P_ChgRecdRefBOMItmDataMigrtn

DDL: P_CHGRECDREFBOMITMDATAMIGRTN SQL: PCHGRECREFBITMDM Type: view COMPOSITE

P_ChgRecdRefBOMItmDataMigrtn is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefBOMItmBsc) and exposes 26 fields with key field ChangeRecordReferenceUUID.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefBOMItmBsc reference_bit from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCHGRECREFBITMDM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefBOMItmBsc ChangeRecordReferenceUUID
Material
Plant
BillOfMaterialVariantUsage
BillOfMaterialVariant
BillOfMaterialItemNumber
BillOfMaterialComponent BOMItem BillOfMaterialComponent
BillOfMaterial
ChangeRecord I_ChgRecdRefBOMItmBsc ChangeRecord
ChangeRecordUUID I_ChgRecdRefBOMItmBsc ChangeRecordUUID
ChangeRecordReferenceType I_ChgRecdRefBOMItmBsc ChangeRecordReferenceType
ChangeRecordReferenceSubtype I_ChgRecdRefBOMItmBsc ChangeRecordReferenceSubtype
ChangeRecordReference I_ChgRecdRefBOMItmBsc ChangeRecordReference
ParentChangeRecordRefUUID I_ChgRecdRefBOMItmBsc ParentChangeRecordRefUUID
IsMainReference I_ChgRecdRefBOMItmBsc IsMainReference
ChgRecRefInternalKey1 I_ChgRecdRefBOMItmBsc ChgRecRefInternalKey1
ChgRecRefInternalKey2 I_ChgRecdRefBOMItmBsc ChgRecRefInternalKey2
ChgRecRefInternalKey3 I_ChgRecdRefBOMItmBsc ChgRecRefInternalKey3
ChgRecRefInternalKey4 I_ChgRecdRefBOMItmBsc ChgRecRefInternalKey4
CreatedByUser I_ChgRecdRefBOMItmBsc CreatedByUser
CreationDateTime I_ChgRecdRefBOMItmBsc CreationDateTime
LastChangedByUser I_ChgRecdRefBOMItmBsc LastChangedByUser
LastChangeDateTime I_ChgRecdRefBOMItmBsc LastChangeDateTime
ChangeRecordVirtualRefInd I_ChgRecdRefBOMItmBsc ChangeRecordVirtualRefInd
ChangeRecordItemRelevance I_ChgRecdRefBOMItmBsc ChangeRecordItemRelevance
_ChangeRecordBsc I_ChgRecdRefBOMItmBsc _ChangeRecordBsc 
@AbapCatalog.sqlViewName: 'PCHGRECREFBITMDM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefBOMItmDataMigrtn
  as select from           I_ChgRecdRefBOMItmBsc    as reference_bit
    left outer to one join I_ChgRecdRefBOMComponent as BOMItem on  reference_bit.ChgRecRefInternalKey1 = BOMItem.BillOfMaterialCategory
                                                               and reference_bit.ChgRecRefInternalKey2 = BOMItem.BillOfMaterial
                                                               and reference_bit.ChgRecRefInternalKey3 = BOMItem.BillOfMaterialVariant
                                                               and reference_bit.ChgRecRefInternalKey4 = BOMItem.BillOfMaterialItemNumber

{
  key       reference_bit.ChangeRecordReferenceUUID,
            BOMItem._MaterialBOMLink.Material,
            BOMItem._MaterialBOMLink.Plant,
            BOMItem._MaterialBOMLink.BillOfMaterialVariantUsage,
            BOMItem._MaterialBOMLink.BillOfMaterialVariant,
            cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) as BillOfMaterialItemNumber,
            BOMItem.BillOfMaterialComponent,
            cast( BOMItem.BillOfMaterial as cs_stlnr preserving type )           as BillOfMaterial,
            reference_bit.ChangeRecord,
            reference_bit.ChangeRecordUUID,
            reference_bit.ChangeRecordReferenceType,
            reference_bit.ChangeRecordReferenceSubtype,
            reference_bit.ChangeRecordReference,
            reference_bit.ParentChangeRecordRefUUID,
            reference_bit.IsMainReference,
            reference_bit.ChgRecRefInternalKey1,
            reference_bit.ChgRecRefInternalKey2,
            reference_bit.ChgRecRefInternalKey3,
            reference_bit.ChgRecRefInternalKey4,
            reference_bit.CreatedByUser,
            reference_bit.CreationDateTime,
            reference_bit.LastChangedByUser,
            reference_bit.LastChangeDateTime,
            reference_bit.ChangeRecordVirtualRefInd,
            reference_bit.ChangeRecordItemRelevance,
            case
              when ( reference_bit.ChgRecdDataMigrationStatus is null or
              reference_bit.ChgRecdDataMigrationStatus is initial )
              then cast( '00' as /plmb/cr_sdm_status )
              else reference_bit.ChgRecdDataMigrationStatus
            end                                                                  as ChgRecdDataMigrationStatus,
            reference_bit._ChangeRecordBsc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFBOMCOMPONENT",
"I_CHGRECDREFBOMITMBSC",
"I_MATERIALBOMLINK"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[
"I_CHGRECDREFBOMITMBSC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More