C_ProdnSupplyAreaBillOfMatl

DDL: C_PRODNSUPPLYAREABILLOFMATL Type: view_entity CONSUMPTION
16 Fields 1 Data Sources 2 Associations 1 OData Services

Bill of Material of PSA Where Used

C_ProdnSupplyAreaBillOfMatl is a Consumption CDS View that provides data about "Bill of Material of PSA Where Used" in SAP S/4HANA. It reads from 1 data source (P_ProdnSupplyAreaBillOfMatl) and exposes 16 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVariantUsage, BOMHeaderInternalChangeCount. It has 2 associations to related views. It is exposed through 1 OData service (UI_PRODSUPPLYAREA_MANAGE).

Data Sources (1)

SourceAliasJoin Type
P_ProdnSupplyAreaBillOfMatl P_ProdnSupplyAreaBillOfMatl from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProductText _ProductText1 $projection.Material = _ProductText1.Product and _ProductText1.Language = $session.system_language
[0..1] I_ProductText _ProductText2 $projection.BillOfMaterialComponent = _ProductText2.Product and _ProductText2.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Bill of Material of PSA Where Used view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRODSUPPLYAREA_MANAGE UI_PRODSUPPLYAREA_MANAGE V4 C1 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory BillOfMaterialCategory BOM Category
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
KEY BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount Counter
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber Item Node Number
BillOfMaterialItemNumber BillOfMaterialItemNumber Item Number
Material Material Material
Plant Plant Valuation Area
ProductionSupplyArea ProductionSupplyArea Supply Area
BillOfMaterialComponent BillOfMaterialComponent Component
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Validity End Date
ProductName _ProductText1 ProductName Description
MaterialComponentText _ProductText2 ProductName Description

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProdnSupplyAreaBillOfMatl.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_ProdnSupplyAreaBillOfMatl AS
SELECT
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVariantUsage,
  BOMHeaderInternalChangeCount,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  BillOfMaterialItemNumber,
  Material,
  Plant,
  ProductionSupplyArea,
  BillOfMaterialComponent,
  ValidityStartDate,
  ValidityEndDate,
  _ProductText1.ProductName AS ProductName,
  _ProductText2.ProductName AS MaterialComponentText
FROM P_ProdnSupplyAreaBillOfMatl
LEFT OUTER JOIN I_ProductText AS _ProductText1 ON Material = _ProductText1.Product AND _ProductText1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText2 ON BillOfMaterialComponent = _ProductText2.Product AND _ProductText2.Language = $session.system_language  -- association [0..1]
;

Learn More