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

132 columns | Print definition?ERP 6.0  | CHANGED_TS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/CABN_EXxChange table for characteristic data5CHANGED_TSChanged time stampdecimal150
2/SMERP/CAWN_EXxChange table - char values (ATINN+ATZHL+ADZHL)5CHANGED_TSChanged time stampdecimal150
3/SMERP/DOC_EXExchange Table - DMS Documents5CHANGED_TSChanged time stampdecimal150
4/SMERP/DOC_FI_EXExchange Table - DMS Document Files5CHANGED_TSChanged time stampdecimal150
5/SMERP/DOC_LI_EXExchange Table - DMS Document Links5CHANGED_TSChanged time stampdecimal150
6/SMERP/EAML_EXExchange Table - Linear Asset Management5CHANGED_TSChanged time stampdecimal150
7/SMERP/KBED_EXExchange Table - Capacity Requirements8CHANGED_TSChanged time stampdecimal150
8/SMERP/KLAH_EXxChange Table - Classification Header (CLINT)5CHANGED_TSChanged time stampdecimal150
9/SMERP/KSSK_EXxChange Table - Object To Class Allocation5CHANGED_TSChanged time stampdecimal150
10/SMERP/SWOR_EXxChange table - Class Keyword (CLINT+SPRAS+KLPOS)5CHANGED_TSChanged time stampdecimal150
11/SMFND/DEMO_B_EXExchange Table - Demo Bookings9CHANGED_TSChanged time stampdecimal150
12/SMFND/DEMO_C_EXExchange Table - Demo Customers5CHANGED_TSChanged time stampdecimal150
13/SMFND/DEMO_F_EXExchange Table - Demo Flights8CHANGED_TSChanged time stampdecimal150
14/SMFND/DSF10Data Staging Framework - Data Store12CHANGED_TSChanged time stampdecimal150
15/SMFND/DSF11Data Staging Framework - Data Store Sgements10CHANGED_TSChanged time stampdecimal150
16/SMFND/DSF20Data Staging Framework - Data Agent12CHANGED_TSChanged time stampdecimal150
17/SMFND/DSF30Data Staging Framework - Scheduling16CHANGED_TSChanged time stampdecimal150
18/SMFND/DSF40Data Staging Framework - Mapping - Tables - DS Population11CHANGED_TSChanged time stampdecimal150
19/SMFND/DSF41Data Staging Framework - Mapping - Fields - DS Population10CHANGED_TSChanged time stampdecimal150
20/SMFND/DSF50Data Staging Framework - Status7CHANGED_TSChanged time stampdecimal150
21/SMFND/GS001Geospatial service definition24CHANGED_TSChanged time stampdecimal150
22/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info24CHANGED_TSChanged time stampdecimal150
23/SMFND/GS001VGeospatial service - Service Provider Attribute Values10CHANGED_TSChanged time stampdecimal150
24/SMFND/GS002Geospatial service - object assignment14CHANGED_TSChanged time stampdecimal150
25/SMFND/OID01_EXxChange table - SAP Object/GIS Object Id Mapping5CHANGED_TSChanged time stampdecimal150
26/SMFND/OID01_GSGeneral purpose SAP Object <-> GIS OBJECTID mapping table12CHANGED_TSChanged time stampdecimal150
27/SYCLO/AP001Syclo Integration Framework Runtime Settings13CHANGED_TSChanged time stampdecimal150
28/SYCLO/AP002Runtime overwrite for mobile app param, globals16CHANGED_TSChanged time stampdecimal150
29/SYCLO/ARBPL_EXSyclo Exchange Table - Work Center5CHANGED_TSChanged time stampdecimal150
30/SYCLO/AUFNR_EXSyclo Exchange Table - Maintenance Work Order5CHANGED_TSChanged time stampdecimal150
31/SYCLO/AUFNR_M1Syclo - Work Order Mobile Data Header10CHANGED_TSChanged time stampdecimal150
32/SYCLO/AUFPL_EXSyclo Exchange Table - Maintenance Work Order7CHANGED_TSChanged time stampdecimal150
33/SYCLO/AUSP_EXSyclo Exchange Table - Maintenance Equipment/FuncLoc CharVal5CHANGED_TSChanged time stampdecimal150
34/SYCLO/CA000Syclo Mobile Application Release Info14CHANGED_TSChanged time stampdecimal150
35/SYCLO/CA000AMobile application - Satellite Systems11CHANGED_TSChanged time stampdecimal150
36/SYCLO/CA000PMobile application - parameters19CHANGED_TSChanged time stampdecimal150
37/SYCLO/CA000SMobile application - mobile status settings15CHANGED_TSChanged time stampdecimal150
38/SYCLO/CA000XCross application system setting - CONVEXIT Exclusion List12CHANGED_TSChanged time stampdecimal150
39/SYCLO/CA001Cross application system settings13CHANGED_TSChanged time stampdecimal150
40/SYCLO/CA002Generic exchange handler table settings24CHANGED_TSChanged time stampdecimal150
41/SYCLO/CA002DxChange Object Data Segment Settings12CHANGED_TSChanged time stampdecimal150
42/SYCLO/CA002FExchange Object Change Pointer Field Catalog11CHANGED_TSChanged time stampdecimal150
43/SYCLO/CA002LExchange Object Associations14CHANGED_TSChanged time stampdecimal150
44/SYCLO/CA003Data filter rule table13CHANGED_TSChanged time stampdecimal150
45/SYCLO/CA003DMDO DOF Table Rule - Meta Data22CHANGED_TSChanged time stampdecimal150
46/SYCLO/CA003MMDO DOF Table Rule - Value11CHANGED_TSChanged time stampdecimal150
47/SYCLO/CHARG_EXSyclo Exchange Table - Material Batch5CHANGED_TSChanged time stampdecimal150
48/SYCLO/DF001Data Filter Object Definition8CHANGED_TSChanged time stampdecimal150
49/SYCLO/DO001Data Object Class Handler Settings30CHANGED_TSChanged time stampdecimal150
50/SYCLO/DO001CMobile data object - Composite Settings15CHANGED_TSChanged time stampdecimal150
51/SYCLO/DO001EMobile data object - exchange object assignment11CHANGED_TSChanged time stampdecimal150
52/SYCLO/DO001FData Object Handler Get Method Field Catalog13CHANGED_TSChanged time stampdecimal150
53/SYCLO/DO001SSyclo MDO data staging settings21CHANGED_TSChanged time stampdecimal150
54/SYCLO/DO001XMobile data object - proxy setting23CHANGED_TSChanged time stampdecimal150
55/SYCLO/DO002BAPI Wrapper Data Object Assignment12CHANGED_TSChanged time stampdecimal150
56/SYCLO/EBELN_EXSyclo Exchange Table - Purchase Order5CHANGED_TSChanged time stampdecimal150
57/SYCLO/EFI01Syclo Exchange enhancement framework assignment10CHANGED_TSChanged time stampdecimal150
58/SYCLO/EQUNR_EXSyclo Exchange Table - Equipment5CHANGED_TSChanged time stampdecimal150
59/SYCLO/FLEET_EXSyclo Exchange Table - Crew Management5CHANGED_TSChanged time stampdecimal150
60/SYCLO/IBASE_EXSyclo Exchange Table - Installed Base5CHANGED_TSChanged time stampdecimal150
61/SYCLO/IBLNR_EXSyclo Exchange Table - Physical Inventory Document5CHANGED_TSChanged time stampdecimal150
62/SYCLO/IVNUM_EXSyclo Exchange Table - Inventory Documents5CHANGED_TSChanged time stampdecimal150
63/SYCLO/KSML_EXSyclo Exchange Table - Class Char (CLINT+POSNR+ADZHL)5CHANGED_TSChanged time stampdecimal150
64/SYCLO/KUNNR_EXSyclo Exchange Table - Customer Master5CHANGED_TSChanged time stampdecimal150
65/SYCLO/LIFNR_EXSyclo Exchange Table - Vendor Master5CHANGED_TSChanged time stampdecimal150
66/SYCLO/LSTAR_EXSyclo Exchange Table - Cost Center/Activity Type5CHANGED_TSChanged time stampdecimal150
67/SYCLO/MATNR1_EXSyclo Exchange Table - Material Master UoM5CHANGED_TSChanged time stampdecimal150
68/SYCLO/MATNR2_EXSyclo Exchange Table - Material Master CRM Extension5CHANGED_TSChanged time stampdecimal150
69/SYCLO/MATNR_EXSyclo Exchange Table - Material Master5CHANGED_TSChanged time stampdecimal150
70/SYCLO/MBL01Mobile device transaction object status14CHANGED_TSChanged time stampdecimal150
71/SYCLO/MBL02Mobile transaction update history14CHANGED_TSChanged time stampdecimal150
72/SYCLO/MBLNR_EXSyclo Exchange Table - Material Document5CHANGED_TSChanged time stampdecimal150
73/SYCLO/MDOCM_EXSyclo Exchange Table - Measurment Document5CHANGED_TSChanged time stampdecimal150
74/SYCLO/MDW00Syclo Middleware User Registry19CHANGED_TSChanged time stampdecimal150
75/SYCLO/MDW00CMobile user communication info12CHANGED_TSChanged time stampdecimal150
76/SYCLO/MDW00DMobile user client deployment status - last update12CHANGED_TSChanged time stampdecimal150
77/SYCLO/MDW00RMobile user cross reference14CHANGED_TSChanged time stampdecimal150
78/SYCLO/MDW01Syclo Middleware Session Registry13CHANGED_TSChanged time stampdecimal150
79/SYCLO/MDW01RMiddleware session cross reference11CHANGED_TSChanged time stampdecimal150
80/SYCLO/MDW02Syclo Middleware Session Data Object Registry13CHANGED_TSChanged time stampdecimal150
81/SYCLO/MDW03Syclo Middleware Session Cross Reference Table9CHANGED_TSChanged time stampdecimal150
82/SYCLO/MDW04Syclo middleware process log14CHANGED_TSChanged time stampdecimal150
83/SYCLO/MDW05Syclo Middleware Server Data16CHANGED_TSChanged time stampdecimal150
84/SYCLO/MELNR_EXSyclo Exchange Table - Entry List5CHANGED_TSChanged time stampdecimal150
85/SYCLO/MSG01Syclo Mobile Data Unit Message Queue (Outbound)39CHANGED_TSChanged time stampdecimal150
86/SYCLO/MSG02Syclo Mobile Data Unit Message Queue (Inbound)14CHANGED_TSChanged time stampdecimal150
87/SYCLO/OBKNR_EXSyclo Exchange Table - PM Object List5CHANGED_TSChanged time stampdecimal150
88/SYCLO/OT001Outbound trigger definition23CHANGED_TSChanged time stampdecimal150
89/SYCLO/POINT_EXSyclo Exchange Table - Measuring Point5CHANGED_TSChanged time stampdecimal150
90/SYCLO/PSH00Push Scenario Definition44CHANGED_TSChanged time stampdecimal150
91/SYCLO/PSH00OTPush scenario outbound trigger assignment10CHANGED_TSChanged time stampdecimal150
92/SYCLO/PSH01Syclo Push Register30CHANGED_TSChanged time stampdecimal150
93/SYCLO/PSH02Syclo Push Register - Instance items19CHANGED_TSChanged time stampdecimal150
94/SYCLO/PSH03Push Instance Subscriber List8CHANGED_TSChanged time stampdecimal150
95/SYCLO/PSH05User Push history21CHANGED_TSChanged time stampdecimal150
96/SYCLO/PSH10Push framework: subscription queue29CHANGED_TSChanged time stampdecimal150
97/SYCLO/QMNUM_EXSyclo Exchange Table - PM/CS/QM notification5CHANGED_TSChanged time stampdecimal150
98/SYCLO/RSNUM_EXSyclo Exchange Table - Material Reservation5CHANGED_TSChanged time stampdecimal150
99/SYCLO/SC001Syclo Security Check Profile16CHANGED_TSChanged time stampdecimal150
100/SYCLO/STG00Syclo cluster data cache storage - header21CHANGED_TSChanged time stampdecimal150
101/SYCLO/STG01Syclo cluster data cache storage - item15CHANGED_TSChanged time stampdecimal150
102/SYCLO/STG02Syclo cluster data cache storage - data7CHANGED_TSChanged time stampdecimal150
103/SYCLO/STG03Syclo cluster data cache storage - supplement parameters9CHANGED_TSChanged time stampdecimal150
104/SYCLO/STG04Syclo cluster data cache storage - data structure meta data15CHANGED_TSChanged time stampdecimal150
105/SYCLO/STOCK1_EXSyclo Exchange Table - Material Stock (WERKS, MATNR)7CHANGED_TSChanged time stampdecimal150
106/SYCLO/STOCK2_EXSyclo Exchange Table - Customer Special Stock10CHANGED_TSChanged time stampdecimal150
107/SYCLO/STOCK_EXSyclo Exchange Table - Material Stock Data7CHANGED_TSChanged time stampdecimal150
108/SYCLO/SUB01Subscription Agent Definition17CHANGED_TSChanged time stampdecimal150
109/SYCLO/SYSLOG001System statistics - Middleware integration32CHANGED_TSChanged time stampdecimal150
110/SYCLO/SYSTATS01System performance statistics - daily summary36CHANGED_TSChanged time stampdecimal150
111/SYCLO/TANUM_EXSyclo Exchange Table - Transfer Order5CHANGED_TSChanged time stampdecimal150
112/SYCLO/TBNUM_EXSyclo Exchange Table - Transfer Requirements5CHANGED_TSChanged time stampdecimal150
113/SYCLO/TPLNR_EXSyclo Exchange Table - Functional Location5CHANGED_TSChanged time stampdecimal150
114/SYCLO/VBELN_EXExchange Table - SD Sales Document Master5CHANGED_TSChanged time stampdecimal150
115/SYCLO/WB000DevTool: Client application definition header11CHANGED_TSChanged time stampdecimal150
116/SYCLO/WB001DevTool: Mobile Screen Definition11CHANGED_TSChanged time stampdecimal150
117/SYCLO/WB001FDevTool: Mobile Screen layout17CHANGED_TSChanged time stampdecimal150
118/SYCLO/WB001VDevTool: Screen field value table14CHANGED_TSChanged time stampdecimal150
119/SYCLO/WB002DevTool: object12CHANGED_TSChanged time stampdecimal150
120/SYCLO/WB002ADevTool: Object attributes14CHANGED_TSChanged time stampdecimal150
121/SYCLO/WB003DevTool: Mobile Screen Set13CHANGED_TSChanged time stampdecimal150
122/SYCLO/WB003ADevTool: Client Screen Set Screen Assignment12CHANGED_TSChanged time stampdecimal150
123/SYCLO/WB004DevTool: Action definition14CHANGED_TSChanged time stampdecimal150
124/SYCLO/WB005DevTool: client data table12CHANGED_TSChanged time stampdecimal150
125/SYCLO/WB005RDevTool: Data table entries12CHANGED_TSChanged time stampdecimal150
126/SYCLO/WB006DevTool: Transaction definition header11CHANGED_TSChanged time stampdecimal150
127/SYCLO/WB006ADevTool: Client transaction attributes14CHANGED_TSChanged time stampdecimal150
128/SYCLO/WB007DevTool: Label table12CHANGED_TSChanged time stampdecimal150
129/SYCLO/WFLOW_EXSyclo Exchange Table - Workflow5CHANGED_TSChanged time stampdecimal150
TOPABAP Unit
130SAUNIT_FAV_BASEMaster Data: Header of Favorites17CHANGED_TSUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSAP Business Workflow
131SWLWPHANDTURLs for Workflow Launch and Callback Handler (Ext. Service)11CHANGED_TSUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWeb Screen Tools - ABAP
132WDY_UI_LIBRARYWeb Dynpro: UI Element Library Definition9CHANGED_TSUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150