SAP Table PIQBPEI_IT1704
Structure for IT1704 for TB058 (in Report BUPTDTRANSMIT)
PIQBPEI_IT1704 (Structure for IT1704 for TB058 (in Report BUPTDTRANSMIT)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PIQBPEI_IT1704 to other SAP tables.
PIQBPEI_IT1704 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| PLVAR | Plan Version | PLVAR | T778P | CHAR | 2 | 0 | ||||||||||||
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||||||||||||
| OBJID | Object ID | HROBJID | PLOGI | NUMC | 8 | 0 | ||||||||||||
| SUBTY | Subtype | SUBTYP | CHAR | 4 | 0 | |||||||||||||
| ISTAT | Planning Status | ISTAT_D | T778S | CHAR | 1 | 0 | ||||||||||||
| BEGDA | Start Date | BEGDATUM | DATS | 8 | 0 | |||||||||||||
| ENDDA | End Date | ENDDATUM | DATS | 8 | 0 | |||||||||||||
| VARYF | Variation Field for File PLOG | VARYF | CHAR | 10 | 0 | |||||||||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||||||
| INFTY | Infotype | INFOTYP | T778T | CHAR | 4 | 0 | ||||||||||||
| OTJID | Concatenation of Object Type and Object ID | OTJID | CHAR | 10 | 0 | |||||||||||||
| AEDTM | Changed on | AEDTM | DATS | 8 | 0 | |||||||||||||
| UNAME | User Name | USRNAME | CHAR | 12 | 0 | |||||||||||||
| REASN | Reason | REASN | CHAR | 2 | 0 | |||||||||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||||||
| ITXNR | Text Module for Infotype | ITXNR | NUMC | 8 | 0 | |||||||||||||
| CHGRP | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||||||
| SBPRF | Field No Longer Used | PIQOLD_SBPRF | DEC | 5 | 2 | |||||||||||||
| CHTYP | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||||||
| SBAUD | Field No Longer Used | PIQOLD_SBAUD | DATS | 8 | 0 | |||||||||||||
| KONFE | Religious Denomination Key | PIQKONFE | T516T | CHAR | 2 | 0 | ||||||||||||
| ETHNIC | Ethnic Origin | PIQETHNIC | T7PIQETHNIC | CHAR | 4 | 0 | ||||||||||||
| ORIGIN | Reserved field/unused field of length 4 | NUSED4 | CHAR | 4 | 0 | |||||||||||||
| TAETE | Student's Job | PIQTAETE | T513C | NUMC | 8 | 0 | ||||||||||||
| SOCIAL | Social Class | PIQSOCIAL | T7PIQSOCIAL | CHAR | 2 | 0 | ||||||||||||
| SERV_STAT | Service Status | PIQSERV_STAT | T505M | NUMC | 2 | 0 | ||||||||||||
| SERV_NR | Service Number | PIQSERV_NR | CHAR | 20 | 0 | |||||||||||||
| VETERAN_NR | Veteran Administration Number | PIQVETERAN_NR | CHAR | 20 | 0 | |||||||||||||
| DR_LIC_NO | Driver's License Number | DR_LIC_NO_PS | CHAR | 20 | 0 | |||||||||||||
| DR_LIC_LAND1 | Country in Which Driver's License Was Issued | DR_LIC_LAND1_PS | T005 | CHAR | 3 | 0 | ||||||||||||
| DR_LIC_REGIO | Region in Which Driver's License Was Issued | DR_LIC_REGIO_PS | T005S | CHAR | 3 | 0 | ||||||||||||
| KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||||||||
| VALID_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | 0 | |||||||||||||
PIQBPEI_IT1704 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PIQBPEI_IT1704 | DR_LIC_LAND1 | SYST | MANDT | T005 | Countries | MANDT |
| PIQBPEI_IT1704 | DR_LIC_LAND1 | PIQBPEI_IT1704 | DR_LIC_LAND1 | T005 | Countries | LAND1 |
| PIQBPEI_IT1704 | DR_LIC_REGIO | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| PIQBPEI_IT1704 | DR_LIC_REGIO | PIQBPEI_IT1704 | DR_LIC_LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| PIQBPEI_IT1704 | DR_LIC_REGIO | PIQBPEI_IT1704 | DR_LIC_REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| PIQBPEI_IT1704 | ETHNIC | SYST | MANDT | T7PIQETHNIC | Ethnic Origins | MANDT |
| PIQBPEI_IT1704 | ETHNIC | PIQBPEI_IT1704 | ETHNIC | T7PIQETHNIC | Ethnic Origins | ETHNIC |
| PIQBPEI_IT1704 | INFTY | PIQBPEI_IT1704 | INFTY | T778T | Infotypes | INFTY |
| PIQBPEI_IT1704 | INFTY | PIQBPEI_IT1704 | MANDT | T778T | Infotypes | MANDT |
| PIQBPEI_IT1704 | ISTAT | PIQBPEI_IT1704 | MANDT | T778S | Planning Status | MANDT |
| PIQBPEI_IT1704 | ISTAT | PIQBPEI_IT1704 | ISTAT | T778S | Planning Status | ISTAT |
| PIQBPEI_IT1704 | KONFE | SYST | MANDT | T516T | Religious Denomination Texts | MANDT |
| PIQBPEI_IT1704 | KONFE | SYST | LANGU | T516T | Religious Denomination Texts | SPRSL |
| PIQBPEI_IT1704 | KONFE | PIQBPEI_IT1704 | KONFE | T516T | Religious Denomination Texts | KONFE |
| PIQBPEI_IT1704 | MANDT | PIQBPEI_IT1704 | MANDT | T000 | Clients | MANDT |
| PIQBPEI_IT1704 | OBJID | PIQBPEI_IT1704 | MANDT | PLOGI | Table Index HRP* | MANDT |
| PIQBPEI_IT1704 | OBJID | PIQBPEI_IT1704 | PLVAR | PLOGI | Table Index HRP* | PLVAR |
| PIQBPEI_IT1704 | OBJID | PIQBPEI_IT1704 | OTYPE | PLOGI | Table Index HRP* | OTYPE |
| PIQBPEI_IT1704 | OBJID | PIQBPEI_IT1704 | OBJID | PLOGI | Table Index HRP* | OBJID |
| PIQBPEI_IT1704 | OTYPE | PIQBPEI_IT1704 | OTYPE | T778O | Object Types | OTYPE |
| PIQBPEI_IT1704 | OTYPE | PIQBPEI_IT1704 | MANDT | T778O | Object Types | MANDT |
| PIQBPEI_IT1704 | PLVAR | PIQBPEI_IT1704 | MANDT | T778P | Plan Versions | MANDT |
| PIQBPEI_IT1704 | PLVAR | PIQBPEI_IT1704 | PLVAR | T778P | Plan Versions | PLVAR |
| PIQBPEI_IT1704 | SERV_STAT | SYST | MANDT | T505M | Military status | MANDT |
| PIQBPEI_IT1704 | SERV_STAT | PIQCOUNTRY | MOLGA | T505M | Military status | MOLGA |
| PIQBPEI_IT1704 | SERV_STAT | PIQBPEI_IT1704 | SERV_STAT | T505M | Military status | MILSA |
| PIQBPEI_IT1704 | SOCIAL | SYST | MANDT | T7PIQSOCIAL | Social Classes | MANDT |
| PIQBPEI_IT1704 | SOCIAL | PIQBPEI_IT1704 | SOCIAL | T7PIQSOCIAL | Social Classes | SOCIAL |
| PIQBPEI_IT1704 | TAETE | PIQBPEI_IT1704 | TAETE | T513C | Jobs With Other/Previous Employers | TAETE |
| PIQBPEI_IT1704 | TAETE | SYST | MANDT | T513C | Jobs With Other/Previous Employers | MANDT |
| PIQBPEI_IT1704 | TAETE | SYST | LANGU | T513C | Jobs With Other/Previous Employers | SPRAS |
