R_MfgBOMPathItemTP

DDL: R_MFGBOMPATHITEMTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources

MRS: BOM Path Item

R_MfgBOMPathItemTP is a Transactional CDS View that provides data about "MRS: BOM Path Item" in SAP S/4HANA. It reads from 1 data source (I_MfgBOMPathItem) and exposes 23 fields with key fields MfgMaterialPathUUID, MfgMatPathItemSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
I_MfgBOMPathItem I_MfgBOMPathItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRS: BOM Path Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MfgMaterialPathUUID I_MfgBOMPathItem MfgMaterialPathUUID Material Path UUID
KEY MfgMatPathItemSequenceNumber I_MfgBOMPathItem MfgMatPathItemSequenceNumber Sort Sequence
ParentSequenceNumber I_MfgBOMPathItem ParentSequenceNumber Number
Material I_MfgBOMPathItem Material Vehicle Model
BillOfMaterialCategory I_MfgBOMPathItem BillOfMaterialCategory BOM category
BillOfMaterialUsage I_MfgBOMPathItem BillOfMaterialUsage Usage
BillOfMaterial I_MfgBOMPathItem BillOfMaterial BOM
AlternativeBillOfMaterial I_MfgBOMPathItem AlternativeBillOfMaterial AlternativeBOM
InheritedBOMItemNode I_MfgBOMPathItem InheritedBOMItemNode Nodes
InheritedNodeNumberVersionBOM I_MfgBOMPathItem InheritedNodeNumberVersionBOM Item node
BOMItemInstanceUUID I_MfgBOMPathItem BOMItemInstanceUUID DMU GUID
BOMVersionStart I_MfgBOMPathItem BOMVersionStart BOM Version
BOMVersionEnd I_MfgBOMPathItem BOMVersionEnd BOM Version
ProductionOrder I_MfgBOMPathItem ProductionOrder Order
OrderSpecificRoutingVersion I_MfgBOMPathItem OrderSpecificRoutingVersion Routing Version
MfgSubBillOfMaterialCategory I_MfgBOMPathItem MfgSubBillOfMaterialCategory BOM category
MfgSubBillOfMaterialUsage I_MfgBOMPathItem MfgSubBillOfMaterialUsage Usage
MfgSubBillOfMaterial I_MfgBOMPathItem MfgSubBillOfMaterial
MfgSubAlternativeBOM I_MfgBOMPathItem MfgSubAlternativeBOM AlternativeBOM
SubordinateBOMVersionStart I_MfgBOMPathItem SubordinateBOMVersionStart BOM Version
SubordinateBOMVersionEnd I_MfgBOMPathItem SubordinateBOMVersionEnd BOM Version
MfgMaterialPathItemIsGeneric I_MfgBOMPathItem MfgMaterialPathItemIsGeneric MathPathItemGeneric
_MfgBOMPath _MfgBOMPath

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_MfgBOMPathItemTP.
-- 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_MfgBOMPathItemTP AS
SELECT
  I_MfgBOMPathItem.MfgMaterialPathUUID AS MfgMaterialPathUUID,
  I_MfgBOMPathItem.MfgMatPathItemSequenceNumber AS MfgMatPathItemSequenceNumber,
  I_MfgBOMPathItem.ParentSequenceNumber AS ParentSequenceNumber,
  I_MfgBOMPathItem.Material AS Material,
  I_MfgBOMPathItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  I_MfgBOMPathItem.BillOfMaterialUsage AS BillOfMaterialUsage,
  I_MfgBOMPathItem.BillOfMaterial AS BillOfMaterial,
  I_MfgBOMPathItem.AlternativeBillOfMaterial AS AlternativeBillOfMaterial,
  I_MfgBOMPathItem.InheritedBOMItemNode AS InheritedBOMItemNode,
  I_MfgBOMPathItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  I_MfgBOMPathItem.BOMItemInstanceUUID AS BOMItemInstanceUUID,
  I_MfgBOMPathItem.BOMVersionStart AS BOMVersionStart,
  I_MfgBOMPathItem.BOMVersionEnd AS BOMVersionEnd,
  I_MfgBOMPathItem.ProductionOrder AS ProductionOrder,
  I_MfgBOMPathItem.OrderSpecificRoutingVersion AS OrderSpecificRoutingVersion,
  I_MfgBOMPathItem.MfgSubBillOfMaterialCategory AS MfgSubBillOfMaterialCategory,
  I_MfgBOMPathItem.MfgSubBillOfMaterialUsage AS MfgSubBillOfMaterialUsage,
  I_MfgBOMPathItem.MfgSubBillOfMaterial AS MfgSubBillOfMaterial,
  I_MfgBOMPathItem.MfgSubAlternativeBOM AS MfgSubAlternativeBOM,
  I_MfgBOMPathItem.SubordinateBOMVersionStart AS SubordinateBOMVersionStart,
  I_MfgBOMPathItem.SubordinateBOMVersionEnd AS SubordinateBOMVersionEnd,
  I_MfgBOMPathItem.MfgMaterialPathItemIsGeneric AS MfgMaterialPathItemIsGeneric
FROM I_MfgBOMPathItem
;

Learn More