ESH_S_BDGTDOC_OP

DDL: ESH_S_BDGTDOC_OP SQL: ESH_U_BDGTDOC_OP Type: view
22 Fields 1 Data Sources

ESH_S_BDGTDOC_OP is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_BDGTDOC_OP) and exposes 22 fields with key fields BUDGETDOCUMENTYEAR, BUDGETENTRYDOCUMENT, FINANCIALMANAGEMENTAREA.

Data Sources (1)

SourceAliasJoin Type
ESH_N_BDGTDOC_OP ESH_N_BDGTDOC_OP from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name BudgetEntryDocument view
UI.headerInfo.typeName Budget Entry Document view
UI.headerInfo.typeNamePlural Budget Entry Documents view
Consumption.semanticObject BudgetEntryDocument view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value BUDGETENTRYDOCUMENT view
UI.headerInfo.description.value FINANCIALMANAGEMENTAREA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_BDGTDOC_OP view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BUDGETDOCUMENTYEAR BUDGETDOCUMENTYEAR Fiscal Year
KEY BUDGETENTRYDOCUMENT BUDGETENTRYDOCUMENT Document Number
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA FM Area
BUDGETENTRYDOCUMENTDATE BUDGETENTRYDOCUMENTDATE
BUDGETENTRYDOCUMENTDESCRIPTION BUDGETENTRYDOCUMENTDESCRIPTION
BUDGETENTRYDOCUMENTSTATUS BUDGETENTRYDOCUMENTSTATUS
BUDGETENTRYDOCUMENTSTATUSNAME BUDGETENTRYDOCUMENTSTATUSNAME Document Status Name
BUDGETENTRYDOCUMENTTYPE BUDGETENTRYDOCUMENTTYPE
BUDGETENTRYDOCUMENTTYPENAME BUDGETENTRYDOCUMENTTYPENAME Document Type Name
BUDGETINGPROCESS BUDGETINGPROCESS Budgeting Process
BUDGETINGRESPONSIBLEPERSONNAME BUDGETINGRESPONSIBLEPERSONNAME Person Resp.
BUDGETVERSION BUDGETVERSION Version
CREATEDBYUSER CREATEDBYUSER Created by User
CREATIONDATE CREATIONDATE Time Stamp
FISCALTREASURYAGENCY FISCALTREASURYAGENCY
FISCALTREASURYLEGISLATIONTYPE FISCALTREASURYLEGISLATIONTYPE
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEDBYUSER LASTCHANGEDBYUSER Changed by User
POSTINGDATE POSTINGDATE Posting Date for GR
PUBLICLAW PUBLICLAW
CREATEDBYUSERNAME CREATEDBYUSERNAME Created by User Name
CHANGEDBYUSERNAME CHANGEDBYUSERNAME Changed by User Name

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_S_BDGTDOC_OP.
-- 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_U_BDGTDOC_OP
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_BDGTDOC_OP AS
SELECT
  BUDGETDOCUMENTYEAR,
  BUDGETENTRYDOCUMENT,
  FINANCIALMANAGEMENTAREA,
  BUDGETENTRYDOCUMENTDATE,
  BUDGETENTRYDOCUMENTDESCRIPTION,
  BUDGETENTRYDOCUMENTSTATUS,
  BUDGETENTRYDOCUMENTSTATUSNAME,
  BUDGETENTRYDOCUMENTTYPE,
  BUDGETENTRYDOCUMENTTYPENAME,
  BUDGETINGPROCESS,
  BUDGETINGRESPONSIBLEPERSONNAME,
  BUDGETVERSION,
  CREATEDBYUSER,
  CREATIONDATE,
  FISCALTREASURYAGENCY,
  FISCALTREASURYLEGISLATIONTYPE,
  LASTCHANGEDATE,
  LASTCHANGEDBYUSER,
  POSTINGDATE,
  PUBLICLAW,
  CREATEDBYUSERNAME,
  CHANGEDBYUSERNAME
FROM ESH_N_BDGTDOC_OP
;

Learn More