SAP ABAP Table J_3RFVAT_REP (VAT in transit ALV fields)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	J_3RFVAT_REP	Table Relationship Diagram
Short Description	VAT in transit ALV fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CHECK__	☐	J_3RFVAT_SEL	J_3RFVAT_SEL	CHAR	100	0	Processing Status of ALV Item
2	LIGHT__	☐	J_3RFVAT_ST	J_3RFVAT_ST	CHAR	100	0	Status of Document in Posting VAT for Goods in Transit
3	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
4	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
5	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
6	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBRK
7	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
8	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
11	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
12	NETWR_LOC	☐	J_3RFVAT_NETWR_LOC	WERTV8	CURR	15	2	Billing Document Net Value in Local Currency
13	WAERK_LOC	☐	J_3RFVAT_WEARS_LOC	WAERS	CUKY	5	0	Local Currency for Company Code	*
14	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
15	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
16	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
17	MWSBK_CUR	☐	J_3RFVAT_MWSBK_LOC	WERTV7	CURR	13	2	Billing Document Tax Amount for Posting in Document Currency
18	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
19	BELNR_VAT	☐	J_3RFVAT_BELNR	BELNR	CHAR	10	0	VAT Posting Document Number
20	GJAHR_VAT	☐	J_3RFVAT_GJAHR	GJAHR	NUMC	4	0	VAT Posting Document Fiscal Year
21	WRBTR_VAT	☐	J_3RFVAT_WRBTR	WERTV8	CURR	15	2	VAT Posting Amount in Document Currency
22	FWBAS_VAT	☐	J_3RFVAT_FWBAS	WERTV8	CURR	15	2	VAT Posting Tax Base Amount in Document Currency
23	WAERS_VAT	☐	J_3RFVAT_WAERS_VAT	WAERS	CUKY	5	0	VAT Posting Document Currency	*
24	DMBTR_VAT	☐	J_3RFVAT_DMBTR	WERTV8	CURR	15	2	VAT Posting Amount in Local Currency
25	HWBAS_VAT	☐	J_3RFVAT_HWBAS	WERTV8	CURR	15	2	VAT Posting Tax Base Amount in Local Currency
26	KURSF_VAT	☐	J_3RFVAT_RATE_VAT	KURSF	DEC	9	5	VAT Posting Document Currency Exchange Rate
27	WWERT_VAT	☐	J_3RFVAT_WWERT	DATUM	DATS	8	0	Translation Date for VAT Posting Document
28	BELNR_INV	☐	J_3RFVAT_BELNR_INV	BELNR	CHAR	10	0	FI Invoice Document Number
29	GJAHR_INV	☐	J_3RFVAT_GJAHR_INV	GJAHR	NUMC	4	0	FI Invoice Fiscal Year
30	BELNR_CLR	☐	J_3RFVAT_BELNR_CLR	BELNR	CHAR	10	0	VAT Clearing Document Number
31	GJAHR_CLR	☐	J_3RFVAT_GJAHR_CLR	GJAHR	NUMC	4	0	VAT Clearing Document Fiscal Year
32	ERRTXT__	☐	J_3RFVAT_MSG	CHAR80	CHAR	80	0	Error Description for ALV item
33	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3RFVAT_REP	BUKRS	T001	BUKRS	KEY	1	CN
2	J_3RFVAT_REP	FKART	TVFK	FKART	KEY	1	CN
3	J_3RFVAT_REP	KUNAG	KNA1	KUNNR	REF	1	CN
4	J_3RFVAT_REP	VBELN	VBRK	VBELN	KEY	1	CN
5	J_3RFVAT_REP	VKORG	TVKO	VKORG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605