P_TH_STRPDEFERTAXPAYMENT

CDS View
81 Fields 1 CDS Views

Enable for PP36 deferred tax scenario

P_TH_STRPDEFERTAXPAYMENT is a CDS View in S/4HANA. Enable for PP36 deferred tax scenario. It contains 81 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_TH_StRpTaxPaymentReturn view union_all COMPOSITE For Thailand PP36 Tax Return Report

Fields (81)

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

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.

-- Enable for PP36 deferred tax scenario
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_TH_STRPDEFERTAXPAYMENT (
    ACCOUNTINGDOCUMENT,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    _TAXTYPETEXT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ADDRESSID,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    CITYNAME,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDOCFISCALYEAR,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRY,
    COUNTRYCURRENCY,
    CUSTOMERSUPPLIERADDRESS,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LOWESTLEVELTAXJURISDICTION,
    PAYMENTDATE,
    PAYMENTNOTE,
    POSTALCODE,
    POSTINGDATE,
    REGION,
    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, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION)
);

Learn More