P_AR_JrnlEntryWthOfclDocType

DDL: P_AR_JRNLENTRYWTHOFCLDOCTYPE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_AR
16 Fields 2 Data Sources

Argentina Journal Entry with Official Document Type Fields

P_AR_JrnlEntryWthOfclDocType is a Consumption CDS View that provides data about "Argentina Journal Entry with Official Document Type Fields" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, P_AR_JournalEntry) and exposes 16 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_VAT_AR.

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
P_AR_JournalEntry JournalEntry from

Parameters (1)

NameTypeDefault
P_AR_Report progname

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_AR_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear P_AR_JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument P_AR_JournalEntry AccountingDocument Journal Entry
FiscalPeriod P_AR_JournalEntry FiscalPeriod Tax period
PostingDate P_AR_JournalEntry PostingDate Posting Date for GR
DocumentDate P_AR_JournalEntry DocumentDate Journal Entry Date
TaxReportingDate P_AR_JournalEntry TaxReportingDate Tax Reporting Date
ReportingDate P_AR_JournalEntry ReportingDate
AccountingDocumentType P_AR_JournalEntry AccountingDocumentType Journal Entry Type
AccountingDocumentCategory P_AR_JournalEntry AccountingDocumentCategory Journal Entry Category
DocumentReferenceID P_AR_JournalEntry DocumentReferenceID Reference
ExchangeRateDate P_AR_JournalEntry ExchangeRateDate Translatn Date
ExchangeRate P_AR_JournalEntry ExchangeRate Exchange rate
CompanyCodeCurrency P_AR_JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency P_AR_JournalEntry TransactionCurrency Transaction Currency
_OneTimeAccountBP P_AR_JournalEntry _OneTimeAccountBP

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_JrnlEntryWthOfclDocType.
-- 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.
-- Parameters: P_AR_Report : progname

CREATE VIEW P_AR_JrnlEntryWthOfclDocType AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.TaxReportingDate AS TaxReportingDate,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.ExchangeRateDate AS ExchangeRateDate,
  JournalEntry.ExchangeRate AS ExchangeRate,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  JournalEntry._OneTimeAccountBP AS _OneTimeAccountBP
FROM P_AR_JournalEntry AS JournalEntry
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More