	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

66 columns | ERP 6.0 | GDATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	GRPC_UPG_HRP1000	Upgrade Back Up Data	19	GDATE	Delimitation date	nvarchar	8	0
2	P01E2_MELD_ST	ELStAM: Status of Notifications for the Administrator	6	GDATE	ELStAM: Date of Creation/Change	nvarchar	8	0
3	P01RBM_TRIN	ZfA: Manage PI Receipt of Notification	8	GDATE	Pension Receipt Notification: Date of Status Change	nvarchar	8	0
4	P01ZFA_TRIN	ZfA: Manage PI Receipt of Notification	8	GDATE	ZfA: Creation/Change Date	nvarchar	8	0
5	P05TPRNL_PR_OUT	Pension Return: PR - Output Data	12	GDATE	Creation/Change Date	nvarchar	8	0
6	P05T_WCR_SIMU	WCR Simulation	40	GDATE	Creation/Change Date	nvarchar	8	0
7	P2B2_QTACC	HCM Declustering B2 - Generating Absence Quotas	7	GDATE	Date Generated	nvarchar	8	0
8	P2B2_QTTRANS	HCM Declustering B2 - Transfer Pool for Quota Deduction	7	GDATE	Date Generated	nvarchar	8	0
9	P2RX_VERSC	Payroll Status Information	9	GDATE	Retro.acct.for gross part as of	nvarchar	8	0
10	T021D	Line Layout Fast Entry: Administration	6	GDATE	Fast Entry: Date of Saving	nvarchar	8	0
11	TBVZ	CO-PA report library (no longer used)	7	GDATE	Date created	nvarchar	8	0
12	TGTB	Control table for table converter	12	GDATE	Date	nvarchar	8	0
13	ZRP1000	Infotype 1000 DB Table	19	GDATE	Delimitation date	nvarchar	8	0
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
14	DDPART	DD: Partitioned form of TBATG	9	GDATE	Date	nvarchar	8	0
15	TBATG	Control table for batch table conversion	8	GDATE	Date	nvarchar	8	0
TOPB2A Business to Administration
16	PB2ASTAT	HR-B2A: Status Management	7	GDATE	Creation/Change Date of Data Record	nvarchar	8	0
17	PC01B2A_SVEMSTAT	SI-Specific Storage E-Mails for Procedure for Returning Data	7	GDATE	Date	nvarchar	8	0
TOPCompany Pension Scheme Germany
18	P01RBM_HIST	Notification Status: Pension Receipt Notifications	5	GDATE	Pension Receipt Notification: Date of Status Change	nvarchar	8	0
19	P01RBM_STAT	Notification Status: Pension Receipt Notifications	11	GDATE	Pension Receipt Notification: Date of Status Change	nvarchar	8	0
20	P01RBM_STAT_R	Status of Confirmations (Pension Receipt Notifications)	11	GDATE	Pension Receipt Notification: Date of Status Change	nvarchar	8	0
21	P01RBM_TRANS	RBM: Status Table for Transfer	6	GDATE	Pension Receipt Notification: Date of Status Change	nvarchar	8	0
22	P01VA_STAT	PEP: Status of Pension Equalization Payment	6	GDATE	PEP: Date of Status Change	nvarchar	8	0
TOPConstruction Industry
23	PDBKBESUM	Constr. Ind. Social Fund Procedure: BEMEL Records (Total)	40	GDATE	Local Date	nvarchar	8	0
TOPContract Accounts Receivable and Payable
24	TFK021D	Screen variants: Administration	6	GDATE	Screen variants: Date saved	nvarchar	8	0
25	TFK021K	Subscreen Management (SAP)	9	GDATE	Fast Entry: Date of Saving	nvarchar	8	0
26	TFK021KC	Detail Screen Structure for Document Display (Customer)	8	GDATE	Fast Entry: Date of Saving	nvarchar	8	0
TOPGermany
27	T5D4T	HIF Receiving Office for the E-Mail Procedure	6	GDATE	Company Number Valid Until	nvarchar	8	0
28	T5D4U	File Numbers for E-Mail Procedure with Health Ins. Funds	8	GDATE	Date	nvarchar	8	0
TOPLocalization
29	J_3RSEXTRACTD	Exctract details (obsolete)	18	GDATE	Cargo customs declaration date	nvarchar	8	0
TOPOrganizational Management
30	HRP1000	Infotype 1000 DB Table	19	GDATE	Delimitation date	nvarchar	8	0
TOPProfile Maintenance
31	TPFHS	Prototype: Profile header, administration data for profiles	10	GDATE	Data part last profile generation	nvarchar	8	0
32	TPFHT	Profile header, administration data for profiles in DB	10	GDATE	Data part last profile generation	nvarchar	8	0
TOPProfitability Analysis
33	T239	Report version table	4	GDATE	Date created	nvarchar	8	0
34	TKEB1	Report Management	11	GDATE	Created On	nvarchar	8	0
35	TKES1	Row/column structures	11	GDATE	Date created	nvarchar	8	0
TOPPublic Sector
36	P01ZFA_NN_STATUS	ZfA: Status Management for ZKNN Notifications	6	GDATE	ZfA: Creation/Change Date	nvarchar	8	0
37	P01ZFA_STATUS	ZfA: Status Management for Notifications	7	GDATE	ZfA: Creation/Change Date	nvarchar	8	0
38	P01ZFA_TRANS	ZfA: Status Table for Transfer	6	GDATE	ZfA: Creation/Change Date	nvarchar	8	0
TOPReporting
39	P05TPRNL_EE_ADMS	Pension Return: Admin of Status Income Relationship - Pers L	15	GDATE	Creation/Change Date	nvarchar	8	0
40	P05TPRNL_LP_ADMS	Pension Return: Administration of Status - Legal Pers Level	13	GDATE	Creation/Change Date	nvarchar	8	0
41	P05T_AE_ADM_STAT	Wage Return: Administrative Unit - Status Table	11	GDATE	Creation/Change Date	nvarchar	8	0
42	P05T_A_EXT	Wage Return: Collective Employer Data - Wage Return	10	GDATE	Creation/Change Date	nvarchar	8	0
43	P05T_CVZ_UITW	CVZ: Tabel voor uitwisselingsbestand	8	GDATE	Creation/Change Date	nvarchar	8	0
44	P05T_IV_ADM_STAT	Wage Return: Income Relationship - Status Table	13	GDATE	Creation/Change Date	nvarchar	8	0
45	P05T_JLO_STAT	Annual Wage Return status	7	GDATE	Creation/Change Date	nvarchar	8	0
46	P05T_RESPONSE	Wage Return: Table for Response Messages	8	GDATE	Creation/Change Date	nvarchar	8	0
47	P05T_WCR_ER_INFO	WCR Info on Employer Level	18	GDATE	Creation/Change Date	nvarchar	8	0
48	P05T_WCR_STAT	WCR Status Table	11	GDATE	Creation/Change Date	nvarchar	8	0
TOPSales and Distribution
49	J_1USEXTRACTD	EXTRACTD	18	GDATE		nvarchar	8	0
TOPSets
50	T800S	FI-SL Set Table (before Release 4.0)	24	GDATE	Date on which object was last changed	nvarchar	8	0
TOPSocial Insurance
51	P01SV_B2ATRNS	Status Table Transfer to Social Insurance Agency	15	GDATE	Employment Tax Statement: Created/Changed On	nvarchar	8	0
TOPStatements
52	P01W_ADMIN_01	HR: Data Module: Administration for Health Insurance Funds	9	GDATE	Creation/Change Date of Data Record	nvarchar	8	0
TOPTax
53	P01E2_HIST	ELStAM Procedure: Table for Status History	6	GDATE	ELStAM: Date of Creation/Change	nvarchar	8	0
54	P01E2_LISTMTL_ST	ELStAM: Status Table for Monthly Change Lists	13	GDATE	ELStAM: Date of Creation/Change	nvarchar	8	0
55	P01E2_LIST_ST	Status Table for ELStAM Procedure Change Lists	7	GDATE	ELStAM: Date of Creation/Change	nvarchar	8	0
56	P01E2_STATUS	ELStAM Procedure: Status Table	8	GDATE	ELStAM: Date of Creation/Change	nvarchar	8	0
57	P01E2_TRANS_ST	Status Table Transfer for ELStAM Procedure	9	GDATE	ELStAM: Date of Creation/Change	nvarchar	8	0
58	P01T_ADMIN_STAT	ETStmt: Status Management Employment Tax Statements	10	GDATE	Employment Tax Statement: Created/Changed On	nvarchar	8	0
59	P01T_ADMST	ETStmt: Status Management - Employment Tax Statements (Old)	10	GDATE	Employment Tax Statement: Created/Changed On	nvarchar	8	0
60	P01T_A_ADS	ETNotif.: Status Administration/Employment Tax Notification	11	GDATE	Employment Tax Statement: Created/Changed On	nvarchar	8	0
61	P01T_A_EXT	ETNotif.: External Data	10	GDATE	Employment Tax Statement: Created/Changed On	nvarchar	8	0
62	P01T_TRANS	ETStmt: Administration/Processing Data Tickets	6	GDATE	Employment Tax Statement: Created/Changed On	nvarchar	8	0
TOPUpgrade - General
63	TBATG_SAV	Steuertabelle für Tabellenumsetzung in Batch	8	GDATE	Datum	nvarchar	8	0
64	TBATG_SHD	Steuertabelle für Tabellenumsetzung in Batch	8	GDATE	Datum	nvarchar	8	0
65	TBATG_STD	Steuertabelle für Tabellenumsetzung in Batch	8	GDATE	Datum	nvarchar	8	0
66	UPGTBATG	Control Table for Creating Indexes in Advance	8	GDATE	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

66 columns | ERP 6.0 | GDATE