I_MfgOrdOpDatesBySemKeyStdVH

DDL: I_MFGORDOPDATESBYSEMKEYSTDVH SQL: IMOODATESBSK_VH Type: view COMPOSITE

Manufacturing Order Operation Dates By Semantic Key

I_MfgOrdOpDatesBySemKeyStdVH is a Composite CDS View that provides data about "Manufacturing Order Operation Dates By Semantic Key" in SAP S/4HANA. It reads from 1 data source (I_MfgOrdOpBySemanticKeyStdVH) and exposes 19 fields with key fields ManufacturingOrder, ManufacturingOrderSequence, ManufacturingOrderOperation. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrdOpBySemanticKeyStdVH I_MfgOrdOpBySemanticKeyStdVH from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_OrderOperationDatesQty _OrderOperationDatesQty $projection.OrderInternalID = _OrderOperationDatesQty.OrderInternalID and $projection.OrderOperationInternalID = _OrderOperationDatesQty.OrderOperationInternalID
[1..1] I_UnitOfMeasure _OperationUnit $projection.operationunit = _OperationUnit.UnitOfMeasure

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMOODATESBSK_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ManufacturingOrderOperation view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Manufacturing Order Operation Dates By Semantic Key view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder
KEY ManufacturingOrderSequence ManufacturingOrderSequence
KEY ManufacturingOrderOperation ManufacturingOrderOperation
ManufacturingOrderText ManufacturingOrderText
MfgOrderOperationText MfgOrderOperationText
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ProductionPlant ProductionPlant
OrderInternalID OrderInternalID
OrderOperationInternalID OrderOperationInternalID
Material Material
MaterialName
OpActualExecutionStartDate _OrderOperationDatesQty OpActualExecutionStartDate
OpActualExecutionStartTime _OrderOperationDatesQty OpActualExecutionStartTime
OpPlannedTotalQuantity _OrderOperationDatesQty OpPlannedTotalQuantity
OperationUnit _OrderOperationDatesQty OperationUnit
_MfgOrder _MfgOrder
_MfgOrderSequence _MfgOrderSequence
_OperationUnit _OperationUnit 
@AbapCatalog.sqlViewName: 'IMOODATESBSK_VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'ManufacturingOrderOperation'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Manufacturing Order Operation Dates By Semantic Key'

define view I_MfgOrdOpDatesBySemKeyStdVH as select from I_MfgOrdOpBySemanticKeyStdVH 
  association [1..1] to I_OrderOperationDatesQty as _OrderOperationDatesQty on  $projection.OrderInternalID = _OrderOperationDatesQty.OrderInternalID
                                                                            and $projection.OrderOperationInternalID = _OrderOperationDatesQty.OrderOperationInternalID
  association [1..1] to I_UnitOfMeasure          as _OperationUnit          on  $projection.operationunit = _OperationUnit.UnitOfMeasure  
{

  @ObjectModel.text.element: ['ManufacturingOrderText']
  @ObjectModel.foreignKey.association: '_MfgOrder'
  key ManufacturingOrder,
  @ObjectModel.foreignKey.association: '_MfgOrderSequence'
  key ManufacturingOrderSequence,
  @ObjectModel.text.element: ['MfgOrderOperationText']
  key ManufacturingOrderOperation,
  @Semantics.text: true
  ManufacturingOrderText,
  @Semantics.text: true
  MfgOrderOperationText,
  //@Consumption.hidden: true

  ManufacturingOrderCategory,
  @Consumption.hidden: true
  ManufacturingOrderType,
  @Consumption.hidden: true
  ProductionPlant,
  @Consumption.hidden: true
  OrderInternalID,
  @Consumption.hidden: true
  OrderOperationInternalID,
  Material,
  _MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName as MaterialName,
  //_MaterialText[1: Language=$session.system_language].MaterialName as MaterialName,

 
  _OrderOperationDatesQty.OpActualExecutionStartDate,
  _OrderOperationDatesQty.OpActualExecutionStartTime,
  @Semantics.quantity.unitOfMeasure: 'OperationUnit'
  //@DefaultAggregation: #SUM

  _OrderOperationDatesQty.OpPlannedTotalQuantity,
  @Semantics.unitOfMeasure: true  
  _OrderOperationDatesQty.OperationUnit,

  @Consumption.hidden: true
  _MfgOrder,
  @Consumption.hidden: true
  _MfgOrderSequence,
  @Consumption.hidden: true
  _OperationUnit
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDER",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_MFGORDOPBYSEMANTICKEYSTDVH",
"I_ORDEROPERATIONDATESQTY"
],
"ASSOCIATED":
[
"I_MANUFACTURINGORDER",
"I_MANUFACTURINGORDERSEQUENCE",
"I_ORDEROPERATIONDATESQTY",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MFGORDOPBYSEMANTICKEYSTDVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More