C_ChgRecdRefFuncLocBOM

DDL: C_CHGRECDREFFUNCLOCBOM SQL: CCHGRCDFLBM Type: view CONSUMPTION

Chg Recd ref Obj FL BOM

C_ChgRecdRefFuncLocBOM is a Consumption CDS View that provides data about "Chg Recd ref Obj FL BOM" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefFuncLocBOMTP) and exposes 46 fields. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefFuncLocBOMTP ChangeRecordReferenceFBMTP from

Associations (8)

CardinalityTargetAliasCondition
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[0..1] C_ChgRecdFuncLocBOMVH _ChangeRecordFLBOMVH $projection.FunctionalLocation = _ChangeRecordFLBOMVH.FunctionalLocation and $projection.Plant = _ChangeRecordFLBOMVH.Plant and $projection.BillOfMaterialVariantUsage = _ChangeRecordFLBOMVH.BillOfMaterialVariantUsage and $projection.BillOfMaterialVariant = _ChangeRecordFLBOMVH.BillOfMaterialVariant
[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_ChgRecdRlvnceFunLocBOMVH _ChangeRecordItemRelVH $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance and $projection.ChangeRecordType = _ChangeRecordItemRelVH.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 CCHGRCDFLBM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Chg Recd ref Obj FL 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 Functional Location BOM view
UI.headerInfo.typeNamePlural Functional Location BOMs view
UI.headerInfo.imageUrl ProductImageURL view
UI.headerInfo.title.value FunctionalLocation view

Fields (46)

KeyFieldSource TableSource FieldDescription
keyChangeRecordReferenceUUID
ProductImageURL
FunctionalLocation FunctionalLocation
Plant Plant
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc
BillOfMaterialVariant BillOfMaterialVariant
ChangeNumber ChangeNumber
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 ChangeRecordItemRelevance
ChangeRecordReference ChangeRecordReference
BillOfMaterial BillOfMaterial
ChangeRecordStatus _ChangeRecordObjPg ChangeRecordStatus
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
CreationDate
LastChangedByUser LastChangedByUser
BillOfMaterialCategory BillOfMaterialCategory
LastChangeDateTime LastChangeDateTime
LastChangeDate
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
ChgRecdItmDSgntr ChgRecdItmDSgntr Digital Signature Status
DigitalSignUserIsAuthorized
ChgRecdDigSignStatusTxt _DigSignStatusText ChgRecdDigSignStatusTxt Digital Signature Status
ChgRecdObjDgtlSgntrEnable
ChgRecdReasonForChange ChgRecdReasonForChange
ExpdCompltnDte ExpdCompltnDte
ChgRecdAuthznGrpText ChgRecdAuthznGrpText
ChgRecdNmbrChgSts ChgRecdNmbrChgSts
_Plant _Plant
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage
_ChangeRecordItemRelVH _ChangeRecordItemRelVH
_ChangeRecordFLBOMVH _ChangeRecordFLBOMVH
_ProcessingStatusVH _ProcessingStatusVH
_ChangeRecordObjPg _ChangeRecordObjPg
_ProcessingStatusTxt _ProcessingStatusTxt
_DigSignStatusText _DigSignStatusText
@AbapCatalog.sqlViewName: 'CCHGRCDFLBM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Chg Recd ref Obj FL BOM'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey:true
@ObjectModel.usageType: {serviceQuality: #C,
                        dataClass: #MIXED,
                        sizeCategory: #XXL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
   semanticKey: ['FunctionalLocation','Plant','BillOfMaterialVariantUsage','BillOfMaterialVariant'],
   createEnabled: true,
   deleteEnabled:'EXTERNAL_CALCULATION',
   updateEnabled,
   transactionalProcessingDelegated: true
}

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

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

define view C_ChgRecdRefFuncLocBOM
  as select from I_ChgRecdRefFuncLocBOMTP as ChangeRecordReferenceFBMTP

  association [1..1] to C_ChangeRecordObjPg          as _ChangeRecordObjPg          on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID

  association [0..1] to C_ChgRecdFuncLocBOMVH        as _ChangeRecordFLBOMVH        on  $projection.FunctionalLocation         = _ChangeRecordFLBOMVH.FunctionalLocation
                                                                                    and $projection.Plant                      = _ChangeRecordFLBOMVH.Plant
                                                                                    and $projection.BillOfMaterialVariantUsage = _ChangeRecordFLBOMVH.BillOfMaterialVariantUsage
                                                                                    and $projection.BillOfMaterialVariant      = _ChangeRecordFLBOMVH.BillOfMaterialVariant

  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_ChgRecdRlvnceFunLocBOMVH   as _ChangeRecordItemRelVH      on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance
                                                                                    and $projection.ChangeRecordType          = _ChangeRecordItemRelVH.ChangeRecordType

  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
  key     ChangeRecordReferenceUUID,
          //          @UI.hidden: true

          //          @ObjectModel.readOnly: true

          //          _ChangeRecordStdBOMVH.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}
          @Consumption.valueHelpDefinition: [{
                        entity:  { name:        'C_ChgRecdFuncLocBOMVH',
                                element:        'FunctionalLocation' },
             additionalBinding:[{ localElement: 'Plant',
                                 element:       'Plant' },
                                { localElement: 'BillOfMaterialVariantUsage',
                                 element:       'BillOfMaterialVariantUsage' },
                                { localElement: 'BillOfMaterialVariant',
                                 element:       'BillOfMaterialVariant' }]
           }]
          FunctionalLocation,

          @UI.lineItem:[{
                position:40,
                importance:#HIGH }
              ]
          @UI.identification: {position: 40, importance: #HIGH}
          @ObjectModel.foreignKey.association: '_Plant'
          Plant,
          @UI.lineItem:[{
               position:45,
               importance:#HIGH }
             ]
          @UI.identification: {position: 45, importance: #MEDIUM}
          @ObjectModel.text.element:  [ 'BillOfMaterialVariantUsageDesc' ]
          BillOfMaterialVariantUsage,
          @UI.hidden:true
          @ObjectModel.readOnly:true
          _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc,
          @UI.lineItem:[{
              position:50,
              importance:#HIGH }
                  ]
          @UI.identification: {position:50, importance: #HIGH}
          BillOfMaterialVariant,
          @UI.lineItem:[{position:110,importance:#MEDIUM }]
          @UI.identification: {position: 110, importance: #MEDIUM}
          @ObjectModel.readOnly: true
          @Consumption.semanticObject: 'ChangeMaster'
          ChangeNumber,
          @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,
          /*//@UI.lineItem: { position:80, importance:#HIGH}

          //@UI.identification: {position: 80, importance: #HIGH}

          @ObjectModel.readOnly: false
          @ObjectModel.text.element: 'ReasonForChangeText'
          @UI.hidden: false
          ReasonForChangeText                                                                                          as ReasonForChangeText,
          //@UI.lineItem: { position:90, importance:#HIGH}

          //@UI.identification: {position: 90, importance: #HIGH}

          @ObjectModel.readOnly: false
          @ObjectModel.text.element: 'ChgRecdAuthznGrpText'
          @UI.hidden: false
          ChgRecdAuthznGrpText                                                                                          as ChgRecdAuthznGrpText,
          //@UI.lineItem: { position:100, importance:#HIGH}

          //@UI.identification: {position: 100, importance: #HIGH}

          @ObjectModel.readOnly: false
          @ObjectModel.text.element: 'ExpdCompltnDteTxt'
          @UI.hidden: false
          ExpdCompltnDteTxt                                                                                             as ExpdCompltnDteTxt,
          //@UI.lineItem: { position:110, importance:#HIGH}

          //@UI.identification: {position: 110, importance: #HIGH}

          @ObjectModel.readOnly: false
          @ObjectModel.text.element: 'ChangeNumberStatus'
          @UI.hidden: false
          ChangeNumberStatus                                                                                            as ChangeNumberStatus,*/
          @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
          _ChangeRecordObjPg.ChangeRecordType            as ChangeRecordType,
          @UI.hidden: true
          ChangeRecordUUID,
          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ChangeRecordReferenceSubtype,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.lineItem:[{
                      position:120,
                      importance:#MEDIUM }
                    ]
          @Consumption: { valueHelp: '_ChangeRecordItemRelVH' }
          @ObjectModel: {foreignKey.association: '_ChangeRecordItemRelVH' }
          @UI.identification: {position:120, importance: #MEDIUM}
          @UI.textArrangement: #TEXT_ONLY
          @ObjectModel.mandatory: true
          ChangeRecordItemRelevance,
          @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: {position: 135, importance: #MEDIUM}
          CreatedByUser,
          @UI.hidden: true
          CreationDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: {position: 140, importance: #MEDIUM}
          cast( '00000000' as /plmb/created_on )         as CreationDate,
          @Semantics.user.lastChangedBy: true
          @ObjectModel.readOnly: true
          @UI.identification: {position: 145, importance: #MEDIUM}
          LastChangedByUser,
          @UI.hidden: true
          BillOfMaterialCategory,
          @UI.hidden: true
          LastChangeDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: {position: 150, importance: #MEDIUM}
          cast( '00000000' as /plmb/changed_on )         as LastChangeDate,
          @UI.hidden: true
          ChangeRecordVirtualRefInd,

          @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: 130 }]
          @EndUserText.label: 'Digital Signature Status'
          _DigSignStatusText.ChgRecdDigSignStatusTxt     as ChgRecdDigSignStatusTxt,


          @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,

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

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

          @UI.lineItem:[{position:100,importance:#MEDIUM }]
          @UI.identification: {position: 100, importance: #MEDIUM}
          ChgRecdAuthznGrpText,

          @UI.lineItem:[{position:110,importance:#MEDIUM }]
          @UI.identification: {position: 110, importance: #MEDIUM}
          ChgRecdNmbrChgSts,


          _Plant,
          _BillOfMaterialVariantUsage,
          _ChangeRecordItemRelVH,
          _ChangeRecordFLBOMVH,
          _ProcessingStatusVH,
          @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
          _ChangeRecordObjPg,
          _ProcessingStatusTxt,
          _DigSignStatusText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDOBJPG",
"I_BILLOFMATERIALUSAGE",
"I_CHGRECDREFFUNCLOCBOMTP"
],
"ASSOCIATED":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDOBJPG",
"C_CHGRECDFUNCLOCBOMVH",
"C_CHGRECDRLVNCEFUNLOCBOMVH",
"C_CHGRECORDITEMPROCGSTATUSVH",
"I_BILLOFMATERIALUSAGE",
"I_CHGRECDITEMPROCGSTATUSTEXT",
"I_PLANTSTDVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/