I_MaterialBillOfMaterialNote

DDL: I_MATERIALBILLOFMATERIALNOTE Type: view_entity COMPOSITE Package: CS_MODEL_API
23 Fields 2 Data Sources

Bill Of Material Header Long Text

I_MaterialBillOfMaterialNote is a Composite CDS View that provides data about "Bill Of Material Header Long Text" in SAP S/4HANA. It reads from 2 data sources (P_MaterialBOMHeaderText, P_MaterialBOMHeaderText) and exposes 23 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. Part of development package CS_MODEL_API.

Data Sources (2)

SourceAliasJoin Type
P_MaterialBOMHeaderText P_MaterialBOMHeaderText from
P_MaterialBOMHeaderText P_MaterialBOMHeaderText union_all

Annotations (10)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.updateEnabled true view
ObjectModel.createEnabled true view
EndUserText.label Bill Of Material Header Long Text view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BOMHeaderLongText BillOfMaterial BOM
KEY BillOfMaterialCategory BOMHeaderLongText BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant _BOMHeader BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion _BOMHeader BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument _BOMHeader EngineeringChangeDocument Change Number
KEY Material _BOMHeader Material Vehicle Model
KEY Plant _BOMHeader Plant Valuation Area
KEY Language BOMHeaderLongText Language Report Text Language
KEY LongTextID BOMHeaderLongText LongTextID Text ID
BOMHeaderInternalChangeCount _BOMHeader BOMHeaderInternalChangeCount Counter
BillOfMaterialVariantUsage _BOMHeader BillOfMaterialVariantUsage Usage
BillOfMaterialasBillOfMaterial
KEY BillOfMaterialCategory BOMHeaderLongText BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant _BOMHeader BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion _BOMHeader BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument _BOMHeader EngineeringChangeDocument Change Number
KEY Material _BOMHeader Material Vehicle Model
KEY Plant _BOMHeader Plant Valuation Area
KEY Language BOMHeaderLongText Language Report Text Language
KEY LongTextID BOMHeaderLongText LongTextID Text ID
BOMHeaderInternalChangeCount _BOMHeader BOMHeaderInternalChangeCount Counter
BillOfMaterialVariantUsage _BOMHeader BillOfMaterialVariantUsage Usage
LongText BOMHeaderLongText LongText Text Name

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 I_MaterialBillOfMaterialNote.
-- 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 I_MaterialBillOfMaterialNote AS
SELECT
  BOMHeaderLongText.BillOfMaterial AS BillOfMaterial,
  BOMHeaderLongText.BillOfMaterialCategory AS BillOfMaterialCategory,
  _BOMHeader.BillOfMaterialVariant AS BillOfMaterialVariant,
  _BOMHeader.BillOfMaterialVersion AS BillOfMaterialVersion,
  _BOMHeader.EngineeringChangeDocument AS EngineeringChangeDocument,
  _BOMHeader.Material AS Material,
  _BOMHeader.Plant AS Plant,
  BOMHeaderLongText.Language AS Language,
  BOMHeaderLongText.LongTextID AS LongTextID,
  _BOMHeader.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  _BOMHeader.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMHeaderLongText.LongText as LongText AS BillOfMaterialasBillOfMaterial,
  BOMHeaderLongText.LongText AS LongText
FROM P_MaterialBOMHeaderText
-- UNION ALL with additional select branch(es): P_MaterialBOMHeaderText
;

Learn More