C_ManageProductionOrder

Production Orders | view: CMANPRODNORDER | Extraction: Not supported | Component: Shop Floor Execution

Tables used: QAMV, QALS, QAMR, QAPP, QAVE, QASR, AFKO, QMFE, MPE_OAN_INSTANCE, AFPO, AUFK_TEXT, AFVC, AFFH, MPE_EXEC_HOLD, VBAK, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, JEST, ESH_SR_LTXT, PRTE, RESB, AFVC, AFVV, MARA, ADCP, ADRC, PLKZ, TCA01_SUBTYPE, KNA1, CRVD_A, DRAW, CRVE_A, AUFK, MPE_FEATURES, MARA, CRVM_A, MAKT, CRVS_A, MDLV, T024D, CRVP_A, IMPTT, T003O, T003P, T001W, PPH_PRODH_ASSGMT, CRFH, MARA, PRD_HRY_ND_VALT, T024F, MKAL, HRRP_DIRECTORY, HRRP_DIRECTORYT, HRRP_DIRECTORY, HRRP_NODE, PROJ, T482, T482T, MPE_SFI, SIT_DEF, SIT_T_DEF, PRPS, CRHD, MPE_FEATURACTIV, MPE_FEATURACTIV, TCS03

🔑 Keys (1)
💰 Amounts
∑ Quantities (12)
📅 Dates (22)
☰ Categorical (9)
Other (86)
🔗 Relations (21)

Column Name	Description
ManufacturingOrder	Order Number

Column Name	Description

Column Name	Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty	Manufacturing Order Planned Total Quantity
MfgOrderConfirmedYieldQty	Confirmed Yield Quantity From Order Confirmation
MfgOrderConfirmedScrapQty	Confirmed Scrap Quantity From Order Confirmation
OpTotalConfirmedYieldQty	Total Confirmed Yield
OpPlannedTotalQuantity	Operation Total Quantity
MfgOrderPlannedScrapQty	Manufacturing Order Planned Scrap Quantity
MfgOrderPlannedYieldQty	Planned Yield Quantity
ActualDeliveredQuantity	Quantity of Goods Received for the Order Item
MfgOrderConfirmedReworkQty	Total Confirmed Rework Quantity
OrderOpenQuantity	Open Quantity
OrderYieldDeviationQty	null
OrderMissingQuantity	null

Column Name	Description
MfgOrderScheduledStartDate	Manufacturing Order Scheduled Start Date
MfgOrderScheduledStartTime	Manufacturing Order Scheduled Start Time
MfgOrderScheduledEndDate	Manufacturing Order Scheduled End Date
MfgOrderScheduledEndTime	Manufacturing Order Scheduled End Time
MfgOrderActualStartDate	Manufacturing Order Actual Start Date
MfgOrderActualStartTime	Manufacturing Order Actual Start Time
MfgOrderActualEndDate	Manufacturing Order Actual End Date
MfgOrderConfirmedEndDate	Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime	Manufacturing Order Confirmed End Time
MfgOrderCreationDate	Order Creation Date
MfgOrderCreationTime	Order Creation Time
LastChangeDate	Change Date for Order Master
LastChangeTime	Changed At
MfgOrderPlannedStartDate	Manufacturing Order Planned Start Date
MfgOrderPlannedStartTime	Manufacturing Order Planned Start Time
MfgOrderPlannedReleaseDate	Manufacturing Order Planned Release Date
MfgOrderPlannedEndTime	Manufacturing Order Planned End Time
MfgOrderPlannedEndDate	Manufacturing Order Planned End Date
MfgOrderScheduledReleaseDate	Manufacturing Order Scheduled Release Date
MfgOrderActualReleaseDate	Manufacturing Order Actual Release Date
MfgOrderTotalCommitmentDate	Total Commitment Date
OrderStartDate	Manufacturing Order Actual Start Date

Column Name	Description
ManufacturingOrderCategory	Order Category	Show values
ProdnProcgIsFlexible	Processing Mode	Show values
ImpactedActyExecSts	Production Order Execution Status Type	Show values
ExecStsRequired	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	Show values
MfgOrderSplitStatus	Status of an Order in a Split Hierarchy	Show values
MfgOrderIsToBeDeleted	Deletion Flag	Show values
OrderHasProductionHold	Boolean Variable (X = True, - = False, Space = Unknown)	Show values
IsCloudSystem	Boolean Variable (X = True, - = False, Space = Unknown)	Show values
BOOVersionChangeRecordIsRqd	Indicator: Change Record Required	Show values

Column Name	Description	Domain name
ManufacturingOrderText	Manufacturing Order Text	TEXT40
OrderInternalBillOfOperations	Order Internal ID	AUFPL
MRPPlantName	Plant Name	TEXT30
MRPArea	MRP Area
MRPAreaText	MRP Area Text
MRPControllerName	MRP Controller Name
ProductionPlantName	Plant Name	TEXT30
ProductionSupervisorName	Production Supervisor Name	TEXT30
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSDescription	WBS Element Name	TEXT40
ProductionVersion	Production Version
ProductionVersionText	Short Text for Production Version	TEXT40
WorkCenterInternalID	String
ManufacturingOrderOperation	null
OperationText	Operation Short Text	TEXT40
MfgOrderOperationText	null
ProductionLine	Production Line for Repetitive Manufacturing	ARBPL
ManufacturingOrderImportance	Order Importance Code	CHAR1
ProdnProcgFlexibilityIndName	Short Text for Fixed Values	DDTEXT
MfgOrderSuperiorMfgOrder	Number of Superior Order	AUFNR
Customer	Customer Number
CustomerName	Name of Customer
AuthorizationGroup	Authorization Group	BRGRU
InspectionLot	null
ChangeRecord	Change Record ID	/PLMB/CR_ID
NetChangeAnalysisPath	null
ImpactedActyExecStsDesc	Impacted Operation Execution Status Description
SchedulingTypeName	Scheduling Type Description	TEXT30
OrderIsCreated	null
OrderIsReleased	null
OrderIsPrinted	null
OrderIsConfirmed	null
OrderIsPartiallyConfirmed	null
OrderIsDelivered	null
OrderIsDeleted	null
OrderIsPreCosted	null
SettlementRuleIsCreated	null
OrderIsPartiallyReleased	null
OrderIsTechnicallyCompleted	null
OrderIsClosed	null
OrderIsPartiallyDelivered	null
OrderIsLocked	null
SettlementRuleIsCrtedManually	null
OrderIsScheduled	null
OrderIsShopFloorOrder	null
OrderHasGeneratedOperations	null
OrderIsToBeHandledInBatches	null
MaterialAvailyIsNotChecked	null
OrderStatusInternalID	null
MfgOrderActualStartDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MfgOrderPlannedStartDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MfgOrderPlannedEndDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MfgOrderScheduledStartDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MfgOrderScheduledEndDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MfgOrderConfirmedEndDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
MaterialName	Material Description	TEXT40
MissingQuantityInPercent	null
OrderHasQualityIssue	null
OrderHasMissingComponents	null
OrderExecutionStartIsLate	null
OrderExecutionEndIsLate	null
ExecutionStartLatenessInHours	null
ExecutionEndLatenessInHours	null
ExecutionStartLatenessInMins	null
ExecutionEndLatenessInMinutes	null
InspHasRejectedCharc	null
InspHasRejectedInspSubset	null
InspHasRejectedInspLot	null
OperationIsConfirmed	null
ManufacturingFeature	Feature that must be Acknowledged	MPE_FEATURE
ManufacturingFeatureIsActive	null
MfgFeatureIsActiveInAnyPlant	null
ProductConfiguration	Product Configuration	CUOBJ
EffectivityParameterVariant	Parameter Variant/Standard Variant	TECHS
EffectivityParameterDesc	Effectivity Parameter Description
EffctyTypeCnctntdParamDesc	null
OrderLongText	Long Text
ManufacturingOrderTypeName	Manufacturing Order Type Name	TEXT40
SitnNumberOfInstances	null
SitnNmbrOfInstceInHierarchy	null
ProdUnivHierarchy	Product Hierarchy	UHHID
ProductHierarchyText	Hierarchy description
ProdUnivHierarchyNode	Product Hierarchy Node
ProductHierarchyNodeText	Product Hierarchy Node Value Text
OpHasAssgdProdnRsceTools	Production Resources/Tools Assigned
StockSegment	Stock Segment

Master Data Relations	Join Conditions
Basic Scheduling Type Client Basic Scheduling Type	`C_MANAGEPRODUCTIONORDER.MANDT == T482.MANDT` `C_MANAGEPRODUCTIONORDER.BASICSCHEDULINGTYPE == T482.TERMKZ`
Batch Number Material Number for Order Client Batch Number ?	`C_MANAGEPRODUCTIONORDER.MATERIAL == MCHA.MATNR` `C_MANAGEPRODUCTIONORDER.MANDT == MCHA.MANDT` `C_MANAGEPRODUCTIONORDER.BATCH == MCHA.CHARG` `C_MANAGEPRODUCTIONORDER.[column in domain "WERKS_D"] == MCHA.WERKS`
Controlling Area Client Controlling Area	`C_MANAGEPRODUCTIONORDER.MANDT == TKA01.MANDT` `C_MANAGEPRODUCTIONORDER.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center for Basic Settlement ? Cost Center for Basic Settlement Client Controlling Area	`C_MANAGEPRODUCTIONORDER.[column in domain "DATBI"] == CSKS.DATBI` `C_MANAGEPRODUCTIONORDER.COSTCENTER == CSKS.KOSTL` `C_MANAGEPRODUCTIONORDER.MANDT == CSKS.MANDT` `C_MANAGEPRODUCTIONORDER.CONTROLLINGAREA == CSKS.KOKRS`
Settlement Cost Element ? Client Controlling Area Settlement Cost Element	`C_MANAGEPRODUCTIONORDER.[column in domain "DATBI"] == CSKB.DATBI` `C_MANAGEPRODUCTIONORDER.MANDT == CSKB.MANDT` `C_MANAGEPRODUCTIONORDER.CONTROLLINGAREA == CSKB.KOKRS` `C_MANAGEPRODUCTIONORDER.COSTELEMENT == CSKB.KSTAR`
Functional Area Functional Area Client	`C_MANAGEPRODUCTIONORDER.FUNCTIONALAREA == TFKB.FKBER` `C_MANAGEPRODUCTIONORDER.MANDT == TFKB.MANDT`
G/L Account for Basic Settlement ? Client G/L Account for Basic Settlement	`C_MANAGEPRODUCTIONORDER.[column in domain "BUKRS"] == SKB1.BUKRS` `C_MANAGEPRODUCTIONORDER.MANDT == SKB1.MANDT` `C_MANAGEPRODUCTIONORDER.GLACCOUNT == SKB1.SAKNR`
Order Type Order Type Client	`C_MANAGEPRODUCTIONORDER.MANUFACTURINGORDERTYPE == T003O.AUART` `C_MANAGEPRODUCTIONORDER.MANDT == T003O.CLIENT`
Material Number for Order Material Number for Order Client	`C_MANAGEPRODUCTIONORDER.MATERIAL == MARA.MATNR` `C_MANAGEPRODUCTIONORDER.MANDT == MARA.MANDT`
MRP Controller Group MRP Controller Production Plant Client	`C_MANAGEPRODUCTIONORDER.MRPCONTROLLER == T024D.DISPO` `C_MANAGEPRODUCTIONORDER.PRODUCTIONPLANT == T024D.WERKS` `C_MANAGEPRODUCTIONORDER.MANDT == T024D.MANDT`
Planning Plant for an Order Planning Plant for an Order Client	`C_MANAGEPRODUCTIONORDER.MRPPLANT == T001W.WERKS` `C_MANAGEPRODUCTIONORDER.MANDT == T001W.MANDT`
Address time zone Address time zone Client	`C_MANAGEPRODUCTIONORDER.PLANTTIMEZONE == TTZZ.TZONE` `C_MANAGEPRODUCTIONORDER.MANDT == TTZZ.CLIENT`
Production Plant Production Plant Client	`C_MANAGEPRODUCTIONORDER.PRODUCTIONPLANT == T001W.WERKS` `C_MANAGEPRODUCTIONORDER.MANDT == T001W.MANDT`
Production Supervisor Production Supervisor Production Plant Client	`C_MANAGEPRODUCTIONORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR` `C_MANAGEPRODUCTIONORDER.PRODUCTIONPLANT == T024F.WERKS` `C_MANAGEPRODUCTIONORDER.MANDT == T024F.MANDT`
Production Unit of Measure Production Unit of Measure Client	`C_MANAGEPRODUCTIONORDER.PRODUCTIONUNIT == T006.MSEHI` `C_MANAGEPRODUCTIONORDER.MANDT == T006.MANDT`
Profit Center ? Profit Center Client Controlling Area	`C_MANAGEPRODUCTIONORDER.[column in domain "DATBI"] == CEPC.DATBI` `C_MANAGEPRODUCTIONORDER.PROFITCENTER == CEPC.PRCTR` `C_MANAGEPRODUCTIONORDER.MANDT == CEPC.MANDT` `C_MANAGEPRODUCTIONORDER.CONTROLLINGAREA == CEPC.KOKRS`
Reference Order Number Client Reference Order Number	`C_MANAGEPRODUCTIONORDER.MANDT == AUFK.MANDT` `C_MANAGEPRODUCTIONORDER.REFERENCEORDER == AUFK.AUFNR`
Responsible Cost Center Responsible Cost Center ? Client Controlling Area	`C_MANAGEPRODUCTIONORDER.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `C_MANAGEPRODUCTIONORDER.[column in domain "DATBI"] == CSKS.DATBI` `C_MANAGEPRODUCTIONORDER.MANDT == CSKS.MANDT` `C_MANAGEPRODUCTIONORDER.CONTROLLINGAREA == CSKS.KOKRS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Responsible Planner Group or Department Responsible Planner Group or Department Production Plant Client	`C_MANAGEPRODUCTIONORDER.RESPONSIBLEPLANNERGROUP == T024A.FEVOR` `C_MANAGEPRODUCTIONORDER.PRODUCTIONPLANT == T024A.WERKS` `C_MANAGEPRODUCTIONORDER.MANDT == T024A.MANDT`