P_GLAcctLineItemSemTagProjects

DDL: P_GLACCTLINEITEMSEMTAGPROJECTS Type: view COMPOSITE
25 Fields 1 Data Sources

P_GLAcctLineItemSemTagProjects is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAcctLineItemSemTagGLAcct) and exposes 25 fields with key fields Ledger, SourceLedger, CompanyCode, PostingFiscalYear, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
I_GLAcctLineItemSemTagGLAcct I_GLAcctLineItemSemTagGLAcct from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGLACCSEMTAGPROJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY PostingFiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY SemanticTag SemanticTag Semantic Tag
KEY GLAccountHierarchy GLAccountHierarchy
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY ValidityEndDate ValidityEndDate ValidTo
Project _ProjectBasicData Project WBS Element
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
BusinessTransactionType BusinessTransactionType Bus.transaction
FiscalYear
ControllingArea ControllingArea Controlling Area
Customer Customer Sold-to Party
PostingDate PostingDate Posting Date for GR
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency

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_GLAcctLineItemSemTagProjects.
-- 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.

CREATE VIEW P_GLAcctLineItemSemTagProjects AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear AS PostingFiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  SemanticTag,
  GLAccountHierarchy,
  ValidityStartDate,
  ValidityEndDate,
  _ProjectBasicData.Project AS Project,
  SalesOrder,
  SalesOrderItem,
  AccountAssignmentType,
  BusinessTransactionType,
  substring(PostingDate,1,4) AS FiscalYear,
  ControllingArea,
  Customer,
  PostingDate,
  AmountInCompanyCodeCurrency,
  AmountInObjectCurrency,
  AmountInGlobalCurrency,
  CompanyCodeCurrency,
  ControllingObjectCurrency,
  GlobalCurrency
FROM I_GLAcctLineItemSemTagGLAcct
;

Learn More