P_VersEngBillOfMaterial

DDL: P_VERSENGBILLOFMATERIAL SQL: PVERSENGBOM Type: view COMPOSITE
43 Fields 2 Data Sources

P_VersEngBillOfMaterial is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_EngBOMUsage, I_MaterialBOM) and exposes 43 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, Material, Plant.

Data Sources (2)

SourceAliasJoin Type
I_EngBOMUsage EngBOMUsage inner
I_MaterialBOM MaterialBOM from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PVERSENGBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
KEY BillOfMaterial I_MaterialBOM BillOfMaterial BOM
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
KEY Material I_MaterialBOM Material Vehicle Model
KEY Plant I_MaterialBOM Plant Valuation Area
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
BillOfMaterialUUID I_MaterialBOM BillOfMaterialUUID Character Field of Length 12
IsMultipleBOMAlt IsMultipleBOMAlt Alt.det. MBOM
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
BOMHeaderInternalChangeCount I_MaterialBOM BOMHeaderInternalChangeCount Counter
BOMPrioritizedVersion BOMPrioritizedVersion Selection ID
BOMUsagePriority BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp I_MaterialBOM BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus I_MaterialBOM BOMVersionStatus BOM Version Status
BOMAlternativeText I_MaterialBOM BOMAlternativeText Alt Text
BOMGroup I_MaterialBOM BOMGroup BOM group
BOMHeaderBaseUnit I_MaterialBOM BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit I_MaterialBOM BOMHeaderQuantityInBaseUnit Base quantity
BOMHeaderText I_MaterialBOM BOMHeaderText BOM Description
BOMIsToBeDeleted I_MaterialBOM BOMIsToBeDeleted Handling Del. Flag
BOMTechnicalType I_MaterialBOM BOMTechnicalType Tech type
BillOfMaterialStatus I_MaterialBOM BillOfMaterialStatus BOM Status
ChgToEngineeringChgDocument I_MaterialBOM ChgToEngineeringChgDocument Change No. To
CreatedByUser I_MaterialBOM CreatedByUser User Name
DocumentIsCreatedByCAD I_MaterialBOM DocumentIsCreatedByCAD CAD Indicator
EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument Change Number
HeaderValidityEndDate I_MaterialBOM HeaderValidityEndDate to
HeaderValidityStartDate I_MaterialBOM HeaderValidityStartDate Valid From
IsALE I_MaterialBOM IsALE ALE indicator
IsConfiguredMaterial I_MaterialBOM IsConfiguredMaterial Configured matl
IsVersionBillOfMaterial I_MaterialBOM IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion I_MaterialBOM IsLatestBOMVersion Latest Rel Version
IsMarkedForDeletion I_MaterialBOM IsMarkedForDeletion Purch.org. data
LaboratoryOrDesignOffice I_MaterialBOM LaboratoryOrDesignOffice Lab/Office
RecordCreationDate I_MaterialBOM RecordCreationDate Created On
LastChangeDate I_MaterialBOM LastChangeDate Time Stamp
LastChangedByUser I_MaterialBOM LastChangedByUser User Name
MatFromLotSizeQuantity I_MaterialBOM MatFromLotSizeQuantity From Lot Size
MaterialToLotSizeQuantity I_MaterialBOM MaterialToLotSizeQuantity To Lot Size
_UnitOfMeasure I_MaterialBOM _UnitOfMeasure
_BillOfMaterialVariantUsage I_MaterialBOM _BillOfMaterialVariantUsage
_BillOfMaterialItem I_MaterialBOM _BillOfMaterialItem

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 P_VersEngBillOfMaterial.
-- 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: PVERSENGBOM

CREATE VIEW P_VersEngBillOfMaterial AS
SELECT
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.BillOfMaterial AS BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  IsMultipleBOMAlt,
  MaterialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MaterialBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  BOMPrioritizedVersion,
  BOMUsagePriority,
  MaterialBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  MaterialBOM.BOMVersionStatus AS BOMVersionStatus,
  MaterialBOM.BOMAlternativeText AS BOMAlternativeText,
  MaterialBOM.BOMGroup AS BOMGroup,
  MaterialBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  MaterialBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  MaterialBOM.BOMHeaderText AS BOMHeaderText,
  MaterialBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  MaterialBOM.BOMTechnicalType AS BOMTechnicalType,
  MaterialBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  MaterialBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  MaterialBOM.CreatedByUser AS CreatedByUser,
  MaterialBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  MaterialBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  MaterialBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  MaterialBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  MaterialBOM.IsALE AS IsALE,
  MaterialBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  MaterialBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  MaterialBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  MaterialBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  MaterialBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  MaterialBOM.RecordCreationDate AS RecordCreationDate,
  MaterialBOM.LastChangeDate AS LastChangeDate,
  MaterialBOM.LastChangedByUser AS LastChangedByUser,
  MaterialBOM.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  MaterialBOM.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  MaterialBOM._UnitOfMeasure AS _UnitOfMeasure,
  MaterialBOM._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  MaterialBOM._BillOfMaterialItem AS _BillOfMaterialItem
FROM I_MaterialBOM AS MaterialBOM
INNER JOIN I_EngBOMUsage AS EngBOMUsage ON /* join condition not captured in parsed metadata */
;

Learn More