1. Home
  2. Resources
  3. SAP Tables
  4. PLAF - Planned Order

SAP Table PLAF

Planned Order

PLAF (Planned Order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PLAF to other SAP tables.

PLAF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PLNUM Planned order number PLNUM CHAR 10 0
MATNR Planning material PLMAT MARA CHAR 18 0
PLWRK Planning Plant PLWRK T001W CHAR 4 0
PWWRK Production plant in planned order PWWRK T001W CHAR 4 0
PAART Order type PAART CHAR 4 0
NB Standard purchase order
LA Stock order
RS Reservation
KD Individual customer order
KB Consignment order
PE Run schedule quantity
VP Planned independent requirements
PR Project order
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBES Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
GSMNG Total planned order quantity GSMNG QUAN 13 3
TLMNG Partial lot quantity TLMNG QUAN 13 3
AVMNG Fixed quantity of scrap from production AVMNG QUAN 13 3
BDMNG Requirement Quantity BDMNG QUAN 13 3
PSTTR Order start date in planned order PSTTR DATS 8 0
PEDTR Order finish date in the planned order PEDTR DATS 8 0
PERTR Planned opening date in planned order PERTR DATS 8 0
WEBAZ Goods receipt processing time in days PLWEZ DEC 3 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
UMSKZ Conversion indicator for planned order PLUMS CHAR 1 0
X Yes
NULL No
AUFFX Firming indicator for planned order data PLAFX CHAR 1 0
X Yes
NULL No
STLFX Fixing indicator for BOM explosion PLSFX CHAR 1 0
X Yes
NULL No
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
FLIEF Fixed Vendor FLIEF LFA1 CHAR 10 0
KONNR Number of Principal Purchase Agreement KONNR EKKO CHAR 10 0
KTPNR Item Number of Principal Purchase Agreement KTPNR EKPO NUMC 5 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
NUMVR Version number NUMVR NUMC 2 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
PSPEL WBS Element PS_POSNR NUMC 8 0
SERNR BOM explosion number SERNR SNUM CHAR 8 0
PALTR Explosion date PALTR DATS 8 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
STLAN BOM Usage STLAN CHAR 1 0
STALT Alternative BOM STALT CHAR 2 0
STSTA BOM status STLST T415S NUMC 2 0
AENNR Change Number AENNR CHAR 12 0
ARSNR Settlement reservation number ARSNR NUMC 10 0
ARSPS Item number of the settlement reservation ARSPS NUMC 4 0
VERTO Distribution key for quantity produced SA_VERTO T437V CHAR 4 0
VERID Production Version VERID MKAL CHAR 4 0
AUFNR Run schedule header number SA_AUFNR SAFK CHAR 12 0
TRART Scheduling type of the planned order TRART CHAR 1 0
PLGRP Production Supervisor FEVOR T024F CHAR 3 0
TERST Start date for production TERST DATS 8 0
TERED Finish date for production TERED DATS 8 0
BEDID ID of the capacity requirements record BEDID NUMC 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
LINID ID for a schedule record SP_OPID NUMC 15 0
TRMKZ Scheduling indicator TRMFL CHAR 1 0
X Yes
NULL No
TRMER Scheduling error TRMER CHAR 2 0
0 Scheduling carried out successfully
1 Scheduling parameters are not maintained in customizing
2 No capacity requirements determined, see customizing
3 Routing does not exist
4 No valid routing can be selected
5 Scheduling terminated, see log
6 Scheduling carried out, see log for error messages
7 Scheduling carried out, see log for information messages
8 Det./rate-based sched. and sequencing active at same time
REDKZ Reduction indicator for scheduling REDKZ CHAR 1 0
NULL No reduction carried out
1 Reduction level 1
2 Reduction level 2
3 Reduction level 3
4 Reduction level 4
5 Reduction level 5
6 Reduction level 6
TRMHK Scheduling source TRMHK CHAR 1 0
1 Scheduling via material master
2 Scheduling via routing
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAL Group Counter PLNAL CHAR 2 0
PLNTY Task List Type PLNTY CHAR 1 0
FRTHW Production note in the planned order FRTHW CHAR 1 0
1 Initiate procurements of non-stock components !
2 Purch.req.with unknown acct assig. for non-stock component !
RGEKZ Indicator: Backflushing for order CO_RGEKZ CHAR 1 0
1 Backflush components during goods receipt
2 Backflush all components during goods receipt
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
REVLV Revision Level REVLV CHAR 2 0
ABMNG Reduced quantity in the planned order ABMNG QUAN 13 3
RATID Index for the results of scheduling production rates RATID NUMC 12 0
GROID Index for rough scheduling results GROID NUMC 12 0
RATER Scheduling error in scheduling production rates RATER CHAR 2 0
0 Scheduling carried out successfully
1 Scheduling parameters are not maintained in customizing
2 No capacity requirements determined, see customizing
3 Routing does not exist
4 No valid routing can be selected
5 Scheduling terminated, see log
6 Scheduling carried out, see log for error messages
7 Scheduling carried out, see log for information messages
8 Det./rate-based sched. and sequencing active at same time
GROER Scheduling error in rough scheduling GROER CHAR 2 0
0 Scheduling carried out successfully
1 Scheduling parameters are not maintained in customizing
2 No capacity requirements determined, see customizing
3 Routing does not exist
4 No valid routing can be selected
5 Scheduling terminated, see log
6 Scheduling carried out, see log for error messages
7 Scheduling carried out, see log for information messages
8 Det./rate-based sched. and sequencing active at same time
OBART Object type OBART CHAR 1 0
1 Planned order
2 Purchase requisition
3 Reservation
4 Production order
6 Simulation order
PLSCN Planning Scenario of Long-Term Planning PLSCN PLSC NUMC 3 0
SBNUM Simulation requirements number SBNUM NUMC 10 0
KBNKZ Kanban Indicator KBNKZ CHAR 1 0
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
KAPFX Indicator: capacity for planned order dispatched KAPFX CHAR 1 0
X Yes
NULL No
SEQNR Seq. number order CY_SEQNR NUMC 14 0
PSTTI Start Time of Planned Order PSTTI TIMS 6 0
PEDTI End Time of Planned Order PEDTI TIMS 6 0
MONKZ Indicator: for assembly order procedures MONKZ CHAR 1 0
X Yes
NULL No
PRNKZ Ind.: Leading order in collective order is planned ordre PRNKZ CHAR 1 0
X
NULL
MDPBV Planned order: confirmation of availability MDPBV CHAR 1 0
NULL Availability not checked
1 Availability checked, not confirmed
2 Availability checked, partially confirmed
3 Availability checked, fully confirmed
VFMNG Planned order: committed quantity VFMNG QUAN 13 3
MDACH Action control: planned order processing MDACH T46AC CHAR 2 0
MDACC Action: planned order processing MDACC T46AS CHAR 4 0
MDACD Date of action: planned order MDACD DATS 8 0
MDACT Time of action: Planned order processing MDACT TIMS 6 0
GSBTR Total commitment date of plnd ord. after ATP check f.comps. GSBTR_PLAF DATS 8 0
PLETX Planned order shift quantities exist PLETX CHAR 1 0
X Yes
NULL No
PRSCH Planned order: scheduling using production dates MD_PRSCHED CHAR 1 0
X Yes
NULL No
LVSCH Planned order: leading scheduling level (determines dates) MD_LVSCHED CHAR 1 0
1 Detailed planning
2 Rate-based planning
3 Rough-cut planning
KZAVC Indicator for type of availability check KZAVC CHAR 1 0
1 ATP check
2 Check against preliminary planning
VRPLA Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
PBDNR Requirements Plan Number PBDNR CHAR 10 0
AGREQ Requirements totaling AGREQ CHAR 1 0
NULL No totaling of dependent requirements
X Totaling of dependent requirements
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
RQNUM Requirements record number RQNUM NUMC 10 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
WAMNG Issued Quantity WAMNG QUAN 13 3
EDGNO Internal number for edge of object dependencies tree EDGNO M60I NUMC 17 0
LBLKZ Subcontracting vendor LBLKZ CHAR 1 0
X Yes
NULL No
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 0
BERID MRP Area BERID MDLV CHAR 10 0
UBERI Issuing MRP area when transferring stock UBERI CHAR 10 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
REMFL Repetitive Manufacturing indicator REMFL CHAR 1 0
PSTMP Last Change to Planned Order: Time Stamp PSTMP DEC 15 0
PUSER Last Change to Planned Order: User PUSER CHAR 12 0
BADI Object change via active Business Add-In MD_BADI CHAR 1 0
1 Business Add-In: Planned Order Change (Scheduling)
2 Business Add-In: Planned Order Change (Requirement Planning)
3 Business Add-In: Planned Order Change (Manual)
STAEX Status information on BOM explosion in planned order MD_STAEX CHAR 2 0
01 Alternative explosion (IPPE) active
02 Bulk material items not exploded
RESLO Issuing Storage Location for Stock Transport Order RESLO T001L CHAR 4 0
SRM_CONTRACT_ID Central Contract SRM_CONTRACT_ID CHAR 10 0
SRM_CONTRACT_ITM Central Contract Item Number SRM_CONTRACT_ITEM NUMC 10 0
MEDKZ Indicator for Distributed Planned Order MEDKZ CHAR 1 0
NULL Not Distribution-Relevant
X Distributed
CNFQTY Total Confirmed Qty Planned Order (Repetitive Manufacturing) MD_MES_CNF_QTY QUAN 13 3
KUNNR Customer Number KUNNR CHAR 10 0

PLAF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PLAF AUFNR PLAF MANDT SAFK Run Schedule Master Data MANDT
PLAF AUFNR PLAF AUFNR SAFK Run Schedule Master Data AUFNR
PLAF BERID PLAF MANDT MDLV Customizing MRP Area MANDT
PLAF BERID PLAF BERID MDLV Customizing MRP Area BERID
PLAF DISPO PLAF MANDT T024D MRP controllers MANDT
PLAF DISPO PLAF PLWRK T024D MRP controllers WERKS
PLAF DISPO PLAF DISPO T024D MRP controllers DISPO
PLAF EDGNO PLAF EDGNO M60I Object dependencies tree structure for chars planning EDGNO
PLAF EDGNO PLAF MANDT M60I Object dependencies tree structure for chars planning MANDT
PLAF EKORG PLAF MANDT T024E Purchasing Organizations MANDT
PLAF EKORG PLAF EKORG T024E Purchasing Organizations EKORG
PLAF ERFME PLAF MANDT T006 Units of Measurement MANDT
PLAF ERFME PLAF ERFME T006 Units of Measurement MSEHI
PLAF FLIEF PLAF MANDT LFA1 Vendor Master (General Section) MANDT
PLAF FLIEF PLAF FLIEF LFA1 Vendor Master (General Section) LIFNR
PLAF KDAUF PLAF MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
PLAF KDAUF PLAF KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
PLAF KNTTP PLAF MANDT T163K Account Assignment Categories in Purchasing Document MANDT
PLAF KNTTP PLAF KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
PLAF KONNR PLAF MANDT EKKO Purchasing Document Header MANDT
PLAF KONNR PLAF KONNR EKKO Purchasing Document Header EBELN
PLAF KTPNR PLAF KONNR EKPO Purchasing Document Item EBELN
PLAF KTPNR PLAF KTPNR EKPO Purchasing Document Item EBELP
PLAF KTPNR PLAF MANDT EKPO Purchasing Document Item MANDT
PLAF LGORT PLAF PLWRK T001L Storage Locations WERKS
PLAF LGORT PLAF LGORT T001L Storage Locations LGORT
PLAF LGORT PLAF MANDT T001L Storage Locations MANDT
PLAF MATNR PLAF MANDT MARA General Material Data MANDT
PLAF MATNR PLAF MATNR MARA General Material Data MATNR
PLAF MDACC PLAF MANDT T46AS Action code text MANDT
PLAF MDACC PLAF MDACC T46AS Action code text MDACC
PLAF MDACH * T46AC Action control ACCFM
PLAF MDACH * T46AC Action control ACCTO
PLAF MDACH PLAF MANDT T46AC Action control MANDT
PLAF MDACH PLAF MDACH T46AC Action control MDACH
PLAF MEINS PLAF MANDT T006 Units of Measurement MANDT
PLAF MEINS PLAF MEINS T006 Units of Measurement MSEHI
PLAF PLGRP PLAF MANDT T024F Production scheduler MANDT
PLAF PLGRP PLAF PWWRK T024F Production scheduler WERKS
PLAF PLGRP PLAF PLGRP T024F Production scheduler FEVOR
PLAF PLSCN PLAF MANDT PLSC Planning scenarios in long-term planning MANDT
PLAF PLSCN PLAF PLSCN PLSC Planning scenarios in long-term planning PLSCN
PLAF PLWRK PLAF PLWRK T001W Plants/Branches WERKS
PLAF PLWRK PLAF MANDT T001W Plants/Branches MANDT
PLAF PWWRK PLAF MANDT T001W Plants/Branches MANDT
PLAF PWWRK PLAF PWWRK T001W Plants/Branches WERKS
PLAF RESLO PLAF MANDT T001L Storage Locations MANDT
PLAF RESLO PLAF PWWRK T001L Storage Locations WERKS
PLAF RESLO PLAF RESLO T001L Storage Locations LGORT
PLAF SERNR PLAF MANDT SNUM BOM explosion number MANDT
PLAF SERNR PLAF SERNR SNUM BOM explosion number SERNR
PLAF SOBKZ PLAF SOBKZ T148 Special Stock Indicator SOBKZ
PLAF SOBKZ PLAF MANDT T148 Special Stock Indicator MANDT
PLAF STSTA PLAF MANDT T415S BOM status MANDT
PLAF STSTA PLAF STSTA T415S BOM status STLST
PLAF VERID PLAF MATNR MKAL Production Versions of Material MATNR
PLAF VERID PLAF PWWRK MKAL Production Versions of Material WERKS
PLAF VERID PLAF VERID MKAL Production Versions of Material VERID
PLAF VERID PLAF MANDT MKAL Production Versions of Material MANDT
PLAF VERTO PLAF MANDT T437V Distribution key in MRP MANDT
PLAF VERTO PLAF PWWRK T437V Distribution key in MRP WERKS
PLAF VERTO PLAF VERTO T437V Distribution key in MRP VERTL