PLAF SAP (Planned Order) Table details
Dictionary Type: Table
Description: Planned Order
Description: Planned Order
Table field list including key, data, relationships and ABAP select examples
PLAF is a standard SAP Table which is used to store Planned Order data and is available within R/3 SAP systems depending on the version and release level.
The PLAF table consists of various fields, each holding specific information or linking keys about Planned Order data available in SAP. These include PLNUM (Planned order number), MATNR (Planning material), PLWRK (Planning Plant), PWWRK (Production plant in planned order).. 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 PLAF 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 | Assigned to domain | MANDT | |||
PLNUM | Planned order number | PLNUM | CHAR | 10 | ALPHA | PLNUM | PAF | ||
MATNR | Planning material | PLMAT | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
PLWRK | Planning Plant | PLWRK | CHAR | 4 | T001W | WERKS | WRK | ||
PWWRK | Production plant in planned order | PWWRK | CHAR | 4 | T001W | WERKS | |||
PAART | Order type | PAART | CHAR | 4 | PAART | ||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SOBES | Special procurement type | SOBES | CHAR | 1 | SOBES | ||||
GSMNG | Total planned order quantity | GSMNG | QUAN | 13(3) | MENG13 | ||||
TLMNG | Partial lot quantity | TLMNG | QUAN | 13(3) | MENG13 | ||||
AVMNG | Fixed quantity of scrap from production | AVMNG | QUAN | 13(3) | MENG13 | ||||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
PSTTR | Order start date in planned order | PSTTR | DATS | 8 | DATUM | ||||
PEDTR | Order finish date in the planned order | PEDTR | DATS | 8 | DATUM | ||||
PERTR | Planned opening date in planned order | PERTR | DATS | 8 | DATUM | ||||
WEBAZ | Goods receipt processing time in days | PLWEZ | DEC | 3 | DEC3 | ||||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
UMSKZ | Conversion indicator for planned order | PLUMS | CHAR | 1 | XFELD | ||||
AUFFX | Firming indicator for planned order data | PLAFX | CHAR | 1 | XFELD | ||||
STLFX | Fixing indicator for BOM explosion | PLSFX | CHAR | 1 | XFELD | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
QUNUM | Number of Quota Arrangement | QUNUM | CHAR | 10 | ALPHA | QUNUM | |||
QUPOS | Quota Arrangement Item | QUPOS | NUMC | 3 | NUM03 | ||||
FLIEF | Fixed Vendor | FLIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | EKPO | EBELP | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
NUMVR | Version number | NUMVR | NUMC | 2 | NUMVR | ||||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
PSPEL | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | SNUM | SERNR | |||
PALTR | Explosion date | PALTR | DATS | 8 | DATUM | ||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
STLAN | BOM Usage | STLAN | CHAR | 1 | Assigned to domain | STLAN | CSV | ||
STALT | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
STSTA | BOM status | STLST | NUMC | 2 | T415S | STLST | |||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | RSPOS | ||||
VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4 | T437V | SA_VERTL | |||
VERID | Production Version | VERID | CHAR | 4 | MKAL | VERID | VER | ||
AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | SAFK | ALPHA | SA_AUFNR | ||
TRART | Scheduling type of the planned order | TRART | CHAR | 1 | CHAR1 | ||||
PLGRP | Production Supervisor | FEVOR | CHAR | 3 | T024F | FEVOR | CFV | ||
TERST | Start date for production | TERST | DATS | 8 | DATUM | ||||
TERED | Finish date for production | TERED | DATS | 8 | DATUM | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
LINID | ID for a schedule record | SP_OPID | NUMC | 15 | SP_OPID | ||||
TRMKZ | Scheduling indicator | TRMFL | CHAR | 1 | XFELD | ||||
TRMER | Scheduling error | TRMER | CHAR | 2 | TRMER | ||||
REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | REDKZ | ||||
TRMHK | Scheduling source | TRMHK | CHAR | 1 | TRMHK | ||||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
PLNTY | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | PLNTY | PTY | H_TCA01 | |
FRTHW | Production note in the planned order | FRTHW | CHAR | 1 | FRTHW | ||||
RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | CO_RGEKZ | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
ABMNG | Reduced quantity in the planned order | ABMNG | QUAN | 13(3) | MENGE | ||||
RATID | Index for the results of scheduling production rates | RATID | NUMC | 12 | Assigned to domain | BEDID | |||
GROID | Index for rough scheduling results | GROID | NUMC | 12 | Assigned to domain | BEDID | |||
RATER | Scheduling error in scheduling production rates | RATER | CHAR | 2 | TRMER | ||||
GROER | Scheduling error in rough scheduling | GROER | CHAR | 2 | TRMER | ||||
OBART | Object type | OBART | CHAR | 1 | OBART | ||||
PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | PLSC | PLSCN | PLS | ||
SBNUM | Simulation requirements number | SBNUM | NUMC | 10 | Assigned to domain | SBNUM | |||
KBNKZ | Kanban Indicator | KBNKZ | CHAR | 1 | KBNKZ | ||||
KAPFX | Indicator: capacity for planned order dispatched | KAPFX | CHAR | 1 | XFELD | ||||
SEQNR | Seq. number order | CY_SEQNR | NUMC | 14 | CY_SEQNR | ||||
PSTTI | Start Time of Planned Order | PSTTI | TIMS | 6 | UZEIT | ||||
PEDTI | End Time of Planned Order | PEDTI | TIMS | 6 | UZEIT | ||||
MONKZ | Indicator: for assembly order procedures | MONKZ | CHAR | 1 | XFELD | ||||
PRNKZ | Ind.: Leading order in collective order is planned ordre | PRNKZ | CHAR | 1 | KREUZ | ||||
MDPBV | Planned order: confirmation of availability | MDPBV | CHAR | 1 | MDPBV | ||||
VFMNG | Planned order: committed quantity | VFMNG | QUAN | 13(3) | MENG13 | ||||
MDACH | Action control: planned order processing | MDACH | CHAR | 2 | T46AC | MDACH | |||
MDACC | Action: planned order processing | MDACC | CHAR | 4 | T46AS | MDACC | |||
MDACD | Date of action: planned order | MDACD | DATS | 8 | DATUM | ||||
MDACT | Time of action: Planned order processing | MDACT | TIMS | 6 | UZEIT | ||||
GSBTR | Total commitment date of plnd ord. after ATP check f.comps. | GSBTR_PLAF | DATS | 8 | DATUM | ||||
PLETX | Planned order shift quantities exist | PLETX | CHAR | 1 | XFELD | ||||
PRSCH | Planned order: scheduling using production dates | MD_PRSCHED | CHAR | 1 | XFELD | ||||
LVSCH | Planned order: leading scheduling level (determines dates) | MD_LVSCHED | CHAR | 1 | SCHED_TYPE | ||||
KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | KZAVC | ||||
VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1 | XFELD | ||||
PBDNR | Requirements Plan Number | PBDNR | CHAR | 10 | CHAR10 | PBN | |||
AGREQ | Requirements totaling | AGREQ | CHAR | 1 | AGREQ | ||||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13(3) | MENG13 | ||||
ERFME | Unit of Entry | ERFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
RQNUM | Requirements record number | RQNUM | NUMC | 10 | Assigned to domain | RQNUM | PLA | ||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
WAMNG | Issued Quantity | WAMNG | QUAN | 13(3) | MENG13 | ||||
EDGNO | Internal number for edge of object dependencies tree | EDGNO | NUMC | 17 | M60I | EDGNO | |||
LBLKZ | Subcontracting vendor | LBLKZ | CHAR | 1 | XFELD | ||||
EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
BERID | MRP Area | BERID | CHAR | 10 | MDLV | BERID | BERID | ||
UBERI | Issuing MRP area when transferring stock | UBERI | CHAR | 10 | Assigned to domain | BERID | |||
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | HTN | |
REMFL | Repetitive Manufacturing indicator | REMFL | CHAR | 1 | REMFL | ||||
PSTMP | Last Change to Planned Order: Time Stamp | PSTMP | DEC | 15 | TZNTSTMPS | ||||
PUSER | Last Change to Planned Order: User | PUSER | CHAR | 12 | UNAME | ||||
BADI | Object change via active Business Add-In | MD_BADI | CHAR | 1 | MD_BADI | ||||
STAEX | Status information on BOM explosion in planned order | MD_STAEX | CHAR | 2 | MD_STAEX | ||||
RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | T001L | LGORT | |||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | ALPHA | BBP_BAPI_EBELN | MMBSI_MEKK_CC | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | BBP_ITEMNO | ||||
MEDKZ | Indicator for Distributed Planned Order | MEDKZ | CHAR | 1 | MEDKZ | ||||
CNFQTY | Total Confirmed Qty Planned Order (Repetitive Manufacturing) | MD_MES_CNF_QTY | QUAN | 13(3) | MENG13 | ||||
.INCLU--AP | 0 | ||||||||
M_MRP | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
.INCLU--AP | 0 | ||||||||
ATRKZ | Request ID | ATRKZ | CHAR | 1 | ATRKZ |
Key field | Non-key field |
How do I retrieve data from SAP table PLAF using ABAP code
The following ABAP code Example will allow you to do a basic selection on PLAF to SELECT all data from the tableDATA: WA_PLAF TYPE PLAF.
SELECT SINGLE *
FROM PLAF
INTO CORRESPONDING FIELDS OF WA_PLAF
WHERE...
How to access SAP table PLAF
Within an ECC or HANA version of SAP you can also view further information about PLAF 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