SAP ABAP Table J_3RBUY_BOOK_EXT (Stucture for PurBook (ALV))
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-LOC (Application Component) Localization
⤷ J3RF (Package) Localization Russia: FI
⤷ FI-LOC (Application Component) Localization
⤷ J3RF (Package) Localization Russia: FI
Basic Data
Table Category | INTTAB | Structure |
Structure | J_3RBUY_BOOK_EXT | 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 | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
2 | BELNR_INV | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
3 | XBLNR_INV | XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
4 | BLDAT_INV | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
5 | BUDAT_INV | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
6 | DMBTR_INV | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
7 | DMBTR_WRS_INV | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
8 | WRBTR_INV | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
9 | WRBTR_WRS_INV | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
10 | BKTXT_INV | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
11 | BELNR_PAY | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
12 | XBLNR_PAY | XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
13 | BLDAT_PAY | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
14 | BUDAT_PAY | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
15 | DMBTR_PAY | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
16 | DMBTR_WRS_PAY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
17 | WRBTR_PAY | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
18 | WRBTR_WRS_PAY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
19 | BKTXT_PAY | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
20 | BELNR_ORIGPAY | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
21 | GJAHR_ORIGPAY | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
22 | BLDAT_ORIGPAY | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
23 | BUDAT_ORIGPAY | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
24 | XBLNR_ORIGPAY | XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
25 | BKTXT_ORIGPAY | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
26 | BELNR_TRN | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
27 | GSBER_TRN | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
28 | BLDAT_TRN | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
29 | BUDAT_TRN | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
30 | MONAT_TRN | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
31 | DMBTR_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
32 | DMBTR_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
33 | WRBTR_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
34 | WRBTR_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
35 | HWBAS_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
36 | HWBAS_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
37 | FWBAS_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
38 | FWBAS_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
39 | HWBAS2_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
40 | HWBAS2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
41 | FWBAS2_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
42 | FWBAS2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
43 | HWBAS3_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
44 | HWBAS3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
45 | FWBAS3_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
46 | FWBAS3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
47 | HWBAS4_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
48 | HWBAS4_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
49 | FWBAS4_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
50 | FWBAS4_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
51 | HWBAS5_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
52 | HWBAS5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
53 | FWBAS5_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
54 | FWBAS5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
55 | BASGRUNO | BASGRUNO | NUM2 | NUMC | 2 | 0 | Group Number for Tax Base Amounts | ||
56 | HWSTE_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
57 | HWSTE_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
58 | FWSTE_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
59 | FWSTE_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
60 | HWSTE2_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
61 | HWSTE2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
62 | FWSTE2_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
63 | FWSTE2_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
64 | HWSTE3_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
65 | HWSTE3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
66 | FWSTE3_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
67 | FWSTE3_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
68 | HWSTE5_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
69 | HWSTE5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
70 | FWSTE5_TRN | HSLXX | WERTV8 | CURR | 15 | 2 | Total transactions in the period in local currency (curr 2) | ||
71 | FWSTE5_WRS_TRN | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
72 | STEGRUNO | STEGRUNO | NUM2 | NUMC | 2 | 0 | Group Number for Tax Amounts | ||
73 | GJAHR_TEST | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
74 | BUZEI_TEST | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
75 | XBLNR_TEST | XBLNR | XBLNR | CHAR | 16 | 0 | Reference Document Number | ||
76 | LIFNR_CRED | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
77 | NAME1_CRED | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
78 | NAME2_CRED | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
79 | NAME3_CRED | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
80 | NAME4_CRED | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
81 | NAME1_CRED_R | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
82 | NAME2_CRED_R | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
83 | NAME3_CRED_R | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
84 | NAME4_CRED_R | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
85 | STCD1_CRED | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
86 | STCD3_CRED | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
87 | FLG_BELNR_TRN | J_3RF_BUE_F_D0 | KOART | CHAR | 1 | 0 | Reversal (Tax Transfer) | ||
88 | BKTXT_TRN | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
89 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
90 | LIGHTS | SCRFICON | SCRPICON | CHAR | 4 | 0 | Icon ID (incl. @) | ||
91 | BOX | J_3RF_BUE_F_BOX | KOART | CHAR | 1 | 0 | Flag for mark rec 01 | ||
92 | FLG_BELNR_PAY | J_3RF_BUE_F_D2 | CHAR | 1 | 0 | Reversal (Payment) | |||
93 | FLG_BELNR_INV | J_3RF_BUE_F_D1 | KOART | CHAR | 1 | 0 | Reversal (Invoice) | ||
94 | FLG_XRAGL_PAY | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
95 | FLG_BELNR_ALL | J_3RF_BUE_F_ALL | KOART | CHAR | 1 | 0 | Reversal (Clearing) | ||
96 | MM_INV_BUDAT | J_3RF_DE_RDAT | DATUM | DATS | 8 | 0 | Date of Goods Receipt | ||
97 | MM_INV_EBLN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
98 | MM_INV_EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
99 | MM_INV_VOISO | VOISO | INTCA | CHAR | 2 | 0 | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | ||
100 | PART_PAYMENT | J_3RF_BUE_F_PP | CHAR | 1 | 0 | Partial Payment | |||
101 | MWSKZ_INV | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
102 | NUM_LINE | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
103 | GJAHR_TRN | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
104 | GJAHR_INV | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
105 | GJAHR_PAY | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
106 | BUTXT | NAME1_BAS | NAME | CHAR | 35 | 0 | Name 1 | ||
107 | PAVAL | PAVAL | TEXT48 | CHAR | 48 | 0 | Parameter value | ||
108 | DAT_BEGIN | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
109 | DAT_END | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
110 | EKBE_BELNR_MM | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
111 | XREF1_INV | XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
112 | XREF1_DAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
113 | HKONT_INV | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
114 | HKONT_TRN | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
115 | HKONT_CLN | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
116 | MM_INV_VORNU | CHAR0256 | CHAR0256 | LCHR | 256 | 0 | Character String - 256 User-Defined Characters | ||
117 | USNAM_INV | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
118 | USNAM_PAY | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
119 | USNAM_PAY_FCT | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
120 | .INCLUDE | 0 | 0 | Extension structure for Sales and Purchase Ledgers | |||||
121 | BUKRS_ADD | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
122 | BELNR_ADD | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
123 | GJAHR_ADD | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
124 | MONAT_ADD | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
125 | BUZEI_ADD | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
126 | FLAG_ADD | STORN | XFELD | CHAR | 1 | 0 | Indicator: Document is reversed |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |