P_CostCenterCommitmentUnion_2

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_CostCenterCommitmentUnion_2.
-- 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: PCSTCTRCMTMT2
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_CostCenterCommitmentUnion_2 AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  cast('' as fis_docln) AS LedgerGLLineItem,
  Ledger,
  cast('' as fis_belnr) AS AccountingDocument,
  ControllingArea,
  CompanyCode,
  FiscalYear,
  CostCenter,
  GLAccount,
  FiscalYearVariant,
  FiscalPeriod,
  cast('' as fins_ledger_pers) AS SourceLedger,
  cast('' as md_supplier) AS Supplier,
  Product AS Material,
  cast(0 as quan1) AS CommittedQuantity,
  ValuationQuantity AS PlannedQuantity,
  cast(0 as quan1_12) AS Quantity,
  cast('' as co_meinh) AS UnitOfMeasure,
  ChartOfAccounts,
  cast('' as fis_ebeln) AS PurchasingDocument,
  cast('00000' as fis_ebelp) AS PurchasingDocumentItem,
  cast('' as esart) AS PurchasingDocumentType,
  cast('' as ebstyp) AS PurchasingDocumentCategory,
  PostingDate,
  PlanningCategory,
  cast('' as fis_src_awref) AS SourceReferenceDocument,
  cast('000000' as fis_src_awitem) AS SourceReferenceDocumentItem,
  CompanyCodeCurrency,
  GlobalCurrency,
  cast('' as fins_currfc) AS FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  cast(0 as fis_vfccur12) AS ActualAmountInFunctionalCrcy,
  cast(0 as fis_vfccur12) AS CmtmtAmountInFunctionalCrcy,
  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_cmtmt_osl) AS CmtmtAmountInFreeDfndCrcy1,
  cast(0 as fis_cmtmt_vsl) AS CmtmtAmountInFreeDfndCrcy2,
  cast(0 as fis_cmtmt_bsl) AS CmtmtAmountInFreeDfndCrcy3,
  cast(0 as fis_cmtmt_csl) AS CmtmtAmountInFreeDfndCrcy4,
  cast(0 as fis_cmtmt_dsl) AS CmtmtAmountInFreeDfndCrcy5,
  cast(0 as fis_cmtmt_esl) AS CmtmtAmountInFreeDfndCrcy6,
  cast(0 as fis_cmtmt_fsl) AS CmtmtAmountInFreeDfndCrcy7,
  cast(0 as fis_cmtmt_gsl) AS CmtmtAmountInFreeDfndCrcy8,
  cast(AmountInFreeDefinedCurrency1 as fis_plan_osl) AS PlanAmountInFreeDefinedCrcy1,
  cast(AmountInFreeDefinedCurrency2 as fis_plan_vsl) AS PlanAmountInFreeDefinedCrcy2,
  cast(AmountInFreeDefinedCurrency3 as fis_plan_bsl) AS PlanAmountInFreeDefinedCrcy3,
  cast(AmountInFreeDefinedCurrency4 as fis_plan_csl) AS PlanAmountInFreeDefinedCrcy4,
  cast(AmountInFreeDefinedCurrency5 as fis_plan_dsl) AS PlanAmountInFreeDefinedCrcy5,
  cast(AmountInFreeDefinedCurrency6 as fis_plan_esl) AS PlanAmountInFreeDefinedCrcy6,
  cast(AmountInFreeDefinedCurrency7 as fis_plan_fsl) AS PlanAmountInFreeDefinedCrcy7,
  cast(AmountInFreeDefinedCurrency8 as fis_plan_gsl) AS PlanAmountInFreeDefinedCrcy8,
  cast(0 as fis_hsl) AS ActualAmountInCompanyCodeCrcy,
  cast(0 as fis_ksl) AS ActualAmountInGlobalCurrency,
  cast(0 as fis_hsl) AS CmtmtAmtInCompanyCodeCurrency,
  cast(0 as fis_ksl) AS CmtmtAmountInGlobalCurrency,
  cast(AmountInCompanyCodeCurrency as fis_hsl) AS PlanAmountInCompanyCodeCrcy,
  cast(AmountInGlobalCurrency as fis_ksl) AS PlanAmountInGlobalCurrency,
  cast('PLN' as costcenterdocumentsource) AS CostCenterDocumentSource,
  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,
  Segment,
  SalesOrganization,
  ProfitCenter,
  Plant,
  OrganizationDivision,
  cast('' as farp_koart) AS FinancialAccountType,
  DistributionChannel,
  BusinessArea,
  AssetClass,
  cast('' as fco_srvdoc_id) AS ServiceDocument,
  cast('' as fis_blart) AS AccountingDocumentType,
  SalesDocument,
  OrderID,
  Customer,
  FunctionalArea
FROM I_FinancialPlanningEntryItem AS _FinancialPlanningEntryItem
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
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_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter AND _CostCenter.ValidityStartDate <= $parameters.P_KeyDate AND _CostCenter.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;