P_SFODsassldTrcblComponent

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_SFODsassldTrcblComponent.
-- 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_SFODsassldTrcblComponent AS
SELECT
  SFIDsassldCompByCompInstce.Reservation AS Reservation,
  SFIDsassldCompByCompInstce.ReservationItem AS ReservationItem,
  SFIDsassldCompByCompInstce.RecordType AS RecordType,
  SFIDsassldCompByCompInstce.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIDsassldCompByCompInstce.OpActyNtwkElement AS OpActyNtwkElement,
  SFIDsassldCompByCompInstce.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  SFIDsassldCompByCompInstce.ShopFloorItem AS ShopFloorItem,
  SFIDsassldCompByCompInstce.Batch AS Batch,
  cast(OpActyInstceComponentDetail.Material as mpe_component_matnr preserving type ) AS Material,
  OpActyInstceComponentDetail.Plant AS Plant,
  SFIDsassldCompByCompInstce.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  SFIDsassldCompByCompInstce.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFIDsassldCompByCompInstce.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFIDsassldCompByCompInstce.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.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstceComponentDetail.AlternativeItemGroup AS AlternativeItemGroup,
  OpActyInstceComponentDetail.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  OpActyInstceComponentDetail.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OpActyInstceComponentDetail.EffectivityParameterVariant AS EffectivityParameterVariant,
  OpActyInstceComponentDetail.Assembly AS Assembly,
  _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  cast(OpActyInstceComponentDetail.RequiredQuantity as mpe_planned_qty preserving type ) AS RequiredQuantity,
  OpActyInstceComponentDetail.RequiredQuantityInBaseUnit AS RequiredQuantityInBaseUnit,
  cast(SFIDsassldCompByCompInstce.MaterialComponentQuantity as mpe_returned_qty_in_base_unit preserving type) AS ResvnItmWithdrawnQtyInBaseUnit,
  cast(SFIDsassldCompByComponent.MaterialComponentQuantity as enmng preserving type) AS ResvnItmTotalWithdrawnQty,
  SFIDsassldCompByCompInstce.MaterialBaseUnit AS MaterialBaseUnit,
  SFIDsassldCompByCompInstce.ComponentAssemblyType AS ComponentAssemblyType,
  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,
  OpActyNtwkInstanceBasic.ManufacturingOrder AS ManufacturingOrder,
  cast(OpActyInstceComponentDetail.ManufacturingOrderOperation as mpe_vornr_char preserving type) AS ManufacturingOrderOperation,
  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,
  OpActyInstceComponentDetail._Material AS _Material,
  OpActyInstceComponentDetail._Plant AS _Plant,
  MatlPlntCompAssembleControl._MatlCompAssembleControl AS _MatlCompAssembleControl,
  OpActyInstceComponentDetail._BOMItemCategory AS _BOMItemCategory
FROM P_SFODisassemblyByCompInstce AS SFIDsassldCompByCompInstce
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_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [0..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_DisassembledComponentOrigin AS _DisassembledComponentOrigin ON DisassembledComponentOrigin = _DisassembledComponentOrigin.DisassembledComponentOrigin  -- association [1..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]
;