P_PE_GLAccountLineItemSemTag

DDL: P_PE_GLACCOUNTLINEITEMSEMTAG Type: view_entity CONSUMPTION
35 Fields 2 Data Sources

P_PE_GLAccountLineItemSemTag is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItem, I_SemTagGLAccount) and exposes 35 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItem GLAccountLineItem from
I_SemTagGLAccount SemTagGLAccount inner

Parameters (1)

NameTypeDefault
P_ReportingCurrency glo_reporting_currency

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAccountLineItem Ledger Ledger
KEY SourceLedger I_GLAccountLineItem SourceLedger Source Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem Journal Entry Item
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY SemanticTag I_SemTagGLAccount SemanticTag Semantic Tag
KEY ValidityStartDate I_SemTagGLAccount ValidityStartDate Validity Start Date
KEY ValidityEndDate I_SemTagGLAccount ValidityEndDate ValidTo
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
FiscalYearVariant I_GLAccountLineItem FiscalYearVariant FY Variant
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
AccountingDocumentCategory I_GLAccountLineItem AccountingDocumentCategory Journal Entry Category
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Node Class
GLAccount I_GLAccountLineItem GLAccount General Ledger
AlternativeGLAccount I_GLAccountLineItem AlternativeGLAccount Group Account
CountryChartOfAccounts I_GLAccountLineItem CountryChartOfAccounts Chart of Accts
ReportingCurrency
_Ledger I_GLAccountLineItem _Ledger
_SourceLedger I_GLAccountLineItem _SourceLedger
_JournalEntry I_GLAccountLineItem _JournalEntry
_CompanyCode I_GLAccountLineItem _CompanyCode
_FiscalYear I_GLAccountLineItem _FiscalYear
_FiscalPeriodForVariant I_GLAccountLineItem _FiscalPeriodForVariant
_FiscalCalendarDate I_GLAccountLineItem _FiscalCalendarDate
_LedgerFiscalYearForVariant I_GLAccountLineItem _LedgerFiscalYearForVariant
_GLAccountInChartOfAccounts I_GLAccountLineItem _GLAccountInChartOfAccounts
_ChartOfAccounts I_GLAccountLineItem _ChartOfAccounts
_AccountingDocumentCategory I_GLAccountLineItem _AccountingDocumentCategory
_AlternativeGLAccount I_GLAccountLineItem _AlternativeGLAccount
_CountryChartOfAccounts I_GLAccountLineItem _CountryChartOfAccounts
_SemanticTag I_SemTagGLAccount _SemanticTag
_Hierarchy I_SemTagGLAccount _Hierarchy

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 P_PE_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.
-- Parameters: P_ReportingCurrency : glo_reporting_currency

CREATE VIEW P_PE_GLAccountLineItemSemTag AS
SELECT
  GLAccountLineItem.Ledger AS Ledger,
  GLAccountLineItem.SourceLedger AS SourceLedger,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  GLAccountLineItem.AccountingDocument AS AccountingDocument,
  GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  SemTagGLAccount.SemanticTag AS SemanticTag,
  SemTagGLAccount.ValidityStartDate AS ValidityStartDate,
  SemTagGLAccount.ValidityEndDate AS ValidityEndDate,
  GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  GLAccountLineItem.PostingDate AS PostingDate,
  GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  GLAccountLineItem.GLAccount AS GLAccount,
  GLAccountLineItem.AlternativeGLAccount AS AlternativeGLAccount,
  GLAccountLineItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  cast( $parameters.P_ReportingCurrency as glo_reporting_currency ) AS ReportingCurrency,
  GLAccountLineItem._Ledger AS _Ledger,
  GLAccountLineItem._SourceLedger AS _SourceLedger,
  GLAccountLineItem._JournalEntry AS _JournalEntry,
  GLAccountLineItem._CompanyCode AS _CompanyCode,
  GLAccountLineItem._FiscalYear AS _FiscalYear,
  GLAccountLineItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  GLAccountLineItem._FiscalCalendarDate AS _FiscalCalendarDate,
  GLAccountLineItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  GLAccountLineItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
  GLAccountLineItem._AlternativeGLAccount AS _AlternativeGLAccount,
  GLAccountLineItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  SemTagGLAccount._SemanticTag AS _SemanticTag,
  SemTagGLAccount._Hierarchy AS _Hierarchy
FROM I_GLAccountLineItem AS GLAccountLineItem
INNER JOIN I_SemTagGLAccount AS SemTagGLAccount ON /* join condition not captured in parsed metadata */
;

Learn More