	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

104 columns | ERP 6.0 | AKTNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000183000	PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item	34	AKTNR		nvarchar	10	0
2	/BIC/B0000185000	PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item	25	AKTNR		nvarchar	10	0
3	/BIC/B0000186000	PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.	24	AKTNR		nvarchar	10	0
4	/BIC/B0000187000	PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)	28	AKTNR		nvarchar	10	0
5	/BIC/B0000189000	PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line	28	AKTNR		nvarchar	10	0
6	CNVTDMS_05_WAKHI	Collector Table for Entries in Table WAKHIND	4	AKTNR	Action for CNVTDMS_05_*	nvarchar	10	0
7	DMF_D_PROMO	Transferred promotions	3	AKTNR	Promotion	nvarchar	10	0
8	REFXCN_PROMCAT	Promotional Data	2	AKTNR	Promotion	nvarchar	10	0
9	ZEIM_LIPS	SD document: Delivery: Item data	152	AKTNR	Promotion	nvarchar	10	0
TOPAgency Business Global Trade
10	WBRP	Agency business: Item	59	AKTNR	Promotion	nvarchar	10	0
TOPAllocation
11	AUBSI	Worklist for PO (Follow-on Document Generation)	33	AKTNR	Promotion	nvarchar	10	0
12	AUKAI	Worklist for Sales Orders (FBG)	25	AKTNR	Promotion	nvarchar	10	0
13	AUPO	Allocation Table Document Item	18	AKTNR	Promotion	nvarchar	10	0
14	AUUMI	Worklist for Stock Transport Orders (Follow-on Doc. Gen.)	32	AKTNR	Promotion	nvarchar	10	0
15	AUVDI	Worklist for Deliveries (Follow-on Doc. Generation)	46	AKTNR	Promotion	nvarchar	10	0
TOPBilling
16	VBRP	Billing Document: Item Data	131	AKTNR	Promotion	nvarchar	10	0
TOPCollectionsDisbursements
17	TKKVMAKT	Dunning Activities	4	AKTNR	Activity Number of a Dunning Level	nvarchar	3	0
18	VVKKMAKT	Executed Dunning Activities	7	AKTNR	Activity Number of a Dunning Level	nvarchar	3	0
TOPConditions
19	KONA	Agreements	40	AKTNR	Promotion	nvarchar	10	0
20	KONH	Conditions (Header)	18	AKTNR	Promotion	nvarchar	10	0
21	KONP	Conditions (Item)	52	AKTNR	Promotion	nvarchar	10	0
TOPConsumption-Based Planning See Also PP-MRP
22	WSAF_PROMO_DELTA	Change Information for Promotions	3	AKTNR	Promotion	nvarchar	10	0
TOPCross-Application Components
23	FRE_DB_ABI_HEAD	Header table for DIF occurrence	2	AKTNR	Promotion	nvarchar	10	0
24	FRE_DB_ABI_POS	Item table for DIF occurrence	2	AKTNR	Promotion	nvarchar	10	0
TOPData Collection
25	S086	Promotion	8	AKTNR	Promotion	nvarchar	10	0
26	S086E	S086 - Structural Information	3	AKTNR	Promotion	nvarchar	10	0
27	S117	Receipt/article	29	AKTNR	Promotion	nvarchar	10	0
28	S120	Sales as per receipts	31	AKTNR	Promotion	nvarchar	10	0
29	S120BIW1	S120BIW1 * Sales as Per Receipts	31	AKTNR	Promotion	nvarchar	10	0
30	S120BIW2	S120BIW2 * Sales as Per Receipts	31	AKTNR	Promotion	nvarchar	10	0
31	S121	Material aggregation - POS	11	AKTNR	Promotion	nvarchar	10	0
32	S121E	S121 - Structural Information	6	AKTNR	Promotion	nvarchar	10	0
33	S270	Do not use!	43	AKTNR	Promotion	nvarchar	10	0
34	S270BIW1	Do not use!	43	AKTNR	Promotion	nvarchar	10	0
35	S270BIW2	Do not use!	43	AKTNR	Promotion	nvarchar	10	0
36	S271	Do not use!	24	AKTNR	Promotion	nvarchar	10	0
37	S271BIW1	Do not use!	24	AKTNR	Promotion	nvarchar	10	0
38	S271BIW2	Do not use!	24	AKTNR	Promotion	nvarchar	10	0
39	S272	Do not use!	42	AKTNR	Promotion	nvarchar	10	0
40	S272BIW1	Do not use!	42	AKTNR	Promotion	nvarchar	10	0
41	S272BIW2	Do not use!	42	AKTNR	Promotion	nvarchar	10	0
42	S273	Do not use!	25	AKTNR	Promotion	nvarchar	10	0
43	S273BIW1	Do not use!	25	AKTNR	Promotion	nvarchar	10	0
44	S273BIW2	Do not use!	25	AKTNR	Promotion	nvarchar	10	0
45	S275	Transfer BW: Einkaufsdaten	33	AKTNR	Actie	nvarchar	10	0
46	S275BIW1	S275BIW1 * Transfer to BW: Purchasing Data	33	AKTNR	Promotion	nvarchar	10	0
47	S275BIW2	S275BIW2 * Transfer to BW: Purchasing Data	33	AKTNR	Promotion	nvarchar	10	0
48	S276	Transfer BW: Vertriebsdaten	29	AKTNR	Actie	nvarchar	10	0
49	S276BIW1	S276BIW1 * Transfer to BW: Sales and Distribution Data	29	AKTNR	Promotion	nvarchar	10	0
50	S276BIW2	S276BIW2 * BW Transfer: Sales and Distribution Data	29	AKTNR	Promotion	nvarchar	10	0
51	S277	Transfer BW: VP-Umbewertung	25	AKTNR	Actie	nvarchar	10	0
52	S277BIW1	S277BIW1 * Transfer to BW: Revaluation at Retail	25	AKTNR	Promotion	nvarchar	10	0
53	S277BIW2	S277BIW2 * Transfer to BW: Revaluation at Retail	25	AKTNR	Promotion	nvarchar	10	0
54	S279	Transfer BW: Bestandsführung	24	AKTNR	Actie	nvarchar	10	0
55	S279BIW1	S279BIW1 * BW Transfer: Inventory Management	24	AKTNR	Promotion	nvarchar	10	0
56	S279BIW2	S279BIW2 * BW Transfer: Inventory Management	24	AKTNR	Promotion	nvarchar	10	0
57	S953	BW Vorl.für BON/Artikel S117	29	AKTNR	Aktion	nvarchar	10	0
TOPDefense Forces and Public Security
58	/ISDFPS/ZEBAN	Copy of EBAN	81	AKTNR	Promotion	nvarchar	10	0
TOPFree Goods
59	KONBBYH	Bonus Buys: Header	14	AKTNR	Promotion	nvarchar	10	0
TOPInventory Management
60	MSEG	Document Segment: Material	139	AKTNR	Promotion	nvarchar	10	0
61	MWXMSEG	ZMSEG: Interface for Posting of Value	139	AKTNR	Promotion	nvarchar	10	0
62	MWZMSEG	ZMSEG:Interface for Posting of Value	139	AKTNR	Promotion	nvarchar	10	0
63	USEG	Retail Revaluation Document: Revaluation Segment	21	AKTNR	Promotion	nvarchar	10	0
TOPInvoice Verification
64	RBDRSEG	Batch IV: Invoice Document Items	82	AKTNR	Promotion	nvarchar	10	0
TOPMaterials Management
65	/ISDFPS/CS_EXLST	Exception List: Overwritten Purchase Requisitions	86	AKTNR	Promotion	nvarchar	10	0
TOPMerchandise and Assortment Planning
66	TWISPS_NOPROMO1	Parameters for Promotions Created in MAP	2	AKTNR	Promotion	nvarchar	10	0
TOPPerishables Procurement
67	FIP_D_PROMO	Promotion data	3	AKTNR	Promotion	nvarchar	10	0
68	FIP_D_PROMO_T	Promotion data Texts	2	AKTNR	Promotion	nvarchar	10	0
TOPPOS Interface
69	WVFB	DRS Interface, Intermediate Buffer, Order Item FM	31	AKTNR	Promotion	nvarchar	10	0
TOPPrice Planning Workbench
70	WRF_PPW_PPDHEAD	PPD Header	7	AKTNR	Promotion Number	nvarchar	10	0
TOPProduct Catalog
71	WWMI	Product catalog	4	AKTNR	Promotion	nvarchar	10	0
TOPPromotion
72	WAAL	Material-to-vendor assignment in price maintenance (promo.)	2	AKTNR	Promotion	nvarchar	10	0
73	WAEL	Delivery Phases in Retail Promotion	2	AKTNR	Promotion	nvarchar	10	0
74	WAGU	Validity of plant groups - IS-R	2	AKTNR	Promotion	nvarchar	10	0
75	WAKC	Assignment of Coupons to Promotion	2	AKTNR	Promotion	nvarchar	10	0
76	WAKH	Promotion Header Data, IS-R	2	AKTNR	Promotion	nvarchar	10	0
77	WAKHIND	Promotion header data IS-R: index table for conditions	3	AKTNR	Promotion	nvarchar	10	0
78	WAKP	Promotion Item Data	2	AKTNR	Promotion	nvarchar	10	0
79	WAKR	Promotion Discounts	2	AKTNR	Promotion	nvarchar	10	0
80	WAKRW	Promotion discounts by plant	2	AKTNR	Promotion	nvarchar	10	0
81	WAKT	Promotion description short text, IS-R	2	AKTNR	Promotion	nvarchar	10	0
82	WALE	Material to store assignment to promotion	2	AKTNR	Promotion	nvarchar	10	0
83	WARNG	Saving of RANGES	2	AKTNR	Promotion	nvarchar	10	0
84	WAZB	Module plant-group assignment	2	AKTNR	Promotion	nvarchar	10	0
85	WAZT	Promotion/themes assignment	2	AKTNR	Promotion	nvarchar	10	0
86	WAZW	Promotion/advertising media assignment	2	AKTNR	Promotion	nvarchar	10	0
87	WMATSITEQTYTIME	Material Quantities in Sites for Promotion Periods	2	AKTNR	Promotion	nvarchar	10	0
88	WMFP	Markdown Planning - item data (materials)	12	AKTNR	Promotion	nvarchar	10	0
89	WRF_DISPRO_DF_Q	Worklist for Assignm of TD Promo Data after Changes to Promo	2	AKTNR	Promotion	nvarchar	10	0
90	WRF_DISPRO_QUEUE	Worklist After Changes to Promotions	2	AKTNR	Promotion	nvarchar	10	0
91	WRF_DISPRO_TD	Time-Dependent Data for Promotions	2	AKTNR	Promotion	nvarchar	10	0
92	WRF_RPR_WAPG	Assignment of Plant Grouping to Local Plant Group No.	2	AKTNR	Promotion	nvarchar	10	0
93	WRF_RPR_WAPGT	Plant Group Descr. Short Text	2	AKTNR	Promotion	nvarchar	10	0
94	WRF_RPR_WAPL	Assignment of Plants to Local Plant Groups	2	AKTNR	Promotion	nvarchar	10	0
TOPPurchasing
95	EBAN	Purchase Requisition	81	AKTNR	Promotion	nvarchar	10	0
96	EKPO	Purchasing Document Item	133	AKTNR	Promotion	nvarchar	10	0
97	MEREQX	Purchase Requisition Change Parameter	81	AKTNR	Updated information in related user data field	nvarchar	1	0
98	WDFR1	Requirements Planning for Perishables	46	AKTNR	Promotion	nvarchar	10	0
99	WRF_POHF_POL	Order list	29	AKTNR	Promotion	nvarchar	10	0
TOPRemaining Beverage - Obsolete Objects
100	/BEV1/RBKP	Copy Table for KONP for Accrual (Field KBRUE)	52	AKTNR	Promotion	nvarchar	10	0
TOPRetail Enterprise Services
101	WESD_BBY_SENT	Bonus Buy: Stores Supplied via Service	6	AKTNR	Promotion	nvarchar	10	0
102	WESD_PROMO_SENT	Retail Promotion: Stores Supplied via Service	4	AKTNR	Promotion	nvarchar	10	0
TOPShipping
103	LIPS	SD document: Delivery: Item data	152	AKTNR	Promotion	nvarchar	10	0
TOPSimulation
104	VSEBAN_CN	Version: Purchase requisition	81	AKTNR	Promotion	nvarchar	10	0

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

104 columns | ERP 6.0 | AKTNR