I_RFM_MasterMfgOrderDuration

DDL: I_RFM_MASTERMFGORDERDURATION SQL: IRFMMASTERORDDUR Type: view COMPOSITE
11 Fields 1 Data Sources

Master Order Duration

I_RFM_MasterMfgOrderDuration is a Composite CDS View that provides data about "Master Order Duration" in SAP S/4HANA. It reads from 1 data source (I_LogisticsOrder) and exposes 11 fields with key field MasterProductionOrder.

Data Sources (1)

SourceAliasJoin Type
I_LogisticsOrder _Duration inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IRFMMASTERORDDUR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.representativeKey MasterProductionOrder view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #COMPOSITE view
EndUserText.label Master Order Duration view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MasterProductionOrder _RFM_MasterProductOrder MasterProductionOrder Master Prod. Ord.
CombinedProductionOrder _RFM_MasterProductOrder CombinedProductionOrder Combined Production Order
ManufacturingOrderCategory
ManufacturingOrderType I_LogisticsOrder OrderType Order Type
ProductionPlant
CreatedByUser _RFM_MasterProductOrder CreatedByUser User Name
CreationDate _RFM_MasterProductOrder CreationDate Time Stamp
CreationTime _RFM_MasterProductOrder CreationTime Time of Change
LastChangedByUser _RFM_MasterProductOrder LastChangedByUser User Name
LastChangeDate _RFM_MasterProductOrder LastChangeDate Time Stamp
LastChangeTime _RFM_MasterProductOrder LastChangeTime Time changed

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 I_RFM_MasterMfgOrderDuration.
-- 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.
-- SQL view name: IRFMMASTERORDDUR

CREATE VIEW I_RFM_MasterMfgOrderDuration AS
SELECT
  _RFM_MasterProductOrder.MasterProductionOrder AS MasterProductionOrder,
  _RFM_MasterProductOrder.CombinedProductionOrder AS CombinedProductionOrder,
  (cast ('10' as abap.numc(2))) AS ManufacturingOrderCategory,
  _Duration.OrderType AS ManufacturingOrderType,
  cast(_Duration.Plant as pwwrk preserving type) AS ProductionPlant,
  _RFM_MasterProductOrder.CreatedByUser AS CreatedByUser,
  _RFM_MasterProductOrder.CreationDate AS CreationDate,
  _RFM_MasterProductOrder.CreationTime AS CreationTime,
  _RFM_MasterProductOrder.LastChangedByUser AS LastChangedByUser,
  _RFM_MasterProductOrder.LastChangeDate AS LastChangeDate,
  _RFM_MasterProductOrder.LastChangeTime AS LastChangeTime
INNER JOIN I_LogisticsOrder AS _Duration ON /* join condition not captured in parsed metadata */
;

Learn More