SAP ABAP Table J_3RBUY_BOOK_12 (Stucture for PurBook (ALV))

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_3RBUY_BOOK_12	Table Relationship Diagram
Short Description	Stucture for PurBook (ALV)

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Stucture for PurBook (ALV)
2	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	BELNR_INV	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	XBLNR_INV	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
5	BLDAT_INV	BLDAT	DATUM	DATS	8	0	Document Date in Document
6	BUDAT_INV	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
7	DMBTR_INV	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
8	DMBTR_WRS_INV	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	WRBTR_INV	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
10	WRBTR_WRS_INV	WAERS	WAERS	CUKY	5	0	Currency Key	*
11	BKTXT_INV	BKTXT	TEXT25	CHAR	25	0	Document Header Text
12	BELNR_PAY	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	XBLNR_PAY	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
14	BLDAT_PAY	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	BUDAT_PAY	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	DMBTR_PAY	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
17	DMBTR_WRS_PAY	WAERS	WAERS	CUKY	5	0	Currency Key	*
18	WRBTR_PAY	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
19	WRBTR_WRS_PAY	WAERS	WAERS	CUKY	5	0	Currency Key	*
20	BKTXT_PAY	BKTXT	TEXT25	CHAR	25	0	Document Header Text
21	BELNR_ORIGPAY	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
22	GJAHR_ORIGPAY	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
23	BLDAT_ORIGPAY	BLDAT	DATUM	DATS	8	0	Document Date in Document
24	BUDAT_ORIGPAY	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
25	XBLNR_ORIGPAY	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
26	BKTXT_ORIGPAY	BKTXT	TEXT25	CHAR	25	0	Document Header Text
27	BELNR_TRN	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
28	GSBER_TRN	GSBER	GSBER	CHAR	4	0	Business Area	*
29	BLDAT_TRN	BLDAT	DATUM	DATS	8	0	Document Date in Document
30	BUDAT_TRN	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
31	MONAT_TRN	MONAT	MONAT	NUMC	2	0	Fiscal period
32	DMBTR_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
33	DMBTR_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
34	WRBTR_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
35	WRBTR_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
36	HWBAS_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
37	HWBAS_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	FWBAS_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
39	FWBAS_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	HWBAS2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
41	HWBAS2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
42	FWBAS2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
43	FWBAS2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
44	HWBAS3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
45	HWBAS3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
46	FWBAS3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
47	FWBAS3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
48	HWBAS4_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
49	HWBAS4_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
50	FWBAS4_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
51	FWBAS4_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
52	HWBAS5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
53	HWBAS5_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
54	FWBAS5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
55	FWBAS5_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
56	BASGRUNO	BASGRUNO	NUM2	NUMC	2	0	Group Number for Tax Base Amounts
57	HWSTE_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
58	HWSTE_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
59	FWSTE_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
60	FWSTE_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
61	HWSTE2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
62	HWSTE2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
63	FWSTE2_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
64	FWSTE2_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
65	HWSTE3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
66	HWSTE3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
67	FWSTE3_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
68	FWSTE3_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
69	HWSTE5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
70	HWSTE5_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
71	FWSTE5_TRN	HSLXX	WERTV8	CURR	15	2	Total transactions in the period in local currency (curr 2)
72	FWSTE5_WRS_TRN	WAERS	WAERS	CUKY	5	0	Currency Key	*
73	STEGRUNO	STEGRUNO	NUM2	NUMC	2	0	Group Number for Tax Amounts
74	GJAHR_TEST	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
75	BUZEI_TEST	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
76	XBLNR_TEST	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
77	LIFNR_CRED	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
78	NAME1_CRED	NAME1_GP	NAME	CHAR	35	0	Name 1
79	NAME2_CRED	NAME2_GP	NAME	CHAR	35	0	Name 2
80	NAME3_CRED	NAME3_GP	NAME	CHAR	35	0	Name 3
81	NAME4_CRED	NAME4_GP	NAME	CHAR	35	0	Name 4
82	NAME1_CRED_R	NAME1_GP	NAME	CHAR	35	0	Name 1
83	NAME2_CRED_R	NAME2_GP	NAME	CHAR	35	0	Name 2
84	NAME3_CRED_R	NAME3_GP	NAME	CHAR	35	0	Name 3
85	NAME4_CRED_R	NAME4_GP	NAME	CHAR	35	0	Name 4
86	STCD1_CRED	STCD1	STCD1	CHAR	16	0	Tax Number 1
87	STCD3_CRED	STCD3	CHAR18	CHAR	18	0	Tax Number 3
88	FLG_BELNR_TRN	J_3RF_BUE_F_D0	KOART	CHAR	1	0	Reversal (Tax Transfer)
89	BKTXT_TRN	BKTXT	TEXT25	CHAR	25	0	Document Header Text
90	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
91	LIGHTS	SCRFICON	SCRPICON	CHAR	4	0	Icon ID (incl. @)
92	BOX	J_3RF_BUE_F_BOX	KOART	CHAR	1	0	Flag for mark rec 01
93	FLG_BELNR_PAY	J_3RF_BUE_F_D2		CHAR	1	0	Reversal (Payment)
94	FLG_BELNR_INV	J_3RF_BUE_F_D1	KOART	CHAR	1	0	Reversal (Invoice)
95	FLG_XRAGL_PAY	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
96	FLG_BELNR_ALL	J_3RF_BUE_F_ALL	KOART	CHAR	1	0	Reversal (Clearing)
97	MM_INV_BUDAT	J_3RF_DE_RDAT	DATUM	DATS	8	0	Date of Goods Receipt
98	MM_INV_EBLN	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
99	MM_INV_EBELP	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
100	MM_INV_VOISO	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
101	PART_PAYMENT	J_3RF_BUE_F_PP		CHAR	1	0	Partial Payment
102	MWSKZ_INV	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
103	NUM_LINE	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
104	GJAHR_TRN	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
105	GJAHR_INV	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
106	GJAHR_PAY	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
107	BUTXT	NAME1_BAS	NAME	CHAR	35	0	Name 1
108	PAVAL	PAVAL	TEXT48	CHAR	48	0	Parameter value
109	DAT_BEGIN	DATS	DATS	DATS	8	0	Field of type DATS
110	DAT_END	DATS	DATS	DATS	8	0	Field of type DATS
111	EKBE_BELNR_MM	MBLNR	BELNR	CHAR	10	0	Number of Material Document
112	XREF1_INV	XREF1	CHAR12	CHAR	12	0	Business partner reference key
113	XREF1_DAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
114	HKONT_INV	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
115	HKONT_TRN	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
116	HKONT_CLN	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
117	MM_INV_VORNU	CHAR0256	CHAR0256	LCHR	256	0	Character String - 256 User-Defined Characters
118	USNAM_INV	USNAM	XUBNAME	CHAR	12	0	User name	*
119	USNAM_PAY	USNAM	XUBNAME	CHAR	12	0	User name	*
120	USNAM_PAY_FCT	USNAM	XUBNAME	CHAR	12	0	User name	*
121	.INCLUDE				0	0	Extension structure for Sales and Purchase Ledgers
122	BUKRS_ADD	BUKRS	BUKRS	CHAR	4	0	Company Code	*
123	BELNR_ADD	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
124	GJAHR_ADD	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
125	MONAT_ADD	MONAT	MONAT	NUMC	2	0	Fiscal period
126	BUZEI_ADD	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
127	FLAG_ADD	STORN	XFELD	CHAR	1	0	Indicator: Document is reversed
128	CORR_TYPE	J_3RF_BUE_CORR_TYPE	J_3RF_BUE_CORR_TYPE	CHAR	1	0	Correction Type
129	CORR_BOOK	J_3RF_BUE_CORR_BOOK	FLAG	CHAR	1	0	Correction invoice from opposite book
130	BELNR_ORIG_INV	J_3RFINV_ORIGS	BELNR	CHAR	10	0	Number of Original VAT Invoice
131	GJAHR_ORIG_INV	J_3RFINV_ORIGY	GJAHR	NUMC	4	0	Year of Original VAT Invoice
132	BLDAT_ORIG_INV	J_3RFINV_ORIGD	DATUM	DATS	8	0	Date of Original VAT Invoice
133	BUDAT_ORIG_INV	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
134	XBLNR_ORIG_INV	J_3RF_EXT_NUMBER	TEXT50	CHAR	50	0	External Document Number
135	NUMBER_REV	J_3RFINV_REVNO	NUM03	NUMC	3	0	Revision Number
136	NUMBER_CORR_REV	J_3RFINV_REVNO_CORR	NUM03	NUMC	3	0	Revision Number of Correction
137	VATDATE_INV	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
138	VATDATE_TRN	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
139	BLDAT_CORR_INV	J_3RFINV_CORRD	DATUM	DATS	8	0	Date of Corrective VAT Invoice
140	XBLNR_CORR_INV	J_3RF_EXT_NUMBER	TEXT50	CHAR	50	0	External Document Number
141	JOURNAL	J_3RFINV_REGFLAG	J_3RF_REGFLAG	CHAR	1	0	Register in Journal
142	BELNR_CORR_INV	J_3RFINV_CORRS	BELNR	CHAR	10	0	Number of Corrective VAT Invoice
143	GJAHR_CORR_INV	J_3RFINV_CORRY	GJAHR	NUMC	4	0	Year of Corrective VAT Invoice
144	BELNR_ORIG_REV	J_3RFINV_REVS	BELNR	CHAR	10	0	Number of Revised VAT Invoice
145	GJAHR_ORIG_REV	J_3RFINV_REVY	GJAHR	NUMC	4	0	Year of Revised VAT Invoice
146	BLDAT_ORIG_REV	J_3RFINV_REVD	DATUM	DATS	8	0	Revision Date
147	BELNR_CORR_REV	J_3RFINV_CORR_REVS	BELNR	CHAR	10	0	Number of Revised Correction Invoice
148	GJAHR_CORR_REV	J_3RFINV_CORR_REVY	GJAHR	NUMC	4	0	Year of Revised Correction Invoice
149	BLDAT_CORR_REV	J_3RFINV_CORR_REVD	DATUM	DATS	8	0	Revision Date of Correction
150	EXT_TEXT_ORIG	FLAG	FLAG	CHAR	1	0	General Flag
151	EXT_TEXT_CORR	FLAG	FLAG	CHAR	1	0	General Flag