A_ChangeRecordReferencePSV

DDL: A_CHANGERECORDREFERENCEPSV Type: view_entity COMPOSITE

Product Structure Variant Assignments to Change Records

A_ChangeRecordReferencePSV is a Composite CDS View that provides data about "Product Structure Variant Assignments to Change Records" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefProdStrucVarTP_2) and exposes 18 fields with key field ChangeRecordReferenceUUID.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefProdStrucVarTP_2 I_ChgRecdRefProdStrucVarTP_2 from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK 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 Product Structure Variant Assignments to Change Records view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
ChangeRecordUUID ChangeRecordUUID
ChangeRecord ChangeRecord
ChangeRecordReferenceType ChangeRecordReferenceType
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
Material Material
Class Class
ProductStructureNodeName ProductStructureNodeName
ProdStrucNodeDescription ProdStrucNodeDescription
ProductStructureVariantName ProductStructureVariantName
ProdStrucVariantDescription ProdStrucVariantDescription
ProdStrucVariantChangeNumber ProdStrucVariantChangeNumber
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID
_ChangeRecord _ChangeRecord 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
//   createEnabled: true,

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

@Metadata: {
  ignorePropagatedAnnotations: true
}

@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@EndUserText.label: 'Product Structure Variant Assignments to Change Records'
define view entity A_ChangeRecordReferencePSV
  as select from I_ChgRecdRefProdStrucVarTP_2 
  association to parent A_ChangeRecord as _ChangeRecord on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

{
  key    ChangeRecordReferenceUUID,
         ChangeRecordUUID,
         ChangeRecord,
         ChangeRecordReferenceType,
         CreatedByUser,
         CreationDateTime,
         LastChangedByUser,
         LastChangeDateTime,
         Material,
         Class,
         ProductStructureNodeName,
         ProdStrucNodeDescription,
         ProductStructureVariantName,
         ProdStrucVariantDescription,
         ProdStrucVariantChangeNumber,
         ChangeRecordItemRelevance,
         ChangeRecordRefObjectUUID,           
         _ChangeRecord
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFPRODSTRUCVARTP_2"
],
"ASSOCIATED":
[
"A_CHANGERECORD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More