C_COPCCOrderAndItemCostsCube

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 C_COPCCOrderAndItemCostsCube.
-- 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: CFIPCCOAICSTCUBE
-- Parameters: P_OrderID : fis_order_number, P_OrderItem : char4, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_PlanningCategory : fcom_category, P_ResultAnalysisVersion : versn, P_Language : sylangu, P_CurrencyRole : fac_crcyrole, P_CostCompIsForCOGM : char1, P_ControllingObject : j_objnr

CREATE VIEW C_COPCCOrderAndItemCostsCube AS
SELECT
  CostElement,
  CtrlgOriginClassification,
  ControllingDebitCreditCode,
  MfgOrderBusTransactionType,
  cast(OriginCostCenter as fis_usp_kostl) AS OriginCostCenter,
  OriginCostCtrActivityType,
  OriginBusinessProcess,
  OriginOrder,
  CostOriginType,
  cast(ltrim(OriginObject, '0') as kkb_herku) AS OriginObject,
  CostOriginGroup,
  cast(PartnerCostCenter as fis_skost) AS PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerBusinessProcess,
  PartnerOrder,
  cast(ltrim(PartnerCostObject, '0') as kkb_partn) AS PartnerCostObject,
  Plant,
  Material,
  SalesOrder,
  ControllingArea,
  CompanyCode,
  ProfitCenter,
  ResponsibleCostCenter,
  OrderCategory,
  OrderType,
  ChartOfAccounts,
  cast('' as ck_element) AS CostComponent,
  cast('' as fis_ck_el_grup) AS CostComponentGroup,
  cast('' as ck_herko) AS CostCompIsForCOGM,
  cast('' as fis_kstar_name) AS GLAccountName,
  cast('' as fis_origin_cost_center_name) AS CostCenterName,
  cast('' as fis_origin_activity_type_name) AS CostCtrActivityTypeName,
  cast('' as fco_cost_component_name) AS CostComponentName,
  cast('' as fis_ck_txgrp) AS CostComponentGroupName,
  UnitOfMeasure,
  ActualQtyInCostSourceUnit,
  PlanQtyInCostSourceUnit,
  TargetQtyInCostSourceUnit,
  PlanCtrlQtyInCostSourceUnit,
  ActlCtrlQtyInCostSourceUnit,
  cast(0 as fis_dspcrcy_actlplndiffpct) AS DspCrcyActlPlanDiffPct,
  DebitActlPlanDiffPercent,
  ActlPlanDiffQuantity,
  cast(0 as fis_actlplandiffoutpqtypercent) AS ActlPlanDiffQtyPct,
  cast( 0 as fis_dspcrcy_actltgtdiffpct) AS DspCrcyActlTgtDiffPct,
  DebitActlTgtDiffPercent,
  ActlTgtDiffQuantity,
  cast(0 as fis_actltgtdiffqtypct) AS ActlTgtDiffQtyPct,
  cast(0 as fis_dspcrcy_plnctrltgtdiffpct) AS DspCrcyPlnCtrlTgtDiffPct,
  cast(0 as fis_planctrltgt_diffqtypct) AS PlanCtrlTgtDiffQtyPct,
  cast(0 as fis_dspcrcy_actlctrltgtdiffpct) AS DspCrcyActlCtrlTgtDiffPct,
  cast(0 as fis_actlctrltgt_diffqtypct) AS ActlCtrlTgtDiffQtyPct,
  cast(_Material._Text[1: Language = $parameters.P_Language].MaterialName as fis_material_text) AS MaterialName,
  cast( _MfgDebitCreditCode._Text[1: Language = $parameters.P_Language].MfgDebitCreditCodeName as fis_debit_indicator_text) AS MfgDebitCreditCodeName,
  _COProdnOrderBusTrans._Text[1: Language = $parameters.P_Language].MfgOrderBusTransactionTypeName AS MfgOrderBusTransactionTypeName
FROM I_COPCCOrderAndItemCostsCube
;