I_BudgetDocNumberStdVH

DDL: I_BUDGETDOCNUMBERSTDVH SQL: IBDGTDOCNBR_VH Type: view COMPOSITE
10 Fields 1 Data Sources

Budget Document Number Standard Value Help

I_BudgetDocNumberStdVH is a Composite CDS View that provides data about "Budget Document Number Standard Value Help" in SAP S/4HANA. It reads from 1 data source (I_BudgetDocument) and exposes 10 fields with key fields BudgetDocumentYear, BudgetDocument.

Data Sources (1)

SourceAliasJoin Type
I_BudgetDocument I_BudgetDocument from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBDGTDOCNBR_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Budget Document Number Standard Value Help view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BudgetDocument view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BudgetDocumentYear BudgetDocumentYear Fiscal Year
KEY BudgetDocument BudgetDocument Document Number
BudgetDocumentType BudgetDocumentType Document Type
PlanningCategory PlanningCategory Plan Category
BudgetCategoryUsage BudgetCategoryUsage Category Usage
PostingDate PostingDate Posting Date
DocumentDate DocumentDate Document Date
BudgetDocumentStatusText Document Status Name
_BudgetDocumentType _BudgetDocumentType
_PlanningCategory _PlanningCategory

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_BudgetDocNumberStdVH.
-- 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: IBDGTDOCNBR_VH

CREATE VIEW I_BudgetDocNumberStdVH AS
SELECT
  BudgetDocumentYear,
  BudgetDocument,
  BudgetDocumentType,
  PlanningCategory,
  BudgetCategoryUsage,
  PostingDate,
  DocumentDate,
  _BudgetDocumentStatus._Text[1:Language = $session.system_language].BudgetDocumentStatusText AS BudgetDocumentStatusText
FROM I_BudgetDocument
;

Learn More