I_IN_StRpGSTRet

Tax Item Details for GST Returns | view: ISTRPGSTTAXITEM | TRAN | Extraction: Not supported | Component: Localization Financials
Tables used: VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T005, KNA1, KNVV, CVI_CUST_LINK, KNVI, T001W, TVKWZ, TVTA, T685, T685A, LFA1, CVI_VEND_LINK, T007A, T001, T014, T007B, J_1IEXCDEFN
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy Tax Amount in Reporting Currency
💲 Company Code Currency (CompanyCodeCurrency):
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Document Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Currency Key (DocumentCurrency):
TaxAmount Tax Amount in Document Currency
TaxBaseAmountInTransCrcy Tax Amount in Document Currency
💲 Currency Key (CountryCurrency):
TaxBaseAmountInCountryCrcy Tax Base in Reporting Currency
TaxAmountInCountryCrcy Tax Amount in Reporting Currency
💲 Additional Currency 1 (AdditionalCurrency1):
TaxBaseAmtInAdditionalCrcy1 Tax Base Amount in Local Currency 2
TaxAmountInAdditionalCurrency1 Tax Amount in Local Currency 2
💲 Additional Currency 2 (AdditionalCurrency2):
TaxBaseAmtInAdditionalCrcy2 Tax Base Amount in Local Currency 3
TaxAmountInAdditionalCurrency2 Tax Amount in Local Currency 3
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
DocumentDate Journal Entry Date
Column Name Description
EUTaxClassification EU Code/Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxType Tax Type Show values
TaxIsNotDeductible Indicator: Tax not deductible Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
IndianTaxConditionName Condition name for Indian tax conditions Show values
IN_GSTSupplierClassification Vendor Classification for GST Show values
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
TaxCode Tax on sales/purchases code MWSKZ
TransactionTypeDetermination Transaction Key CHAR3
TaxRate null
GLAccount General Ledger Account SAKNR
TaxItemGroup Group Indicator for Tax Line Items NUM03
TaxJurisdiction Tax Jurisdiction TXJCD
BusinessPlace Business Place J_1BBRANCH
AccountingDocumentType Document Type BLART
ReferenceDocumentType Reference Document Type AWTYP
ReverseDocument Reverse Document Number BELNR
ReverseDocumentFiscalYear Fiscal Year of Reversal Document GJAHR
Ledger Ledger FINS_LEDGER
LedgerGroup Country grouping, including country grouping 00 LDGRP
FiscalPeriod Fiscal Period POPER
ExchangeRate Exchange Rate UKURS
CompanyCodeCountry Country/Region Key LAND1
ReportingCountry Reporting Country/Region LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
SupplierName Name of Supplier TEXT80
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName Business Partner Name TEXT80
CustomerSupplierAddress Business Partner Address
ConditionType Condition Type KSCHL
SpecialGLTransactionType Special G/L Transaction Type UMSKS
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
IN_HSNOrSACCode HSN or SAC Code J_1IG_HSN_SAC
DocumentReferenceID Document Reference ID XBLNR1
IN_GSTDocumentType null
IN_GSTSection null
IN_IntegratedGSTAmount null
IN_StateGSTAmount null
IN_CentralGSTAmount null
IN_CessGSTAmtInCoCodeCrcy null
Master Data Relations Join Conditions
Country/Region Key
  • Client
  • Country/Region Key
  • I_IN_STRPGSTRET.MANDT == T005.MANDT
  • I_IN_STRPGSTRET.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_IN_STRPGSTRET.MANDT == KNA1.MANDT
  • I_IN_STRPGSTRET.CUSTOMER == KNA1.KUNNR
Tax classification for customer
  • Client
  • Tax classification for customer
  • ?
  • I_IN_STRPGSTRET.MANDT == TSKD.MANDT
  • I_IN_STRPGSTRET.CUSTOMERTAXCLASSIFICATION == TSKD.TAXKD
  • I_IN_STRPGSTRET.[column in domain "TATYP"] == TSKD.TATYP
Place of Supply
  • ?
  • Client
  • Place of Supply
  • I_IN_STRPGSTRET.[column in domain "LAND1"] == T005S.LAND1
  • I_IN_STRPGSTRET.MANDT == T005S.MANDT
  • I_IN_STRPGSTRET.IN_GSTPLACEOFSUPPLY == T005S.BLAND
Supplier
  • Client
  • Supplier
  • I_IN_STRPGSTRET.MANDT == LFA1.MANDT
  • I_IN_STRPGSTRET.SUPPLIER == LFA1.LIFNR
Vendor account group
  • Client
  • Vendor account group
  • I_IN_STRPGSTRET.MANDT == T077K.MANDT
  • I_IN_STRPGSTRET.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Tax Code
  • ?
  • Client
  • Target Tax Code (for Deferred Tax)
  • I_IN_STRPGSTRET.[column in domain "KALSM_D"] == T007A.KALSM
  • I_IN_STRPGSTRET.MANDT == T007A.MANDT
  • I_IN_STRPGSTRET.TARGETTAXCODE == T007A.MWSKZ
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • I_IN_STRPGSTRET.[column in domain "KVEWE"] == T683.KVEWE
  • I_IN_STRPGSTRET.[column in domain "KAPPL"] == T683.KAPPL
  • I_IN_STRPGSTRET.MANDT == T683.MANDT
  • I_IN_STRPGSTRET.TAXCALCULATIONPROCEDURE == T683.KALSM