P_AR_StRpJrnlLdgrJrnlEntryItem

DDL: P_AR_STRPJRNLLDGRJRNLENTRYITEM SQL: PARJRNLLDGENTIT Type: view CONSUMPTION Package: GLO_FIN_IS_AR_JOURNAL_LEDGER
31 Fields 2 Data Sources

Argentina Journal Entry Item for Journal Ledger Report

P_AR_StRpJrnlLdgrJrnlEntryItem is a Consumption CDS View that provides data about "Argentina Journal Entry Item for Journal Ledger Report" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntryItem, I_StRpJournalEntryLog) and exposes 31 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_AR_JOURNAL_LEDGER.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntryItem JournalEntryItem from
I_StRpJournalEntryLog StRpJournalEntryLog inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PARJRNLLDGENTIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_JournalEntryItem SourceLedger Source Ledger
KEY Ledger I_JournalEntryItem Ledger 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 StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
AccountingDocumentItem I_JournalEntryItem AccountingDocumentItem Posting View Item
ReferenceDocumentType I_JournalEntryItem ReferenceDocumentType Reference Document Type
GLAccount I_JournalEntryItem GLAccount General Ledger
ChartOfAccounts I_JournalEntryItem ChartOfAccounts Node Class
FinancialAccountType I_JournalEntryItem FinancialAccountType Fin. Account Type
TaxCode I_JournalEntryItem TaxCode Tax Code
SupplierFiscalAdress
CustomerFiscalAdress
SupplierCountry
SupplierIsNaturalPerson
SupplierName
SupplierTaxNumber1
CustomerCountry
CustomerIsNaturalPerson
CustomerName
CustomerTaxNumber1
DebitCreditCode I_JournalEntryItem DebitCreditCode Single-Character Flag
CompanyCodeCurrency I_JournalEntryItem CompanyCodeCurrency Local Currency
TransactionCurrency I_JournalEntryItem TransactionCurrency Transaction Currency
AmountInCompanyCodeCurrency I_JournalEntryItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency I_JournalEntryItem AmountInTransactionCurrency Pt Crcy Amt

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_AR_StRpJrnlLdgrJrnlEntryItem.
-- 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: PARJRNLLDGENTIT

CREATE VIEW P_AR_StRpJrnlLdgrJrnlEntryItem AS
SELECT
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.TaxCode AS TaxCode,
  cast( JournalEntryItem._Supplier.FiscalAddress as fiskn_d ) AS SupplierFiscalAdress,
  JournalEntryItem._Customer.FiscalAddress AS CustomerFiscalAdress,
  JournalEntryItem._Supplier.Country AS SupplierCountry,
  JournalEntryItem._Supplier.IsNaturalPerson AS SupplierIsNaturalPerson,
  JournalEntryItem._Supplier.SupplierName AS SupplierName,
  JournalEntryItem._Supplier.TaxNumber1 AS SupplierTaxNumber1,
  JournalEntryItem._Customer.Country AS CustomerCountry,
  JournalEntryItem._Customer.NFPartnerIsNaturalPerson AS CustomerIsNaturalPerson,
  JournalEntryItem._Customer.CustomerName AS CustomerName,
  JournalEntryItem._Customer.TaxNumber1 AS CustomerTaxNumber1,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency
FROM I_JournalEntryItem AS JournalEntryItem
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;

Learn More