1. Home
  2. Resources
  3. SAP Tables
  4. MPPA - View of planned order (MPS)

SAP Table MPPA

View of planned order (MPS)

MPPA (View of planned order (MPS)) 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 MPPA to other SAP tables.

MPPA table fields

Field Data element Checktable Datatype Length Decimals
OBART Object type OBART CHAR 1 0
1 Planned order
2 Purchase requisition
3 Reservation
4 Production order
6 Simulation order
PLNUM Planned order number PLNUM CHAR 10 0
PLWRK Planning Plant PLWRK 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
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 WEBAZ DEC 3 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
AUFFX Indicator: fixeing lot size in planned order FIX01 CHAR 1 0
X Yes
NULL No
STLFX Indicator: fixing explosion in planned order FIX02 CHAR 1 0
X Yes
NULL No
UMSKZ Conversion indicator for planned order PLUMS CHAR 1 0
X Yes
NULL No
EKORG Purchasing Organization EKORG T024E CHAR 4 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
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
PSPEL WBS Element PS_POSNR PRPS NUMC 8 0
AKTAL Current explosion available AKTAL CHAR 1 0
NULL Blank
. Radio button
X Selection
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 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
REVLV Revision Level REVLV CHAR 2 0
VERID Production Version VERID MKAL CHAR 4 0
STLAN BOM Usage STLAN CHAR 1 0
STALT Alternative BOM STALT CHAR 2 0
STSTA BOM status STLST NUMC 2 0
VERTO Distribution key for quantity produced SA_VERTO T437V CHAR 4 0
AUFNR Run schedule header number SA_AUFNR SAFK CHAR 12 0
AENNR Change Number AENNR AENR CHAR 12 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 !
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
EBELN Agreement Number EVRTN EKKO CHAR 10 0
EBELP Agreement Item EVRTP EKPO NUMC 5 0
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
AKTFT Indicator "Detailed scheduling available" AKTFT CHAR 1 0
X Yes
NULL No
BEDID ID of the capacity requirements record BEDID NUMC 12 0
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
AKTRT Indicator: "scheduling rates of production" available AKTRT CHAR 1 0
X Yes
NULL No
RATID Index for the results of scheduling production rates RATID 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
AKTGT Indicator: "rough-cut scheduling available" AKTGT CHAR 1 0
X Yes
NULL No
GROID Index for rough scheduling results GROID NUMC 12 0
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
PRNKZ Ind.: Leading order in collective order is planned ordre PRNKZ CHAR 1 0
X
NULL
KAPFX Indicator: capacity for planned order dispatched KAPFX CHAR 1 0
X Yes
NULL No
VRPLA Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
PBDNR Requirements Plan Number PBDNR CHAR 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
WAMNG Issued Quantity WAMNG QUAN 13 3
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
PLANR Planning segment number PLANR CHAR 20 0
PLAAB Material requirements planning segment PLAAB NUMC 2 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 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
KUNNR Customer Number KUNNR CHAR 10 0

MPPA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MPPA AENNR MPPA AENNR AENR Change Master AENNR
MPPA AENNR SYST MANDT AENR Change Master MANDT
MPPA AUFNR SYST MANDT SAFK Run Schedule Master Data MANDT
MPPA AUFNR MPPA AUFNR SAFK Run Schedule Master Data AUFNR
MPPA EBELN SYST MANDT EKKO Purchasing Document Header MANDT
MPPA EBELN MPPA EBELN EKKO Purchasing Document Header EBELN
MPPA EBELP SYST MANDT EKPO Purchasing Document Item MANDT
MPPA EBELP MPPA EBELN EKPO Purchasing Document Item EBELN
MPPA EBELP MPPA EBELP EKPO Purchasing Document Item EBELP
MPPA EKORG SYST MANDT T024E Purchasing Organizations MANDT
MPPA EKORG MPPA EKORG T024E Purchasing Organizations EKORG
MPPA FLIEF SYST MANDT LFA1 Vendor Master (General Section) MANDT
MPPA FLIEF MPPA FLIEF LFA1 Vendor Master (General Section) LIFNR
MPPA KDAUF SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MPPA KDAUF MPPA KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
MPPA KNTTP SYST MANDT T163K Account Assignment Categories in Purchasing Document MANDT
MPPA KNTTP MPPA KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
MPPA KONNR SYST MANDT EKKO Purchasing Document Header MANDT
MPPA KONNR MPPA KONNR EKKO Purchasing Document Header EBELN
MPPA KTPNR SYST MANDT EKPO Purchasing Document Item MANDT
MPPA KTPNR MPPA KONNR EKPO Purchasing Document Item EBELN
MPPA KTPNR MPPA KTPNR EKPO Purchasing Document Item EBELP
MPPA LGORT SYST MANDT T001L Storage Locations MANDT
MPPA LGORT * T001L Storage Locations WERKS
MPPA LGORT MPPA LGORT T001L Storage Locations LGORT
MPPA PSPEL SYST MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
MPPA PSPEL MPPA PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
MPPA PWWRK MPPA PWWRK T001W Plants/Branches WERKS
MPPA PWWRK SYST MANDT T001W Plants/Branches MANDT
MPPA SERNR SYST MANDT SNUM BOM explosion number MANDT
MPPA SERNR MPPA SERNR SNUM BOM explosion number SERNR
MPPA SOBKZ SYST MANDT T148 Special Stock Indicator MANDT
MPPA SOBKZ MPPA SOBKZ T148 Special Stock Indicator SOBKZ
MPPA VERID MPPA VERID MKAL Production Versions of Material VERID
MPPA VERID SYST MANDT MKAL Production Versions of Material MANDT
MPPA VERID MT61D MATNR MKAL Production Versions of Material MATNR
MPPA VERID MPPA PWWRK MKAL Production Versions of Material WERKS
MPPA VERTO SYST MANDT T437V Distribution key in MRP MANDT
MPPA VERTO MPPA PWWRK T437V Distribution key in MRP WERKS
MPPA VERTO MPPA VERTO T437V Distribution key in MRP VERTL