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

135 columns | Print definition?ERP 6.0  | DATALN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/013DATALNsmallint50
2AANK3DATALNsmallint50
3AANL3DATALNsmallint50
4ATAB3DATALNsmallint50
5BPHIER3DATALNsmallint50
6CFIS3DATALNsmallint50
7CRVP3DATALNsmallint50
8DBMAPS3DATALNsmallint50
9DEBI3DATALNsmallint50
10DVPOOL3DATALNsmallint50
11DVPOOLTEXT3DATALNsmallint50
12FINPL3DATALNsmallint50
13GLSP3DATALNsmallint50
14GLTP3DATALNsmallint50
15KALK3DATALNsmallint50
16KAPOL3DATALNsmallint50
17KBPOL3DATALNsmallint50
18KCPOL3DATALNsmallint50
19KDPOL3DATALNsmallint50
20KEPOOL3DATALNsmallint50
21KGPOL3DATALNsmallint50
22KRED3DATALNsmallint50
23LDAN3DATALNsmallint50
24LDKO3DATALNsmallint50
25LISA3DATALNsmallint50
26MAT13DATALNsmallint50
27MBAN3DATALNsmallint50
28MBMP3DATALNsmallint50
29MBRK3DATALNsmallint50
30MCLIB3DATALNsmallint50
31MEIN3DATALNsmallint50
32MEKK3DATALNsmallint50
33MEOR3DATALNsmallint50
34MSAK3DATALNsmallint50
35MSPOOL3DATALNsmallint50
36M_AANL3DATALNsmallint50
37M_ADMC3DATALNsmallint50
38M_ADRC3DATALNsmallint50
39M_ADRP3DATALNsmallint50
40M_AEN13DATALNsmallint50
41M_BUPA3DATALNsmallint50
42M_CF013DATALNsmallint50
43M_CLAS3DATALNsmallint50
44M_CLFN3DATALNsmallint50
45M_ESM23DATALNsmallint50
46M_FDUP3DATALNsmallint50
47M_FPVT3DATALNsmallint50
48M_IBEW3DATALNsmallint50
49M_IFLM3DATALNsmallint50
50M_IIMA3DATALNsmallint50
51M_IRLM3DATALNsmallint50
52M_J1BA3DATALNsmallint50
53M_J1IA3DATALNsmallint50
54M_J1IB3DATALNsmallint50
55M_J1ID3DATALNsmallint50
56M_J1IH3DATALNsmallint50
57M_J1IK3DATALNsmallint50
58M_KLSW3DATALNsmallint50
59M_KMNR3DATALNsmallint50
60M_LOBJ3DATALNsmallint50
61M_MCA13DATALNsmallint50
62M_MCA23DATALNsmallint50
63M_MCBM3DATALNsmallint50
64M_MCEA3DATALNsmallint50
65M_MCEM3DATALNsmallint50
66M_MCES3DATALNsmallint50
67M_MCGB3DATALNsmallint50
68M_MCGU3DATALNsmallint50
69M_MCHA3DATALNsmallint50
70M_MCOB3DATALNsmallint50
71M_MERK3DATALNsmallint50
72M_MJB23DATALNsmallint50
73M_MJB33DATALNsmallint50
74M_MJB43DATALNsmallint50
75M_MJB53DATALNsmallint50
76M_MJBU3DATALNsmallint50
77M_MJBV3DATALNsmallint50
78M_MJBW3DATALNsmallint50
79M_MJBX3DATALNsmallint50
80M_MJBZ3DATALNsmallint50
81M_MREA3DATALNsmallint50
82M_MSAK3DATALNsmallint50
83M_MTLN3DATALNsmallint50
84M_MTVM3DATALNsmallint50
85M_MTVN3DATALNsmallint50
86M_MTVO3DATALNsmallint50
87M_MVER3DATALNsmallint50
88M_MWAK3DATALNsmallint50
89M_OBJE3DATALNsmallint50
90M_PTER3DATALNsmallint50
91M_PTRM3DATALNsmallint50
92M_SFIP3DATALNsmallint50
93M_SPBB3DATALNsmallint50
94M_SWZA3DATALNsmallint50
95M_VMCF3DATALNsmallint50
96M_VMVK3DATALNsmallint50
97M_VTBS3DATALNsmallint50
98M_VTMA3DATALNsmallint50
99M_VTOF3DATALNsmallint50
100M_WASV3DATALNsmallint50
101M_WDEP3DATALNsmallint50
102M_WORD3DATALNsmallint50
103M_WPAN3DATALNsmallint50
104NCOM3DATALNsmallint50
105ORDE3DATALNsmallint50
106PLOM3DATALNsmallint50
107PTEST13DATALNsmallint50
108PVER13DATALNsmallint50
109QDPT3DATALNsmallint50
110REBL3DATALNsmallint50
111SAKO3DATALNsmallint50
112SFCPL3DATALNsmallint50
113SFWPL3DATALNsmallint50
114SMPOOL3DATALNsmallint50
115TESPO3DATALNsmallint50
116UMG_TEST_P3DATALNsmallint50
117UMG_TEST_S3DATALNsmallint50
118UTAB3DATALNsmallint50
119VBMC3DATALNsmallint50
120VIND3DATALNsmallint50
121VLIM3DATALNsmallint50
122VMCV3DATALNsmallint50
123VPOOL3DATALNsmallint50
124VTEST113DATALNsmallint50
125YMUS3DATALNsmallint50
TOPABAP Runtime Environment
126DBTABPRTTable of log records for table tupel changes11DATALNActual length of vardatasmallint50
TOPAdvertising Management
127JHTMEMORYIS-M/AM: Buffering Table for Order Data Transfer17DATALNActual length of vardatasmallint50
128JHTVMEMORYIS-M/AM: Buffering Table for Contract Data Transfer17DATALNActual length of vardatasmallint50
TOPAudit trail enhancements ILM
129AUT_D_DBTABLOGAudit Trail (ILM): Storage of Archived Table Logs13DATALNActual length of vardatasmallint50
TOPDB-Independent Database Interface
130DBTABLOGLog Records of Table Changes13DATALNActual length of vardatasmallint50
TOPGRC Process Control Plug-in
131/GRCPI/GRIASNAPAM - Capture snapshot of change log4DATALNActual length of vardatasmallint50
TOPMaster Data
132JGTMEMORYIS-M/SD: Buffer Table for Data Transfer14DATALNActual length of vardatasmallint50
133RJGTEXTORDIS-M/AM: Transfer Business Partner from Technical System7DATALNActual length of vardatasmallint50
TOPPeriodical Sales and Distribution
134JKTMEMORYIS-M/SD: Buffer Table for Order Data Transfer15DATALNActual length of vardatasmallint50
TOPProcess Controls -Automated Controls
135GRPCRTA_GRPCSNAPGRC Change Log: Capture snapshot of change log4DATALNActual length of vardatasmallint50