What is C_GLAccountLineItemSemTag in SAP S/4HANA?

C_GLAccountLineItemSemTag is a consumption CDS view in SAP S/4HANA. G/L Line Item with Semantic Tag - Query It contains 122 fields.

Which tables does C_GLAccountLineItemSemTag read from?

C_GLAccountLineItemSemTag reads data from: I_GLAccountLineItemSemTag.

What VDM layer is C_GLAccountLineItemSemTag?

C_GLAccountLineItemSemTag is classified as a Consumption view optimized for specific business scenarios and reporting.

C_GLAccountLineItemSemTag

DDL: C_GLACCOUNTLINEITEMSEMTAG SQL: CFIGLACCTLITST Type: view CONSUMPTION

122 Fields 1 Data Sources

G/L Line Item with Semantic Tag - Query

C_GLAccountLineItemSemTag (Consumption)

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

Accounting and Financial Close

C_GLAccountLineItemSemTag is a Consumption CDS View that provides data about "G/L Line Item with Semantic Tag - Query" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemSemTag) and exposes 122 fields with key fields GLAccountHierarchy, CompanyCode, LedgerFiscalYear, Ledger.

SAP Help Documentation

Category	CDS Views for Transaction Data
Data Category	Query
Status	Released
Corresponding DataSource	2CCFIGLACCTLITST

Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the key figure amounts for a specific company code in a certain fiscal year? What is the ratio of margin to revenue? What is my net cash amount in company code currency?

Prerequisites
Users who want to consume data using this CDS view must be able to display data for the relevant fields in the universal journal, such as ledger, company code, cost center, profit center, and segment.

Structure
Business Objects This view is built on the following business objects: Semantic tags Cube view I_JOURNALENTRYITEMCUBE Views This view is built on the following views: I_GLAcctLineItemSemTagGLAcct : G/L line items with semantic tags I_GLAccountLineItemSemTag : G/L line items with semantic tags (functional areas included) Main input parameters The main input parameters are: P_KeyDate used to specify the key date of consumption. The default value is today. P_Language used to specify the language. The default value is the system language. Measures and attributes The view contains the following important measures and attributes: Net cash generated from continuing operating activities Net cash used in continuing investing activities Net cash generated from financing activities Net cash amount in company code currency Financial statement version Recognized revenue Revenue amount in global and company code currency

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-GL-IS
Capabilities	Analytical Query
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are the key figure amounts for a specific company code in a certain fiscal year?</p></li> <li><p>What is the ratio of margin to revenue?</p></li> <li><p>What is my net cash amount in company code currency?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_GLAccountLineItemSemTag	I_GLAccountLineItemSemTag	from

Parameters (2)

Name	Type	Default
P_KeyDate	sydate
P_Language	sylangu

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CFIGLACCTLITST	view
EndUserText.label	G/L Line Item with Semantic Tag - Query	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
OData.publish	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view

Fields (122)

Key	Field	Source Field	Description
KEY	GLAccountHierarchy	GLAccountHierarchy	Financial Statement Version
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	LedgerFiscalYear	LedgerFiscalYear	Fiscal Year of Ledger
KEY	Ledger	Ledger	Ledger in General Ledger Accounting
	FiscalPeriod	FiscalPeriod	Fiscal Period
	Project	Project	WBS Element
	FiscalQuarter	FiscalQuarter	Fiscal Quarter
	WBSElement	WBSElement	Work Breakdown Structure Element (WBS Element)
	SemanticTag	SemanticTag	Semantic Tag of a Hierarchy Node
	GLAccount	GLAccount	General Ledger
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	CostCenter	CostCenter	Cost Center
	ProfitCenter	ProfitCenter	Profit Center
	AccountingDocument	AccountingDocument	Journal Entry
	Segment	Segment	Segment for Segmental Reporting
	RevenueAmountInCompanyCodeCrcy	RevenueAmountInCompanyCodeCrcy	Revenue Amount in Company Code Currency
	RevenueInGlobalCurrency	RevenueInGlobalCurrency	Revenue Amount in Global Currency
	GrossRevenueAmtInCCCrcy	GrossRevenueAmtInCCCrcy	Gross Revenue
	RecognizedRevnAmtInCCCrcy	RecognizedRevnAmtInCCCrcy	Recognized Revenue
	RecognizedRevnAmtInGlobCrcy	RecognizedRevnAmtInGlobCrcy	Recognized Revenue
	RevenueAdjustmentAmtInCCCrcy	RevenueAdjustmentAmtInCCCrcy	Revenue Adjustment
	RevenueAdjustAmtInGlobCrcy	RevenueAdjustAmtInGlobCrcy	Revenue Adjustment
	DeferredRevenueAmtInCCCrcy	DeferredRevenueAmtInCCCrcy	Deferred Revenue
	AccruedRevenueAmtInCCCrcy	AccruedRevenueAmtInCCCrcy	Accrued Revenue
	RecognizableRevenueAmtInCCCrcy	RecognizableRevenueAmtInCCCrcy	Actual Revenue
	RecognizableRevnAmtInGlobCrcy	RecognizableRevnAmtInGlobCrcy	Actual Revenue
	BilledRevenueAmtInCoCodeCrcy	BilledRevenueAmtInCoCodeCrcy	Actual Revenue
	BilledRevenueAmtInGlobCrcy	BilledRevenueAmtInGlobCrcy	Actual Revenue
	BilledValnQtyInCostSourceUnit	BilledValnQtyInCostSourceUnit	Billed Quantity
	UnbilledRevnInCoCodeCrcy	UnbilledRevnInCoCodeCrcy	Unbilled Revenue
	RecognizedMarginAmtInCCCrcy	RecognizedMarginAmtInCCCrcy	Recognized Margin
	MnlContrAccrPnLItmAmtInCCCrcy	MnlContrAccrPnLItmAmtInCCCrcy	Manual Contract Accruals Income Statement in CCCrcy
	CostAmountInCompanyCodeCrcy	CostAmountInCompanyCodeCrcy	Cost Amount in Company Code Currency
	CostOfGoodsSoldAmtInGlobCrcy	CostOfGoodsSoldAmtInGlobCrcy	Cost of Goods Sold - Total
	FxdCOGSAmtInGlobCrcy	FxdCOGSAmtInGlobCrcy	Cost of Goods Sold - Fixed
	RecognizedCOGSAmtInCCCrcy	RecognizedCOGSAmtInCCCrcy	Recognized COS
	COGSAdjustmentAmtInCCCrcy	COGSAdjustmentAmtInCCCrcy	COS Adjustment
	DeferredCOGSAmtInCCCrcy	DeferredCOGSAmtInCCCrcy	Deferred COS
	AccruedCOGSAmtInCCCrcy	AccruedCOGSAmtInCCCrcy	Accrued COS
	RecognizableCostAmtInCCCrcy	RecognizableCostAmtInCCCrcy	Actual Cost
	ImminentLossRsrvAmtInCCCrcy	ImminentLossRsrvAmtInCCCrcy	Reserves for Imminent Loss
	SalesDeductReserveAmtInCCCrcy	SalesDeductReserveAmtInCCCrcy	Reserves for Anticipated Sales Deductions
	UnrlzdCostsReserveAmtInCCCrcy	UnrlzdCostsReserveAmtInCCCrcy	Reserves for Unrealized Costs
	MnlContrAccrBalShtAmtInCCCrcy	MnlContrAccrBalShtAmtInCCCrcy	Manual Contract Accruals Balance Sheet in CCCrcy
	SalesDeductionAmountInGlobCrcy	SalesDeductionAmountInGlobCrcy	Sales Deduction
	SalesDeductionAmtInCoCodeCrcy	SalesDeductionAmtInCoCodeCrcy	Sales Deduction
	PriceDifferenceAmtInGlobCrcy	PriceDifferenceAmtInGlobCrcy	Price Differences
	AdminOverheadAmtInGlobCrcy	AdminOverheadAmtInGlobCrcy	Administration Overhead
	SalesOverheadAmtInGlobCrcy	SalesOverheadAmtInGlobCrcy	Sales Overhead
	MarketingOverheadAmtInGlobCrcy	MarketingOverheadAmtInGlobCrcy	Marketing Overhead
	RnDOverheadAmtInGlobCrcy	RnDOverheadAmtInGlobCrcy	Research and Development Overhead
	LongTermInvmtAmtInCCCrcy	LongTermInvmtAmtInCCCrcy	Increase (Decrease) in Long-term Investments
	AcctsRblAmtInCCCrcy	AcctsRblAmtInCCCrcy	Increase (Decrease) in Accounts Receivable (Net)
	AcctsOthRblAmtInCCCrcy	AcctsOthRblAmtInCCCrcy	Increase (Decrease) in Accounts Other Receivable (Net)
	AcctsPyblAmtInCCCrcy	AcctsPyblAmtInCCCrcy	Increase (Decrease) in Accounts Payable (Net)
	AcctsOthPyblAmtInCCCrcy	AcctsOthPyblAmtInCCCrcy	Increase (Decrease) in Accounts Other Payables (Net)
	ProvisionAmtInCCCrcy	ProvisionAmtInCCCrcy	Increase/Decrease of Provisions
	NotesReceivableAmtInCCCrcy	NotesReceivableAmtInCCCrcy	Increase (Decrease) in Notes Receivable
	TangibleAstDeprAmtInCCCrcy	TangibleAstDeprAmtInCCCrcy	Depreciation of Tangible Assets
	IntngblAssetAmtznAmtInCCCrcy	IntngblAssetAmtznAmtInCCCrcy	Amortization of Intangible Assets
	TangibleAstAmtInCCCrcy	TangibleAstAmtInCCCrcy	Purchase (Sale) of Tangible Assets
	IntangibleAstAmtInCCCrcy	IntangibleAstAmtInCCCrcy	Purchase (Sale) of Intangible Assets
	FixedAssetRtrmtAmtInCCCrcy	FixedAssetRtrmtAmtInCCCrcy	Gain/Loss from Retirement of Fixed Assets
	InventoryAmtInCCCrcy	InventoryAmtInCCCrcy	Increase/Decrease of Inventories
	CommonStockAmtInCCCrcy	CommonStockAmtInCCCrcy	Increase (Decrease) in Common Stocks
	CashAndCashEqvlntAmtInCCCrcy	CashAndCashEqvlntAmtInCCCrcy	Change (Increase/ Decrease) in cash and cash equivalents
	AssetAmtInCCCrcy	AssetAmtInCCCrcy	Asset Amount In CompanyCode Currency
	LiabilityEquityAmtInCCCrcy	LiabilityEquityAmtInCCCrcy	Liabilities and Equity Amount In Company Code Currency
	NotAssignedAmtInCCCrcy	NotAssignedAmtInCCCrcy	Not Assigned Amount In Company Code Currency
	NetResultAmtInCCCrcy	NetResultAmtInCCCrcy	Net Result Amount In Company Code Currency
	PnLResultAmtInCCCrcy	PnLResultAmtInCCCrcy	Profit for the Period
	GLAcctNetIncomeAmtInCCCrcy	GLAcctNetIncomeAmtInCCCrcy	Net Income Amount In Company Code Currency
	VarblCOGSAmtInGlobCrcy	VarblCOGSAmtInGlobCrcy	Cost of Goods Sold - Variable
	ContrbnMargin1AmtInGlobCrcy	ContrbnMargin1AmtInGlobCrcy	Contribution Margin I
	ContrbnMargin2AmtInGlobCrcy	ContrbnMargin2AmtInGlobCrcy	Contribution Margin II
	ContrbnMargin3AmtInGlobCrcy	ContrbnMargin3AmtInGlobCrcy	Contribution Margin III
	OperatingActyCashAmtInCCCrcy	OperatingActyCashAmtInCCCrcy	Net cash generated from continuing operating activities
	InvestingActyCashAmtInCCCrcy	InvestingActyCashAmtInCCCrcy	Net cash used in continuing investing activities
	FinancingActyCashAmtInCCCrcy	FinancingActyCashAmtInCCCrcy	Net cash generated from financing activities
	NetCashAmtInCCCrcy	NetCashAmtInCCCrcy	Net Cash Amount In CompanyCode Currency
	AssetLiabilityAmtInCCCrcy	AssetLiabilityAmtInCCCrcy	Asset/Liability Amount in Company Code Currency
	RecognizedMarginPercent	0
	CompanyCodeCurrency	CompanyCodeCurrency	Company Code Currency
	GlobalCurrency	GlobalCurrency	GM Billing Element: Global Currency
	BalanceTransactionCurrency	BalanceTransactionCurrency	Balance Transaction Currency
	TransactionCurrency	TransactionCurrency	Transaction Currency
	FunctionalCurrency	FunctionalCurrency	Functional Currency
	FreeDefinedCurrency1	FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2	FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3	FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4	FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5	FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6	FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7	FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	AmountInTransactionCurrency	AmountInTransactionCurrency	Amount in Transaction Currency
	AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global Currency
	AmountInBalanceTransacCrcy	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	AmountInFunctionalCurrency	AmountInFunctionalCurrency	Amount in Functional Currency
	DebitAmountInFunctionalCrcy	DebitAmountInFunctionalCrcy	Debit Amount in Functional Currency
	CreditAmountInFunctionalCrcy	CreditAmountInFunctionalCrcy	Credit Amount in Functional Currency
	AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	WBSElementInternalID	WBSElementInternalID	WBS Element Internal ID
	ProjectInternalID	ProjectInternalID	Project Internal ID
	_CompanyCode	_CompanyCode
	FiscalYear	FiscalYear	G/L Fiscal Year
	ChartOfAccounts	ChartOfAccounts	Chart of Accounts
	ControllingArea	ControllingArea	Controlling Area
	FiscalYearVariant	FiscalYearVariant	Fiscal Year Variant
	_JournalEntry	_JournalEntry
	_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts
	_CostCenter	_CostCenter
	_ProfitCenter	_ProfitCenter
	_LedgerFiscalYearForVariant	_LedgerFiscalYearForVariant

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 C_GLAccountLineItemSemTag.
-- 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: CFIGLACCTLITST
-- Parameters: P_KeyDate : sydate, P_Language : sylangu

CREATE VIEW C_GLAccountLineItemSemTag AS
SELECT
  GLAccountHierarchy,
  CompanyCode,
  LedgerFiscalYear,
  Ledger,
  FiscalPeriod,
  Project,
  FiscalQuarter,
  WBSElement,
  SemanticTag,
  GLAccount,
  FunctionalArea,
  CostCenter,
  ProfitCenter,
  AccountingDocument,
  Segment,
  RevenueAmountInCompanyCodeCrcy,
  RevenueInGlobalCurrency,
  GrossRevenueAmtInCCCrcy,
  RecognizedRevnAmtInCCCrcy,
  RecognizedRevnAmtInGlobCrcy,
  RevenueAdjustmentAmtInCCCrcy,
  RevenueAdjustAmtInGlobCrcy,
  DeferredRevenueAmtInCCCrcy,
  AccruedRevenueAmtInCCCrcy,
  RecognizableRevenueAmtInCCCrcy,
  RecognizableRevnAmtInGlobCrcy,
  BilledRevenueAmtInCoCodeCrcy,
  BilledRevenueAmtInGlobCrcy,
  BilledValnQtyInCostSourceUnit,
  UnbilledRevnInCoCodeCrcy,
  RecognizedMarginAmtInCCCrcy,
  MnlContrAccrPnLItmAmtInCCCrcy,
  CostAmountInCompanyCodeCrcy,
  CostOfGoodsSoldAmtInGlobCrcy,
  FxdCOGSAmtInGlobCrcy,
  RecognizedCOGSAmtInCCCrcy,
  COGSAdjustmentAmtInCCCrcy,
  DeferredCOGSAmtInCCCrcy,
  AccruedCOGSAmtInCCCrcy,
  RecognizableCostAmtInCCCrcy,
  ImminentLossRsrvAmtInCCCrcy,
  SalesDeductReserveAmtInCCCrcy,
  UnrlzdCostsReserveAmtInCCCrcy,
  MnlContrAccrBalShtAmtInCCCrcy,
  SalesDeductionAmountInGlobCrcy,
  SalesDeductionAmtInCoCodeCrcy,
  PriceDifferenceAmtInGlobCrcy,
  AdminOverheadAmtInGlobCrcy,
  SalesOverheadAmtInGlobCrcy,
  MarketingOverheadAmtInGlobCrcy,
  RnDOverheadAmtInGlobCrcy,
  LongTermInvmtAmtInCCCrcy,
  AcctsRblAmtInCCCrcy,
  AcctsOthRblAmtInCCCrcy,
  AcctsPyblAmtInCCCrcy,
  AcctsOthPyblAmtInCCCrcy,
  ProvisionAmtInCCCrcy,
  NotesReceivableAmtInCCCrcy,
  TangibleAstDeprAmtInCCCrcy,
  IntngblAssetAmtznAmtInCCCrcy,
  TangibleAstAmtInCCCrcy,
  IntangibleAstAmtInCCCrcy,
  FixedAssetRtrmtAmtInCCCrcy,
  InventoryAmtInCCCrcy,
  CommonStockAmtInCCCrcy,
  CashAndCashEqvlntAmtInCCCrcy,
  AssetAmtInCCCrcy,
  LiabilityEquityAmtInCCCrcy,
  NotAssignedAmtInCCCrcy,
  NetResultAmtInCCCrcy,
  PnLResultAmtInCCCrcy,
  GLAcctNetIncomeAmtInCCCrcy,
  VarblCOGSAmtInGlobCrcy,
  ContrbnMargin1AmtInGlobCrcy,
  ContrbnMargin2AmtInGlobCrcy,
  ContrbnMargin3AmtInGlobCrcy,
  OperatingActyCashAmtInCCCrcy,
  InvestingActyCashAmtInCCCrcy,
  FinancingActyCashAmtInCCCrcy,
  NetCashAmtInCCCrcy,
  AssetLiabilityAmtInCCCrcy,
  0 AS RecognizedMarginPercent,
  CompanyCodeCurrency,
  GlobalCurrency,
  BalanceTransactionCurrency,
  TransactionCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  AmountInGlobalCurrency,
  AmountInBalanceTransacCrcy,
  AmountInFunctionalCurrency,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  WBSElementInternalID,
  ProjectInternalID,
  FiscalYear,
  ChartOfAccounts,
  ControllingArea,
  FiscalYearVariant
FROM I_GLAccountLineItemSemTag
;

Depth:

C_GLAccountLineItemSemTag view

I_GLAccountLineItemSemTag view