C_BOMAltAndUsage

DDL: C_BOMALTANDUSAGE Type: view_entity CONSUMPTION Package: CS_MODEL
12 Fields

Consumption view to fetch alternatives of a BOM

C_BOMAltAndUsage is a Consumption CDS View that provides data about "Consumption view to fetch alternatives of a BOM" in SAP S/4HANA. Part of development package CS_MODEL.

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view to fetch alternatives of a BOM view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVersion
EngineeringChangeDocument
Material
Plant
BillOfMaterialVariantUsage
HeaderValidityStartDate
AssemblyBOMDraftUUID
HasActiveEntity
IsActiveEntity

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_BOMAltAndUsage.
-- 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_BOMAltAndUsage AS
SELECT
  cast( BillOfMaterial as char8 preserving type ) AS BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialCategory,
  cast(' ' as cs_versn preserving type ) AS BillOfMaterialVersion,
  cast(' ' as aennr preserving type ) AS EngineeringChangeDocument,
  cast(' ' as matnr preserving type) AS Material,
  cast(' ' as werks_d preserving type ) AS Plant,
  cast(' ' as stlan preserving type ) AS BillOfMaterialVariantUsage,
  $session.system_date AS HeaderValidityStartDate,
  cast ( hextobin('00000000000000000000000000000000') as /bobf/uuid preserving type ) AS AssemblyBOMDraftUUID,
  cast('' as xfeld preserving type ) AS HasActiveEntity,
  cast('' as xfeld preserving type ) AS IsActiveEntity
;

Learn More