SAP ABAP Table PIQBPEI_IT1702 (Structure for IT1702 for TB058 (in Report BUPTDTRANSMIT))
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQBP_D (Package) Campus Management: SAP Business Partner Enhancements
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQBP_D (Package) Campus Management: SAP Business Partner Enhancements
Basic Data
Table Category | INTTAB | Structure |
Structure | PIQBPEI_IT1702 | Table Relationship Diagram |
Short Description | Structure for IT1702 for TB058 (in Report BUPTDTRANSMIT) |
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 | .INCLUDE | 0 | 0 | DB Table for Infotype 1702 | |||||
2 | .INCLUDE | 0 | 0 | Extended Key Definition of PD Infotypes | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
5 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
6 | OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | PLOGI | |
7 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * | |
8 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
9 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
10 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
11 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
12 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
13 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
14 | OTJID | OTJID | CHAR10 | CHAR | 10 | 0 | Concatenation of Object Type and Object ID | ||
15 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
16 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
17 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
18 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
19 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
20 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
21 | .INCLUDE | 0 | 0 | Personal Data | |||||
22 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
23 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
24 | MIDNM | PAD_MIDNM | PAD_VORNM | CHAR | 40 | 0 | Middle Name | ||
25 | INITS | INITS | TEXT10 | CHAR | 10 | 0 | Initials | ||
26 | BIRTHNAME | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
27 | TITEL | TITEL | TITEL | CHAR | 15 | 0 | Title | T535N | |
28 | VORSW | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | T535N | |
29 | NAMZU | NAMZU | TITEL | CHAR | 15 | 0 | Other Title | T535N | |
30 | RUFNM | PIQ_RUFNM | PAD_VORNM | CHAR | 40 | 0 | Known As | ||
31 | GBDAT | PIQ_GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
32 | GBLND | GBLND | LAND1 | CHAR | 3 | 0 | Country of Birth | T005 | |
33 | GBDEP | PIQ_GBDEP | REGIO | CHAR | 3 | 0 | Region of Birth (State, Province, County) | T005S | |
34 | GBORT | PAD_GBORT | PAD_ORT01 | CHAR | 40 | 0 | Birthplace | ||
35 | GBNAT | PIQ_GBNAT | LAND1 | CHAR | 3 | 0 | Nationality (Citizenship) at Birth | T005 | |
36 | NATIO | PIQNATSL | LAND1 | CHAR | 3 | 0 | Nationality (Citizenship) | T005 | |
37 | NATI2 | PIQNATS2 | LAND1 | CHAR | 3 | 0 | Second Nationality (Citizenship) | T005 | |
38 | NATI3 | PIQNATS3 | LAND1 | CHAR | 3 | 0 | Third Nationality (Citizenship) | T005 | |
39 | LANGU | PIQ_SPRAS | SPRAS | LANG | 1 | 0 | Language of Communication | T002 | |
40 | ANRED | ANRDE | ANRDE | CHAR | 1 | 0 | Form-of-Address Key | T522G | |
41 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
42 | FAMST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | T502T | |
43 | PRDNI | PIQ_PRDNI | CHAR20 | CHAR | 20 | 0 | Identification Number | ||
44 | NACHN_MC | PIQ_NACHN_MC | CHAR40 | CHAR | 40 | 0 | Last Name (Field for Search Help) | ||
45 | VORNA_MC | PIQ_VORNA_MC | CHAR40 | CHAR | 40 | 0 | First Name (Search Help Field) | ||
46 | DEATHDATE | PIQ_DEATHDATE | DATE | DATS | 8 | 0 | Date of Death | ||
47 | DREGDATE | PIQ_REGDEATHDATE | DATE | DATS | 8 | 0 | Date On Which Death Was Recorded | ||
48 | BIRTHNAME_MC | PIQ_BIRTHNAME_MC | CHAR40 | CHAR | 40 | 0 | Name at Birth (Field for Search Help) | ||
49 | MIDNM_MC | PIQ_MIDNM_MC | CHAR40 | CHAR | 40 | 0 | Middle Name (Field for Search Help) | ||
50 | PREV_SURNAME | PIQ_GB_PREV_SURNAME | PIQ_GB_PREV_SURNAME | CHAR | 30 | 0 | UCAS: Previous Name | ||
51 | .INCLUDE | 0 | 0 | ||||||
52 | .INCLUDE | 0 | 0 | Struct. for Report BUPTDTRANSMIT for Distribution of TD Data | |||||
53 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
54 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) | ||
55 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
56 | VALID_FROM | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PIQBPEI_IT1702 | ANRED | T522G | ANRED | KEY | 1 | CN |
2 | PIQBPEI_IT1702 | FAMST | T502T | FAMST | |||
3 | PIQBPEI_IT1702 | GBDEP | T005S | BLAND | |||
4 | PIQBPEI_IT1702 | GBLND | T005 | LAND1 | |||
5 | PIQBPEI_IT1702 | GBNAT | T005 | LAND1 | |||
6 | PIQBPEI_IT1702 | INFTY | T778T | INFTY | KEY | 1 | CN |
7 | PIQBPEI_IT1702 | ISTAT | T778S | ISTAT | KEY | 1 | CN |
8 | PIQBPEI_IT1702 | LANGU | T002 | SPRAS | KEY | 1 | CN |
9 | PIQBPEI_IT1702 | MANDT | T000 | MANDT | KEY | 1 | CN |
10 | PIQBPEI_IT1702 | NAMZU | T535N | TITEL | |||
11 | PIQBPEI_IT1702 | NATI2 | T005 | LAND1 | |||
12 | PIQBPEI_IT1702 | NATI3 | T005 | LAND1 | |||
13 | PIQBPEI_IT1702 | NATIO | T005 | LAND1 | KEY | 1 | CN |
14 | PIQBPEI_IT1702 | OBJID | PLOGI | OBJID | KEY | 1 | CN |
15 | PIQBPEI_IT1702 | OTYPE | T778O | OTYPE | KEY | 1 | CN |
16 | PIQBPEI_IT1702 | PLVAR | T778P | PLVAR | KEY | 1 | CN |
17 | PIQBPEI_IT1702 | TITEL | T535N | TITEL | |||
18 | PIQBPEI_IT1702 | VORSW | T535N | TITEL |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |