P_AU_StRpTPARTaxLineItems

DDL: P_AU_STRPTPARTAXLINEITEMS SQL: PAUSRTPARTXLITMS Type: view COMPOSITE Package: GLO_FIN_IS_AU
20 Fields 2 Data Sources

Tax Items of TPAR Accounting Docs

P_AU_StRpTPARTaxLineItems is a Composite CDS View that provides data about "Tax Items of TPAR Accounting Docs" in SAP S/4HANA. It reads from 2 data sources (I_AU_StRpTPARInvoiceLineItems, P_StRpTaxItem) and exposes 20 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. Part of development package GLO_FIN_IS_AU.

Data Sources (2)

SourceAliasJoin Type
I_AU_StRpTPARInvoiceLineItems I_AU_StRpTPARInvoiceLineItems from
P_StRpTaxItem StRpTaxItem inner

Parameters (2)

NameTypeDefault
P_FromReportingDate figen_rep_date_from
P_ToReportingDate figen_rep_date_to

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PAUSRTPARTXLITMS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID StRpJournalEntryLog StatryRptRunID Report Run ID
KEY CompanyCode StRpTPARInvcLineItms CompanyCode Receiver Company Code
KEY AccountingDocument StRpTPARInvcLineItms AccountingDocument Journal Entry
KEY FiscalYear StRpTPARInvcLineItms FiscalYear G/L Fiscal Year
KEY TaxItem P_StRpTaxItem TaxItem Tax Item
DocumentItem
Supplier StRpTPARInvcLineItms Supplier Supplier
TotalGrossAmountInCoCodeCrcy
AU_TPARServiceType StRpTPARInvcLineItms AU_TPARServiceType Service Type
AU_TPARGrantName StRpTPARInvcLineItms AU_TPARGrantName
ClearingJournalEntry StRpTPARInvcLineItms ClearingJournalEntry Clrng doc.
PaymentDocument StRpTPARInvcLineItms PaymentDocument Payment Document Number
TaxCode P_StRpTaxItem TaxCode Tax Code
AU_TPARGrantObject
GLAccountelseendasGLAccount
ReportingCurrency P_StRpTaxItem ReportingCurrency Currency
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy

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_AU_StRpTPARTaxLineItems.
-- 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: PAUSRTPARTXLITMS
-- Parameters: P_FromReportingDate : figen_rep_date_from, P_ToReportingDate : figen_rep_date_to

CREATE VIEW P_AU_StRpTPARTaxLineItems AS
SELECT
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  StRpTPARInvcLineItms.CompanyCode AS CompanyCode,
  StRpTPARInvcLineItms.AccountingDocument AS AccountingDocument,
  StRpTPARInvcLineItms.FiscalYear AS FiscalYear,
  StRpTaxItem.TaxItem AS TaxItem,
  min ( StRpTPARInvcLineItms.AccountingDocumentItem) AS DocumentItem,
  StRpTPARInvcLineItms.Supplier AS Supplier,
  min( StRpTPARInvcLineItms.TotalGrossAmountInCoCodeCrcy ) AS TotalGrossAmountInCoCodeCrcy,
  StRpTPARInvcLineItms.AU_TPARServiceType AS AU_TPARServiceType,
  StRpTPARInvcLineItms.AU_TPARGrantName AS AU_TPARGrantName,
  StRpTPARInvcLineItms.ClearingJournalEntry AS ClearingJournalEntry,
  StRpTPARInvcLineItms.PaymentDocument AS PaymentDocument,
  StRpTaxItem.TaxCode AS TaxCode,
  min(StRpTPARInvcLineItms.AU_TPARGrantObject ) AS AU_TPARGrantObject,
  case when StRpTPARInvcLineItms.AU_TPARServiceType = 'G' then min(StRpTPARInvcLineItms.GLAccount) else ' ' end as GLAccount AS GLAccountelseendasGLAccount,
  StRpTaxItem.ReportingCurrency AS ReportingCurrency,
  min(StRpTaxItem.TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  min(StRpTaxItem.TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy
FROM I_AU_StRpTPARInvoiceLineItems
INNER JOIN P_StRpTaxItem AS StRpTaxItem ON /* join condition not captured in parsed metadata */
;

Learn More