R_MaintBillOfMaterialTP

DDL: R_MAINTBILLOFMATERIALTP SQL: IMAINTBOMHEADRTP Type: view_entity TRANSACTIONAL
52 Fields 1 Data Sources 2 Associations

Maintenance BOM

R_MaintBillOfMaterialTP is a Transactional CDS View that provides data about "Maintenance BOM" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceBillOfMaterial) and exposes 52 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, Plant. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceBillOfMaterial bom_header from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel _FunctionalLocationLabel.FunctionalLocation = bom_header.TechnicalObject and $projection.BillOfMaterialCategory = 'T'
[0..*] R_MaintBillOfMaterialItemTP _MaintBillOfMaterialItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance BOM view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name MaintenanceBillOfMaterial view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
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
LastChangeDateTime LastChangeDateTime Timestamp
SelectedBillOfMaterialVersion SelectedBillOfMaterialVersion
ChangeNumberObjectType ChangeNumberObjectType
CreatedByUserName CreatedByUserName Person Resp.
ChangedByUserName ChangedByUserName
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechnicalObjectLabel Technical Object
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
_FunctionalLocation _FunctionalLocation
_MaintBillOfMaterialCategory _MaintBillOfMaterialCategory
_MaintBillOfMaterialUsage _MaintBillOfMaterialUsage
_Plant _Plant
_MaintTechObjBOMChgNumber _MaintTechObjBOMChgNumber
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_MaintBillOfMaterialItem _MaintBillOfMaterialItem

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 R_MaintBillOfMaterialTP.
-- 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: IMAINTBOMHEADRTP

CREATE VIEW R_MaintBillOfMaterialTP AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  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,
  LastChangeDateTime,
  SelectedBillOfMaterialVersion,
  ChangeNumberObjectType,
  CreatedByUserName,
  ChangedByUserName,
  TechObjIsEquipOrFuncnlLoc,
  cast (TechnicalObject as eams_tech_obj_alpha_conv preserving type ) AS TechnicalObjectLabel,
  Equipment,
  FunctionalLocation
FROM I_MaintenanceBillOfMaterial AS bom_header
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = bom_header.TechnicalObject AND BillOfMaterialCategory = 'T'  -- association [0..1]
LEFT OUTER JOIN R_MaintBillOfMaterialItemTP AS _MaintBillOfMaterialItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More