	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

144 columns | ERP 6.0 | DOCNUM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OPT/VIM_LIC_ID	Collect Docids ICC	7	DOCNUM	Accounting Document Number	nvarchar	10	0
2	/OPT/VIM_LIC_VD	Collect Docids VIM	7	DOCNUM	Accounting Document Number	nvarchar	10	0
3	/SAPSLL/CUSWLAD	Link for Requesting External Customs Declaration Replicates	9	DOCNUM	IDoc number	nvarchar	16	0
4	/SDF/EM_TEST_FLW	Document Flow for documents created by Test Program	2	DOCNUM	Document Number for Test Program	nvarchar	10	0
5	/SDF/EM_TEST_HDR	Header Data for documents created by Test Program	2	DOCNUM	Document Number for Test Program	nvarchar	10	0
6	/SDF/EM_TEST_ITM	Item Data for documents created by Test Program	2	DOCNUM	Document Number for Test Program	nvarchar	10	0
7	/SDF/IVISALEPNDG	ALE messages stuck in tRFC	2	DOCNUM	IDoc number	nvarchar	16	0
8	CFDI_STAT_LOG_MX	MX: CFDI Status Log Details	15	DOCNUM	IDoc number	nvarchar	16	0
9	CNVTDMS_04_TAB	Table Pool for TDMS MD&C	10	DOCNUM	FIELDS for TDMS MD&C	nvarchar	30	0
10	CNVTDMS_05_IDOC	Fill Header for Delivery Documents (IS-OIL)	3	DOCNUM	Numc 16	nvarchar	16	0
11	DFKKPTSAFTPAYMTD	Portugal: SAF-T Payment Method	5	DOCNUM	Document Number	nvarchar	12	0
12	DFKKSAFTINV_H	SAF-T Source Document: Header	6	DOCNUM	Document Number	nvarchar	12	0
13	DFKKSAFTPAY_H	SAF-T Payment Source Document: Header	5	DOCNUM	Document Number	nvarchar	12	0
14	DFKKSAFTPAY_I	SAF-T Payment Source Document: Item	5	DOCNUM	Document Number	nvarchar	12	0
15	DFKKSAFTPAY_ORIG	SAF-T Payment Source Document: Item	5	DOCNUM	Document Number	nvarchar	12	0
16	EDI30C		2	DOCNUM		nvarchar	16	0
17	EDI40		2	DOCNUM		nvarchar	16	0
18	EDID2	IDoc Data Record from 3.0C onwards	2	DOCNUM	IDoc number	nvarchar	16	0
19	EDID4	IDoc Data Records from 4.0 onwards	2	DOCNUM	IDoc number	nvarchar	16	0
20	EDIDD_OLD	IDoc Data Record	2	DOCNUM	IDoc number	nvarchar	16	0
21	EDIDOC		2	DOCNUM		nvarchar	16	0
22	IDXLOGDC40	IDoc Adapter RFC Logging EDI_DC40	5	DOCNUM	IDoc number	nvarchar	16	0
23	IDXLOGDD40	IDoc Adapter RFC Logging EDI_DD40	5	DOCNUM	IDoc number	nvarchar	16	0
24	J_1BNFADD_INFO	Free Usage Fields for Additional Information	2	DOCNUM	Document Number	nvarchar	10	0
25	J_1BNFE_D_CCEFLD	CC-e Event Correction Letter Fields	2	DOCNUM	Document Number	nvarchar	10	0
26	J_1BNFE_EXPORT	Exportation Control	2	DOCNUM	Document Number	nvarchar	10	0
27	J_1BNFFUEL	Nota Fiscal: Fuel Details	2	DOCNUM	Document Number	nvarchar	10	0
28	J_1BNFNVE	NVE table	2	DOCNUM	Document Number	nvarchar	10	0
29	J_1BNFPHARMACEUT	Medicines and Pharmaceutical Raw Material	2	DOCNUM	Document Number	nvarchar	10	0
30	J_1BNFREFPROC	Additional Information: Referenced Processes	2	DOCNUM	Document Number	nvarchar	10	0
31	J_1BNFSUGARDEDUC	Taxes and Contributions on Sugarcane	2	DOCNUM	Document Number	nvarchar	10	0
32	J_1BNFSUGARSUPPL	Daily Supply of Sugarcane	2	DOCNUM	Document Number	nvarchar	10	0
33	J_1BNFTRADENOTES	Trade Notes	2	DOCNUM	Document Number	nvarchar	10	0
34	J_1BNFTRAILER	Trailer Information	2	DOCNUM	Document Number	nvarchar	10	0
35	J_1BNFTRANSVOL	Transported Volumes	2	DOCNUM	Document Number	nvarchar	10	0
36	J_1BNFVEHICLE	Nota Fiscal: Vehicle Details	2	DOCNUM	Document Number	nvarchar	10	0
37	REFXCN_SALES	Sales Data	3	DOCNUM	IDOC Number	nvarchar	16	0
38	REFXCN_STATE	Sale Satement Data	3	DOCNUM	IDOC Number	nvarchar	16	0
39	ZFSCM_IDIDO	Abbildung:TrxRef -> IDoc	3	DOCNUM	Nummer des IDocs	nvarchar	16	0
40	ZFSCM_IDOBEL	Verknüpfung: IDoc <-> Eingangsbeleg	3	DOCNUM	Nummer des IDocs	nvarchar	16	0
41	ZIDOC_CREATE	IDocs zu denen ein ZALEAUD geschrieben wurde	2	DOCNUM	Nummer des IDocs	nvarchar	16	0
TOPAccounts Payable
42	/PTGWFI/F_SMIMTR	SMI Process Monitor	2	DOCNUM	SMI document number	nvarchar	10	0
TOPALE Integration Technology
43	BDAUDQUEUE	ALE Audit queue for unprocessed IDocs	8	DOCNUM	IDoc number	nvarchar	16	0
44	CATT_ALE	Table for ALE - CATT Session	2	DOCNUM	IDoc number	nvarchar	16	0
45	EDCPIC	EDI table of received IDocs from R/2	4	DOCNUM	IDoc number	nvarchar	16	0
46	EDFI2	EDI: Last processed document in file	3	DOCNUM	Last IDoc processed when a file was processed	nvarchar	16	0
47	EDFIL	EDI: Last processed document in file	4	DOCNUM	IDoc number	nvarchar	16	0
48	EDID3	IDoc Data Record from 3.0 onwards	2	DOCNUM	IDoc number	nvarchar	16	0
49	EDIDC	Control record (IDoc)	2	DOCNUM	IDoc number	nvarchar	16	0
50	EDIDOCINDX	Control record (IDoc)	2	DOCNUM	IDoc number	nvarchar	16	0
51	EDIDS	Status Record (IDoc)	2	DOCNUM	IDoc number	nvarchar	16	0
52	EDIQI	IDoc Inbound Queue Table	5	DOCNUM	IDoc number	nvarchar	16	0
53	EDIQO	IDoc: Outbound Queue for qRFC	4	DOCNUM	IDoc number	nvarchar	16	0
54	TBDRCSTATE	Objects in recovery environment (ALE)	2	DOCNUM	IDoc number	nvarchar	16	0
TOPAssortment List
55	WBB_MIDOC	Assortment List: Header For Merged IDocs	7	DOCNUM	IDoc number	nvarchar	16	0
56	WDLSP	POS outbound log: IDoc (items)	4	DOCNUM	IDoc number	nvarchar	16	0
TOPData Transfer
57	PPDHD	Transfer to Accounting: Document Header	2	DOCNUM	Document number	nvarchar	10	0
58	PPDIT	Transfer to Accounting: Lines in HR IDOCs	2	DOCNUM	Document number	nvarchar	10	0
59	PPDIX	Transfer to Accounting: Index Table for HR IDOCs	5	DOCNUM	Document number	nvarchar	10	0
60	PPDMSG	Transfer to Accounting: Table of Error Messages	2	DOCNUM	Document number	nvarchar	10	0
61	PPDSH	Payroll Posting Document: Status History	2	DOCNUM	Document number	nvarchar	10	0
62	PPDST	Transfer to Accounting: Substituted Acc. Assig. Object	2	DOCNUM	Document number	nvarchar	10	0
TOPData Transfer Workbench
63	DXFILENOK	Possible Corrupt Error Files in Data Transfer	3	DOCNUM	Last IDoc processed when a file was processed	nvarchar	16	0
TOPDistributed Maintenance
64	/ISDFPS/UPSREPCP	ALE Replication Table for Change Authorizations	6	DOCNUM	Message Number	nvarchar	32	0
TOPDistribution Requirements Planning
65	MDRP_POCO	Event Table: Deployment Run	23	DOCNUM	Document number	nvarchar	20	0
TOPDistribution Unit Distribution Packet
66	DELIVERY	Replication Table	5	DOCNUM	IDoc number	nvarchar	16	0
67	DSPHDR	ALE Distribution Packet : Header data	12	DOCNUM	IDoc number	nvarchar	16	0
68	DSPITM	ALE Distribution Packet : Objects	5	DOCNUM	IDoc number	nvarchar	16	0
69	UPSHDR	ALE Distribution Unit: Header Data	12	DOCNUM	Message Number	nvarchar	32	0
70	UPSITM	ALE Distribution Unit: Objects	8	DOCNUM	Message Number	nvarchar	32	0
71	UPSITX	ALE Distribution Unit: Objects of Processed Units	8	DOCNUM	Message Number	nvarchar	32	0
72	UPSREP01	ALE Replication Table: Replication Table	6	DOCNUM	Message Number	nvarchar	32	0
TOPDSD Connector
73	/DSD/ME_DOCMASK	DSD CN: Document Numbering	5	DOCNUM	DSD Connector: Document Numbering 8 byte	nvarchar	8	0
TOPEnergy Data Management
74	EDEXTASKIDOC	IDocs for Data Exchange Task	3	DOCNUM	IDoc number	nvarchar	16	0
75	EEDMIMPORTLOG_DB	EDM Import Log: Database Table	9	DOCNUM	IDoc number	nvarchar	16	0
TOPExternal personnel administration
76	HRSM_HEAD	External employee data: Header data	9	DOCNUM	Inbound IDoc Number	nvarchar	16	0
TOPFinancials Basis
77	UBC_TB_INVH	Bill (Header)	3	DOCNUM	Internal Invoice/Bill Number	nvarchar	16	0
78	UBC_TB_INVHACT	Account Assignments on Bill Header	3	DOCNUM	Internal Invoice/Bill Number	nvarchar	16	0
79	UBC_TB_INVHMES	Bill: Messages from Inbound Processing	3	DOCNUM	Internal Invoice/Bill Number	nvarchar	16	0
80	UBC_TB_INVP	Bill Item	3	DOCNUM	Internal Invoice/Bill Number	nvarchar	16	0
81	UBC_TB_INVPACT	Account Assignments on Level of Item	3	DOCNUM	Internal Invoice/Bill Number	nvarchar	16	0
82	UBC_TB_NOTES	Table for Notes	3	DOCNUM	Internal Invoice/Bill Number	nvarchar	16	0
TOPGlobal Trade Services
83	/SAPSLL/LEGMES	SLL: Customs Document: Messages for Each Activity	29	DOCNUM	IDoc number	nvarchar	16	0
84	/SAPSLL/MDMES	Messages per Master Data Item	3	DOCNUM	IDoc number	nvarchar	16	0
85	/SAPSLL/TSHD	Tax Statement: Header	17	DOCNUM	IDoc number	nvarchar	16	0
TOPIntercompany Data Exchange
86	EREMADVCTRL_IDOC	IDE: control table - payment data	5	DOCNUM	IDoc number	nvarchar	16	0
TOPInterface to Terminal Automation System
87	OIK02A	IS-OIL/TAS: Status of processed functions	2	DOCNUM	IDoc number	nvarchar	16	0
88	OIK02B	IS-OIL/TAS: Status of processed functions - messages	2	DOCNUM	IDoc number	nvarchar	16	0
89	OIK04	IS-OIL/TAS: Idoc data segment	2	DOCNUM	IDoc number	nvarchar	16	0
90	OIK29	IS-OIL/TPI: Status of processed inbound IDoc OILSHI01	2	DOCNUM	IDoc number	nvarchar	16	0
91	OIK29A	IS-OIL/TPI: Status of processed functions	2	DOCNUM	IDoc number	nvarchar	16	0
92	OIK29B	IS-OIL/TPI: Status of processed functions - messages	2	DOCNUM	IDoc number	nvarchar	16	0
93	OIK29C	IS-OIL/TPI: Status of processed functions - messages	2	DOCNUM	IDoc number	nvarchar	16	0
94	OIK29D	IS-OIL/TPI: Status of processed inbound IDoc OILSHI01	2	DOCNUM	IDoc number	nvarchar	16	0
TOPJoint Venture und Production Sharing Accounting
95	T8JDX	JV EDI Inbound: IDOC to FB01 document numbers	2	DOCNUM	IDoc number	nvarchar	16	0
TOPJust-In-Time Processing
96	JITIMP	Calls for the signal monitor	8	DOCNUM	IDoc number	nvarchar	16	0
TOPLocalization
97	J_1BCTE_D_DOCREF	Reference to the NF-e being transported	2	DOCNUM	Document Number	nvarchar	10	0
98	J_1BCTE_D_REF	Reference to the NF-e being transported	2	DOCNUM	Document Number	nvarchar	10	0
99	J_1BCTE_D_RES	Information about resource	2	DOCNUM	Document Number	nvarchar	10	0
100	J_1BFIFOIN	Incoming FIFO relevant Consignment movements (BRAZIL)	13	DOCNUM	Document Number	nvarchar	10	0
101	J_1BNFCPD	Nota Fiscal one-time accounts	2	DOCNUM	Document Number	nvarchar	10	0
102	J_1BNFDOC	Nota Fiscal Header	2	DOCNUM	Document Number	nvarchar	10	0
103	J_1BNFERFCBATCH	NF-e documents to be send via Report J_1BRFCBATCH	2	DOCNUM	Document Number	nvarchar	10	0
104	J_1BNFE_ACTIVE	Electronic Nota Fiscal: Actual Status	2	DOCNUM	Document Number	nvarchar	10	0
105	J_1BNFE_CCE	NF-e CCe Table	2	DOCNUM	Document Number	nvarchar	10	0
106	J_1BNFE_EVENT	NF-e Events Table	2	DOCNUM	Document Number	nvarchar	10	0
107	J_1BNFE_HISTORY	Electronic Nota Fiscal - History	2	DOCNUM	Document Number	nvarchar	10	0
108	J_1BNFE_INVALID	Electronic Nota Fiscal: Invalid Status Actions	2	DOCNUM	Document Number	nvarchar	10	0
109	J_1BNFFTX	Nota Fiscal header message	2	DOCNUM	Document Number	nvarchar	10	0
110	J_1BNFIMPORT_ADI	Nota Fiscal Data for Additions to Import Documents	2	DOCNUM	Document Number	nvarchar	10	0
111	J_1BNFIMPORT_DI	Nota Fiscal Data for Import Documents	2	DOCNUM	Document Number	nvarchar	10	0
112	J_1BNFLIN	Nota Fiscal line items	2	DOCNUM	Document Number	nvarchar	10	0
113	J_1BNFNAD	Nota Fiscal partners	2	DOCNUM	Document Number	nvarchar	10	0
114	J_1BNFREF	Nota Fiscal reference to header message	2	DOCNUM	Document Number	nvarchar	10	0
115	J_1BNFSTX	Nota Fiscal tax per item	2	DOCNUM	Document Number	nvarchar	10	0
116	J_1BPOSCOUPONS	POS-Database Coupons (Brazilian)	21	DOCNUM	IDoc number	nvarchar	16	0
117	J_1BPOSREDUCTION	POS-Database Reduction (Brazilian)	24	DOCNUM	IDoc number	nvarchar	16	0
118	J_1B_CIAP_OBJECT	CIAP document data	3	DOCNUM	Document Number	nvarchar	10	0
TOPMaterials Management
119	/ISDFPS/CS_SW_ID	System Switch: Force Element and IDocs	5	DOCNUM	IDoc number	nvarchar	16	0
TOPPOS Interface
120	WPLST	POS interface: processing log	2	DOCNUM	IDoc number	nvarchar	16	0
121	WPTST	POS interface: restart log for upload processing	2	DOCNUM	IDoc number	nvarchar	16	0
122	WPXST	POS interface: status external subsystems (error messages)	10	DOCNUM	IDoc number	nvarchar	16	0
TOPProduct Data Replication
123	CRWB_BADI_BL2UPS	UPS Entries for Baseline (Workflow Dependent)	9	DOCNUM	Message Number	nvarchar	32	0
TOPSales
124	VBLB	Sales document: Release order data	6	DOCNUM	IDoc number	nvarchar	16	0
TOPSAP Retail Store
125	WSTI_MKPF_INDEX	Phys. Inventory During Open Time: Material Doc. Index	13	DOCNUM	IDoc number	nvarchar	16	0
126	WSTI_PDC_EVENT	Retail Store Physical Inventory: PDC Transactions	2	DOCNUM	IDoc number	nvarchar	16	0
127	WSTI_POS_EVENT	Physical Inventory in an Opened Store: POS Trans by Receipt	30	DOCNUM	IDoc number	nvarchar	16	0
TOPSAPscript
128	STXRDID	SAPscript: Raw Data Interface - Data Table	2	DOCNUM	SAPscript: Raw Data Interface Identifier	nvarchar	10	0
129	STXRDIR	SAPscript: RDI - Reference Table for Test Mode	3	DOCNUM	SAPscript: Raw Data Interface Identifier	nvarchar	10	0
TOPSelf-Billing Proced.
130	VSBCON	Conditions (Surcharges/Discounts) of an IDoc Item	3	DOCNUM	IDoc number	nvarchar	16	0
131	VSBDAT	Self-Billing Procedure Data w. Automatic Postings	3	DOCNUM	IDoc number	nvarchar	16	0
132	VSBGRH	IDoc Header Regrouping Information	3	DOCNUM	IDoc number	nvarchar	16	0
133	VSBGRI	IDoc Item Regrouping Information	3	DOCNUM	IDoc number	nvarchar	16	0
134	VSBHDR	IDoc Self-Billing Procedure w. Automatic Postings	3	DOCNUM	IDoc number	nvarchar	16	0
135	VSBITM	IDoc-Item Self-Billing Procedure w. Automatic Postings	3	DOCNUM	IDoc number	nvarchar	16	0
136	VSBPER	Prestep-Errors in Self-Billing Procedure w. Autom. Postings	3	DOCNUM	IDoc number	nvarchar	16	0
137	VSBREF	References: Self-Billing Procedure with Autom. Postings	3	DOCNUM	IDoc number	nvarchar	16	0
TOPSpecification 2
138	SPCCNVDOCNUM	Conversion between S2K doc. no. and Appl. Doc. No.	3	DOCNUM	Reduction in Length of Appl. Doc. to Create S2K Document No.	nvarchar	2	0
139	SPCMCNVDOCNUM	Conversion between S2KM doc. no. and Appl. Doc. No.	3	DOCNUM	Reduction in Length of Appl. Doc. to Create S2K Document No.	nvarchar	2	0
TOPTakeoverHandover of Technical Objects
140	PHINT	Phase In Table	11	DOCNUM	IDoc number	nvarchar	16	0
TOPTariffs, Duties and Permits
141	OIH_J_1BMSEG_NF	Link between Gain and Losses Movements and Nota Fiscal	2	DOCNUM	Document Number	nvarchar	10	0
TOPTransaction Manager
142	VTBKORES	Correspondence Data	50	DOCNUM	Number of IDoc (Outgoing)	nvarchar	16	0
TOPVehicle Management System
143	VLCIDGU	VELO : Vehicle to IDoc Number Assignment Table	2	DOCNUM	IDoc number	nvarchar	16	0
TOPWarehouse Management
144	LRF_WKQU	Assignment User ->Queue	9	DOCNUM	Currently Processed Document Number	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

144 columns | ERP 6.0 | DOCNUM