	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

75 columns | ERP 6.0 | EXTERNAL_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000151000	PSA for 0DPR_PROJECT_ATTR T90CLNT090 Proj. Def. Attr.	9	EXTERNAL_ID		nvarchar	24	0
2	/CPD/D_PFP_PH	Plan Header	4	EXTERNAL_ID	External ID for Financial Plan	nvarchar	44	0
3	/IWFND/I_MED_MEX	maps an external identifier to the mapping	5	EXTERNAL_ID	generic place holder for an external object identifier	nvarchar	40	0
4	CLB2C_APPL_DATA	Collaboration: Application Settings for a Target Server	5	EXTERNAL_ID	Collaboration: Application ID at Collaboration Platform	nvarchar	255	0
5	CNV_MBT_ACT_REC	Activity record - info about DMIS DEL Activities	8	EXTERNAL_ID	MBT PCL: Session ID	nvarchar	20	0
6	DMC_ACT_REC	Activity record - info about the execution of DMC activities	7	EXTERNAL_ID	External identifier of an MWB activity	nvarchar	40	0
7	DMC_TABSPACE_SIZ	DMC : Tabelle zum Speichern von Tab.platz-Größe	1	EXTERNAL_ID	External identifier of an MWB activity	nvarchar	40	0
8	DOTM_SYS	DBOSC-TM: System	7	EXTERNAL_ID	DBOSC-CR: Generated ID (30) Lower Case	nvarchar	30	0
9	GRRMOBLOSEVT	Main Entity Table for Loss Events	3	EXTERNAL_ID	External ID of Loss Event	nvarchar	50	0
10	GRRMOBLOSEVTH	Main Entity Table for Loss Events - History Table	4	EXTERNAL_ID	External ID of Loss Event	nvarchar	50	0
11	HRSFI_D_ONB_IMP	SuccessFactors: Staging Area for Onboarding Applicants	5	EXTERNAL_ID	External Id for New Hire Applicant	ntext	1073741823	0
12	RSPMPROCESS	RSPM Process Directory	9	EXTERNAL_ID	External ID	nvarchar	40	0
13	T7BREFD_EVEXT	Table to link between intern.event ID and external event ID	2	EXTERNAL_ID	External event ID	nvarchar	64	0
14	T7BREFD_STLOG	Event status log	11	EXTERNAL_ID	External event ID	nvarchar	64	0
15	WFAL_GUID_2_SMK	Mapping-Table GUID - semantic key	3	EXTERNAL_ID	External Identifier	nvarchar	20	0
16	ZDPR_OBJLINK	Object link data storage for DPR	11	EXTERNAL_ID	Key of the linked object	nvarchar	255	0
17	ZRPM_OBJ_LINK	Object link data storage	7	EXTERNAL_ID	Key of the linked object	nvarchar	255	0
18	ZRPM_STATUS	RPM Status	2	EXTERNAL_ID	Business Object ID	nvarchar	24	0
TOPBRFplus - ABAP-Based Business Rules
19	FDT_ACTN_1010	FDT: Action - Message Log	8	EXTERNAL_ID	FDT: Universal Unique Identifier	nvarchar	32	0
20	FDT_ACTN_1010A	FDT: Action - Message Log	8	EXTERNAL_ID	FDT: Universal Unique Identifier	nvarchar	32	0
21	FDT_ACTN_1010S	FDT: Action - Message Log	7	EXTERNAL_ID	FDT: Universal Unique Identifier	nvarchar	32	0
22	FDT_ACTN_1010T	FDT: Action - Message Log	7	EXTERNAL_ID	FDT: Universal Unique Identifier	nvarchar	32	0
TOPCommon Functions
23	INM_INITIATIVE	Initiative Master Table	5	EXTERNAL_ID	Initiative ID	nvarchar	24	0
24	INM_INIT_CD	Initiative- Pseudo table for change documents	5	EXTERNAL_ID	Initiative ID	nvarchar	24	0
TOPExternal Project Management Tools
25	DPR_XML_TRANS	Table for Transporting Templates	2	EXTERNAL_ID	Identification of Entities	nvarchar	24	0
TOPGeneric Project Planning
26	CGPL_ARCH_IDX	Project Planning: Index of Archived Projects	3	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
27	CGPL_PROJECT	Project Planning: Attribute Table for Project Headers	3	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
28	CGPL_TASK	Project Planning: Attribute Table for Activities	3	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
TOPGrantor Management
29	GTR_CRM_GPM	CRM Grantor Program Management: Mapping ID/LOGSYS -> GUID	2	EXTERNAL_ID	Grantor Program External Identifier (CRM)	nvarchar	24	0
TOPLean Staffing
30	SAWE_ENHANCED_FC	Enhanced Forecast Objects	6	EXTERNAL_ID	Staff Assignment External ID	nvarchar	10	0
TOPLine Maintenance
31	/ISDFPS/LM_FLI	Flight	20	EXTERNAL_ID	External ID	nvarchar	12	0
TOPLoans Management
32	TDLOS_MAP_TARIF	Loan Origination: Assignment of Insurance Rates	4	EXTERNAL_ID	Key for Insurance Rate	nvarchar	8	0
TOPMaster Data
33	TDCLI_INSURANCE	Table of Credit Life Insurance Rates	2	EXTERNAL_ID	Key for Insurance Rate	nvarchar	8	0
34	TDCLI_INSURANCET	Text Tables for CLI - Rates	3	EXTERNAL_ID	Key for Insurance Rate	nvarchar	8	0
35	TDCLI_INS_1	Table of Credit Life Insurance Rates	1	EXTERNAL_ID	Key for Insurance Rate	nvarchar	8	0
TOPObject Links
36	DPR_OBJLINK	Object Link	11	EXTERNAL_ID	External Identification of Linked Object	ntext	1073741823	0
TOPPortfolio Management
37	/RPM/BUCKET_D	Operational bucket persisted data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
38	/RPM/COLLECTN_D	Collection Persisted Data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
39	/RPM/HIERARCHY_D	Strategic hierarchy persisted data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
40	/RPM/ITEM_D	Operational item persisted data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
41	/RPM/ITEM_H	Operational item persisted data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
42	/RPM/PORTFOLIO_D	Portfolio Operational persisted data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
43	/RPM/PORTFOLIO_S	Portfolio Details persisted data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
44	/RPM/RELATION_D	Portofolio relation object persisted data	6	EXTERNAL_ID	Business Object ID	nvarchar	24	0
45	/RPM/REVIEW_D	Portfolio Review Persisted Data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
46	/RPM/WHATIF_D	What If Persisted Data	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
47	RPM_BUCKET_D_CD	Bucket - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
48	RPM_COLLECTN_CD	Collection - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
49	RPM_DOCUMENT	Document data storage	6	EXTERNAL_ID	ID	nvarchar	24	0
50	RPM_F4LABEL_TAB	Project ID display selection field structure	2	EXTERNAL_ID	External_ID described in Long Text for help	nvarchar	24	0
51	RPM_FES_PRJ_ASGN	Assignments for Project Manager	22	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
52	RPM_FES_PRJ_ROLE	Assignments for Project Manager	22	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
53	RPM_FES_RES_ASGN	To be deleted	22	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
54	RPM_FES_RES_ROLE	To be deleted	22	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
55	RPM_ITEM_D_CD	Item details - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
56	RPM_ITEM_H_CD	Item header - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
57	RPM_OBJ_LINK	Object link data storage	7	EXTERNAL_ID	External Identifier String of Linked Object	ntext	1073741823	0
58	RPM_OBJ_LINK_CD	Object links - Pseudo table for change documents	7	EXTERNAL_ID	External Identifier String of Linked Object	ntext	1073741823	0
59	RPM_PORTFOLIO_CD	Portfolio attributes - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
60	RPM_PROJECT_ARCH	Projects in archive	2	EXTERNAL_ID	ID	nvarchar	24	0
61	RPM_RELATE	RPM: Relationship table	16	EXTERNAL_ID	ID	nvarchar	24	0
62	RPM_RELATE_BKUP	RPM: Relationship table	16	EXTERNAL_ID	ID	nvarchar	24	0
63	RPM_RELATION_CD	Portofolio Relations - Pseudo table for change documents	6	EXTERNAL_ID	Business Object ID	nvarchar	24	0
64	RPM_REVIEW_CD	Portfolio Review - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
65	RPM_WHATIF_D_CD	What If Scenario - Pseudo table for change documents	3	EXTERNAL_ID	Business Object ID	nvarchar	24	0
TOPProject Management
66	CGPL_ARCH_IDX_VS	Project Plan: Index of Archived Projects	5	EXTERNAL_ID	Project Planning: External Indentifier of an Element	nvarchar	24	0
67	CGPL_ENTITY	CGPL Entities	5	EXTERNAL_ID	Identification of Entities	nvarchar	24	0
TOPPromotion
68	WAKH	Promotion Header Data, IS-R	93	EXTERNAL_ID	CGPL Project External ID	nvarchar	24	0
TOPReturnable Packaging Logistics
69	RLEXTID	Conversion of External Partner Descriptions	6	EXTERNAL_ID	Description of Object at Partner	nvarchar	35	0
TOPSocial Services and Social Security
70	PSSCD_SXP	SXP Header Data	7	EXTERNAL_ID	Transaction Number	nvarchar	10	0
TOPStreamWork ABAP Library
71	CLBC_APPLI_DATA	Collaboration: Application Settings for a Target Server	5	EXTERNAL_ID	Collaboration: Application ID at Collaboration Platform	nvarchar	255	0
TOPTransaction Manager
72	TCORIC_SWIFT_FRM	Format-dependent attributes for SWIFT message types	5	EXTERNAL_ID	External format ID	nvarchar	15	0
TOPWeb Service and SOAP - ABAP
73	SRT_CON_SYSTEMS	SOAManager Connectivity : Remote systems for connectivity	4	EXTERNAL_ID	External Service identifier	nvarchar	32	0
74	SRT_IDENTIFIER	Service identifier	2	EXTERNAL_ID	External Service identifier	nvarchar	32	0
TOPWorkforce Management Application
75	WFA_TIMOFFREQ	Time off Requests	19	EXTERNAL_ID	External Identifier	nvarchar	20	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

75 columns | ERP 6.0 | EXTERNAL_ID