C_LinkedProdnVersBOM

DDL: C_LINKEDPRODNVERSBOM Type: view_entity CONSUMPTION
17 Fields 1 Data Sources

BOM to Material Assgmt in Rec prv

C_LinkedProdnVersBOM is a Consumption CDS View that provides data about "BOM to Material Assgmt in Rec prv" in SAP S/4HANA. It reads from 1 data source (I_MaterialBOM) and exposes 17 fields with key fields Material, Plant, BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant.

Data Sources (1)

SourceAliasJoin Type
I_MaterialBOM I_MaterialBOM from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BOM to Material Assgmt in Rec prv view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY BillOfMaterialCategory BillOfMaterialCategory BOM Category
KEY BillOfMaterial Bill Of Material
KEY BillOfMaterialVariant BillOfMaterialVariant Alternative BOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY ChangeNumber EngineeringChangeDocument Change Number
ValidityEndDate HeaderValidityEndDate to
ValidityStartDate HeaderValidityStartDate Valid From
BillOfMaterialVariantUsage BillOfMaterialVariantUsage BOM Usage
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit Base quantity
BOMHeaderBaseUnit BOMHeaderBaseUnit Base Unit of Measure
BOMHeaderText BOMHeaderText BOM Description
BillOfMaterialStatus BillOfMaterialStatus BOM Status
MatFromLotSizeQuantity MatFromLotSizeQuantity Minimum Lot Size
MaterialToLotSizeQuantity MaterialToLotSizeQuantity Maximum Lot Size
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc

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_LinkedProdnVersBOM.
-- 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_LinkedProdnVersBOM AS
SELECT
  Material,
  Plant,
  BillOfMaterialCategory,
  cast ( BillOfMaterial as abap.char(8) ) AS BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument AS ChangeNumber,
  HeaderValidityEndDate AS ValidityEndDate,
  HeaderValidityStartDate AS ValidityStartDate,
  BillOfMaterialVariantUsage,
  BOMHeaderQuantityInBaseUnit,
  BOMHeaderBaseUnit,
  BOMHeaderText,
  BillOfMaterialStatus,
  MatFromLotSizeQuantity,
  MaterialToLotSizeQuantity,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc
FROM I_MaterialBOM
;

Learn More