SAP Table

PLAF Planned Order

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

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

/ Fields

PLAF columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 MANDT
KeyPLNUM 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
BESKZ Procurement Type CHAR 1 0 BESKZ
SOBES Special procurement type CHAR 1 0 SOBES
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
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
REDKZ Reduction indicator for scheduling CHAR 1 0 REDKZ
TRMHK Scheduling source CHAR 1 0 TRMHK
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
RGEKZ Indicator: Backflushing for order CHAR 1 0 CO_RGEKZ
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
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
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
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
VRPLA Indicator: planning without final assembly CHAR 1 0 VRPLA
PBDNR Requirements Plan CHAR 10 0 PBDNR
AGREQ Requirements totaling CHAR 1 0 AGREQ
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
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
STAEX Status information on BOM explosion in planned order CHAR 2 0 MD_STAEX
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
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
DAC_CREATION_DATE System Date DATS 8 0 SYDATUM
M_MRP Checkbox CHAR 1 0 XFELD
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
DPS_HANDOVER_TIME Time for Handover to Detailed Planning And Scheduling DEC 15 0 SYPP_DPS_HANDOVER_TIME
/ Relationships

PLAF foreign keys.

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