I_ChgRecdRefMfgBOMTP

DDL: I_CHGRECDREFMFGBOMTP SQL: ICRREFMFGBOMTP Type: view TRANSACTIONAL

Change Record Reference MBOM

I_ChgRecdRefMfgBOMTP is a Transactional CDS View that provides data about "Change Record Reference MBOM" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefMBOM) and exposes 36 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

1 data source(s) 36 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefMBOM ManufacturingBOM from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
[0..1] E_ChgRecdRefMfgBOMBsc _MfgBOMExtension $projection.ChangeRecordReferenceUUID = _MfgBOMExtension.ChangeRecordReferenceUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICRREFMFGBOMTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Change Record Reference MBOM view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PLMCRREFMBOM_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
Material Material
Plant Plant
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterialVariant BillOfMaterialVariant
BillOfMaterialVersion BillOfMaterialVersion
ChgRecdReasonForChange ChgRecdReasonForChange
ExpdCompltnDte ExpdCompltnDte
ChgRecdAuthznGrpText ChgRecdAuthznGrpText
ChgRecdNmbrChgSts ChgRecdNmbrChgSts
ChangeNumber ChangeNumber
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID
ChangeRecordReference ChangeRecordReference
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
IsMainReference IsMainReference
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus
ChgRecdItmTgtSts ChgRecdItmTgtSts
ChgRecdItmDSgntr ChgRecdItmDSgntr
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus
BillOfMaterialHeaderUUID
BillOfMaterialUUID
BillOfMaterial I_ChgRecdRefMBOM BillOfMaterial
BillOfMaterialCategory I_ChgRecdRefMBOM BillOfMaterialCategory
IsVersionBillOfMaterial
BOMVersionStatus
BillOfMaterialStatus
_ChangeRecord _ChangeRecord 
@AbapCatalog.sqlViewName: 'ICRREFMFGBOMTP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Change Record Reference MBOM'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: { semanticKey: ['Material','Plant','BillOfMaterialVariantUsage','BillOfMaterialVariant','BillOfMaterialVersion'],
                writeDraftPersistence: 'PLMCRREFMBOM_D',
                createEnabled,
                deleteEnabled,
                updateEnabled
              }

@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}

define view I_ChgRecdRefMfgBOMTP
  as select from I_ChgRecdRefMBOM as ManufacturingBOM
  association [1..1] to I_ChangeRecordDraftTP as _ChangeRecord    on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefMfgBOMBsc as _MfgBOMExtension on $projection.ChangeRecordReferenceUUID = _MfgBOMExtension.ChangeRecordReferenceUUID

{
  key ChangeRecordReferenceUUID,
      Material,
      Plant,
      BillOfMaterialVariantUsage,
      BillOfMaterialVariant,
      BillOfMaterialVersion,
      ChgRecdReasonForChange,
      ExpdCompltnDte,
      ChgRecdAuthznGrpText,
      ChgRecdNmbrChgSts,
      ChangeNumber,

      ChangeRecordUUID,
      @ObjectModel.readOnly:true
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordRefObjectUUID,
      ChangeRecordReference,
      ParentChangeRecordRefUUID,
      IsMainReference,
      @Semantics.user.createdBy: true
      @ObjectModel.readOnly:true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      @ObjectModel.readOnly:true
      LastChangedByUser,
      LastChangeDateTime,
      ChangeRecordItemRelevance,
      ChangeRecordVirtualRefInd,
      ChangeRecordItemProcgStatus,
      ChgRecdItmTgtSts,
      ChgRecdItmDSgntr,
      ChgRecdCurrentItemProcgStatus,
      @ObjectModel.readOnly: true
      cast(hextobin('00000000000000000000000000000000') as cs_guidb)                                                 as BillOfMaterialHeaderUUID,
      @ObjectModel.readOnly:true
      concat(concat(concat(BillOfMaterial,BillOfMaterialCategory),BillOfMaterialVariantUsage),BillOfMaterialVariant) as BillOfMaterialUUID,
      @ObjectModel.readOnly: true
      ManufacturingBOM.BillOfMaterial,
      ManufacturingBOM.BillOfMaterialCategory,
      cast('' as cs_versnind)                                                                                        as IsVersionBillOfMaterial,
      cast('' as cs_versnst)                                                                                         as BOMVersionStatus,
      cast('' as stlst)                                                                                              as BillOfMaterialStatus,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecord
}

Learn More