SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

184 columns | Print definition?ERP 6.0  | VARDATA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/014VARDATAvarbinary38000
2/NAKISA/C16VARDATAvarbinary38000
3AABLG6VARDATAvarbinary38000
4AANK4VARDATAvarbinary5000
5AANL4VARDATAvarbinary5000
6ATAB4VARDATAvarbinary9040
7BPHIER4VARDATAvarbinary38000
8CDCLS8VARDATAvarbinary38000
9CFIS4VARDATAvarbinary38000
10CLU45VARDATAvarbinary38000
11CLUSTERVER5VARDATAvarbinary38000
12CLUTAB6VARDATAvarbinary38000
13CRVP4VARDATAvarbinary38000
14CVEP16VARDATAvarbinary38000
15CVEP25VARDATAvarbinary38000
16CVER16VARDATAvarbinary38000
17CVER25VARDATAvarbinary38000
18CVER36VARDATAvarbinary38000
19CVER45VARDATAvarbinary38000
20CVER56VARDATAvarbinary38000
21DBMAPS4VARDATAvarbinary3000
22DEBI4VARDATAvarbinary5000
23DOCCLV9VARDATAvarbinary38000
24DOKCL9VARDATAvarbinary38000
25DOKCLU9VARDATAvarbinary38000
26DSYCLV8VARDATAvarbinary38000
27DSYO17VARDATAvarbinary38000
28DSYO25VARDATAvarbinary38000
29DSYO36VARDATAvarbinary38000
30DVPOOL4VARDATAvarbinary15000
31DVPOOLTEXT4VARDATAimage21474836470
32EDI30C7VARDATAvarbinary38000
33EDI407VARDATAvarbinary38000
34EDIDOC6VARDATAvarbinary38000
35EPIDXB11VARDATAvarbinary38000
36EPIDXC12VARDATAvarbinary38000
37FINPL4VARDATAvarbinary38000
38GLS2CLUS9VARDATAvarbinary38000
39GLSP4VARDATAvarbinary8000
40GLTP4VARDATAvarbinary20000
41IMPREDOC6VARDATAvarbinary38000
42J_5K_LFCL8VARDATAvarbinary38000
43J_CLU5VARDATAvarbinary38000
44KALK4VARDATAvarbinary5000
45KAPOL4VARDATAvarbinary360
46KBPOL4VARDATAvarbinary38000
47KCPOL4VARDATAvarbinary200
48KDPOL4VARDATAvarbinary500
49KEPOOL4VARDATAvarbinary1200
50KGPOL4VARDATAvarbinary200
51KOCLU6VARDATAvarbinary38000
52KRED4VARDATAvarbinary5000
53LDAN4VARDATAvarbinary5000
54LDKO4VARDATAvarbinary4000
55LISA4VARDATAvarbinary10000
56MAT14VARDATAvarbinary5000
57MBAN4VARDATAvarbinary5000
58MBMP4VARDATAvarbinary5000
59MBRK4VARDATAvarbinary5000
60MCLIB4VARDATAvarbinary38000
61MEIN4VARDATAvarbinary5000
62MEKK4VARDATAvarbinary5000
63MEOR4VARDATAvarbinary5000
64MSAK4VARDATAvarbinary5000
65MSPOOL4VARDATAvarbinary38000
66MWOFF_CL8VARDATAvarbinary38000
67M_AANL4VARDATAvarbinary5000
68M_ADMC4VARDATAvarbinary5000
69M_ADRC4VARDATAvarbinary5000
70M_ADRP4VARDATAvarbinary5000
71M_AEN14VARDATAvarbinary5000
72M_BUPA4VARDATAvarbinary5000
73M_CF014VARDATAvarbinary5000
74M_CLAS4VARDATAvarbinary5000
75M_CLFN4VARDATAvarbinary5000
76M_ESM24VARDATAvarbinary5000
77M_FDUP4VARDATAvarbinary5000
78M_FPVT4VARDATAvarbinary5000
79M_IBEW4VARDATAvarbinary5000
80M_IFLM4VARDATAvarbinary5000
81M_IIMA4VARDATAvarbinary5000
82M_IRLM4VARDATAvarbinary5000
83M_J1BA4VARDATAvarbinary5000
84M_J1IA4VARDATAvarbinary5000
85M_J1IB4VARDATAvarbinary5000
86M_J1ID4VARDATAvarbinary5000
87M_J1IH4VARDATAvarbinary5000
88M_J1IK4VARDATAvarbinary5000
89M_KLSW4VARDATAvarbinary5000
90M_KMNR4VARDATAvarbinary5000
91M_LOBJ4VARDATAvarbinary5000
92M_MCA14VARDATAvarbinary5000
93M_MCA24VARDATAvarbinary5000
94M_MCBM4VARDATAvarbinary5000
95M_MCEA4VARDATAvarbinary5000
96M_MCEM4VARDATAvarbinary5000
97M_MCES4VARDATAvarbinary5000
98M_MCGB4VARDATAvarbinary5000
99M_MCGU4VARDATAvarbinary5000
100M_MCHA4VARDATAvarbinary5000
101M_MCOB4VARDATAvarbinary5000
102M_MERK4VARDATAvarbinary5000
103M_MJB24VARDATAvarbinary5000
104M_MJB34VARDATAvarbinary5000
105M_MJB44VARDATAvarbinary5000
106M_MJB54VARDATAvarbinary5000
107M_MJBU4VARDATAvarbinary5000
108M_MJBV4VARDATAvarbinary5000
109M_MJBW4VARDATAvarbinary5000
110M_MJBX4VARDATAvarbinary5000
111M_MJBZ4VARDATAvarbinary5000
112M_MREA4VARDATAvarbinary5000
113M_MSAK4VARDATAvarbinary5000
114M_MTLN4VARDATAvarbinary5000
115M_MTVM4VARDATAvarbinary5000
116M_MTVN4VARDATAvarbinary5000
117M_MTVO4VARDATAvarbinary5000
118M_MVER4VARDATAvarbinary5000
119M_MWAK4VARDATAvarbinary5000
120M_OBJE4VARDATAvarbinary5000
121M_PTER4VARDATAvarbinary5000
122M_PTRM4VARDATAvarbinary5000
123M_SFIP4VARDATAvarbinary5000
124M_SPBB4VARDATAvarbinary5000
125M_SWZA4VARDATAvarbinary5000
126M_VMCF4VARDATAvarbinary5000
127M_VMVK4VARDATAvarbinary5000
128M_VTBS4VARDATAvarbinary5000
129M_VTMA4VARDATAvarbinary5000
130M_VTOF4VARDATAvarbinary5000
131M_WASV4VARDATAvarbinary5000
132M_WDEP4VARDATAvarbinary5000
133M_WORD4VARDATAvarbinary5000
134M_WPAN4VARDATAvarbinary5000
135NCOM4VARDATAvarbinary20480
136ORDE4VARDATAvarbinary5000
137PCDCLS8VARDATAvarbinary38000
138PLOM4VARDATAvarbinary5000
139PRCD_CLUST7VARDATAvarbinary38000
140PTEST14VARDATAvarbinary38000
141PVER14VARDATAvarbinary38000
142QDPT4VARDATAvarbinary38000
143REBL4VARDATAvarbinary5000
144REGUC13VARDATAvarbinary38000
145RFBLG8VARDATAvarbinary38000
146RFMHN15VARDATAvarbinary38000
147RKEPI8VARDATAvarbinary38000
148SAKO4VARDATAvarbinary5000
149SFCPL4VARDATAvarbinary38000
150SFHOA7VARDATAvarbinary38000
151SFHYT7VARDATAvarbinary38000
152SFWPL4VARDATAvarbinary38000
153SMPOOL4VARDATAvarbinary38000
154T512CLU9VARDATAvarbinary38000
155TERCL7VARDATAvarbinary38000
156TERCL27VARDATAvarbinary38000
157TERCL36VARDATAvarbinary38000
158TESCL5VARDATAvarbinary38000
159TESPO4VARDATAvarbinary38000
160TESTCLUST15VARDATAvarbinary38000
161UMG_TEST_C5VARDATAvarbinary38000
162UMG_TEST_F5VARDATAvarbinary38000
163UMG_TEST_P4VARDATAvarbinary38000
164UMG_TEST_S4VARDATAvarbinary400
165UTAB4VARDATAvarbinary38000
166VBCLU6VARDATAvarbinary38000
167VBFCL6VARDATAvarbinary38000
168VBLOG5VARDATAvarbinary38000
169VBMC4VARDATAvarbinary5000
170VERCLUSTER5VARDATAvarbinary38000
171VER_CLUSTR6VARDATAvarbinary38000
172VIND4VARDATAvarbinary3000
173VLIM4VARDATAvarbinary5000
174VMCV4VARDATAvarbinary5000
175VPOOL4VARDATAvarbinary10000
176VTEST106VARDATAvarbinary38000
177VTEST114VARDATAvarbinary4520
178YMUS4VARDATAvarbinary38000
TOPAdvertising Management
179JHTMEMORYIS-M/AM: Buffering Table for Order Data Transfer18VARDATAIS-M: Variable data part for order data transfernvarchar18000
180JHTVMEMORYIS-M/AM: Buffering Table for Contract Data Transfer18VARDATAIS-M: Variable data part for order data transfernvarchar18000
TOPMaster Data
181JGTMEMORYIS-M/SD: Buffer Table for Data Transfer15VARDATAIS-M: Variable Part for BP Data Transferntext10737418230
182RJGTEXTORDIS-M/AM: Transfer Business Partner from Technical System8VARDATAIS-M: Variable Part for BP Data Transferntext10737418230
TOPPeriodical Sales and Distribution
183JKTMEMORYIS-M/SD: Buffer Table for Order Data Transfer16VARDATAIS-M: Variable data part for order data transfernvarchar18000
TOPUI Services, Screen, Batch Input
184APQDDATA DEFINITION Queue7VARDATALong String Used to Store BDC Objects in the Databasentext10737418230