SAP WRF_APC_PLI Purchasing List Items Table
Overview
WRF_APC_PLI is a standard SAP S/4HANA table that stores Purchasing List Items data. There are total 36 fields in the WRF_APC_PLI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_APC_PLI 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_PLI to other SAP tables and standard CDS views available based on WRF_APC_PLI table in S/4HANA 2020.
Techincal Settings of WRF_APC_PLI
Below are technical details of the table WRF_APC_PLI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_APC_PLI Fields
The following table gives you an overview of the fields available in WRF_APC_PLI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PLID | Purchasing List Number | WRF_PLID | WRF_APC_PLH | CHAR | 10 |
| PLITEM | Purchasing List Item ID | WRF_PLITEM | CHAR | 22 | |
| MAIN_MATNR | Planned Material Number | WRF_PLNART | * | CHAR | 40 |
| PRES_ST | Presentation Date Store | WRF_PRDAT_ST | DATS | 8 | |
| DL_ID | Date Line ID (GUID) | WRF_PSCD_DL_ID | CHAR | 22 | |
| FL_CHG | Purchasing List Item Is Changeable | WRF_FL_CHG | CHAR | 1 | |
| FL_SUM | Include PL Item in Sum | WRF_FL_SUM | CHAR | 1 | |
| FL_PO | Include PL Item in Purchase Order | WRF_FL_PO | CHAR | 1 | |
| FL_RELEASE | Checkbox | XFELD | CHAR | 1 | |
| FL_REL_REQ | Checkbox | XFELD | CHAR | 1 | |
| FL_ORIGIN | Origin of Purchasing List Item | WRF_ORIGIN | CHAR | 1 | |
| PLITEM_SRC | Purchasing List Source Item ID | WRF_PLITEM_SRC | WRF_APC_PLI | CHAR | 22 |
| LAYGR_SRC | Layout Module | LAYGR | * | CHAR | 10 |
| LMVER_SRC | Layout Module Version | LAYMOD_VER | * | NUMC | 4 |
| PL_CONSIGN | Consignment Flag | WRF_CONS_APC | CHAR | 1 | |
| LIFNR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| PO_NETPR | Operational APC: Purchase Price Current PO Supplier Currency | WRF_PRICE_PO | CURR | 11 | |
| PO_WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| PO_NETPR_OWN | Operational APC: Purchase Price Current PO Own Currency | WRF_NPRPO_OWN | CURR | 11 | |
| PO_WAERS_OWN | Currency Key | WAERS | TCURC | CUKY | 5 |
| UNIT | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| MARKET_NO | Number for Market Buying | WRF_MARKETNO | CHAR | 10 | |
| CHGDC | OAPC: Manually Changed DC in a Purchasing List Item | WRF_APC_CHGDC | T001W | CHAR | 4 |
| FL_PAQUPD | OAPC: Update of Put Away Quantity Distribution Necessary | WRF_APC_PAQUPD | CHAR | 1 | |
| FL_SYNC | OAPC: Synchronisation Necessary for Purchasing List Item | WRF_APC_SYNC | NUMC | 2 | |
| RESCD | Operational APC: Reschedule During PL Item Release | WRF_APC_RESCD | CHAR | 1 | |
| PRCDD | Operational APC: Direct Delivery Indicator | WRF_APC_PRCDD | CHAR | 1 | |
| NOCDP | OAPC: No Cross-Docking with Prepacking | WRF_APC_NOCDP | CHAR | 1 | |
| SA_CMPTOT | Use derived plan quantities for total calculation | WRF_APC_SA_CMPTOT | CHAR | 1 | |
| SA_CBUOM | Convert component quantity to base UOM | WRF_APC_SA_CBUOM | CHAR | 1 | |
| FYVAR | Fiscal Year Variant | PERIV | * | CHAR | 2 |
| FYEAR | Posting Date YYYY | BDATJ | NUMC | 4 | |
| POPER | Posting period | POPER | NUMC | 3 | |
| ATTYP | Material Category | ATTYP | CHAR | 2 | |
| APPLLOG | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 |
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_PLI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_APC_PLI | CHGDC | : | T001W |
| WRF_APC_PLI | LIFNR | : | LFA1 |
| WRF_APC_PLI | MANDT | : | T000 |
| WRF_APC_PLI | PLID | : | WRF_APC_PLH |
| WRF_APC_PLI | PLITEM_SRC | : | WRF_APC_PLI |
| WRF_APC_PLI | PO_WAERS | : | TCURC |
| WRF_APC_PLI | PO_WAERS_OWN | : | TCURC |
| WRF_APC_PLI | UNIT | : | T006 |