SAP table PLAF (Planned Order)

SAP table PLAF has 2 primary key fields being MANDT,PLNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
PLNUM Planned Order CHAR 10 0 PLNUM
MATNR Planning material CHAR 40 0 MARA PLMAT
PLWRK Planning Plant CHAR 4 0 T001W PLWRK
PWWRK Production Plant CHAR 4 0 T001W PWWRK
PAART Planned Order Type CHAR 4 0 PAART
KB Consignment order
KD Individual customer order
LA Stock order
LX External planned order
NB Standard purchase order
PE Run schedule quantity
PR Project order
RS Reservation
VP Planned independent requirements
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
SOBES Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
GSMNG Planned Total Order Quantity QUAN 13 3 GSMNG
TLMNG Partial Lot Quantity QUAN 13 3 TLMNG
AVMNG Planned Scrap Quantity QUAN 13 3 AVMNG
BDMNG Requirement Quantity QUAN 13 3 BDMNG
PSTTR Planned Order Start Date DATS 8 0 PSTTR
PEDTR Planned Order End Date DATS 8 0 PEDTR
PERTR Planned Opening Date in Planned Order DATS 8 0 PERTR
WEBAZ Goods Receipt Processing Duration in Days DEC 3 0 PLWEZ
DISPO MRP Controller CHAR 3 0 T024D DISPO
UMSKZ Planned Order Conversion Indicator CHAR 1 0 PLUMS
AUFFX Firming Indicator for Planned Order Data CHAR 1 0 PLAFX
STLFX Fixing Indicator for BOM Explosion CHAR 1 0 PLSFX
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
QUNUM Number of quota arrangement CHAR 10 0 QUNUM
QUPOS Quota arrangement item NUMC 3 0 QUPOS
FLIEF Fixed Vendor CHAR 10 0 LFA1 FLIEF
KONNR Number of principal purchase agreement CHAR 10 0 EKKO KONNR
KTPNR Item number of principal purchase agreement NUMC 5 0 EKPO KTPNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
LGORT Storage location CHAR 4 0 T001L LGORT_D
NUMVR Version number NUMC 2 0 NUMVR
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
PSPEL WBS Element NUMC 8 0 PS_POSNR
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
PALTR Explosion date DATS 8 0 PALTR
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
STLAN BOM Usage CHAR 1 0 STLAN
STALT Alternative BOM CHAR 2 0 STALT
STSTA Bill of Material Status NUMC 2 0 T415S STLST
AENNR Change Number CHAR 12 0 AENNR
ARSNR Settlement reservation number NUMC 10 0 ARSNR
ARSPS Item number of the settlement reservation NUMC 4 0 ARSPS
VERTO Distribution key for quantity produced CHAR 4 0 T437V SA_VERTO
VERID Production Version CHAR 4 0 MKAL VERID
AUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
TRART Scheduling Type of the Planned Order CHAR 1 0 TRART
PLGRP Production Supervisor CHAR 3 0 T024F FEVOR
TERST Start Date for Production DATS 8 0 TERST
TERED End Date for Production DATS 8 0 TERED
BEDID ID of the Capacity Requirements Record NUMC 12 0 BEDID
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
LINID ID for a schedule record NUMC 15 0 SP_OPID
TRMKZ Scheduling indicator CHAR 1 0 TRMFL
TRMER Scheduling error CHAR 2 0 TRMER
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 Detailed scheduling and sequencing active at same time
REDKZ Reduction indicator for scheduling CHAR 1 0 REDKZ
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 CHAR 1 0 TRMHK
1 Scheduling via material master
2 Scheduling via routing
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
PLNTY Task List Type CHAR 1 0 PLNTY
FRTHW Production note in the planned order CHAR 1 0 FRTHW
1 Initiate procurements of non-stock components !
2 Purch.req.with unknown acct assig. for non-stock component !
RGEKZ Indicator: Backflushing for order CHAR 1 0 CO_RGEKZ
1 Backflush components during goods receipt
2 Backflush all components during goods receipt
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
REVLV Revision Level CHAR 2 0 REVLV
ABMNG Reduced quantity in the planned order QUAN 13 3 ABMNG
RATID -INVALID FOR S/4- Index for the rslts of schedg prod. rates NUMC 12 0 RATID
GROID -INVALID FOR S/4- Index for rough scheduling results NUMC 12 0 GROID
RATER -INVALID FOR S/4- Schedg error in schedg production rates CHAR 2 0 RATER
GROER -INVALID FOR S/4- Scheduling error in rough scheduling CHAR 2 0 GROER
OBART Object type CHAR 1 0 OBART
1 Planned order
2 Purchase requisition
3 Reservation
4 Production order
6 Simulation order
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSC PLSCN
SBNUM Simulation requirements number NUMC 10 0 SBNUM
KBNKZ Kanban Indicator CHAR 1 0 KBNKZ
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
Z Scheduling Agreement for JIT calls
KAPFX Indicator: Capacity for Planned Order is Dispatched CHAR 1 0 KAPFX
SEQNR Sequence Number Order NUMC 14 0 CY_SEQNR
PSTTI Planned Order Start Time TIMS 6 0 PSTTI
PEDTI Planned Order End Time TIMS 6 0 PEDTI
MONKZ Indicator: For Assembly Order Procedures CHAR 1 0 MONKZ
PRNKZ Ind.: Leading order in collective order is planned ordre CHAR 1 0 PRNKZ
MDPBV Planned order: confirmation of availability CHAR 1 0 MDPBV
Availability not checked
1 Availability checked, not confirmed
2 Availability checked, partially confirmed
3 Availability checked, fully confirmed
VFMNG Planned order: committed quantity QUAN 13 3 VFMNG
MDACH Action Control: Planned Order Processing CHAR 2 0 T46AC MDACH
MDACC Action: planned order processing CHAR 4 0 T46AS MDACC
MDACD Date of action: planned order DATS 8 0 MDACD
MDACT Time of action: Planned order processing TIMS 6 0 MDACT
GSBTR Planned Order Total Commitment Date According to ATP Check DATS 8 0 GSBTR_PLAF
PLETX Planned order shift quantities exist CHAR 1 0 PLETX
PRSCH Planned order: scheduling using production dates CHAR 1 0 MD_PRSCHED
LVSCH Planned order: leading scheduling level (determines dates) CHAR 1 0 MD_LVSCHED
KZAVC Indicator for type of availability check CHAR 1 0 KZAVC
1 ATP check
2 Check against preliminary planning
VRPLA Indicator: planning without final assembly CHAR 1 0 VRPLA
PBDNR Requirements Plan CHAR 10 0 PBDNR
AGREQ Requirements totaling CHAR 1 0 AGREQ
No totaling of dependent requirements
X Totaling of dependent requirements
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
ERFME Unit of entry UNIT 3 0 T006 ERFME
RQNUM Requirements record number NUMC 10 0 RQNUM
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
WEMNG Quantity of Goods Received QUAN 13 3 WEMNG
WAMNG Issued Quantity QUAN 13 3 WAMNG
EDGNO Internal number for edge of object dependencies tree NUMC 17 0 M60I EDGNO
LBLKZ Subcontracting Supplier CHAR 1 0 LBLKZ
EMLIF Supplier to be Supplied/Who is to Receive Delivery CHAR 10 0 EMLIF
BERID MRP Area CHAR 10 0 MDLV BERID
UBERI Issuing MRP area when transferring stock CHAR 10 0 UBERI
EMATN Material number corresponding to manufacturer part number CHAR 40 0 EMATN
REMFL Repetitive Manufacturing indicator CHAR 1 0 REMFL
PSTMP Last Change to Planned Order: Time Stamp DEC 15 0 PSTMP
PUSER Last Change to Planned Order: User CHAR 12 0 PUSER
BADI Object change via active Business Add-In CHAR 1 0 MD_BADI
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 CHAR 2 0 MD_STAEX
01 Alternative explosion (IPPE) active
02 Bulk material items not exploded
RESLO Issuing Storage Location for Stock Transport Order CHAR 4 0 T001L RESLO
SRM_CONTRACT_ID Central Contract CHAR 10 0 SRM_CONTRACT_ID
SRM_CONTRACT_ITM Central Contract Item Number NUMC 10 0 SRM_CONTRACT_ITEM
ORG_REQ_DATE Receipt/Requirements date DATS 8 0 DAT00
PTEXT Planned Order Text CHAR 255 0 PP_PLORD_TEXT
DUMMY_PLAF_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
MEDKZ Indicator for Distributed Planned Order CHAR 1 0 MEDKZ
Not Distribution-Relevant
X Distributed
CNFQTY Total Confirmed Qty Planned Order (Repetitive Manufacturing) QUAN 13 3 MD_MES_CNF_QTY
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
BOM_VERSN BOM Version CHAR 4 0 CS_VERSN
DAC_PP_COMPONENT Component ID in Extended Passport (EPP) CHAR 32 0 EPP_COMPONENT_ID
DAC_INDIRECT_ACCESS Digital Access: Object was created indirectly CHAR 1 0 DAC_INDIRECT_ACCESS
X Information that creation was triggered by external request
DAC_CREATION_DATE System Date DATS 8 0 SYDATUM
M_MRP Checkbox CHAR 1 0 XFELD
No
X Yes
KUNNR Customer Number CHAR 10 0 KUNNR
FLG_BUNDLE Indicates Bundle Information Maintained CHAR 1 0 FLG_BUNDLE
FSH_MPLND_ORD Master Planned Order Number CHAR 12 0 FSH_MPLO_ORD
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SEASONS FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SEASONS FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 FSH_COLLECTIONS FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEMES FSH_THEME
ATRKZ Request ID CHAR 1 0 ATRKZ
Standard request
B TOI - Order (created using BAPI)
E MOP - Order (previously EOG)
L LPP - Order
M Multi-Item Order
T Segmentation Order
U Original Order
Z Combined Order
DPS_HANDOVER_TIME Time for Handover to Detailed Planning And Scheduling DEC 15 0 SYPP_DPS_HANDOVER_TIME

PLAF foreign key relationships

Table Field Check Table Check Field
0 PLAF AUFNR SAFK Run Schedule Master Data MANDT
0 PLAF AUFNR SAFK Run Schedule Master Data AUFNR
1 PLAF BERID MDLV Customizing MRP Area MANDT
1 PLAF BERID MDLV Customizing MRP Area BERID
0 PLAF DISPO T024D MRP Controllers MANDT
0 PLAF DISPO T024D MRP Controllers WERKS
0 PLAF DISPO T024D MRP Controllers DISPO
1 PLAF EDGNO M60I Object dependencies tree structure for chars planning MANDT
0 PLAF EKORG T024E Purchasing Organizations EKORG
1 PLAF ERFME T006 Units of Measurement MANDT
0 PLAF FLIEF LFA1 Supplier Master (General Section) MANDT
0 PLAF FLIEF LFA1 Supplier Master (General Section) LIFNR
1 PLAF FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_SEASON_YEAR
1 PLAF FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_SEASON
1 PLAF FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_COLLECTION
0 PLAF FSH_SEASON FSH_SEASONS Database table for FSH Seasons FSH_SEASON_YEAR
0 PLAF FSH_SEASON FSH_SEASONS Database table for FSH Seasons FSH_SEASON
1 PLAF FSH_SEASON_YEAR FSH_SEASONS Database table for FSH Seasons FSH_SEASON_YEAR
1 PLAF FSH_SEASON_YEAR FSH_SEASONS Database table for FSH Seasons FSH_SEASON
0 PLAF FSH_THEME FSH_THEMES Database table for FSH Themes FSH_SEASON_YEAR
0 PLAF FSH_THEME FSH_THEMES Database table for FSH Themes FSH_SEASON
0 PLAF FSH_THEME FSH_THEMES Database table for FSH Themes FSH_COLLECTION
0 PLAF FSH_THEME FSH_THEMES Database table for FSH Themes FSH_THEME
1 PLAF KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 PLAF KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 PLAF KONNR EKKO Purchasing Document Header MANDT
0 PLAF KONNR EKKO Purchasing Document Header EBELN
1 PLAF KTPNR EKPO Purchasing Document Item MANDT
1 PLAF KTPNR EKPO Purchasing Document Item EBELN
0 PLAF LGORT T001L Storage Locations MANDT
0 PLAF LGORT T001L Storage Locations WERKS
1 PLAF MATNR MARA General Material Data MANDT
1 PLAF MATNR MARA General Material Data MATNR
0 PLAF MDACC T46AS Action code text MANDT
0 PLAF MDACC T46AS Action code text MDACC
1 PLAF MDACH T46AC Action control MANDT
1 PLAF MDACH T46AC Action control MDACH
1 PLAF MDACH T46AC Action control ACCFM
1 PLAF MDACH T46AC Action control ACCTO
0 PLAF MEINS T006 Units of Measurement MANDT
0 PLAF MEINS T006 Units of Measurement MSEHI
1 PLAF PLGRP T024F Production scheduler WERKS
0 PLAF PLSCN PLSC Planning scenarios in long-term planning MANDT
1 PLAF PLWRK T001W Plants/Branches MANDT
1 PLAF PLWRK T001W Plants/Branches WERKS
0 PLAF PWWRK T001W Plants/Branches MANDT
0 PLAF PWWRK T001W Plants/Branches WERKS
1 PLAF RESLO T001L Storage Locations MANDT
1 PLAF RESLO T001L Storage Locations WERKS
0 PLAF SERNR SNUM BOM explosion number MANDT
1 PLAF SOBKZ T148 Special Stock Indicator MANDT
1 PLAF SOBKZ T148 Special Stock Indicator SOBKZ
0 PLAF STSTA T415S BOM status MANDT
1 PLAF VERID MKAL Production Versions of Material WERKS
1 PLAF VERID MKAL Production Versions of Material VERID
0 PLAF VERTO T437V Distribution key in MRP MANDT
0 PLAF VERTO T437V Distribution key in MRP WERKS