I_CHGRECDWBSBILLOFMATTP_2

CDS View

Chg Record WBS BOM

I_CHGRECDWBSBILLOFMATTP_2 is a CDS View in S/4HANA. Chg Record WBS BOM. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ChgRecdWBSElmntBOM view_entity from COMPOSITE WBS BOM assign to Chg Records 
@AbapCatalog.sqlViewName: 'ICHGRECDWBSBMTP2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Chg Record WBS BOM'
define view I_ChgRecdWBSBillOfMatTP_2
  as select from           I_ChangeRecdRefWBSElmntBOMBsc as reference_bom

    left outer to one join I_ProjectBOMLink              as BOMLink on  reference_bom.ChgRecRefInternalKey1 = BOMLink.BillOfMaterialCategory
                                                                    and reference_bom.ChgRecRefInternalKey2 = BOMLink.BillOfMaterial
                                                                    and reference_bom.ChgRecRefInternalKey3 = BOMLink.BillOfMaterialVariant
  association        to parent I_ChangeRecordTP_2  as _ChangeRecordAPITP on $projection.ChangeRecordUUID = _ChangeRecordAPITP.ChangeRecordUUID
  association [1..1] to I_ChangeRecordDraftTP      as _ChangeRecordTP    on $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefWBSElmntBOMBsc as _WBSBOMExtension   on $projection.ChangeRecordReferenceUUID = _WBSBOMExtension.ChangeRecordReferenceUUID

{

  key        reference_bom.ChangeRecordReferenceUUID,
             case
               when BOMLink.WBSElementInternalID is null then cast(SUBSTRING( reference_bom.ChangeRecordReference, 1, 8) as ps_s4_pspnr )
               else cast(BOMLink.WBSElementInternalID as ps_s4_pspnr )
               end                                                      as WBSElementInternalID,
             case
               when BOMLink.Material is null then cast(SUBSTRING( reference_bom.ChangeRecordReference, 9, 40) as matnr)
               else cast(BOMLink.Material as matnr)
               end                                                      as Material,
             case
              when BOMLink.Plant is null then  cast(SUBSTRING( reference_bom.ChangeRecordReference, 49, 4) as werks_d)
              else cast(BOMLink.Plant as werks_d)
              end                                                       as Plant,
             case
              when BOMLink.BillOfMaterialVariantUsage is null then cast (SUBSTRING( reference_bom.ChangeRecordReference, 53, 1) as stlan)
              else cast(BOMLink.BillOfMaterialVariantUsage as stlan)
              end                                                       as BillOfMaterialVariantUsage,
             case
              when BOMLink.BillOfMaterialVariant is null then cast(SUBSTRING( reference_bom.ChangeRecordReference, 54, 2) as stalt)
              else cast(BOMLink.BillOfMaterialVariant as stalt)

              end                                                       as BillOfMaterialVariant,

             reference_bom.ChangeRecordUUID,
             reference_bom.ChangeRecord,
             reference_bom.ChangeRecordReferenceType,
             reference_bom.ChangeRecordReferenceSubtype,
             reference_bom.ChangeRecordReference,
             reference_bom.ParentChangeRecordRefUUID,
             reference_bom.IsMainReference,
             BOMLink.BillOfMaterialCategory,
             reference_bom.ChangeNumber,
             reference_bom.CreatedByUser,
             reference_bom.CreationDateTime,
             reference_bom.LastChangedByUser,
             reference_bom.LastChangeDateTime,
             reference_bom.ChangeRecordItemRelevance,
             reference_bom.ChangeRecordVirtualRefInd,

             cast( BOMLink.BillOfMaterial as cs_stlnr preserving type ) as BillOfMaterial,
             reference_bom.ChangeRecordRefObjectUUID,
             reference_bom.ChangeRecordItemProcgStatus,
             _ChangeRecordTP,
             _ChangeRecordAPITP
}
where
  reference_bom.ChangeRecordReferenceType = 'WBM'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECDREFWBSELMNTBOMBSC",
"I_PROJECTBOMLINK"
],
"ASSOCIATED":
[
"E_CHGRECDREFWBSELMNTBOMBSC",
"I_CHANGERECORDDRAFTTP",
"I_CHANGERECORDTP_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More