I_CostCenterClassicCommitment

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_CostCenterClassicCommitment.
-- 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: ICSTCTRCMTMTCL

CREATE VIEW I_CostCenterClassicCommitment AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  LedgerGLLineItem,
  SourceLedger,
  Ledger,
  AccountingDocument,
  ControllingArea,
  CompanyCode,
  FiscalYear,
  FiscalYearVariant,
  FiscalPeriod,
  CostCenter,
  GLAccount,
  cast(PurchasingDocument as fis_ebeln preserving type ) AS PurchasingDocument,
  cast(PurchasingDocumentItem as fis_ebelp preserving type ) AS PurchasingDocumentItem,
  Supplier,
  Material,
  cast(CommittedQuantity as quan1 preserving type ) AS CommittedQuantity,
  PlannedQuantity,
  Quantity,
  cast(UnitOfMeasure as msehiunit preserving type ) AS UnitOfMeasure,
  ChartOfAccounts,
  PurchasingDocumentType,
  PurchasingDocumentCategory,
  cast(PostingDate as fis_budat preserving type ) AS PostingDate,
  PlanningCategory,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  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,
  CmtmtAmtInCompanyCodeCurrency,
  CmtmtAmtInCompanyCodeCurrency AS CmtmtCumltvAmtInCoCodeCurrency,
  CmtmtAmountInGlobalCurrency,
  CmtmtAmountInGlobalCurrency AS CmtmtCumltvAmtInGlobCrcy,
  PlanAmountInFunctionalCurrency,
  PlanAmountInFunctionalCurrency AS PlanCumltvAmtInFunctionalCrcy,
  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,
  ( ActualAmountInCompanyCodeCrcy ) AS TotAssgdAmtInCoCodeCurrency,
  ActualAmountInGlobalCurrency AS TotAssgdAmtInGlobalCurrency,
  ( ActualAmountInCompanyCodeCrcy ) AS AssgdCumltvAmtInCoCodeCurrency,
  ActualAmountInGlobalCurrency AS AssgdCumltvAmtInGlobalCurrency,
  PlanAmountInCompanyCodeCrcy AS AvailableAmountInCCCrcy,
  PlanAmountInGlobalCurrency AS BdgtAvailableAmtInGlobalCrcy,
  PlanAmountInCompanyCodeCrcy AS AvailCumltvAmtInCoCodeCurrency,
  PlanAmountInGlobalCurrency AS AvailCumltvAmtInGlobalCurrency,
  CostCenterDocumentSource,
  AccountAssignmentType,
  IsStatisticalCostCenter,
  ValuationArea,
  ServiceDocumentType,
  Segment,
  SalesOrganization,
  ProfitCenter,
  Plant,
  OrganizationDivision,
  FinancialAccountType,
  DistributionChannel,
  BusinessArea,
  AssetClass,
  ServiceDocument,
  AccountingDocumentType,
  SalesDocument,
  OrderID,
  Customer,
  FunctionalArea
FROM P_CostCtrClassicCmtmtUnion
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_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_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _AccountAssignmentTypeT ON AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType AND _AccountAssignmentTypeT.Language = $session.system_language  -- association [1..1]
;