	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

67 columns | ERP 6.0 | LINE_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	DIAN_A_1001_08	Cached Data of DIAN Format 1001 version 08	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
2	DIAN_A_1003_07	Cached Data of DIAN Format 1003 version 07	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
3	DIAN_A_1005_07	Cached Data of DIAN Format 1005 version 07	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
4	DIAN_A_1006_07	Cached Data of DIAN Format 1006 version 07	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
5	DIAN_A_1007_08	Cached Data of DIAN Format 1007 version 08	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
6	DIAN_A_1008_07	Cached Data of DIAN Format 1003 version 07	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
7	DIAN_A_1009_07	Cached Data of DIAN Format 1009 version 07	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
8	DIAN_A_EXTRACT	Cached Extraction of DIAN Report	5	LINE_ID	Globally Unique Identifier	varbinary	16	0
9	DIAN_A_EXTR_INFO	Documents information related to the extracted DIAN data	2	LINE_ID	Globally Unique Identifier	varbinary	16	0
10	DIAN_A_TFORMAT	Testing table for Cached Data of DIAN Formats	3	LINE_ID	Globally Unique Identifier	varbinary	16	0
11	DIAN_C_ACCOUNTS	DIAN Accounts	5	LINE_ID	Globally Unique Identifier	varbinary	16	0
12	DIAN_C_VAT_1001	Additional VAT Settings for Format 1001	5	LINE_ID	Globally Unique Identifier	varbinary	16	0
13	DIAN_C_VAT_CONST	VAT Concept Settings	5	LINE_ID	Globally Unique Identifier	varbinary	16	0
14	DIAN_C_VAT_FORST	DIAN VAT Format Settings	4	LINE_ID	Globally Unique Identifier	varbinary	16	0
15	DIAN_C_WTH	DIAN Withholding Tax	5	LINE_ID	Globally Unique Identifier	varbinary	16	0
16	DIAN_C_WTH_1001	Additional Withholding Settings for Format 1001	5	LINE_ID	Globally Unique Identifier	varbinary	16	0
17	DVM_BOF_STATS	Business Objects Footprint statistics	3	LINE_ID	GUID in 'RAW' format	varbinary	16	0
18	J_3RFIMCD_MOVE	Cross company transfer. Import Customs Declaration	5	LINE_ID	Cross-Company Movement ID for Import Customs Declaration	nvarchar	5	0
TOPAccounting Engine
19	/EACC/CONFIGS_LI	Configurations	6	LINE_ID	Field Name	nvarchar	30	0
TOPBasic Functions
20	EMMAC_CCAT_CND	Conditions for Case Determination or Priority	5	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
TOPBusiness Process Engine
21	SWFBRULECOM	BAM: Client-Specific Conditions	7	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
22	SWFBRULECOU	BAM: Cross-Client Condition	6	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
TOPClassification System New
23	CHARACTERTEXT	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
24	CHARACTERTEXTH	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
25	CME_ST_R3_DEP	CME Characteristic: Object Dependencies for R/3 Characterstc	14	LINE_ID	Row Key	nvarchar	5	0
26	CME_ST_R3_DEPH	CME Characteristic: Object Dependencies for R/3 Characterstc	14	LINE_ID	Row Key	nvarchar	5	0
27	CME_ST_REF	Characteristic: Data Reference	17	LINE_ID	Row Key	nvarchar	5	0
28	CME_ST_REFH	Characteristic: Data Reference	17	LINE_ID	Row Key	nvarchar	5	0
29	CME_ST_VALUE	CME Data Type: Values	3	LINE_ID	Row Key	nvarchar	5	0
30	CME_ST_VALUEH	CME Data Type: Values	4	LINE_ID	Row Key	nvarchar	5	0
31	CME_ST_VAL_TXT	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
32	CME_ST_VAL_TXTH	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
33	DEFSCOPETEXT	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
34	DEFSCOPETEXTH	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
35	DTYPETEXT	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
36	DTYPETEXTH	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
TOPConfirmations
37	AFFW	Goods Movements with Errors from Confirmations	75	LINE_ID	Unique identification of document line	nvarchar	6	0
TOPEvent Management
38	/SAPTRX/CONDDATA	Condition data table	5	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
TOPFunds Management
39	FMFGF2EDPRF	Edit 8- SF 133 Proof Edit (FACTS II)	2	LINE_ID	SF 133 Line ID	nvarchar	4	0
TOPHydrocarbon Product Management
40	MSEGO1	Quantity Conversion Parameters for Material Documents	5	LINE_ID	Unique identification of document line	nvarchar	6	0
41	MSEGO2	Material Document Quantities in Additional Units of Measure	6	LINE_ID	Unique identification of document line	nvarchar	6	0
42	OIB_MIGO_HQCI	Store the QCI-GOITEM for MIGOs hold/restore feature	2	LINE_ID	Unique identification of document line	nvarchar	6	0
43	OIB_MIGO_HQCI_E	Store the QCI-GOITEM-Bapiret for MIGOs hold/restore feature	2	LINE_ID	Unique identification of document line	nvarchar	6	0
44	OIB_MIGO_HQCI_P	Store the QCI-GOITEM-Parameter for MIGOs hold/restore featur	2	LINE_ID	Unique identification of document line	nvarchar	6	0
45	OIB_MIGO_HQCI_Q	Store the QCI-GOITEM-Quantity for MIGOs hold/restore feature	2	LINE_ID	Unique identification of document line	nvarchar	6	0
46	OIB_MIGO_HTST	Store the TST-GOITEM for MIGOs hold/restore feature	2	LINE_ID	Unique identification of document line	nvarchar	6	0
TOPInventory Management
47	MSEG	Document Segment: Material	5	LINE_ID	Unique identification of document line	nvarchar	6	0
48	MWXMSEG	ZMSEG: Interface for Posting of Value	5	LINE_ID	Unique identification of document line	nvarchar	6	0
49	MWZMSEG	ZMSEG:Interface for Posting of Value	5	LINE_ID	Unique identification of document line	nvarchar	6	0
TOPLocal Event Infrastructure
50	SLEI_CONDITION	LEI conditions - Cross client	3	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
51	SLEI_CONDITION_C	LEI conditions - Client specific	4	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
TOPMaintenance Orders
52	/MRSS/D_RSBUFDAT	Resource Buffering Data	3	LINE_ID	Numc3, internal use	nvarchar	3	0
TOPManufacturer Part Number
53	ADPIC_HOLD_MIGO	Store BADI goitem for MIGO hold / restore functionality	2	LINE_ID	Unique identification of document line	nvarchar	6	0
54	ADPIC_HOLD_MPN	Store MPN subitems for MIGO hold / restore functionality	2	LINE_ID	Unique identification of document line	nvarchar	6	0
TOPMaster Data Framework
55	DML_DELIVERY_TXT	MDF Text Object	19	LINE_ID	Row Key	nvarchar	5	0
56	DML_ST_TEXT	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
57	DML_ST_TEXTH	DML Text Object	23	LINE_ID	Row Key	nvarchar	5	0
TOPPurchasing
58	EKBE_SC	Component Consumption History for Subcontracting	7	LINE_ID	Unique identification of document line	nvarchar	6	0
TOPRepetitive Manufacturing
59	COMPMOVE	Goods Movement of Components	4	LINE_ID	Unique identification of document line	nvarchar	6	0
TOPSAP Business Workflow
60	SWBRULEBIN	WF: Runtime Representation of a Rule	6	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
61	SWBRULECOM	WF: Client-specific start conditions	8	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
62	SWBRULECOU	WF: Connecting Condition/Context to Event Linkage	7	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
63	SWDSCONDEF	WF Definition: Conditions	8	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
64	SWD_CONDEF	WF Definition/Runtime: Conditions	9	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
65	SWECDFIELD	Combined field restrictions for change document	4	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
66	SWJPCOND	Parameter Condition (Parsed)	4	LINE_ID	Condition Editor: Line Number in Internal Display	nvarchar	3	0
TOPTariffs, Duties and Permits
67	OIH_MIGO_HTDP	Store the TDP-GOITEM for MIGOs hold/restore feature	2	LINE_ID	Unique identification of document line	nvarchar	6	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

67 columns | ERP 6.0 | LINE_ID