I_CostCenterCommitment_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 I_CostCenterCommitment_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: ICSTCTRCMTMT
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_CostCenterCommitment_2 AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  LedgerGLLineItem,
  Ledger,
  AccountingDocument,
  ControllingArea,
  CompanyCode,
  FiscalYear,
  CostCenter,
  GLAccount,
  FiscalYearVariant,
  FiscalPeriod,
  Supplier,
  Material,
  SourceLedger,
  CommittedQuantity,
  PlannedQuantity,
  Quantity,
  UnitOfMeasure,
  ChartOfAccounts,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurchasingDocumentType,
  PurchasingDocumentCategory,
  PostingDate,
  cast(PlanningCategory as fis_category preserving type ) AS PlanningCategory,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  cast(FreeDefinedCurrency3 as fis_curr3 preserving type ) AS FreeDefinedCurrency3,
  cast(FreeDefinedCurrency4 as fis_curr4 preserving type ) AS FreeDefinedCurrency4,
  cast(FreeDefinedCurrency5 as fis_curr5 preserving type ) AS FreeDefinedCurrency5,
  cast(FreeDefinedCurrency6 as fis_curr6 preserving type ) AS FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  cast(FreeDefinedCurrency8 as fis_curr8 preserving type ) AS FreeDefinedCurrency8,
  ActualAmountInFunctionalCrcy,
  ActualAmountInFunctionalCrcy AS ActlCumltvAmtInFunctionalCrcy,
  ActualAmountInCompanyCodeCrcy,
  ActualAmountInCompanyCodeCrcy AS ActualCumltvAmtInCoCodeCrcy,
  ActualAmountInGlobalCurrency,
  ActualAmountInGlobalCurrency AS ActlCumltvAmtInGlobalCurrency,
  ActualAmountInFreeDfndCrcy1,
  ActualAmountInFreeDfndCrcy1 AS ActlCumltvAmtInFreeDfndCrcy1,
  ActualAmountInFreeDfndCrcy2,
  ActualAmountInFreeDfndCrcy2 AS ActlCumltvAmtInFreeDfndCrcy2,
  ActualAmountInFreeDfndCrcy3,
  ActualAmountInFreeDfndCrcy3 AS ActlCumltvAmtInFreeDfndCrcy3,
  ActualAmountInFreeDfndCrcy4,
  ActualAmountInFreeDfndCrcy4 AS ActlCumltvAmtInFreeDfndCrcy4,
  ActualAmountInFreeDfndCrcy5,
  ActualAmountInFreeDfndCrcy5 AS ActlCumltvAmtInFreeDfndCrcy5,
  ActualAmountInFreeDfndCrcy6,
  ActualAmountInFreeDfndCrcy6 AS ActlCumltvAmtInFreeDfndCrcy6,
  ActualAmountInFreeDfndCrcy7,
  ActualAmountInFreeDfndCrcy7 AS ActlCumltvAmtInFreeDfndCrcy7,
  ActualAmountInFreeDfndCrcy8,
  ActualAmountInFreeDfndCrcy8 AS ActlCumltvAmtInFreeDfndCrcy8,
  CmtmtAmountInFunctionalCrcy,
  CmtmtAmountInFunctionalCrcy AS CmtmtCumltvAmtInFunctionalCrcy,
  CmtmtAmtInCompanyCodeCurrency,
  CmtmtAmtInCompanyCodeCurrency AS CmtmtCumltvAmtInCoCodeCurrency,
  CmtmtAmountInGlobalCurrency,
  CmtmtAmountInGlobalCurrency AS CmtmtCumltvAmtInGlobCrcy,
  CmtmtAmountInFreeDfndCrcy1,
  CmtmtAmountInFreeDfndCrcy1 AS CmtmtCumltvAmtInFreeDfndCrcy1,
  CmtmtAmountInFreeDfndCrcy2,
  CmtmtAmountInFreeDfndCrcy2 AS CmtmtCumltvAmtInFreeDfndCrcy2,
  CmtmtAmountInFreeDfndCrcy3,
  CmtmtAmountInFreeDfndCrcy3 AS CmtmtCumltvAmtInFreeDfndCrcy3,
  CmtmtAmountInFreeDfndCrcy4,
  CmtmtAmountInFreeDfndCrcy4 AS CmtmtCumltvAmtInFreeDfndCrcy4,
  CmtmtAmountInFreeDfndCrcy5,
  CmtmtAmountInFreeDfndCrcy5 AS CmtmtCumltvAmtInFreeDfndCrcy5,
  CmtmtAmountInFreeDfndCrcy6,
  CmtmtAmountInFreeDfndCrcy6 AS CmtmtCumltvAmtInFreeDfndCrcy6,
  CmtmtAmountInFreeDfndCrcy7,
  CmtmtAmountInFreeDfndCrcy7 AS CmtmtCumltvAmtInFreeDfndCrcy7,
  CmtmtAmountInFreeDfndCrcy8,
  CmtmtAmountInFreeDfndCrcy8 AS CmtmtCumltvAmtInFreeDfndCrcy8,
  PlanAmountInCompanyCodeCrcy,
  PlanAmountInCompanyCodeCrcy AS PlanCumltvAmtInCoCodeCrcy,
  PlanAmountInGlobalCurrency,
  PlanAmountInGlobalCurrency AS PlndCumltvAmtInGlobalCurrency,
  PlanAmountInFreeDefinedCrcy1,
  PlanAmountInFreeDefinedCrcy1 AS PlanCumltvAmtInFreeDfndCrcy1,
  PlanAmountInFreeDefinedCrcy2,
  PlanAmountInFreeDefinedCrcy2 AS PlanCumltvAmtInFreeDfndCrcy2,
  PlanAmountInFreeDefinedCrcy3,
  PlanAmountInFreeDefinedCrcy3 AS PlanCumltvAmtInFreeDfndCrcy3,
  PlanAmountInFreeDefinedCrcy4,
  PlanAmountInFreeDefinedCrcy4 AS PlanCumltvAmtInFreeDfndCrcy4,
  PlanAmountInFreeDefinedCrcy5,
  PlanAmountInFreeDefinedCrcy5 AS PlanCumltvAmtInFreeDfndCrcy5,
  PlanAmountInFreeDefinedCrcy6,
  PlanAmountInFreeDefinedCrcy6 AS PlanCumltvAmtInFreeDfndCrcy6,
  PlanAmountInFreeDefinedCrcy7,
  PlanAmountInFreeDefinedCrcy7 AS PlanCumltvAmtInFreeDfndCrcy7,
  PlanAmountInFreeDefinedCrcy8,
  PlanAmountInFreeDefinedCrcy8 AS PlanCumltvAmtInFreeDfndCrcy8,
  ( ActualAmountInFunctionalCrcy ) AS AssignedAmountInFunctionalCrcy,
  ( ActualAmountInFunctionalCrcy ) AS AssgdCumltvAmtInFunctionalCrcy,
  ( ActualAmountInCompanyCodeCrcy ) AS TotAssgdAmtInCoCodeCurrency,
  ActualAmountInGlobalCurrency AS TotAssgdAmtInGlobalCurrency,
  ( ActualAmountInFreeDfndCrcy1 ) AS AssignedAmtInFreeDefinedCrcy1,
  ( ActualAmountInFreeDfndCrcy2 ) AS AssignedAmtInFreeDefinedCrcy2,
  ( ActualAmountInFreeDfndCrcy3 ) AS AssignedAmtInFreeDefinedCrcy3,
  ( ActualAmountInFreeDfndCrcy4 ) AS AssignedAmtInFreeDefinedCrcy4,
  ( ActualAmountInFreeDfndCrcy5 ) AS AssignedAmtInFreeDefinedCrcy5,
  ( ActualAmountInFreeDfndCrcy6 ) AS AssignedAmtInFreeDefinedCrcy6,
  ( ActualAmountInFreeDfndCrcy7 ) AS AssignedAmtInFreeDefinedCrcy7,
  ( ActualAmountInFreeDfndCrcy8 ) AS AssignedAmtInFreeDefinedCrcy8,
  ( ActualAmountInCompanyCodeCrcy ) AS AssgdCumltvAmtInCoCodeCurrency,
  ActualAmountInGlobalCurrency AS AssgdCumltvAmtInGlobalCurrency,
  ( ActualAmountInFreeDfndCrcy1 ) AS AssgdCumltvAmtInFreeDfndCrcy1,
  ( ActualAmountInFreeDfndCrcy2 ) AS AssgdCumltvAmtInFreeDfndCrcy2,
  ( ActualAmountInFreeDfndCrcy3 ) AS AssgdCumltvAmtInFreeDfndCrcy3,
  ( ActualAmountInFreeDfndCrcy4 ) AS AssgdCumltvAmtInFreeDfndCrcy4,
  ( ActualAmountInFreeDfndCrcy5 ) AS AssgdCumltvAmtInFreeDfndCrcy5,
  ( ActualAmountInFreeDfndCrcy6 ) AS AssgdCumltvAmtInFreeDfndCrcy6,
  ( ActualAmountInFreeDfndCrcy7 ) AS AssgdCumltvAmtInFreeDfndCrcy7,
  ( ActualAmountInFreeDfndCrcy8 ) AS AssgdCumltvAmtInFreeDfndCrcy8,
  PlanAmountInCompanyCodeCrcy AS AvailableAmountInCCCrcy,
  PlanAmountInGlobalCurrency AS BdgtAvailableAmtInGlobalCrcy,
  PlanAmountInFreeDefinedCrcy1 AS AvailableAmountInFreeDfndCrcy1,
  PlanAmountInFreeDefinedCrcy2 AS AvailableAmountInFreeDfndCrcy2,
  PlanAmountInFreeDefinedCrcy3 AS AvailableAmountInFreeDfndCrcy3,
  PlanAmountInFreeDefinedCrcy4 AS AvailableAmountInFreeDfndCrcy4,
  PlanAmountInFreeDefinedCrcy5 AS AvailableAmountInFreeDfndCrcy5,
  PlanAmountInFreeDefinedCrcy6 AS AvailableAmountInFreeDfndCrcy6,
  PlanAmountInFreeDefinedCrcy7 AS AvailableAmountInFreeDfndCrcy7,
  PlanAmountInFreeDefinedCrcy8 AS AvailableAmountInFreeDfndCrcy8,
  PlanAmountInCompanyCodeCrcy AS AvailCumltvAmtInCoCodeCurrency,
  PlanAmountInGlobalCurrency AS AvailCumltvAmtInGlobalCurrency,
  PlanAmountInFreeDefinedCrcy1 AS AvailCumltvAmtInFreeDfndCrcy1,
  PlanAmountInFreeDefinedCrcy2 AS AvailCumltvAmtInFreeDfndCrcy2,
  PlanAmountInFreeDefinedCrcy3 AS AvailCumltvAmtInFreeDfndCrcy3,
  PlanAmountInFreeDefinedCrcy4 AS AvailCumltvAmtInFreeDfndCrcy4,
  PlanAmountInFreeDefinedCrcy5 AS AvailCumltvAmtInFreeDfndCrcy5,
  PlanAmountInFreeDefinedCrcy6 AS AvailCumltvAmtInFreeDfndCrcy6,
  PlanAmountInFreeDefinedCrcy7 AS AvailCumltvAmtInFreeDfndCrcy7,
  PlanAmountInFreeDefinedCrcy8 AS AvailCumltvAmtInFreeDfndCrcy8,
  CostCenterDocumentSource,
  AccountAssignmentType,
  IsStatisticalCostCenter,
  $parameters.P_KeyDate AS KeyDate,
  ValuationArea,
  ServiceDocumentType,
  Segment,
  SalesOrganization,
  ProfitCenter,
  Plant,
  OrganizationDivision,
  FinancialAccountType,
  DistributionChannel,
  BusinessArea,
  AssetClass,
  ServiceDocument,
  AccountingDocumentType,
  SalesDocument,
  OrderID,
  Customer,
  FunctionalArea
FROM P_CostCenterCommitmentUnion_2
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter AND _CostCenter.ValidityStartDate <= $session.system_date AND _CostCenter.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON UnitOfMeasure = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurgDocumentTypeText ON PurchasingDocumentType = _PurgDocumentTypeText.PurchasingDocumentType AND PurchasingDocumentCategory = _PurgDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON PurchasingDocumentCategory = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_PlanningCategoryText AS _PlanningCategoryText ON PlanningCategory = _PlanningCategoryText.PlanningCategory  -- association [0..*]
LEFT OUTER JOIN I_CostCtrCmtmtDocSourceTxt AS _CostCtrCmtmtDocSourceTxt ON CostCenterDocumentSource = _CostCtrCmtmtDocSourceTxt.CostCenterDocumentSource AND _CostCtrCmtmtDocSourceTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _AccountAssignmentTypeT ON AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType AND _AccountAssignmentTypeT.Language = $session.system_language  -- association [1..1]
;