ESH_N_BUDGETITEM

DDL: ESH_N_BUDGETITEM SQL: ESH_L_BUDGETITEM Type: view
21 Fields 1 Data Sources

ESH_N_BUDGETITEM is a CDS View in SAP S/4HANA. It reads from 1 data source (I_BUDGETDOCUMENTITMSEARCH) and exposes 21 fields with key fields BUDGETDOCUMENT, BUDGETDOCUMENTITEM, BUDGETDOCUMENTYEAR, CONTROLLINGAREA.

Data Sources (1)

SourceAliasJoin Type
I_BUDGETDOCUMENTITMSEARCH I_BUDGETDOCUMENTITMSEARCH from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_BUDGETITEM view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BUDGETDOCUMENT BUDGETDOCUMENT Document Number
KEY BUDGETDOCUMENTITEM BUDGETDOCUMENTITEM Data record number
KEY BUDGETDOCUMENTYEAR BUDGETDOCUMENTYEAR Fiscal Year
KEY CONTROLLINGAREA CONTROLLINGAREA Controlling Area
AMOUNTINTRANSACTIONCURRENCY AMOUNTINTRANSACTIONCURRENCY Pt Crcy Amt
BUDGETINGTYPE BUDGETINGTYPE Budget Type
BUDGETPERIOD BUDGETPERIOD Budget Period
BUDGETPROCESS BUDGETPROCESS Budget Process Type
COMPANYCODE COMPANYCODE Receiver Company Code
COSTCENTER COSTCENTER Cost Center
FUNCTIONALAREA FUNCTIONALAREA Sendr Fctl Area
FUND FUND Sender Fund
FUNDAUTHZNGRP
GLACCOUNT GLACCOUNT General Ledger
GRANTID GRANTID Sender Grant
PLANNINGCATEGORY PLANNINGCATEGORY Plan Category
PLANNINGCATEGORYUSAGE _PLANNINGCATEGORY PLANNINGCATEGORYUSAGE
PROFITCENTER _WBSELEMENT PROFITCENTER Profit Center
PROJECT PROJECT WBS Element
TRANSACTIONCURRENCY TRANSACTIONCURRENCY Transaction Currency
WBSELEMENT WBSELEMENT WBS Internal ID

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 ESH_N_BUDGETITEM.
-- 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: ESH_L_BUDGETITEM

CREATE VIEW ESH_N_BUDGETITEM AS
SELECT
  BUDGETDOCUMENT,
  BUDGETDOCUMENTITEM,
  BUDGETDOCUMENTYEAR,
  CONTROLLINGAREA,
  AMOUNTINTRANSACTIONCURRENCY,
  BUDGETINGTYPE,
  BUDGETPERIOD,
  BUDGETPROCESS,
  COMPANYCODE,
  COSTCENTER,
  FUNCTIONALAREA,
  FUND,
  _FUND._FUNDAUTHZNGRP.FUNDAUTHZNGRP AS FUNDAUTHZNGRP,
  GLACCOUNT,
  GRANTID,
  PLANNINGCATEGORY,
  _PLANNINGCATEGORY.PLANNINGCATEGORYUSAGE AS PLANNINGCATEGORYUSAGE,
  _WBSELEMENT.PROFITCENTER AS PROFITCENTER,
  PROJECT,
  TRANSACTIONCURRENCY,
  WBSELEMENT
FROM I_BUDGETDOCUMENTITMSEARCH
;

Learn More