P_MatlBOMHdrLtstInstanceDets

DDL: P_MATLBOMHDRLTSTINSTANCEDETS SQL: PBOMLTSTINSDTS Type: view COMPOSITE
40 Fields 3 Data Sources

P_MatlBOMHdrLtstInstanceDets is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_MaterialBOMHdrLtstInstance, is, I_MaterialBOM) and exposes 40 fields with key fields BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory.

Data Sources (3)

SourceAliasJoin Type
P_MaterialBOMHdrLtstInstance BOMHdr from
is is inner
I_MaterialBOM MaterialBOM inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PBOMLTSTINSDTS 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 (40)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial P_MaterialBOMHdrLtstInstance BillOfMaterial BOM
KEY BillOfMaterialVariant P_MaterialBOMHdrLtstInstance BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialCategory P_MaterialBOMHdrLtstInstance BillOfMaterialCategory BOM category
EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument Change Number
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
BillOfMaterialUUID I_MaterialBOM BillOfMaterialUUID Character Field of Length 12
IsMultipleBOMAlt I_MaterialBOM IsMultipleBOMAlt Alt.det. MBOM
Material I_MaterialBOM Material Vehicle Model
RecordCreationDate I_MaterialBOM RecordCreationDate Created On
Plant I_MaterialBOM Plant Valuation Area
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

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_MatlBOMHdrLtstInstanceDets.
-- 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: PBOMLTSTINSDTS

CREATE VIEW P_MatlBOMHdrLtstInstanceDets AS
SELECT
  BOMHdr.BillOfMaterial AS BillOfMaterial,
  BOMHdr.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMHdr.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  MaterialBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  MaterialBOM.Material AS Material,
  MaterialBOM.RecordCreationDate AS RecordCreationDate,
  MaterialBOM.Plant AS Plant,
  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
FROM P_MaterialBOMHdrLtstInstance 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 */
;

Learn More