What is P_TH_StRpRemit_ADDR2_T in SAP S/4HANA?

P_TH_StRpRemit_ADDR2_T is a composite CDS view in SAP S/4HANA. Thailand PP36 Tax item with Thailand address It contains 88 fields.

Which tables does P_TH_StRpRemit_ADDR2_T read from?

P_TH_StRpRemit_ADDR2_T reads data from: P_TH_StRpTaxPaymentReturn.

What VDM layer is P_TH_StRpRemit_ADDR2_T?

P_TH_StRpRemit_ADDR2_T is classified as a Composite view that combines data from multiple basic views.

P_TH_StRpRemit_ADDR2_T

DDL: P_TH_STRPREMIT_ADDR2_T SQL: PTHREMIT_T Type: view COMPOSITE Package: GLO_FIN_IS_VAT_TH

88 Fields 1 Data Sources

Thailand PP36 Tax item with Thailand address

P_TH_StRpRemit_ADDR2_T is a Composite CDS View that provides data about "Thailand PP36 Tax item with Thailand address" in SAP S/4HANA. It reads from 1 data source (P_TH_StRpTaxPaymentReturn) and exposes 88 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode. Part of development package GLO_FIN_IS_VAT_TH.

Data Sources (1)

Source	Alias	Join Type
P_TH_StRpTaxPaymentReturn	P_TH_StRpTaxPaymentReturn	from

Parameters (6)

Name	Type	Default
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

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PTHREMIT_T	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view

Fields (88)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_TH_StRpTaxPaymentReturn	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_TH_StRpTaxPaymentReturn	AccountingDocument	Journal Entry
KEY	FiscalYear	P_TH_StRpTaxPaymentReturn	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_TH_StRpTaxPaymentReturn	TaxItem	Tax Item
KEY	TaxCode	P_TH_StRpTaxPaymentReturn	TaxCode	Tax Code
KEY	TransactionTypeDetermination	P_TH_StRpTaxPaymentReturn	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	P_TH_StRpTaxPaymentReturn	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	P_TH_StRpTaxPaymentReturn	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	P_TH_StRpTaxPaymentReturn	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TaxBoxStrucValidityStartDate	P_TH_StRpTaxPaymentReturn	TaxBoxStrucValidityStartDate
KEY	TaxBoxStructureType	P_TH_StRpTaxPaymentReturn	TaxBoxStructureType
KEY	TaxGroup	P_TH_StRpTaxPaymentReturn	TaxGroup	Tax Group
KEY	AddressID	P_TH_StRpTaxPaymentReturn	AddressID	Ship-to address
	Supplier	P_TH_StRpTaxPaymentReturn	Supplier	Supplier
	TaxBoxStructure	P_TH_StRpTaxPaymentReturn	TaxBoxStructure
	TaxCalculationProcedure	P_TH_StRpTaxPaymentReturn	TaxCalculationProcedure	Tax Procedure
	ReportingDate	P_TH_StRpTaxPaymentReturn	ReportingDate
	PostingDate	P_TH_StRpTaxPaymentReturn	PostingDate	Posting Date for GR
	DocumentDate	P_TH_StRpTaxPaymentReturn	DocumentDate	Journal Entry Date
	TaxReportingDate	P_TH_StRpTaxPaymentReturn	TaxReportingDate	Tax Reporting Date
	FiscalPeriod	P_TH_StRpTaxPaymentReturn	FiscalPeriod	Tax period
	TaxItemGroup	P_TH_StRpTaxPaymentReturn	TaxItemGroup	Tax doc. item number
	AccountingDocumentType	P_TH_StRpTaxPaymentReturn	AccountingDocumentType	Journal Entry Type
	PaymentNote	P_TH_StRpTaxPaymentReturn	PaymentNote	Text
	ClearingJournalEntry	P_TH_StRpTaxPaymentReturn	ClearingJournalEntry	Clrng doc.
	ClearingJournalEntryFiscalYear	P_TH_StRpTaxPaymentReturn	ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	PaymentDate	P_TH_StRpTaxPaymentReturn	PaymentDate	Payment Date
	SupplierPaytCurrencyExchRate	P_TH_StRpTaxPaymentReturn	SupplierPaytCurrencyExchRate	Supp. Payt Currency Exch. Rate
	AccountingDocumentHeaderText	P_TH_StRpTaxPaymentReturn	AccountingDocumentHeaderText	Doc.Header Text
	DocumentReferenceID	P_TH_StRpTaxPaymentReturn	DocumentReferenceID	Reference
	CompanyCodeCountry	P_TH_StRpTaxPaymentReturn	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	P_TH_StRpTaxPaymentReturn	ReportingCountry
	BusinessPartnerCountry	P_TH_StRpTaxPaymentReturn	BusinessPartnerCountry	BP Ctry/Reg.
	TaxRate	P_TH_StRpTaxPaymentReturn	TaxRate	Tax Rate
	TaxRateValidityStartDate	P_TH_StRpTaxPaymentReturn	TaxRateValidityStartDate	Tax Rate Validity Start Date
	IsReversal	P_TH_StRpTaxPaymentReturn	IsReversal	Reversal doc.
	IsReversed	P_TH_StRpTaxPaymentReturn	IsReversed	Reversed?
	GLAccount	P_TH_StRpTaxPaymentReturn	GLAccount	General Ledger
	BusinessPlace	P_TH_StRpTaxPaymentReturn	BusinessPlace	Business place
	TaxJurisdiction	P_TH_StRpTaxPaymentReturn	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	P_TH_StRpTaxPaymentReturn	LowestLevelTaxJurisdiction	Jurisdict. Code
	TaxNumber1	P_TH_StRpTaxPaymentReturn	TaxNumber1	VAT Reg. No.
	TaxNumber2	P_TH_StRpTaxPaymentReturn	TaxNumber2	Tax Number 2
	TaxNumber3	P_TH_StRpTaxPaymentReturn	TaxNumber3
	BusinessPartner	P_TH_StRpTaxPaymentReturn	BusinessPartner	Issuing Authority
	OrganizationName1	TH_Address	OrganizationName1	Name
	OrganizationName2	TH_Address	OrganizationName2	Name 2
	OrganizationName3	TH_Address	OrganizationName3	Name 3
	OrganizationName4	TH_Address	OrganizationName4	Name 4
	OrganizationName411asTaxPayerName
	BusinessPartnerName	P_TH_StRpTaxPaymentReturn	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	P_TH_StRpTaxPaymentReturn	CustomerSupplierAddress
	Building	TH_Address	Building	Building code
	RoomNumber	TH_Address	RoomNumber	Room Number
	Floor	TH_Address	Floor	Floor
	StreetSuffixName	TH_Address	StreetSuffixName	Street 4
	HouseNumber	TH_Address	HouseNumber	House Number
	StreetPrefixName	TH_Address	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	TH_Address	AdditionalStreetPrefixName	Street 3
	StreetName	TH_Address	StreetName	Text
	HomeCityName	TH_Address	HomeCityName	Different City
	District	TH_Address	District	District Court
	CityName	TH_Address	CityName	Name
	PostalCode	TH_Address	PostalCode	Postal Code
	Country	P_TH_StRpTaxPaymentReturn	Country	Venue: Ctry/Reg
	CountryNameendasCountryName
	TaxType	P_TH_StRpTaxPaymentReturn	TaxType	Tax Type
	CompanyCodeCurrency	P_TH_StRpTaxPaymentReturn	CompanyCodeCurrency	Local Currency
	CountryCurrency	P_TH_StRpTaxPaymentReturn	CountryCurrency	Currency
	DocumentCurrency	P_TH_StRpTaxPaymentReturn	DocumentCurrency	Document Currency
	ReportingCurrency	P_TH_StRpTaxPaymentReturn	ReportingCurrency	Currency
	AdditionalCurrency1	P_TH_StRpTaxPaymentReturn	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	P_TH_StRpTaxPaymentReturn	AdditionalCurrency2	Local curr. 3
	AmountInTransactionCurrency	P_TH_StRpTaxPaymentReturn	AmountInTransactionCurrency	Pt Crcy Amt
	TaxBaseAmountInCoCodeCrcy	P_TH_StRpTaxPaymentReturn	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_TH_StRpTaxPaymentReturn	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	P_TH_StRpTaxPaymentReturn	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	P_TH_StRpTaxPaymentReturn	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInRptgCrcy	P_TH_StRpTaxPaymentReturn	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	P_TH_StRpTaxPaymentReturn	TaxAmountInRptgCrcy	Tax Rept. Crcy
	AmountInAdditionalCurrency1	P_TH_StRpTaxPaymentReturn	AmountInAdditionalCurrency1	Amount in Additional Currency 1
	AmountInAdditionalCurrency2	P_TH_StRpTaxPaymentReturn	AmountInAdditionalCurrency2	LC2 Amount
	TaxBaseAmtInAdditionalCrcy1	P_TH_StRpTaxPaymentReturn	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2	P_TH_StRpTaxPaymentReturn	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1	P_TH_StRpTaxPaymentReturn	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2	P_TH_StRpTaxPaymentReturn	TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxIsNotDeductible	P_TH_StRpTaxPaymentReturn	TaxIsNotDeductible	Non-Deductible
	_TaxTypeText	P_TH_StRpTaxPaymentReturn	_TaxTypeText

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_T.
-- 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_T
-- 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_T 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,
  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,
  TH_Address.OrganizationName1 AS OrganizationName1,
  TH_Address.OrganizationName2 AS OrganizationName2,
  TH_Address.OrganizationName3 AS OrganizationName3,
  TH_Address.OrganizationName4 AS OrganizationName4,
  concat_with_space(concat_with_space(TH_Address.OrganizationName1,TH_Address.OrganizationName2, 1), concat_with_space(TH_Address.OrganizationName3,TH_Address.OrganizationName4, 1), 1) as TaxPayerName AS OrganizationName411asTaxPayerName,
  P_TH_StRpTaxPaymentReturn.BusinessPartnerName AS BusinessPartnerName,
  P_TH_StRpTaxPaymentReturn.CustomerSupplierAddress AS CustomerSupplierAddress,
  TH_Address.Building AS Building,
  TH_Address.RoomNumber AS RoomNumber,
  TH_Address.Floor AS Floor,
  TH_Address.StreetSuffixName AS StreetSuffixName,
  TH_Address.HouseNumber AS HouseNumber,
  TH_Address.StreetPrefixName AS StreetPrefixName,
  TH_Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  TH_Address.StreetName AS StreetName,
  TH_Address.HomeCityName AS HomeCityName,
  TH_Address.District AS District,
  TH_Address.CityName AS CityName,
  TH_Address.PostalCode AS PostalCode,
  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
;

Depth:

P_TH_StRpRemit_ADDR2_T view

P_TH_StRpTaxPaymentReturn view

P_TH_StRpRemit_ADDR_ALL view_entity