P_BOMHeaderType

DDL: P_BOMHEADERTYPE SQL: PBOMTYPES Type: view BASIC

P_BOMHeaderType is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_MaterialBOMLink, I_SalesOrderBOMLink) and exposes 14 fields with key fields BillOfMaterial, BillOfMaterialVariant, Material, Plant, BillOfMaterialVariantUsage.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_MaterialBOMLink I_MaterialBOMLink from
I_SalesOrderBOMLink I_SalesOrderBOMLink union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PBOMTYPES view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY Material Material
KEY Plant Plant
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage
KEY SalesOrder
KEY SalesOrderItem
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY Material Material
KEY Plant Plant
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage
KEY SalesOrder SalesOrder
KEY SalesOrderItem SalesOrderItem
KEY BillOfMaterialCategory BillOfMaterialCategory 
@AbapCatalog.sqlViewName: 'PBOMTYPES'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_BOMHeaderType as select from I_MaterialBOMLink {
  key BillOfMaterial,
  key BillOfMaterialVariant,
  key Material,
  key Plant,
  key BillOfMaterialVariantUsage,
  key cast('' as cs_vbeln) as SalesOrder,
  key cast('000000' as cs_vbpos preserving type) as SalesOrderItem,
  key BillOfMaterialCategory
}
 union all select from I_SalesOrderBOMLink {
  key BillOfMaterial,
  key BillOfMaterialVariant,
  key Material,
  key Plant,
  key BillOfMaterialVariantUsage,
  key SalesOrder,
  key SalesOrderItem,
  key BillOfMaterialCategory
 }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALBOMLINK",
"I_SALESORDERBOMLINK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More