WRF_APC_PLI SAP (Purchasing List Items) Table details
Dictionary Type: Table
Description: Purchasing List Items
Description: Purchasing List Items
Table field list including key, data, relationships and ABAP select examples
WRF_APC_PLI is a standard SAP Table which is used to store Purchasing List Items data and is available within R/3 SAP systems depending on the version and release level.
The WRF_APC_PLI table consists of various fields, each holding specific information or linking keys about Purchasing List Items data available in SAP. These include MANDT (Client), PLID (Purchasing List Number), PLITEM (Purchasing List Item ID), MAIN_MATNR (Planned Material Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WRF_APC_PLI table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PLID | Purchasing List Number | WRF_PLID | CHAR | 10 | WRF_APC_PLH | PLID1 | WRF_PLID | PLID | |
PLITEM | Purchasing List Item ID | WRF_PLITEM | CHAR | 22 | SYSUUID_22 | ||||
MAIN_MATNR | Planned Material Number | WRF_PLNART | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
PRES_ST | Presentation Date Store | WRF_PRDAT_ST | DATS | 8 | DATUM | ||||
DL_ID | Date Line ID (GUID) | WRF_PSCD_DL_ID | CHAR | 22 | SYSUUID_22 | ||||
FL_CHG | Purchasing List Item Is Changeable | WRF_FL_CHG | CHAR | 1 | XFELD | ||||
FL_SUM | Include PL Item in Sum | WRF_FL_SUM | CHAR | 1 | XFELD | ||||
FL_PO | Include PL Item in Purchase Order | WRF_FL_PO | CHAR | 1 | XFELD | ||||
FL_RELEASE | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
FL_REL_REQ | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
FL_ORIGIN | Origin of Purchasing List Item | WRF_ORIGIN | CHAR | 1 | WRF_ORIGIN | ||||
PLITEM_SRC | Purchasing List Source Item ID | WRF_PLITEM_SRC | CHAR | 22 | WRF_APC_PLI | SYSUUID_22 | |||
LAYGR_SRC | Layout Module | LAYGR | CHAR | 10 | Assigned to domain | LAYGR | WLM | LAYMODD | |
LMVER_SRC | Layout Module Version | LAYMOD_VER | NUMC | 4 | Assigned to domain | WLMV | LAYMOD_VER | WLMV | LAYMODVER |
PL_CONSIGN | Consignment Flag | WRF_CONS_APC | CHAR | 1 | WRF_CONS_APC | ||||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
PO_NETPR | Operational APC: Purchase Price Current PO Vendor Currency | WRF_PRICE_PO | CURR | 11(2) | WERTV6 | ||||
PO_WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
PO_NETPR_OWN | Operational APC: Purchase Price Current PO Own Currency | WRF_NPRPO_OWN | CURR | 11(2) | WERTV6 | ||||
PO_WAERS_OWN | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
UNIT | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MARKET_NO | Number for Market Buying | WRF_MARKETNO | CHAR | 10 | WRF_MARKETNO | ||||
CHGDC | OAPC: Manually Changed DC in a Purchasing List Item | WRF_APC_CHGDC | CHAR | 4 | T001W | WERKS | |||
FL_PAQUPD | OAPC: Update of Put Away Quantity Distribution Necessary | WRF_APC_PAQUPD | CHAR | 1 | XFELD | ||||
FL_SYNC | OAPC: Synchronisation Necessary for Purchasing List Item | WRF_APC_SYNC | NUMC | 2 | WRF_APC_SYNC | ||||
RESCD | Operational APC: Reschedule During PL Item Release | WRF_APC_RESCD | CHAR | 1 | CHAR1 | ||||
PRCDD | Operational APC: Direct Delivery Indicator | WRF_APC_PRCDD | CHAR | 1 | WRF_APC_PRCDD | ||||
NOCDP | OAPC: No Cross-Docking with Prepacking | WRF_APC_NOCDP | CHAR | 1 | CHAR1 | ||||
SA_CMPTOT | Use derived plan quantities for total calculation | WRF_APC_SA_CMPTOT | CHAR | 1 | XFELD | ||||
SA_CBUOM | Convert component quantity to base UOM | WRF_APC_SA_CBUOM | CHAR | 1 | XFELD | ||||
FYVAR | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
FYEAR | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
APPLLOG | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 |
Key field | Non-key field |
How do I retrieve data from SAP table WRF_APC_PLI using ABAP code
The following ABAP code Example will allow you to do a basic selection on WRF_APC_PLI to SELECT all data from the tableDATA: WA_WRF_APC_PLI TYPE WRF_APC_PLI.
SELECT SINGLE *
FROM WRF_APC_PLI
INTO CORRESPONDING FIELDS OF WA_WRF_APC_PLI
WHERE...
How to access SAP table WRF_APC_PLI
Within an ECC or HANA version of SAP you can also view further information about WRF_APC_PLI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects