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
⤷ 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 |