P_EngmntProjGLAcctLneItmSemTag

DDL: P_ENGMNTPROJGLACCTLNEITMSEMTAG SQL: PENGFIGLACCTLST Type: view COMPOSITE Package: CPD_CDS
16 Fields 2 Data Sources

G/L Line Item with Semantic Tag Including FA

P_EngmntProjGLAcctLneItmSemTag is a Composite CDS View that provides data about "G/L Line Item with Semantic Tag Including FA" in SAP S/4HANA. It reads from 2 data sources (I_EngmntProjAssgmtToSessionUsr, I_GLAccountLineItemSemTag) and exposes 16 fields with key fields Ledger, GLAccountHierarchy, SemanticTag, ValidityStartDate, ValidityEndDate. Part of development package CPD_CDS.

Data Sources (2)

SourceAliasJoin Type
I_EngmntProjAssgmtToSessionUsr A from
I_GLAccountLineItemSemTag B inner

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PENGFIGLACCTLST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAccountLineItemSemTag Ledger Ledger
KEY GLAccountHierarchy I_GLAccountLineItemSemTag GLAccountHierarchy
KEY SemanticTag I_GLAccountLineItemSemTag SemanticTag Semantic Tag
KEY ValidityStartDate I_GLAccountLineItemSemTag ValidityStartDate Validity Start Date
KEY ValidityEndDate I_GLAccountLineItemSemTag ValidityEndDate ValidTo
Project I_GLAccountLineItemSemTag Project WBS Element
SalesOrder I_GLAccountLineItemSemTag SalesOrder SD Document
SalesOrderItem I_GLAccountLineItemSemTag SalesOrderItem Sales Order Item
RevenueAmountInCompanyCodeCrcy I_GLAccountLineItemSemTag RevenueAmountInCompanyCodeCrcy
CompanyCodeCurrency I_GLAccountLineItemSemTag CompanyCodeCurrency Local Currency
PostingDate I_GLAccountLineItemSemTag PostingDate Posting Date for GR
BusinessTransactionType I_GLAccountLineItemSemTag BusinessTransactionType Bus.transaction
IsMyProject I_EngmntProjAssgmtToSessionUsr IsMyProject
EngagementProjectUUID I_EngmntProjAssgmtToSessionUsr EngagementProjectUUID Engmnt Project UUID
Currency I_EngmntProjAssgmtToSessionUsr Currency Valuation Crcy
ProjectVisibility I_EngmntProjAssgmtToSessionUsr ProjectVisibility

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_EngmntProjGLAcctLneItmSemTag.
-- 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: PENGFIGLACCTLST

CREATE VIEW P_EngmntProjGLAcctLneItmSemTag AS
SELECT
  B.Ledger AS Ledger,
  B.GLAccountHierarchy AS GLAccountHierarchy,
  B.SemanticTag AS SemanticTag,
  B.ValidityStartDate AS ValidityStartDate,
  B.ValidityEndDate AS ValidityEndDate,
  B.Project AS Project,
  B.SalesOrder AS SalesOrder,
  B.SalesOrderItem AS SalesOrderItem,
  B.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInCompanyCodeCrcy,
  B.CompanyCodeCurrency AS CompanyCodeCurrency,
  B.PostingDate AS PostingDate,
  B.BusinessTransactionType AS BusinessTransactionType,
  A.IsMyProject AS IsMyProject,
  A.EngagementProjectUUID AS EngagementProjectUUID,
  A.Currency AS Currency,
  A.ProjectVisibility AS ProjectVisibility
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN I_GLAccountLineItemSemTag AS B ON /* join condition not captured in parsed metadata */
;

Learn More