ESH_N_MBOM_HEADER

DDL: ESH_N_MBOM_HEADER SQL: ESH_L_MBOMHEADER Type: view
18 Fields 1 Data Sources

ESH_N_MBOM_HEADER is a CDS View in SAP S/4HANA. It reads from 1 data source (I_MATERIALBOMHEADERSEARCH) and exposes 18 fields with key fields BILLOFMATERIAL, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, MATERIAL, PLANT.

Data Sources (1)

SourceAliasJoin Type
I_MATERIALBOMHEADERSEARCH I_MATERIALBOMHEADERSEARCH from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_MBOMHEADER view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BILLOFMATERIAL BILLOFMATERIAL BOM
KEY BILLOFMATERIALVARIANT BILLOFMATERIALVARIANT AlternativeBOM
KEY BILLOFMATERIALVARIANTUSAGE BILLOFMATERIALVARIANTUSAGE Usage
KEY MATERIAL MATERIAL Vehicle Model
KEY PLANT PLANT Valuation Area
BILLOFMATERIALCATEGORY BILLOFMATERIALCATEGORY BOM category
BILLOFMATERIALCOMPONENT _BOMITEMS BILLOFMATERIALCOMPONENT Component
BILLOFMATERIALVARIANTUSAGEDESC BILLOFMATERIALVARIANTUSAGEDESC
BILLOFMATERIALVERSION BILLOFMATERIALVERSION BOM Version
BOMITEMDESCRIPTION _BOMITEMS BOMITEMDESCRIPTION Item Text
BOMITEMTEXT2 _BOMITEMS BOMITEMTEXT2 Item Text
BOM_ITEM_DESCRIPTION _BOMITEMS COMPONENTDESCRIPTION Item Text
CREATEDBYUSER CREATEDBYUSER User Name
BOM_ITEM_CHANGE_NUMBER _BOMITEMS ENGINEERINGCHANGEDOCUMENT Change Number
ENGINEERINGCHANGEDOCUMENT ENGINEERINGCHANGEDOCUMENT Change Number
LASTCHANGEDBYUSER LASTCHANGEDBYUSER User Name
MATERIALNAME MATERIALNAME Material Description
PLANTNAME PLANTNAME Plant 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 ESH_N_MBOM_HEADER.
-- 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.
-- SQL view name: ESH_L_MBOMHEADER

CREATE VIEW ESH_N_MBOM_HEADER AS
SELECT
  BILLOFMATERIAL,
  BILLOFMATERIALVARIANT,
  BILLOFMATERIALVARIANTUSAGE,
  MATERIAL,
  PLANT,
  BILLOFMATERIALCATEGORY,
  _BOMITEMS.BILLOFMATERIALCOMPONENT AS BILLOFMATERIALCOMPONENT,
  BILLOFMATERIALVARIANTUSAGEDESC,
  BILLOFMATERIALVERSION,
  _BOMITEMS.BOMITEMDESCRIPTION AS BOMITEMDESCRIPTION,
  _BOMITEMS.BOMITEMTEXT2 AS BOMITEMTEXT2,
  _BOMITEMS.COMPONENTDESCRIPTION AS BOM_ITEM_DESCRIPTION,
  CREATEDBYUSER,
  _BOMITEMS.ENGINEERINGCHANGEDOCUMENT AS BOM_ITEM_CHANGE_NUMBER,
  ENGINEERINGCHANGEDOCUMENT,
  LASTCHANGEDBYUSER,
  MATERIALNAME,
  PLANTNAME
FROM I_MATERIALBOMHEADERSEARCH
;

Learn More