I_RoutingHeader

DDL: I_ROUTINGHEADER SQL: IRTGHDR Type: view_entity BASIC Package: VDM_PP_MD_RTG

Routing Header Details

I_RoutingHeader is a Basic CDS View (Dimension) that provides data about "Routing Header Details" in SAP S/4HANA. It reads from 1 data source (I_MfgBillOfOperationsChgSt) and exposes 40 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BOOInternalVersionCounter. It has 1 association to related views. Part of development package VDM_PP_MD_RTG.

1 data source(s) 40 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgBillOfOperationsChgSt I_MfgBillOfOperationsChgSt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TaskListLongText _LongText $projection.BillOfOperationsType = _LongText.TaskListType and $projection.BillOfOperationsGroup = _LongText.TaskListGroup and $projection.BillOfOperationsVariant = _LongText.TaskListGroupCounter and $projection.BOOInternalVersionCounter = _LongText.TaskListVersionCounter and $projection.LongTextLanguageCode is not null

Annotations (9)

NameValueLevelField
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey BOOInternalVersionCounter view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Routing Header Details view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType BillOfOperationsType
KEY BillOfOperationsGroup BillOfOperationsGroup
KEY BillOfOperationsVariant BillOfOperationsVariant
KEY BOOInternalVersionCounter BOOInternalVersionCounter
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
ChangeNumber ChangeNumber
IsMarkedForDeletion IsMarkedForDeletion
IsDeleted IsDeleted
IsImplicitlyDeleted IsImplicitlyDeleted
BillOfOperationsDesc BillOfOperationsDesc
LongTextLanguageCode LongTextLanguageCode
Plant Plant
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsStatus BillOfOperationsStatus
MinimumLotSizeQuantity MinimumLotSizeQuantity
MaximumLotSizeQuantity MaximumLotSizeQuantity
BillOfOperationsUnit BillOfOperationsUnit
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ChangedDateTime ChangedDateTime
PlainLongText _LongText PlainLongText
ResponsiblePlannerGroup ResponsiblePlannerGroup
WorkCenterTypeCode WorkCenterTypeCode
WorkCenterInternalID WorkCenterInternalID
ReplacedBillOfOperations ReplacedBillOfOperations
_BillOfOperations _BillOfOperations
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsUsage _BillOfOperationsUsage
_BillOfOperationsStatus _BillOfOperationsStatus
_BillOfOperationsUnit _BillOfOperationsUnit
_Plant _Plant
_LongTextLanguage _LongTextLanguage
_ChangeMaster _ChangeMaster
_ResponsiblePlannerGroup _ResponsiblePlannerGroup
_WorkCenter _WorkCenter
_WorkCenterType _WorkCenterType 
//@AbapCatalog.sqlViewName: 'IRTGHDR'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@VDM.viewType: #BASIC
@Analytics: {dataCategory: #DIMENSION}
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'BOOInternalVersionCounter'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Routing Header Details'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@Metadata.allowExtensions: true
//define view I_RoutingHeader

define view entity I_RoutingHeader
  as select from I_MfgBillOfOperationsChgSt
  association [0..1] to I_TaskListLongText as _LongText on  $projection.BillOfOperationsType      = _LongText.TaskListType
                                                        and $projection.BillOfOperationsGroup     = _LongText.TaskListGroup
                                                        and $projection.BillOfOperationsVariant   = _LongText.TaskListGroupCounter
                                                        and $projection.BOOInternalVersionCounter = _LongText.TaskListVersionCounter
                                                        and $projection.LongTextLanguageCode      is not null
{
  key BillOfOperationsType,
  key BillOfOperationsGroup,
  key BillOfOperationsVariant,
  key BOOInternalVersionCounter,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      ChangeNumber,
      IsMarkedForDeletion, //DELKZ

      IsDeleted,           //LOEKZ

      IsImplicitlyDeleted, //LOEKZ_INHERITED

      @Semantics.text: true
      BillOfOperationsDesc,
      @ObjectModel.foreignKey.association: '_LongTextLanguage'
      LongTextLanguageCode,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_BillOfOperationsUsage'
      BillOfOperationsUsage,
      @ObjectModel.foreignKey.association: '_BillOfOperationsStatus'
      BillOfOperationsStatus,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      @DefaultAggregation: #MIN
      MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      @DefaultAggregation: #MAX
      MaximumLotSizeQuantity,
      //      @Semantics.unitOfMeasure: true

      BillOfOperationsUnit,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      ChangedDateTime,
      //      @Consumption.hidden: true

      _LongText.PlainLongText,
      @ObjectModel.foreignKey.association: '_ResponsiblePlannerGroup'
      ResponsiblePlannerGroup,
      @ObjectModel.foreignKey.association: '_WorkCenterType'
      WorkCenterTypeCode,
      @ObjectModel.foreignKey.association: '_WorkCenter'
      WorkCenterInternalID,
      ReplacedBillOfOperations,

      /*    Associations    */
      _BillOfOperations,
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperationsUsage,
      _BillOfOperationsStatus,
      _BillOfOperationsUnit,
      _Plant,
      _LongTextLanguage,
      _ChangeMaster,
      _ResponsiblePlannerGroup,
      /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
      _WorkCenter,
      /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
      _WorkCenterType
}
where
      BillOfOperationsType =  'N'
  and ValidityEndDate      >= ValidityStartDate

Learn More