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

116 columns | Print definition?ERP 6.0  | MOBILE_APP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/CABN_EXxChange table for characteristic data2MOBILE_APPMobile Application Namenvarchar300
2/SMERP/CAWN_EXxChange table - char values (ATINN+ATZHL+ADZHL)2MOBILE_APPMobile Application Namenvarchar300
3/SMERP/DOC_EXExchange Table - DMS Documents2MOBILE_APPMobile Application Namenvarchar300
4/SMERP/DOC_FI_EXExchange Table - DMS Document Files2MOBILE_APPMobile Application Namenvarchar300
5/SMERP/DOC_LI_EXExchange Table - DMS Document Links2MOBILE_APPMobile Application Namenvarchar300
6/SMERP/EAML_EXExchange Table - Linear Asset Management2MOBILE_APPMobile Application Namenvarchar300
7/SMERP/KBED_EXExchange Table - Capacity Requirements2MOBILE_APPMobile Application Namenvarchar300
8/SMERP/KLAH_EXxChange Table - Classification Header (CLINT)2MOBILE_APPMobile Application Namenvarchar300
9/SMERP/KSSK_EXxChange Table - Object To Class Allocation2MOBILE_APPMobile Application Namenvarchar300
10/SMERP/SWOR_EXxChange table - Class Keyword (CLINT+SPRAS+KLPOS)2MOBILE_APPMobile Application Namenvarchar300
11/SMFND/DEMO_B_EXExchange Table - Demo Bookings2MOBILE_APPMobile Application Namenvarchar300
12/SMFND/DEMO_C_EXExchange Table - Demo Customers2MOBILE_APPMobile Application Namenvarchar300
13/SMFND/DEMO_F_EXExchange Table - Demo Flights2MOBILE_APPMobile Application Namenvarchar300
14/SMFND/DSF10Data Staging Framework - Data Store6MOBILE_APPMobile Application Namenvarchar300
15/SMFND/DSF11Data Staging Framework - Data Store Sgements6MOBILE_APPMobile Application Namenvarchar300
16/SMFND/DSF20Data Staging Framework - Data Agent8MOBILE_APPMobile Application Namenvarchar300
17/SMFND/DSF30Data Staging Framework - Scheduling12MOBILE_APPMobile Application Namenvarchar300
18/SMFND/DSF40Data Staging Framework - Mapping - Tables - DS Population7MOBILE_APPMobile Application Namenvarchar300
19/SMFND/DSF41Data Staging Framework - Mapping - Fields - DS Population6MOBILE_APPMobile Application Namenvarchar300
20/SMFND/DSF50Data Staging Framework - Status5MOBILE_APPMobile Application Namenvarchar300
21/SMFND/GS001Geospatial service definition3MOBILE_APPMobile Application Namenvarchar300
22/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info20MOBILE_APPMobile Application Namenvarchar300
23/SMFND/GS001VGeospatial service - Service Provider Attribute Values6MOBILE_APPMobile Application Namenvarchar300
24/SMFND/GS002Geospatial service - object assignment9MOBILE_APPMobile Application Namenvarchar300
25/SMFND/OID01_EXxChange table - SAP Object/GIS Object Id Mapping2MOBILE_APPMobile Application Namenvarchar300
26/SMFND/OID01_GSGeneral purpose SAP Object <-> GIS OBJECTID mapping table3MOBILE_APPMobile Application Namenvarchar300
27/SYCLO/AP001Syclo Integration Framework Runtime Settings2MOBILE_APPMobile Application Namenvarchar300
28/SYCLO/AP002Runtime overwrite for mobile app param, globals3MOBILE_APPMobile Application Namenvarchar300
29/SYCLO/ARBPL_EXSyclo Exchange Table - Work Center2MOBILE_APPMobile Application Namenvarchar300
30/SYCLO/AUFNR_EXSyclo Exchange Table - Maintenance Work Order2MOBILE_APPMobile Application Namenvarchar300
31/SYCLO/AUFPL_EXSyclo Exchange Table - Maintenance Work Order2MOBILE_APPMobile Application Namenvarchar300
32/SYCLO/AUSP_EXSyclo Exchange Table - Maintenance Equipment/FuncLoc CharVal2MOBILE_APPMobile Application Namenvarchar300
33/SYCLO/CA000Syclo Mobile Application Release Info2MOBILE_APPMobile Application Namenvarchar300
34/SYCLO/CA000AMobile application - Satellite Systems2MOBILE_APPMobile Application Namenvarchar300
35/SYCLO/CA000PMobile application - parameters2MOBILE_APPMobile Application Namenvarchar300
36/SYCLO/CA000SMobile application - mobile status settings2MOBILE_APPMobile Application Namenvarchar300
37/SYCLO/CA000STMobile application - mobile status alias2MOBILE_APPMobile Application Namenvarchar300
38/SYCLO/CA000XCross application system setting - CONVEXIT Exclusion List2MOBILE_APPMobile Application Namenvarchar300
39/SYCLO/CA002Generic exchange handler table settings4MOBILE_APPMobile Application Namenvarchar300
40/SYCLO/CA002DxChange Object Data Segment Settings8MOBILE_APPMobile Application Namenvarchar300
41/SYCLO/CA002FExchange Object Change Pointer Field Catalog7MOBILE_APPMobile Application Namenvarchar300
42/SYCLO/CA002LExchange Object Associations7MOBILE_APPMobile Application Namenvarchar300
43/SYCLO/CA003Data filter rule table8MOBILE_APPMobile Application Namenvarchar300
44/SYCLO/CA003DMDO DOF Table Rule - Meta Data17MOBILE_APPMobile Application Namenvarchar300
45/SYCLO/CA003MMDO DOF Table Rule - Value6MOBILE_APPMobile Application Namenvarchar300
46/SYCLO/CHARG_EXSyclo Exchange Table - Material Batch2MOBILE_APPMobile Application Namenvarchar300
47/SYCLO/DO001Data Object Class Handler Settings4MOBILE_APPMobile Application Namenvarchar300
48/SYCLO/DO001CMobile data object - Composite Settings11MOBILE_APPMobile Application Namenvarchar300
49/SYCLO/DO001EMobile data object - exchange object assignment7MOBILE_APPMobile Application Namenvarchar300
50/SYCLO/DO001FData Object Handler Get Method Field Catalog9MOBILE_APPMobile Application Namenvarchar300
51/SYCLO/DO001SSyclo MDO data staging settings3MOBILE_APPMobile Application Namenvarchar300
52/SYCLO/DO001XMobile data object - proxy setting3MOBILE_APPMobile Application Namenvarchar300
53/SYCLO/DO002BAPI Wrapper Data Object Assignment3MOBILE_APPMobile Application Namenvarchar300
54/SYCLO/EBELN_EXSyclo Exchange Table - Purchase Order2MOBILE_APPMobile Application Namenvarchar300
55/SYCLO/EFI01Syclo Exchange enhancement framework assignment3MOBILE_APPMobile Application Namenvarchar300
56/SYCLO/EQUNR_EXSyclo Exchange Table - Equipment2MOBILE_APPMobile Application Namenvarchar300
57/SYCLO/FLEET_EXSyclo Exchange Table - Crew Management2MOBILE_APPMobile Application Namenvarchar300
58/SYCLO/IBASE_EXSyclo Exchange Table - Installed Base2MOBILE_APPMobile Application Namenvarchar300
59/SYCLO/IBLNR_EXSyclo Exchange Table - Physical Inventory Document2MOBILE_APPMobile Application Namenvarchar300
60/SYCLO/IVNUM_EXSyclo Exchange Table - Inventory Documents2MOBILE_APPMobile Application Namenvarchar300
61/SYCLO/KSML_EXSyclo Exchange Table - Class Char (CLINT+POSNR+ADZHL)2MOBILE_APPMobile Application Namenvarchar300
62/SYCLO/KUNNR_EXSyclo Exchange Table - Customer Master2MOBILE_APPMobile Application Namenvarchar300
63/SYCLO/LIFNR_EXSyclo Exchange Table - Vendor Master2MOBILE_APPMobile Application Namenvarchar300
64/SYCLO/LSTAR_EXSyclo Exchange Table - Cost Center/Activity Type2MOBILE_APPMobile Application Namenvarchar300
65/SYCLO/MATNR1_EXSyclo Exchange Table - Material Master UoM2MOBILE_APPMobile Application Namenvarchar300
66/SYCLO/MATNR2_EXSyclo Exchange Table - Material Master CRM Extension2MOBILE_APPMobile Application Namenvarchar300
67/SYCLO/MATNR_EXSyclo Exchange Table - Material Master2MOBILE_APPMobile Application Namenvarchar300
68/SYCLO/MBL01Mobile device transaction object status2MOBILE_APPMobile Application Namenvarchar300
69/SYCLO/MBL02Mobile transaction update history4MOBILE_APPMobile Application Namenvarchar300
70/SYCLO/MBLNR_EXSyclo Exchange Table - Material Document2MOBILE_APPMobile Application Namenvarchar300
71/SYCLO/MDOCM_EXSyclo Exchange Table - Measurment Document2MOBILE_APPMobile Application Namenvarchar300
72/SYCLO/MDW00Syclo Middleware User Registry6MOBILE_APPMobile Application Namenvarchar300
73/SYCLO/MDW00RMobile user cross reference4MOBILE_APPMobile Application Namenvarchar300
74/SYCLO/MDW01RMiddleware session cross reference6MOBILE_APPMobile Application Namenvarchar300
75/SYCLO/MDW04Syclo middleware process log5MOBILE_APPMobile Application Namenvarchar300
76/SYCLO/MDW04SSyclo middleware process statistics2MOBILE_APPMobile Application Namenvarchar300
77/SYCLO/MDW05Syclo Middleware Server Data7MOBILE_APPMobile Application Namenvarchar300
78/SYCLO/MELNR_EXSyclo Exchange Table - Entry List2MOBILE_APPMobile Application Namenvarchar300
79/SYCLO/MSG01Syclo Mobile Data Unit Message Queue (Outbound)4MOBILE_APPMobile Application Namenvarchar300
80/SYCLO/MSG02Syclo Mobile Data Unit Message Queue (Inbound)4MOBILE_APPMobile Application Namenvarchar300
81/SYCLO/OBKNR_EXSyclo Exchange Table - PM Object List2MOBILE_APPMobile Application Namenvarchar300
82/SYCLO/OT001Outbound trigger definition4MOBILE_APPMobile Application Namenvarchar300
83/SYCLO/POINT_EXSyclo Exchange Table - Measuring Point2MOBILE_APPMobile Application Namenvarchar300
84/SYCLO/PSH00Push Scenario Definition3MOBILE_APPMobile Application Namenvarchar300
85/SYCLO/PSH00OTPush scenario outbound trigger assignment6MOBILE_APPMobile Application Namenvarchar300
86/SYCLO/PSH01Syclo Push Register3MOBILE_APPMobile Application Namenvarchar300
87/SYCLO/PSH02Syclo Push Register - Instance items8MOBILE_APPMobile Application Namenvarchar300
88/SYCLO/PSH05User Push history3MOBILE_APPMobile Application Namenvarchar300
89/SYCLO/PSH10Push framework: subscription queue4MOBILE_APPMobile Application Namenvarchar300
90/SYCLO/QMNUM_EXSyclo Exchange Table - PM/CS/QM notification2MOBILE_APPMobile Application Namenvarchar300
91/SYCLO/RSNUM_EXSyclo Exchange Table - Material Reservation2MOBILE_APPMobile Application Namenvarchar300
92/SYCLO/STG00Syclo cluster data cache storage - header3MOBILE_APPMobile Application Namenvarchar300
93/SYCLO/STOCK1_EXSyclo Exchange Table - Material Stock (WERKS, MATNR)2MOBILE_APPMobile Application Namenvarchar300
94/SYCLO/STOCK2_EXSyclo Exchange Table - Customer Special Stock2MOBILE_APPMobile Application Namenvarchar300
95/SYCLO/STOCK_EXSyclo Exchange Table - Material Stock Data2MOBILE_APPMobile Application Namenvarchar300
96/SYCLO/SUB01Subscription Agent Definition3MOBILE_APPMobile Application Namenvarchar300
97/SYCLO/SYSLOG001System statistics - Middleware integration7MOBILE_APPMobile Application Namenvarchar300
98/SYCLO/TANUM_EXSyclo Exchange Table - Transfer Order2MOBILE_APPMobile Application Namenvarchar300
99/SYCLO/TBNUM_EXSyclo Exchange Table - Transfer Requirements2MOBILE_APPMobile Application Namenvarchar300
100/SYCLO/TPLNR_EXSyclo Exchange Table - Functional Location2MOBILE_APPMobile Application Namenvarchar300
101/SYCLO/VBELN_EXExchange Table - SD Sales Document Master2MOBILE_APPMobile Application Namenvarchar300
102/SYCLO/WB000DevTool: Client application definition header6MOBILE_APPMobile Application Namenvarchar300
103/SYCLO/WB001DevTool: Mobile Screen Definition4MOBILE_APPMobile Application Namenvarchar300
104/SYCLO/WB001FDevTool: Mobile Screen layout10MOBILE_APPMobile Application Namenvarchar300
105/SYCLO/WB001VDevTool: Screen field value table8MOBILE_APPMobile Application Namenvarchar300
106/SYCLO/WB002DevTool: object5MOBILE_APPMobile Application Namenvarchar300
107/SYCLO/WB002ADevTool: Object attributes8MOBILE_APPMobile Application Namenvarchar300
108/SYCLO/WB003DevTool: Mobile Screen Set6MOBILE_APPMobile Application Namenvarchar300
109/SYCLO/WB003ADevTool: Client Screen Set Screen Assignment5MOBILE_APPMobile Application Namenvarchar300
110/SYCLO/WB004DevTool: Action definition8MOBILE_APPMobile Application Namenvarchar300
111/SYCLO/WB005DevTool: client data table7MOBILE_APPMobile Application Namenvarchar300
112/SYCLO/WB005RDevTool: Data table entries7MOBILE_APPMobile Application Namenvarchar300
113/SYCLO/WB006DevTool: Transaction definition header5MOBILE_APPMobile Application Namenvarchar300
114/SYCLO/WB006ADevTool: Client transaction attributes8MOBILE_APPMobile Application Namenvarchar300
115/SYCLO/WB007DevTool: Label table6MOBILE_APPMobile Application Namenvarchar300
116/SYCLO/WFLOW_EXSyclo Exchange Table - Workflow2MOBILE_APPMobile Application Namenvarchar300