P_AU_StRpTPARCrrtnPhseSuplrLog

DDL: P_AU_STRPTPARCRRTNPHSESUPLRLOG SQL: PAUSRTPARCRTNPSL Type: view COMPOSITE Package: GLO_FIN_IS_AU
16 Fields 1 Data Sources

AU TPAR Correction Phase Supplier Log

P_AU_StRpTPARCrrtnPhseSuplrLog is a Composite CDS View that provides data about "AU TPAR Correction Phase Supplier Log" in SAP S/4HANA. It reads from 1 data source (P_AU_StRpTPARAggrgSupplierAmt) and exposes 16 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptCrtnRunID, Supplier, AU_TPARServiceType. Part of development package GLO_FIN_IS_AU.

Data Sources (1)

SourceAliasJoin Type
P_AU_StRpTPARAggrgSupplierAmt StRpTPARAggrgSuplrAmtCrtn from

Parameters (2)

NameTypeDefault
P_StatryRptStdRunID srf_report_run_id
P_StatryRptCrtnRunID srf_report_run_id

Annotations (10)

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_AU_StRpTPARAggrgSupplierAmt StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_AU_StRpTPARAggrgSupplierAmt StatryRptCategory Report ID
KEY StatryRptCrtnRunID P_AU_StRpTPARAggrgSupplierAmt StatryRptRunID Report Run ID
KEY Supplier P_AU_StRpTPARAggrgSupplierAmt Supplier Supplier
KEY AU_TPARServiceType P_AU_StRpTPARAggrgSupplierAmt AU_TPARServiceType Service Type
KEY AU_TPARGrantName P_AU_StRpTPARAggrgSupplierAmt AU_TPARGrantName
AU_TPARGrantDate P_AU_StRpTPARAggrgSupplierAmt AU_TPARGrantDate Grant Date
TotalGrossAmountInCoCodeCrcy P_AU_StRpTPARAggrgSupplierAmt TotalGrossAmountInCoCodeCrcy Amount in LC
TotalVATAmtInCoCodeCrcy P_AU_StRpTPARAggrgSupplierAmt TotalVATAmtInCoCodeCrcy LC Tax
ReportingCurrency P_AU_StRpTPARAggrgSupplierAmt ReportingCurrency Currency
StatryRptStdRunID StRpTPARAggrgSuplrAmtstd StatryRptRunID Report Run ID
StdSupplier StRpTPARAggrgSuplrAmtstd Supplier Supplier
StdServiceType StRpTPARAggrgSuplrAmtstd AU_TPARServiceType Service Type
StdGrantName StRpTPARAggrgSuplrAmtstd AU_TPARGrantName
StdTotalGrossAmtInCoCodeCrcy StRpTPARAggrgSuplrAmtstd TotalGrossAmountInCoCodeCrcy Amount in LC
StdTotalVATAmtInCoCodeCrcy StRpTPARAggrgSuplrAmtstd TotalVATAmtInCoCodeCrcy LC Tax

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_StRpTPARCrrtnPhseSuplrLog.
-- 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: PAUSRTPARCRTNPSL
-- Parameters: P_StatryRptStdRunID : srf_report_run_id, P_StatryRptCrtnRunID : srf_report_run_id

CREATE VIEW P_AU_StRpTPARCrrtnPhseSuplrLog AS
SELECT
  StRpTPARAggrgSuplrAmtCrtn.StatryRptgEntity AS StatryRptgEntity,
  StRpTPARAggrgSuplrAmtCrtn.StatryRptCategory AS StatryRptCategory,
  StRpTPARAggrgSuplrAmtCrtn.StatryRptRunID AS StatryRptCrtnRunID,
  StRpTPARAggrgSuplrAmtCrtn.Supplier AS Supplier,
  StRpTPARAggrgSuplrAmtCrtn.AU_TPARServiceType AS AU_TPARServiceType,
  StRpTPARAggrgSuplrAmtCrtn.AU_TPARGrantName AS AU_TPARGrantName,
  StRpTPARAggrgSuplrAmtCrtn.AU_TPARGrantDate AS AU_TPARGrantDate,
  StRpTPARAggrgSuplrAmtCrtn.TotalGrossAmountInCoCodeCrcy AS TotalGrossAmountInCoCodeCrcy,
  StRpTPARAggrgSuplrAmtCrtn.TotalVATAmtInCoCodeCrcy AS TotalVATAmtInCoCodeCrcy,
  StRpTPARAggrgSuplrAmtCrtn.ReportingCurrency AS ReportingCurrency,
  StRpTPARAggrgSuplrAmtstd.StatryRptRunID AS StatryRptStdRunID,
  StRpTPARAggrgSuplrAmtstd.Supplier AS StdSupplier,
  StRpTPARAggrgSuplrAmtstd.AU_TPARServiceType AS StdServiceType,
  StRpTPARAggrgSuplrAmtstd.AU_TPARGrantName AS StdGrantName,
  StRpTPARAggrgSuplrAmtstd.TotalGrossAmountInCoCodeCrcy AS StdTotalGrossAmtInCoCodeCrcy,
  StRpTPARAggrgSuplrAmtstd.TotalVATAmtInCoCodeCrcy AS StdTotalVATAmtInCoCodeCrcy
FROM P_AU_StRpTPARAggrgSupplierAmt AS StRpTPARAggrgSuplrAmtCrtn
;

Learn More