SAP Table P1818
Infotype 1818: Threshold Value
P1818 (Infotype 1818: Threshold Value) 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 P1818 to other SAP tables.
Source: P1818 (Infotype 1818: Threshold Value)
P1818 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 | |||||||
| THR_TF | Timeframe | FOPC_TIMEFRAME | CHAR | 10 | 0 | |||||||
| THR_YEAR | Year | FOPC_YEAR | CHAR | 4 | 0 | |||||||
| ABOVE | Above Threshold | FOPC_THR_ABOVE | CHAR | 1 | 0 |
Possible values
|
||||||
| THRESHOLD | Threshold Value | FOPC_TRESHOLD | CURR | 12 | 2 | |||||||
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
P1818 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P1818 | CURRENCY | SYST | MANDT | TCURC | Currency Codes | MANDT |
| P1818 | CURRENCY | P1818 | CURRENCY | TCURC | Currency Codes | WAERS |
| P1818 | INFTY | P1818 | MANDT | T778T | Infotypes | MANDT |
| P1818 | INFTY | P1818 | INFTY | T778T | Infotypes | INFTY |
| P1818 | ISTAT | P1818 | MANDT | T778S | Planning Status | MANDT |
| P1818 | ISTAT | P1818 | ISTAT | T778S | Planning Status | ISTAT |
| P1818 | MANDT | P1818 | MANDT | T000 | Clients | MANDT |
| P1818 | OTYPE | P1818 | MANDT | T778O | Object Types | MANDT |
| P1818 | OTYPE | P1818 | OTYPE | T778O | Object Types | OTYPE |
| P1818 | PLVAR | P1818 | MANDT | T778P | Plan Versions | MANDT |
| P1818 | PLVAR | P1818 | PLVAR | T778P | Plan Versions | PLVAR |
| P1818 | SUBTY | P1818 | MANDT | T778U | Subtypes | MANDT |
| P1818 | SUBTY | P1818 | INFTY | T778U | Subtypes | INFTY |
| P1818 | SUBTY | P1818 | SUBTY | T778U | Subtypes | SUBTY |
