SAP ABAP Table J_3RTSE (Secondary index table for VAT)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RF (Package) Localization Russia: FI

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_3RTSE	Table Relationship Diagram
Short Description	Secondary index table for VAT

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	INITDOC	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	INITDATE	☑	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
5	INITBUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	SECBUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	SECDOC	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
8	SECDATE	☑	BLDAT	DATUM	DATS	8	0	Document Date in Document
9	SECBUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
10	ORIGIN	☑	J_3RFORIGIN	SYCHAR26	CHAR	26	0	Origin
11	TYPE	☐	J_3RFSEC_TYPE	J_3RFSEC_TYPE	CHAR	1	0	Secondary Event Type	J_3RFSECTYPE
12	QUANT	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
13	SUMMA	☐	J_3RDMBTR	VWERT13	CURR	13	2	Secondary event amount
14	PERCENT	☐	J_3RPERCENT	VWERT13	CURR	13	2	Percent
15	REFERENCE	☐	J_3RSZUONR	ZUONR	CHAR	18	0	Allocation number
16	WITHOUTTAX	☐	J_3RWITHOUTTAX	J_3RWITHOUTTAX	CHAR	1	0	VAT Include/Exclude
17	TAXDOC	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
18	TAXDATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
19	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
20	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
21	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
22	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
23	INITXBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
24	NDSPOSC	☐	J_3RNDSPOS	J_3RNDSPOS	CURR	13	2	The VAT on an item of the invoice
25	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
26	PROPL	☐	J_3RPROPL	NUM03	NUMC	3	0	Percent of payment
27	VOZMVAT	☐	J_3RVOZM	J_3RVOZM	CURR	13	2	The compensated amount of the VAT
28	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
29	SECXBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
30	POSEND	☐	J_3RPOSEND	CHAR1_X	CHAR	1	0	The item is processed
31	EVENT	☐	J_3RNKSEVENT	J_3RNKSEVENT	CHAR	2	0	Secondary Event Type
32	ERRCODE	☐	J_3RPERRCODE	J_3RPERRCODE	CHAR	2	0	Error Code
33	DESCRIPT	☐	CHAR50	TEXT50	CHAR	50	0	Comment
34	STATISTIC	☐	J_3RSTOP	XFELD	CHAR	1	0	Attribute of further processing
35	RUNDATE	☐	J_3RRUNDATE	DATS	DATS	8	0	Run date
36	RUNID	☐	J_3RRUNID	CHAR6	CHAR	6	0	Run identificator
37	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
38	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3RTSE	BUKRS	T001	BUKRS	KEY	1	CN
2	J_3RTSE	CHARG	MCH1	CHARG	KEY	1	CN
3	J_3RTSE	MANDT	T000	MANDT	KEY	1	CN
4	J_3RTSE	MATNR	MARA	MATNR	KEY	1	CN
5	J_3RTSE	MEINS	T006	MSEHI	KEY	1	CN
6	J_3RTSE	OBJNR	ONR00	OBJNR	KEY	1	CN
7	J_3RTSE	TYPE	J_3RFSECTYPE	J_3RFSEC_TYPE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in