A_MaintenanceBillOfMaterial

DDL: A_MAINTENANCEBILLOFMATERIAL Type: view_entity COMPOSITE
40 Fields 1 Data Sources 1 Associations 1 OData Services

Maintenance Bill Of Material

A_MaintenanceBillOfMaterial is a Composite CDS View that provides data about "Maintenance Bill Of Material" in SAP S/4HANA. It reads from 1 data source (R_MaintBillOfMaterialTP) and exposes 40 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, TechnicalObject. It has 1 association to related views. It is exposed through 1 OData service (API_MAINTENANCEBOM).

Data Sources (1)

SourceAliasJoin Type
R_MaintBillOfMaterialTP R_MaintBillOfMaterialTP projection

Associations (1)

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

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Maintenance Bill Of Material view
OData.entityType.name MaintBOMHeader_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_MAINTENANCEBOM API_MAINTENANCEBOM V2 C2 C1

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY TechnicalObject TechnicalObject Technical Object
KEY Plant Plant Valuation Area
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID Guid
IsMultipleBOMAlt IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount Counter
BOMUsagePriority BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus BOMVersionStatus BOM Version Status
IsVersionBillOfMaterial IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion IsLatestBOMVersion Latest Rel Version
IsConfiguredMaterial IsConfiguredMaterial Configured matl
BOMTechnicalType BOMTechnicalType Tech type
BOMGroup BOMGroup BOM group
BOMHeaderText BOMHeaderText BOM Description
BOMAlternativeText BOMAlternativeText Alt Text
BillOfMaterialStatus BillOfMaterialStatus BOM Status
HeaderValidityStartDate HeaderValidityStartDate Valid From
HeaderValidityEndDate HeaderValidityEndDate to
ChgToEngineeringChgDocument ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
IsALE IsALE ALE indicator
BOMHeaderBaseUnit BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate RecordCreationDate Created On
LastChangeDate LastChangeDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
BOMIsToBeDeleted BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice LaboratoryOrDesignOffice Lab/Office
SelectedBillOfMaterialVersion SelectedBillOfMaterialVersion
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
_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_MaintenanceBillOfMaterial.
-- 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.

CREATE VIEW A_MaintenanceBillOfMaterial AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  TechnicalObject,
  Plant,
  EngineeringChangeDocument,
  BillOfMaterialVariantUsage,
  BillOfMaterialHeaderUUID,
  IsMultipleBOMAlt,
  BOMHeaderInternalChangeCount,
  BOMUsagePriority,
  BillOfMaterialAuthsnGrp,
  BOMVersionStatus,
  IsVersionBillOfMaterial,
  IsLatestBOMVersion,
  IsConfiguredMaterial,
  BOMTechnicalType,
  BOMGroup,
  BOMHeaderText,
  BOMAlternativeText,
  BillOfMaterialStatus,
  HeaderValidityStartDate,
  HeaderValidityEndDate,
  ChgToEngineeringChgDocument,
  IsMarkedForDeletion,
  IsALE,
  BOMHeaderBaseUnit,
  BOMHeaderQuantityInBaseUnit,
  RecordCreationDate,
  LastChangeDate,
  CreatedByUser,
  LastChangedByUser,
  BOMIsToBeDeleted,
  DocumentIsCreatedByCAD,
  LaboratoryOrDesignOffice,
  SelectedBillOfMaterialVersion,
  Equipment,
  FunctionalLocation
FROM R_MaintBillOfMaterialTP
LEFT OUTER JOIN A_BillOfMaterialUsage AS _BillOfMaterialUsage ON BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage  -- association [0..1]
;

Learn More