	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

222 columns | B1 9.2 | BASETYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value	Constraints
TOPFinance
1	AJD2	Withholding Tax - History	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
2	AWHT	Withholding Tax	6	BaseType	Base Type	VarChar	1	0	N	G=Gross, N=Net, V=VAT
3	AWTD	Withholding Tax Definition	9	BaseType	Base Type	VarChar	1	0	N	G=Gross, N=Net, V=VAT
4	BTF2	Journal Voucher Withholding Tax - History	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
5	JDT2	Withholding Tax - History	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
6	JST1	TDS Adjustment - Rows	20	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
7	OWHT	Withholding Tax	6	BaseType	Base Type	VarChar	1	0	N	G=Gross, N=Net, V=VAT
8	OWTD	Withholding Tax Definition	9	BaseType	Base Type	VarChar	1	0	N	G=Gross, N=Net, V=VAT
9	UWTX1	WTax Transactions - Rows	15	BaseType	Base Type	VarChar	1	0	N	G=Gross, N=Net, V=VAT
10	WTX1	WTax Transactions - Rows	15	BaseType	Base Type	VarChar	1	0	N	G=Gross, N=Net, V=VAT
TOPGeneral
11	CIN11	Correction Invoice - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
12	OBVL	Serial Numbers and Batch Valuation Log	5	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
13	UBVL	Serial Numbers and Batch Valuation Log	5	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
TOPInventory and Production
14	AQR1	Inventory Posting - Rows	34	BaseType	Base Document Type	Int	11	0	1470000065	1470000065=Inventory Counting
15	IGE1	Goods Issue - Rows	6	BaseType	Base Document Type	Int	11	0	-1	202=Production Order
16	IGE11	Goods Issue - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
17	IGE13	Goods Issue Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
18	IGE3	Goods Issue - Freight	41	BaseType	Base Document Type	Int	11	0	-1	202=Production Order
19	IGE4	Goods Issue - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
20	IGE5	Goods Issue - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
21	IGN1	Goods Receipt - Rows	6	BaseType	Base Document Type	Int	11	0	-1	202=Production Order
22	IGN11	Goods Receipt - Drawn Dpm Det	5	BaseType	Base Object Type	Int	11	0	-1
23	IGN13	Goods Receipt Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
24	IGN3	Goods Receipt - Freight	41	BaseType	Base Document Type	Int	11	0	-1	202=Production Order
25	IGN4	Goods Receipt - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
26	IGN5	Goods Receipt - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
27	ILM3	Non-Inventory and Resource Components Log Msg	11	BaseType	Base Transaction Type	Int	11	0	-1	60=Goods Issue
28	IPD1	Inventory Posting Draft - Rows	34	BaseType	Base Document Type	Int	11	0	1470000065	1470000065=Inventory Counting
29	IPF1	Landed Costs - Rows	3	BaseType	Base Document Type	Int	11	0	-1	18=A/P Invoice, 20=Goods Receipt PO, 69=Landed Costs
30	IQR1	Inventory Posting - Rows	34	BaseType	Base Document Type	Int	11	0	1470000065	1470000065=Inventory Counting
31	OAIM	Archive Inventory Message	12	BaseType	Base Transaction Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
32	OILM	Inventory Log Message	13	BaseType	Base Transaction Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
33	OIMT	Templates for Inventory JE	3	BaseType	Base Transaction Type	Int	6	0	-1
34	OITL	Inventory Transactions Log	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
35	ORTL	Resource Transaction Log	6	BaseType	Base Document Type	Int	11	0
36	UILM	IVI Inventory Log Message	13	BaseType	Base Transaction Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat
37	UILM3	Non-Inventory and Resource Components Log Msg	11	BaseType	Base Transaction Type	Int	11	0	-1	60=Goods Issue
38	WTQ1	Inventory Transfer Request - Rows	6	BaseType	Base Document Type	Int	11	0	-1	20=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouse Transfers
39	WTQ11	Inv. Transfer Request - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	-1
40	WTQ13	Inventory Transfer Request Rows - Distributed Freights	41	BaseType	Base Document Type	Int	11	0
41	WTQ3	Inventory Transfer Request - Freight	41	BaseType	Base Document Type	Int	11	0	-1	20=Goods Receipt PO, 59=Goods Receipt
42	WTQ4	Inventory Transfer Request - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
43	WTQ5	Inventory Transfer Request - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
44	WTR1	Inventory Transfer - Rows	6	BaseType	Base Document Type	Int	11	0	-1	1250000001=Inventory Transfer Request, 20=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouses Transfers
45	WTR11	Inv. Transfer - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	-1
46	WTR13	Inventory Transfer Rows - Distributed Freights	41	BaseType	Base Document Type	Int	11	0
47	WTR3	Inventory Transfer - Freight	41	BaseType	Base Document Type	Int	11	0	-1	1250000001=Inventory Transfer Request, 20=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer
48	WTR4	Inventory Transfer - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
49	WTR5	Inventory Transfer - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
TOPMarketing Documents
50	ADO1	A/R Invoice (Rows) - History	6	BaseType	Base Document Type	Int	11	0	-1	13=Invoices, 15=Delivery notes, 16=A/R Returns, 17=Sales Order, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase orders, 23=Sales Quotation
51	ADO11	A/R Inv (Drawn Dpm Det) - Hist	5	BaseType	Base Object Type	Int	11	0	-1
52	ADO13	A/R Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
53	ADO20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
54	ADO3	A/R Invoice - Freight - History	41	BaseType	Base Document Type	Int	11	0	-1	13=Invoices, 15=Delivery notes, 16=Revert Delivery Notes, 17=Orders, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase orders, 23=Quotations
55	ADO4	Documents - Tax - History	25	BaseType	Base Document Type	Int	11	0	-1
56	ADO5	Withholding Tax - History	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
57	CIN1	Correction Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	16=A/R Returns, 17=Sales Order, 23=Sales Quotation
58	CIN13	Correction Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
59	CIN20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
60	CIN3	A/R Correction Invoice - Freight	41	BaseType	Base Document Type	Int	11	0	-1	16=A/R Returns, 17=Sales Order, 23=Sales Quotation
61	CIN4	Correction Invoice - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
62	CIN5	AR Correction Invoice - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
63	CPI1	A/P Correction Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	163=A/P Correction Invoice, 18=A/P Invoice
64	CPI11	A/P Corr. Inv - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	-1
65	CPI13	A/P Correction Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
66	CPI20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
67	CPI3	A/P Correction Invoice - Freight	41	BaseType	Base Document Type	Int	11	0		163=A/P Correction Invoice, 18=A/P Invoice
68	CPI4	A/P Correction Invoice - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
69	CPI5	Withholding Tax Data	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
70	CPV1	A/P Correction Invoice Reversal - Rows	6	BaseType	Base Document Type	Int	11	0	-1	163=A/P Correction Invoice
71	CPV11	A/P CrIn Rev - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	-1
72	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
73	CPV20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
74	CPV3	A/P Correction Invoice Reversal - Freight	41	BaseType	Base Document Type	Int	11	0		163=A/P Correction Invoice
75	CPV4	A/P Correction Invoice Reversal - Tax Amt per Doc.	25	BaseType	Base Document Type	Int	11	0	-1
76	CPV5	A/P Correction Invoice Reversal - WTax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
77	CSI1	A/R Correction Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 165=A/R Correction Invoice
78	CSI11	A/R Corr. Inv. - Drawn Dpm Det	5	BaseType	Base Object Type	Int	11	0	-1
79	CSI13	A/R Correction Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
80	CSI20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
81	CSI3	A/R Correction Invoice - Freight	41	BaseType	Base Document Type	Int	11	0		13=A/R Invoice, 165=A/R Correction Invoice
82	CSI4	A/R Correction Invoice - Tax Amount Per Document	25	BaseType	Base Document Type	Int	11	0	-1
83	CSI5	A/R Correction Invoice - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
84	CSV1	A/R Correction Invoice Reversal - Rows	6	BaseType	Base Document Type	Int	11	0	-1	165=A/R Correction Invoice
85	CSV11	A/R CrIn Rev - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	-1
86	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
87	CSV20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
88	CSV3	A/R Correction Invoice Reversal - Freight	41	BaseType	Base Document Type	Int	11	0		165=A/R Correction Invoice
89	CSV4	A/R Correction Invoice Reversal - Tax Amount Per Document	25	BaseType	Base Document Type	Int	11	0	-1
90	CSV5	A/R Correction Invoice Reversal - WTax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
91	DLN1	Delivery - Rows	6	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery, 165=A/R Correction Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
92	DLN11	Delivery - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
93	DLN13	Delivery Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
94	DLN20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
95	DLN3	Delivery Notes - Freight	41	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
96	DLN4	Delivery - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
97	DLN5	Delivery - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
98	DOC20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
99	DPI1	A/R Down Payment - Rows	6	BaseType	Base Document Type	Int	11	0	-1	15=Delivery, 17=Sales Order, 203=A/R Down Payment, 23=Quotation
100	DPI11	A/R DP - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
101	DPI13	A/R Down Payment Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
102	DPI20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
103	DPI3	A/R Down Payment - Freight	41	BaseType	Base Document Type	Int	11	0	-1	15=Delivery, 17=Sales Order, 23=Sales Quotation
104	DPI4	A/R Down Payment - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
105	DPI5	A/R Down Payment - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
106	DPO1	A/P Down Payment - Rows	6	BaseType	Base Document Type	Int	11	0	-1	204=A/P Down Payment, 20=Goods Receipt PO, 22=Purchase Order, 540000006=Purchase Quotation
107	DPO11	A/P DP - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
108	DPO13	A/P Down Payment Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
109	DPO20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
110	DPO3	A/P Down Payment - Freight	41	BaseType	Base Document Type	Int	11	0	-1	20=Goods Receipt PO, 22=Purchase orders
111	DPO4	A/P Down Payment - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
112	DPO5	A/P Down Payment - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
113	DRF1	Draft - Rows	6	BaseType	Base Document Type	Int	11	0	-1	1250000001=Inventory Transfers Request, 132=Correction Invoice, 13=A/R Invoice, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A
114	DRF11	Draft - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
115	DRF13	Draft Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
116	DRF20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 1470000113=Purchase Request, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
117	DRF3	Draft - Freight	41	BaseType	Base Document Type	Int	11	0		13=A/R Invoice, 1470000113=Purchase Request, 15=Delivery notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Good Receipt PO, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 540000006=Purchase Quotation
118	DRF4	Draft Documents - Tax	25	BaseType	Base Document Type	Int	11	0	-1
119	DRF5	Draft Documents - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
120	GPA1	Gross Profit Adjustment - Documents	30	BaseType	Base Type	nVarChar	20	0
121	IEI1	Incoming Excise Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	140000009=Outgoing Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 16=A/R Returns, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return
122	IEI11	IEI - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
123	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
124	IEI20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
125	IEI3	IEI - Freight	41	BaseType	Base Document Type	Int	11	0	-1
126	IEI4	Incoming Excise Invoice - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
127	IEI5	Incoming Excise Invoice - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
128	IGE20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
129	IGN20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
130	INV1	A/R Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	13=Invoice, 15=Delivery, 17=Sales Order, 23=Sales Quotation
131	INV11	A/R Invoice - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	203	203=A/R Down Payment
132	INV13	A/R Invoice Rows - Distributed Freights	41	BaseType	Base Document Type	Int	11	0
133	INV20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
134	INV3	A/R Invoice - Freight	41	BaseType	Base Document Type	Int	11	0	-1	15=Delivery, 17=Sales Order, 23=Sales Quotation
135	INV4	A/R Invoice - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
136	INV5	A/R Invoice - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
137	OEI1	Outgoing Excise Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	14=A/R Credit Memo, 15=Delivery, 16=A/R Returns, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return, 67=Inventory Transfers
138	OEI11	OEI - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
139	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
140	OEI20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
141	OEI3	OEI - Freight	41	BaseType	Base Document Type	Int	11	0	-1
142	OEI4	Outgoing Excise Invoice - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
143	OEI5	Outgoing Excise Invoice - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
144	PCH1	A/P Invoice - Rows	6	BaseType	Base Document Type	Int	11	0	-1	18=A/P Invoice, 20=Goods Receipt PO, 22=Purchase Orders, 540000006=Purchase Quotation, 69=Landed Costs
145	PCH11	A/P Invoice - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	204	204=A/P Down Payment
146	PCH13	A/P Invoice Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
147	PCH20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
148	PCH3	A/P Invoice - Freight	41	BaseType	Base Document Type	Int	11	0	-1	20=Goods Receipt PO, 22=Purchase orders
149	PCH4	A/P Invoice - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
150	PCH5	A/P Invoice - Withholding Tax Data	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
151	PDN1	Goods Receipt PO - Rows	6	BaseType	Base Document Type	Int	11	0	-1	163=A/P Correction Invoice, 18=A/P Invoice, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Orders, 540000006=Purchase Quotation
152	PDN11	GRPO - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
153	PDN13	Goods Receipt PO Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
154	PDN20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
155	PDN3	Goods Receipt PO - Freight	41	BaseType	Base Document Type	Int	11	0	-1	18=A/P Invoice, 21=Goods Return, 22=Purchase orders
156	PDN4	Goods Receipt PO - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
157	PDN5	Goods Reciept PO - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
158	POR1	Purchase Order - Rows	6	BaseType	Base Document Type	Int	11	0	-1	1470000113=Purchase Request, 17=Sales Order, 22=Purchase Orders, 23=Sales Quotation, 540000006=Purchase Quotation
159	POR11	PO - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
160	POR13	Purchase Order Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
161	POR20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 1470000113=Purchase Request, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
162	POR3	Purchase Order - Freight	41	BaseType	Base Document Type	Int	11	0	-1	1470000113=Purchase Request, 17=Sales Order
163	POR4	Purchase Order - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
164	POR5	Purchase Order - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
165	PQT1	Purchase Quotation - Rows	6	BaseType	Base Document Type	Int	11	0	-1	1470000113=Purchase Request, 17=Sales Order, 23=Sales Quotation
166	PQT11	PQ - Drawn DPM Detail	5	BaseType	Base Object Type	Int	11	0	-1
167	PQT13	Purchase Quotation Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
168	PQT20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
169	PQT3	Purchase Quotation - Freight	41	BaseType	Base Document Type	Int	11	0	-1	17=Sales Order
170	PQT4	Purchase Quotation - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
171	PQT5	Purchase Quotation - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
172	PRQ1	Purchase Request - Rows	6	BaseType	Base Document Type	Int	11	0	-1	17=Sales Order, 23=Sales Quotation
173	PRQ11	PR - Drawn DPM Detail	5	BaseType	Base Object Type	Int	11	0	-1
174	PRQ13	Purchase Request Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
175	PRQ20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
176	PRQ3	Purchase Request - Freight	41	BaseType	Base Document Type	Int	11	0	-1	17=Sales Order
177	PRQ4	Purchase Request - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
178	PRQ5	Purchase Request - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
179	QUT1	Sales Quotation - Rows	6	BaseType	Base Document Type	Int	11	0	-1
180	QUT11	Sls Quote - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
181	QUT13	Sales Quotation Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
182	QUT20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
183	QUT3	Sales Quotation - Freight	41	BaseType	Base Document Type	Int	11	0	-1
184	QUT4	Sales Quotation - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
185	QUT5	Sales Quotation - Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
186	RDN1	Returns - Rows	6	BaseType	Base Document Type	Int	11	0	-1	15=A/R Delivery Note, 16=A/R Returns
187	RDN11	Returns - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
188	RDN13	Returns Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
189	RDN20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
190	RDN3	Return - Freight	41	BaseType	Base Document Type	Int	11	0	-1	15=Delivery
191	RDN4	Returns - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
192	RDN5	Returns - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
193	RDR1	Sales Order - Rows	6	BaseType	Base Document Type	Int	11	0	-1	23=Sales Quotation
194	RDR11	Sls Ord. - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
195	RDR13	Sales Order Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
196	RDR20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
197	RDR3	Sales Order - Freight	41	BaseType	Base Document Type	Int	11	0	-1	23=Sales Quotation
198	RDR4	Sales Order - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
199	RDR5	Sales Order - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
200	RIN1	A/R Credit Memo - Rows	6	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 14=A/R Credit Note, 16=A/R Returns, 203=A/R Down Payment
201	RIN11	A/R Cr. Memo - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	203	203=A/R Down Payment
202	RIN13	A/R Credit Memo Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
203	RIN20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
204	RIN3	A/R Credit Memo - Freight	41	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment
205	RIN4	A/R Credit Memo - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
206	RIN5	A/R Credit Memo - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
207	RPC1	A/P Credit Memo - Rows	6	BaseType	Base Document Type	Int	11	0	-1	18=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment, 21=Goods Return
208	RPC11	A/P Cr. Memo - Drawn Dpm Det.	5	BaseType	Base Object Type	Int	11	0	204	204=A/P Down Payment
209	RPC13	A/P Credit Memo Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
210	RPC20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
211	RPC3	A/P Credit Memo - Freight	41	BaseType	Base Document Type	Int	11	0	-1	18=A/P Invoice, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return
212	RPC4	A/P Credit Memo - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
213	RPC5	A/P Credit Memo - Withholding Tax	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
214	RPD1	Goods Return - Rows	6	BaseType	Base Document Type	Int	11	0	-1	20=Purchase Delivery Notes, 21=Goods Return
215	RPD11	Gds Return - Drawn Dpm Detail	5	BaseType	Base Object Type	Int	11	0	-1
216	RPD13	Goods Returns Rows - Distributed Expenses	41	BaseType	Base Document Type	Int	11	0
217	RPD20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
218	RPD3	Goods Return - Freight	41	BaseType	Base Document Type	Int	11	0	-1	20=Purchase Delivery Notes
219	RPD4	Goods Return - Tax Amount per Document	25	BaseType	Base Document Type	Int	11	0	-1
220	RPD5	Goods Return - Withholding Tax Data	18	BaseType	Base Type	VarChar	1	0		G=Gross, N=Net, V=VAT
221	WTQ20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation
222	WTR20	Intrastat Expenses	12	BaseType	Base Document Type	Int	11	0	-1	13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation

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

222 columns | B1 9.2 | BASETYPE