What is C_TH_StRpRemittanceTaxItmQuery in SAP S/4HANA?

C_TH_StRpRemittanceTaxItmQuery is a consumption CDS view in SAP S/4HANA. Remittance Tax Item Statutory Reporting for Thailand(P.P.36) It contains 75 fields.

Which tables does C_TH_StRpRemittanceTaxItmQuery read from?

C_TH_StRpRemittanceTaxItmQuery reads data from: I_TH_StRpRemittanceTaxItemCube.

What VDM layer is C_TH_StRpRemittanceTaxItmQuery?

C_TH_StRpRemittanceTaxItmQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_TH_StRpRemittanceTaxItmQuery

DDL: C_TH_STRPREMITTANCETAXITMQUERY SQL: CTHREMITTXITMQ Type: view CONSUMPTION

75 Fields 1 Data Sources

Remittance Tax Item Statutory Reporting for Thailand(P.P.36)

C_TH_StRpRemittanceTaxItmQuery is a Consumption CDS View that provides data about "Remittance Tax Item Statutory Reporting for Thailand(P.P.36)" in SAP S/4HANA. It reads from 1 data source (I_TH_StRpRemittanceTaxItemCube) and exposes 75 fields with key fields CompanyCode, AccountingDocument, FiscalYear, StatryRptgEntity, StatryRptCategory.

Data Sources (1)

Source	Alias	Join Type
I_TH_StRpRemittanceTaxItemCube	I_TH_StRpRemittanceTaxItemCube	from

Parameters (1)

Name	Type	Default
P_Language	sylangu

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CTHREMITTXITMQ	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
Analytics.query	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Remittance Tax Item Statutory Reporting for Thailand(P.P.36)	view

Fields (75)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	StatryRptgEntity	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	StatryRptCategory	Report ID
KEY	StatryRptRunID	StatryRptRunID	Report Run ID
KEY	TaxCode	TaxCode	Tax Code
KEY	TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	TaxItemGroupingVersion	Tax Grping Ver.
KEY	ValidFrom	ValidFrom	Vers.Valid From
KEY	TaxBoxStructureType	TaxBoxStructureType
KEY	TaxGroup	TaxGroup	Tax Group
	TaxCalculationProcedure	TaxCalculationProcedure	Tax Procedure
	ReportingDate	ReportingDate
	PostingDate	PostingDate	Posting Date for GR
	DocumentDate	DocumentDate	Journal Entry Date
	TaxReportingDate	TaxReportingDate	Tax Reporting Date
	FiscalPeriod	FiscalPeriod	Tax period
	TaxItemGroup	TaxItemGroup	Tax doc. item number
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	ClearingDocFiscalYear	ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry
	ClearingAccountingDocument	ClearingAccountingDocument	Clearing Journal Entry
	ClearingJournalEntryFiscalYear	ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	ClearingJournalEntry	ClearingJournalEntry	Clrng doc.
	SupplierPaytCurrencyExchRate	SupplierPaytCurrencyExchRate	Supp. Payt Currency Exch. Rate
	AccountingDocumentHeaderText	AccountingDocumentHeaderText	Doc.Header Text
	PaymentNote	PaymentNote
	DocumentReferenceID	DocumentReferenceID	Reference
	CompanyCodeCountry	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	ReportingCountry
	TaxRate	TaxRate	Tax Rate
	IsReversal	IsReversal	Reversal doc.
	IsReversed	IsReversed	Reversed?
	GLAccount	GLAccount	General Ledger
	BusinessPlace	BusinessPlace	Business place
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	LowestLevelTaxJurisdiction	Jurisdict. Code
	TaxNumber1	TaxNumber1	VAT Reg. No.
	TaxNumber2	TaxNumber2	Tax Number 2
	TaxNumber3	TaxNumber3
	BusinessPartner	BusinessPartner	Issuing Authority
	BusinessPartnerCountry	BusinessPartnerCountry	BP Ctry/Reg.
	BusinessPartnerName	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	CustomerSupplierAddress
	Building	Building	Building code
	RoomNumber	RoomNumber	Room Number
	Floor	Floor	Floor
	StreetSuffixName	StreetSuffixName	Street 4
	HouseNumber	HouseNumber	House Number
	StreetPrefixName	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	AdditionalStreetPrefixName	Street 3
	StreetName	StreetName	Text
	HomeCityName	HomeCityName	Different City
	District	District	District Court
	CityName	CityName	Name
	PostalCode	PostalCode	Postal Code
	PhoneNumber	PhoneNumber	Telephone no.
	CountryName	CountryName	Country
	TaxType	TaxType	Tax Type
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	CountryCurrency	CountryCurrency	Currency
	DocumentCurrency	DocumentCurrency	Document Currency
	ReportingCurrency	ReportingCurrency	Currency
	AmountInReportingCurrency	AmountInReportingCurrency
	AmountInTransactionCurrency	AmountInTransactionCurrency	Pt Crcy Amt
	TaxBaseAmountInCoCodeCrcy	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInRptgCrcy	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxIsNotDeductible	TaxIsNotDeductible	Non-Deductible
	_TaxTypeText	_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 C_TH_StRpRemittanceTaxItmQuery.
-- 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: CTHREMITTXITMQ
-- Parameters: P_Language : sylangu

CREATE VIEW C_TH_StRpRemittanceTaxItmQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  TaxCalculationProcedure,
  ReportingDate,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  TaxItemGroup,
  AccountingDocumentType,
  ClearingDocFiscalYear,
  ClearingAccountingDocument,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  SupplierPaytCurrencyExchRate,
  AccountingDocumentHeaderText,
  PaymentNote,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxRate,
  IsReversal,
  IsReversed,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerCountry,
  BusinessPartnerName,
  CustomerSupplierAddress,
  Building,
  RoomNumber,
  Floor,
  StreetSuffixName,
  HouseNumber,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetName,
  HomeCityName,
  District,
  CityName,
  PostalCode,
  PhoneNumber,
  CountryName,
  TaxType,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AmountInReportingCurrency,
  AmountInTransactionCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxIsNotDeductible
FROM I_TH_StRpRemittanceTaxItemCube
;

Depth:

C_TH_StRpRemittanceTaxItmQuery view

I_TH_StRpRemittanceTaxItemCube view