	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

87 columns | ERP 6.0 | LTXT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	P05T_IRS_TYPE_T	Income Relationship Split Types (Texts)	3	LTXT	Income Relationship Split Type Text	nvarchar	80	0
TOPBalanced Scorecard
2	UMB_BC_OB101	Strategy Elements: Texts (Business Content)	4	LTXT	Long Text	nvarchar	60	0
3	UMB_BC_PE101	Perspectives: Texts (Business Content)	4	LTXT	Long Text	nvarchar	60	0
4	UMB_BC_SM100T	Strategy Map: Texts	4	LTXT	Long Text	nvarchar	60	0
5	UMB_BC_ST101	Strategies: Texts (Business Content)	4	LTXT	Long Text	nvarchar	60	0
6	UMB_BC_ST104T	Strategy Category: Texts (Business Content)	4	LTXT	Long Text	nvarchar	60	0
7	UMB_CI101	General Initiatives: Texts	4	LTXT	Long Text	nvarchar	60	0
8	UMB_CM100T	Performance Overview: Texts	4	LTXT	Long Text	nvarchar	60	0
9	UMB_CO101	General Objectives: Texts	4	LTXT	Long Text	nvarchar	60	0
10	UMB_CO103	General Objectives: Measure Label Text	5	LTXT	Long Text	nvarchar	60	0
11	UMB_GS101	Value Fields: Texts	4	LTXT	Long Text	nvarchar	60	0
12	UMB_HI101	Scorecard Hierarchy: Texts	4	LTXT	Long Text	nvarchar	60	0
13	UMB_OB101	Objectives: Texts	4	LTXT	Long Text	nvarchar	60	0
14	UMB_PE101	Perspectives : Texts	4	LTXT	Long Text	nvarchar	60	0
15	UMB_RB101	Report Builder: Texts	4	LTXT	Long Text	nvarchar	60	0
16	UMB_RB_BB101	OBSOLETE! Report Builder: Elements - Texts	4	LTXT	Long Text	nvarchar	60	0
17	UMB_RB_DT101	OBSOLETE! Report Builder: Element - Detail - Texts	4	LTXT	Long Text	nvarchar	60	0
18	UMB_RB_SB101	OBSOLETE! Report Builder: Selection Elements - Texts	4	LTXT	Long Text	nvarchar	60	0
19	UMB_SC101	Scorecard: Texts	4	LTXT	Long Text	nvarchar	60	0
20	UMB_SC171T	Scorecard: BW Web Report (Obsolete)	4	LTXT	Long Text	nvarchar	60	0
21	UMB_SC172T	Scorecard: URL (Obsolete)	4	LTXT	Long Text	nvarchar	60	0
22	UMB_SC173T	Scorecard: BW Web Report	5	LTXT	Long Text	nvarchar	60	0
23	UMB_SC174T	Scorecard: URL	5	LTXT	Long Text	nvarchar	60	0
24	UMB_SC181	Scorecard: Texts for Initiatives	5	LTXT	Long Text	nvarchar	60	0
25	UMB_SC198	Scorecard: Initiative: Milestones (Text Table)	6	LTXT	Long Text	nvarchar	60	0
26	UMB_SG100T	Scorecard Group: Texts	4	LTXT	Long Text	nvarchar	60	0
27	UMB_ST101	Strategies: Texts	4	LTXT	Long Text	nvarchar	60	0
28	UMB_ST104T	Strategy Category: Texts	4	LTXT	Long Text	nvarchar	60	0
29	UMB_SV100T	Scorecard View: Texts	4	LTXT	Long Text	nvarchar	60	0
30	UMB_SV101T	Scorecard View: Column Texts	5	LTXT	Long Text	nvarchar	60	0
31	UMB_WIZARD100T	Scorecard Wizard: Activity	3	LTXT	Long Text	nvarchar	60	0
32	UMB_WIZARD101T	Scorecard Wizard: Step	4	LTXT	Long Text	nvarchar	60	0
TOPClinical System
33	N1DCS_DAUERTHE	IS-H*MED: DCS: Quick Entry Long-Term Therapies	8	LTXT	IS-H: Short Text for Billing Item	nvarchar	40	0
34	N1MEDS_DS01T	Medication: Text Table for Alternate Names for Search Fields	5	LTXT	Medication: Alternate Name for Search Fields	nvarchar	23	0
35	N1MEDS_DS12T	Medication: Text Table for Formulary Grouping Areas	4	LTXT	Medication: Long Text	nvarchar	20	0
36	N1MEDS_DS14T	Medication: Text Table for Template Grouping Areas	4	LTXT	Medication: Long Text	nvarchar	20	0
37	TN2CLIM_COMPMST	CLIM: Measurement in Input Element	5	LTXT	CLIM: Name of Input Element	nvarchar	60	0
TOPCorporate Performance Monitor
38	UMC_GS110T	Formula: Texts	4	LTXT	Long Text	nvarchar	60	0
39	UMC_GS120T	Assignment of Formula Result: Texts	4	LTXT	Long Text	nvarchar	60	0
40	UMC_RU100T	Periodization: Texts	4	LTXT	Long Text	nvarchar	60	0
41	UMC_TM100T	Time Variable: Texts	4	LTXT	Long Text	nvarchar	60	0
42	UMR_RI000T	Risk: Category Text Table	4	LTXT	Description	nvarchar	60	0
43	UMR_RI010T	Risk: Group Text Table	4	LTXT	Description	nvarchar	60	0
44	UMR_RI040T	Risk URL Assignment Text Table	5	LTXT	Description	nvarchar	60	0
45	UMR_RI100T	Risk: Text Table	4	LTXT	Description	nvarchar	60	0
46	UMR_RI125T	OBSOLETE RMS: Probability and Risk Intensity Versions Text T	11	LTXT	Long Text	nvarchar	60	0
47	UMR_RI140T	RMS: Risk-Reducing Activities (Text Table)	6	LTXT	Long Text	nvarchar	60	0
48	UMR_RI141T	RMS: Risk-Reducing Activities - Milestones - Text Table	7	LTXT	Long Text	nvarchar	60	0
49	UMR_RI201T	RMS: BW Web Report	4	LTXT	Long Text	nvarchar	60	0
50	UMR_RI202T	RMS: URL	4	LTXT	Long Text	nvarchar	60	0
51	UMR_TL100T	Threat Level: Text Table	4	LTXT	Long Text	nvarchar	60	0
52	UMV_HI101	Value Driver Tree Hierarchy: Text Table	7	LTXT	Long Text	nvarchar	60	0
53	UMV_TR101	Value Driver Tree: Text Table	7	LTXT	Long Text	nvarchar	60	0
54	UMV_TR125T	Obsolete:Val. Driver Tree:Texts Assign. Web Reports to Value	4	LTXT	Long Text	nvarchar	60	0
55	UMV_TR126T	Obsolete: Frame: URL	4	LTXT	Long Text	nvarchar	60	0
56	UMV_TR225T	Value Driver Tree:Text Assignment of Web Reports to Measures	4	LTXT	Long Text	nvarchar	60	0
57	UMV_TR226T	Value driver Tree: Text Assignment URLs to Measures	4	LTXT	Long Text	nvarchar	60	0
58	UMV_VD101	Obsolete: Value Drivers: Text Tables	7	LTXT	Long Text	nvarchar	60	0
TOPDefault Risk and Limit System
59	KLREL_LIMITID_T	Text Table for Limit IDs	4	LTXT	Long Text for Limit ID	nvarchar	30	0
TOPEngineering Change Management
60	ECM_GROUP	Group Assignment for Change Number	6	LTXT	Long Text	nvarchar	1	0
TOPManagement Cockpit
61	UMM_CO103	Cockpits: Texts	4	LTXT	Long Text	nvarchar	60	0
62	UMM_CO105	Cockpits: Texts for the Hierarchy Nodes	4	LTXT	Long Text	nvarchar	60	0
63	UMM_FR103	Frames: Texts	4	LTXT	Long Text	nvarchar	60	0
64	UMM_FR117	Frame: Web Report Text	4	LTXT	Long Text	nvarchar	60	0
65	UMM_FR122	Frame: URL	4	LTXT	Long Text	nvarchar	60	0
66	UMM_LN102	Cockpit Objects: Links and Reports - Texts	7	LTXT	Long Text	nvarchar	60	0
67	UMM_LV102	Logical Views: Texts	4	LTXT	Long Text	nvarchar	60	0
68	UMM_SH100T	Style Sheets: Text Table	4	LTXT	Long Text	nvarchar	60	0
69	UMM_VA101	Variables: Texts	4	LTXT	Long Text	nvarchar	60	0
70	UMM_WA102	Walls: Texts	4	LTXT	Long Text	nvarchar	60	0
TOPMarket Risk Analyzer
71	VTVFGKOGFT	Text Table for Forms of Transaction in IS-B Risk Management	4	LTXT	Text (30 Characters)	nvarchar	30	0
TOPMedical Rounds
72	TN1BALANCETYPET	i.s.h.med: Fluid Balancing, Inflow/Outflow Types, Text Table	5	LTXT	i.s.h.med: Balancing, Inflow/Outflow Type Name	nvarchar	80	0
TOPMessages
73	DNOC_FUNC_PART	Partner func.	6	LTXT	Partner Function Long Text	nvarchar	60	0
74	DNOC_PRIORITYT	Priority Texts	6	LTXT	Priority Long Text	nvarchar	60	0
75	DNOC_TYPE_NOTET	Note Types: Texts	5	LTXT	Note Type Long Text	nvarchar	60	0
76	DNOC_TYPE_PART	Partner Categories: Texts	5	LTXT	Partner Types Long Text	nvarchar	60	0
77	DNOC_TYPE_TEXTT	Text Segment Types: Texts	6	LTXT	Text Segment Type Long Text	nvarchar	60	0
TOPProduction Allocation
78	GHO_SIMU_H_T	Simulation Header Language Dependent Texts	6	LTXT	Simulation Long Text Exists	nvarchar	1	0
TOPReporting
79	P05T_KENT_TXT	Wage Return: Indicator Text Table	5	LTXT	Wage Return: Indicator Text	nvarchar	60	0
80	P05T_NO_XML_TAG	Wage Return: Text Table Feature without XML Tags	5	LTXT	Wage Return: Indicator Text	nvarchar	60	0
81	P05T_T_WCR_CODET	WCR Code Description	5	LTXT	WCR Code Description	nvarchar	50	0
82	P05T_WCR_SYSID_T	Work Cost Regulation: System ID Descriptions	4	LTXT	System ID Description	nvarchar	50	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
83	TNCH50T	IS-H CH: Texts for Billing Agreements	6	LTXT	IS-H CH: Long text for billing agreement	nvarchar	40	0
84	TNWAT_EDI_CODES	IS-H AT: EDIVKA EDI Verfahren Codelisten	9	LTXT	IS-H AT: Verfahren ext. Codeliste aus Subsystemen Langtext	nvarchar	120	0
TOPTime Sheet
85	TCATSD	CATS: Rejection Reasons	3	LTXT	Create Long Text for Rejection Reason	nvarchar	1	0
TOPTravel Expenses
86	T706WWW_TXT	Text Table HTML Links and File Paths	6	LTXT	Text Labels for Links	nvarchar	80	0
TOPTreasury
87	TZ45	Headings for BAV Lists	8	LTXT	Long Text for BAV Lists	nvarchar	255	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

87 columns | ERP 6.0 | LTXT