I_SemTagGLAccount

DDL: I_SEMTAGGLACCOUNT SQL: IFISEMTAGGLACCT Type: view BASIC
14 Fields 1 Associations

G/L Account with Semantic Tag

I_SemTagGLAccount (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

SemanticTagGeneralLedger · Accounting and Financial Close

I_SemTagGLAccount is a Basic CDS View (Cube) that provides data about "G/L Account with Semantic Tag" in SAP S/4HANA. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryCube
Purpose
This CDS view is designed to provide a structured representation of General Ledger accounts with associated semantic tags. It facilitates the analysis and reporting of financial data by linking G/L accounts to semantic tags, which can be used to categorize and interpret financial information in a meaningful way. The view also includes associations to hierarchy nodes and other relevant financial structures, enabling comprehensive financial analysis. This CDS view provides the data to answer the following business questions: What are the semantic tags associated with each G/L account in the financial system? How do G/L accounts relate to specific hierarchy nodes within the financial reporting structure? What is the validity period for each semantic tag associated with a G/L account? Which G/L accounts are permitted to use functional areas based on their semantic tags? How can semantic tags be used to categorize and interpret financial data for reporting and analysis purposes? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Restriction Type ID Restriction Type HRYTYPE_HRYID_OH Hierarchy Type/ID for Overhead Accounting HRYTYPE_HRYID_LI Hierarchy Type/ID for Liquidity Item HRYTYPE_HRYID_BS Hierarchy Type/ID for Budget Specialist HRYTYPE_HRYID_SA Hierarchy Type/ID for Sales Accounting HRYTYPE_HRYID Hierarchy Type/ID HRYTYPE_HRYID_BAM Hierarchy Type/ID for Bank Account Management HRYTYPE_HRYID_CS Hierarchy Type/ID for Consolidation HRYTYPE_HRYID_DV Hierarchy Type/ID for Profit Center Accounting HRYTYPE_HRYID_GL Hierarchy Type/ID for General Ledger Accounting HRYTYPE_HRYID_GM Hierarchy Type/ID for Grants Management HRYTYPE_HRYID_FA Hierarchy Type/ID for Fund Accounting HRYTYPE_HRYID_FFS Hierarchy Type/ID for Financial Services Enhancements HRYTYPE_HRYID_PM Hierarchy Type/ID for Master Data - Product Master HRYTYPE_HRYID_CIT Hierarchy Type/ID for Corporate Income Tax HRYTYPE_HRYID_CS_AND_REF Hierarchy Type/ID for Consolidation including references You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Label GLAccountHierarchy FSV HierarchyNode Node SemanticTag Semantic Tag ValidityEndDate Valid To ValidityStartDate Valid From ChartOfAccounts Chart of Accounts GLAccount G/L Account FunctionalAreaIsUsed Functional Area IsFunctionalAreaPermitted Fun.Area Perm.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-IS
CapabilitiesData Source in SQL Select, Data Provider for Analytical Queries, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_GLAccountHierarchyNode _GLAccountHierarchyNode $projection.GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy and $projection.HierarchyNode = _GLAccountHierarchyNode.HierarchyNode

Annotations (14)

NameValueLevelField
EndUserText.label G/L Account with Semantic Tag view
AbapCatalog.sqlViewName IFISEMTAGGLACCT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name SemanticTagGeneralLedger view

Fields (14)

KeyFieldSource TableSource FieldDescription
GLAccountHierarchy GLAccountHierarchy Financial Statement Version
HierarchyNode Hierarchy node
SemanticTag SemanticTag Semantic Tag of a Hierarchy Node
ValidityEndDate ValidityEndDate Valid To Date
ValidityStartDate ValidityStartDate Validity Start Date
ChartOfAccounts ChartOfAccounts Chart of Accounts
GLAccount GLAccount General Ledger
FunctionalAreaIsUsed FunctionalAreaIsUsed Indicator: Functional Area Enabled
IsFunctionalAreaPermitted Indicator: Assignment of Functional Areas Is Permitted
_Hierarchy _Hierarchy
_GLAccountHierarchyNode _GLAccountHierarchyNode
_SemanticTag _SemanticTag
_ChartOfAccounts _ChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts

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_SemTagGLAccount.
-- 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: IFISEMTAGGLACCT

CREATE VIEW I_SemTagGLAccount AS
SELECT
  GLAccountHierarchy,
  cast ( '' as hrynode ) AS HierarchyNode,
  SemanticTag,
  ValidityEndDate,
  ValidityStartDate,
  ChartOfAccounts,
  GLAccount,
  FunctionalAreaIsUsed,
  cast( case when SemanticTag = 'NTINC_ALAC' then '' else FunctionalAreaIsUsed end as xfber_011 ) AS IsFunctionalAreaPermitted
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy AND HierarchyNode = _GLAccountHierarchyNode.HierarchyNode  -- association [0..*]
;

Learn More