P_TH_STRPTAXPAYMENTRETURN

CDS View
73 Fields 4 CDS Views

For Thailand PP36 Tax Return Report

P_TH_STRPTAXPAYMENTRETURN is a CDS View in S/4HANA. For Thailand PP36 Tax Return Report. It contains 73 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_TH_SPLITFILE2 view from COMPOSITE SPLIT FIle
P_TH_StRpRemit_ADDR2_D view from COMPOSITE Thailand PP36 Tax item with default address
P_TH_StRpRemit_ADDR2_O view from COMPOSITE Thailand PP36 Tax item with one-time address
P_TH_StRpRemit_ADDR2_T view from COMPOSITE Thailand PP36 Tax item with Thailand address

Fields (73)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AddressID AddressID 3
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 3
KEY TaxBox TaxBox 3
KEY TaxBoxStructureType TaxBoxStructureType 3
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 3
KEY TaxCode TaxCode 3
KEY TaxDeclnAmountType TaxDeclnAmountType 3
KEY TaxGroup TaxGroup 3
KEY TaxItem TaxItem 3
KEY TaxItemGroupingVersion TaxItemGroupingVersion 3
KEY TransactionTypeDetermination TransactionTypeDetermination 3
_TaxTypeText _TaxTypeText 3
AccountingDocumentHeaderText AccountingDocumentHeaderText 3
AccountingDocumentType AccountingDocumentType 3
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency2 AdditionalCurrency2 3
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 3
AmountInTransactionCurrency AmountInTransactionCurrency 3
BusinessPartner BusinessPartner 3
BusinessPartnerCountry BusinessPartnerCountry 3
BusinessPartnerName BusinessPartnerName 2
BusinessPlace BusinessPlace 3
ClearingJournalEntry ClearingJournalEntry 3
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 3
CompanyCodeCountry CompanyCodeCountry 3
CompanyCodeCurrency CompanyCodeCurrency 3
Country Country 3
CountryCurrency CountryCurrency 3
CustomerSupplierAddress CustomerSupplierAddress 3
DocumentCurrency DocumentCurrency 3
DocumentDate DocumentDate 3
DocumentReferenceID DocumentReferenceID 3
FiscalPeriod FiscalPeriod 3
GLAccount GLAccount 3
IsReversal IsReversal 3
IsReversed IsReversed 3
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 3
PaymentDate PaymentDate 3
PaymentNote PaymentNote 3
PostalCode PostalCode 1
PostingDate PostingDate 3
ReportingCountry ReportingCountry 3
ReportingCurrency ReportingCurrency 3
ReportingDate ReportingDate 3
StreetName StreetName 1
Supplier Supplier 3
SupplierPaytCurrencyExchRate SupplierPaytCurrencyExchRate 3
TaxAmount TaxAmount 3
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 3
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 3
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 3
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 3
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 3
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 3
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 3
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 3
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 3
TaxBoxStructure TaxBoxStructure 3
TaxCalculationProcedure TaxCalculationProcedure 3
TaxIsNotDeductible TaxIsNotDeductible 3
TaxItemGroup TaxItemGroup 3
TaxJurisdiction TaxJurisdiction 3
TaxNumber1 TaxNumber1 3
TaxNumber2 TaxNumber2 3
TaxNumber3 TaxNumber3 3
TaxPayerName TaxPayerName 1
TaxRate TaxRate 3
TaxRateValidityStartDate TaxRateValidityStartDate 3
TaxReportingDate TaxReportingDate 3
TaxType TaxType 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- For Thailand PP36 Tax Return Report
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_TH_STRPTAXPAYMENTRETURN (
    ACCOUNTINGDOCUMENT,
    ADDRESSID,
    COMPANYCODE,
    FISCALYEAR,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    _TAXTYPETEXT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRY,
    COUNTRYCURRENCY,
    CUSTOMERSUPPLIERADDRESS,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LOWESTLEVELTAXJURISDICTION,
    PAYMENTDATE,
    PAYMENTNOTE,
    POSTALCODE,
    POSTINGDATE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    STREETNAME,
    SUPPLIER,
    SUPPLIERPAYTCURRENCYEXCHRATE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXBOXSTRUCTURE,
    TAXCALCULATIONPROCEDURE,
    TAXISNOTDEDUCTIBLE,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXPAYERNAME,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ADDRESSID, COMPANYCODE, FISCALYEAR, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION)
);

Learn More