P_CHGRECDREFBOMITMVIRT

CDS View

Private view for BOM Item Reference (Virtual)

P_CHGRECDREFBOMITMVIRT is a CDS View in S/4HANA. Private view for BOM Item Reference (Virtual). It contains 35 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 35 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefBOMItmDataMigrtn view union_all COMPOSITE Change Record Reference BIT Data Mgrtn
P_ChgRecdRefBOMItm view from TRANSACTIONAL Private view for BOM Item Reference

Fields (35)

KeyField CDS FieldsUsed in Views
_ChangeRecordBsc _ChangeRecordBsc 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialComponent BillOfMaterialComponent 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
BillOfMaterialItemUUID BillOfMaterialItemUUID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordUUID ChangeRecordUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdDataMigrationStatus ChgRecdDataMigrationStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecRefInternalKey1 1
ChgRecRefInternalKey2 ChgRecRefInternalKey2 1
ChgRecRefInternalKey3 ChgRecRefInternalKey3 1
ChgRecRefInternalKey4 ChgRecRefInternalKey4 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Material Material 1
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 1
Plant Plant 1 
@AbapCatalog.sqlViewName: 'PCRREFBOMITMVT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_ChgRecdRefBOMItmVirt
  as select from I_ChgRecdRefBOMItmBsc as reference_bit
{
  key        ChangeRecordReferenceUUID,

             cast(SUBSTRING( reference_bit.ChangeRecordReference, 1, 40) as matnr)            as Material,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 41, 4) as werks_d)          as Plant,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 45, 1) as stlan)            as BillOfMaterialVariantUsage,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 46, 2) as stalt)            as BillOfMaterialVariant,
             cast ( hextobin('00000000000000000000000000000000') as cs_guid preserving type ) as BillOfMaterialItemUUID,
             cast(SUBSTRING( reference_bit.ChangeRecordReference, 48, 4) as cs_sposn)         as BillOfMaterialItemNumber,
             cast('' as idnrk)                                                                as BillOfMaterialComponent,
             cast('' as stnum)                                                                as BillOfMaterial,
             cast ('M' as stlty preserving type)                                              as BillOfMaterialCategory,

             ChangeRecordUUID,
             ChangeRecord,
             ChangeRecordReferenceType,
             ChangeRecordReferenceSubtype,
             ChangeRecordReference,
             ParentChangeRecordRefUUID,
             IsMainReference,

             ChgRecRefInternalKey1,
             ChgRecRefInternalKey2,
             ChgRecRefInternalKey3,
             ChgRecRefInternalKey4,

             ChgRecdReasonForChange,
             ExpdCompltnDte,
             ChgRecdAuthznGrpText,
             ChgRecdNmbrChgSts,
             ChangeNumber,


             ChgRecdDataMigrationStatus,
             reference_bit.ChangeRecordItemProcgStatus,
             reference_bit.ChgRecdItmTgtSts,
             reference_bit.ChgRecdItmDSgntr,
             @Semantics.user.createdBy: true
             reference_bit.CreatedByUser,
             reference_bit.CreationDateTime,
             @Semantics.user.lastChangedBy: true
             reference_bit.LastChangedByUser,
             reference_bit.LastChangeDateTime,

             ChangeRecordItemRelevance,
             ChangeRecordVirtualRefInd,

             _ChangeRecordBsc

}
where
      ChangeRecordReferenceType = 'BIT'
  and ChangeRecordVirtualRefInd = 'X'

Learn More