	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

170 columns | ERP 6.0 | NETWR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000176000	PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header	30	NETWR		decimal	15	0
2	/BIC/B0000178000	PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item	76	NETWR		decimal	15	0
3	/BIC/B0000184000	PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data	24	NETWR		decimal	15	0
4	/BIC/B0000185000	PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item	70	NETWR		decimal	15	0
5	/BIC/B0000187000	PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)	54	NETWR		decimal	13	0
6	IDGT_GTDH	GT Document Header	9	NETWR	Net Value	decimal	17	2
7	IDGT_GTDI	GT Document Item	9	NETWR	Net Value	decimal	17	2
8	IDGT_MERGE_INFO	Item Merge Info	6	NETWR	Net Value	decimal	17	2
9	IDGT_VATH	VAT Invoice Header	6	NETWR	Net Value	decimal	17	2
10	IDGT_VATI	VAT Invoice Item	11	NETWR	Net Value	decimal	17	2
11	J_1ILOCDOC	EXIM : Reference Documents for Letter of Credit	7	NETWR	Net Value in Document Currency	decimal	15	2
12	J_3RFGTD_ITEM	Import Customs Declaration Items	27	NETWR	Invoice Cost	decimal	15	2
13	S870BIW1	S870BIW1 * Reference Structure for Generating Info Structure	21	NETWR	Effective order value	decimal	15	2
14	S870BIW2	S870BIW2 * Reference Structure for Generating Info Structure	21	NETWR	Effective order value	decimal	15	2
15	ZEIM_LIPS	SD document: Delivery: Item data	169	NETWR	Net Value in Document Currency	decimal	15	2
16	ZEIM_VBAK	Sales Document: Header Data	17	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
17	ZEIM_VBAP	Sales Document: Item Data	44	NETWR	Net value of the order item in document currency	decimal	15	2
TOPAgency Business Global Trade
18	WBRK	Agency business: Header	43	NETWR	Agency Business: Net value in document currency	decimal	15	2
19	WBRL	Agency business: Item in document list	5	NETWR	Agency business: New value of item in a list	decimal	15	2
20	WBRP	Agency business: Item	27	NETWR	Net value of the item in document currency	decimal	15	2
21	WLFD_IVRHDR	Agency Bus.: DB table for Invoice Request Header	9	NETWR	Agency Business: Net value in document currency	decimal	15	2
22	WLFD_IVRITM	Agency Bus.: DB table for Invoice Request Item	9	NETWR	Net value of the item in document currency	decimal	15	2
TOPBasic Functions
23	FPLT	Billing Plan: Dates	37	NETWR	Net value of the order item in document currency	decimal	15	2
24	FPLTPO	Billing Plan: Dates	37	NETWR	Net value of the order item in document currency	decimal	15	2
25	VFPLT	Billing Plan: Dates	37	NETWR	Net value of the order item in document currency	decimal	15	2
TOPBasis Components
26	ZSALES_ORD_ITEM	Sales Order Item(IDES Demo)	8	NETWR	Net value of the order item in document currency	decimal	15	2
TOPBilling
27	VBRK	Billing Document: Header Data	46	NETWR	Net Value in Document Currency	decimal	15	2
28	VBRL	Sales Document: Invoice List	5	NETWR	Net Value in Document Currency	decimal	15	2
29	VBRP	Billing Document: Item Data	22	NETWR	Net value of the billing item in document currency	decimal	15	2
TOPChargeback
30	WB2_D_BUSVOL	Rebates: Business Volume	9	NETWR	Net Value in Document Currency	decimal	15	2
TOPContract Accounts Receivable and Payable
31	FKK_JFRK_SHORT	Header Data for IS-M/SD Billing Document - Extracts	19	NETWR	Value of invoice	nvarchar	16	0
32	FKK_JFRP_SHORT	Item Data for IS-M/SD Billing Document - Extracts	15	NETWR	IS-M/SD: Net Value of Item in Document Currency	nvarchar	17	0
33	FKK_JLRK_SHORT	Header Data for IS-M/SD Service Settlement - Extracts	17	NETWR	Value of invoice	nvarchar	16	0
34	FKK_JLRPCM_SHORT	Item Data for IS-M/SD Commission Settlement - Extracts	12	NETWR	IS-M/SD: Net Value of Item in Document Currency	nvarchar	17	0
35	FKK_JLRPHD_SHORT	Item Data for IS-M/SD Home Delivery Settlement - Extracts	8	NETWR	IS-M/SD: Net Value of Item in Document Currency	nvarchar	17	0
TOPContract Handling
36	S462	IS-BEV-CH: Sales in BUn	21	NETWR	Net value of the billing item in document currency	decimal	15	2
37	S463	IS-BEV-CH: Sales in Stat. UoM	21	NETWR	Net value of the billing item in document currency	decimal	15	2
TOPCross-Application Components
38	VVBAK	Sales Document: Header Data	17	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
39	VVBAP	Sales Document: Item Data	44	NETWR	Net value of the order item in document currency	decimal	15	2
TOPData Collection
40	S011	PURCHIS: Purchasing Group Statistics	14	NETWR	Effective order value	decimal	15	2
41	S011BIW1	S011BIW1 * PURCHIS: Purchasing Group Statistics	14	NETWR	Effective order value	decimal	15	2
42	S011BIW2	S011BIW2 * PURCHIS: Purchasing Group Statistics	14	NETWR	Effective order value	decimal	15	2
43	S012	Purchasing	25	NETWR	Effective order value	decimal	15	2
44	S012BIW1	S012BIW1 * Purchasing	25	NETWR	Effective order value	decimal	15	2
45	S012BIW2	S012BIW2 * Purchasing	25	NETWR	Effective order value	decimal	15	2
46	S260	SD - Sales order	90	NETWR	Net value of the order item in document currency	decimal	15	2
47	S260BIW1	SD - Sales order	90	NETWR	Net value of the order item in document currency	decimal	15	2
48	S260BIW2	SD - Sales order	90	NETWR	Net value of the order item in document currency	decimal	15	2
49	S262	SD - Billing document	85	NETWR	Net value of the billing item in document currency	decimal	15	2
50	S262BIW1	SD - Billing document	85	NETWR	Net value of the billing item in document currency	decimal	15	2
51	S262BIW2	SD - Billing document	85	NETWR	Net value of the billing item in document currency	decimal	15	2
52	S264	SD- Offer	93	NETWR	Net value of the order item in document currency	decimal	15	2
53	S264BIW1	S264BIW1 * SD - Quotation	93	NETWR	Net value of the order item in document currency	decimal	15	2
54	S264BIW2	S264BIW2 * SD - Quotation	93	NETWR	Net value of the order item in document currency	decimal	15	2
55	S270	Do not use!	27	NETWR	Net order value in order currency	decimal	13	2
56	S270BIW1	Do not use!	27	NETWR	Net order value in order currency	decimal	13	2
57	S270BIW2	Do not use!	27	NETWR	Net order value in order currency	decimal	13	2
58	S272	Do not use!	34	NETWR	Net value of the billing item in document currency	decimal	15	2
59	S272BIW1	Do not use!	34	NETWR	Net value of the billing item in document currency	decimal	15	2
60	S272BIW2	Do not use!	34	NETWR	Net value of the billing item in document currency	decimal	15	2
61	S850	BW220: Connecting LIS-IS to BW	21	NETWR	Effective order value	decimal	15	2
62	S851	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
63	S852	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
64	S853	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
65	S854	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
66	S855	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
67	S856	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
68	S857	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
69	S858	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
70	S859	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
71	S860	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
72	S861	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
73	S862	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
74	S863	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
75	S864	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
76	S865	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
77	S866	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
78	S867	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
79	S868	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
80	S869	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
81	S870	Reference Structure for Generating Info Structures	21	NETWR	Effective order value	decimal	15	2
82	S913	LIS: Purchasing (cons. Planng)	20	NETWR	Effective order value	decimal	15	2
83	S930	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
84	S931	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
85	S932	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
86	S933	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
87	S934	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
88	S935	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
89	S936	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
90	S937	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
91	S938	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
92	S939	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
93	S940	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
94	S941	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
95	S942	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
96	S943	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
97	S944	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
98	S945	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
99	S946	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
100	S947	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
101	S948	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
102	S949	BW220: Connect LIS-IS to BW(2)	21	NETWR	Effective order value	decimal	15	2
TOPData Retention Tool
103	TXW_S_EKPO	Retrieve EKPO from archive	21	NETWR	Purchase order net value	nvarchar	16	0
104	TXW_S_VBAP	Retrieve VBAP from archive	16	NETWR	Net value of the order item in document currency	nvarchar	16	0
105	TXW_S_VBRK	Retrieve VBRK from archive	23	NETWR	Value of invoice	nvarchar	16	0
106	TXW_S_VBRP	Retrieve VBRP from archive	29	NETWR	Net value of the billing item in document currency	nvarchar	17	0
TOPExternal Services
107	ESKL	Account Assignment Specification: Service Line	10	NETWR	Net Value of Item	decimal	11	2
108	ESKN	Account Assignment in Service Package	9	NETWR	Account Assignment Value	decimal	11	2
109	ESLL	Lines of Service Package	23	NETWR	Net Value of Item	decimal	11	2
110	ESSR	Service Entry Sheet Header Data	39	NETWR	Net Value of Entry Sheet	decimal	11	2
111	TMP_SPEC	Model Service Specifications	21	NETWR	Net Value in Document Currency	decimal	15	2
TOPFinancial Accounting
112	/CCEE/SIFIPE7	Pro forma invoice for temporary export of goods	9	NETWR	Net value of the billing item in document currency	decimal	15	2
TOPFreight Processing
113	VFKN	Account Determination in Shipment Costs Item	8	NETWR	Net value in currency of shipment cost item	decimal	15	2
114	VFKP	Shipment Costs: Item Data	6	NETWR	Net value in currency of shipment cost item	decimal	15	2
115	VFSI	Shipment Costs: Sub-item Data	9	NETWR	Net value of sub-item in currency of shipment cost item	decimal	15	2
TOPIntegration
116	FKK_VBRK_SHORT	Header Data for SD Billing Document - Extracts	20	NETWR	Value of invoice	nvarchar	16	0
117	FKK_VBRP_SHORT	Item Data for SD Billing Document - Extracts	25	NETWR	Net value of the billing item in document currency	decimal	15	2
TOPInventory Management
118	MWXVM07M	Fields: Update Control of Module Pool SAPMM07M	45	NETWR	Net order value in document currency	decimal	13	2
119	MWZVM07M	Fields: Update Control of Module Pool SAPMM07M	45	NETWR	Net order value in document currency	decimal	13	2
TOPInvoice Verification
120	RBDRSEG	Batch IV: Invoice Document Items	34	NETWR	Net order value in document currency	decimal	13	2
121	RBEX	Persistent Key Figures Header and Item	8	NETWR	Net Value in Document Currency	decimal	15	2
TOPLocalization
122	IDGT_INFO	GTI China: Data sent to GT	33	NETWR	Net Value	decimal	17	2
123	J_1BNFLIN	Nota Fiscal line items	25	NETWR	Net Value	decimal	15	2
124	J_3RSCCDITEM	Cargo Customs Declaration Item	9	NETWR	Net Value in Document Currency	decimal	11	2
TOPMarketing Retail Network
125	OIFORCPR	Transfer customer expected price into sales condition record	4	NETWR	Value expected by customer (item value)	nvarchar	4	0
TOPPatient Accounting
126	NVBRK	IS-H: Billing document header data	36	NETWR	Net Value in Document Currency	decimal	15	2
127	NVBRP	IS-H: Billing document item data	11	NETWR	Net value of the billing item in document currency	decimal	15	2
TOPPeriodical Sales and Distribution
128	JFRK	IS-M/SD: Billing - Header Data	36	NETWR	Net Value in Document Currency	decimal	15	2
129	JFRP	IS-M/SD: Billing Document - Item Data	11	NETWR	Net value of the billing item in document currency	decimal	15	2
130	JKAK	Sales Order Header Data	12	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
131	JKEP	Sales Order: Schedule Line Data	25	NETWR	IS-M: Net price in document currency	decimal	15	2
132	JLRK	IS-M/SD: Settlement Header Data	22	NETWR	Net Value in Document Currency	decimal	15	2
133	JLRP	IS-M/SD: Item Data for Settlement	13	NETWR	IS-M: Net Value of Settlement Item in Document Currency	decimal	15	2
134	JVTZAEM2	Sales Order Header Data	14	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
TOPProduction and Revenue Accounting
135	OIUCM_CONTRACT	PRA Contracts	12	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
TOPProfitability Analysis
136	CEERROR	CO-PA: Incorrect records from SD	65	NETWR	Net Value in Document Currency	decimal	15	2
TOPPublic Sector
137	PA0752	HR Master Record: Infotype 0752	44	NETWR	Currency Key	nvarchar	5	0
TOPPurchasing
138	EBKN	Purchase Requisition Account Assignment	53	NETWR	Net Order Value in PO Currency	decimal	13	2
139	EKAB	Release Documentation	9	NETWR	Net Order Value in PO Currency	decimal	13	2
140	EKKN	Account Assignment in Purchasing Document	10	NETWR	Net Order Value in PO Currency	decimal	13	2
141	EKPO	Purchasing Document Item	27	NETWR	Net Order Value in PO Currency	decimal	13	2
142	EREV	Version in Purchasing	19	NETWR	Net Order Value in PO Currency	decimal	13	2
143	WDFR_POS	Perishables Planninng Item	48	NETWR	Net Order Value in PO Currency	decimal	13	2
144	WRF_PRCT_WL_ITEM	Original Table for Worklist Items	19	NETWR	Net Order Value in PO Currency	decimal	13	2
145	WRF_PRCT_WL_SHDW	Shadow Table for Worklist Items	22	NETWR	Net Order Value in PO Currency	decimal	13	2
TOPPurchasing Information System
146	MCEKS	R/2 PURCHIS Data (Status: Last Data Transmission)	21	NETWR	Net purchase order value (base unit)	decimal	15	2
TOPRecycling Administration Core Functions
147	J_7LV1K	REA Document: Header Data	29	NETWR	Net Value in Document Currency	decimal	17	2
148	J_7LV1P	REA Document: Item Data	7	NETWR	Net Value in Document Currency	decimal	17	2
TOPRemaining Beverage - Obsolete Objects
149	/BEV1/RBVBAK	Sales Document: Header Data	17	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
150	/BEV1/RBVBAP	Sales Document: Item Data	44	NETWR	Net value of the order item in document currency	decimal	15	2
151	S468	IS Beverage EM, Purchasing Information System Empties	24	NETWR	Net purchase order value (base unit)	decimal	15	2
TOPSales
152	VBAK	Sales Document: Header Data	17	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
153	VBAP	Sales Document: Item Data	44	NETWR	Net value of the order item in document currency	decimal	15	2
154	VBPV	Sales Document: Product Proposal	25	NETWR	Net value of the order item in document currency	decimal	15	2
155	VKDFS	SD Index: Billing Initiator	17	NETWR	Net Value in Document Currency	decimal	15	2
TOPSAP Healthcare - Industry-Specific Components for Hospitals
156	NLVERP	Rechnungregister-position	11	NETWR		decimal	15	0
157	NWCH80	IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise	29	NETWR	Valore netto nella divisa del documento	decimal	15	2
TOPSelf-Billing Proced.
158	VSBDIT	Self-Billing Procedure Delivery Item w. Automatic Posting	14	NETWR	Net value of the billing item in document currency	decimal	15	2
159	VSBPLG	Processing Log: Self-Billing Procedure w. Autom. Postings	20	NETWR	Net Value in Document Currency	decimal	15	2
TOPSelf-Service Procurement
160	/SRMERP/D_ACC_IT	Account assignment item	7	NETWR	Net Order Value in PO Currency	decimal	13	2
161	/SRMERP/D_SC_ITM	Shopping Cart Item	30	NETWR	Net Value in Document Currency	decimal	15	2
TOPShipping
162	LIKP	SD Document: Delivery Header Data	97	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
163	LIPS	SD document: Delivery: Item data	169	NETWR	Net Value in Document Currency	decimal	15	2
TOPSimulation
164	VSEBKN_CN	Version: Purchase requisition account assignment	54	NETWR	Net Order Value in PO Currency	decimal	13	2
165	VSFPLT_CN	Version: Billing schedule: Dates	38	NETWR	Net value of the order item in document currency	decimal	15	2
166	VSVBAK_CN	Version: Sales document: Header data	18	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
167	VSVBAP_CN	Version: Sales document: Item data	45	NETWR	Net value of the order item in document currency	decimal	15	2
TOPTraders and Schedulers Workbench
168	S431	PURCHIS: (OIL-TSW) Purchasing document stats by TSW object	22	NETWR	Effective order value	decimal	15	2
TOPVehicle Management System
169	VLCBATCHACT	VELO : Variant for Action Execution in Batch	68	NETWR	Net Value of the Sales Order in Document Currency	decimal	15	2
TOPVendor Evaluation
170	EVAL_IV_PERS_ITM	Persistent Key FIgures with Info About Indicator	8	NETWR	Net order value in document currency	decimal	13	2

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

170 columns | ERP 6.0 | NETWR