A_ChangeRecordReferencePSV

DDL: A_CHANGERECORDREFERENCEPSV Type: view_entity COMPOSITE Package: VDM_PLMB_CR_O

Product Structure Variant

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

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 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'
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
}