SAP table P1818 (Infotype 1818: Threshold Value)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PLVAR | Plan Version | CHAR | 2 | 0 | T778P | PLVAR | |
| OTYPE | Object Type | CHAR | 2 | 0 | T778O | OTYPE | |
| OBJID | Object ID | NUMC | 8 | 0 | OBJEKTID | ||
| INFTY | Infotype | CHAR | 4 | 0 | T778T | INFOTYP | |
| SUBTY | Subtype | CHAR | 4 | 0 | T778U | SUBTYP | |
| ISTAT | Planning Status | CHAR | 1 | 0 | T778S | ISTAT_D | |
| PRIOX | Priority | CHAR | 2 | 0 | PRIOX | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDATUM | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDATUM | ||
| VARYF | Variation Field for File PLOG | CHAR | 10 | 0 | VARYF | ||
| SEQNR | Number of Infotype Record With Same Key | NUMC | 3 | 0 | SEQNR | ||
| AEDTM | Changed on | DATS | 8 | 0 | AEDTM | ||
| UNAME | User Name | CHAR | 12 | 0 | USRNAME | ||
| REASN | Reason | CHAR | 2 | 0 | REASN | ||
| HISTO | Historical Record Flag | CHAR | 1 | 0 | HISTO | ||
| ITXNR | Text Module for Infotype | NUMC | 8 | 0 | ITXNR | ||
| THR_TF | Timeframe | CHAR | 10 | 0 | FOPC_TIMEFRAME | ||
| THR_YEAR | Year | CHAR | 4 | 0 | FOPC_YEAR | ||
| ABOVE | Above Threshold | CHAR | 1 | 0 | FOPC_THR_ABOVE | ||
| THRESHOLD | Threshold Value | CURR | 12 | 2 | FOPC_TRESHOLD | ||
| CURRENCY | Currency Key | CUKY | 5 | 0 | TCURC | WAERS |
P1818 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 P1818 | CURRENCY | TCURC | Currency Codes | WAERS |
| 1 P1818 | INFTY | T778T | Infotypes | MANDT |
| 1 P1818 | INFTY | T778T | Infotypes | INFTY |
| 0 P1818 | ISTAT | T778S | Planning Status | MANDT |
| 1 P1818 | MANDT | T000 | Clients | MANDT |
| 0 P1818 | OTYPE | T778O | Object Types | MANDT |
| 0 P1818 | OTYPE | T778O | Object Types | OTYPE |
| 1 P1818 | PLVAR | T778P | Plan Versions | MANDT |
| 0 P1818 | SUBTY | T778U | Subtypes | MANDT |
| 0 P1818 | SUBTY | T778U | Subtypes | INFTY |
| 0 P1818 | SUBTY | T778U | Subtypes | SUBTY |