C_ChgRecdRefVarBOM

DDL: C_CHGRECDREFVARBOM SQL: CCHGRCDVARBOM Type: view CONSUMPTION

Change Record Reference Var BOM

C_ChgRecdRefVarBOM is a Consumption CDS View that provides data about "Change Record Reference Var BOM" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefVarBOMTP) and exposes 49 fields. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefVarBOMTP ChangeRecordReferenceVBMTP from

Associations (9)

CardinalityTargetAliasCondition
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[0..1] C_ChgRecdVarBOMVH _ChangeRecordVarBOMVH $projection.Material = _ChangeRecordVarBOMVH.Material and $projection.Plant = _ChangeRecordVarBOMVH.Plant and $projection.BillOfMaterialVariantUsage = _ChangeRecordVarBOMVH.BillOfMaterialVariantUsage and $projection.BillOfMaterialVariant = _ChangeRecordVarBOMVH.BillOfMaterialVariant
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_PlantStdVH _Plant $projection.Plant = _Plant.Plant
[0..1] I_BillOfMaterialUsage _BillOfMaterialVariantUsage $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage and _BillOfMaterialVariantUsage.Language = $session.system_language
[1..1] C_ChangeRecordItemRelBOMVH _ChangeRecordItemRelBOMVH $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelBOMVH.ChangeRecordItemRelevance and $projection.ChangeRecordType = _ChangeRecordItemRelBOMVH.ChangeRecordType
[1..1] C_ChgRecordItemProcgStatusVH _ProcessingStatusVH $projection.ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus and $projection.ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus
[0..*] I_ChgRecdItemProcgStatusText _ProcessingStatusTxt $projection.ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus
[0..*] C_ChangeRecdDigSignStatusVH _DigSignStatusText $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CCHGRCDVARBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Change Record Reference Var BOM view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.transactionalProcessingDelegated true view
UI.headerInfo.typeName Variant BOM view
UI.headerInfo.typeNamePlural Variant BOMs view
UI.headerInfo.imageUrl ProductImageURL view
UI.headerInfo.title.value Variant view

Fields (49)

KeyFieldSource TableSource FieldDescription
keyChangeRecordReferenceUUID
ProductImageURL
Material Material
Plant Plant
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterialVariant BillOfMaterialVariant
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus Processing Status
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus
ChangeRecordLifecycleStatus _ChangeRecordObjPg ChangeRecordLifecycleStatus
ChangeRecordItemIsNotEditable _ChangeRecordObjPg ChangeRecordItemIsNotEditable
ChangeRecordItmIsAddDelEnabled _ChangeRecordObjPg ChangeRecordItmIsAddDelEnabled
ChangeRecordType _ChangeRecordObjPg ChangeRecordType
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
ChangeRecordItemRelevance
ChangeNumber ChangeNumber
MaterialName
ChangeRecordReference ChangeRecordReference
ChgRecdItemProcgStatusIsEnbld _ChangeRecordObjPg ChgRecdItemProcgStatusIsEnbld
BillOfMaterial BillOfMaterial
ChangeRecordStatus _ChangeRecordObjPg ChangeRecordStatus
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
CreationDate
LastChangedByUser LastChangedByUser
BillOfMaterialCategory BillOfMaterialCategory
LastChangeDateTime LastChangeDateTime
LastChangeDate
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
ChgRecdItmTgtSts ChgRecdItmTgtSts
ChgRecdItmDSgntr ChgRecdItmDSgntr Digital Signature Status
DigitalSignUserIsAuthorized
ChgRecdDigSignStatusTxt _DigSignStatusText ChgRecdDigSignStatusTxt Digital Signature Status
ChgRecdReasonForChange ChgRecdReasonForChange
ExpdCompltnDte ExpdCompltnDte
ChgRecdAuthznGrpText ChgRecdAuthznGrpText
ChgRecdNmbrChgSts ChgRecdNmbrChgSts
ChgRecdObjDgtlSgntrEnable
_Material _Material
_Plant _Plant
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage
_ChangeRecordItemRelBOMVH _ChangeRecordItemRelBOMVH
_ChangeRecordVarBOMVH _ChangeRecordVarBOMVH
_ProcessingStatusVH _ProcessingStatusVH
_ChangeRecordObjPg _ChangeRecordObjPg
_ProcessingStatusTxt _ProcessingStatusTxt
_DigSignStatusText _DigSignStatusText
@AbapCatalog.sqlViewName: 'CCHGRCDVARBOM'
//@Search.searchable: true

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Change Record Reference Var BOM'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey:true
@ObjectModel.usageType: {serviceQuality: #C,
                        dataClass: #MIXED,
                        sizeCategory: #XXL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
   semanticKey: ['Material','Plant','BillOfMaterialVariantUsage','BillOfMaterialVariant'],
   createEnabled: true,
   deleteEnabled:'EXTERNAL_CALCULATION',
   updateEnabled,
   transactionalProcessingDelegated: true
}

@UI.headerInfo:{
  typeName: 'Variant BOM',
  typeNamePlural: 'Variant BOMs',
  imageUrl: 'ProductImageURL',
  title:{value:'Variant'}
}

@UI.presentationVariant.requestAtLeast: [ 'ChangeRecordType', 'ChangeRecordLifecycleStatus', 'ChangeRecordReferenceType' ]

define view C_ChgRecdRefVarBOM
  as select from I_ChgRecdRefVarBOMTP as ChangeRecordReferenceVBMTP
  association [1..1] to C_ChangeRecordObjPg          as _ChangeRecordObjPg          on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID

  //  association [0..1] to I_ChangeRecordBillOfMaterialVH as _ChangeRecordBillOfMaterialVH on  $projection.Material                   = _ChangeRecordBillOfMaterialVH.Material

  //                                                                                        and $projection.Plant                      = _ChangeRecordBillOfMaterialVH.Plant

  //                                                                                        and $projection.BillOfMaterialVariantUsage = _ChangeRecordBillOfMaterialVH.BillOfMaterialVariantUsage

  //                                                                                        and $projection.BillOfMaterialVariant      = _ChangeRecordBillOfMaterialVH.BillOfMaterialVariant


  association [0..1] to C_ChgRecdVarBOMVH            as _ChangeRecordVarBOMVH       on  $projection.Material                   = _ChangeRecordVarBOMVH.Material
                                                                                    and $projection.Plant                      = _ChangeRecordVarBOMVH.Plant
                                                                                    and $projection.BillOfMaterialVariantUsage = _ChangeRecordVarBOMVH.BillOfMaterialVariantUsage
                                                                                    and $projection.BillOfMaterialVariant      = _ChangeRecordVarBOMVH.BillOfMaterialVariant




  //  association [0..1] to I_ChangeRecordBillOfMaterialVH as _ChangeRecordBillOfMaterial on  $projection.Material                   = _ChangeRecordBillOfMaterial.Material

  //                                                                                        and $projection.Plant                      = _ChangeRecordBillOfMaterial.Plant

  //                                                                                        and $projection.BillOfMaterialVariantUsage = _ChangeRecordBillOfMaterial.BillOfMaterialVariantUsage

  //                                                                                        and $projection.BillOfMaterialVariant      = _ChangeRecordBillOfMaterial.BillOfMaterialVariant

  association [0..1] to I_Material                   as _Material                   on  $projection.Material = _Material.Material

  association [0..1] to I_PlantStdVH                 as _Plant                      on  $projection.Plant = _Plant.Plant

  association [0..1] to I_BillOfMaterialUsage        as _BillOfMaterialVariantUsage on  $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage
                                                                                    and _BillOfMaterialVariantUsage.Language   = $session.system_language
  association [1..1] to C_ChangeRecordItemRelBOMVH   as _ChangeRecordItemRelBOMVH   on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelBOMVH.ChangeRecordItemRelevance
                                                                                    and $projection.ChangeRecordType          = _ChangeRecordItemRelBOMVH.ChangeRecordType

  // and $projection.ChangeRecordReferenceType = _ChangeRecordItemRelBOMVH.ChangeRecordReferenceType

  association [1..1] to C_ChgRecordItemProcgStatusVH as _ProcessingStatusVH         on  $projection.ChangeRecordItemProcgStatus   = _ProcessingStatusVH.ChgRecdNextItemProcgStatus
                                                                                    and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus
                                                                                    and $projection.ChangeRecordLifecycleStatus   = _ProcessingStatusVH.ChangeRecordLifecycleStatus
  association [0..*] to I_ChgRecdItemProcgStatusText as _ProcessingStatusTxt        on  $projection.ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus

  association [0..*] to C_ChangeRecdDigSignStatusVH  as _DigSignStatusText          on  $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus

{
          --------------------------------------------
          //        @UI.facet: [

          //          ----Facets

          //          {type: #COLLECTION, position: 10, id: 'BOMInfo', label: 'Material BOM Information'},

          //          {type: #IDENTIFICATION_REFERENCE, position: 10, id: 'BOMRef', parentId: 'BOMInfo', isSummary, isPartOfPreview },

          //        ----Facets: Attachments

          //        {type: #COLLECTION, position: 10, id: 'Attachments', label: 'Attachments'}

          //        ]

          --------------------------------------------
          @UI.hidden: true
          @ObjectModel.readOnly: true
          //          @Consumption.semanticObject: 'MaterialBOM'

          //          @UI.lineItem:[

          //           {type: #FOR_INTENT_BASED_NAVIGATION,

          //                      semanticObjectAction: 'Maintenance',

          //                      label: 'Display Material BOM',

          //                      importance:#HIGH}  ]

  key     ChangeRecordReferenceUUID,
          //    @UI.hidden: true

          //    @ObjectModel.readOnly: true

          //   _ChangeRecordBillOfMaterialVH.BillOfMaterialHeaderUUID              as BillOfMaterialHeaderUUID,

          @UI.hidden: true
          @UI.lineItem:[
          { position:5,
            importance:#HIGH }
          ]
          @UI.identification: {position: 5, importance: #HIGH}
          @Semantics.imageUrl: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_OBJECT_THUMBNAIL_VE'

          cast( '' as productimageurl )                                       as ProductImageURL,
          @UI.lineItem:[{
                position:10,

                importance:#HIGH }
                             ]
          @UI.identification: {position: 10, importance: #HIGH}
          @ObjectModel.text.element:  [ 'MaterialName' ]
          @Consumption.valueHelpDefinition: [{
          entity: { name: 'C_ChgRecdVarBOMVH',
          element: 'Material' },
          additionalBinding:[
          { localElement: 'Plant',
          element: 'Plant' },
          { localElement: 'BillOfMaterialVariantUsage',
          element: 'BillOfMaterialVariantUsage' },
          { localElement: 'BillOfMaterialVariant',
          element: 'BillOfMaterialVariant' }]
          }]

          Material,
          @UI.lineItem:[{
                position:20,
                importance:#HIGH }
              ]
          @UI.identification: {position: 20, importance: #HIGH}
          @ObjectModel.foreignKey.association: '_Plant'
          Plant,
          @UI.lineItem:[{
                position:30,
                importance:#HIGH }
              ]
          @UI.identification: {position:30, importance: #MEDIUM}
          //@ObjectModel.foreignKey.association: '_BillOfMaterialVariantUsage'

          BillOfMaterialVariantUsage,
          @UI.lineItem:[{
              position:40,
              importance:#MEDIUM }
                  ]
          @UI.identification: {position:40, importance: #MEDIUM}
          BillOfMaterialVariant,

          //          @ObjectModel.virtualElement : true

          //          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_BOM_ECN_CALCULATE'

          //          @ObjectModel.readOnly: true

          //          @UI.hidden: true

          //          cast( '' as aennr )                                                 as EngineeringChangeDocument,


          @UI.lineItem:[{
              position:45,
              importance:#MEDIUM }
            ]
          @UI.identification: [{position: 70, importance: #MEDIUM }]
          @EndUserText.label: 'Processing Status'
          @Consumption.valueHelpDefinition: [{association: '_ProcessingStatusVH'}]
          @ObjectModel.foreignKey.association: '_ProcessingStatusVH'
          @UI.textArrangement: #TEXT_FIRST
          ChangeRecordItemProcgStatus,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          ChgRecdCurrentItemProcgStatus,
          @ObjectModel.readOnly: true
          @UI.hidden: true
          _ChangeRecordObjPg.ChangeRecordLifecycleStatus                      as ChangeRecordLifecycleStatus,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordItemIsNotEditable,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordItmIsAddDelEnabled,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          // @ObjectModel.foreignKey.association: '_ChangeRecordItemRelBOMVH'

          _ChangeRecordObjPg.ChangeRecordType                                 as ChangeRecordType,
          @UI.hidden: true
          ChangeRecordUUID,
          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ChangeRecordReferenceSubtype,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.lineItem:[{
                      position:60,
                      importance:#MEDIUM }
                    ]
          @Consumption: { valueHelp: '_ChangeRecordItemRelBOMVH' }
          @ObjectModel: {foreignKey.association: '_ChangeRecordItemRelBOMVH' }
          @UI.identification: {position:60, importance: #MEDIUM}
          @UI.textArrangement: #TEXT_ONLY
          --          @ObjectModel.mandatory: true
          ChangeRecordItemRelevance,
          @UI.lineItem:[{position:80,importance:#MEDIUM }]
          @UI.identification: {position: 80, importance: #MEDIUM}
          @ObjectModel.readOnly: true
          @Consumption.semanticObject: 'ChangeMaster'
          ChangeNumber,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _Material._Text[1:Language = $session.system_language].MaterialName as MaterialName,
          @UI.hidden: true
          ChangeRecordReference,
          @ObjectModel.readOnly:true
          @UI.hidden: true
          _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld,
          //For BOM Navigation

          @UI.hidden: true
          BillOfMaterial,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordStatus,
          @Semantics.user.createdBy: true
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 95 }]
          CreatedByUser,
          @UI.hidden: true
          CreationDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 100 }]
          cast( '00000000' as /plmb/created_on )                              as CreationDate,
          @Semantics.user.lastChangedBy: true
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 105 }]
          LastChangedByUser,
          @UI.hidden: true
          BillOfMaterialCategory,
          @UI.hidden: true
          LastChangeDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 110 }]
          cast( '00000000' as /plmb/changed_on )                              as LastChangeDate,
          @UI.hidden: true
          ChangeRecordVirtualRefInd,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          ChgRecdItmTgtSts,

          @UI.hidden: true
          @UI.lineItem:[{importance:#HIGH, hidden: true }   ]
          @EndUserText.label: 'Digital Signature Status'
          @ObjectModel.foreignKey.association: '_DigSignStatusText'
          @Consumption: { valueHelp: '_DigSignStatusText' }
          ChgRecdItmDSgntr,

          @UI.lineItem:[{
              hidden: true,
              importance:#LOW }
            ]
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_I_DSGNTR_ENABLE'
          cast( '' as boolean)                                                as DigitalSignUserIsAuthorized,

          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #LOW, position: 90 }]
          @EndUserText.label: 'Digital Signature Status'
          _DigSignStatusText.ChgRecdDigSignStatusTxt                          as ChgRecdDigSignStatusTxt,

          @UI.identification: [{importance: #MEDIUM, position: 115 }]
          ChgRecdReasonForChange,

          @UI.identification: [{importance: #MEDIUM, position: 120 }]
          ExpdCompltnDte,

          @UI.identification: [{importance: #MEDIUM, position: 125 }]
          @Consumption.valueHelpDefinition: [{ entity : { name : 'C_ChangeRecdAuthznGrpVH' , element: 'ChgRecdNmbrAuthznGrp'}}]
          ChgRecdAuthznGrpText,

          @UI.identification: [{importance: #MEDIUM, position: 130 }]
          @Consumption.valueHelpDefinition: [{ entity : { name : 'C_ChgRecdChgNmbrStatusVH' , element: 'ChgRecdNmbrChgSts'}}]
          ChgRecdNmbrChgSts,


          @UI.lineItem:[{
          hidden: true,
          importance:#LOW }
          ]
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_I_DSGNTR_ENABLE'
          cast( '' as boolean)                                                as ChgRecdObjDgtlSgntrEnable,

          //          @ObjectModel.readOnly: true

          //          @UI.hidden: true

          //          _ChangeRecordBillOfMaterial.HeaderValidityStartDate,

          _Material,
          _Plant,
          _BillOfMaterialVariantUsage,
          _ChangeRecordItemRelBOMVH,
          _ChangeRecordVarBOMVH,
          _ProcessingStatusVH,
          @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
          _ChangeRecordObjPg,
          _ProcessingStatusTxt,
          _DigSignStatusText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDOBJPG",
"I_CHGRECDREFVARBOMTP",
"I_MATERIAL",
"I_MATERIALTEXT"
],
"ASSOCIATED":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDITEMRELBOMVH",
"C_CHANGERECORDOBJPG",
"C_CHGRECDVARBOMVH",
"C_CHGRECORDITEMPROCGSTATUSVH",
"I_BILLOFMATERIALUSAGE",
"I_CHGRECDITEMPROCGSTATUSTEXT",
"I_MATERIAL",
"I_PLANTSTDVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/