P_EBWIP_OrderCost2

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_EBWIP_OrderCost2.
-- 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.
-- SQL view name: PEBWIPORDCST2
-- Parameters: P_KeyDate : fins_fperiod_enddate, P_Ledger : fins_ledger, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_EBWIP_OrderCost2 AS
SELECT
  _OrderHeader.CompanyCode AS CompanyCode,
  _OrderHeader.OrderID AS OrderID,
  _OrderHeader.ObjectInternalID AS ObjectInternalID,
  OrderDescription,
  OrderType,
  OrderCategory,
  _OrderHeader.Material AS Material,
  _OrderHeader.Plant AS Plant,
  ProfitCenter,
  ControllingArea,
  _OrderHeader.FunctionalArea AS FunctionalArea,
  _OrderHeader.StorageLocation AS StorageLocation,
  _OrderHeader.MRPArea AS MRPArea,
  _OrderHeader.MRPPlant AS MRPPlant,
  MfgOrderHasMultipleItems,
  CombnOrdCombinationIdentifier,
  CombinedOrder,
  RequestOrderType,
  SuperiorOrder,
  _LdgrCompCodeCrcy.Currency AS DisplayCurrency,
  WIPCostInDspCrcy,
  ReservesUnrealizedCostsAmount,
  coalesce(ProducedAmountInDspCrcy, 0) AS ProducedAmountInDspCrcy,
  coalesce(CompletedQuantityToDate, 0) AS CompletedQuantityToDate,
  coalesce(ActualOutputQuantity, 0) AS ActualOutputQuantity,
  case when CostingLotSize <> 0 and OrderCategory <> '05' then cast( _MaterialCostEstimate.LotSizeIndependentCosts + ( round(cast(division(_PlanOutPutQuantity.PlanOutputQuantity, CostingLotSize, 3) as abap.dec(14, 6)) * _MaterialCostEstimate.PlanCostInDspCrcy, 2) ) as abap.curr( 23, 2 ) ) else 0 end as PlanCostAmountInDspCrcy AS curr232else0endasPlanCostAmountInDspCrcy,
  _OrderHeader.UnitOfMeasure AS UnitOfMeasure,
  _PlanOutPutQuantity.PlanOutputQuantity AS OrderPlannedTotalQty,
  _OrderHeader.CreatedByUser AS CreatedByUser,
  _OrderHeader.CreationDate AS CreationDate,
  _OrderHeader.LastChangedByUser AS LastChangedByUser,
  _OrderHeader.LastChangeDate AS LastChangeDate
FROM P_EBWIP_Order
INNER JOIN P_EBWIP_WIP3 ON /* join condition not captured in parsed metadata */
;