P_VersEngBOMWithCRAssignment

DDL: P_VERSENGBOMWITHCRASSIGNMENT SQL: PVERSEBOMCR Type: view COMPOSITE

P_VersEngBOMWithCRAssignment is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_VersEngBillOfMaterial, P_EngBOMAndPlngScpAssgd) and exposes 10 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, Material.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_VersEngBillOfMaterial VersEngBOM from
P_EngBOMAndPlngScpAssgd VersEngBOMAssignedToCR inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PVERSEBOMCR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory P_VersEngBillOfMaterial BillOfMaterialCategory
KEY BillOfMaterial P_VersEngBillOfMaterial BillOfMaterial
KEY BillOfMaterialVariant P_VersEngBillOfMaterial BillOfMaterialVariant
KEY BillOfMaterialVersion P_VersEngBillOfMaterial BillOfMaterialVersion
KEY Material P_VersEngBillOfMaterial Material
KEY Plant P_VersEngBillOfMaterial Plant
KEY ChangeRecordUUID P_EngBOMAndPlngScpAssgd ChangeRecordUUID
KEY ChangeRecordRefPlngScpUUID P_EngBOMAndPlngScpAssgd ChangeRecordRefPlngScpUUID
ChangeRecord P_EngBOMAndPlngScpAssgd ChangeRecord
ProductionPlant 
@AbapCatalog.sqlViewName: 'PVERSEBOMCR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality:#X, sizeCategory: #XXL, dataClass: #MASTER}
//@EndUserText.label: 'Version Controlled Eng BOM With Their Change Records'

@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_VersEngBOMWithCRAssignment
  as select from P_VersEngBillOfMaterial as VersEngBOM
    inner join   P_EngBOMAndPlngScpAssgd as VersEngBOMAssignedToCR on  VersEngBOM.BillOfMaterialCategory = VersEngBOMAssignedToCR.BillOfMaterialCategory
                                                                   and VersEngBOM.BillOfMaterial         = VersEngBOMAssignedToCR.BillOfMaterial
                                                                   and VersEngBOM.BillOfMaterialVariant  = VersEngBOMAssignedToCR.BillOfMaterialVariant
                                                                   and VersEngBOM.BillOfMaterialVersion  = VersEngBOMAssignedToCR.BillOfMaterialVersion
                                                                   and VersEngBOM.Plant                  = VersEngBOMAssignedToCR.Plant
{
  key VersEngBOM.BillOfMaterialCategory,
  key VersEngBOM.BillOfMaterial,
  key VersEngBOM.BillOfMaterialVariant,
  key VersEngBOM.BillOfMaterialVersion,
  key VersEngBOM.Material,
  key VersEngBOM.Plant,
  key VersEngBOMAssignedToCR.ChangeRecordUUID,
  key VersEngBOMAssignedToCR.ChangeRecordRefPlngScpUUID,      
      VersEngBOMAssignedToCR.ChangeRecord,
      VersEngBOMAssignedToCR._PlngScp.Plant as ProductionPlant

}

Learn More