I_CHGRECDREFBOMITMBSC

CDS View

Change Record Reference Object BOM Item

I_CHGRECDREFBOMITMBSC is a CDS View in S/4HANA. Change Record Reference Object BOM Item. It contains 28 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 28 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_ChgRecdRefBITAfterDataMigrtn view from COMPOSITE
P_ChgRecdRefBITBfrDataMigrtn view from COMPOSITE
P_ChgRecdRefBOMItmDataMigrtn view from COMPOSITE
P_ChgRecdRefBOMItmVirt view from COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 3
_ChangeRecordBsc _ChangeRecordBsc 3
ChangeNumber ChangeNumber 2
ChangeRecord ChangeRecord 3
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 3
ChangeRecordItemRelevance ChangeRecordItemRelevance 3
ChangeRecordReference ChangeRecordReference 3
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 3
ChangeRecordReferenceType ChangeRecordReferenceType 3
ChangeRecordUUID ChangeRecordUUID 3
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 3
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 2
ChgRecdDataMigrationStatus ChgRecdDataMigrationStatus 2
ChgRecdItmDSgntr ChgRecdItmDSgntr 3
ChgRecdItmTgtSts ChgRecdItmTgtSts 3
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 2
ChgRecdReasonForChange ChgRecdReasonForChange 2
ChgRecRefInternalKey1 ChgRecRefInternalKey1 3
ChgRecRefInternalKey2 ChgRecRefInternalKey2 3
ChgRecRefInternalKey3 ChgRecRefInternalKey3 3
ChgRecRefInternalKey4 ChgRecRefInternalKey4 3
CreatedByUser CreatedByUser 4
CreationDateTime CreationDateTime 4
ExpdCompltnDte ExpdCompltnDte 2
IsMainReference IsMainReference 3
LastChangeDateTime LastChangeDateTime 4
LastChangedByUser LastChangedByUser 4
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 3 
@AbapCatalog.sqlViewName: 'ICHGRECDREFBOMIB'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Object BOM Item'
define view I_ChgRecdRefBOMItmBsc
  as select from           /iam/d_i_obj_ref as reference
    inner join             /iam/d_i_root    as root          on  reference.parent_key = root.db_key
                                                             and root.application     = 'CR'
                                                             and root.issue_category  = 'CR'
    left outer to one join /plmi/cr_itm_ext as reference_ext on reference.db_key = reference_ext.parent_key
  association [1..1] to I_ChangeRecordBsc as _ChangeRecordBsc on $projection.ChangeRecordUUID = _ChangeRecordBsc.ChangeRecordUUID


{
  key       reference.db_key                           as ChangeRecordReferenceUUID,

            root.issue_id                              as ChangeRecord,
            reference.parent_key                       as ChangeRecordUUID,

            reference.type_cd                          as ChangeRecordReferenceType,
            reference.subtype_cd                       as ChangeRecordReferenceSubtype,
            reference.id                               as ChangeRecordReference,
            reference.par_objref_uuid                  as ParentChangeRecordRefUUID,
            reference.main_ref_ind                     as IsMainReference,
            reference.internal_id1                     as ChgRecRefInternalKey1,
            reference.internal_id2                     as ChgRecRefInternalKey2,
            reference.internal_id3                     as ChgRecRefInternalKey3,
            reference.internal_id4                     as ChgRecRefInternalKey4,
            //            reference.internal_guid             as     ChgRecRefInternalGUID,

            //            reference_ext.customer_no         as ChangeRecordReferenceCustNo,


            @Semantics.user.createdBy: true
            reference.created_by                       as CreatedByUser,
            cast( reference.created_on  as tzntstmps ) as CreationDateTime,
            @Semantics.user.lastChangedBy: true
            reference.changed_by                       as LastChangedByUser,
            cast( reference.changed_on  as tzntstmps ) as LastChangeDateTime,
            reference.virtual_ref_ind                  as ChangeRecordVirtualRefInd,
            reference.item_rel                         as ChangeRecordItemRelevance,
            reference_ext.sdm_status                   as ChgRecdDataMigrationStatus,
            reference_ext.itm_status                   as ChangeRecordItemProcgStatus,
            reference_ext.tgt_proc_status              as ChgRecdItmTgtSts,
            reference_ext.dig_sign                     as ChgRecdItmDSgntr,
            reference_ext.reasonforchange              as ChgRecdReasonForChange,
            reference_ext.expected_comp_dat            as ExpdCompltnDte,
            reference_ext.auth_group                   as ChgRecdAuthznGrpText,
            reference_ext.chgstatus                    as ChgRecdNmbrChgSts,
            reference_ext.changenumber                 as ChangeNumber,

            @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
            _ChangeRecordBsc
}
where
  type_cd = 'BIT'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/IAM/D_I_OBJ_REF",
"/IAM/D_I_ROOT",
"/PLMI/CR_ITM_EXT"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More