A_ChangeRecordReferenceMat

DDL: A_CHANGERECORDREFERENCEMAT Type: view_entity COMPOSITE

Material Assignments to Change Records

A_ChangeRecordReferenceMat is a Composite CDS View that provides data about "Material Assignments to Change Records" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordReferenceMatTP_2) and exposes 15 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordReferenceMatTP_2 I_ChangeRecordReferenceMatTP_2 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordProduct _ChangeRecordProduct $projection.Material = _ChangeRecordProduct.Product
[0..1] E_ChgRecdRefMatBsc _MatExtension $projection.ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Material Assignments to Change Records view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
ChangeRecord ChangeRecord
ChangeRecordUUID ChangeRecordUUID
ChangeRecordType ChangeRecordType
ChangeRecordReferenceType ChangeRecordReferenceType
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
Material Material
MaterialType _ChangeRecordProduct ProductType
BaseUnit _ChangeRecordProduct BaseUnit
MaterialStatus _ChangeRecordProduct CrossPlantStatus
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus
_ChangeRecord _ChangeRecord 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel: {
//   createEnabled: true,

   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #L
   }
}

@Metadata: {
  ignorePropagatedAnnotations: true
}

@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@EndUserText.label: 'Material Assignments to Change Records'
define view entity A_ChangeRecordReferenceMat
  as select from I_ChangeRecordReferenceMatTP_2
  association        to parent A_ChangeRecord as _ChangeRecord        on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
  association [1..1] to I_ChangeRecordProduct as _ChangeRecordProduct on $projection.Material = _ChangeRecordProduct.Product
  association [0..1] to E_ChgRecdRefMatBsc    as _MatExtension        on $projection.ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID
 {
  key    ChangeRecordReferenceUUID,
         ChangeRecord,
         ChangeRecordUUID,
         ChangeRecordType,
         ChangeRecordReferenceType,
         CreatedByUser,
         CreationDateTime,
         LastChangedByUser,
         case
            when LastChangeDateTime = fltp_to_dec( 0.00 as timestampl )
            then fltp_to_dec( 19720401000000.00 as timestampl )
            else LastChangeDateTime
         end                                   as LastChangeDateTime,
         Material,
         _ChangeRecordProduct.ProductType      as MaterialType,
         _ChangeRecordProduct.BaseUnit         as BaseUnit,
         _ChangeRecordProduct.CrossPlantStatus as MaterialStatus,
         ChangeRecordItemRelevance,
         ChangeRecordItemProcgStatus,
         _ChangeRecord

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDPRODUCT",
"I_CHANGERECORDREFERENCEMATTP_2"
],
"ASSOCIATED":
[
"A_CHANGERECORD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More