P_SFOTraceableAssldComp

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 P_SFOTraceableAssldComp.
-- 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 P_SFOTraceableAssldComp AS
SELECT
  SFOAssldTrcblCompByLdngResvn.Reservation AS Reservation,
  SFOAssldTrcblCompByLdngResvn.ReservationItem AS ReservationItem,
  SFOAssldTrcblCompByLdngResvn.RecordType AS RecordType,
  SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement AS OpActyNtwkElement,
  SFOAssldTrcblCompByLdngResvn.ShopFloorItem AS ShopFloorItem,
  SFOAssldTrcblCompByLdngResvn.Batch AS Batch,
  cast(SFOAssldTrcblCompByLdngResvn.Material as mpe_component_matnr preserving type ) AS Material,
  SFOAssldTrcblCompByLdngResvn.Plant AS Plant,
  SFOAssldTrcblCompByLdngResvn.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  SFOAssldTrcblCompByLdngResvn.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFOAssldTrcblCompByLdngResvn.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFOAssldTrcblCompByLdngResvn.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstceComponentDetail.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  OpActyInstceComponentDetail.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyInstceComponentDetail.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OpActyInstceComponentDetail.BOMItem AS BOMItem,
  OpActyInstceComponentDetail.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstceComponentDetail.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstceComponentDetail.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyInstceComponentDetail.BOMItemCategory AS BOMItemCategory,
  OpActyInstceComponentDetail.AlternativeItemGroup AS AlternativeItemGroup,
  OpActyInstceComponentDetail.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  OpActyInstceComponentDetail.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OpActyInstceComponentDetail.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstceComponentDetail.EffectivityParameterVariant AS EffectivityParameterVariant,
  _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  OpActyInstceComponentDetail.Assembly AS Assembly,
  cast(OpActyInstceComponentDetail.RequiredQuantity as mpe_planned_qty preserving type ) AS RequiredQuantity,
  OpActyInstceComponentDetail.RequiredQuantityInBaseUnit AS RequiredQuantityInBaseUnit,
  cast(SFOAssldTrcblCompByLdngResvn.MaterialComponentQuantity as mpe_consumed_qty_in_base_unit preserving type) AS ResvnItmWithdrawnQtyInBaseUnit,
  cast(SFOAssldCompByLdngResvnNoIn.MaterialComponentQuantity as enmng preserving type) AS ResvnItmTotalWithdrawnQty,
  SFOAssldTrcblCompByLdngResvn.MaterialBaseUnit AS MaterialBaseUnit,
  SFOAssldTrcblCompByLdngResvn.EntryUnit AS EntryUnit,
  OpActyInstceComponentDetail.FormulaKey AS FormulaKey,
  OpActyInstceComponentDetail.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyInstceComponentDetail.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyInstceComponentDetail.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyInstceComponentDetail.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  OpActyInstceComponentDetail.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyInstceComponentDetail.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  SFOAssldTrcblCompByLdngResvn.ManufacturingOrder AS ManufacturingOrder,
  cast(OrderOperationBasic.Operation_2 as mpe_vornr_char preserving type) AS Operation,
  OrderOperationBasic.OperationText AS OperationText,
  OpActyNtwkInstanceBasic.OrderInternalID AS OrderInternalID,
  OpActyNtwkInstanceBasic.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyNtwkInstanceBasic.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyNtwkInstanceBasic.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  _ShopFloorItem.SerialNumber AS SerialNumber,
  cast(_ShopFloorItem._Equipment.ManufacturerSerialNumber as mpe_mfr_sernr preserving type) AS ManufacturerSerialNumber,
  InstanceReferenceDesignator.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  MatlPlntCompAssembleControl.MatlCompAssembleControl AS MatlCompAssembleControl,
  OpActyInstceComponentDetail.DebitCreditCode AS DebitCreditCode,
  SFOAssldTrcblCompByLdngResvn._ManufacturingOrder AS _ManufacturingOrder,
  SFOAssldTrcblCompByLdngResvn._Material AS _Material,
  SFOAssldTrcblCompByLdngResvn._Plant AS _Plant,
  SFOAssldTrcblCompByLdngResvn._ProductPlantBasic AS _ProductPlantBasic,
  MatlPlntCompAssembleControl._MatlCompAssembleControl AS _MatlCompAssembleControl,
  OpActyInstceComponentDetail._BOMItemCategory AS _BOMItemCategory
FROM P_SFOAssldTrcblCompByLdngResvn AS SFOAssldTrcblCompByLdngResvn
INNER JOIN P_SFOAssldCompByLdngResvnNoIn AS SFOAssldCompByLdngResvnNoIn ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlPlntCompAssembleControl AS MatlPlntCompAssembleControl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItemBasic ON BillOfMaterialCategory = _BillOfMaterialItemBasic.BillOfMaterialCategory AND BillOfMaterialInternalID = _BillOfMaterialItemBasic.BillOfMaterial AND BOMItem = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _MfgBOMItemWithPhantomHier ON BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory AND BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial AND BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
LEFT OUTER JOIN I_MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails ON MfgRefStructureItemDetailUUID = _MfgRefStrucItemWithDetails.MfgRefStructureItemUUID AND MfgRefStrucItmDetIsContextual = ''  -- association [0..1]
LEFT OUTER JOIN I_MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails ON MfgRefStructureItemDetailUUID = _MfgRefHierItemWithDetails.MfgRefHierarchyItemUUID AND MfgRefStrucItmDetIsContextual = 'X'  -- association [0..1]
;