SAP ABAP Table V_J_3RFREGINVIN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_J_3RFREGINVIN	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	NUM	☑	NUM10	NUM10	NUMC	10	0	10 digit number
5	EXT_ORIG	☐	J_3RFINV_ORIGE	TEXT50	CHAR	50	0	External Number of Original VAT Invoice
6	EXT_CORR	☐	J_3RFINV_CORRE	TEXT50	CHAR	50	0	External Number of Corrective VAT Invoice
7	REVNO	☐	J_3RFINV_REVNO	NUM03	NUMC	3	0	Revision Number
8	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
9	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
10	DATE_RECV	☐	J_3RFINV_RECV	DATUM	DATS	8	0	Receipt Date
11	BELNR_ORIG	☐	J_3RFINV_ORIGS	BELNR	CHAR	10	0	Number of Original VAT Invoice	BKPF
12	GJAHR_ORIG	☐	J_3RFINV_ORIGY	GJAHR	NUMC	4	0	Year of Original VAT Invoice
13	BELNR_CORR	☐	J_3RFINV_CORRS	BELNR	CHAR	10	0	Number of Corrective VAT Invoice	BKPF
14	GJAHR_CORR	☐	J_3RFINV_CORRY	GJAHR	NUMC	4	0	Year of Corrective VAT Invoice
15	BELNR_REV	☐	J_3RFINV_REVS	BELNR	CHAR	10	0	Number of Revised VAT Invoice	BKPF
16	GJAHR_REV	☐	J_3RFINV_REVY	GJAHR	NUMC	4	0	Year of Revised VAT Invoice
17	DATE_ORIG	☐	J_3RFINV_ORIGD	DATUM	DATS	8	0	Date of Original VAT Invoice
18	DATE_CORR	☐	J_3RFINV_CORRD	DATUM	DATS	8	0	Date of Corrective VAT Invoice
19	DATE_REV	☐	J_3RFINV_REVD	DATUM	DATS	8	0	Revision Date
20	EXCH_TYP	☐	J_3RFINV_EXCHTYP	J_3RF_EXCHTYP	CHAR	1	0	Exchange Format
21	OPER_TYP	☐	J_3RFINV_OPERTYP	CHAR20	CHAR	20	0	Operation Type
22	NAME	☐	J_3RFINV_NAME	J_3RF_TEXT255	CHAR	255	0	Partner Name
23	INN	☐	J_3RFINV_INN	STCD1	CHAR	16	0	Partner INN
24	KPP	☐	J_3RFINV_KPP	CHAR18	CHAR	18	0	Partner KPP
25	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	FWBTR	☐	J_3RFINV_FWBTR	WERTV8	CURR	15	2	Gross Amount in Document Currency
27	FWSTE	☐	J_3RFINV_FWSTE	WERTV8	CURR	15	2	Tax Amount in Document Currency
28	FWBTR_DIFF	☐	J_3RFINV_FWBTRDIFF	WERTV8	CURR	15	2	Gross Amount Difference in Document Currency
29	FWSTE_DIFF	☐	J_3RFINV_FWSTEDIFF	WERTV8	CURR	15	2	Tax Amount Difference in Document Currency
30	NONTAX	☐	J_3RFINV_NONTAX	XCHAR	CHAR	1	0	Flag: Document Is Nontaxable
31	FLAG_DEL	☐	J_3RFINV_DELFLAG	XFELD	CHAR	1	0	Flag: Entry Is Deleted
32	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name
33	TMSTMP	☐	J_3RFINV_TMSTMP	TIMESTAMP	CHAR	14	0	Time Stamp
34	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
35	FLAG_NONREG	☐	J_3RFINV_NONREG	J_3RFINV_NONREG	CHAR	1	0	Flag: Non-Registered XML Invoice
36	DOC_STATUS	☐	J_3RFINV_DOC_STATUS	J_3RFINV_DOC_STATUS	CHAR	2	0	Electronic Invoice Document Status
37	CLARIF_STATUS	☐	J_3RFINV_CLARIF_STATUS	J_3RFINV_CLARIF_STATUS	CHAR	2	0	Electronic Invoice Clarification Request Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_J_3RFREGINVIN	BELNR_CORR	BKPF	BELNR	KEY	1	CN
2	V_J_3RFREGINVIN	BELNR_ORIG	BKPF	BELNR	KEY	1	CN
3	V_J_3RFREGINVIN	BELNR_REV	BKPF	BELNR	KEY	1	CN
4	V_J_3RFREGINVIN	BUKRS	T001	BUKRS	KEY	1	CN
5	V_J_3RFREGINVIN	KUNNR	KNA1	KUNNR	KEY	1	CN
6	V_J_3RFREGINVIN	LIFNR	LFA1	LIFNR	KEY	1	CN
7	V_J_3RFREGINVIN	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in