P_PE_PurDmstcSuplrTaxItem

DDL: P_PE_PURDMSTCSUPLRTAXITEM SQL: PPEPDSTI Type: view CONSUMPTION Package: GLO_FIN_IS_PE
26 Fields 4 Data Sources

Peru: Purchase Domestic Supplier Tax Item

P_PE_PurDmstcSuplrTaxItem is a Consumption CDS View that provides data about "Peru: Purchase Domestic Supplier Tax Item" in SAP S/4HANA. It reads from 4 data sources (I_Country, P_PE_PurDmstcSuplrJEItemAggrgd, I_TaxCode, I_TaxItem) and exposes 26 fields with key fields CompanyCode, AccountingDocument, FiscalYear, StatryRptCategory, StatryRptgEntity. Part of development package GLO_FIN_IS_PE.

Data Sources (4)

SourceAliasJoin Type
I_Country Country inner
P_PE_PurDmstcSuplrJEItemAggrgd P_PE_PurDmstcSuplrJEItemAggrgd from
I_TaxCode TaxCode inner
I_TaxItem TaxItem inner

Parameters (2)

NameTypeDefault
P_ReportingCurrency glo_reporting_currency
P_TaxConversionIsNotEnabled fipe_deactivate_currency_conv

Annotations (9)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntry CompanyCode Receiver Company Code
KEY AccountingDocument JournalEntry AccountingDocument Journal Entry
KEY FiscalYear JournalEntry FiscalYear G/L Fiscal Year
KEY StatryRptCategory JournalEntry StatryRptCategory Report ID
KEY StatryRptgEntity JournalEntry StatryRptgEntity Reporting Entity
KEY StatryRptRunID JournalEntry StatryRptRunID Report Run ID
KEY Ledger JournalEntry Ledger Ledger
KEY TaxItem I_TaxItem TaxItem Tax Item
KEY TaxCode I_TaxItem TaxCode Tax Code
KEY TaxBox TaxBoxConfiguration TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxBoxConfiguration TaxDeclnAmountType
FiscalPeriod JournalEntry FiscalPeriod Tax period
PE_OriginalDocumentDate JournalEntry PE_OriginalDocumentDate
DocumentReferenceID JournalEntry DocumentReferenceID Reference
OriginalDocumentReferenceID JournalEntry OriginalDocumentReferenceID
ReportingDate JournalEntry ReportingDate
DocumentDate JournalEntry DocumentDate Journal Entry Date
NetDueDate JournalEntry NetDueDate Net Due Date
AccountingDocumentType JournalEntry AccountingDocumentType Journal Entry Type
Supplier JournalEntry Supplier Supplier
ExchangeRate JournalEntry ExchangeRate Exchange rate
CalendarYearMonth JournalEntry CalendarYearMonth
ExchangeRateDate
CountryCurrency I_Country CountryCurrency Currency
TransactionCurrency JournalEntry TransactionCurrency Transaction Currency
ReportingCurrency JournalEntry ReportingCurrency Currency

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_PE_PurDmstcSuplrTaxItem.
-- 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: PPEPDSTI
-- Parameters: P_ReportingCurrency : glo_reporting_currency, P_TaxConversionIsNotEnabled : fipe_deactivate_currency_conv

CREATE VIEW P_PE_PurDmstcSuplrTaxItem AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.StatryRptCategory AS StatryRptCategory,
  JournalEntry.StatryRptgEntity AS StatryRptgEntity,
  JournalEntry.StatryRptRunID AS StatryRptRunID,
  JournalEntry.Ledger AS Ledger,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxCode AS TaxCode,
  TaxBoxConfiguration.TaxBox AS TaxBox,
  TaxBoxConfiguration.TaxDeclnAmountType AS TaxDeclnAmountType,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.PE_OriginalDocumentDate AS PE_OriginalDocumentDate,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.OriginalDocumentReferenceID AS OriginalDocumentReferenceID,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.NetDueDate AS NetDueDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.Supplier AS Supplier,
  JournalEntry.ExchangeRate AS ExchangeRate,
  JournalEntry.CalendarYearMonth AS CalendarYearMonth,
  cast(coalesce(JournalEntry.PE_OriginalDocumentDate, JournalEntry.DocumentDate) as vdm_v_exchange_rate_date preserving type) AS ExchangeRateDate,
  Country.CountryCurrency AS CountryCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  JournalEntry.ReportingCurrency AS ReportingCurrency
FROM P_PE_PurDmstcSuplrJEItemAggrgd
INNER JOIN I_TaxItem AS TaxItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_Country AS Country ON /* join condition not captured in parsed metadata */
INNER JOIN I_TaxCode AS TaxCode ON /* join condition not captured in parsed metadata */
;

Learn More