P_CostCtrClassicCmtmtUnion

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_CostCtrClassicCmtmtUnion.
-- 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: PCSTCTRCMTMTCL

CREATE VIEW P_CostCtrClassicCmtmtUnion AS
SELECT
  cast('00000000000000000000000' as fis_fp_request_tsn) AS FinancialPlanningReqTransSqnc,
  cast('000000' as rsdatapid) AS FinancialPlanningDataPacket,
  cast(0 as rsarecord) AS FinancialPlanningEntryItem,
  cast('' as fis_docln) AS LedgerGLLineItem,
  cast('' as fis_rldnr) AS Ledger,
  cast('' as fis_belnr) AS AccountingDocument,
  ControllingArea,
  CompanyCode,
  FiscalYear,
  CostCenter,
  CostElement AS GLAccount,
  PurchasingDocument,
  PurchasingDocumentItem,
  FiscalYearVariant,
  FiscalPeriod,
  cast('' as fins_ledger_pers) AS SourceLedger,
  cast(Supplier as md_supplier preserving type ) AS Supplier,
  Material,
  TotalQuantity AS CommittedQuantity,
  cast(0 as vquan1_12 ) AS PlannedQuantity,
  cast(0 as quan1_12) AS Quantity,
  UnitOfMeasure,
  ChartOfAccounts,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PostingDate,
  cast('' as fis_category) AS PlanningCategory,
  cast(CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  cast(ControllingAreaCurrency as fis_rkcur preserving type ) AS GlobalCurrency,
  cast('' as fins_currfc) AS FunctionalCurrency,
  cast('' as fis_rocur) AS FreeDefinedCurrency1,
  cast('' as fis_rvcur) AS FreeDefinedCurrency2,
  cast('' as fins_curr3) AS FreeDefinedCurrency3,
  cast('' as fins_curr4) AS FreeDefinedCurrency4,
  cast('' as fins_curr5) AS FreeDefinedCurrency5,
  cast('' as fins_curr6) AS FreeDefinedCurrency6,
  cast('' as fis_rfcur) AS FreeDefinedCurrency7,
  cast('' as fins_curr8) AS FreeDefinedCurrency8,
  cast(0 as fis_vfccur12) AS ActualAmountInFunctionalCrcy,
  cast(0 as fis_vfccur12) AS PlanAmountInFunctionalCurrency,
  cast(0 as fis_act_osl) AS ActualAmountInFreeDfndCrcy1,
  cast(0 as fis_act_vsl) AS ActualAmountInFreeDfndCrcy2,
  cast(0 as fis_act_bsl) AS ActualAmountInFreeDfndCrcy3,
  cast(0 as fis_act_csl) AS ActualAmountInFreeDfndCrcy4,
  cast(0 as fis_act_dsl) AS ActualAmountInFreeDfndCrcy5,
  cast(0 as fis_act_esl) AS ActualAmountInFreeDfndCrcy6,
  cast(0 as fis_act_fsl) AS ActualAmountInFreeDfndCrcy7,
  cast(0 as fis_act_gsl) AS ActualAmountInFreeDfndCrcy8,
  cast(0 as fis_plan_osl) AS PlanAmountInFreeDefinedCrcy1,
  cast(0 as fis_plan_vsl) AS PlanAmountInFreeDefinedCrcy2,
  cast(0 as fis_plan_bsl) AS PlanAmountInFreeDefinedCrcy3,
  cast(0 as fis_plan_csl) AS PlanAmountInFreeDefinedCrcy4,
  cast(0 as fis_plan_dsl) AS PlanAmountInFreeDefinedCrcy5,
  cast(0 as fis_plan_esl) AS PlanAmountInFreeDefinedCrcy6,
  cast(0 as fis_plan_fsl) AS PlanAmountInFreeDefinedCrcy7,
  cast(0 as fis_plan_gsl) AS PlanAmountInFreeDefinedCrcy8,
  cast(0 as fis_hsl) AS ActualAmountInCompanyCodeCrcy,
  cast(0 as fis_ksl) AS ActualAmountInGlobalCurrency,
  cast(AmountInCompanyCodeCurrency as fis_hsl) AS CmtmtAmtInCompanyCodeCurrency,
  cast(AmountInCtrlgAreaCrcy as fis_ksl) AS CmtmtAmountInGlobalCurrency,
  cast(0 as fis_hsl) AS PlanAmountInCompanyCodeCrcy,
  cast(0 as fis_ksl) AS PlanAmountInGlobalCurrency,
  cast('CMT' as costcenterdocumentsource) AS CostCenterDocumentSource,
  cast('KS' as fis_accasty) AS AccountAssignmentType,
  cast('' as fis_accasty_n1) AS StstclAccountAssignmentType1,
  cast('' as fis_accasty_n2) AS StstclAccountAssignmentType2,
  cast('' as fis_accasty_n3) AS StstclAccountAssignmentType3,
  cast('' as fins_xkostl_stat) AS IsStatisticalCostCenter,
  cast('' as bwkey) AS ValuationArea,
  cast('' as fco_srvdoc_type) AS ServiceDocumentType,
  cast('' as fb_segment) AS Segment,
  cast('' as vkorg) AS SalesOrganization,
  cast('' as fis_prctr) AS ProfitCenter,
  cast('' as werks_d) AS Plant,
  cast('' as fis_spart) AS OrganizationDivision,
  cast('' as farp_koart) AS FinancialAccountType,
  cast('' as vtweg) AS DistributionChannel,
  cast('' as fis_rbusa) AS BusinessArea,
  cast('' as anlkl) AS AssetClass,
  cast('' as fco_srvdoc_id) AS ServiceDocument,
  cast('' as fis_blart) AS AccountingDocumentType,
  cast('' as vbeln_va) AS SalesDocument,
  cast('' as fis_aufnr) AS OrderID,
  cast('' as kunnr) AS Customer,
  cast('' as fm_farea) AS FunctionalArea
FROM I_ControllingCommitmentLineItm AS _ControllingCommitmentLineItm
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
-- UNION ALL with additional select branch(es): P_CostCenterActualPlan
;