C_PT_SAFTGenLedgerEntryQry

DDL: C_PT_SAFTGENLEDGERENTRYQRY SQL: CPTSAFTGLENTQRY Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
15 Fields 1 Data Sources

SAF-T PT General Ledger Entries Query

C_PT_SAFTGenLedgerEntryQry is a Consumption CDS View that provides data about "SAF-T PT General Ledger Entries Query" in SAP S/4HANA. It reads from 1 data source (C_PT_SAFTGenLedgerEntryCube) and exposes 15 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (1)

SourceAliasJoin Type
C_PT_SAFTGenLedgerEntryCube a from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTGLENTQRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
AbapCatalog.preserveKey true view
EndUserText.label SAF-T PT General Ledger Entries Query view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode C_PT_SAFTGenLedgerEntryCube CompanyCode Receiver Company Code
KEY FiscalYear C_PT_SAFTGenLedgerEntryCube FiscalYear G/L Fiscal Year
KEY AccountingDocument C_PT_SAFTGenLedgerEntryCube AccountingDocument Journal Entry
KEY Ledger C_PT_SAFTGenLedgerEntryCube Ledger Ledger
JournalEntryType C_PT_SAFTGenLedgerEntryCube JournalEntryType Journal Entry Type
JournalEntry JournalEntry
DocumentTransaction C_PT_SAFTGenLedgerEntryCube DocumentTransaction Transaction ID
FiscalPeriod C_PT_SAFTGenLedgerEntryCube FiscalPeriod Tax period
TransactionDate C_PT_SAFTGenLedgerEntryCube TransactionDate Value Date
CreatedByUser C_PT_SAFTGenLedgerEntryCube CreatedByUser User Name
JournalDescription C_PT_SAFTGenLedgerEntryCube JournalDescription
FinancialTransactionType C_PT_SAFTGenLedgerEntryCube FinancialTransactionType Transact. Type
PostingDate C_PT_SAFTGenLedgerEntryCube PostingDate Posting Date for GR
Customer C_PT_SAFTGenLedgerEntryCube Customer Sold-to Party
Supplier C_PT_SAFTGenLedgerEntryCube Supplier Supplier

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_PT_SAFTGenLedgerEntryQry.
-- 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: CPTSAFTGLENTQRY

CREATE VIEW C_PT_SAFTGenLedgerEntryQry AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.AccountingDocument AS AccountingDocument,
  a.Ledger AS Ledger,
  a.JournalEntryType AS JournalEntryType,
  JournalEntry,
  a.DocumentTransaction AS DocumentTransaction,
  a.FiscalPeriod AS FiscalPeriod,
  a.TransactionDate AS TransactionDate,
  a.CreatedByUser AS CreatedByUser,
  a.JournalDescription AS JournalDescription,
  a.FinancialTransactionType AS FinancialTransactionType,
  a.PostingDate AS PostingDate,
  a.Customer AS Customer,
  a.Supplier AS Supplier
FROM C_PT_SAFTGenLedgerEntryCube AS a
;

Learn More