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

Home | ERP 6.0 
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

40 columns | Print definition?ERP 6.0  | GUID_STOCK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAP-LIM Logistics Inventory Management Engine
1/LIME/COLL_APSCollection for Planning System39GUID_STOCKGUID Stock Itemvarbinary160
2/LIME/COLL_BWCollection for Business Warehouse39GUID_STOCKGUID Stock Itemvarbinary160
3/LIME/COLL_FINCollection for Financial System39GUID_STOCKGUID Stock Itemvarbinary160
4/LIME/COLL_INVCollection for Inventory System39GUID_STOCKGUID Stock Itemvarbinary160
5/LIME/COLL_LEGCollection for External System39GUID_STOCKGUID Stock Itemvarbinary160
6/LIME/COLL_MMIMCollection for R/3 Inventory Management39GUID_STOCKGUID Stock Itemvarbinary160
7/LIME/COLL_W2IMCollection for WME after ERP-MMIM39GUID_STOCKGUID Stock Itemvarbinary160
8/LIME/LOG_QUANLog Table for the Stock Changes Made to a Document7GUID_STOCKGUID Stock Itemvarbinary160
9/LIME/LOG_SERIALLog Table of Serial Numbers9GUID_STOCKGUID Stock Itemvarbinary160
10/LIME/LSQLIME - Stock Attributes2GUID_STOCKGUID Stock Itemvarbinary160
11/LIME/NLOG_QUANLogging of Changes in Table /LIME/NQUAN6GUID_STOCKGUID Stock Itemvarbinary160
12/LIME/NLOG_SERLIME - Serial Numbers6GUID_STOCKGUID Stock Itemvarbinary160
13/LIME/NQUANLIME - Stock Quantities2GUID_STOCKGUID Stock Itemvarbinary160
14/LIME/NSERIALLIME - Serial Numbers2GUID_STOCKGUID Stock Itemvarbinary160
15/LIME/PN_ITEMTable to Save Prima Nota Item Data24GUID_STOCKGUID Stock Itemvarbinary160
16/LIME/QUANLIME - Stock Quantities2GUID_STOCKGUID Stock Itemvarbinary160
17/LIME/SERIALLIME - Serial Numbers2GUID_STOCKGUID Stock Itemvarbinary160
18/LIME/STOCK_I001LIME - Stock Key Material (R/3)7GUID_STOCKGlobally Unique Identifiervarbinary160
19/LIME/STOCK_I002LIME - Stock Key Material, Batch (R/3)8GUID_STOCKGlobally Unique Identifiervarbinary160
20/LIME/STOCK_I003LIME - Stock Key GTIN, Variant8GUID_STOCKGlobally Unique Identifiervarbinary160
21/LIME/STOCK_I005LIME - Stock Key APO Material (F&R)7GUID_STOCKGlobally Unique Identifiervarbinary160
22/LIME/STOCK_I006LIME - Stock Key Product GUID, Version (ICH)8GUID_STOCKGlobally Unique Identifiervarbinary160
23/LIME/STOCK_I011LIME - Stock Key Sales Order Stock (R/3)9GUID_STOCKGlobally Unique Identifiervarbinary160
24/LIME/STOCK_I012LIME - Stock Key Sales Order Stock, Batch (R/3)10GUID_STOCKGlobally Unique Identifiervarbinary160
25/LIME/STOCK_I021LIME - Stock Key Project Stock (R/3)8GUID_STOCKGlobally Unique Identifiervarbinary160
26/LIME/STOCK_I022LIME - Stock Key Project Stock, Batch (R/3)9GUID_STOCKGlobally Unique Identifiervarbinary160
27/LIME/STOCK_S001Shadow Table for LIME - Material (R/3)7GUID_STOCKGlobally Unique Identifiervarbinary160
28/LIME/STOCK_S002Shadow Table for LIME - Material, Batch (R/3)8GUID_STOCKGlobally Unique Identifiervarbinary160
29/LIME/STOCK_S003Shadow Table for LIME - GTIN, Variant8GUID_STOCKGlobally Unique Identifiervarbinary160
30/LIME/STOCK_S005Shadow Table for LIME - APO Material (F&R)7GUID_STOCKGlobally Unique Identifiervarbinary160
31/LIME/STOCK_S006Shadow Table for LIME - Product GUID, Version (ICH)8GUID_STOCKGlobally Unique Identifiervarbinary160
32/LIME/STOCK_S011Shadow Table for LIME - Sales Order Stock (R/3)9GUID_STOCKGlobally Unique Identifiervarbinary160
33/LIME/STOCK_S012Shadow Table for LIME - Sales Order Stock, Batch (R/3)10GUID_STOCKGlobally Unique Identifiervarbinary160
34/LIME/STOCK_S021Shadow Table for LIME - Project Stock (R/3)8GUID_STOCKGlobally Unique Identifiervarbinary160
35/LIME/STOCK_S022Shadow Table for LIME - Project Stock, Batch (R/3)9GUID_STOCKGlobally Unique Identifiervarbinary160
36/LIME/USID_I001LIME - USID Key Serial Number (R/3)3GUID_STOCKGUID Stock Itemvarbinary160
TOPGlobal Trade Services
37/SAPSLL/S_IG01GTS - Make-to-Order Stock (Duty Unpaid)13GUID_STOCKGlobally Unique Identifiervarbinary160
38/SAPSLL/S_IG02GTS - Stock11GUID_STOCKGlobally Unique Identifiervarbinary160
39/SAPSLL/S_SG01GTS - Make-to-Order Stock (Duty Unpaid)13GUID_STOCKGlobally Unique Identifiervarbinary160
40/SAPSLL/S_SG02GTS - Shadow Stock11GUID_STOCKGlobally Unique Identifiervarbinary160

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy