R_BOMItmObjDpnAssignmentTP

DDL: R_BOMITMOBJDPNASSIGNMENTTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 2 Associations

BOM Item Dependency Assignment - TP

R_BOMItmObjDpnAssignmentTP is a Transactional CDS View that provides data about "BOM Item Dependency Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_BOMItmObjDpnAssignment) and exposes 15 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, HeaderChangeDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BOMItmObjDpnAssignment I_BOMItmObjDpnAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_BillOfMaterialTP _BillOfMaterial $projection.BillOfMaterial = _BillOfMaterial.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterial.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BillOfMaterial.BillOfMaterialVersion and $projection.HeaderChangeDocument = _BillOfMaterial.EngineeringChangeDocument and $projection.Material = _BillOfMaterial.Material and $projection.Plant = _BillOfMaterial.Plant
[1..*] R_VarCnfHistlObjDpndcyTP _HistoricalObjectDependency $projection.ObjectDependencyName = _HistoricalObjectDependency.ObjectDependencyName and $projection.ValidityStartDate <= _HistoricalObjectDependency.ValidityEndDate and $projection.ValidityEndDate >= _HistoricalObjectDependency.ValidityStartDate

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label BOM Item Dependency Assignment - TP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY HeaderChangeDocument HeaderChangeDocument Change Number
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber Item node
KEY ObjectDependencyName ObjectDependencyName
ObjDpnProcessingSequenceValue ObjDpnProcessingSequenceValue
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_HistoricalObjectDependency _HistoricalObjectDependency
_BillOfMaterialItem _BillOfMaterialItem
_BillOfMaterial _BillOfMaterial

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_BOMItmObjDpnAssignmentTP.
-- 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_BOMItmObjDpnAssignmentTP AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  HeaderChangeDocument,
  Material,
  Plant,
  BillOfMaterialItemNodeNumber,
  ObjectDependencyName,
  ObjDpnProcessingSequenceValue,
  ValidityStartDate,
  ValidityEndDate
FROM I_BOMItmObjDpnAssignment
LEFT OUTER JOIN R_BillOfMaterialTP AS _BillOfMaterial ON BillOfMaterial = _BillOfMaterial.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterial.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterial.BillOfMaterialVersion AND HeaderChangeDocument = _BillOfMaterial.EngineeringChangeDocument AND Material = _BillOfMaterial.Material AND Plant = _BillOfMaterial.Plant  -- association [1..1]
LEFT OUTER JOIN R_VarCnfHistlObjDpndcyTP AS _HistoricalObjectDependency ON ObjectDependencyName = _HistoricalObjectDependency.ObjectDependencyName AND ValidityStartDate <= _HistoricalObjectDependency.ValidityEndDate AND ValidityEndDate >= _HistoricalObjectDependency.ValidityStartDate  -- association [1..*]
;

Learn More