I_STRPTAXITEM

CDS View
102 Fields 44 CDS Views

Tax Item view for Statutory Reporting

I_STRPTAXITEM is a CDS View in S/4HANA. Tax Item view for Statutory Reporting. It contains 102 fields. 44 CDS views read from this table.

CDS Views using this table (44)

ViewTypeJoinVDMDescription
C_HU_EVATTaxItemCube view_entity inner CONSUMPTION HU eVAT Tax Item Analytical Cube
C_LU_SAFTTax view inner CONSUMPTION SAFT LU Tax
C_MX_DIOTTaxItemLog view_entity from CONSUMPTION Mexico DIOT Audit Trail Data
C_OM_StRpTaxItemWithRefDoc view union_all CONSUMPTION Tax Items With Reference Documents
C_OM_StRpTaxItemWithRefDoc view from CONSUMPTION Tax Items With Reference Documents
C_ZA_SuplrCharcsAndTaxItemCube view from CONSUMPTION South Africa Supplier Characteristics and Tax Item details
FIACCDOCINGST view from
FIES_CalculateTaxReportingD20 view inner Upd VATDATE: Helper for cocd without SII
I_AE_StRpTaxItemAuditCube view_entity from COMPOSITE Sales and Purchase Item with Tax - Cube
I_AR_StRpTaxItem view from COMPOSITE Argentina VAT Tax Line Item Calculation
I_CO_DIANVatTaxReturnBox view_entity from COMPOSITE Colombia DIAN VAT Tax Return Box
I_IL_StRpTaxItemLog view inner COMPOSITE IL: Tax Item For Statutory Reporting
I_MX_DIOTTaxItem view_entity inner COMPOSITE MX DIOT Tax Details with TaxBox config
I_SAFTAccountingTax view left_outer COMPOSITE SAF-T Accouting Tax
I_StRpTaxItemBoxCube view from COMPOSITE VAT Tax Item box level reporting
P_CODIANStRpTaxCodesAndItems view from CONSUMPTION DIAN Format 1001 Tax Codes And Tax Items
P_CountOfTaxLines view from CONSUMPTION
P_EG_StRpTaxLineItem view_entity from COMPOSITE
P_ES_StRpVATRetTaxItem10 view from COMPOSITE
P_ES_TaxReturnBoxDocSel view from COMPOSITE
P_FinCorr1TaxItem view_entity from COMPOSITE
P_GetNonDeductibleDocItem view from COMPOSITE
P_HR_StRpTaxItem view_entity from COMPOSITE Croatia selection for tax reporting
P_IN_GST_ISRCM view from COMPOSITE
P_IN_GST_TAXITEMRATE view from COMPOSITE
P_JP_VATRETURN_TAXBASE view_entity from CONSUMPTION
P_KR_Nondcblinputvatitem00 view from COMPOSITE
P_KR_NONDCBLOUTPUTVATITEM00 view from COMPOSITE
P_KR_NONDCBLPREFIXASSETS00 view inner COMPOSITE
P_KR_StrpToBeDclrdNonDedVatItm view inner COMPOSITE ACR Non Deductible ToBe Declare
P_PH_StRpTaxItemBoxCube view from COMPOSITE
P_PL_SAFTTaxItemBasicAgg view from COMPOSITE
P_PT_STAMPTAXITEMASSIGN view from CONSUMPTION Portugal Stamp Tax Item Selection
P_RptdItemLocalPA view_entity from COMPOSITE
P_SG_StRpTaxItemBoxCube0 view from COMPOSITE
P_SK_StRpCtrlStmntTxItm view inner COMPOSITE
P_SK_StRpVATCSDfrrdTaxItem view inner COMPOSITE
P_SK_StRpVATCSInputTaxItem view_entity from COMPOSITE
P_SK_StRpVATCSInputTaxItemSum view_entity from COMPOSITE
P_SK_StRpVATCSTaxItem view from COMPOSITE
P_SK_VATLedgerTaxItem view_entity from COMPOSITE
P_StRpTaxItemBoxPA view from COMPOSITE
P_StRpTaxReturn view from COMPOSITE
P_TR_PurSlsEdocTaxItem view from COMPOSITE

Fields (102)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,TaxTransferDocument 42
KEY AccountingDocumentType AccountingDocumentType 23
KEY CompanyCode CompanyCode 41
KEY DebitCreditCode DebitCreditCode 12
KEY FiscalYear FiscalYear,TaxTransferDocumentYear 36
KEY ReportingCountry ReportingCountry 12
KEY ReportingCurrency ReportingCurrency 14
KEY Supplier Supplier 10
KEY SupplierAccountGroup SupplierAccountGroup 7
KEY TaxCalculationProcedure TaxCalculationProcedure 16
KEY TaxCode TaxCode 32
KEY TaxItem TaxItem 22
KEY TaxItemGroup TaxItemGroup 18
KEY TaxItemUUID TaxItemUUID 1
KEY TaxRate TaxRate 19
KEY TaxReportingDate ReportingPeriodEndDate,ReportingPeriodStartDate,TaxReportingDate 16
KEY TransactionTypeDetermination TransactionTypeDetermination 26
_AccountingDocument _AccountingDocument 6
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem 1
_GLAccount _GLAccount 3
_JournalEntry _JournalEntry 4
_OneTimeAccountBP _OneTimeAccountBP 1
_ReceivablesPayablesItem _ReceivablesPayablesItem 4
_ReportedItemsLog _ReportedItemsLog 5
_ReportingCurrency _ReportingCurrency 2
_TaxCalculationProcedure _TaxCalculationProcedure 1
_TaxCodeText _TaxCodeText 4
_TaxJurisdiction _TaxJurisdiction 3
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem 1
_TaxTypeText _TaxTypeText 4
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 7
AdditionalCurrency1 AdditionalCurrency1 9
AdditionalCurrency2 AdditionalCurrency2 9
AlternativeReferenceDocument AlternativeReferenceDocument 1
BusinessPartner BusinessPartner 13
BusinessPartnerCountry BusinessPartnerCountry,ShipToPartyCountry 6
BusinessPartnerName BusinessPartnerName 12
BusinessPlace BusinessPlace 14
CAReconciliationKey CAReconciliationKey 4
ClearingAccountingDocument ClearingAccountingDocument 1
CompanyCodeCountry CompanyCodeCountry 10
CompanyCodeCurrency CompanyCodeCurrency 20
ConditionType ConditionType 8
CountryCurrency CountryCurrency 9
Customer Customer 8
CustomerSupplierAddress CustomerSupplierAddress 7
CustomerSupplierVATRegn CustomerSupplierVATRegn,VATRegistration 4
DebitCreditCodeIsChanged DebitCreditCodeIsChanged 3
DocumentCurrency DocumentCurrency,TransactionCurrency 11
DocumentDate DocumentDate 15
DocumentReferenceID DocumentReferenceID 11
DocumentReferenceNumberPrefix DocumentReferenceNumberPrefix 1
EUTaxClassification EUTaxClassification 10
ExchangeRate ExchangeRate 6
FiscalPeriod FiscalPeriod 10
GLAccount GLAccount 13
InterestDocFinAccountType FinancialAccountType,InterestDocFinAccountType 2
IsNegativePosting IsNegativePosting 1
IsReversal IsReversal 9
IsReversed IsReversed 10
Ledger Ledger 7
LedgerGroup LedgerGroup 7
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 6
MiniOneStopShopTxRptgCntry MiniOneStopShopTxRptgCntry 5
OriginalReferenceDocument OriginalReferenceDocument 6
PostingDate PostingDate 16
ReferenceDocumentType ReferenceDocumentType 13
ReportingDate ItemReportingDate,ReportingDate 15
ReverseDocument RefAccountingDocument,ReverseDocument 10
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 9
SenderAccountingDocument SenderAccountingDocument 2
SenderCompanyCode SenderCompanyCode 2
SenderFiscalYear SenderFiscalYear 1
SenderLogicalSystem SenderLogicalSystem 4
TargetTaxCode ItemTargetTaxCode,TargetTaxCode 12
TaxAmount TaxAmount,TaxAmountInRptgCrcy,TaxAmountInTransCrcy 10
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 7
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 7
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 15
TaxAmountInCountryCrcy TaxAmountInCountryCrcy 9
TaxAmountInRptgCrcy TaxAmountInRptgCrcy,TotalGrossAmountInRptgCrcy 12
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 14
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 9
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 10
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 10
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 7
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 7
TaxCodeReturnCountry TaxCodeReturnCountry 1
TaxCountry TaxCountry 11
TaxDataSource TaxDataSource 1
TaxFulfillmentDate TaxFulfillmentDate 1
TaxIsNotDeductible TaxIsNotDeductible 8
TaxJurisdiction TaxJurisdiction 10
TaxNumber1 TaxNumber1 12
TaxNumber2 TaxNumber2 11
TaxNumber3 TaxNumber3 10
TaxNumber4 TaxNumber4 2
TaxRateValidityStartDate TaxRateValidityStartDate 10
TaxReportingDocumentDate TaxReportingDocumentDate 2
TaxReturnCountry TaxReturnCountry 12
TaxType TaxType 16

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 view for Statutory Reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTAXITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXITEM,
    TAXITEMGROUP,
    TAXITEMUUID,
    TAXRATE,
    TAXREPORTINGDATE,
    TRANSACTIONTYPEDETERMINATION,
    _ACCOUNTINGDOCUMENT,
    _DEBTORCREDITORRBLSPYBLSITEM,
    _GLACCOUNT,
    _JOURNALENTRY,
    _ONETIMEACCOUNTBP,
    _RECEIVABLESPAYABLESITEM,
    _REPORTEDITEMSLOG,
    _REPORTINGCURRENCY,
    _TAXCALCULATIONPROCEDURE,
    _TAXCODETEXT,
    _TAXJURISDICTION,
    _TAXRECEIVABLESPAYABLESITEM,
    _TAXTYPETEXT,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ALTERNATIVEREFERENCEDOCUMENT,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    CLEARINGACCOUNTINGDOCUMENT,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    CUSTOMER,
    CUSTOMERSUPPLIERADDRESS,
    CUSTOMERSUPPLIERVATREGN,
    DEBITCREDITCODEISCHANGED,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    DOCUMENTREFERENCENUMBERPREFIX,
    EUTAXCLASSIFICATION,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    INTERESTDOCFINACCOUNTTYPE,
    ISNEGATIVEPOSTING,
    ISREVERSAL,
    ISREVERSED,
    LEDGER,
    LEDGERGROUP,
    LOWESTLEVELTAXJURISDICTION,
    MINIONESTOPSHOPTXRPTGCNTRY,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    TARGETTAXCODE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXCODERETURNCOUNTRY,
    TAXCOUNTRY,
    TAXDATASOURCE,
    TAXFULFILLMENTDATE,
    TAXISNOTDEDUCTIBLE,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, REPORTINGCOUNTRY, REPORTINGCURRENCY, SUPPLIER, SUPPLIERACCOUNTGROUP, TAXCALCULATIONPROCEDURE, TAXCODE, TAXITEM, TAXITEMGROUP, TAXITEMUUID, TAXRATE, TAXREPORTINGDATE, TRANSACTIONTYPEDETERMINATION)
);

Learn More