What is P_TH_StRpRemit_ADDR2_D in SAP S/4HANA?

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

Which tables does P_TH_StRpRemit_ADDR2_D read from?

P_TH_StRpRemit_ADDR2_D reads data from: P_TH_StRpTaxPaymentReturn.

What VDM layer is P_TH_StRpRemit_ADDR2_D?

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

P_TH_StRpRemit_ADDR2_D

DDL: P_TH_STRPREMIT_ADDR2_D SQL: PTHREMIT_D Type: view COMPOSITE Package: GLO_FIN_IS_VAT_TH

88 Fields 1 Data Sources

Thailand PP36 Tax item with default address

P_TH_StRpRemit_ADDR2_D is a Composite CDS View that provides data about "Thailand PP36 Tax item with default 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 (5)

Name	Type	Default
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_D	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
	AddressRepresentationCode	Address	AddressRepresentationCode	Address Version
	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	Address	OrganizationName1	Name
	OrganizationName2	Address	OrganizationName2	Name 2
	OrganizationName3	Address	OrganizationName3	Name 3
	OrganizationName4	Address	OrganizationName4	Name 4
	OrganizationName411asTaxPayerName
	BusinessPartnerName	P_TH_StRpTaxPaymentReturn	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	P_TH_StRpTaxPaymentReturn	CustomerSupplierAddress
	Building	Address	Building	Building code
	RoomNumber	Address	RoomNumber	Room Number
	Floor	Address	Floor	Floor
	StreetSuffixName	Address	StreetSuffixName	Street 4
	HouseNumber	Address	HouseNumber	House Number
	StreetPrefixName	Address	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	Address	AdditionalStreetPrefixName	Street 3
	StreetName	Address	StreetName	Text
	HomeCityName	Address	HomeCityName	Different City
	District	Address	District	District Court
	CityName	Address	CityName	Name
	PostalCode	Address	PostalCode	Postal Code
	Country	P_TH_StRpTaxPaymentReturn	Country	Venue: Ctry/Reg
	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_D.
-- 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_D
-- Parameters: 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_D 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,
  Address.AddressRepresentationCode 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,
  Address.OrganizationName1 AS OrganizationName1,
  Address.OrganizationName2 AS OrganizationName2,
  Address.OrganizationName3 AS OrganizationName3,
  Address.OrganizationName4 AS OrganizationName4,
  concat_with_space(concat_with_space(Address.OrganizationName1,Address.OrganizationName2, 1), concat_with_space(Address.OrganizationName3,Address.OrganizationName4, 1), 1) as TaxPayerName AS OrganizationName411asTaxPayerName,
  P_TH_StRpTaxPaymentReturn.BusinessPartnerName AS BusinessPartnerName,
  P_TH_StRpTaxPaymentReturn.CustomerSupplierAddress AS CustomerSupplierAddress,
  Address.Building AS Building,
  Address.RoomNumber AS RoomNumber,
  Address.Floor AS Floor,
  Address.StreetSuffixName AS StreetSuffixName,
  Address.HouseNumber AS HouseNumber,
  Address.StreetPrefixName AS StreetPrefixName,
  Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  Address.StreetName AS StreetName,
  Address.HomeCityName AS HomeCityName,
  Address.District AS District,
  Address.CityName AS CityName,
  Address.PostalCode AS PostalCode,
  P_TH_StRpTaxPaymentReturn.Country AS Country,
  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_D view

P_TH_StRpTaxPaymentReturn view

P_TH_StRpRemit_ADDR2_DT view