I_AU_StRpTPARInvoiceLineItems

DDL: I_AU_STRPTPARINVOICELINEITEMS SQL: IAUTPARINVCLI Type: view COMPOSITE
12 Fields 6 Data Sources

Australia TPAR Invoice Line Items

I_AU_StRpTPARInvoiceLineItems is a Composite CDS View that provides data about "Australia TPAR Invoice Line Items" in SAP S/4HANA. It reads from 6 data sources and exposes 12 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (6)

SourceAliasJoin Type
I_JournalEntryItemCube JournalEntryItemCube inner
I_Ledger Ledger inner
I_OperationalAcctgDocItem OperationalAcctgDocItem inner
P_AU_StRpTPARSuplrAcctgDocItm P_AU_StRpTPARSuplrAcctgDocItm from
P_AU_StrpTPARServiceType StRpTPARServiceType inner
I_Supplier Supplier inner

Parameters (2)

NameTypeDefault
P_FromReportingDate figen_rep_date_from
P_ToReportingDate figen_rep_date_to

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IAUTPARINVCLI 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
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Australia TPAR Invoice Line Items view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode StRpTPARSuplrAcctgDocItm CompanyCode Receiver Company Code
KEY AccountingDocument StRpTPARSuplrAcctgDocItm AccountingDocument Journal Entry
KEY FiscalYear StRpTPARSuplrAcctgDocItm FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
GLAccount I_JournalEntryItemCube GLAccount General Ledger
Supplier StRpTPARSuplrAcctgDocItm Supplier Supplier
ReportingDate StRpTPARSuplrAcctgDocItm ReportingDate
TotalGrossAmountInCoCodeCrcy StRpTPARSuplrAcctgDocItm TotalGrossAmountInCoCodeCrcy Amount in LC
AU_TPARServiceType P_AU_StrpTPARServiceType AU_TPARServiceType Service Type
AU_TPARGrantName P_AU_StrpTPARServiceType AU_TPARGrantName
ClearingJournalEntry StRpTPARSuplrAcctgDocItm ClearingJournalEntry Clrng doc.
PaymentDocument StRpTPARSuplrAcctgDocItm PaymentDocument Payment Document Number

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

CREATE VIEW I_AU_StRpTPARInvoiceLineItems AS
SELECT
  StRpTPARSuplrAcctgDocItm.CompanyCode AS CompanyCode,
  StRpTPARSuplrAcctgDocItm.AccountingDocument AS AccountingDocument,
  StRpTPARSuplrAcctgDocItm.FiscalYear AS FiscalYear,
  OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItemCube.GLAccount AS GLAccount,
  StRpTPARSuplrAcctgDocItm.Supplier AS Supplier,
  StRpTPARSuplrAcctgDocItm.ReportingDate AS ReportingDate,
  StRpTPARSuplrAcctgDocItm.TotalGrossAmountInCoCodeCrcy AS TotalGrossAmountInCoCodeCrcy,
  StRpTPARServiceType.AU_TPARServiceType AS AU_TPARServiceType,
  StRpTPARServiceType.AU_TPARGrantName AS AU_TPARGrantName,
  StRpTPARSuplrAcctgDocItm.ClearingJournalEntry AS ClearingJournalEntry,
  StRpTPARSuplrAcctgDocItm.PaymentDocument AS PaymentDocument
FROM P_AU_StRpTPARSuplrAcctgDocItm
INNER JOIN I_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS OperationalAcctgDocItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemCube AS JournalEntryItemCube ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger AS Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN P_AU_StrpTPARServiceType AS StRpTPARServiceType ON /* join condition not captured in parsed metadata */
;

Learn More