R_ProductionOrderTP

Production Order (Transactional Procg) | view: RPRODNORDTP | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKO, AFPO, AUFK
Column Name Description
ManufacturingOrder Manufacturing Order ID
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty Manufacturing Order Planned Total Quantity
MfgOrderPlannedScrapQty Manufacturing Order Planned Scrap Quantity
MfgOrderConfirmedYieldQty Confirmed Yield Quantity From Order Confirmation
MfgOrderConfirmedScrapQty Confirmed Scrap Quantity From Order Confirmation
MfgOrderConfirmedReworkQty Total Confirmed Rework Quantity
ExpectedDeviationQuantity Expected Yield Deviation
ActualDeliveredQuantity Quantity of Goods Received for the Order Item
Column Name Description
CreationDate Order Creation Date
CreationTime Order Creation Time
LastChangeDate Change Date for Order Master
LastChangeTime Changed At
BOOExplosionDate Date for Routing Explosion
BOOValidityStartDate Valid-From Date
BOMExplosionDate Date of BOM Explosion/Routing Transfer
BOMValidityStartDate Valid-From Date
MfgOrderPlannedStartDate Manufacturing Order Planned Start Date
MfgOrderPlannedStartTime Manufacturing Order Planned Start Time
MfgOrderPlannedEndDate Manufacturing Order Planned End Date
MfgOrderPlannedEndTime Manufacturing Order Planned End Time
MfgOrderPlannedReleaseDate Manufacturing Order Planned Release Date
MfgOrderScheduledStartDate Manufacturing Order Scheduled Start Date
MfgOrderScheduledStartTime Manufacturing Order Scheduled Start Time
MfgOrderScheduledEndDate Manufacturing Order Scheduled End Date
MfgOrderScheduledEndTime Manufacturing Order Scheduled End Time
MfgOrderScheduledReleaseDate Manufacturing Order Scheduled Release Date
MfgOrderActualStartDate Manufacturing Order Actual Start Date
MfgOrderActualStartTime Manufacturing Order Actual Start Time
MfgOrderActualEndDate Manufacturing Order Actual End Date
MfgOrderActualReleaseDate Manufacturing Order Actual Release Date
MfgOrderConfirmedEndDate Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime Manufacturing Order Confirmed End Time
MfgOrderTotalCommitmentDate Total Commitment Date
MfgOrderActualCompletionDate Technical Completion Date
MfgOrderItemActualDeliveryDate Actual Delivery/Finish Date
Column Name Description
ManufacturingOrderCategory Order Category Show values
ManufacturingOrderHasLongText Long Text Exists Show values
IsMarkedForDeletion Deletion Flag Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
MfgOrderHasMultipleItems Order Has Multiple Items Show values
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
OrderIsNotCostedAutomatically Indicator: Do not cost automatically Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically Show values
ProdnProcgIsFlexible Flexible Processing Show values
InventoryUsabilityCode Inventory Usability Code Show values
CapacityRqmtHasNotToBeCreated Indicator: Do not Create Capacity Requirements Show values
BillOfMaterialCategory Bill of Material Category Code Show values
ControllingObjectClass Controlling Object Class Show values
Column Name Description Domain name
ManufacturingOrderText Manufacturing Order Text TEXT40
LongTextLanguageCode Long Text Language SPRAS
ManufacturingOrderImportance Order Importance Code CHAR1
MfgOrderHierarchyLevel Level (in multi-level BOM explosions) DEC2
CreatedByUser Entered By USNAM
LastChangedByUser Last Changed By USNAM
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
StockSegment Stock Segment SGT_SRCA
MfgOrderInternalID Order Internal ID AUFPL
SuperiorOrder Number of Superior Order AUFNR
MRPArea MRP Area BERID
ProductionVersion Production Version VERID
Reservation Number of reservation/dependent requirements RSNUM
SettlementReservation Settlement Reservation RSNUM
MfgOrderConfirmation Completion confirmation number for the operation CO_RUECK
NumberOfMfgOrderConfirmations Number Of Confirmations CIM_COUNT
PlannedOrder Planned Order PLNUM
CapacityRequirement ID of the Capacity Requirements Record BEDID
InspectionLot Inspection Lot Number QPLOS
ForecastSchedulingType Forecast Scheduling Type TERART
ProductConfiguration Product Configuration CUOBJ
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
CapacityActiveVersion Version of Available Capacity KAPVERSION
OrderSequenceNumber Sequence Number Order CY_SEQNR
BillOfOperationsType Bill of Operations Type PLNTY
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BOOInternalVersionCounter Internal counter CIM_COUNT
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterial Bill Of Material PPH_STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialVersion BOM Version CS_VERSN
ProductCostCollector Cost Collector for Production Process AUFNR
ActualCostsCostingVariant Costing Variant For Actual Costs KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
Master Data Relations Join Conditions
Basic Scheduling Type
  • Basic Scheduling Type
  • Client
  • R_PRODUCTIONORDERTP.BASICSCHEDULINGTYPE == T482.TERMKZ
  • R_PRODUCTIONORDERTP.MANDT == T482.MANDT
Batch Number
  • ?
  • Client
  • Batch Number
  • Product Number
  • R_PRODUCTIONORDERTP.[column in domain "WERKS_D"] == MCHA.WERKS
  • R_PRODUCTIONORDERTP.MANDT == MCHA.MANDT
  • R_PRODUCTIONORDERTP.BATCH == MCHA.CHARG
  • R_PRODUCTIONORDERTP.PRODUCT == MCHA.MATNR
BOM Usage
  • Client
  • BOM Usage
  • R_PRODUCTIONORDERTP.MANDT == T416.MANDT
  • R_PRODUCTIONORDERTP.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Bill of Operations Material
  • Client
  • Bill of Operations Material
  • R_PRODUCTIONORDERTP.MANDT == MARA.MANDT
  • R_PRODUCTIONORDERTP.BILLOFOPERATIONSMATERIAL == MARA.MATNR
Task List Usage
  • Client
  • Bill of Operations Usage
  • R_PRODUCTIONORDERTP.MANDT == T411.MANDT
  • R_PRODUCTIONORDERTP.BILLOFOPERATIONSUSAGE == T411.VERWE
Business Area
  • Client
  • Business Area
  • R_PRODUCTIONORDERTP.MANDT == TGSB.MANDT
  • R_PRODUCTIONORDERTP.BUSINESSAREA == TGSB.GSBER
Change Number
  • Change Number
  • Client
  • R_PRODUCTIONORDERTP.CHANGENUMBER == AENR.AENNR
  • R_PRODUCTIONORDERTP.MANDT == AENR.MANDT
Company Code
  • Client
  • Company Code
  • R_PRODUCTIONORDERTP.MANDT == T001.MANDT
  • R_PRODUCTIONORDERTP.COMPANYCODE == T001.BUKRS
Application R_PRODUCTIONORDERTP.CONDITIONAPPLICATION == T681A.KAPPL
Controlling Area
  • Controlling Area
  • Client
  • R_PRODUCTIONORDERTP.CONTROLLINGAREA == TKA01.KOKRS
  • R_PRODUCTIONORDERTP.MANDT == TKA01.MANDT
Cost Center for Basic Settlement
  • ?
  • Controlling Area
  • Client
  • Cost Center for Basic Settlement
  • R_PRODUCTIONORDERTP.[column in domain "DATBI"] == CSKS.DATBI
  • R_PRODUCTIONORDERTP.CONTROLLINGAREA == CSKS.KOKRS
  • R_PRODUCTIONORDERTP.MANDT == CSKS.MANDT
  • R_PRODUCTIONORDERTP.COSTCENTER == CSKS.KOSTL
Settlement Cost Element
  • ?
  • Controlling Area
  • Client
  • Settlement Cost Element
  • R_PRODUCTIONORDERTP.[column in domain "DATBI"] == CSKB.DATBI
  • R_PRODUCTIONORDERTP.CONTROLLINGAREA == CSKB.KOKRS
  • R_PRODUCTIONORDERTP.MANDT == CSKB.MANDT
  • R_PRODUCTIONORDERTP.COSTELEMENT == CSKB.KSTAR
Costing Sheet
  • Application
  • Client
  • ?
  • Costing Sheet
  • R_PRODUCTIONORDERTP.CONDITIONAPPLICATION == T683.KAPPL
  • R_PRODUCTIONORDERTP.MANDT == T683.MANDT
  • R_PRODUCTIONORDERTP.[column in domain "KVEWE"] == T683.KVEWE
  • R_PRODUCTIONORDERTP.COSTINGSHEET == T683.KALSM
Order Currency
  • Client
  • Order Currency
  • R_PRODUCTIONORDERTP.MANDT == TCURC.MANDT
  • R_PRODUCTIONORDERTP.CURRENCY == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • R_PRODUCTIONORDERTP.MANDT == TFKB.MANDT
  • R_PRODUCTIONORDERTP.FUNCTIONALAREA == TFKB.FKBER
G/L Account for Basic Settlement
  • Client
  • G/L Account for Basic Settlement
  • Company Code
  • R_PRODUCTIONORDERTP.MANDT == SKB1.MANDT
  • R_PRODUCTIONORDERTP.GLACCOUNT == SKB1.SAKNR
  • R_PRODUCTIONORDERTP.COMPANYCODE == SKB1.BUKRS
Leading Order in Current Processing
  • Client
  • Leading Order in Current Processing
  • R_PRODUCTIONORDERTP.MANDT == AUFK.MANDT
  • R_PRODUCTIONORDERTP.LEADINGORDER == AUFK.AUFNR
Order Type
  • Order Type
  • Client
  • R_PRODUCTIONORDERTP.MANUFACTURINGORDERTYPE == T003O.AUART
  • R_PRODUCTIONORDERTP.MANDT == T003O.CLIENT
MRP Controller Group
  • Client
  • MRP Controller
  • Production Plant
  • R_PRODUCTIONORDERTP.MANDT == T024D.MANDT
  • R_PRODUCTIONORDERTP.MRPCONTROLLER == T024D.DISPO
  • R_PRODUCTIONORDERTP.PRODUCTIONPLANT == T024D.WERKS
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • R_PRODUCTIONORDERTP.MANDT == T001W.MANDT
  • R_PRODUCTIONORDERTP.PLANNINGPLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • R_PRODUCTIONORDERTP.MANDT == MARA.MANDT
  • R_PRODUCTIONORDERTP.PRODUCT == MARA.MATNR
Production Plant
  • Client
  • Production Plant
  • R_PRODUCTIONORDERTP.MANDT == T001W.MANDT
  • R_PRODUCTIONORDERTP.PRODUCTIONPLANT == T001W.WERKS
Production Scheduling Profile
  • Client
  • Production Scheduling Profile
  • Production Plant
  • R_PRODUCTIONORDERTP.MANDT == TCO43.MANDT
  • R_PRODUCTIONORDERTP.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
  • R_PRODUCTIONORDERTP.PRODUCTIONPLANT == TCO43.WERKS
Production Supervisor
  • Client
  • Production Supervisor
  • Production Plant
  • R_PRODUCTIONORDERTP.MANDT == T024F.MANDT
  • R_PRODUCTIONORDERTP.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • R_PRODUCTIONORDERTP.PRODUCTIONPLANT == T024F.WERKS
Production Unit of Measure
  • Client
  • Production Unit of Measure
  • R_PRODUCTIONORDERTP.MANDT == T006.MANDT
  • R_PRODUCTIONORDERTP.PRODUCTIONUNIT == T006.MSEHI
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • R_PRODUCTIONORDERTP.[column in domain "DATBI"] == CEPC.DATBI
  • R_PRODUCTIONORDERTP.CONTROLLINGAREA == CEPC.KOKRS
  • R_PRODUCTIONORDERTP.MANDT == CEPC.MANDT
  • R_PRODUCTIONORDERTP.PROFITCENTER == CEPC.PRCTR
MRP Distribution Key
  • ?
  • Client
  • MRP Distribution Key
  • R_PRODUCTIONORDERTP.[column in domain "WERKS_D"] == T437V.WERKS
  • R_PRODUCTIONORDERTP.MANDT == T437V.MANDT
  • R_PRODUCTIONORDERTP.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
Reference Order Number
  • Client
  • Reference Order Number
  • R_PRODUCTIONORDERTP.MANDT == AUFK.MANDT
  • R_PRODUCTIONORDERTP.REFERENCEORDER == AUFK.AUFNR
Responsible Cost Center
  • ?
  • Controlling Area
  • Responsible Cost Center
  • Client
  • R_PRODUCTIONORDERTP.[column in domain "DATBI"] == CSKS.DATBI
  • R_PRODUCTIONORDERTP.CONTROLLINGAREA == CSKS.KOKRS
  • R_PRODUCTIONORDERTP.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • R_PRODUCTIONORDERTP.MANDT == CSKS.MANDT
Storage Location
  • Storage Location
  • Client
  • Planning Plant for an Order
  • R_PRODUCTIONORDERTP.STORAGELOCATION == T001L.LGORT
  • R_PRODUCTIONORDERTP.MANDT == T001L.MANDT
  • R_PRODUCTIONORDERTP.PLANNINGPLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Client
  • Responsible Planner Group or Department
  • Production Plant
  • R_PRODUCTIONORDERTP.MANDT == T024A.MANDT
  • R_PRODUCTIONORDERTP.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • R_PRODUCTIONORDERTP.PRODUCTIONPLANT == T024A.WERKS