P_CostCenterBudget

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_CostCenterBudget.
-- 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: PCSTCNTRBDGT
-- Parameters: P_KeyDate : sydatum, P_BudgetPlanningCategory : fis_category, P_InputPlanningCategory : fis_category, P_Language : spras, P_LeadingLedger : fins_ledger

CREATE VIEW P_CostCenterBudget AS
SELECT
  $parameters.P_KeyDate AS KeyDate,
  cast( cast( 'ACT01' as abap.char( 5 )) as fcom_category) AS PlanningCategory,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  GLAccountLineItem.SourceLedger AS Ledger,
  GLAccountLineItem.ControllingArea AS ControllingArea,
  _CostCenterAtPostingDate.BudgetCarryingCostCenter AS BudgetCarryingCostCenter,
  _AvailyCtrlProfileSemanticTag.GLAccountHierarchy AS GLAccountHierarchy,
  _AvailyCtrlProfileSemanticTag.HierarchyNode AS HierarchyNode,
  concat( concat( substring( _GLAccountHierarchyID.HierarchyNode, 2, 39 ), '~' ), substring( _AvailyCtrlProfileSemanticTag.HierarchyNode, 2, 23 ) ) AS GLAccountHierNodeSemanticKey,
  _BudgetCarryingCostCenter.AvailabilityControlProfile AS AvailabilityControlProfile,
  GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  _PredictionLedger.PredictionLedger AS PredictionLedger,
  cast( 0 as fins_vkcur12) AS PlanAmountInCompanyCodeCrcy,
  cast( 0 as fins_vkcur12) AS BudgetAmountInCompanyCodeCrcy,
  GLAccountLineItem.AmountInCompanyCodeCurrency AS ActualCostAmtInCCCrcy,
  cast( 0 as fins_vkcur12) AS CmtmtCostInCCCrcy,
  GLAccountLineItem.AmountInCompanyCodeCurrency AS TotAssgdAmtInCoCodeCurrency,
  -GLAccountLineItem.AmountInCompanyCodeCurrency AS AvailableBdgtAmtInCoCodeCrcy,
  cast(0 as fins_vkcur12) AS PlanAmountInGlobalCurrency,
  cast( 0 as fins_vkcur12) AS BudgetInGlobalCrcy,
  GLAccountLineItem.AmountInGlobalCurrency AS ActualCostInGlobalCrcy,
  cast( 0 as fins_vkcur12) AS CmtmtCostInGlobalCurrency,
  GLAccountLineItem.AmountInGlobalCurrency AS TotAssgdAmtInGlobalCurrency,
  -GLAccountLineItem.AmountInGlobalCurrency AS AvailableBudgetInGlobalCrcy,
  _BudgetCarryingCostCenter._Text[1:Language = $parameters.P_Language].CostCenterName AS BudgetCarryingCostCenterName,
  _GLAccountHierarchyNodeT[1:Language = $parameters.P_Language].HierarchyNodeText AS HierarchyNodeText,
  _CostCenterAtPostingDate._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  GLAccountLineItem._GLAccountInChartOfAccounts._Text[1:Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  GLAccountLineItem._ControllingArea AS _ControllingArea,
  GLAccountLineItem._FiscalYear AS _FiscalYear,
  GLAccountLineItem._CompanyCode AS _CompanyCode,
  GLAccountLineItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  GLAccountLineItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  _GLAccountHierarchyText[1:Language = $parameters.P_Language].GLAccountHierarchyName AS GLAccountHierarchyName,
  cast(' ' as fcom_category_t preserving type ) AS PlanningCategoryName,
  GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  GLAccountLineItem.OrderID AS OrderID,
  GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  GLAccountLineItem.Customer AS Customer,
  GLAccountLineItem.Segment AS Segment,
  GLAccountLineItem.BusinessArea AS BusinessArea,
  GLAccountLineItem.ProfitCenter AS ProfitCenter,
  GLAccountLineItem.Supplier AS Supplier,
  GLAccountLineItem.SalesOrganization AS SalesOrganization,
  GLAccountLineItem.Plant AS Plant,
  GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  GLAccountLineItem.ValuationArea AS ValuationArea,
  GLAccountLineItem.SalesDocument AS SalesDocument,
  GLAccountLineItem.CostCenter AS CostCenter,
  GLAccountLineItem.GLAccount AS GLAccount,
  GLAccountLineItem.DistributionChannel AS DistributionChannel,
  GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  GLAccountLineItem.ServiceDocument AS ServiceDocument,
  GLAccountLineItem.AssetClass AS AssetClass,
  GLAccountLineItem.PostingDate AS PostingDate,
  GLAccountLineItem.FunctionalArea AS FunctionalArea,
  GLAccountLineItem._Ledger AS _Ledger,
  GLAccountLineItem._Order AS _Order,
  GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  GLAccountLineItem._Customer AS _Customer,
  GLAccountLineItem._Supplier AS _Supplier,
  GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  GLAccountLineItem._SalesDocument AS _SalesDocument,
  GLAccountLineItem._ServiceDocument AS _ServiceDocument,
  GLAccountLineItem.JointVenture AS JointVenture,
  _JointVentureDesc[1:Language = $parameters.P_Language].JointVentureName AS JointVentureName,
  GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  _JntVntrEquityGrpText[1:Language = $parameters.P_Language].JntOpgAgrmtEquityGrpText AS JointVentureEquityGroupName,
  GLAccountLineItem.JointVentureCostRecoveryCode AS JointVentureRecoveryCode,
  _JointVentureRecoveryText[1:Language = $parameters.P_Language].JointVentureRecoveryCodeName as JointVentureRecoveryCodeName AS P_KeyDateasKeyDate,
  _JointVentureRecoveryText[1:Language = $parameters.P_Language].JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName
FROM I_GLAccountLineItemRawData AS GLAccountLineItem
INNER JOIN I_CostCenter AS _CostCenterAtPostingDate ON /* join condition not captured in parsed metadata */
INNER JOIN I_CostCenter AS _BudgetCarryingCostCenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_AvailyCtrlProfileSemanticTag AS _AvailyCtrlProfileSemanticTag ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountHierSubTree AS _GLAccountHierSubTree ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyID ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PredictionLedger AS _PredictionLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..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_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON _GLAccountHierarchyNode.GLAccountHierarchy = _AvailyCtrlProfileSemanticTag.GLAccountHierarchy AND _GLAccountHierarchyNode.HierarchyNode = _AvailyCtrlProfileSemanticTag.HierarchyNode AND _GLAccountHierarchyNode.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchyNodeT AS _GLAccountHierarchyNodeT ON GLAccountHierarchy = _GLAccountHierarchyNodeT.GLAccountHierarchy AND HierarchyNode = _GLAccountHierarchyNodeT.HierarchyNode AND _GLAccountHierarchyNodeT.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_GLAccountHierarchyText AS _GLAccountHierarchyText ON GLAccountHierarchy = _GLAccountHierarchyText.GLAccountHierarchy  -- association [0..*]
LEFT OUTER JOIN I_PlanningCategoryText AS _PlanningCategoryText ON PlanningCategory = _PlanningCategoryText.PlanningCategory  -- association [0..*]
LEFT OUTER JOIN I_JointVentureDesc AS _JointVentureDesc ON _JointVentureDesc.CompanyCode = GLAccountLineItem.CompanyCode AND _JointVentureDesc.JointVenture = GLAccountLineItem.JointVenture  -- association [0..*]
LEFT OUTER JOIN I_JntVntrEquityGrpText AS _JntVntrEquityGrpText ON _JntVntrEquityGrpText.CompanyCode = GLAccountLineItem.CompanyCode AND _JntVntrEquityGrpText.JointVenture = GLAccountLineItem.JointVenture AND _JntVntrEquityGrpText.JntOpgAgrmtEquityGrp = GLAccountLineItem.JointVentureEquityGroup  -- association [0..*]
LEFT OUTER JOIN I_JointVentureRecoveryText AS _JointVentureRecoveryText ON _JointVentureRecoveryText.CompanyCode = GLAccountLineItem.CompanyCode AND _JointVentureRecoveryText.JointVentureRecoveryCode = GLAccountLineItem.JointVentureCostRecoveryCode  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
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]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData, I_FinancialPlanningEntryItem
;