P_EBOC_COGM_OrderAndItemCosts

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_OrderAndItemCosts.
-- 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: PEBOCCOGMHDRITM
-- Parameters: P_OrderID : fis_order_number, P_OrderItem : char4, P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_Ledger : fins_ledger, P_CostComponentStructure : ck_elesmhk, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_EBOC_COGM_OrderAndItemCosts AS
SELECT
  CostElement,
  cast(CtrlgOriginClassification as fis_kkb_herkz) AS CtrlgOriginClassification,
  ControllingDebitCreditCode,
  CostOriginGroup,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerBusinessProcess,
  PartnerOrder,
  cast(UnitOfMeasure as co_meinh) AS UnitOfMeasure,
  Material,
  IsLotSizeIndependent,
  cast('%' as msehi) AS RatioUnit,
  DisplayCurrency,
  ControllingArea,
  CompanyCode,
  ProfitCenter,
  ResponsibleCostCenter,
  OrderCategory,
  OrderType,
  Plant,
  SalesOrder,
  ChartOfAccounts,
  $session.system_date AS ValidityDate,
  cast(DebitActlCostInDspCrcy as fis_dr_actlcost_in_dspcrcy) AS DebitActlCostInDspCrcy,
  cast(DebitPlanCostInDspCrcy as fis_dr_plancost_in_dspcrcy) AS DebitPlanCostInDspCrcy,
  cast(DebitTargetCostInDspCrcy as fis_dr_tgtcost_in_dspcrcy) AS DebitTargetCostInDspCrcy,
  cast(DebitActlTgtDiffCostInDspCrcy as fis_dractltgtdiffcostindspcrcy) AS DebitActlTgtDiffCostInDspCrcy,
  cast( CostComponentStructure as ck_elesmhk) AS CostComponentStructure
FROM P_EBOC_COGM_OrderAndItemCosts4
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MfgDebitCreditCode AS _MfgDebitCreditCode ON ControllingDebitCreditCode = _MfgDebitCreditCode.ManufacturingDebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountTxt ON ChartOfAccounts = _GLAccountTxt.ChartOfAccounts AND CostElement = _GLAccountTxt.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_CostComponentText AS _CostComponentTxt ON CostComponent = _CostComponentTxt.CostComponent AND CostComponentStructure = _CostComponentTxt.CostComponentStructure  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _PartnerCostCenterText ON PartnerCostCenter = _PartnerCostCenterText.CostCenter AND ControllingArea = _PartnerCostCenterText.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _PrtrCostCenterActvtTypeText ON ControllingArea = _PrtrCostCenterActvtTypeText.ControllingArea AND PartnerCostCtrActivityType = _PrtrCostCenterActvtTypeText.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
;