P_EBOC_COGM_OrderAndItemCosts2

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_EBOC_COGM_OrderAndItemCosts2.
-- 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: PEBOCCOGMHDRITM2
-- Parameters: P_OrderID : fis_order_number, P_OrderItem : char4, P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_Ledger : fins_ledger, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_EBOC_COGM_OrderAndItemCosts2 AS
SELECT
  CompanyCode,
  ControllingArea,
  ControllingValueType,
  CostElement,
  ControllingKeySubNumber,
  ControllingDebitCreditCode,
  PartnerAccountAssignment,
  OriginSenderObject,
  CtrlgOriginClassification,
  UnitOfMeasure,
  SubLedgerAcctLineItemType,
  IsLotSizeIndependent,
  cast(Plant as werks_d) AS Plant,
  cast(Material as matnr) AS Material,
  cast(CostOriginGroup as fis_hrkft) AS CostOriginGroup,
  PartnerObjectType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  cast(PartnerBusinessProcess as par_prznr) AS PartnerBusinessProcess,
  PartnerOrder,
  OrderID,
  OrderItem,
  OrderCategory,
  MfgOrderHasMultipleItems,
  AccountAssignmentType,
  :P_OrderID AS POrderID,
  :P_OrderItem AS POrderItem,
  AmountInDisplayCurrency
FROM P_EBOC_COGM_OrderAndItemCosts1
;