I_CostCenterBudgetWithKey

DDL: I_COSTCENTERBUDGETWITHKEY Type: view_entity COMPOSITE
86 Fields 1 Data Sources 3 Associations

Cost Center Budget Report with Key

I_CostCenterBudgetWithKey is a Composite CDS View that provides data about "Cost Center Budget Report with Key" in SAP S/4HANA. It reads from 1 data source (P_CostCenterBudget) and exposes 86 fields with key fields FiscalYear, Ledger, CompanyCode, AccountingDocument, LedgerGLLineItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_CostCenterBudget P_CostCenterBudget from

Parameters (5)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_BudgetPlanningCategory fcom_category
P_InputPlanningCategory fcom_category
P_LeadingLedger fins_ledger
P_Language spras

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_JournalEntry _JournalEntry $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_CostCenter _BudgetCarryingCostCenter $projection.ControllingArea = _BudgetCarryingCostCenter.ControllingArea and $projection.BudgetCarryingCostCenter = _BudgetCarryingCostCenter.CostCenter and _BudgetCarryingCostCenter.ValidityStartDate <= $session.system_date and _BudgetCarryingCostCenter.ValidityEndDate >= $session.system_date

Annotations (8)

NameValueLevelField
EndUserText.label Cost Center Budget Report with Key view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (86)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem
KeyDate KeyDate Maturity Key Date
ControllingArea ControllingArea Controlling Area
FiscalPeriod FiscalPeriod Tax period
BudgetCarryingCostCenter BudgetCarryingCostCenter Budget-Carrying Cost Center
GLAccountHierarchy GLAccountHierarchy
HierarchyNode HierarchyNode Node
GLAccountHierNodeSemanticKey GLAccountHierNodeSemanticKey
OrderID OrderID Order ID
AccountingDocumentType AccountingDocumentType Journal Entry Type
Customer Customer Sold-to Party
Segment Segment Segment number
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
Supplier Supplier Supplier
SalesOrganization SalesOrganization Sales Organization
Plant Plant Valuation Area
ServiceDocumentType ServiceDocumentType Transaction Type
ValuationArea ValuationArea Valuation Area
SalesDocument SalesDocument SD Document
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
PlanningCategory PlanningCategory Plan Category
OrganizationDivision OrganizationDivision Org. Division
ServiceDocument ServiceDocument Transaction ID
FinancialAccountType FinancialAccountType Fin. Account Type
AssetClass AssetClass Asset Class
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant FiscalYearVariant FY Variant
PredictionLedger PredictionLedger
PostingDate PostingDate Posting Date for GR
FunctionalArea FunctionalArea Sendr Fctl Area
BudgetCarryingCostCenterName BudgetCarryingCostCenterName
CostCenterName CostCenterName Name
GLAccountName GLAccountName Short Text
HierarchyNodeText HierarchyNodeText
GLAccountHierarchyName GLAccountHierarchyName
PlanningCategoryName PlanningCategoryName
JointVenture JointVenture Joint venture
JointVentureName JointVentureName
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVentureEquityGroupName JointVentureEquityGroupName
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
JointVentureRecoveryCodeName JointVentureRecoveryCodeName
PlanAmountInCompanyCodeCrcy PlanAmountInCompanyCodeCrcy Local Crcy Amt
BudgetAmountInCompanyCodeCrcy BudgetAmountInCompanyCodeCrcy Local Crcy Amt
ActualCostAmtInCCCrcy ActualCostAmtInCCCrcy Actl Costs Bal. (CC)
CmtmtCostInCCCrcy CmtmtCostInCCCrcy Local Crcy Amt
TotAssgdAmtInCoCodeCurrency TotAssgdAmtInCoCodeCurrency Local Crcy Amt
AvailableBdgtAmtInCoCodeCrcy AvailableBdgtAmtInCoCodeCrcy Local Crcy Amt
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency Amount in Global Currency
BudgetInGlobalCrcy BudgetInGlobalCrcy Amount in Global Currency
ActualCostInGlobalCrcy ActualCostInGlobalCrcy Actl Costs Bal. (GC)
CmtmtCostInGlobalCurrency CmtmtCostInGlobalCurrency Amount in Global Currency
TotAssgdAmtInGlobalCurrency TotAssgdAmtInGlobalCurrency Amount in Global Currency
AvailableBudgetInGlobalCrcy AvailableBudgetInGlobalCrcy Amount in Global Currency
_JournalEntry _JournalEntry
_ControllingArea _ControllingArea
_GlobalCurrency _GlobalCurrency
_FiscalYear _FiscalYear
_CompanyCode _CompanyCode
_FiscalPeriodForVariant _FiscalPeriodForVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalYearVariant _FiscalYearVariant
_GLAccountHierarchyNode _GLAccountHierarchyNode
_BudgetCarryingCostCenter _BudgetCarryingCostCenter
_Ledger _Ledger
_Order _Order
_AccountingDocumentType _AccountingDocumentType
_Customer _Customer
_CurrentProfitCenter _CurrentProfitCenter
_CurrentCostCenter _CurrentCostCenter
_Supplier _Supplier
_GLAccountInCompanyCode _GLAccountInCompanyCode
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument

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_CostCenterBudgetWithKey.
-- 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.
-- Parameters: P_KeyDate : vdm_v_key_date, P_BudgetPlanningCategory : fcom_category, P_InputPlanningCategory : fcom_category, P_LeadingLedger : fins_ledger, P_Language : spras

CREATE VIEW I_CostCenterBudgetWithKey AS
SELECT
  FiscalYear,
  Ledger,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  KeyDate,
  ControllingArea,
  FiscalPeriod,
  BudgetCarryingCostCenter,
  GLAccountHierarchy,
  HierarchyNode,
  GLAccountHierNodeSemanticKey,
  OrderID,
  AccountingDocumentType,
  Customer,
  Segment,
  BusinessArea,
  ProfitCenter,
  Supplier,
  SalesOrganization,
  Plant,
  ServiceDocumentType,
  ValuationArea,
  SalesDocument,
  CostCenter,
  GLAccount,
  DistributionChannel,
  PlanningCategory,
  OrganizationDivision,
  ServiceDocument,
  FinancialAccountType,
  AssetClass,
  GlobalCurrency,
  CompanyCodeCurrency,
  LedgerFiscalYear,
  FiscalYearVariant,
  PredictionLedger,
  PostingDate,
  FunctionalArea,
  BudgetCarryingCostCenterName,
  CostCenterName,
  GLAccountName,
  HierarchyNodeText,
  GLAccountHierarchyName,
  PlanningCategoryName,
  JointVenture,
  JointVentureName,
  JointVentureEquityGroup,
  JointVentureEquityGroupName,
  JointVentureRecoveryCode,
  JointVentureRecoveryCodeName,
  PlanAmountInCompanyCodeCrcy,
  BudgetAmountInCompanyCodeCrcy,
  ActualCostAmtInCCCrcy,
  CmtmtCostInCCCrcy,
  TotAssgdAmtInCoCodeCurrency,
  AvailableBdgtAmtInCoCodeCrcy,
  PlanAmountInGlobalCurrency,
  BudgetInGlobalCrcy,
  ActualCostInGlobalCrcy,
  CmtmtCostInGlobalCurrency,
  TotAssgdAmtInGlobalCurrency,
  AvailableBudgetInGlobalCrcy
FROM P_CostCenterBudget
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _BudgetCarryingCostCenter ON ControllingArea = _BudgetCarryingCostCenter.ControllingArea AND BudgetCarryingCostCenter = _BudgetCarryingCostCenter.CostCenter AND _BudgetCarryingCostCenter.ValidityStartDate <= $session.system_date AND _BudgetCarryingCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
;

Learn More