P_LU_SAFTJournalTax

DDL: P_LU_SAFTJOURNALTAX SQL: PLUSAFTJNLTAX Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_LU
49 Fields 1 Data Sources

Journal Entries Relevant for Tax

P_LU_SAFTJournalTax is a Composite CDS View that provides data about "Journal Entries Relevant for Tax" in SAP S/4HANA. It reads from 1 data source (P_LU_SAFTDownPaymentDocOnly) and exposes 49 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger, LedgerGLLineItem. Part of development package GLO_FIN_IS_SAFT_LU.

Data Sources (1)

SourceAliasJoin Type
P_LU_SAFTDownPaymentDocOnly SpGLTax inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PLUSAFTJNLTAX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument JournalEntry AccountingDocument Journal Entry
KEY Ledger JournalEntry Ledger Ledger
KEY LedgerGLLineItem JournalEntry LedgerGLLineItem Journal Entry Item
AccountingDocumentItem JournalEntry AccountingDocumentItem Posting View Item
DocumentTransaction JournalEntry DocumentTransaction Transaction ID
AccountingDocumentType JournalEntry AccountingDocumentType Journal Entry Type
DocumentDate JournalEntry DocumentDate Journal Entry Date
PostingDate JournalEntry PostingDate Posting Date for GR
FiscalPeriod JournalEntry FiscalPeriod Tax period
AccountingDocumentCategory JournalEntry AccountingDocumentCategory Journal Entry Category
AccountingDocCreatedByUser JournalEntry AccountingDocCreatedByUser User which created overhead document
AccountingDocumentCreationDate JournalEntry AccountingDocumentCreationDate Journal Entry Date
ExchangeRate JournalEntry ExchangeRate Exchange rate
Customer JournalEntry Customer Sold-to Party
Supplier JournalEntry Supplier Supplier
FinancialAccountType JournalEntry FinancialAccountType Fin. Account Type
ChartOfAccounts JournalEntry ChartOfAccounts Node Class
GLAccount JournalEntry GLAccount General Ledger
SpecialGLCode JournalEntry SpecialGLCode Special G/L Ind
TaxCode JournalEntry TaxCode Tax Code
TaxCalculationProcedure JournalEntry TaxCalculationProcedure Tax Procedure
DocumentItemText JournalEntry DocumentItemText Text
DebitCreditCode JournalEntry DebitCreditCode Single-Character Flag
IsReversal JournalEntry IsReversal Reversal doc.
Quantity JournalEntry Quantity Value
CompanyCodeCurrency JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency JournalEntry TransactionCurrency Transaction Currency
AmountInCompanyCodeCurrency JournalEntry AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency JournalEntry AmountInTransactionCurrency Pt Crcy Amt
AccountingDocumentItemType JournalEntry AccountingDocumentItemType Line Item ID
VATRegistration JournalEntry VATRegistration VAT Registration No.
CompanyCodeCountry JournalEntry CompanyCodeCountry Reporting Ctry/Reg.
DelivOfGoodsDestCountry JournalEntry DelivOfGoodsDestCountry Dest. C/R
TransactionTypeDetermination JournalEntry TransactionTypeDetermination Transaction Key
CAIsDownPaymentRequest
_CompanyCode JournalEntry _CompanyCode
_FiscalYear JournalEntry _FiscalYear
_AccountingDocumentType JournalEntry _AccountingDocumentType
_AccountingDocumentCategory JournalEntry _AccountingDocumentCategory
_AccountingDocumentTypeText JournalEntry _AccountingDocumentTypeText
_Ledger JournalEntry _Ledger
_ChartOfAccounts JournalEntry _ChartOfAccounts
_DebitCreditCode JournalEntry _DebitCreditCode
_CompanyCodeCurrency JournalEntry _CompanyCodeCurrency
_TransactionCurrency JournalEntry _TransactionCurrency
_Supplier JournalEntry _Supplier
_Customer JournalEntry _Customer

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_LU_SAFTJournalTax.
-- 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: PLUSAFTJNLTAX

CREATE VIEW P_LU_SAFTJournalTax AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.Ledger AS Ledger,
  JournalEntry.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntry.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntry.DocumentTransaction AS DocumentTransaction,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  JournalEntry.ExchangeRate AS ExchangeRate,
  JournalEntry.Customer AS Customer,
  JournalEntry.Supplier AS Supplier,
  JournalEntry.FinancialAccountType AS FinancialAccountType,
  JournalEntry.ChartOfAccounts AS ChartOfAccounts,
  JournalEntry.GLAccount AS GLAccount,
  JournalEntry.SpecialGLCode AS SpecialGLCode,
  JournalEntry.TaxCode AS TaxCode,
  JournalEntry.TaxCalculationProcedure AS TaxCalculationProcedure,
  JournalEntry.DocumentItemText AS DocumentItemText,
  JournalEntry.DebitCreditCode AS DebitCreditCode,
  JournalEntry.IsReversal AS IsReversal,
  JournalEntry.Quantity AS Quantity,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  JournalEntry.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntry.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntry.AccountingDocumentItemType AS AccountingDocumentItemType,
  JournalEntry.VATRegistration AS VATRegistration,
  JournalEntry.CompanyCodeCountry AS CompanyCodeCountry,
  JournalEntry.DelivOfGoodsDestCountry AS DelivOfGoodsDestCountry,
  JournalEntry.TransactionTypeDetermination AS TransactionTypeDetermination,
  coalesce(SpGLTax.CAIsDownPaymentRequest, ' ') AS CAIsDownPaymentRequest,
  JournalEntry._CompanyCode AS _CompanyCode,
  JournalEntry._FiscalYear AS _FiscalYear,
  JournalEntry._AccountingDocumentType AS _AccountingDocumentType,
  JournalEntry._AccountingDocumentCategory AS _AccountingDocumentCategory,
  JournalEntry._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  JournalEntry._Ledger AS _Ledger,
  JournalEntry._ChartOfAccounts AS _ChartOfAccounts,
  JournalEntry._DebitCreditCode AS _DebitCreditCode,
  JournalEntry._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalEntry._TransactionCurrency AS _TransactionCurrency,
  JournalEntry._Supplier AS _Supplier,
  JournalEntry._Customer AS _Customer
INNER JOIN P_LU_SAFTDownPaymentDocOnly AS SpGLTax ON /* join condition not captured in parsed metadata */
;

Learn More