A_ChangeRecordRefProdnRouting

DDL: A_CHANGERECORDREFPRODNROUTING Type: view_entity COMPOSITE Package: VDM_PLMB_CR_API

Production Routing Assignments to Change Records

A_ChangeRecordRefProdnRouting is a Composite CDS View that provides data about "Production Routing Assignments to Change Records" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecdRefProdnRtgTP_2) and exposes 13 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR_API.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecdRefProdnRtgTP_2 ChangeRecordReferenceRTGTP from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Production Routing Assignments to Change Records view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
ChangeRecord ChangeRecord
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
BillOfOperationsGroup
BillOfOperationsVariant
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_ChangeRecord _ChangeRecord
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata: {
  ignorePropagatedAnnotations: true 
}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

//@Feature: 'BF:API_FULLSCOPE'

@EndUserText.label: 'Production Routing Assignments to Change Records'
define view entity A_ChangeRecordRefProdnRouting
as select from I_ChangeRecdRefProdnRtgTP_2 as ChangeRecordReferenceRTGTP
  
 association to parent A_ChangeRecord as _ChangeRecord on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

{
  key     ChangeRecordReferenceUUID,   
          ChangeRecord,  
          ChangeRecordUUID,                 
          ChangeRecordReferenceType,
          cast (ChangeRecordReferenceRTGTP.BillOfOperationsGroup as plnnr preserving type ) as BillOfOperationsGroup,                              
          cast(ChangeRecordReferenceRTGTP.BillOfOperationsVariant as plnal preserving type) as BillOfOperationsVariant,                          
          ChangeRecordItemRelevance,  
          ChangeRecordItemProcgStatus,                                                                          
          CreatedByUser,
          CreationDateTime,
          LastChangedByUser,
          LastChangeDateTime,
          _ChangeRecord
          
          
}