FISTRPGSTR1ITEM

GSTR1 Tax Items for Statutory Reporting | view: FISRGSTR1ITM | Extraction: Not supported | Component: Localization Financials
Tables used: BSEG, VBPA, VBRP, VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, BKPF, BSEG, VBPA, VBPA, ADRC, KNVI, T604N, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, BUT000, CVI_CUST_LINK, KNA1, DFKKBPTAXNUM_ADR, CFIN_AV_CI_ROOT, T005, KNA1, CVI_CUST_LINK, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, T007A, T001, T014, T007B, J_1IEXCDEFN, EDOINTXCODEMAP, EDOINUQC, J_1IEXCDEFN, J_1ISTATECDM
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
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
💲 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
invdmbtr Amount in local currency
dmbtr null
Column Name Description
📏 Base Unit of Measure (meins):
menge Quantity
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
bldat Journal Entry Date
vatdate Tax Reporting 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
shkzg Debit/Credit Indicator Show values
SDDocumentCategory SD Document Category Show values
niltype eDocument India: Niltype Show values
rvchrg eDocument India: Reverse Charge Show values
import eDocument India: Import (Goods or Services Indicator) Show values
cond_name Condition name for Indian tax conditions Show values
edoc_in_uqc eDocument India: Unit Quantity Code Show values
prsfd Carry out pricing Show values
Column Name Description Domain name
TaxRate TaxRate (Percentage)
GLAccount General Ledger Account SAKNR
TaxItemGroup Group Indicator for Tax Line Items NUM03
BusinessPlace Business Place J_1BBRANCH
TaxJurisdiction Tax Jurisdiction TXJCD
LowestLevelTaxJurisdiction Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax TXJCD
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
DocumentReferenceID Document Reference ID XBLNR1
AlternativeReferenceDocument Alternative Reference Document XBLNR_ALT
AccountingDocumentHeaderText Document Header Text TEXT25
CompanyCodeCountry Country/Region Key LAND1
ReportingCountry Reporting Country/Region LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
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
umsks Special G/L Transaction Type UMSKS
rebzg Document No. of the Invoice to Which the Transaction Belongs BELNR
rebzj Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
rebzz Line Item in the Relevant Invoice BUZEI
rebzt Follow-On Document Type REBZT
invxblnr Document Reference ID XBLNR1
TaxCountry Tax Reporting Country/Region LAND1
OriginalReferenceDocument Object key AWKEY
hsn_sac HSN or SAC Code J_1IG_HSN_SAC
text1 Description of Rule TEXT60
condname null
kbetr null
plc_sup Place of Supply REGIO
gst_part GST Partner J_1IG_PARTNER
legal_state_code ITD State Code J_1ISTATECODE
RegisteredInd null
BPTaxNumber Business Partner Tax Number BPTAXNUM
Master Data Relations Join Conditions
Customer Number
  • Client
  • Customer Number
  • FISTRPGSTR1ITEM.MANDT == KNA1.MANDT
  • FISTRPGSTR1ITEM.CUSTOMER == KNA1.KUNNR
General Ledger Account
  • General Ledger Account
  • Client
  • ?
  • FISTRPGSTR1ITEM.HKONT == SKB1.SAKNR
  • FISTRPGSTR1ITEM.MANDT == SKB1.MANDT
  • FISTRPGSTR1ITEM.[column in domain "BUKRS"] == SKB1.BUKRS
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FISTRPGSTR1ITEM.LAND == T005.LAND1
  • FISTRPGSTR1ITEM.LAND1 == T005.LAND1
  • FISTRPGSTR1ITEM.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • FISTRPGSTR1ITEM.LAND == T005.LAND1
  • FISTRPGSTR1ITEM.LAND1 == T005.LAND1
  • FISTRPGSTR1ITEM.MANDT == T005.MANDT
Material Number
  • Client
  • Material Number
  • FISTRPGSTR1ITEM.MANDT == MARA.MANDT
  • FISTRPGSTR1ITEM.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FISTRPGSTR1ITEM.MANDT == T006.MANDT
  • FISTRPGSTR1ITEM.MEINS == T006.MSEHI
Vendor account group
  • Vendor account group
  • Client
  • FISTRPGSTR1ITEM.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • FISTRPGSTR1ITEM.MANDT == T077K.MANDT
Tax Code
  • ?
  • Client
  • Target Tax Code (for Deferred Tax)
  • FISTRPGSTR1ITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FISTRPGSTR1ITEM.MANDT == T007A.MANDT
  • FISTRPGSTR1ITEM.TARGETTAXCODE == T007A.MWSKZ
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • FISTRPGSTR1ITEM.[column in domain "KVEWE"] == T683.KVEWE
  • FISTRPGSTR1ITEM.[column in domain "KAPPL"] == T683.KAPPL
  • FISTRPGSTR1ITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • FISTRPGSTR1ITEM.MANDT == T683.MANDT
Tax classification for customer
  • ?
  • Tax classification for customer
  • Client
  • FISTRPGSTR1ITEM.[column in domain "TATYP"] == TSKD.TATYP
  • FISTRPGSTR1ITEM.TAXKD == TSKD.TAXKD
  • FISTRPGSTR1ITEM.MANDT == TSKD.MANDT
Plant
  • Client
  • Plant
  • FISTRPGSTR1ITEM.MANDT == T001W.MANDT
  • FISTRPGSTR1ITEM.WERKS == T001W.WERKS