SAP Table PSPL
Index project -> planned order
PSPL (Index project -> planned order) 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 PSPL to other SAP tables.
PSPL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||
| PSPEL | WBS Element | PS_POSNR | NUMC | 8 | 0 | |||||||||||||
| PLNUM | Planned order number | PLNUM | PLAF | CHAR | 10 | 0 | ||||||||||||
| KNTTP | Account Assignment Category | KNTTP | T163K | CHAR | 1 | 0 | ||||||||||||
| KZVBR | Consumption Posting | KZVBR | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||||||||
| KDAUF | Sales Order Number | KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | 0 | |||||||||||||
| KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | 0 | |||||||||||||
PSPL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PSPL | KDAUF | PSPL | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| PSPL | KDAUF | PSPL | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| PSPL | KNTTP | PSPL | MANDT | T163K | Account Assignment Categories in Purchasing Document | MANDT |
| PSPL | KNTTP | PSPL | KNTTP | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
| PSPL | PLNUM | PSPL | PLNUM | PLAF | Planned Order | PLNUM |
| PSPL | PLNUM | PSPL | MANDT | PLAF | Planned Order | MANDT |
| PSPL | SOBKZ | PSPL | MANDT | T148 | Special Stock Indicator | MANDT |
| PSPL | SOBKZ | PSPL | SOBKZ | T148 | Special Stock Indicator | SOBKZ |
