P_AU_StRpTPARCrrtnPhseSuplrDet

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_StRpTPARCrrtnPhseSuplrDet.
-- 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: PAUSRTPARCRTNPSD
-- Parameters: P_StatryRptStdRunID : srf_report_run_id, P_StatryRptCrtnRunID : srf_report_run_id

CREATE VIEW P_AU_StRpTPARCrrtnPhseSuplrDet AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptCrtnRunID AS StatryRptRunID,
  StRpTPARCrrtnPhseSuplrLog.Supplier AS Supplier,
  StRpTPARCrrtnPhseSuplrLog.AU_TPARServiceType AS AU_TPARServiceType,
  StRpTPARCrrtnPhseSuplrLog.AU_TPARGrantName AS AU_TPARGrantName,
  TotalGrossAmountInCoCodeCrcy,
  TotalVATAmtInCoCodeCrcy,
  ReportingCurrency,
  lpad( cast(ceil(floor(TotalGrossAmountInCoCodeCrcy)) as abap.sstring(11) ), 11 , '0') AS TotalGrossAmtWithLeadingZeros,
  lpad( cast(ceil(floor(TotalVATAmtInCoCodeCrcy)) as abap.sstring(11) ), 11 , '0') AS TotalTaxAmtWithLeadingZeros,
  AU_TPARGrantDate,
  case when _Supplier.VATRegistration is initial then '0' else _Supplier.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  case when _Supplier._AddressDefaultRepresentation.POBox is not initial then _Supplier._AddressDefaultRepresentation.POBox else _Supplier.StreetName end as StreetName AS StreetNameendasStreetName,
  case when _Supplier._AddressDefaultRepresentation.POBox is not initial then _Supplier._AddressDefaultRepresentation.POBoxDeviatingCityName else _Supplier.CityName end as CityName AS CityNameendasCityName,
  case when _Supplier.Country = 'AU' then _Supplier.Region else 'OTH' end as Region AS RegionelseOTHendasRegion,
  case when _Supplier.Country = 'AU' then case when _Supplier._AddressDefaultRepresentation.POBox is not initial then _Supplier._AddressDefaultRepresentation.POBoxPostalCode else _Supplier.PostalCode end else '9999' end as PostalCode AS PostalCodeendelse9999endasPostalCode,
  _Supplier.PhoneNumber1 AS PhoneNumber1,
  _SupplierBankDetails.Bank AS Bank,
  _SupplierBankDetails.BankAccount AS BankAccount,
  _Supplier._CurrentDfltEmailAddress.EmailAddress AS BusinessPartnerEmailAddress,
  AmendmentIndicator,
  1 AS NumberOfRecords
FROM P_AU_StRpTPARCrrtnPhseSuplrLog
INNER JOIN I_Supplier AS _Supplier ON /* join condition not captured in parsed metadata */
;