I_DistrActualCost

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 I_DistrActualCost.
-- 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 I_DistrActualCost AS
SELECT
  ControllingObject,
  PartnerControllingObject,
  CostElement,
  ControllingKeySubNumber,
  ControllingBusTransacType,
  PurchasingDocument,
  PurchasingDocumentItem,
  OriginSenderObject,
  Plant,
  Material,
  ControllingArea,
  CompanyCode,
  OrderID,
  sum( cast(AmountInTransactionCurrency as abap.dec( 23, 2 )) * -1 ) AS AmountInTransactionCurrency,
  TransactionCurrency,
  sum( cast(AmountInCtrlgObjectCurrency as abap.dec( 23, 2 )) * -1 ) AS AmountInCtrlgObjectCurrency,
  ControllingObjectCurrency,
  sum( cast(AmountInCtrlgAreaCrcy as abap.dec( 23, 2 )) * -1 ) AS AmountInCtrlgAreaCrcy,
  ControllingAreaCurrency,
  sum( DistrdTotalMaterialQuantity * -1 ) AS DistrdTotalMaterialQuantity,
  max(DistributionPostingDate) AS DistributionPostingDate,
  cast(max(I_DistrAccountingData.LastChangeDateTime) as timestampl) AS LastChangeDateTime
FROM I_DistrAccountingData
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransCurrency ON TransactionCurrency = _TransCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingObjectCurrency ON ControllingObjectCurrency = _ControllingObjectCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DistrdTotMatlQtyUnit ON DistrdTotalMaterialQtyUnit = _DistrdTotMatlQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ProductCostCtrlgOrderItem AS _OrderItem ON OrderID = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _POItem ON PurchasingDocument = _POItem.PurchasingDocument AND PurchasingDocumentItem = _POItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;