P_NL_SAFTJournalLineItem

DDL: P_NL_SAFTJOURNALLINEITEM SQL: PNLSAFTJITEM Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_NL
57 Fields 2 Data Sources

Journal Line Items for NL Audit File

P_NL_SAFTJournalLineItem is a Composite CDS View that provides data about "Journal Line Items for NL Audit File" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInCompanyCode, I_JournalEntryItem) and exposes 57 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package GLO_FIN_IS_SAFT_NL.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInCompanyCode GLAccount inner
I_JournalEntryItem JournalEntryItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PNLSAFTJITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_JournalEntryItem SourceLedger Source Ledger
KEY CompanyCode I_JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_JournalEntryItem Ledger Ledger
CompanyCodeCurrency I_JournalEntryItem CompanyCodeCurrency Local Currency
GLAccount I_JournalEntryItem GLAccount General Ledger
AlternativeGLAccount I_JournalEntryItem AlternativeGLAccount Group Account
ChartOfAccounts I_JournalEntryItem ChartOfAccounts Node Class
CountryChartOfAccounts I_JournalEntryItem CountryChartOfAccounts Chart of Accts
ReferenceDocument I_JournalEntryItem ReferenceDocument Reference Document
PostingDate I_JournalEntryItem PostingDate Posting Date for GR
Customer I_JournalEntryItem Customer Sold-to Party
Supplier I_JournalEntryItem Supplier Supplier
TaxCode I_JournalEntryItem TaxCode Tax Code
ReferenceDocumentType I_JournalEntryItem ReferenceDocumentType Reference Document Type
ReversalReferenceDocument I_JournalEntryItem ReversalReferenceDocument Reversal Reference Document
IsReversed I_JournalEntryItem IsReversed Reversed?
CostCenter I_JournalEntryItem CostCenter Cost Center
ControllingArea I_JournalEntryItem ControllingArea Controlling Area
Quantity I_JournalEntryItem Quantity Value
LogicalSystem I_JournalEntryItem LogicalSystem Logical System
TransactionTypeDetermination I_JournalEntryItem TransactionTypeDetermination Transaction Key
FinancialAccountType I_JournalEntryItem FinancialAccountType Fin. Account Type
TaxCalculationProcedure
OrderID I_JournalEntryItem OrderID Order ID
AmountInTransactionCurrency I_JournalEntryItem AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency I_JournalEntryItem TransactionCurrency Transaction Currency
ValueDate I_JournalEntryItem ValueDate Value Date
AccountingDocumentItem I_JournalEntryItem AccountingDocumentItem Posting View Item
IsReversal I_JournalEntryItem IsReversal Reversal doc.
SalesDocument I_JournalEntryItem SalesDocument SD Document
SalesDocumentItem I_JournalEntryItem SalesDocumentItem Sales Document Item
InvoiceReference I_JournalEntryItem InvoiceReference Invoice Reference
InvoiceItemReference I_JournalEntryItem InvoiceItemReference Item
DocumentReferenceID
ReferenceDocumentContext I_JournalEntryItem ReferenceDocumentContext Reference Document Context
AccountingDocumentItemType AcctgDocItem AccountingDocumentItemType Line Item ID
ReconciliationAccountType I_GLAccountInCompanyCode ReconciliationAccountType Reconcil. ID
_SourceLedger _SourceLedger
_CompanyCode I_JournalEntryItem _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_Ledger _Ledger
_CompanyCodeCurrency _CompanyCodeCurrency
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_AlternativeGLAccount _AlternativeGLAccount
_ChartOfAccounts _ChartOfAccounts
_CountryChartOfAccounts _CountryChartOfAccounts
_Customer _Customer
_Supplier _Supplier
_CostCenter _CostCenter
_ControllingArea _ControllingArea
_LogicalSystem _LogicalSystem
_ReferenceDocumentType _ReferenceDocumentType
_Order _Order

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_NL_SAFTJournalLineItem.
-- 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: PNLSAFTJITEM

CREATE VIEW P_NL_SAFTJournalLineItem AS
SELECT
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.TaxCode AS TaxCode,
  JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntryItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntryItem.IsReversed AS IsReversed,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.Quantity AS Quantity,
  JournalEntryItem.LogicalSystem AS LogicalSystem,
  JournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  JournalEntryItem.OrderID AS OrderID,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.ValueDate AS ValueDate,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.SalesDocument AS SalesDocument,
  JournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
  JournalEntryItem.InvoiceReference AS InvoiceReference,
  JournalEntryItem.InvoiceItemReference AS InvoiceItemReference,
  JournalEntryItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  AcctgDocItem.AccountingDocumentItemType AS AccountingDocumentItemType,
  GLAccount.ReconciliationAccountType AS ReconciliationAccountType,
  JournalEntryItem._CompanyCode AS _CompanyCode
FROM I_JournalEntryItem AS JournalEntryItem
INNER JOIN I_GLAccountInCompanyCode AS GLAccount ON /* join condition not captured in parsed metadata */
;

Learn More