	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

109 columns | ERP 6.0 | CUSTOMER

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/CPD/D_MP_HDR	Master Project Header	8	CUSTOMER	Customer Number	nvarchar	10	0
2	/IXOS/DC_EX_ADDR	Addresses of a customer	2	CUSTOMER	Customer number	nvarchar	10	0
3	/IXOS/DC_EX_CUST	(J_8AGTD71) Customer	2	CUSTOMER	Customer number	nvarchar	10	0
4	/IXOS/DC_EX_LCP	(J_8AGTD74) Link customer/product	2	CUSTOMER	Customer number	nvarchar	10	0
5	/IXOS/DC_EX_SRM	Customer Documents	2	CUSTOMER	Customer number	nvarchar	10	0
6	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	75	CUSTOMER	Customer Number	nvarchar	10	0
7	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	76	CUSTOMER	Customer Number	nvarchar	10	0
8	ARBERP_D_SI_SO	Inbound Sales Order versioning for inbound messages	3	CUSTOMER	Customer Number	nvarchar	10	0
9	CMCBD_CONSUME	Cash Budgeting Consumption	35	CUSTOMER	Customer Number	nvarchar	10	0
10	CNVCMIS_FIELDS	Explicit conversion rules for fields during migration	4	CUSTOMER	Customer Object	nvarchar	1	0
11	CNVCMIS_FIPARS	parameters for rules mentioned in cnvmbtfields	4	CUSTOMER	Customer Object	nvarchar	1	0
12	CNVCMIS_MAPPING	Table for storing information about the mapping	10	CUSTOMER	Customer Object	nvarchar	1	0
13	CNVCMIS_NTR_STRU	Information about the known values of nontransparent field	12	CUSTOMER	Customer Object	nvarchar	1	0
14	CNVMBT09TABLE	Tables to be processed	12	CUSTOMER	Flag indicating that table is found in customer system	nvarchar	1	0
15	CNVMBTCHECKS	MBT Checks	4	CUSTOMER	Customer Object	nvarchar	1	0
16	CNVMBTCOBJ	conversion objects	4	CUSTOMER	Customer Object	nvarchar	1	0
17	CNVMBTFIELDS	explicite conversion rules for fields during migration	4	CUSTOMER	Customer Object	nvarchar	1	0
18	CNVMBTFIPARS	parameters for rules mentioned in cnvmbtfields	4	CUSTOMER	Customer Object	nvarchar	1	0
19	CNVMBTFORKEY	Foreign key releations in structure + fixed values	4	CUSTOMER	Customer Object	nvarchar	1	0
20	CNVMBTTABLES	explicite list of tables to be handled during migration	4	CUSTOMER	Customer Object	nvarchar	1	0
21	CNVMBTTABSTRUC	Field list of tables for file transfer	4	CUSTOMER	Customer Object	nvarchar	1	0
22	CNVMBTTREE	Structure of conversion object / hierachy	4	CUSTOMER	Customer Object	nvarchar	1	0
23	CNVMBT_DEL_TABLE	Table to be processed	12	CUSTOMER	Just one character	nvarchar	1	0
24	CNVTDMSBW_ALLOBJ	All Objects and their tables	9	CUSTOMER	Customer Object	nvarchar	1	0
25	CNVTDMSBW_EXLOBJ	Objects in BW system and conversion object mapping	7	CUSTOMER	Customer Object	nvarchar	1	0
26	CNVTDMSBW_OBJDT	Objects in BW system and conversion object mapping	6	CUSTOMER	Customer Object	nvarchar	1	0
27	CNVTDMS_08_FIELD	explicite conversion rules for fields during migration	5	CUSTOMER	Customer Object	nvarchar	1	0
28	CNVTDMS_08_FIPAR	parameters for rules mentioned in cnvmbtfields	5	CUSTOMER	Customer Object	nvarchar	1	0
29	CNVTDMS_09_TABLE	Tables to be processed	12	CUSTOMER	Flag indicating that table is found in customer system	nvarchar	1	0
30	CNV_20100_BPRIO	Priority control for B-level	10	CUSTOMER	Single-Character Indicator	nvarchar	1	0
31	CNV_MBT_09_TABLE	Tables for table deletion	12	CUSTOMER	Just one character	nvarchar	1	0
32	DMC_UPG_CPROJ	MWB: Customer Project	1	CUSTOMER	MWB: Customer	nvarchar	20	0
33	DMC_UPG_CP_REL	MWB: Release Upgrades in a Customer Project	1	CUSTOMER	MWB: Customer	nvarchar	20	0
34	DMC_UPG_CUST	MWB: Customer Data for a Project	1	CUSTOMER	MWB: Customer	nvarchar	20	0
35	EPIC_CBC	EPIC:Cash budgeting control consumption table	12	CUSTOMER	Customer Number	nvarchar	10	0
36	EPIC_CBC_EBR	Cash Budgeting Control of Bank Receipt	9	CUSTOMER	Customer Number	nvarchar	10	0
37	FIEUD_SBINV_H	SAFT: Self Billing Invoices (Header)- (MM)	32	CUSTOMER	Customer Number	nvarchar	10	0
38	FIEUD_SDINV_H	SAFT: Invoices from SD module(Header)	30	CUSTOMER	Customer Number	nvarchar	10	0
39	MRP_BUF_DEM_ITEM	Supply demand items and uncovered demand items	20	CUSTOMER	Customer Number	nvarchar	10	0
40	PPH_CACHE_ITEM	Supply demand items and uncovered demand items	21	CUSTOMER	Customer Number	nvarchar	10	0
41	QAM_L_BCV_A	QIM: Temporary Storage Activities f. Business Context Viewer	9	CUSTOMER	Customer	nvarchar	10	0
42	QAM_L_BCV_I	QIM: Temporary Storage Issues for Business Context Viewer	10	CUSTOMER	Customer	nvarchar	10	0
43	REFXCN_IDOC	REFX POS IDOC Inbound data	3	CUSTOMER	Customer number of plant	nvarchar	10	0
44	REFXCN_IDOCTAB	REFX POS IDOC Inbound data	4	CUSTOMER	Customer number of plant	nvarchar	10	0
45	SRA019_T_CONFIG	Shipment Customer Configuration	3	CUSTOMER	Customer Number	nvarchar	10	0
46	ZATPCUSTSITE	ATP Check: Customer Site Mapping	2	CUSTOMER	Customer Number	nvarchar	10	0
47	ZQUOTAB1	Quotation details	2	CUSTOMER	Character field of length 40	nvarchar	40	0
TOPAccounts Receivable Accounting Process Integration
48	FDM_INVOICE_MEM	Invoice Information Provided	6	CUSTOMER	Customer Number	nvarchar	10	0
TOPAgency Business Global Trade
49	WBRP	Agency business: Item	156	CUSTOMER	Customer	nvarchar	10	0
TOPAMI Event Management
50	EFDT_EXPR003	FDT: Expression - Create Service Order	9	CUSTOMER	Customer Number	nvarchar	10	0
51	EFDT_EXPR003A	FDT: Expression - Create Service Order	9	CUSTOMER	Customer Number	nvarchar	10	0
52	EFDT_EXPR003S	FDT: Expression - Create Service Order	8	CUSTOMER	Customer Number	nvarchar	10	0
53	EFDT_EXPR003T	FDT: Expression - Create Service Order	8	CUSTOMER	Customer Number	nvarchar	10	0
TOPBI Content Analyzer
54	RSCONTCHECKPROP	BI Content Checks Properties	6	CUSTOMER	Boolean Variable (X=True, -=False, Space=Unknown)	nvarchar	1	0
TOPBusiness Partner Enhancements for Financial Services
55	BP000	Business Partner Master (General Data)	8	CUSTOMER	Customer Number	nvarchar	10	0
TOPClinical System
56	N2HIT_ENTRY	HL: Hit List Entry	3	CUSTOMER	General Flag	nvarchar	1	0
57	N2HIT_ENTT	HL: Text Table for /MED/GA_HL_ENTRY	4	CUSTOMER	General Flag	nvarchar	1	0
58	N2HIT_EN_OB	HL: Assignment: Hit List Entry -> Assigned Object	4	CUSTOMER	General Flag	nvarchar	1	0
59	N2HIT_EN_OT	HL: Text Table for /MED/N2HIT_EN_OB	5	CUSTOMER	General Flag	nvarchar	1	0
TOPCollections Management
60	UDM_CCT_ATTR	Customer Contact	3	CUSTOMER	Business Partner Number	nvarchar	10	0
61	UDM_RSM_ATTR	Resubmissions	3	CUSTOMER	Business Partner Number	nvarchar	10	0
TOPCondition Technique
62	/SAPCND/UE_RANGE	Userexit Formula Number Range	7	CUSTOMER	Customer System: TRESC checks enabled	nvarchar	1	0
TOPControlling
63	IAOM_CPRO_EXAT	External Characteristics of an Object in cProjects	14	CUSTOMER	Sold-to party	nvarchar	10	0
TOPCross-Application Component CA Enhancements
64	/SAPMP/MIG_T002	Migration CS -> DIMP: Object Status Batch Stock	8	CUSTOMER	Customer Number	nvarchar	10	0
TOPCross-Application Components
65	ETP_TASKS	Easy Task Planning: Tasks	12	CUSTOMER	128 character	nvarchar	128	0
TOPDealer Portal
66	/SAPDII/SPPSHIPA	Maintaining Alternate shipping locations	4	CUSTOMER	Customer Number	nvarchar	10	0
TOPDirect Store Delivery
67	/DSD/DX_HD	DEX Stream Header (backend)	2	CUSTOMER	Customer Number	nvarchar	10	0
TOPDistributor-Reseller-Management
68	/SAPHT/DRMSLSRPT	DRM 867 Outbound processing table	8	CUSTOMER	Customer Number	nvarchar	10	0
TOPElectronic Data Interchange
69	PRICAT_K001	PRICAT: Catalog header	10	CUSTOMER	Customer Number	nvarchar	10	0
70	PRICAT_K003S	PRICAT: Status of the Catalog Item per Customer	6	CUSTOMER	Customer Number	nvarchar	10	0
71	PRICAT_K008C	PRICAT: Catalog Item Prices/Conditions/Taxes per Customer	6	CUSTOMER	Customer Number	nvarchar	10	0
72	PRICAT_K009C	PRICAT: Catalog Item Scales for Condition for Customer	6	CUSTOMER	Customer Number	nvarchar	10	0
73	PRICAT_K00C	PRICAT: Customer of a Price Catalog	3	CUSTOMER	Customer Number	nvarchar	10	0
74	PRISBCPARA	PRICAT: SBC Parameters for PRICAT Customers	1	CUSTOMER	Customer Number	nvarchar	10	0
TOPEngineering Change Record
75	/PLMI/ECR_HDR	Engineering Change Record Header data	4	CUSTOMER	Customer Number 1	nvarchar	10	0
TOPEnvironment, Health and Safety
76	/TDAG/CPT_TASKH	Header data for tasks	11	CUSTOMER	Customer Number	nvarchar	10	0
77	/TDAG/CPT_TASKHA	CP: Kopfdaten für Aufgaben / Archiv	11	CUSTOMER	Customer Number	nvarchar	10	0
78	/TDAG/CPT_TRCKH	Obsolete - CP: Tracker - Kopfdaten	7	CUSTOMER	Customer Number	nvarchar	10	0
79	/TDAG/CPT_TRCKHA	Obsolete - CP: Tracker - Kopfdaten / Archiv	7	CUSTOMER	Customer Number	nvarchar	10	0
80	/TDAG/RCSA_CAPOS	Campaign position data	6	CUSTOMER	Customer	nvarchar	10	0
TOPERP related topics
81	/MRSS/D_RM_ROUT2	Routing table to determing Resource management Groups	13	CUSTOMER	Customer Number	nvarchar	10	0
TOPFinancials Basis
82	UBC_TB_CEDATA	Cost Events	4	CUSTOMER	Customer ID	nvarchar	20	0
TOPGL Account Posting
83	TCJ_POSITIONS	Cash Journal Document Items	22	CUSTOMER	Customer Number	nvarchar	10	0
TOPGlobal Trade
84	WB2_D_COMSUB	Trading Contract: commodity sub items	27	CUSTOMER	Sold-to party	nvarchar	10	0
85	WB2_D_SHD_ITEM	Shadow Items	16	CUSTOMER	Sold-to party	nvarchar	10	0
TOPGrantor Management
86	GTRCUST_ACCGRP	Assignment Customer -> Customer account groups	3	CUSTOMER	Customer Number	nvarchar	10	0
TOPInteraction Center WebClient
87	CRMC_IC_EMAIL	Email client customizing table	4	CUSTOMER	Default To Address in New E-Mail	nvarchar	1	0
TOPJoint Venture und Production Sharing Accounting
88	T8PSA_LIFT_TERM	Lifting Volumes by terminal	14	CUSTOMER	Customer Number	nvarchar	10	0
89	T8PSA_LIFT_VOL	Lifting Volumes	21	CUSTOMER	Customer Number	nvarchar	10	0
TOPMarketing, Accounting and Pricing
90	OICQOIL	F&A Oil Table for Repository Default	3	CUSTOMER	F&A repository customer	nvarchar	10	0
TOPMaster Data Synchronization
91	CVI_CUST_LINK	Assignment Between Customer and Business Partner	3	CUSTOMER	Customer Number	nvarchar	10	0
TOPMaterials Management
92	J_1GMM2GV	End year inventory	8	CUSTOMER	Customer Number	nvarchar	10	0
TOPMessages
93	DNOD_NOTIF_TA	Notification: Data for Task Planning	8	CUSTOMER	128 character	nvarchar	128	0
TOPOverhead Cost Controlling
94	TKALV	Control Parameter for Line Item Report with AAA	4	CUSTOMER	Customer Entry	nvarchar	1	0
TOPPayment Transactions
95	TFIBLAPARPVAR	Online Payment: Variants	4	CUSTOMER	Customer Number	nvarchar	10	0
TOPPerishables Procurement
96	FIP_D_PDT_TO_CUS	Internal planned delivery time from suppl. Plant to customer	4	CUSTOMER	Customer Number	nvarchar	10	0
97	FIP_D_PROMO	Promotion data	5	CUSTOMER	Customer Number	nvarchar	10	0
TOPRemaining Beverage - Obsolete Objects
98	/BEV3/CHCDPBK	CDP: Purchase Control Results	10	CUSTOMER	Customer Number of Sold-to Party	nvarchar	10	0
99	/BEV3/CHCDPSALES	CDP: Contract Sales (Detailed)	11	CUSTOMER	Customer Number of Sold-to Party	nvarchar	10	0
TOPRental Accounting
100	VIRAINV	RE Invoice Header	18	CUSTOMER	Customer Number	nvarchar	10	0
TOPReusable Components of Business Suite Foundation
101	/BOFU/SO_BUPA_RT	Sales Order Business Partner Root Table	7	CUSTOMER		nvarchar	30	0
TOPSAP NetWeaver Mobile - Use subcomponents
102	MEREP_TEST_CUST	MI Test Tool - Customize Tables with Values	5	CUSTOMER	General Flag	nvarchar	1	0
TOPSpecification 2
103	SPCPRTNRINF	Partner Information for SPEC 2000 message	5	CUSTOMER	Customer Identification Code	nvarchar	5	0
TOPStructure
104	DPR_PROJECT	Project Definition	24	CUSTOMER	Business Partner GUID	varbinary	16	0
TOPStructures
105	PSHLP_CUST_DPROF	Data Selection Profile	11	CUSTOMER	Customer	nvarchar	1	0
106	PSHLP_DATASET_DB	To store the user specific datasets chosen	12	CUSTOMER	Single-Character Indicator	nvarchar	1	0
TOPTrading Contract
107	WB2_D_STRING	Logistical string,circle and washout	7	CUSTOMER	Sold-to party	nvarchar	10	0
TOPWeb Channel UM ERP aspects
108	ERPD_WEC_CU_DFPM	Default Payment method for a Customer ( Web Channel )	2	CUSTOMER	Customer Number	nvarchar	10	0
109	ERPD_WEC_CU_PAYM	Customer Payment Methods ( Web Channel )	3	CUSTOMER	Customer 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

109 columns | ERP 6.0 | CUSTOMER