P_NonVrsEngBillofMaterial

DDL: P_NONVRSENGBILLOFMATERIAL SQL: PNONVRSENGBOM Type: view COMPOSITE Package: MPE_PLAN_MEC
43 Fields 7 Data Sources

Non Version Engineering Bill of Material

P_NonVrsEngBillofMaterial is a Composite CDS View that provides data about "Non Version Engineering Bill of Material" in SAP S/4HANA. It reads from 7 data sources and exposes 43 fields with key fields BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, Material, Plant. Part of development package MPE_PLAN_MEC.

Data Sources (7)

SourceAliasJoin Type
P_NonVersEBOMHdrLtstInstance BOMHdr from
P_BOMItmModifiedDate BOMItmModifiedDate inner
I_EngBOMUsage EngBOMUsage inner
is is inner
is is inner
is is inner
I_MaterialBOM MaterialBOM inner

Annotations (9)

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

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_MaterialBOM BillOfMaterial BOM
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
KEY Material I_MaterialBOM Material Vehicle Model
KEY Plant I_MaterialBOM Plant Valuation Area
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument Change Number
BillOfMaterialUUID I_MaterialBOM BillOfMaterialUUID Character Field of Length 12
IsMultipleBOMAlt I_MaterialBOM IsMultipleBOMAlt Alt.det. MBOM
RecordCreationDate I_MaterialBOM RecordCreationDate Created On
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
BOMHeaderInternalChangeCount I_MaterialBOM BOMHeaderInternalChangeCount Counter
BOMPrioritizedVersion I_MaterialBOM BOMPrioritizedVersion Selection ID
BOMUsagePriority I_MaterialBOM 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
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
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_NonVrsEngBillofMaterial.
-- 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: PNONVRSENGBOM

CREATE VIEW P_NonVrsEngBillofMaterial AS
SELECT
  MaterialBOM.BillOfMaterial AS BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  MaterialBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  MaterialBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  MaterialBOM.RecordCreationDate AS RecordCreationDate,
  MaterialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MaterialBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  MaterialBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  MaterialBOM.BOMUsagePriority AS 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.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.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 P_NonVersEBOMHdrLtstInstance AS BOMHdr
INNER JOIN is ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialBOM AS MaterialBOM ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngBOMUsage AS EngBOMUsage ON /* join condition not captured in parsed metadata */
INNER JOIN P_BOMItmModifiedDate AS BOMItmModifiedDate ON /* join condition not captured in parsed metadata */
;

Learn More