SAP ABAP Table PIQ_CORR_ADM_HISTORY (OBSOLETE)
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_CORR_ADM_HISTORY   Table Relationship Diagram
Short Description OBSOLETE    
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 MANDT MANDT MANDT CLNT 3   0   Client *
2 COTYP COTYP_KK COTYP_KK CHAR 4   0   Correspondence Type *
3 COKEY COKEY_KK COKEY_KK CHAR 36   0   Correspondence key  
4 UNAME SYUNAME SYCHAR12 CHAR 12   0   User Name  
5 CDATE SYDATUM SYDATS DATS 8   0   System Date  
6 CTIME SYTIME SYTIME TIMS 6   0   TIME Data Element for SYST  
7 GPART CREC_GP_KK BU_PARTNER CHAR 10   0   Correspondence Recipient *
8 ORG_GPART CREC_ORG_GP_KK BU_PARTNER CHAR 10   0   Original Correspondence Recipient *
9 VKONT CORR_VKONT_KK CORR_VKONT_KK CHAR 12   0   Contract Account Number  
10 VTREF CORR_VTREF_KK CORR_VTREF_KK CHAR 20   0   Reference Specifications from Contract  
11 ADRNR CREC_AD_KK AD_ADDRNUM CHAR 10   0   Address Number of Correspondence Recipient *
12 AGPART CSEN_GP_KK BU_PARTNER CHAR 10   0   Sending Business Partner *
13 AADRNR CSEN_AD_KK AD_ADDRNUM CHAR 10   0   Address Number of Correspondence Sender *
14 FORMKEY FORMKEY FORMKEY CHAR 30   0   Application form *
15 FORMKEY_RDI FORMKEY FORMKEY CHAR 30   0   Application form *
16 ENTID1 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
17 DATA1 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
18 ENTID2 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
19 DATA2 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
20 ENTID3 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
21 DATA3 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
22 ENTID4 ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
23 DATA4 CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
24 CSORT CSORT_KK CORR_TXT50 CHAR 50   0   Correspondence Sort Field  
25 XCODT XCODT_KK XFELD CHAR 1   0   Data Part Is Used  
26 XCODT_CLUST XCODT_CLUST_KK XFELD CHAR 1   0   Cluster Data Part is Used  
27 LAUFD CORR_LAUFD_KK DATUM DATS 8   0   Date ID for Creation Run  
28 LAUFI CORR_LAUFI_KK CORR_LAUFI_KK CHAR 6   0   Additional ID Characteristic for Creation Run  
29 XTEST XTEST_KK XFELD CHAR 1   0   Correspondence is Result of Test  
30 COPRI COPRI_KK SYDATS DATS 8   0   Print Date  
31 COIDT COIDT_KK SYDATS DATS 8   0   Date of Issue  
32 COITM COITM_KK SYTIME TIMS 6   0   Issue Time to the Second  
33 SPRAS SPRAS SPRAS LANG 1   0   Language Key *
34 SALWA CORR_BLWAE_KK WAERS CUKY 5   0   Transaction Currency *
35 SALBE CORR_BETRH_KK WRTV7 CURR 13   2   Amount in Local Currency with +/- Signs  
36 SENDCONTROL SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control *
37 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
38 BUKRS CORR_BUKRS CORR_BUKRS CHAR 4   0   Company Code in Correspondence  
39 CORR_ROLE CORR_ROLE_KK CORR_ROLE_KK CHAR 4   0   Correspondence Roles *
40 COCYR COCYR_KK GJAHR NUMC 4   0   Year of Correspondence Creation  
41 COPER COPER_KK COPER_KK CHAR 1   0   Correspondence Interval  
42 COPNR COPNR_KK COPNR_KK NUMC 2   0   Period number  
43 COEMP COEMP_KK XFELD CHAR 1   0   Blank Correspondence  
44 UMBUCH CORR_UMBUCH_KK XFELD CHAR 1   0   Transfer Posting Carried Out  
45 ST_OBJID PIQSTUDENT HROBJID NUMC 8   0   Object ID of Student *
46 STUDENT12 PIQSTUDENT12 PIQSTUDENT12 CHAR 12   0   Student Number  
47 .INCLUDE       0   0   BAPI Structure for Student: Personal Data (Text Fields)  
48 FORM_OF_ADDRESS_KEY ANRDE ANRDE CHAR 1   0   Form-of-Address Key T522G
49 FORM_OF_ADDRESS_KEY_TXT ANRLT TEXT15 CHAR 15   0   Long Text: Form of Address  
50 INITIALS INITS TEXT10 CHAR 10   0   Initials  
51 FIRST_NAME PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
52 LAST_NAME PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
53 MIDDLE_NAME PAD_MIDNM PAD_VORNM CHAR 40   0   Middle Name  
54 TITEL TITEL TITEL CHAR 15   0   Title T535N
55 TITEL_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
56 NAME_AFFIX VORSW TITEL CHAR 15   0   Name Prefix T535N
57 NAME_AFFIX_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
58 ARISTOCRATIC_TITLE NAMZU TITEL CHAR 15   0   Other Title T535N
59 ARISTOCRATIC_TITLE_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
60 NICKNAME PIQ_RUFNM PAD_VORNM CHAR 40   0   Known As  
61 NAME_AT_BIRTH PAD_NAME2 PAD_NACHN CHAR 40   0   Name at Birth  
62 DATE_BIRTH PIQ_GBDAT GBDAT DATS 8   0   Date of Birth  
63 BIRTHPLACE PAD_GBORT PAD_ORT01 CHAR 40   0   Birthplace  
64 COUNTRY_OF_BIRTH GBLND LAND1 CHAR 3   0   Country of Birth T005
65 COUNTRY_OF_BIRTH_ISO INTCA INTCA CHAR 2   0   Country ISO code  
66 NAMEOFBIRTHCOUNTRY LANDX TEXT15 CHAR 15   0   Country Name  
67 REGION_OF_BIRTH PIQ_GBDEP REGIO CHAR 3   0   Region of Birth (State, Province, County) T005S
68 NAMEOFBIRTHSTATE BEZEI20 TEXT20 CHAR 20   0   Description  
69 NATIONALITY_AT_BIRTH PIQ_GBNAT LAND1 CHAR 3   0   Nationality (Citizenship) at Birth *
70 NATIONALITY_AT_BIRTH_ISO INTCA INTCA CHAR 2   0   Country ISO code  
71 NATIONALITY_AT_BIRTH_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
72 NATIONALITY PIQNATSL LAND1 CHAR 3   0   Nationality (Citizenship) *
73 NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
74 NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
75 SECOND_NATIONALITY PIQNATS2 LAND1 CHAR 3   0   Second Nationality (Citizenship) *
76 SECOND_NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
77 SECOND_NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
78 THIRD_NATIONALITY PIQNATS3 LAND1 CHAR 3   0   Third Nationality (Citizenship) *
79 THIRD_NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
80 THIRD_NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
81 GENDER_KEY GESCH GESCH CHAR 1   0   Gender Key  
82 GENDER_KEY_TXT PIQGESCHT   CHAR 15   0   Gender of Student  
83 MARITAL_STATUS FAMST FAMST CHAR 1   0   Marital Status Key T502T
84 MARITAL_STATUS_TXT FATXT FATXT CHAR 6   0   Marital Status  
85 PERSIDNO PIQ_PRDNI CHAR20 CHAR 20   0   Identification Number  
86 CORRESP_LANGUAGE PIQ_SPRAS SPRAS LANG 1   0   Language of Communication T002
87 CORRESP_LANGUAGE_ISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
88 CORRESP_LANGUAGE_TXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
89 DEATH_DATE PIQ_DEATHDATE DATE DATS 8   0   Date of Death  
90 DEATH_REGDATE PIQ_REGDEATHDATE DATE DATS 8   0   Date On Which Death Was Recorded  
91 ADM_QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
92 PROCESS PIQPROCESS PIQPROCESS CHAR 4   0   Activity *
93 PROCESST PIQPROCESS2T TEXT40 CHAR 40   0   Activity (Description)  
94 ISTAT PIQADMSTATE PIQADMSTATE CHAR 1   0   Admission Application Status  
95 ISTAT_T PIQAPPSTATUSTEXT   CHAR 60   0   Application Status (Description)  
96 SC_OBJID PIQSCOBJID HROBJID NUMC 8   0   Program ID *
97 SC_SHT PIQSCSHORT TEXT12 CHAR 12   0   Program (Abbreviation)  
98 SC_T PIQSCTXT TEXT40 CHAR 40   0   Program Description  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQ_CORR_ADM_HISTORY ARISTOCRATIC_TITLE T535N TITEL REF 1 CN
2 PIQ_CORR_ADM_HISTORY CORRESP_LANGUAGE T002 SPRAS REF 1 CN
3 PIQ_CORR_ADM_HISTORY COUNTRY_OF_BIRTH T005 LAND1 REF 1 CN
4 PIQ_CORR_ADM_HISTORY FORM_OF_ADDRESS_KEY T522G ANRED REF 1 CN
5 PIQ_CORR_ADM_HISTORY MARITAL_STATUS T502T FAMST REF 1 CN
6 PIQ_CORR_ADM_HISTORY NAME_AFFIX T535N TITEL REF 1 CN
7 PIQ_CORR_ADM_HISTORY REGION_OF_BIRTH T005S BLAND REF 1 CN
8 PIQ_CORR_ADM_HISTORY TITEL T535N TITEL REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 471