SAP ABAP Table PIQ_COOKBOOK_REP_ALV_GRID (TEST: REPORTING)
Hierarchy
☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management
Basic Data
Table Category INTTAB    Structure 
Structure PIQ_COOKBOOK_REP_ALV_GRID   Table Relationship Diagram
Short Description TEST: REPORTING    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 STUDENTNUMBER PIQSTUDENT12 PIQSTUDENT12 CHAR 12   0   Student Number  
2 .INCLUDE       0   0   BAPI Structure for Student: Personal Data (Text Fields)  
3 FORM_OF_ADDRESS_KEY ANRDE ANRDE CHAR 1   0   Form-of-Address Key T522G
4 FORM_OF_ADDRESS_KEY_TXT ANRLT TEXT15 CHAR 15   0   Long Text: Form of Address  
5 INITIALS INITS TEXT10 CHAR 10   0   Initials  
6 FIRST_NAME PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
7 LAST_NAME PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
8 MIDDLE_NAME PAD_MIDNM PAD_VORNM CHAR 40   0   Middle Name  
9 TITEL TITEL TITEL CHAR 15   0   Title T535N
10 TITEL_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
11 NAME_AFFIX VORSW TITEL CHAR 15   0   Name Prefix T535N
12 NAME_AFFIX_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
13 ARISTOCRATIC_TITLE NAMZU TITEL CHAR 15   0   Other Title T535N
14 ARISTOCRATIC_TITLE_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
15 NICKNAME PIQ_RUFNM PAD_VORNM CHAR 40   0   Known As  
16 NAME_AT_BIRTH PAD_NAME2 PAD_NACHN CHAR 40   0   Name at Birth  
17 DATE_BIRTH PIQ_GBDAT GBDAT DATS 8   0   Date of Birth  
18 BIRTHPLACE PAD_GBORT PAD_ORT01 CHAR 40   0   Birthplace  
19 COUNTRY_OF_BIRTH GBLND LAND1 CHAR 3   0   Country of Birth T005
20 COUNTRY_OF_BIRTH_ISO INTCA INTCA CHAR 2   0   Country ISO code  
21 NAMEOFBIRTHCOUNTRY LANDX TEXT15 CHAR 15   0   Country Name  
22 REGION_OF_BIRTH PIQ_GBDEP REGIO CHAR 3   0   Region of Birth (State, Province, County) T005S
23 NAMEOFBIRTHSTATE BEZEI20 TEXT20 CHAR 20   0   Description  
24 NATIONALITY_AT_BIRTH PIQ_GBNAT LAND1 CHAR 3   0   Nationality (Citizenship) at Birth *
25 NATIONALITY_AT_BIRTH_ISO INTCA INTCA CHAR 2   0   Country ISO code  
26 NATIONALITY_AT_BIRTH_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
27 NATIONALITY PIQNATSL LAND1 CHAR 3   0   Nationality (Citizenship) *
28 NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
29 NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
30 SECOND_NATIONALITY PIQNATS2 LAND1 CHAR 3   0   Second Nationality (Citizenship) *
31 SECOND_NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
32 SECOND_NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
33 THIRD_NATIONALITY PIQNATS3 LAND1 CHAR 3   0   Third Nationality (Citizenship) *
34 THIRD_NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
35 THIRD_NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
36 GENDER_KEY GESCH GESCH CHAR 1   0   Gender Key  
37 GENDER_KEY_TXT PIQGESCHT   CHAR 15   0   Gender of Student  
38 MARITAL_STATUS FAMST FAMST CHAR 1   0   Marital Status Key T502T
39 MARITAL_STATUS_TXT FATXT FATXT CHAR 6   0   Marital Status  
40 PERSIDNO PIQ_PRDNI CHAR20 CHAR 20   0   Identification Number  
41 CORRESP_LANGUAGE PIQ_SPRAS SPRAS LANG 1   0   Language of Communication T002
42 CORRESP_LANGUAGE_ISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
43 CORRESP_LANGUAGE_TXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
44 DEATH_DATE PIQ_DEATHDATE DATE DATS 8   0   Date of Death  
45 DEATH_REGDATE PIQ_REGDEATHDATE DATE DATS 8   0   Date On Which Death Was Recorded  
46 .INCLUDE       0   0   BAPI Structure for Student: Addit'l Pers. Data (Text Fields)  
47 RELIGION PIQKONFE KONFE CHAR 2   0   Religious Denomination Key T516T
48 RELIGION_TXT KNFTX TEXT25 CHAR 25   0   Religious Denomination Long Text  
49 ETHNIC_GRP PIQETHNIC PIQETHNIC CHAR 4   0   Ethnic Origin T7PIQETHNIC
50 ETHNIC_GRP_TXT PIQETHNICT TEXT40 CHAR 40   0   Ethnic Origin (Description)  
51 JOB PIQTAETE TAESL NUMC 8   0   Student's Job T513C
52 JOB_TXT TEXT25 TEXT25 CHAR 25   0   Text length 25  
53 SOCIAL_GRP PIQSOCIAL PIQSOCIAL CHAR 2   0   Social Class T7PIQSOCIAL
54 SOCIAL_GRP_TXT PIQSOCIALT TEXT40 CHAR 40   0   Social Class (Description)  
55 SERVICE_STATUS PIQSERV_STAT MILSA NUMC 2   0   Service Status *
56 SERVICE_STATUS_TXT TEXT25 TEXT25 CHAR 25   0   Text length 25  
57 SERVICE_NUMBER PIQSERV_NR   CHAR 20   0   Service Number  
58 VETERAN_NUMBER PIQVETERAN_NR   CHAR 20   0   Veteran Administration Number  
59 DRIVERS_LICENSE_NO DR_LIC_NO_PS   CHAR 20   0   Driver's License Number  
60 DRIVERS_LICENSE_COUNTRY DR_LIC_LAND1_PS LAND1 CHAR 3   0   Country in Which Driver's License Was Issued T005
61 DRIVERS_LICENSE_COUNTRY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
62 NAMEOFLICENCECOUNTRY LANDX TEXT15 CHAR 15   0   Country Name  
63 DRIVERS_LICENSE_REGION DR_LIC_REGIO_PS REGIO CHAR 3   0   Region in Which Driver's License Was Issued T005S
64 NAMEOFLICENSESTATE BEZEI20 TEXT20 CHAR 20   0   Description  
65 .INCLUDE       0   0   BAPI Structure for Student: Challenge Data (Text Fields)  
66 CHALL_GRP PIQCHGRP PIQCHGRP CHAR 2   0   Challenge Group (Student) T7PIQCHGRP
67 CHALL_GRP_TXT PIQCHGRPT TEXT40 CHAR 40   0   Challenge Group (Description)  
68 CHALL_PERC PIQCHALLPERC DEC3_2 DEC 5   2   Degree of Challenge  
69 CHALL_TYPE PIQCHTYP PIQCHTYP CHAR 2   0   Challenge Type T7PIQCHTYP
70 CHALL_TYPE_TXT PIQCHTYPT TEXT40 CHAR 40   0   Challenge Type (Description)  
71 DATE_CHALL_CERT PIQSBAUD DATUM DATS 8   0   Expiry Date of ID for Challenged Persons  
72 .INCLUDE       0   0   BAPI Structure for Student: Residence (Text Fields)  
73 RESIDENCY_STATUS PIQRESIDSTATUS RESIS CHAR 1   0   Resident Status *
74 RESIDENCY_STATUS_TXT RESTX TEXT25 CHAR 25   0   Residence status texts  
75 RESIDENCY_COUNTRY PIQRESIDCOUNTRY LAND1 CHAR 3   0   Resident Country T005
76 RESIDENCY_COUNTRY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
77 NAMEOFRESIDENCYCOUNTRY LANDX TEXT15 CHAR 15   0   Country Name  
78 RESIDENCY_REGION PIQRESIDREGIO REGIO CHAR 3   0   Resident State T005S
79 NAMEOFRESIDENCYSTATE BEZEI20 TEXT20 CHAR 20   0   Description  
80 RESIDENCY_COUNTY PIQRESIDCOUNC COUNC CHAR 3   0   Resident County T005E
81 NAMEOFRESIDENCYCOUNTY BEZEI20 TEXT20 CHAR 20   0   Description  
82 PASSPORT_NUMBER PIQPASSN PIQPASSN CHAR 20   0   Passport Number  
83 ORIGIN PIQORIGIN PIQORIGIN CHAR 4   0   Origin T7PIQORIGIN
84 ORIGIN_TXT PIQORIGINT TEXT40 CHAR 40   0   Origin  
85 .INCLUDE       0   0   BAPI Structure for Student: Study Data (Text Fields)  
86 ALTERNAT_STUDENT_NO PIQMATRIKEL CHAR40 CHAR 40   0   Additional Identification Number  
87 STUDENTGRP PIQSTGRP PIQSTGRP CHAR 4   0   Student Group T7PIQSTGRP
88 STUDENTGRP_TXT PIQSTGRPT TEXT40 CHAR 40   0   Student Group (Description)  
89 REGISTWINDOW PIQREGWINDOW CHAR4 CHAR 4   0   Time Window Used in Module Booking Process  
90 .INCLUDE       0   0   BAPI Structure for Student: Fee Calc. Data (Text Fields)  
91 STUDENT_FEE_CATEG PIQSTFEECAT PIQSTFEECAT CHAR 4   0   Student Fee Category T7PIQSTFEECAT
92 STUDENT_FEE_CATEG_TXT PIQSTFEECATT TEXT30 CHAR 30   0   Student Fee Category (Description)  
93 BENEFIT_CATEG PIQBENCAT PIQBENCAT CHAR 4   0   Benefit Category T7PIQBENCAT
94 BENEFIT_CATEG_TXT PIQBENCATT TEXT30 CHAR 30   0   Benefit Category (Description)  
95 PERS_DISCOUNT1 PIQPDISCT1 PIQPDISCT1 CHAR 4   0   Discount/Surcharge Category 1 T7PIQPDISCT1
96 PERS_DISCOUNT1_TXT PIQPDISCT1T TEXT30 CHAR 30   0   Discount/Surcharge Category 1 (Description)  
97 PERS_DISCOUNT2 PIQPDISCT2 PIQPDISCT2 CHAR 4   0   Discount/Surcharge Category 2 T7PIQPDISCT2
98 PERS_DISCOUNT2_TXT PIQPDISCT2T TEXT30 CHAR 30   0   Discount/Surcharge Category 2 (Description)  
99 PERS_DISCOUNT3 PIQPDISCT3 PIQPDISCT3 CHAR 4   0   Discount/Surcharge Category 3 T7PIQPDISCT3
100 PERS_DISCOUNT3_TXT PIQPDISCT3T TEXT30 CHAR 30   0   Discount/Surcharge Category 3 (Description)  
101 PERS_DISCOUNT4 PIQPDISCT4 PIQPDISCT4 CHAR 4   0   Discount/Surcharge Category 4 T7PIQPDISCT4
102 PERS_DISCOUNT4_TXT PIQPDISCT4T TEXT30 CHAR 30   0   Discount/Surcharge Category 4 (Description)  
103 PERS_DISCOUNT5 PIQPDISCT5 PIQPDISCT5 CHAR 4   0   Discount/Surcharge Category 5 T7PIQPDISCT5
104 PERS_DISCOUNT5_TXT PIQPDISCT5T TEXT30 CHAR 30   0   Discount/Surcharge Category 5 (Description)  
105 PERS_DISCOUNT6 PIQPDISCT6 PIQPDISCT6 CHAR 4   0   Discount/Surcharge Category 6 T7PIQPDISCT6
106 PERS_DISCOUNT6_TXT PIQPDISCT6T TEXT30 CHAR 30   0   Discount/Surcharge Category 6 (Description)  
107 .INCLUDE       0   0   BAPI Structure for Student: Org. Unit (Text Fields)  
108 ASSIGNED_ORGUNIT PIQSTORGUNIT_ASSIGNED HROBJID NUMC 8   0   Assigned Organizational Unit of Student *
109 ASSIGNED_ORGUNIT_TXT PIQSTORGTX TEXT40 CHAR 40   0   Name of the Student's Organizational Unit  
110 ASSIGNED_ORGUNIT_SHT PIQSTORGSHT TEXT12 CHAR 12   0   Organizational Unit of Student (Abbreviation)  
111 .INCLUDE       0   0   BAPI Structure for Student: Campus (Text Fields)  
112 CAMPUS PIQCAMPUS HROBJID NUMC 8   0   Campus *
113 CAMPUS_TXT PIQCAMPUSTXT TEXT40 CHAR 40   0   Campus Name  
114 CAMPUS_SHT PIQCAMPUSSHT TEXT12 CHAR 12   0   Campus Abbreviation  
115 .INCLUDE       0   0   BAPI Structure for Student: Status Attributes (Text Fields)  
116 CONFIDENTIALITY PIQCONFID PIQCONFID CHAR 2   0   Data Privacy Level *
117 CONFIDENTIALITY_TXT PIQCONFIDT TEXT40 CHAR 40   0   Data Privacy Level (Description)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQ_COOKBOOK_REP_ALV_GRID ARISTOCRATIC_TITLE T535N TITEL REF 1 CN
2 PIQ_COOKBOOK_REP_ALV_GRID BENEFIT_CATEG T7PIQBENCAT BENCAT REF 1 CN
3 PIQ_COOKBOOK_REP_ALV_GRID CHALL_GRP T7PIQCHGRP CHGRP REF 1 CN
4 PIQ_COOKBOOK_REP_ALV_GRID CHALL_TYPE T7PIQCHTYP CHTYP REF 1 CN
5 PIQ_COOKBOOK_REP_ALV_GRID CORRESP_LANGUAGE T002 SPRAS REF 1 CN
6 PIQ_COOKBOOK_REP_ALV_GRID COUNTRY_OF_BIRTH T005 LAND1 REF 1 CN
7 PIQ_COOKBOOK_REP_ALV_GRID DRIVERS_LICENSE_COUNTRY T005 LAND1 REF 1 CN
8 PIQ_COOKBOOK_REP_ALV_GRID DRIVERS_LICENSE_REGION T005S BLAND REF 1 CN
9 PIQ_COOKBOOK_REP_ALV_GRID ETHNIC_GRP T7PIQETHNIC ETHNIC    
10 PIQ_COOKBOOK_REP_ALV_GRID FORM_OF_ADDRESS_KEY T522G ANRED REF 1 CN
11 PIQ_COOKBOOK_REP_ALV_GRID JOB T513C TAETE    
12 PIQ_COOKBOOK_REP_ALV_GRID MARITAL_STATUS T502T FAMST REF 1 CN
13 PIQ_COOKBOOK_REP_ALV_GRID NAME_AFFIX T535N TITEL REF 1 CN
14 PIQ_COOKBOOK_REP_ALV_GRID ORIGIN T7PIQORIGIN ORIGIN REF 1 CN
15 PIQ_COOKBOOK_REP_ALV_GRID PERS_DISCOUNT1 T7PIQPDISCT1 PDISCT1 REF 1 CN
16 PIQ_COOKBOOK_REP_ALV_GRID PERS_DISCOUNT2 T7PIQPDISCT2 PDISCT2 REF 1 CN
17 PIQ_COOKBOOK_REP_ALV_GRID PERS_DISCOUNT3 T7PIQPDISCT3 PDISCT3 REF 1 CN
18 PIQ_COOKBOOK_REP_ALV_GRID PERS_DISCOUNT4 T7PIQPDISCT4 PDISCT4 KEY 1 CN
19 PIQ_COOKBOOK_REP_ALV_GRID PERS_DISCOUNT5 T7PIQPDISCT5 PDISCT5 REF 1 CN
20 PIQ_COOKBOOK_REP_ALV_GRID PERS_DISCOUNT6 T7PIQPDISCT6 PDISCT6 REF 1 CN
21 PIQ_COOKBOOK_REP_ALV_GRID REGION_OF_BIRTH T005S BLAND REF 1 CN
22 PIQ_COOKBOOK_REP_ALV_GRID RELIGION T516T KONFE    
23 PIQ_COOKBOOK_REP_ALV_GRID RESIDENCY_COUNTRY T005 LAND1 REF 1 CN
24 PIQ_COOKBOOK_REP_ALV_GRID RESIDENCY_COUNTY T005E COUNC REF 1 CN
25 PIQ_COOKBOOK_REP_ALV_GRID RESIDENCY_REGION T005S BLAND REF 1 CN
26 PIQ_COOKBOOK_REP_ALV_GRID SOCIAL_GRP T7PIQSOCIAL SOCIAL 1 CN
27 PIQ_COOKBOOK_REP_ALV_GRID STUDENTGRP T7PIQSTGRP STGRP 1 CN
28 PIQ_COOKBOOK_REP_ALV_GRID STUDENT_FEE_CATEG T7PIQSTFEECAT STFEECAT REF 1 CN
29 PIQ_COOKBOOK_REP_ALV_GRID TITEL T535N TITEL REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in