P_SFITraceableAssldComp

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_SFITraceableAssldComp.
-- 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_SFITraceableAssldComp AS
SELECT
  SFIAssldTrcblCompByLdngResvn.Reservation AS Reservation,
  SFIAssldTrcblCompByLdngResvn.ReservationItem AS ReservationItem,
  SFIAssldTrcblCompByLdngResvn.RecordType AS RecordType,
  SFIAssldTrcblCompByLdngResvn.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIAssldTrcblCompByLdngResvn.OpActyNtwkElement AS OpActyNtwkElement,
  SFIAssldTrcblCompByLdngResvn.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  SFIAssldTrcblCompByLdngResvn.AssembledShopFloorItem AS ShopFloorItem,
  cast(SFIAssldTrcblCompByLdngResvn.Material as mpe_component_matnr preserving type ) AS Material,
  SFIAssldTrcblCompByLdngResvn.Plant AS Plant,
  SFIAssldTrcblCompByLdngResvn.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFIAssldTrcblCompByLdngResvn.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFIAssldTrcblCompByLdngResvn.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  SFIAssldTrcblCompByLdngResvn.ActiveReplaceShopFloorItem AS ActiveReplaceShopFloorItem,
  SFIAssldTrcblCompByLdngResvn.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  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.OriginalReservationItem AS OriginalReservationItem,
  OpActyInstceComponentDetail.AlternativeItemGroup AS AlternativeItemGroup,
  OpActyInstceComponentDetail.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  OpActyInstceComponentDetail.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OpActyInstceComponentDetail.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstceComponentDetail.EffectivityParameterVariant AS EffectivityParameterVariant,
  OpActyInstceComponentDetail.Assembly AS Assembly,
  _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  cast(OpActyInstceComponentDetail.MfgOrderComponentUsageNetQty as mpe_planned_qty preserving type ) AS RequiredQuantity,
  cast(SFIAssldTrcblCompByLdngResvn.MaterialComponentQuantity as mpe_consumed_qty_in_base_unit preserving type) AS ResvnItmWithdrawnQtyInBaseUnit,
  cast(SFIAssldCompByLdngResvnNoIn.MaterialComponentQuantity as enmng preserving type) AS ResvnItmTotalWithdrawnQty,
  SFIAssldTrcblCompByLdngResvn.MaterialBaseUnit AS MaterialBaseUnit,
  SFIAssldTrcblCompByLdngResvn.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,
  cast(OpActyInstceComponentDetail.ManufacturingOrderOperation as mpe_vornr_char preserving type) AS ManufacturingOrderOperation,
  OpActyNtwkInstanceBasic.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstceComponentDetail.MfgOrderOperationText AS MfgOrderOperationText,
  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,
  SFIAssldTrcblCompByLdngResvn._Material AS _Material,
  SFIAssldTrcblCompByLdngResvn._Plant AS _Plant,
  SFIAssldTrcblCompByLdngResvn._ProductPlantBasic AS _ProductPlantBasic,
  MatlPlntCompAssembleControl._MatlCompAssembleControl AS _MatlCompAssembleControl,
  OpActyInstceComponentDetail._BOMItemCategory AS _BOMItemCategory
FROM P_SFIAssldTrcblCompByLdngResvn AS SFIAssldTrcblCompByLdngResvn
INNER JOIN P_SFIAssldCompByLdngResvnNoIn AS SFIAssldCompByLdngResvnNoIn 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 _ParentShopFloorItem ON AssemblyShopFloorItem = _ParentShopFloorItem.ShopFloorItem  -- 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]
;