I_AU_StRpTPARSupplierAmountLog

DDL: I_AU_STRPTPARSUPPLIERAMOUNTLOG SQL: IAUSRTPARSUPLRAL Type: view BASIC Package: GLO_FIN_IS_AU
12 Fields 1 Data Sources

Australia TPAR Supplier Amount Log

I_AU_StRpTPARSupplierAmountLog is a Basic CDS View that provides data about "Australia TPAR Supplier Amount Log" in SAP S/4HANA. It reads from 1 data source (fiau_sup_amt_log) and exposes 12 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, Supplier. Part of development package GLO_FIN_IS_AU.

Data Sources (1)

SourceAliasJoin Type
fiau_sup_amt_log StRpTPARSplrAmtLog from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IAUSRTPARSUPLRAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Australia TPAR Supplier Amount Log view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity statryrptgentity Reporting Entity
KEY StatryRptCategory statryrptcategory Report ID
KEY StatryRptRunID statryrptrunid Report Run ID
KEY CompanyCode fiau_sup_amt_log companycode Receiver Company Code
KEY Supplier supplier Supplier
KEY AU_TPARServiceType fiau_sup_amt_log au_tparservicetype Service Type
KEY GLAccount glaccount General Ledger
KEY AU_TPARGrantObject au_tpargrantobject TPAR Grant Obj
AU_TPARGrantDate au_tpargrantdate Grant Date
TotalGrossAmountInCoCodeCrcy totalgrossamountincocodecrcy Amount in LC
TotalVATAmtInCoCodeCrcy totalvatamtincocodecrcy LC Tax
ReportingCurrency 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 I_AU_StRpTPARSupplierAmountLog.
-- 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: IAUSRTPARSUPLRAL

CREATE VIEW I_AU_StRpTPARSupplierAmountLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  StRpTPARSplrAmtLog.companycode AS CompanyCode,
  Supplier,
  StRpTPARSplrAmtLog.au_tparservicetype AS AU_TPARServiceType,
  GLAccount,
  AU_TPARGrantObject,
  AU_TPARGrantDate,
  TotalGrossAmountInCoCodeCrcy,
  TotalVATAmtInCoCodeCrcy,
  ReportingCurrency
FROM fiau_sup_amt_log AS StRpTPARSplrAmtLog
;

Learn More