P_STRPTAXITEM

CDS View
74 Fields 5 CDS Views

Tax Item for Statutory Reporting (Auxiliary View)

P_STRPTAXITEM is a CDS View in S/4HANA. Tax Item for Statutory Reporting (Auxiliary View). It contains 74 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_StRpTaxItem view from COMPOSITE Tax Item view for Statutory Reporting
P_AU_StRpTPARTaxLineItems view inner COMPOSITE Tax Items of TPAR Accounting Docs
P_CO_DIANFrmt1001TaxItem view from CONSUMPTION Format 1001 - VAT Tax Item
P_ID_StRpTaxItemBoxCube0 view from COMPOSITE ID Tax Item Box
P_MX_DueDeferredTaxItem view from COMPOSITE Mexico Due Deferred Tax Item

Fields (74)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 4
KEY FiscalYear FiscalYear 2
KEY TaxCode TaxCode 5
KEY TaxItem TaxItem 5
KEY TaxItemUUID TaxItemUUID 1
KEY TransactionTypeDetermination TransactionTypeDetermination 4
_AccountingDocument _AccountingDocument 1
_CompanyCodeCountry _CompanyCodeCountry 1
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem 1
_GLAccount _GLAccount 1
_ReceivablesPayablesItem _ReceivablesPayablesItem 1
_TaxJurisdiction _TaxJurisdiction 1
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 3
AdditionalCurrency1 AdditionalCurrency1 1
AdditionalCurrency2 AdditionalCurrency2 1
BusinessPlace BusinessPlace 3
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 2
ConditionType ConditionType 1
CountryCurrency CountryCurrency 1
DebitCreditCodeCalc DebitCreditCode 2
DebitCreditCodeIsChanged DebitCreditCodeIsChanged 1
DocumentCurrency DocumentCurrency 2
DocumentDate DocumentDate 3
DocumentReferenceID DocumentReferenceID 3
ExchangeRate ExchangeRate 1
FiscalPeriod FiscalPeriod 1
GLAccount GLAccount 2
IsReversal IsReversal 1
IsReversed IsReversed 1
Ledger Ledger 2
LedgerGroup LedgerGroup 1
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 2
OriginalReferenceDocument OriginalReferenceDocument 2
PostingDate PostingDate 3
ReferenceDocumentType ReferenceDocumentType 2
ReportingCountry ReportingCountry 2
ReportingCurrency ReportingCurrency 1
ReportingDate ReportingDate 3
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
SenderAccountingDocument SenderAccountingDocument 2
SenderCompanyCode SenderCompanyCode 2
SenderFiscalYear SenderFiscalYear 1
SenderLogicalSystem SenderLogicalSystem 2
TaxAmount TaxAmount,TaxAmountInTransCrcy 2
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 1
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 2
TaxAmountInCountryCrcy TaxAmountInCountryCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 2
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 2
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 1
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 1
TaxCalculationProcedure TaxCalculationProcedure 1
TaxCountry TaxCountry 1
TaxDataSource TaxDataSource 1
TaxFulfillmentDate TaxFulfillmentDate 1
TaxIsNotDeductible TaxIsNotDeductible 1
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef 1
TaxItemGroup TaxItemGroup 1
TaxItemIsExternal TaxItemIsExternal 1
TaxJurisdiction TaxJurisdiction 2
TaxRate TaxRate 1
TaxRateValidityStartDate TaxRateValidityStartDate 2
TaxReportingDate TaxReportingDate 3
TaxReportingDocumentDate TaxReportingDocumentDate 3
TaxReturnCountry TaxReturnCountry 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.

-- Tax Item for Statutory Reporting (Auxiliary View)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_STRPTAXITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXCODE,
    TAXITEM,
    TAXITEMUUID,
    TRANSACTIONTYPEDETERMINATION,
    _ACCOUNTINGDOCUMENT,
    _COMPANYCODECOUNTRY,
    _DEBTORCREDITORRBLSPYBLSITEM,
    _GLACCOUNT,
    _RECEIVABLESPAYABLESITEM,
    _TAXJURISDICTION,
    _TAXRECEIVABLESPAYABLESITEM,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    DEBITCREDITCODECALC,
    DEBITCREDITCODEISCHANGED,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LEDGER,
    LEDGERGROUP,
    LOWESTLEVELTAXJURISDICTION,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXCALCULATIONPROCEDURE,
    TAXCOUNTRY,
    TAXDATASOURCE,
    TAXFULFILLMENTDATE,
    TAXISNOTDEDUCTIBLE,
    TAXITEMACCTGDOCITEMREF,
    TAXITEMGROUP,
    TAXITEMISEXTERNAL,
    TAXJURISDICTION,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXRETURNCOUNTRY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXCODE, TAXITEM, TAXITEMUUID, TRANSACTIONTYPEDETERMINATION)
);

Learn More