SAP table MPPA (View of planned order (MPS))

Field Description Data Type Length Decimals Checktable Data Element
OBART Object type CHAR 1 0 OBART
1 Planned order
2 Purchase requisition
3 Reservation
4 Production order
6 Simulation order
PLNUM Planned Order CHAR 10 0 PLNUM
PLWRK Planning Plant CHAR 4 0 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
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 time in days DEC 3 0 WEBAZ
LGORT Storage location CHAR 4 0 T001L LGORT_D
AUFFX Indicator: Fixing of Lot Size in Planned Order CHAR 1 0 FIX01
STLFX Indicator: fixing explosion in planned order CHAR 1 0 FIX02
UMSKZ Planned Order Conversion Indicator CHAR 1 0 PLUMS
EKORG Purchasing organization CHAR 4 0 T024E EKORG
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
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
PSPEL WBS Element NUMC 8 0 PRPS PS_POSNR
AKTAL Current explosion available CHAR 1 0 AKTAL
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
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
REVLV Revision Level CHAR 2 0 REVLV
VERID Production Version CHAR 4 0 MKAL VERID
STLAN BOM Usage CHAR 1 0 STLAN
STALT Alternative BOM CHAR 2 0 STALT
STSTA Bill of Material Status NUMC 2 0 STLST
VERTO Distribution key for quantity produced CHAR 4 0 T437V SA_VERTO
AUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
AENNR Change Number CHAR 12 0 AENR AENNR
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 !
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
EBELN Agreement Number CHAR 10 0 EKKO EVRTN
EBELP Agreement Item NUMC 5 0 EKPO EVRTP
QUNUM Number of quota arrangement CHAR 10 0 QUNUM
QUPOS Quota arrangement item NUMC 3 0 QUPOS
AKTFT Indicator "Detailed scheduling available" CHAR 1 0 AKTFT
BEDID ID of the Capacity Requirements Record NUMC 12 0 BEDID
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
AKTRT -INVALID FOR S/4- Indicator: "schedg rates of prodn" avail. CHAR 1 0 AKTRT
RATID -INVALID FOR S/4- Index for the rslts of schedg prod. rates NUMC 12 0 RATID
RATER -INVALID FOR S/4- Schedg error in schedg production rates CHAR 2 0 RATER
AKTGT -INVALID FOR S/4- Indicator: "rough-cut schedg available" CHAR 1 0 AKTGT
GROID -INVALID FOR S/4- Index for rough scheduling results NUMC 12 0 GROID
GROER -INVALID FOR S/4- Scheduling error in rough scheduling CHAR 2 0 GROER
PRNKZ Ind.: Leading order in collective order is planned ordre CHAR 1 0 PRNKZ
KAPFX Indicator: Capacity for Planned Order is Dispatched CHAR 1 0 KAPFX
VRPLA Indicator: planning without final assembly CHAR 1 0 VRPLA
PBDNR Requirements Plan CHAR 10 0 PBDNR
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
WAMNG Issued Quantity QUAN 13 3 WAMNG
WEMNG Quantity of Goods Received QUAN 13 3 WEMNG
PLANR Planning segment number CHAR 20 0 PLANR
PLAAB Material requirements planning segment NUMC 2 0 PLAAB
EMATN Material number corresponding to manufacturer part number CHAR 40 0 EMATN
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
SRM_CONTRACT_ID Central Contract CHAR 10 0 SRM_CONTRACT_ID
SRM_CONTRACT_ITM Central Contract Item Number NUMC 10 0 SRM_CONTRACT_ITEM
BOM_VERSN BOM Version CHAR 4 0 CS_VERSN
KUNNR Customer Number CHAR 10 0 KUNNR

MPPA foreign key relationships

Table Field Check Table Check Field
0 MPPA AENNR AENR Change Master AENNR
1 MPPA AUFNR SAFK Run Schedule Master Data MANDT
1 MPPA AUFNR SAFK Run Schedule Master Data AUFNR
0 MPPA EBELN EKKO Purchasing Document Header EBELN
1 MPPA EBELP EKPO Purchasing Document Item MANDT
1 MPPA EBELP EKPO Purchasing Document Item EBELN
0 MPPA EKORG T024E Purchasing Organizations EKORG
1 MPPA FLIEF LFA1 Supplier Master (General Section) MANDT
1 MPPA FLIEF LFA1 Supplier Master (General Section) LIFNR
0 MPPA KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
0 MPPA KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
1 MPPA KONNR EKKO Purchasing Document Header EBELN
0 MPPA KTPNR EKPO Purchasing Document Item MANDT
0 MPPA KTPNR EKPO Purchasing Document Item EBELN
1 MPPA LGORT T001L Storage Locations MANDT
1 MPPA LGORT T001L Storage Locations WERKS
0 MPPA PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 MPPA PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 MPPA PWWRK T001W Plants/Branches MANDT
1 MPPA PWWRK T001W Plants/Branches WERKS
0 MPPA SERNR SNUM BOM explosion number MANDT
1 MPPA SOBKZ T148 Special Stock Indicator MANDT
1 MPPA SOBKZ T148 Special Stock Indicator SOBKZ
0 MPPA VERID MKAL Production Versions of Material WERKS
0 MPPA VERID MKAL Production Versions of Material VERID
1 MPPA VERTO T437V Distribution key in MRP MANDT
1 MPPA VERTO T437V Distribution key in MRP WERKS