C_RFM_ManageMasterPlndOrder

DDL: C_RFM_MANAGEMASTERPLNDORDER Type: view_entity CONSUMPTION
25 Fields 1 Data Sources 1 Associations

Manage Master Planned Order

C_RFM_ManageMasterPlndOrder is a Consumption CDS View that provides data about "Manage Master Planned Order" in SAP S/4HANA. It reads from 1 data source (R_RFM_ManageMasterPlndOrdTP) and exposes 25 fields with key field MasterPlannedOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_RFM_ManageMasterPlndOrdTP R_RFM_ManageMasterPlndOrdTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_RFM_MngMasterPlndOrdComp _Component $projection.MasterPlannedOrder = _Component.MasterPlannedOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Master Planned 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 MasterPlannedOrder view
Search.searchable true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MasterPlannedOrder MasterPlannedOrder
CombinedPlannedOrder CombinedPlannedOrder
MRPController MRPController MRP Controller
MRPPlant MRPPlant Plant
PlannedOrderType PlannedOrderType
PlannedOrderCategory PlannedOrderCategory
ProductionPlant ProductionPlant Prod plnt
PlannedOrderTypeName PlannedOrderTypeName
PlannedOrderCategoryName PlannedOrderCategoryName
ProductionPlantName ProductionPlantName
MRPPlantName MRPPlantName
MRPControllerName MRPControllerName Controller name
virtualPlannedOrderOpeningDatepertr
virtualPlndOrderPlannedStartDatepsttr
virtualPlndOrderPlannedEndDatepedtr
virtualProductmatnr
virtualProductNamemaktx
virtualFashionGenericMaterialNamemaktx
virtualPlannedTotalQtyInBaseUnitgsmng
virtualBaseUnitmeins
virtualPlannedOrderplnum
virtualSalesOrderkdauf
char1
virtualMaterialGroupmatkl
_Component _Component

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_ManageMasterPlndOrder.
-- 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_ManageMasterPlndOrder AS
SELECT
  MasterPlannedOrder,
  CombinedPlannedOrder,
  MRPController,
  MRPPlant,
  PlannedOrderType,
  PlannedOrderCategory,
  ProductionPlant,
  PlannedOrderTypeName,
  PlannedOrderCategoryName,
  ProductionPlantName,
  MRPPlantName,
  MRPControllerName,
  virtual PlannedOrderOpeningDate : pertr AS virtualPlannedOrderOpeningDatepertr,
  virtual PlndOrderPlannedStartDate : psttr AS virtualPlndOrderPlannedStartDatepsttr,
  virtual PlndOrderPlannedEndDate : pedtr AS virtualPlndOrderPlannedEndDatepedtr,
  virtual Product : matnr AS virtualProductmatnr,
  virtual ProductName : maktx AS virtualProductNamemaktx,
  virtual FashionGenericMaterialName : maktx AS virtualFashionGenericMaterialNamemaktx,
  virtual PlannedTotalQtyInBaseUnit : gsmng AS virtualPlannedTotalQtyInBaseUnitgsmng,
  virtual BaseUnit : meins AS virtualBaseUnitmeins,
  virtual PlannedOrder : plnum AS virtualPlannedOrderplnum,
  virtual SalesOrder : kdauf AS virtualSalesOrderkdauf,
  virtual GenericProductIsFilled : abap.char(1) AS char1,
  virtual MaterialGroup : matkl AS virtualMaterialGroupmatkl
FROM R_RFM_ManageMasterPlndOrdTP
LEFT OUTER JOIN C_RFM_MngMasterPlndOrdComp AS _Component ON MasterPlannedOrder = _Component.MasterPlannedOrder  -- association [0..*]
;

Learn More