C_RFM_ManageMasterMfgOrder

DDL: C_RFM_MANAGEMASTERMFGORDER Type: view_entity CONSUMPTION

Manage Master Manufacturing Order

C_RFM_ManageMasterMfgOrder is a Consumption CDS View that provides data about "Manage Master Manufacturing Order" in SAP S/4HANA. It reads from 1 data source (R_RFM_ManageMasterMfgOrderTP) and exposes 44 fields with key field MasterProductionOrder. It has 2 associations to related views. It is exposed through 1 OData service (UI_RFM_MNG_MSTRPRODNORD). It is used in 1 Fiori application: Manage Master Production Orders – Fashion.

Data Sources (1)

SourceAliasJoin Type
R_RFM_ManageMasterMfgOrderTP R_RFM_ManageMasterMfgOrderTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_RFM_MasterMfgOrdOpComponents _Comp $projection.MasterProductionOrder = _Comp.MasterProductionOrder
[0..*] C_RFM_MasterMfgOrdOpSchedule _Oper $projection.MasterProductionOrder = _Oper.MasterProductionOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Master Manufacturing Order view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.representativeKey MasterProductionOrder view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_MNG_MSTRPRODNORD UI_RFM_MNG_MSTRPRODNORD V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5678 Manage Master Production Orders – Fashion Transactional

Manage Master Production Orders – Fashion

Business Role: Production Supervisor - Discrete Manufacturing (Retail)

With this app, you can view the details of production orders at master, individual and combined production order levels. In addition, you can use this app to create master production orders from individual production orders and combined production orders from master production orders.

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY MasterProductionOrder MasterProductionOrder
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ProductionPlant ProductionPlant Prod plnt
CombinedProductionOrder CombinedProductionOrder
virtualPlantNamewerks_name
virtualFashionGenericMaterialNamemaktx
virtualMaterialmatnr
virtualMaterialNamemaktx
virtualProductionUnitproductionunit
virtualMfgOrderConfirmedYieldQtyco_igmng
virtualMfgOrderConfirmedScrapQtyco_iasmg
virtualMfgOrderConfirmedReworkQtyrmnga
virtualActualDeliveredQuantityco_wemng
virtualOrderOpenQuantityopenquan
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
char1
int2
int2
int2
int2
int2
int2
int2
char1
char1
char1
char1
char1
virtualManufacturingOrderaufnr
virtualMRPPlantco_pwerk
virtualMaterialGroupmatkl
virtualGenericProductIsFilledboolean
_Comp _Comp
_Oper _Oper

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_RFM_ManageMasterMfgOrder.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_RFM_ManageMasterMfgOrder AS
SELECT
  MasterProductionOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  CombinedProductionOrder,
  virtual PlantName : werks_name AS virtualPlantNamewerks_name,
  virtual FashionGenericMaterialName : maktx AS virtualFashionGenericMaterialNamemaktx,
  virtual Material : matnr AS virtualMaterialmatnr,
  virtual MaterialName : maktx AS virtualMaterialNamemaktx,
  virtual ProductionUnit : productionunit AS virtualProductionUnitproductionunit,
  virtual MfgOrderConfirmedYieldQty : co_igmng AS virtualMfgOrderConfirmedYieldQtyco_igmng,
  virtual MfgOrderConfirmedScrapQty : co_iasmg AS virtualMfgOrderConfirmedScrapQtyco_iasmg,
  virtual MfgOrderConfirmedReworkQty : rmnga AS virtualMfgOrderConfirmedReworkQtyrmnga,
  virtual ActualDeliveredQuantity : co_wemng AS virtualActualDeliveredQuantityco_wemng,
  virtual OrderOpenQuantity : openquan AS virtualOrderOpenQuantityopenquan,
  virtual OrderIsCreated : abap.char( 1) AS char1,
  virtual CreatedStatusQtyInPercent : abap.int2 AS int2,
  virtual ManufacturingOrder : aufnr AS virtualManufacturingOrderaufnr,
  virtual MRPPlant : co_pwerk AS virtualMRPPlantco_pwerk,
  virtual MaterialGroup : matkl AS virtualMaterialGroupmatkl,
  virtual GenericProductIsFilled : boolean AS virtualGenericProductIsFilledboolean
FROM R_RFM_ManageMasterMfgOrderTP
LEFT OUTER JOIN C_RFM_MasterMfgOrdOpComponents AS _Comp ON MasterProductionOrder = _Comp.MasterProductionOrder  -- association [0..*]
LEFT OUTER JOIN C_RFM_MasterMfgOrdOpSchedule AS _Oper ON MasterProductionOrder = _Oper.MasterProductionOrder  -- association [0..*]
;