SAP ABAP Table PIQCORRHISTORY_DISP (Correspondence History)
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 PIQCORRHISTORY_DISP   Table Relationship Diagram
Short Description Correspondence History    
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 .INCLU-_H       0   0   Correspondence - Correspondence Header  
2 MANDT_H MANDT MANDT CLNT 3   0   Client *
3 COTYP_H COTYP_KK COTYP_KK CHAR 4   0   Correspondence Type TFK070A
4 COKEY_H COKEY_KK COKEY_KK CHAR 36   0   Correspondence key  
5 UNAME_H SYUNAME SYCHAR12 CHAR 12   0   User Name  
6 CDATE_H COCDT_KK SYDATS DATS 8   0   Created On  
7 CTIME_H COCTM_KK SYTIME TIMS 6   0   Time of Creation (to the Second)  
8 GPART_H CREC_GP_KK BU_PARTNER CHAR 10   0   Correspondence Recipient *
9 GPART_GUID_H CREC_GP_GUID_KK SYSUUID_C CHAR 32   0   Correspondence Recipient (GUID)  
10 GPART_ADR_KIND_H CORR_ADR_KIND_KK BU_ADRKIND CHAR 10   0   Address Type Of Correspondence Recipient *
11 ORG_GPART_H CREC_ORG_GP_KK BU_PARTNER CHAR 10   0   Original Correspondence Recipient *
12 ORG_GPART_GUID_H CREC_ORG_GP_GUID_KK SYSUUID_C CHAR 32   0   Original Correspondence Recipient (GUID)  
13 ADD_GPART_H CREC_GP_ADD_KK BU_PARTNER CHAR 10   0   Additional Business Partner for Correspondence Recipient *
14 ADD_GPART_GUID_H CREC_GP_ADD_GUID_KK SYSUUID_C CHAR 32   0   Addit. Business Partner for Correspondence Recipient GUID  
15 ADD_GPART_CAT_H CREC_GP_ADD_CAT_KK CORR_CREC_ADD_CAT_KK CHAR 1   0   Type of Additional Correspondence Recipient  
16 VKONT_H CORR_VKONT_KK CORR_VKONT_KK CHAR 12   0   Contract Account Number  
17 VTREF_H CORR_VTREF_KK CORR_VTREF_KK CHAR 20   0   Reference Specifications from Contract  
18 ADR_VALID_ON_H CREC_AD_VALID_ON_KK TZNTSTMPS DEC 15   0   Address of Correspondence Recipient Valid On  
19 ADRNR_H CREC_AD_KK AD_ADDRNUM CHAR 10   0   Address Number of Correspondence Recipient *
20 ADR_GUID_H CREC_AD_GUID_KK SYSUUID_C CHAR 32   0   Address GUID of Correspondence Recipient  
21 ADRNR_INDEP_COMM_H CREC_AD_INDEP_COMM_KK AD_ADDRNUM CHAR 10   0   Address Number for Address-Independent Communication *
22 AGPART_H CSEN_GP_KK BU_PARTNER CHAR 10   0   Sending Business Partner *
23 AGPART_GUID_H CSEN_GP_GUID_KK SYSUUID_C CHAR 32   0   Sender (GUID)  
24 AGPART_ADR_KIND_H CORR_ADR_KIND_KK BU_ADRKIND CHAR 10   0   Address Type Of Correspondence Recipient *
25 AADRNR_H CSEN_AD_KK AD_ADDRNUM CHAR 10   0   Address Number of Correspondence Sender *
26 AADR_GUID_H CSEN_AD_GUID_KK SYSUUID_C CHAR 32   0   Address GUID of Correspondence Sender  
27 FORMKEY_H FORMKEY FORMKEY CHAR 30   0   Application form *
28 FORMKEY_RDI_H FORMKEY FORMKEY CHAR 30   0   Application form *
29 ENTID1_H ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
30 DATA1_H CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
31 ENTID2_H ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
32 DATA2_H CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
33 ENTID3_H ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
34 DATA3_H CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
35 ENTID4_H ENTID_KK ENTID_KK CHAR 4   0   Correspondence data *
36 DATA4_H CDATA_KK CDATA_KK CHAR 32   0   Correspondence Data Field  
37 CSORT_H CSORT_KK CORR_TXT50 CHAR 50   0   Correspondence Sort Field  
38 XCODT_H XCODT_KK XFELD CHAR 1   0   Data Part Is Used  
39 XCODT_CLUST_H XCODT_CLUST_KK XFELD CHAR 1   0   Cluster Data Part is Used  
40 LAUFD_H CORR_LAUFD_KK DATUM DATS 8   0   Date ID for Creation Run  
41 LAUFI_H CORR_LAUFI_KK CORR_LAUFI_KK CHAR 6   0   Additional ID Characteristic for Creation Run  
42 XTEST_H XTEST_KK XFELD CHAR 1   0   Correspondence is Result of Test  
43 COPRI_H COPRI_KK SYDATS DATS 8   0   Print Date  
44 COIDT_H COIDT_KK SYDATS DATS 8   0   Date of Issue  
45 COITM_H COITM_KK SYTIME TIMS 6   0   Issue Time to the Second  
46 SPRAS_H SPRAS SPRAS LANG 1   0   Language Key *
47 SALWA_H CORR_BLWAE_KK WAERS CUKY 5   0   Transaction Currency *
48 SALBE_H CORR_BETRH_KK WRTV7 CURR 13   2   Amount in Local Currency with +/- Signs  
49 SENDCONTROL_H SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control ESENDCONTROL
50 PERSNUMBER_H AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
51 APERSNUMBER_H AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
52 BUKRS_H CORR_BUKRS CORR_BUKRS CHAR 4   0   Company Code in Correspondence  
53 CORR_ROLE_H CORR_ROLE_KK CORR_ROLE_KK CHAR 4   0   Correspondence Roles TFK070M
54 COPRI_LAUFD_H COPRI_LAUFD_KK DATUM DATS 8   0   Date ID for Print Run  
55 COPRI_LAUFI_H COPRI_LAUFID_KK COPRI_LAUFID_KK CHAR 6   0   ID Characteristic for Run  
56 PROCESS_ID__H CORR_PROCESS_ID_KK   CHAR 36   0   Business Process ID  
57 NO_DOCPARTS_H CORR_NO_DOCPARTS_KK   NUMC 4   0   Number of Document Parts  
58 DOCPART_ROLE_H CORR_DOCPART_ROLE_KK CORR_DOCPART_ROLE_KK CHAR 1   0   Document Part Role  
59 XTRIAL_H XTRIAL_KK XFELD CHAR 1   0   Correspondence Request is Test  
60 XREPRINT_H XREPRINT_KK XFELD CHAR 1   0   Recreate Correspondence  
61 .INCLUDE       0   0    
62 SUBAP_H CORR_SUBAP_KK CORR_SUBAP_KK CHAR 1   0   Subapplication Indicator in Correspondence  
63 XDELETE_H X_CORR_DELETE_KK XFELD CHAR 1   0   Correspondence Is Logically Deleted  
64 PRINT_MODE_H PRINT_MODE_KK BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
65 X_NO_ARC_H X_NO_ARC_KK XFELD CHAR 1   0   SAP ArchiveLink Object ID Part Is Not Used  
66 X_DOCPART_LIST_H X_DOCPART_LIST_KK XFELD CHAR 1   0   Document Part List Is Used  
67 .INCLU--AP       0   0   CMS appends for DFKKCOH  
68 .INCLU-CMS       0   0   CMS include for DFKKCOH  
69 OBJECT_IDCMS_H CMS_DTE_OBJECT_ID SYSUUID RAW 16   0   Object Identification Number  
70 FLG_ORIGINALCMS_H CMS_DTE_FLG_ORIG CMS_FLG CHAR 1   0   Flag to indicate if the document is original or duplicate  
71 SENDCONTROLCMS_H SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control *
72 .INCLU--AP       0   0   Loans Append for DFKKCOH  
73 .INCLU-FVD       0   0   Loans Include for DFKKCOH  
74 PRODUCTTYPEFVD_H VVSART VVSART CHAR 3   0   Product Type *
75 BP_ROLEFVD_H BU_PARTNERROLE BU_ROLE CHAR 6   0   BP Role *
76 BP_ROLETYPEFVD_H BP_ROLE BP_ROLE CHAR 4   0   Business Partner Role Type *
77 SOBJECTFVD_H VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
78 CORR_ACTIVITYFVD_H KORRVORF KORRVORF NUMC 4   0   Correspondence activity *
79 REFERENCEDATEFVD_H TB_CORR_REFERENCE_DATE DATUM DATS 8   0   Reference Date for Creating Correspondence  
80 .INCLU-_HI       0   0   Correspondence - Correspondence History  
81 MANDT_HI MANDT MANDT CLNT 3   0   Client *
82 COTYP_HI COTYP_KK COTYP_KK CHAR 4   0   Correspondence Type TFK070A
83 GPART_HI CREC_GP_KK BU_PARTNER CHAR 10   0   Correspondence Recipient *
84 VKONT_HI CORR_VKONT_KK CORR_VKONT_KK CHAR 12   0   Contract Account Number  
85 COKEY_HI COKEY_KK COKEY_KK CHAR 36   0   Correspondence key  
86 GPART_GUID_HI CREC_GP_GUID_KK SYSUUID_C CHAR 32   0   Correspondence Recipient (GUID)  
87 ORG_GPART_HI CREC_ORG_GP_KK BU_PARTNER CHAR 10   0   Original Correspondence Recipient *
88 ORG_GPART_GUID_HI CREC_ORG_GP_GUID_KK SYSUUID_C CHAR 32   0   Original Correspondence Recipient (GUID)  
89 VTREF_HI CORR_VTREF_KK CORR_VTREF_KK CHAR 20   0   Reference Specifications from Contract  
90 CDATE_HI COCDT_KK SYDATS DATS 8   0   Created On  
91 COIDT_HI COIDT_KK SYDATS DATS 8   0   Date of Issue  
92 COITM_HI COITM_KK SYTIME TIMS 6   0   Issue Time to the Second  
93 COISSTSTMP_HI COCRETSTMP_KK TZNTSTMPS DEC 15   0   Time Stamp for Time Created  
94 COISSTSTMPNEW_HI COISSTSTMP_KK TZNTSTMPS DEC 15   0   Issue Timestamp  
95 COISSUSER_HI COISSUSER_KK SYCHAR12 CHAR 12   0   Issue, Logon Name of User  
96 COPRI_HI COPRI_KK SYDATS DATS 8   0   Print Date  
97 COPRITSTMP_HI COPRITSTMP_KK TZNTSTMPS DEC 15   0   Print Timestamp  
98 COPRIUSER_HI COPRIUSER_KK SYCHAR12 CHAR 12   0   Print, Logon Name of User  
99 COCYR_HI COCYR_KK GJAHR NUMC 4   0   Year of Correspondence Creation  
100 COPER_HI COPER_KK COPER_KK CHAR 1   0   Correspondence Interval  
101 COPNR_HI COPNR_KK COPNR_KK NUMC 2   0   Period number  
102 COEMP_HI COEMP_KK XFELD CHAR 1   0   Blank Correspondence  
103 SALWA_HI CORR_WAERS_KK WAERS CUKY 5   0   Currency Key TCURC
104 SALBE_HI CORR_BETRH_KK WRTV7 CURR 13   2   Amount in Local Currency with +/- Signs  
105 UMBUCH_HI CORR_UMBUCH_KK XFELD CHAR 1   0   Transfer Posting Carried Out  
106 BUKRS_HI CORR_BUKRS CORR_BUKRS CHAR 4   0   Company Code in Correspondence  
107 CORR_STATUS_HI CORR_STATUS_KK CORR_STATUS_KK CHAR 2   0   Correspondence Status TFK070P
108 .INCLUDE       0   0   FI-CA Correspondence - Inbound Correspondence in the History  
109 INCORR_HI INCORR_KK XFELD CHAR 1   0   FI-CA Correspondence: Inbound Correspondence Indicator  
110 INCORR_FAEDN_HI INCORR_FAEDN_KK DATUM DATS 8   0   Inbound Correspondence Due Date  
111 INCORR_INDATE_HI INCORR_INDATE_KK SYDATS DATS 8   0   Date Inbound Correspondence Received  
112 COPRI_LAUFD_HI COPRI_LAUFD_KK DATUM DATS 8   0   Date ID for Print Run  
113 COPRI_LAUFI_HI COPRI_LAUFID_KK COPRI_LAUFID_KK CHAR 6   0   ID Characteristic for Run  
114 .INCLUDE       0   0    
115 SUBAP_HI CORR_SUBAP_KK CORR_SUBAP_KK CHAR 1   0   Subapplication Indicator in Correspondence  
116 XTRIAL_HI XTRIAL_KK XFELD CHAR 1   0   Correspondence Request is Test  
117 TECH_STATUS_HI CORR_TECH_STATUS_KK CORR_TECH_STATUS_KK CHAR 2   0   Technical Correspondence Status  
118 FORMKEY_HI FORMKEY FORMKEY CHAR 30   0   Application form *
119 FORMKEY_RDI_HI FORMKEY_RDI FORMKEY CHAR 30   0   Alternative RDI Form *
120 SENDCONTROL_HI SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control *
121 .INCLUDE       0   0   Data Fields for Archiving  
122 ARCHIVE_STATUS_HI TYP_ARCHIVE_STATUS TYP_ARCHIVE_STATUS CHAR 1   0   Archiving Status  
123 ARCHIVE_FLUD_HI TYP_ARCHIVE_FLUD DATS DATS 8   0   Resubmission Date  
124 REJECTION_HI TYP_REJECTION   CHAR 2   0   Rejection Reason  
125 .INCLU--AP       0   0   CMS append for DFKKCOHI  
126 .INCLU-CMS       0   0   CMS include for DFKKCOH  
127 OBJECT_IDCMS_HI CMS_DTE_OBJECT_ID SYSUUID RAW 16   0   Object Identification Number  
128 FLG_ORIGINALCMS_HI CMS_DTE_FLG_ORIG CMS_FLG CHAR 1   0   Flag to indicate if the document is original or duplicate  
129 SENDCONTROLCMS_HI SENDCONTROL ESENDCONTROL CHAR 4   0   Dispatch Control *
130 .INCLUDE       0   0   BAPI Structure for Student: Personal Data (Text Fields)  
131 FORM_OF_ADDRESS_KEY ANRDE ANRDE CHAR 1   0   Form-of-Address Key T522G
132 FORM_OF_ADDRESS_KEY_TXT ANRLT TEXT15 CHAR 15   0   Long Text: Form of Address  
133 INITIALS INITS TEXT10 CHAR 10   0   Initials  
134 FIRST_NAME PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
135 LAST_NAME PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
136 MIDDLE_NAME PAD_MIDNM PAD_VORNM CHAR 40   0   Middle Name  
137 TITEL TITEL TITEL CHAR 15   0   Title T535N
138 TITEL_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
139 NAME_AFFIX VORSW TITEL CHAR 15   0   Name Prefix T535N
140 NAME_AFFIX_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
141 ARISTOCRATIC_TITLE NAMZU TITEL CHAR 15   0   Other Title T535N
142 ARISTOCRATIC_TITLE_TXT TTOUT TEXT15 CHAR 15   0   Output text for name affix  
143 NICKNAME PIQ_RUFNM PAD_VORNM CHAR 40   0   Known As  
144 NAME_AT_BIRTH PAD_NAME2 PAD_NACHN CHAR 40   0   Name at Birth  
145 DATE_BIRTH PIQ_GBDAT GBDAT DATS 8   0   Date of Birth  
146 BIRTHPLACE PAD_GBORT PAD_ORT01 CHAR 40   0   Birthplace  
147 COUNTRY_OF_BIRTH GBLND LAND1 CHAR 3   0   Country of Birth T005
148 COUNTRY_OF_BIRTH_ISO INTCA INTCA CHAR 2   0   Country ISO code  
149 NAMEOFBIRTHCOUNTRY LANDX TEXT15 CHAR 15   0   Country Name  
150 REGION_OF_BIRTH PIQ_GBDEP REGIO CHAR 3   0   Region of Birth (State, Province, County) T005S
151 NAMEOFBIRTHSTATE BEZEI20 TEXT20 CHAR 20   0   Description  
152 NATIONALITY_AT_BIRTH PIQ_GBNAT LAND1 CHAR 3   0   Nationality (Citizenship) at Birth *
153 NATIONALITY_AT_BIRTH_ISO INTCA INTCA CHAR 2   0   Country ISO code  
154 NATIONALITY_AT_BIRTH_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
155 NATIONALITY PIQNATSL LAND1 CHAR 3   0   Nationality (Citizenship) *
156 NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
157 NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
158 SECOND_NATIONALITY PIQNATS2 LAND1 CHAR 3   0   Second Nationality (Citizenship) *
159 SECOND_NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
160 SECOND_NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
161 THIRD_NATIONALITY PIQNATS3 LAND1 CHAR 3   0   Third Nationality (Citizenship) *
162 THIRD_NATIONALITY_ISO INTCA INTCA CHAR 2   0   Country ISO code  
163 THIRD_NATIONALITY_TXT PIQNATIO TEXT15 CHAR 15   0   Nationality (Citizenship)  
164 GENDER_KEY GESCH GESCH CHAR 1   0   Gender Key  
165 GENDER_KEY_TXT PIQGESCHT   CHAR 15   0   Gender of Student  
166 MARITAL_STATUS FAMST FAMST CHAR 1   0   Marital Status Key T502T
167 MARITAL_STATUS_TXT FATXT FATXT CHAR 6   0   Marital Status  
168 PERSIDNO PIQ_PRDNI CHAR20 CHAR 20   0   Identification Number  
169 CORRESP_LANGUAGE PIQ_SPRAS SPRAS LANG 1   0   Language of Communication T002
170 CORRESP_LANGUAGE_ISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
171 CORRESP_LANGUAGE_TXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
172 DEATH_DATE PIQ_DEATHDATE DATE DATS 8   0   Date of Death  
173 DEATH_REGDATE PIQ_REGDEATHDATE DATE DATS 8   0   Date On Which Death Was Recorded  
174 STUDENT_OBJID PIQSTUDENT HROBJID NUMC 8   0   Object ID of Student *
175 STUDENT12 PIQSTUDENT12 PIQSTUDENT12 CHAR 12   0   Student Number  
176 ADM_QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
177 ACTIVITY PIQPROCESS PIQPROCESS CHAR 4   0   Activity *
178 ACTIVITY_TXT PIQPROCESS2T TEXT40 CHAR 40   0   Activity (Description)  
179 ADM_ISTAT PIQADMSTATE PIQADMSTATE CHAR 1   0   Admission Application Status  
180 ADM_ISTAT_TXT PIQAPPSTATUSTEXT   CHAR 60   0   Application Status (Description)  
181 PROGRAM_OBJID PIQSCOBJID HROBJID NUMC 8   0   Program ID *
182 PROGRAM_SHORT PIQSCSHORT TEXT12 CHAR 12   0   Program (Abbreviation)  
183 PROGRAM_STEXT PIQSCTXT TEXT40 CHAR 40   0   Program Description  
184 COTXT COTXT_KK TEXT40 CHAR 40   0   Name of Correspondence Type  
185 FORMCLASS FORMCLASS FORMCLASS CHAR 30   0   Form Class *
186 FORMCLASS_TXT DESCR_FCL TEXT60 CHAR 60   0   Short Description of Form Class  
187 FORMKEY_TXT DESCR_FORM TEXT50 CHAR 50   0   Text for application form  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQCORRHISTORY_DISP ARISTOCRATIC_TITLE T535N TITEL REF 1 CN
2 PIQCORRHISTORY_DISP CORRESP_LANGUAGE T002 SPRAS REF 1 CN
3 PIQCORRHISTORY_DISP CORR_ROLE_H TFK070M CORR_ROLE    
4 PIQCORRHISTORY_DISP CORR_STATUS_HI TFK070P CORR_STATUS    
5 PIQCORRHISTORY_DISP COTYP_H TFK070A COTYP    
6 PIQCORRHISTORY_DISP COTYP_HI TFK070A COTYP    
7 PIQCORRHISTORY_DISP COUNTRY_OF_BIRTH T005 LAND1 REF 1 CN
8 PIQCORRHISTORY_DISP FORM_OF_ADDRESS_KEY T522G ANRED REF 1 CN
9 PIQCORRHISTORY_DISP MARITAL_STATUS T502T FAMST REF 1 CN
10 PIQCORRHISTORY_DISP NAME_AFFIX T535N TITEL REF 1 CN
11 PIQCORRHISTORY_DISP REGION_OF_BIRTH T005S BLAND REF 1 CN
12 PIQCORRHISTORY_DISP SALWA_HI TCURC WAERS REF 1 CN
13 PIQCORRHISTORY_DISP SENDCONTROL_H ESENDCONTROL SENDCONTROL    
14 PIQCORRHISTORY_DISP TITEL T535N TITEL REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 472