R_ProjectSemTagGLAccount

DDL: R_PROJECTSEMTAGGLACCOUNT SQL: RPROJSEMTAGGLACT Type: view BASIC
9 Fields 1 Data Sources

GL Accounts for Semantic Tag

R_ProjectSemTagGLAccount is a Basic CDS View that provides data about "GL Accounts for Semantic Tag" in SAP S/4HANA. It reads from 1 data source (P_SemTagGLAccount) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
P_SemTagGLAccount P_SemTagGLAccount from

Annotations (10)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label GL Accounts for Semantic Tag view
AbapCatalog.sqlViewName RPROJSEMTAGGLACT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
GLAccountHierarchy GLAccountHierarchy
SemanticTag SemanticTag Semantic Tag
HierarchyNode HierarchyNode Node
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
HierarchyNodeClass Node Class
HierarchyNodeVal GLAccount General Ledger
_Hierarchy _Hierarchy
_SemanticTag _SemanticTag

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 R_ProjectSemTagGLAccount.
-- 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: RPROJSEMTAGGLACT

CREATE VIEW R_ProjectSemTagGLAccount AS
SELECT
  GLAccountHierarchy,
  SemanticTag,
  HierarchyNode,
  ValidityEndDate,
  ValidityStartDate,
  cast( ChartOfAccounts as nodecls) AS HierarchyNodeClass,
  GLAccount AS HierarchyNodeVal
FROM P_SemTagGLAccount
;

Learn More