J_3RTSE

Secondary index table for VAT | #index | Component: Financials Russia
Column Name Description
MANDT FK Client
BUKRS FK Company Code
INITDOC Document Number of an Accounting Document
INITDATE Posting Date in the Document
INITBUZEI Number of Line Item Within Accounting Document
SECBUKRS Company Code
SECDOC Document Number of an Accounting Document
SECDATE Document Date in Document
SECBUZEI Number of Line Item Within Accounting Document
ORIGIN Origin
Column Name Description
💲 Currency Key (WAERS):
SUMMA Secondary Event Amount
PERCENT Percent
NDSPOSC The VAT on an item of the invoice
VOZMVAT The compensated amount of the VAT
Column Name Description
📏 Base Unit of Measure (MEINS):
QUANT Quantity
Column Name Description
INITDATE Posting Date in the Document
SECDATE Document Date in Document
TAXDATE Document Date in Document
RUNDATE Run date
UPDDT Date of the Last Document Update
RATE_DATE Exchange Rate Date
Column Name Description
WITHOUTTAX VAT Include/Exclude Show values
POSEND The item is processed Show values
EVENT Secondary Event Type Show values
ERRCODE Error Code Show values
STATISTIC Attribute of further processing Show values
Column Name Description Domain name
REFERENCE Allocation number ZUONR
TAXDOC Document Number of an Accounting Document BELNR
KSTAR Cost Element KSTAR
INITXBLNR Reference Document Number XBLNR1
PROPL Percent of payment NUM03
SECXBLNR Reference Document Number XBLNR1
DESCRIPT Comment TEXT50
RUNID Run identificator CHAR6
USNAM User Name XUBNAME
TAXYEAR Fiscal Year GJAHR
TAXCODE Target Tax Code (for Deferred Tax) MWSKZ
CCD_BELN Customs Declaration Document Number J_3RS_CCD_BELN
CCD_ITEM Customs Declaration Item Number J_3RS_CCD_ID
CCD_SUBITM Customs Declaration Subitem Number J_3RS_CCD_ID
IMPORT_NOTIFICATION Import Notification Internal Number J_3RS_IMNT_INT_NUM
IMPORT_NOTIFICATION_ITEM Import Notification Item J_3RS_IMNT_POSNR
Master Data Relations Join Conditions
Company Code
  • J_3RTSE.MANDT == T001.MANDT
  • J_3RTSE.BUKRS == T001.BUKRS
Batch Number
  • Material Number
  • Client
  • Batch Number
  • J_3RTSE.MATNR == MCH1.MATNR
  • J_3RTSE.MANDT == MCH1.MANDT
  • J_3RTSE.CHARG == MCH1.CHARG
Client J_3RTSE.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_3RTSE.MATNR == MARA.MATNR
  • J_3RTSE.MANDT == MARA.MANDT
Base Unit of Measure
  • J_3RTSE.MANDT == T006.MANDT
  • J_3RTSE.MEINS == T006.MSEHI
Currency Key
  • J_3RTSE.MANDT == TCURC.MANDT
  • J_3RTSE.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Reference to secondary event types table
  • Company Code
  • Secondary Event Type
  • Client