A_BillOfMaterial

DDL: A_BILLOFMATERIAL SQL: ABILLOFMATERIAL Type: view COMPOSITE Package: CS_OP
40 Fields 1 Data Sources 2 Associations

Bill of Material

A_BillOfMaterial is a Composite CDS View that provides data about "Bill of Material" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialAPITP) and exposes 40 fields with key field BillOfMaterialHeaderUUID. It has 2 associations to related views. Part of development package CS_OP.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterialAPITP bom_header from

Associations (2)

CardinalityTargetAliasCondition
[0..1] A_BillOfMaterialUsage _BillOfMaterialUsage $projection.BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage
[0..*] A_BillOfMaterialItem _BillOfMaterialItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ABILLOFMATERIAL view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of Material view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (40)

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

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 A_BillOfMaterial.
-- 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: ABILLOFMATERIAL

CREATE VIEW A_BillOfMaterial AS
SELECT
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterial AS BillOfMaterial,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.Material AS Material,
  bom_header.Plant AS Plant,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.IsLatestBOMVersion AS IsLatestBOMVersion,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  cast ( bom_header.BOMTechnicalType as tetyp_d preserving type) AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.EngineeringChangeDocForEdit AS EngineeringChangeDocForEdit,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.IsALE AS IsALE,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  SelectedBillOfMaterialVersion
FROM I_BillOfMaterialAPITP AS bom_header
LEFT OUTER JOIN A_BillOfMaterialUsage AS _BillOfMaterialUsage ON BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage  -- association [0..1]
LEFT OUTER JOIN A_BillOfMaterialItem AS _BillOfMaterialItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More