P_MaintPlngBcktOrderComponent

Auxiliary View for Order Components in Planning Bucket | view: PMNTPLGBKTCOMP | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, AFIH, AFKO, RESB, AFKO, AFVC, EBAN, EKKO, JEST, FM01, AUFK, AUFK, RSADD, RSDB, AUFK, EAM_MOPEXCPHASEA, EAM_MOPEXCPHASET, MARA, MAKT, T430, T001W, T001K, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
MaintenanceOrder FK Order Number
MaintenanceOrderOperation Operation/Activity Number
MaintenanceOrderComponent BOM item number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
RequirementQuantityInBaseUnit Requirement Quantity
WithdrawnQuantity Withdrawn Quantity
ConfirmedAvailableQuantity Available Quantity
Column Name Description
RequirementDate Requirements date for the component
RequirementTime Time that reservation quantity required
DeliveryDate Item delivery date
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
MaintOrdProcessPhaseCode Process Phase Show values
OperationExternalProcessing Operation External Processing Type Show values
MaintOpExecStageGroupCode PRE MAIN POST - Grouping Show values
MaintOrdCompCmtdQtyIsKept Keep Committed Quantities of Stock Components Show values
Column Name Description Domain name
MaintenanceOrderSubOperation Operation/Activity Number VORNR
ComponentDescription Material Description TEXT40
MaintenanceOrderDesc Description TEXT40
OperationDescription Operation Short Text TEXT40
PurReqnAssgdToMaintOrderOp Purchase Requisition Number BANFN
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
MaintOpExecStageShortText Description of Maintenance Operation Execution Stage TEXT30
MaintOpExecutionStageName Short Name of Maintenance Operation Execution Stage TEXT10
PurchaseRequisition Purchase Requisition Number BANFN
Supplier Account Number of Supplier LIFNR
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
ReservationType Record type RSART
ServicePerformer Service Performer BU_PARTNER
MaintOrdCompAvailyCritltyCode null
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter Internal counter CIM_COUNT
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == T006.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.BASEUNIT == T006.MSEHI
Fixed Vendor
  • Fixed Vendor
  • Client
  • P_MAINTPLNGBCKTORDERCOMPONENT.FIXEDSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == LFA1.MANDT
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == T156.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.GOODSMOVEMENTTYPE == T156.BWART
Item category (bill of material)
  • Client
  • Item category (bill of material)
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == T418.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.ITEMCATEGORY == T418.POSTP
Order Number
  • Client
  • Order Number
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == AUFK.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.MAINTENANCEORDER == AUFK.AUFNR
Material Number
  • Material Number
  • Material Number
  • Client
  • P_MAINTPLNGBCKTORDERCOMPONENT.MATERIAL == MARA.MATNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.PRODUCT == MARA.MATNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == MARA.MANDT
Account Number of Supplier
  • Client
  • Supplier
  • Account Number of Supplier
  • Account Number of Supplier
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == LFA1.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.PURCHASEORDERSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.PREFERREDSUPPLIER == LFA1.LIFNR
Vendor
  • Client
  • Supplier
  • Account Number of Supplier
  • Account Number of Supplier
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == LFA1.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.PURCHASEORDERSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.PREFERREDSUPPLIER == LFA1.LIFNR
Material Number
  • Material Number
  • Material Number
  • Client
  • P_MAINTPLNGBCKTORDERCOMPONENT.MATERIAL == MARA.MATNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.PRODUCT == MARA.MATNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_MAINTPLNGBCKTORDERCOMPONENT.PRODUCTGROUP == T023.MATKL
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == T134.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.PRODUCTTYPE == T134.MTART
Product Type P_MAINTPLNGBCKTORDERCOMPONENT.PRODUCTTYPECODE == CMD_PRDTYPE.PROD_TYPE_CODE
Supplier
  • Client
  • Supplier
  • Account Number of Supplier
  • Account Number of Supplier
  • P_MAINTPLNGBCKTORDERCOMPONENT.MANDT == LFA1.MANDT
  • P_MAINTPLNGBCKTORDERCOMPONENT.PURCHASEORDERSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.OPERATIONSUPPLIER == LFA1.LIFNR
  • P_MAINTPLNGBCKTORDERCOMPONENT.PREFERREDSUPPLIER == LFA1.LIFNR