I_RFM_MasterMfgOrderDuration

DDL: I_RFM_MASTERMFGORDERDURATION SQL: IRFMMASTERORDDUR Type: view COMPOSITE

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.

1 data source(s) 11 fields

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
CombinedProductionOrder _RFM_MasterProductOrder CombinedProductionOrder Combined Production Order
ManufacturingOrderCategory
ManufacturingOrderType I_LogisticsOrder OrderType
ProductionPlant
CreatedByUser _RFM_MasterProductOrder CreatedByUser
CreationDate _RFM_MasterProductOrder CreationDate
CreationTime _RFM_MasterProductOrder CreationTime
LastChangedByUser _RFM_MasterProductOrder LastChangedByUser
LastChangeDate _RFM_MasterProductOrder LastChangeDate
LastChangeTime _RFM_MasterProductOrder LastChangeTime 
@AbapCatalog.sqlViewName: 'IRFMMASTERORDDUR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@ObjectModel.representativeKey: 'MasterProductionOrder'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@Search.searchable: true
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Master Order Duration'
define view I_RFM_MasterMfgOrderDuration
  as select distinct from I_RFM_MasterProductOrder as _RFM_MasterProductOrder
    inner join            I_LogisticsOrder     as _Duration on _RFM_MasterProductOrder.MasterProductionOrder = _Duration.MasterProductionOrder
{
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key _RFM_MasterProductOrder.MasterProductionOrder,
      @EndUserText.label: 'Combined Production Order'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      _RFM_MasterProductOrder.CombinedProductionOrder,
      (cast ('10' as abap.numc(2)))  as ManufacturingOrderCategory,
      _Duration.OrderType as ManufacturingOrderType,
      cast(_Duration.Plant as pwwrk preserving type)                             as ProductionPlant,
      @Semantics.user.createdBy: true
      _RFM_MasterProductOrder.CreatedByUser,
      @Semantics.systemDate.createdAt: true
      _RFM_MasterProductOrder.CreationDate,
      @Semantics.systemTime.createdAt: true
      _RFM_MasterProductOrder.CreationTime,
      @Semantics.user.lastChangedBy: true
      _RFM_MasterProductOrder.LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      _RFM_MasterProductOrder.LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      _RFM_MasterProductOrder.LastChangeTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_RFM_MASTERPRODUCTORDER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More