SAP WRF_APC_PLPL Purchasing List Planned Data Table
Overview
WRF_APC_PLPL is a standard SAP S/4HANA table that stores Purchasing List Planned Data data. There are total 19 fields in the WRF_APC_PLPL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_APC_PLPL belongs to Orders and Contracts (LO-RFM-PUR-POF) module and is located in the package Operational Assortment Planning and Control (WRF_APC).
In addition, following links provide an overview of foreign key relationships, if any, that link WRF_APC_PLPL to other SAP tables and standard CDS views available based on WRF_APC_PLPL table in S/4HANA 2020.
Techincal Settings of WRF_APC_PLPL
Below are technical details of the table WRF_APC_PLPL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_APC_PLPL Fields
The following table gives you an overview of the fields available in WRF_APC_PLPL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PLITEM | Purchasing List Item ID | WRF_PLITEM | WRF_APC_PLI | CHAR | 22 |
| CHAR1 | Characteristic Value | ATWRT | CHAR | 70 | |
| CHAR2 | Characteristic Value | ATWRT | CHAR | 70 | |
| CHAR3 | Characteristic Value | ATWRT | CHAR | 70 | |
| KEYFIG | Key Figure ID | WRF_KEYFIG | WRFT_APC_KFIG | CHAR | 2 |
| ASORT | Assortment | ASORT | WRS1 | CHAR | 10 |
| PLID | Purchasing List Number | WRF_PLID | WRF_APC_PLH | CHAR | 10 |
| MAIN_MATNR | Planned Material Number | WRF_PLNART | * | CHAR | 40 |
| QUAN_PLN | Planned Quantity for Each Store of the Assortment | WRF_QTY_PLAN | QUAN | 10 | |
| COST_BASIC | Target Purchasing / Cost Value (Basic Purchase Price) | WRF_COST_BASIC | CURR | 19 | |
| COST_NET | Target Purchasing / Cost Value (Net/Net) | WRF_COST_NET | CURR | 19 | |
| RETAIL | Target Purchasing / Retail Value without Tax | WRF_RETAIL | CURR | 19 | |
| RETAIL_TAX | Target Purchasing / Retail Value Including Tax | WRF_RETAIL_TAX | CURR | 19 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| UNIT | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| TIMESTAMP | Time Stamp | WRF_TIMESTAMP | NUMC | 14 | |
| CHANGED_BY | Name of person who changed object | AENAM | CHAR | 12 | |
| VARNR | Variant number | VATNR | * | CHAR | 40 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WRF_APC_PLPL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_APC_PLPL | ASORT | : | WRS1 |
| WRF_APC_PLPL | KEYFIG | : | WRFT_APC_KFIG |
| WRF_APC_PLPL | MANDT | : | T000 |
| WRF_APC_PLPL | PLID | : | WRF_APC_PLH |
| WRF_APC_PLPL | PLITEM | : | WRF_APC_PLI |
| WRF_APC_PLPL | UNIT | : | T006 |
| WRF_APC_PLPL | WAERS | : | TCURC |