C_RFM_ManageMasterMfgOrder

DDL: C_RFM_MANAGEMASTERMFGORDER Type: view_entity CONSUMPTION Package: RFM_PP_MANAGE_MASTER_PROD_ORD
44 Fields 1 Data Sources 2 Associations 1 OData Services

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). Part of development package RFM_PP_MANAGE_MASTER_PROD_ORD.

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

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..*]
;

Learn More