SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

14 columns | B1 9.3 | ACTIONTYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value	Constraints
TOPGeneral
1	AHF1	Hide Functions Configuration - Rows History	9	ActionType	Hide Item Action Type	Int	6	0	0	0=Hide Item, 1=Hide Column, 2=Hide Item's Valid Value, 3=Hide Panel, 4=Hide Column's Valid Value
2	AHF2	Hide Function Configuration - Rows History	5	ActionType	Action Type	Int	6	0	0	0=Hide Menu, 1=Move Menu, 2=Hide Pop-Up Menu
3	HFC1	Hide Function Configuration - Rows	9	ActionType	Hide Item Action Type	Int	6	0	0	0=Hide Item, 1=Hide Column, 2=Hide Item's Valid Value, 3=Hide Panel, 4=Hide Column's Valid Value
4	HFC2	Hide Function Configuration - Rows	5	ActionType	Action Type	Int	6	0	0	0=Hide Menu, 1=Move Menu, 2=Hide Pop-Up Menu
5	OBVL	Serial Numbers and Batch Valuation Log	6	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA
6	ORCJ	Resource Capacity Log	13	ActionType	Action Type	Int	6	0	-1	10=Sales Order - Close, 11=Sales Order - Cancel, 12=Sales Order - Add Line, 13=Sales Order - Delete Line, 14=Sales Order - Update Line, 15=Delivery - Create, 16=Delivery - Close, 17=Delivery - Cancel, 18=A/R Invoice - Create, 19=A/R Invoice - Cancel, 1=Production Order - Create, 20=A/R Credit Memo - Create, 21=A/R Credit Memo - Cancel, 22=
7	OUAL	User Action Log	5	ActionType	Action Type	VarChar	1	0
8	UBVL	Serial Numbers and Batch Valuation Log	6	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA
TOPInventory and Production
9	OAIM	Archive Inventory Message	15	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA
10	OILM	Inventory Log Message	17	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA
11	ORTL	Resource Transaction Log	9	ActionType	Action Type	Int	11	0	0	0=RESOURCE_TRANSACTION_UNKNOWN, 1=RESOURCE_TRANSACTION_IN, 2=RESOURCE_TRANSACTION_OUT
12	OTNL	CCD Log	13	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA
13	UILM	IVI Inventory Log Message	17	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA
TOPMarketing Documents
14	GPA1	Gross Profit Adjustment - Documents	27	ActionType	Action Type	Int	11	0	5	0=TRANSACTION_UNKNOWN, 10=TRANSACTION_CLOSE_OUT, 11=TRANSACTION_NEGATIVE_REVALUATION, 12=TRANSACTION_NULLIFY, 13=TRANSACTION_RESERVE_CI_IN, 14=TRANSACTION_RESERVE_CI_OUT, 15=TRANSACTION_RESERVE_CI_REVAL_INC, 16=TRANSACTION_RESERVE_CI_REVAL_DEC, 17=TRANSACTION_REVAL_PRICE_CHANGE_INCREASE, 18=TRANSACTION_REVAL_PRICE_CHANGE_DECREASE, 1=TRANSA