SAP WRF_APC_PLPOQ Purchasing List Purchase Order Quantities Table
Overview
WRF_APC_PLPOQ is a standard SAP S/4HANA table that stores Purchasing List Purchase Order Quantities data. There are total 33 fields in the WRF_APC_PLPOQ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_APC_PLPOQ 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_PLPOQ to other SAP tables and standard CDS views available based on WRF_APC_PLPOQ table in S/4HANA 2020.
Techincal Settings of WRF_APC_PLPOQ
Below are technical details of the table WRF_APC_PLPOQ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_APC_PLPOQ Fields
The following table gives you an overview of the fields available in WRF_APC_PLPOQ
| 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 |
| PLSUBITEM | Purchasing List Subitem | WRF_SUBITEM | NUMC | 4 | |
| MATNR | Material Number | MATNR | * | CHAR | 40 |
| KEYFIG | Key Figure ID | WRF_KEYFIG | WRFT_APC_KFIG | CHAR | 2 |
| DIS_CENTER | Distribution Center | VZWRK | T001W | CHAR | 4 |
| PLID | Purchasing List Number | WRF_PLID | WRF_APC_PLH | CHAR | 10 |
| ATTYP | Material Category | ATTYP | CHAR | 2 | |
| QUAN_ASGN | Assigned Quantity for Each Store of the Assortment | WRF_QTY_ASSIGN | QUAN | 10 | |
| UNIT | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| FLAG_FIXED | Checkbox | XFELD | CHAR | 1 | |
| TIMESTAMP | Time Stamp | WRF_TIMESTAMP | NUMC | 14 | |
| EBELN | Purchasing Document Number | EBELN | * | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | * | NUMC | 5 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| ABELP | Allocation Table Item | ABELP | AUPO | NUMC | 5 |
| ACT_QUAN | Actual Quantity (Purchase Order) | WRF_QTY_ACTUAL | QUAN | 13 | |
| ACT_UNIT | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| ACT_DLID | Date Line ID (GUID) | WRF_PSCD_DL_ID | CHAR | 22 | |
| ACT_PRESST | Presentation Date Store | WRF_PRDAT_ST | DATS | 8 | |
| ACT_DELST | Delivery Date Store | WRF_GRDAT_ST | DATS | 8 | |
| ACT_DELDC | Delivery Date DC | WRF_GRDAT_DC | DATS | 8 | |
| ACT_DC | Distribution Center | VZWRK | T001W | CHAR | 4 |
| ACT_LIFNR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| ACT_NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11 | |
| ACT_WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| ACT_PEINH | Price unit | EPEIN | DEC | 5 | |
| ACT_BPRME | Order Price Unit (Purchasing) | BBPRM | T006 | UNIT | 3 |
| FLAG_STATUS | Status for Confirmation | WRF_POHF_STATUS | CHAR | 2 | |
| DATE_STATUS | Date when Status Was Set / Recent PO Feedback | WRF_DATE_STATUS | DATS | 8 | |
| DATE_ALLOC | Date when Allocation Table Was Generated | WRF_DATE_ALLOC | DATS | 8 | |
| APPLLOG | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | |
| SUBMI | Collective Number | SUBMI | CHAR | 10 |
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_PLPOQ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_APC_PLPOQ | ABELN | : | AUKO |
| WRF_APC_PLPOQ | ABELP | : | AUPO |
| WRF_APC_PLPOQ | ACT_BPRME | : | T006 |
| WRF_APC_PLPOQ | ACT_DC | : | T001W |
| WRF_APC_PLPOQ | ACT_LIFNR | : | LFA1 |
| WRF_APC_PLPOQ | ACT_UNIT | : | T006 |
| WRF_APC_PLPOQ | ACT_WAERS | : | TCURC |
| WRF_APC_PLPOQ | DIS_CENTER | : | T001W |
| WRF_APC_PLPOQ | KEYFIG | : | WRFT_APC_KFIG |
| WRF_APC_PLPOQ | MANDT | : | T000 |
| WRF_APC_PLPOQ | MATNR | : | * |
| WRF_APC_PLPOQ | PLID | : | WRF_APC_PLH |
| WRF_APC_PLPOQ | PLITEM | : | WRF_APC_PLI |
| WRF_APC_PLPOQ | UNIT | : | T006 |