	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

71 columns | ERP 6.0 | FROM_DATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/GSINS/INH_B2E_C	Benefit Type to Wage Type for External Transfers	4	FROM_DATE	"Valid From" Date	nvarchar	8	0
2	/GSINS/INH_B2W_C	Benefit Type to Wage Type for Payments	4	FROM_DATE	"Valid From" Date	nvarchar	8	0
3	/OTTM/BL_T_ERM	E-Receipt metadata	13	FROM_DATE	From Date	nvarchar	8	0
4	BOE_PLE_ITEM	Pledge item data table of BoE management	24	FROM_DATE	Pledge from date	nvarchar	8	0
5	CMCBD_CYCLE	Cash Budgeting Cycle	6	FROM_DATE	Cash Budget Cycle Start Date	nvarchar	8	0
6	CNVTDMSBI_MULDAT	To store the mulitple 'from dates' at infoarea level	5	FROM_DATE	Date for TDMS	nvarchar	8	0
7	CNVTDMSBI_SELEC	Selected "From date" for a package	3	FROM_DATE	Date for TDMS	nvarchar	8	0
8	CNVTDMSBW_BSTDT	Best From Dates	3	FROM_DATE	Field of type DATS	nvarchar	8	0
9	CNVTDMS_01_EVAL	Table to hold From Dates and their Evaluation	3	FROM_DATE	Date	nvarchar	8	0
10	FIEUD_FISUMMARY	SAFT: FI Transaction Summary Information	5	FROM_DATE	Date	nvarchar	8	0
11	FIEUD_GOODSCNT	SAFT:MM: XML Goods movement Transaction Count and Summary	4	FROM_DATE	Date	nvarchar	8	0
12	FIEUD_INVSUMMARY	SAFT: FI Transaction Summary Information	5	FROM_DATE	Date	nvarchar	8	0
13	FIEUD_MMINVCNT	SAFT:MM: XML Invoice Transaction Count and Summary	4	FROM_DATE	Date	nvarchar	8	0
14	ISM_PT_NUMBR_AM	Signature PT: Relevancy of M/AM Billing Number range	7	FROM_DATE	Signature PT: Starting Date for Signatures	nvarchar	8	0
15	ISM_PT_NUMBR_SD	Signature PT: Relevancy of Billing Number range	7	FROM_DATE	Signature PT: Starting Date for Signatures	nvarchar	8	0
16	NPLR	Legal Representative	5	FROM_DATE	Validity Date (Valid From)	nvarchar	8	0
17	RDBRA_LZB_PERIOD	RA RDB: Periods of a maturity band	7	FROM_DATE	Start Date of Maturity Band Period	nvarchar	8	0
18	SIPT_NUMBR_OBD	Signature PT: Relevancy of Delivery Number range	8	FROM_DATE	Signature PT: Starting Date for Signatures	nvarchar	8	0
19	SIPT_NUMBR_OIG	Siganture PT : Customizing Table for Signature in IS-OIL	9	FROM_DATE	Date	nvarchar	8	0
TOPActual Update and Commitment Update
20	GTRRULE_ASSIGN	GTR Multi-Funding Rules Assignment To CRM Objects	3	FROM_DATE	Start Date	nvarchar	8	0
TOPArchive Information System
21	ASPART_ACT	ArchiveInfoSys: Actual Partitioning	2	FROM_DATE	AS Partitioning: From Date	nvarchar	8	0
22	ASPART_CONF	ArchivInfoSys: Partitioning Configuration	2	FROM_DATE	AS Partitioning: From Date	nvarchar	8	0
TOPBackground Processing
23	FAVSELS	User-Specific Favorite Selection Criteria	8	FROM_DATE	Planned Start Date for Background Job	nvarchar	8	0
TOPBatches
24	TOBJ_D_UPLOAD	Table to store Plant and Material relevant to Batch History	6	FROM_DATE	Valid-From Date	nvarchar	8	0
TOPBudgeting and Availability Control
25	GMBDGTVALIDITY	Grant budget validity	6	FROM_DATE	Valid-from Date	nvarchar	8	0
TOPCollectionsDisbursements
26	IBROBHREALLOC	Change Responsibilities for Broker Hierarchies	9	FROM_DATE	Date	nvarchar	8	0
TOPContract Accounts Receivable and Payable
27	DFKK_DOC_EXTR	FI-CA Documents - Extracts	3	FROM_DATE	From Posting Date	nvarchar	8	0
TOPData Access in Agreement with German Tax Law
28	TPCDATE	Periods for Authorization Check	4	FROM_DATE	Field of type DATS	nvarchar	8	0
29	TPCDATEN	Periods for Authorization Check	5	FROM_DATE	Field of type DATS	nvarchar	8	0
TOPE-Recruiting
30	T77RCF_DOVR_PM	Performance Management Templates in Overview (Successor)	3	FROM_DATE	Valid From	nvarchar	8	0
TOPEmployee Interaction Center
31	THREIC_IBSEARCH	EIC Inbox Initial Search Profile	7	FROM_DATE	EIC: Created From	nvarchar	8	0
32	THREIC_IBSUBST	EIC Inbox Substitution	3	FROM_DATE	Field of type DATS	nvarchar	8	0
TOPFunds Management
33	FMFG_PEROP_SD	Retrieval Options - Period of Performance for SD	3	FROM_DATE	Valid From Date	nvarchar	8	0
34	FMSPLIT_SPLIT	Distributions for Rule-Based Account Distributions	6	FROM_DATE	Start Date	nvarchar	8	0
TOPFunds Management-Specific Postings
35	PSO48	Customer Assignment of BUSAB to Customer Master Record	4	FROM_DATE	Valid-From Date	nvarchar	8	0
TOPGrantee Management
36	GMCCSETTINGS	Company code settings	3	FROM_DATE	Valid-from Date	nvarchar	8	0
TOPIncident Reporting
37	EHHSSD_ISR_SURPT	Incident Report - Summary Report	8	FROM_DATE	From-Date for Report Search	nvarchar	8	0
TOPIntercompany Data Exchange
38	ETAXTINVKO	Extract Table for Tax Storage for Incoming Bill, Extr. Info	3	FROM_DATE	From Posting Date	nvarchar	8	0
39	TINV_EXTR_HDR	Extract of Bill Receipt Document: Admin. Data (Eval. System)	3	FROM_DATE	From Posting Date	nvarchar	8	0
TOPLocalization
40	J_1IEWT_CERTIF	Certificate Issued Details-EWT India	16	FROM_DATE	Valid-from date	nvarchar	8	0
41	J_1IEWT_CERTIF_N	Certificate Issued Details-EWT India:SECCO	16	FROM_DATE	Valid-from date	nvarchar	8	0
42	SIPT_NUMBR_FI	Signature PT: Relevancy of FI Number range	8	FROM_DATE	Signature PT: Starting Date for Signatures	nvarchar	8	0
43	SIPT_NUMBR_MM	Signature PT: Relevancy of Self Billing Number range	10	FROM_DATE	Signature PT: Starting Date for Signatures	nvarchar	8	0
44	SIPT_NUMBR_SD	Signature PT: Relevancy of Billing Number range	7	FROM_DATE	Signature PT: Starting Date for Signatures	nvarchar	8	0
TOPMarketing, Accounting and Pricing
45	OICINT_CAL	Interest calculation	4	FROM_DATE	From date for interest calculation	nvarchar	8	0
TOPMaster Data
46	GMASPCLASS	Sponsored Class - Sponsor Specific Data	4	FROM_DATE	Valid from	nvarchar	8	0
47	GMASPPROG	Sponsored Program - Sponsor Specific Data	4	FROM_DATE	Valid from	nvarchar	8	0
48	GMFUNDRECOVER_O	Fund recovery for outgoing grants	6	FROM_DATE	Valid-from Date	nvarchar	8	0
49	GMGRFUNDRECOVER	Fund recovery	4	FROM_DATE	Valid-from Date	nvarchar	8	0
50	GMGRIDCCAP	Grant IDC Cap (Program + Class)	5	FROM_DATE	Valid-from Date	nvarchar	8	0
51	GMGRIDCCAP2	Grant IDC Cap (Grant level)	3	FROM_DATE	Valid-from Date	nvarchar	8	0
52	GMGRIDCCAP2_O	Grant IDC Cap (Grant level) for outgoing grant	4	FROM_DATE	Valid-from Date	nvarchar	8	0
53	GMGRIDCCAP_O	Grant IDC Cap (Program + Class) for outgoing grant	6	FROM_DATE	Valid-from Date	nvarchar	8	0
54	GMGRRESPONSIBLE	Objects responsible for the grant	6	FROM_DATE	Date that responsiblity starts	nvarchar	8	0
55	GMINDIRECTCOST	IDC rates for directly sponsored grants [incoming grants]	5	FROM_DATE	Valid-from Date	nvarchar	8	0
56	GMINDIRECTCOST_O	Indirect costs for outgoing grants	6	FROM_DATE	Valid-from Date	nvarchar	8	0
57	GMINDIRECTCOST_R	Indirect costs for recipient	5	FROM_DATE	Valid-from Date	nvarchar	8	0
58	GMSPAGT	Allowed Grant Types for Sponsor	4	FROM_DATE	Valid from	nvarchar	8	0
59	GMSPRESPONSIBLE	Objects responsible for the sponsored program	6	FROM_DATE	Date that responsiblity starts	nvarchar	8	0
60	GMSPRESPTYP	Responsibility Defaults for Sponsor	6	FROM_DATE	Valid from	nvarchar	8	0
TOPMedia Product Sales and Distribution
61	JVTSDHDPLAN	IS-M: Planning Record for M/SD Home Delivery of SD Orders	3	FROM_DATE	IS-M: Shipping Date	nvarchar	8	0
TOPPublic Sector Contract Accounts Receivable and Payable
62	DFMCA_BRF560	BRF: Parameters for Facts Selection	13	FROM_DATE	BRF: Expression	nvarchar	20	0
63	DFMCA_BRF772	BRF: Parameters for Facts Selection	13	FROM_DATE	BRF: Expression	nvarchar	20	0
TOPReusable Components of Business Suite Foundation
64	/BOFU/DDMOCUST_H	Demo Customer Header	25	FROM_DATE		nvarchar	8	0
TOPSAP Utilities
65	TEAMI_AMS	Advanced Metering System	3	FROM_DATE	From-Date	nvarchar	8	0
66	TEAMI_AMST	Text Table for Advanced Metering System	4	FROM_DATE	From-Date	nvarchar	8	0
TOPTransaction Manager
67	TCORT_CODRP	Deal: Rollover Plan	7	FROM_DATE	'Valid From' Date	nvarchar	8	0
68	VTBROLLOVER	Rollover Periods for Forward Securities Transactions	5	FROM_DATE	'Valid From' Date	nvarchar	8	0
TOPTravel Expenses
69	PTRV_SADD	Trip Statistics - Add. Receipt Data	10	FROM_DATE	From Date	nvarchar	8	0
TOPWithout Description
70	CCMSBIAVAILDOWNT	Individual Non-Availability Settings	9	FROM_DATE	System Date	nvarchar	8	0
71	CCMSBIAVLREPCF	Individual Reporting Settings: SLA Limits	9	FROM_DATE	System Date	nvarchar	8	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

71 columns | ERP 6.0 | FROM_DATE