P_TH_StRpRemit_ADDR2_O

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_TH_StRpRemit_ADDR2_O.
-- 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: PTHREMIT_O
-- Parameters: P_Language : sylangu, P_RelevantAmountPosition : relevantamountposition, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW P_TH_StRpRemit_ADDR2_O AS
SELECT
  P_TH_StRpTaxPaymentReturn.CompanyCode AS CompanyCode,
  P_TH_StRpTaxPaymentReturn.AccountingDocument AS AccountingDocument,
  P_TH_StRpTaxPaymentReturn.FiscalYear AS FiscalYear,
  P_TH_StRpTaxPaymentReturn.TaxItem AS TaxItem,
  P_TH_StRpTaxPaymentReturn.TaxCode AS TaxCode,
  P_TH_StRpTaxPaymentReturn.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_TH_StRpTaxPaymentReturn.TaxBox AS TaxBox,
  P_TH_StRpTaxPaymentReturn.TaxDeclnAmountType AS TaxDeclnAmountType,
  P_TH_StRpTaxPaymentReturn.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  P_TH_StRpTaxPaymentReturn.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  P_TH_StRpTaxPaymentReturn.TaxBoxStructureType AS TaxBoxStructureType,
  P_TH_StRpTaxPaymentReturn.TaxGroup AS TaxGroup,
  P_TH_StRpTaxPaymentReturn.AddressID AS AddressID,
  P_TH_StRpTaxPaymentReturn.Supplier AS Supplier,
  'S' AS AddressRepresentationCode,
  P_TH_StRpTaxPaymentReturn.TaxBoxStructure AS TaxBoxStructure,
  P_TH_StRpTaxPaymentReturn.TaxCalculationProcedure AS TaxCalculationProcedure,
  P_TH_StRpTaxPaymentReturn.ReportingDate AS ReportingDate,
  P_TH_StRpTaxPaymentReturn.PostingDate AS PostingDate,
  P_TH_StRpTaxPaymentReturn.DocumentDate AS DocumentDate,
  P_TH_StRpTaxPaymentReturn.TaxReportingDate AS TaxReportingDate,
  P_TH_StRpTaxPaymentReturn.FiscalPeriod AS FiscalPeriod,
  P_TH_StRpTaxPaymentReturn.TaxItemGroup AS TaxItemGroup,
  P_TH_StRpTaxPaymentReturn.AccountingDocumentType AS AccountingDocumentType,
  P_TH_StRpTaxPaymentReturn.PaymentNote AS PaymentNote,
  P_TH_StRpTaxPaymentReturn.ClearingJournalEntry AS ClearingJournalEntry,
  P_TH_StRpTaxPaymentReturn.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_TH_StRpTaxPaymentReturn.PaymentDate AS PaymentDate,
  P_TH_StRpTaxPaymentReturn.SupplierPaytCurrencyExchRate AS SupplierPaytCurrencyExchRate,
  P_TH_StRpTaxPaymentReturn.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  P_TH_StRpTaxPaymentReturn.DocumentReferenceID AS DocumentReferenceID,
  P_TH_StRpTaxPaymentReturn.CompanyCodeCountry AS CompanyCodeCountry,
  P_TH_StRpTaxPaymentReturn.ReportingCountry AS ReportingCountry,
  P_TH_StRpTaxPaymentReturn.BusinessPartnerCountry AS BusinessPartnerCountry,
  P_TH_StRpTaxPaymentReturn.TaxRate AS TaxRate,
  P_TH_StRpTaxPaymentReturn.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  P_TH_StRpTaxPaymentReturn.IsReversal AS IsReversal,
  P_TH_StRpTaxPaymentReturn.IsReversed AS IsReversed,
  P_TH_StRpTaxPaymentReturn.GLAccount AS GLAccount,
  P_TH_StRpTaxPaymentReturn.BusinessPlace AS BusinessPlace,
  P_TH_StRpTaxPaymentReturn.TaxJurisdiction AS TaxJurisdiction,
  P_TH_StRpTaxPaymentReturn.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  P_TH_StRpTaxPaymentReturn.TaxNumber1 AS TaxNumber1,
  P_TH_StRpTaxPaymentReturn.TaxNumber2 AS TaxNumber2,
  P_TH_StRpTaxPaymentReturn.TaxNumber3 AS TaxNumber3,
  P_TH_StRpTaxPaymentReturn.BusinessPartner AS BusinessPartner,
  P_TH_StRpTaxPaymentReturn.TaxPayerName AS TaxPayerName,
  P_TH_StRpTaxPaymentReturn.CustomerSupplierAddress AS CustomerSupplierAddress,
  '' AS Building,
  '' AS RoomNumber,
  '' AS Floor,
  '' AS StreetSuffixName,
  '' AS HouseNumber,
  '' AS StreetPrefixName,
  '' AS AdditionalStreetPrefixName,
  P_TH_StRpTaxPaymentReturn.StreetName AS StreetName,
  '' AS HomeCityName,
  '' AS District,
  case when P_TH_StRpTaxPaymentReturn.CityName is not null then P_TH_StRpTaxPaymentReturn.CityName else case when P_TH_StRpTaxPaymentReturn.Region is not null then case $parameters.P_Language when 'T' then THRegionText.RegionName else RegionText.RegionName end else '' end end as CityName AS RegionNameendelseendendasCityName,
  P_TH_StRpTaxPaymentReturn.PostalCode AS PostalCode,
  '' AS PhoneNumber,
  P_TH_StRpTaxPaymentReturn.Country AS Country,
  case $parameters.P_Language when 'I' then CountryText.CountryName else THCountryText.CountryName end as CountryName AS CountryNameendasCountryName,
  P_TH_StRpTaxPaymentReturn.TaxType AS TaxType,
  P_TH_StRpTaxPaymentReturn.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_TH_StRpTaxPaymentReturn.CountryCurrency AS CountryCurrency,
  P_TH_StRpTaxPaymentReturn.DocumentCurrency AS DocumentCurrency,
  P_TH_StRpTaxPaymentReturn.ReportingCurrency AS ReportingCurrency,
  P_TH_StRpTaxPaymentReturn.AdditionalCurrency1 AS AdditionalCurrency1,
  P_TH_StRpTaxPaymentReturn.AdditionalCurrency2 AS AdditionalCurrency2,
  P_TH_StRpTaxPaymentReturn.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_TH_StRpTaxPaymentReturn.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_TH_StRpTaxPaymentReturn.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_TH_StRpTaxPaymentReturn.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_TH_StRpTaxPaymentReturn.TaxAmount AS TaxAmount,
  P_TH_StRpTaxPaymentReturn.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  P_TH_StRpTaxPaymentReturn.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  P_TH_StRpTaxPaymentReturn.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  P_TH_StRpTaxPaymentReturn.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  P_TH_StRpTaxPaymentReturn.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  P_TH_StRpTaxPaymentReturn.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  P_TH_StRpTaxPaymentReturn.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  P_TH_StRpTaxPaymentReturn.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  P_TH_StRpTaxPaymentReturn.TaxIsNotDeductible AS TaxIsNotDeductible,
  P_TH_StRpTaxPaymentReturn._TaxTypeText AS _TaxTypeText
FROM P_TH_StRpTaxPaymentReturn
;