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

147 columns | Print definition?ERP 6.0  | VARKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/01000028ATAB5VARKEYnvarchar500
2/NAKISA/012VARKEYnvarchar1100
3/NAKISA/C12VARKEYnvarchar1100
4/NAKISA/C1_DBSTGDashboard Analytics staged data3VARKEYnvarchar1050
5/NAKISA/C2_IMPDashboard analytics import parameters temporary table3VARKEYnvarchar1050
6/NAKISA/P1Dashboard Performance Potential - Performance2VARKEYnvarchar1100
7/NAKISA/P2Dashboard Performance Potential - Potential2VARKEYnvarchar1100
8/NAKISA/PPDashboard Performance Potential per user2VARKEYnvarchar1100
9AANK2VARKEYnvarchar1100
10AANL2VARKEYnvarchar1100
11ATAB2VARKEYnvarchar500
12BPHIER2VARKEYnvarchar1100
13CFIS2VARKEYnvarchar1100
14CNVTDMSSCR_KEYSTable Keys for Conditional Scrambling5VARKEYCommentnvarchar500
15CNVTDMSSCR_MATABScrambling Final Mapping Table4VARKEYScrambling Variable Keynvarchar500
16CNVTDMSSCR_MTABScrambling Final Mapping Table4VARKEYScrambling Variable Keynvarchar500
17CNVTDMSSCR_RATABScrambling Random Table4VARKEYScrambling Variable Keynvarchar500
18CNVTDMSSCR_RTABScrambling Random Table4VARKEYScrambling Variable Keynvarchar500
19CRVP2VARKEYnvarchar1100
20DBMAPS2VARKEYnvarchar600
21DEBI2VARKEYnvarchar1100
22DMC_RESTARTRestart handling: Assignment of message ID to sender keys2VARKEYnvarchar2550
23DVPOOL2VARKEYnvarchar1100
24DVPOOLTEXT2VARKEYnvarchar1100
25EDOPENUMBERAssign Series and Number Range to Document Type4VARKEYeDocument: Variable Keynvarchar100
26FINPL2VARKEYnvarchar1100
27GLSP2VARKEYnvarchar1100
28GLTP2VARKEYnvarchar1100
29KALK2VARKEYnvarchar1100
30KAPOL2VARKEYnvarchar650
31KBPOL2VARKEYnvarchar650
32KCPOL2VARKEYnvarchar590
33KDPOL2VARKEYnvarchar670
34KEPOOL2VARKEYnvarchar800
35KGPOL2VARKEYnvarchar670
36KRED2VARKEYnvarchar1100
37LDAN2VARKEYnvarchar250
38LDKO2VARKEYnvarchar250
39LISA2VARKEYnvarchar1100
40MAT12VARKEYnvarchar1100
41MBAN2VARKEYnvarchar1100
42MBMP2VARKEYnvarchar1100
43MBRK2VARKEYnvarchar1100
44MCLIB2VARKEYnvarchar1100
45MEIN2VARKEYnvarchar1100
46MEKK2VARKEYnvarchar1100
47MEOR2VARKEYnvarchar1100
48MSAK2VARKEYnvarchar1100
49MSPOOL2VARKEYnvarchar1100
50M_AANL2VARKEYnvarchar1100
51M_ADMC2VARKEYnvarchar1100
52M_ADRC2VARKEYnvarchar1100
53M_ADRP2VARKEYnvarchar1100
54M_AEN12VARKEYnvarchar1100
55M_BUPA2VARKEYnvarchar1100
56M_CF012VARKEYnvarchar1100
57M_CLAS2VARKEYnvarchar1100
58M_CLFN2VARKEYnvarchar1100
59M_ESM22VARKEYnvarchar1100
60M_FDUP2VARKEYnvarchar1100
61M_FPVT2VARKEYnvarchar1100
62M_IBEW2VARKEYnvarchar1100
63M_IFLM2VARKEYnvarchar1100
64M_IIMA2VARKEYnvarchar1100
65M_IRLM2VARKEYnvarchar1100
66M_J1BA2VARKEYnvarchar1100
67M_J1IA2VARKEYnvarchar1100
68M_J1IB2VARKEYnvarchar1100
69M_J1ID2VARKEYnvarchar1100
70M_J1IH2VARKEYnvarchar1100
71M_J1IK2VARKEYnvarchar1100
72M_KLSW2VARKEYnvarchar1100
73M_KMNR2VARKEYnvarchar1100
74M_LOBJ2VARKEYnvarchar1100
75M_MCA12VARKEYnvarchar1100
76M_MCA22VARKEYnvarchar1100
77M_MCBM2VARKEYnvarchar1100
78M_MCEA2VARKEYnvarchar1100
79M_MCEM2VARKEYnvarchar1100
80M_MCES2VARKEYnvarchar1100
81M_MCGB2VARKEYnvarchar1100
82M_MCGU2VARKEYnvarchar1100
83M_MCHA2VARKEYnvarchar1100
84M_MCOB2VARKEYnvarchar1100
85M_MERK2VARKEYnvarchar1100
86M_MJB22VARKEYnvarchar1100
87M_MJB32VARKEYnvarchar1100
88M_MJB42VARKEYnvarchar1100
89M_MJB52VARKEYnvarchar1100
90M_MJBU2VARKEYnvarchar1100
91M_MJBV2VARKEYnvarchar1100
92M_MJBW2VARKEYnvarchar1100
93M_MJBX2VARKEYnvarchar1100
94M_MJBZ2VARKEYnvarchar1100
95M_MREA2VARKEYnvarchar1100
96M_MSAK2VARKEYnvarchar1100
97M_MTLN2VARKEYnvarchar1100
98M_MTVM2VARKEYnvarchar1100
99M_MTVN2VARKEYnvarchar1100
100M_MTVO2VARKEYnvarchar1100
101M_MVER2VARKEYnvarchar1100
102M_MWAK2VARKEYnvarchar1100
103M_OBJE2VARKEYnvarchar1100
104M_PTER2VARKEYnvarchar1100
105M_PTRM2VARKEYnvarchar1100
106M_SFIP2VARKEYnvarchar1100
107M_SPBB2VARKEYnvarchar1100
108M_SWZA2VARKEYnvarchar1100
109M_VMCF2VARKEYnvarchar1100
110M_VMVK2VARKEYnvarchar1100
111M_VTBS2VARKEYnvarchar1100
112M_VTMA2VARKEYnvarchar1100
113M_VTOF2VARKEYnvarchar1100
114M_WASV2VARKEYnvarchar1100
115M_WDEP2VARKEYnvarchar1100
116M_WORD2VARKEYnvarchar1100
117M_WPAN2VARKEYnvarchar1100
118NCOM2VARKEYnvarchar480
119ORDE2VARKEYnvarchar1100
120PLOM2VARKEYnvarchar1100
121PTEST12VARKEYnvarchar1100
122PVER12VARKEYnvarchar1100
123QDPT2VARKEYnvarchar1100
124REBL2VARKEYnvarchar1100
125SAKO2VARKEYnvarchar1100
126SFCPL2VARKEYnvarchar1100
127SFWPL2VARKEYnvarchar1100
128SMPOOL2VARKEYnvarchar1100
129TESPO2VARKEYnvarchar1100
130TESTCLUST11VARKEYnvarchar1100
131UMG_TEST_P2VARKEYnvarchar1100
132UMG_TEST_S2VARKEYnvarchar400
133UTAB2VARKEYnvarchar500
134VBMC2VARKEYnvarchar1100
135VIND2VARKEYnvarchar1100
136VLIM2VARKEYnvarchar1100
137VMCV2VARKEYnvarchar1100
138VPOOL2VARKEYnvarchar1100
139VTEST112VARKEYnvarchar500
140YMUS2VARKEYnvarchar1100
TOPData Collection
141S111Index: Subsequent Settlement8VARKEYVariable key 100 bytesnvarchar1000
142S111ES111 - Structure Information7VARKEYVariable key 100 bytesnvarchar1000
TOPDefault Risk and Limit System
143VTBLSLALimit Type: Summarization of the Characteristic Values3VARKEYLock Key for Tablesnvarchar1200
TOPEasy Enhancement Workbench
144AXT_TAB_NRRANGENumber Ranges for Extensibility Logical Object Type2VARKEYchar120nvarchar1200
TOPLogistics Execution
145/DSD/PE_CNDRDHPricing: Retrieved Condition Records - Control Info.6VARKEYCharacter 100nvarchar1000
TOPTariffs, Duties and Permits
146OIH_J1B_ACSVALBrazil: Oil Access Values4VARKEYVariable keynvarchar600
TOPTax Reporting
147OIUX1_VKEY_XREFTable for variable key in Tax Reporting5VARKEYVariable Key for Tax Reportingnvarchar40