R_SalesOrderBillOfMaterialTP

DDL: R_SALESORDERBILLOFMATERIALTP Type: view_entity TRANSACTIONAL Package: CS_MODEL_API
43 Fields 1 Data Sources 2 Associations

Sales Order BOM Header TP

R_SalesOrderBillOfMaterialTP is a Transactional CDS View that provides data about "Sales Order BOM Header TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderBOMHeader) and exposes 43 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, EngineeringChangeDocument, Material. It has 2 associations to related views. Part of development package CS_MODEL_API.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderBOMHeader bom_header from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_BillOfMaterialTP _BillOfMaterialExtension $projection.BillOfMaterial = _BillOfMaterialExtension.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterialExtension.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BillOfMaterialExtension.BillOfMaterialVariant and $projection.BOMHeaderInternalChangeCount = _BillOfMaterialExtension.BOMHeaderInternalChangeCount
[0..*] R_SlsOrdBillOfMaterialItemTP _BillOfMaterialItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Sales Order BOM Header TP view
ObjectModel.sapObjectNodeType.name SalesBillOfMaterial view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory I_SalesOrderBOMHeader BillOfMaterialCategory BOM category
KEY BillOfMaterial
KEY BillOfMaterialVariant I_SalesOrderBOMHeader BillOfMaterialVariant AlternativeBOM
KEY EngineeringChangeDocument I_SalesOrderBOMHeader EngineeringChangeDocument Change Number
KEY Material I_SalesOrderBOMHeader Material Vehicle Model
KEY Plant I_SalesOrderBOMHeader Plant Valuation Area
SalesOrder I_SalesOrderBOMHeader SalesOrder SD Document
SalesOrderItem I_SalesOrderBOMHeader SalesOrderItem Sales Order Item
IsVersionBillOfMaterial I_SalesOrderBOMHeader IsVersionBillOfMaterial Versioning Relevant
LastChangeDateTime I_SalesOrderBOMHeader LastChangeDateTime Timestamp
EngineeringChangeDocForEdit I_SalesOrderBOMHeader EngineeringChangeDocument Change Number
BillOfMaterialHeaderUUID I_SalesOrderBOMHeader BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage I_SalesOrderBOMHeader BillOfMaterialVariantUsage Usage
ValidityStartDate I_SalesOrderBOMHeader HeaderValidityStartDate Valid From
ValidityEndDate I_SalesOrderBOMHeader HeaderValidityEndDate to
BOMHeaderInternalChangeCount I_SalesOrderBOMHeader BOMHeaderInternalChangeCount Counter
BOMHeaderText I_SalesOrderBOMHeader BOMHeaderText BOM Description
BOMExplosionApplication I_SalesOrderBOMHeader BOMExplosionApplication BOM Application
BOMUsagePriority I_SalesOrderBOMHeader BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp I_SalesOrderBOMHeader BillOfMaterialAuthsnGrp Auth group
BOMTechnicalType I_SalesOrderBOMHeader BOMTechnicalType Tech type
BOMGroup I_SalesOrderBOMHeader BOMGroup BOM group
BOMAlternativeText I_SalesOrderBOMHeader BOMAlternativeText Alt Text
BillOfMaterialStatus I_SalesOrderBOMHeader BillOfMaterialStatus BOM Status
ChgToEngineeringChgDocument I_SalesOrderBOMHeader ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion I_SalesOrderBOMHeader IsMarkedForDeletion Purch.org. data
BOMIsArchivedForDeletion I_SalesOrderBOMHeader BOMIsArchivedForDeletion Deletion flag
IsConfiguredMaterial I_SalesOrderBOMHeader IsConfiguredMaterial Configured matl
BOMIsConfigurableasBOMIsConfigurable
IsALEasIsALE
BOMHeaderBaseUnit I_SalesOrderBOMHeader BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit I_SalesOrderBOMHeader BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate I_SalesOrderBOMHeader RecordCreationDate Created On
LastChangeDate I_SalesOrderBOMHeader LastChangeDate Time Stamp
LastChangedByUser I_SalesOrderBOMHeader LastChangedByUser User Name
CreatedByUser I_SalesOrderBOMHeader CreatedByUser User Name
BOMIsToBeDeleted I_SalesOrderBOMHeader BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD I_SalesOrderBOMHeader DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice I_SalesOrderBOMHeader LaboratoryOrDesignOffice Lab/Office
BOMAssetNtwkHndovrIsRelevant I_SalesOrderBOMHeader BOMAssetNtwkHndovrIsRelevant BOM to AIN Handover
_Plant _Plant
_BOMChangeNumbers _BOMChangeNumbers
_BillOfMaterialItem _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 R_SalesOrderBillOfMaterialTP.
-- 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 R_SalesOrderBillOfMaterialTP AS
SELECT
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( bom_header.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.Material AS Material,
  bom_header.Plant AS Plant,
  bom_header.SalesOrder AS SalesOrder,
  bom_header.SalesOrderItem AS SalesOrderItem,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.LastChangeDateTime AS LastChangeDateTime,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocForEdit,
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.HeaderValidityStartDate AS ValidityStartDate,
  bom_header.HeaderValidityEndDate AS ValidityEndDate,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMExplosionApplication AS BOMExplosionApplication,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMTechnicalType AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bom_header.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant
FROM I_SalesOrderBOMHeader AS bom_header
LEFT OUTER JOIN E_BillOfMaterialTP AS _BillOfMaterialExtension ON BillOfMaterial = _BillOfMaterialExtension.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialExtension.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialExtension.BillOfMaterialVariant AND BOMHeaderInternalChangeCount = _BillOfMaterialExtension.BOMHeaderInternalChangeCount  -- association [1..1]
LEFT OUTER JOIN R_SlsOrdBillOfMaterialItemTP AS _BillOfMaterialItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More