SAP Table P1684_EXP
Infotype 1684 expanded structures
P1684_EXP (Infotype 1684 expanded structures) 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 P1684_EXP to other SAP tables.
P1684_EXP 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 | OBJEKTID | NUMC | 8 | 0 | |||||||
| INFTY | Infotype | INFOTYP | T778T | CHAR | 4 | 0 | ||||||
| SUBTY | Subtype | SUBTYP | T778U | CHAR | 4 | 0 | ||||||
| ISTAT | Planning Status | ISTAT_D | T778S | CHAR | 1 | 0 | ||||||
| PRIOX | Priority | PRIOX | CHAR | 2 | 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 | |||||||
| 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 | |||||||
| MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||||||
| TABNR | Reference Number to Table Part | HRTABNR | CHAR | 32 | 0 | |||||||
| TABSEQNR | Sequence Number in Table Part of Table Infotype | HRTABSEQNR | NUMC | 6 | 0 | |||||||
| ACCDT | Charging Date | HRTNM_ACCDT | DATS | 8 | 0 | |||||||
| REFER | Reference | HRTNM_REFER | CHAR | 35 | 0 | |||||||
| BUPAR | Business Partner Number | BU_PARTNER | BUT000 | CHAR | 10 | 0 | ||||||
| KOBES | Cost item | KOBES | T77TNM_CA | CHAR | 8 | 0 | ||||||
| PRICE | Proposed amount | HRTNM_PRICE | CURR | 15 | 2 | |||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||
| WERKS | Personnel Area | PERSA | CHAR | 4 | 0 | |||||||
| BTRTL | Personnel Subarea | BTRTL | T001P | CHAR | 4 | 0 | ||||||
| MOLPT | Country Grouping | MOLGA | CHAR | 2 | 0 | |||||||
| ATTTY | TNM: attendee type | HRTNM_ATTTY | CHAR | 2 | 0 |
Possible values
|
||||||
| FIRM | Company | HRTNM_FIRM | NUMC | 8 | 0 | |||||||
| ONGHT | Number of Overnight Stays | HRTNM_ONGHT | NUMC | 5 | 0 | |||||||
| IORDT | Internal order date | HRTNM_IORDT | DATS | 8 | 0 | |||||||
| INVDT | Invoice date | HRTNM_INVDT | DATS | 8 | 0 | |||||||
P1684_EXP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P1684_EXP | BTRTL | SYST | MANDT | T001P | Personnel Area/Subarea | MANDT |
| P1684_EXP | BTRTL | P1684_EXP | WERKS | T001P | Personnel Area/Subarea | WERKS |
| P1684_EXP | BTRTL | P1684_EXP | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| P1684_EXP | BUPAR | SYST | MANDT | BUT000 | BP: General data I | CLIENT |
| P1684_EXP | BUPAR | P1684_EXP | BUPAR | BUT000 | BP: General data I | PARTNER |
| P1684_EXP | INFTY | P1684_EXP | MANDT | T778T | Infotypes | MANDT |
| P1684_EXP | INFTY | P1684_EXP | INFTY | T778T | Infotypes | INFTY |
| P1684_EXP | ISTAT | P1684_EXP | MANDT | T778S | Planning Status | MANDT |
| P1684_EXP | ISTAT | P1684_EXP | ISTAT | T778S | Planning Status | ISTAT |
| P1684_EXP | KOBES | SYST | MANDT | T77TNM_CA | Cost Attributes | MANDT |
| P1684_EXP | KOBES | * | T77TNM_CA | Cost Attributes | MOLGA | |
| P1684_EXP | KOBES | P1684_EXP | KOBES | T77TNM_CA | Cost Attributes | KOBES |
| P1684_EXP | KOBES | * | T77TNM_CA | Cost Attributes | ENDDA | |
| P1684_EXP | MANDT | P1684_EXP | MANDT | T000 | Clients | MANDT |
| P1684_EXP | MOLGA | P1684_EXP | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| P1684_EXP | OTYPE | P1684_EXP | OTYPE | T778O | Object Types | OTYPE |
| P1684_EXP | OTYPE | P1684_EXP | MANDT | T778O | Object Types | MANDT |
| P1684_EXP | PLVAR | P1684_EXP | MANDT | T778P | Plan Versions | MANDT |
| P1684_EXP | PLVAR | P1684_EXP | PLVAR | T778P | Plan Versions | PLVAR |
| P1684_EXP | SUBTY | P1684_EXP | MANDT | T778U | Subtypes | MANDT |
| P1684_EXP | SUBTY | P1684_EXP | INFTY | T778U | Subtypes | INFTY |
| P1684_EXP | SUBTY | P1684_EXP | SUBTY | T778U | Subtypes | SUBTY |
| P1684_EXP | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
| P1684_EXP | WAERS | P1684_EXP | WAERS | TCURC | Currency Codes | WAERS |
