I_FSItemBySemanticTag

DDL: I_FSITEMBYSEMANTICTAG SQL: IFSITMBYSEMTA Type: view BASIC
11 Fields 2 Data Sources

Fetch Financial Statement Item By Semantic Tag

I_FSItemBySemanticTag is a Basic CDS View that provides data about "Fetch Financial Statement Item By Semantic Tag" in SAP S/4HANA. It reads from 2 data sources (finsc_fagl2semta, hrrp_node) and exposes 11 fields.

Data Sources (2)

SourceAliasJoin Type
finsc_fagl2semta FAGL from
hrrp_node HRRP inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFSITMBYSEMTA view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Fetch Financial Statement Item By Semantic Tag view

Fields (11)

KeyFieldSource TableSource FieldDescription
FinancialStatementVariant finsc_fagl2semta versn Version
HierarchyNode hrrp_node hrynode Node
HierarchyVersion hrrp_node hryver Version: Structures
ValidityStartDate hrrp_node hryvalfrom Valid From
ValidityEndDate hrrp_node hryvalto Valid To
SemanticTag finsc_fagl2semta fins_sem_tag Semantic Tag
FinancialStatementItem finsc_fagl2semta ergsl FS Item
LowerBoundaryAccount finsc_fagl2semta vonkt Account From
UpperBoundaryAccount finsc_fagl2semta biskt Account To
LowerBoundaryFunctionalArea finsc_fagl2semta vonfb Func. Area From
UpperBoundaryFunctionalArea finsc_fagl2semta bisfb Functl. Area To

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_FSItemBySemanticTag.
-- 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: IFSITMBYSEMTA

CREATE VIEW I_FSItemBySemanticTag AS
SELECT
  FAGL.versn AS FinancialStatementVariant,
  HRRP.hrynode AS HierarchyNode,
  HRRP.hryver AS HierarchyVersion,
  HRRP.hryvalfrom AS ValidityStartDate,
  HRRP.hryvalto AS ValidityEndDate,
  FAGL.fins_sem_tag AS SemanticTag,
  FAGL.ergsl AS FinancialStatementItem,
  FAGL.vonkt AS LowerBoundaryAccount,
  FAGL.biskt AS UpperBoundaryAccount,
  FAGL.vonfb AS LowerBoundaryFunctionalArea,
  FAGL.bisfb AS UpperBoundaryFunctionalArea
FROM finsc_fagl2semta AS FAGL
INNER JOIN hrrp_node AS HRRP ON /* join condition not captured in parsed metadata */
;

Learn More