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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

47 columns | Print definition?ERP 6.0  | GUID_LCLIC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/CCMHDCustoms Warehouse Collective Completion - Header6GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
2/SAPSLL/CUPEDSupplementary Customs Declaration Header10GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
3/SAPSLL/CWLCCPWorklist of Export Items to Determine IP Closing Portions7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
4/SAPSLL/CWLOCPWorklist: Import Items to Determine OP Closing Portions6GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
5/SAPSLL/CWLPCPWorklist: Installation Statement FC w/PEU9GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
6/SAPSLL/ITARAUDITAR Tracking: Log - Header Data5GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
7/SAPSLL/IVMCST01Indiv. Stock Item: Special Customs Procedures: Inward Proc.6GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
8/SAPSLL/IVMCST02Totals Stock: Special Customs Procedure: Inward Processing6GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
9/SAPSLL/IVMFST01Individual Stock Item Free Circulation for Prescribed EndUse5GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
10/SAPSLL/LCLICLegal Control: License Header2GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
11/SAPSLL/LCLICAQLegal Control: License: Available Quantity3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
12/SAPSLL/LCLICAQLLicense: Change Log: Available Quantity7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
13/SAPSLL/LCLICAVLegal Control: License: Available Quantity3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
14/SAPSLL/LCLICAVLLicense: Change Log of Available Quantity7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
15/SAPSLL/LCLICBGTS: License - Banks3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
16/SAPSLL/LCLICCLegal Control - Licenses - Control Classes3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
17/SAPSLL/LCLICCOLegal Control: License - Application Data3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
18/SAPSLL/LCLICCQULicense - Quantities Taken per Component3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
19/SAPSLL/LCLICCVULicense - Values Taken per Component3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
20/SAPSLL/LCLICESLL: Legal Control: License - Restitution3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
21/SAPSLL/LCLICFSLL: Legal Control: License - Prefixation3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
22/SAPSLL/LCLICGLegal Control - Licenses - Business Transaction Type3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
23/SAPSLL/LCLICHSLL: Legal Control: - License - Peculiarity Code3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
24/SAPSLL/LCLICILegal Control - Licenses - Import Code Number3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
25/SAPSLL/LCLICJLicense - Projects3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
26/SAPSLL/LCLICKGTS: License - Terms of Payment3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
27/SAPSLL/LCLICLLegal Control: Licenses - Countries3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
28/SAPSLL/LCLICMLegal Control - Licenses - Materials3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
29/SAPSLL/LCLICNSLL: Legal Control: License - CAP Numbers3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
30/SAPSLL/LCLICOLegal Control: Licenses - Org. Units3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
31/SAPSLL/LCLICPSLL: Legal Control: License - Procedures3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
32/SAPSLL/LCLICQLegal Control: Licenses - Quantities7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
33/SAPSLL/LCLICQUSLegal Control: Licenses - Quantities Allocated7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
34/SAPSLL/LCLICRSLL: Legal Control: License - Country Groups3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
35/SAPSLL/LCLICSLegal Control: Licenses - Statuses3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
36/SAPSLL/LCLICULegal Control: Licenses - Legal Units3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
37/SAPSLL/LCLICVSLL: Legal Control: License - Values7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
38/SAPSLL/LCLICVUSLegal Control: Licenses - Values Allocated7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
39/SAPSLL/LCLICWLegal Control - Licenses - Commodity Code3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
40/SAPSLL/LCLICYGTS: License - Documents3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
41/SAPSLL/LCLICZGTS: License - Access Codes3GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
42/SAPSLL/LEGCONLegal Control - Document6GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
43/SAPSLL/LEGPEUClosing of Free Circulation with Prescribed End Use12GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
44/SAPSLL/LEGSCPClosings of Special Customs Procedures (IP / PUCC)8GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
45/SAPSLL/SCPBODSettlement Run for Special Customs Procedures7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
46/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities4GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160
47/SAPSLL/VDFCPEUInstallation Statement for Free Circ. w/Prescribed End Use7GUID_LCLICPrimary Key as GUID in 'RAW' Formatvarbinary160