I_BudgetDocumentItmSearch

DDL: I_BUDGETDOCUMENTITMSEARCH SQL: IBDGTDOCITMES Type: view COMPOSITE
45 Fields 1 Data Sources 7 Associations

Budget Document Item Search

I_BudgetDocumentItmSearch is a Composite CDS View that provides data about "Budget Document Item Search" in SAP S/4HANA. It reads from 1 data source (I_BudgetDocumentItmSearchBasic) and exposes 45 fields with key fields ControllingArea, BudgetDocument, BudgetDocumentYear, BudgetDocumentItem. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BudgetDocumentItmSearchBasic I_BudgetDocumentItmSearchBasic from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_Fund _Fund $projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund
[0..1] I_BudgetPeriod _BudgetPeriod $projection.BudgetPeriod = _BudgetPeriod.BudgetPeriod
[1..*] I_CostCenter _CostCenter $projection.ControllingArea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter
[0..1] I_FunctionalArea _FunctionalArea $projection.FunctionalArea = _FunctionalArea.FunctionalArea
[0..1] I_WBSElement _WBSElement $projection.WBSElement = _WBSElement.WBSElement
[0..1] I_GLAccountInCompanyCode _GLAccountInCompanyCode $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
[0..1] I_Grant _Grant $projection.GrantID = _Grant.GrantID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBDGTDOCITMES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
EndUserText.label Budget Document Item Search view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY BudgetDocument BudgetDocument Document Number
KEY BudgetDocumentYear BudgetDocumentYear Fiscal Year
KEY BudgetDocumentItem BudgetDocumentItem Data record number
PlanningCategory PlanningCategory Plan Category
BudgetDocumentYearForEdit BudgetDocumentYear Fiscal Year
CompanyCode CompanyCode Receiver Company Code
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
FunctionalArea FunctionalArea Sendr Fctl Area
FiscalYear FiscalYear G/L Fiscal Year
FinancialManagementArea FinancialManagementArea FM Area
Fund Fund Sender Fund
BudgetPeriod BudgetPeriod Budget Period
WBSElement WBSElement WBS Internal ID
Project Project WBS Element
GrantID GrantID Sender Grant
BudgetProcess BudgetProcess Budget Process Type
BudgetingType BudgetingType Budget Type
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
_BudgetingType _BudgetingType
_BudgetPeriod _BudgetPeriod
_BudgetProcess _BudgetProcess
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_ControllingArea _ControllingArea
_ControllingAreaCurrency _ControllingAreaCurrency
_CostCenter _CostCenter
_FinMgmtArea _FinMgmtArea
_FunctionalArea _FunctionalArea
_Fund _Fund
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GlobalCurrency _GlobalCurrency
_LedgerFiscalYear _LedgerFiscalYear
_Grant _Grant
_PlanningCategory _PlanningCategory
_WBSElement _WBSElement
_TransactionCurrency _TransactionCurrency

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_BudgetDocumentItmSearch.
-- 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: IBDGTDOCITMES

CREATE VIEW I_BudgetDocumentItmSearch AS
SELECT
  ControllingArea,
  BudgetDocument,
  BudgetDocumentYear,
  BudgetDocumentItem,
  PlanningCategory,
  BudgetDocumentYear AS BudgetDocumentYearForEdit,
  CompanyCode,
  GLAccount,
  CostCenter,
  FunctionalArea,
  FiscalYear,
  FinancialManagementArea,
  Fund,
  BudgetPeriod,
  WBSElement,
  Project,
  GrantID,
  BudgetProcess,
  BudgetingType,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency
FROM I_BudgetDocumentItmSearchBasic
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [1..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
;

Learn More