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

71 columns | Print definition?ERP 6.0  | GUID_MOBJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/ADRCONLegal Control: Data on Address Defined for Business Partner30GUID_MOBJPrimary Key of Main Objectvarbinary160
2/SAPSLL/ADRCONSPGTS: Legal Control: SPL Check Results for Address17GUID_MOBJPrimary Key of Main Objectvarbinary160
3/SAPSLL/ADRLRIDGTS: Identification Numbers for Address in Business Partner13GUID_MOBJPrimary Key of Main Objectvarbinary160
4/SAPSLL/BOPITGTS: General Bill of Product - Item Data11GUID_MOBJPrimary Key of Main Objectvarbinary160
5/SAPSLL/CHGLGChange Log4GUID_MOBJPrimary Key of Main Objectvarbinary160
6/SAPSLL/CMPEOSPL Screening: Exclusion of Objects (e.g. SPL Entity)4GUID_MOBJPrimary Key of Main Objectvarbinary160
7/SAPSLL/CORACTLegal & Logistics Services: Activities7GUID_MOBJPrimary Key of Main Objectvarbinary160
8/SAPSLL/CORCTSDocument - Customs Tariff Numbers: Non-Country-Specific14GUID_MOBJPrimary Key of Main Objectvarbinary160
9/SAPSLL/CORCTSCL&L Services: Document - Customs Tariff Nos. (Country-Spec.)15GUID_MOBJPrimary Key of Main Objectvarbinary160
10/SAPSLL/CORCTZCustoms Document Reference Codes15GUID_MOBJPrimary Key of Main Objectvarbinary160
11/SAPSLL/CORCUITCL&L Srv.: Document - Item- and Country-Specific Customs Data12GUID_MOBJPrimary Key of Main Objectvarbinary160
12/SAPSLL/CORCUSDCL&L Srv.: Document - Doc.- and Country-Specific Customs Data12GUID_MOBJPrimary Key of Main Objectvarbinary160
13/SAPSLL/CORDATDeadlines8GUID_MOBJPrimary Key of Main Objectvarbinary160
14/SAPSLL/CORDIMLegal & Logistics Services: Dimensions9GUID_MOBJPrimary Key of Main Objectvarbinary160
15/SAPSLL/CORGDCLegal & Logistics Services: Goods Description7GUID_MOBJPrimary Key of Main Objectvarbinary160
16/SAPSLL/CORPARDocument Partner20GUID_MOBJPrimary Key of Main Objectvarbinary160
17/SAPSLL/CORREFReference Data9GUID_MOBJPrimary Key of Main Objectvarbinary160
18/SAPSLL/CORSTALegal & Logistics Services: Document Statuses8GUID_MOBJPrimary Key of Main Objectvarbinary160
19/SAPSLL/CORSTHChronological Status of a Document14GUID_MOBJPrimary Key of Main Objectvarbinary160
20/SAPSLL/CORVALSLL: Values9GUID_MOBJPrimary Key of Main Objectvarbinary160
21/SAPSLL/CTSGENLegal&Logistics Services: Generic Part of Customs Tariff No.8GUID_MOBJPrimary Key of Main Objectvarbinary160
22/SAPSLL/CTSGENTL & L Services: Text for Generic Customs Tariff No.7GUID_MOBJPrimary Key as GUID in 'RAW' Formatvarbinary160
23/SAPSLL/CTSNUMCustoms Tariff Number8GUID_MOBJPrimary Key of Main Objectvarbinary160
24/SAPSLL/CTSNUMCL & L Services - Country-Specific Customs Tariff No.9GUID_MOBJPrimary Key of Main Objectvarbinary160
25/SAPSLL/CTSNUMCTL&L Services - Text for Country-Specific Customs Tariff No.7GUID_MOBJPrimary Key as GUID in 'RAW' Formatvarbinary160
26/SAPSLL/CTSNUMTLegal & Logistics Services - Text for Customs Tariff No.7GUID_MOBJPrimary Key as GUID in 'RAW' Formatvarbinary160
27/SAPSLL/CUHDDATGTS: Customs Document: Header Dates47GUID_MOBJPrimary Key of Main Objectvarbinary160
28/SAPSLL/CUHDSTAGTS: Customs Doc.: Header Status34GUID_MOBJPrimary Key of Main Objectvarbinary160
29/SAPSLL/CUITDATGTS: Customs Document: Item Dates22GUID_MOBJPrimary Key of Main Objectvarbinary160
30/SAPSLL/CUITSTAGTS: Customs Document: Item Status21GUID_MOBJPrimary Key of Main Objectvarbinary160
31/SAPSLL/CUITSUBLegal Services: Customs Document - Subitem8GUID_MOBJPrimary Key of Main Objectvarbinary160
32/SAPSLL/CUIVSLL: Customs Document: Bill10GUID_MOBJPrimary Key of Main Objectvarbinary160
33/SAPSLL/CUPEDRHGTS: Period Entry Reference to Customs Document4GUID_MOBJPrimary Key of Main Objectvarbinary160
34/SAPSLL/CUPEDRIGTS: Period Entry Reference to Customs Document Item13GUID_MOBJPrimary Key of Main Objectvarbinary160
35/SAPSLL/EMCHEAAdministrative Document (Excise Duty) - Header29GUID_MOBJPrimary Key of Main Objectvarbinary160
36/SAPSLL/EMCITMAdministrative Document (Excise Duty) - Item51GUID_MOBJPrimary Key of Main Objectvarbinary160
37/SAPSLL/ITARAUDDITAR Tracking: Log - Item Data16GUID_MOBJPrimary Key of Main Objectvarbinary160
38/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results21GUID_MOBJPrimary Key of Main Objectvarbinary160
39/SAPSLL/LCLICCQLegal Control: License - Quantities per Component11GUID_MOBJPrimary Key of Main Objectvarbinary160
40/SAPSLL/LCLICCVLegal Control: License - Values per Component11GUID_MOBJPrimary Key of Main Objectvarbinary160
41/SAPSLL/LEGACTSLL: Customs Document: Activities18GUID_MOBJPrimary Key of Main Objectvarbinary160
42/SAPSLL/LEGAGRGTS: References to Aggregated Document Items9GUID_MOBJPrimary Key of Main Objectvarbinary160
43/SAPSLL/LEGCOLContainer Management in Safekeeping12GUID_MOBJPrimary Key of Main Objectvarbinary160
44/SAPSLL/LEGCOMSLL: Customs Document: Communiation Numbers9GUID_MOBJPrimary Key of Main Objectvarbinary160
45/SAPSLL/LEGCONLegal Control - Document35GUID_MOBJPrimary Key of Main Objectvarbinary160
46/SAPSLL/LEGCTRCustoms Document: Involved Countries9GUID_MOBJPrimary Key of Main Objectvarbinary160
47/SAPSLL/LEGCULCSLL: Customs Document: Customs Processing: Duties41GUID_MOBJPrimary Key of Main Objectvarbinary160
48/SAPSLL/LEGCUSCustoms Document: Customs Processing75GUID_MOBJPrimary Key of Main Objectvarbinary160
49/SAPSLL/LEGDOCSLL: Customs Document: Documents27GUID_MOBJPrimary Key of Main Objectvarbinary160
50/SAPSLL/LEGEVESLL: Customs Document: Events20GUID_MOBJPrimary Key of Main Objectvarbinary160
51/SAPSLL/LEGFINGTS Customs Document: Closing Portions Item12GUID_MOBJPrimary Key of Main Objectvarbinary160
52/SAPSLL/LEGLRGILegal Services: List of Services Still to Be Executed8GUID_MOBJPrimary Key of Main Objectvarbinary160
53/SAPSLL/LEGMESSLL: Customs Document: Messages for Each Activity14GUID_MOBJPrimary Key of Main Objectvarbinary160
54/SAPSLL/LEGOPRGTS Customs Document: Closing of Outward Processing15GUID_MOBJPrimary Key of Main Objectvarbinary160
55/SAPSLL/LEGPGESLL: Customs Doc.: Packing Data18GUID_MOBJPrimary Key of Main Objectvarbinary160
56/SAPSLL/LEGPLOSLL: Customs Document: Seals11GUID_MOBJPrimary Key of Main Objectvarbinary160
57/SAPSLL/LEGREFSLL: Customs Document: External Reference Objects11GUID_MOBJPrimary Key of Main Objectvarbinary160
58/SAPSLL/LEGSUSSSL Customs Document: Deferment10GUID_MOBJPrimary Key of Main Objectvarbinary160
59/SAPSLL/LEGTPRSLL: Customs Document: Shipment Procedure64GUID_MOBJPrimary Key of Main Objectvarbinary160
60/SAPSLL/PGEREFSLL: Package Data Link Handler9GUID_MOBJPrimary Key of Main Objectvarbinary160
61/SAPSLL/RECDTRReconciliation Summary: Duties and Totals22GUID_MOBJPrimary Key of Main Objectvarbinary160
62/SAPSLL/RECSIDReconciliation Summary: Item Details17GUID_MOBJPrimary Key of Main Objectvarbinary160
63/SAPSLL/SPLAUDLegal Control - SPL - Audit25GUID_MOBJPrimary Key of Main Objectvarbinary160
64/SAPSLL/SPLAUDKLegal Control - SPL - Audit: Comments8GUID_MOBJPrimary Key of Main Objectvarbinary160
65/SAPSLL/SPLAUDRAudit Trail for SPL Screening - Additional Object References12GUID_MOBJPrimary Key of Main Objectvarbinary160
66/SAPSLL/TSCHDTax Statement: Hierarchy Customs Declaration Header9GUID_MOBJPrimary Key of Main Objectvarbinary160
67/SAPSLL/TSCITTax Statement: Hierarchy Customs Declaration Item8GUID_MOBJPrimary Key of Main Objectvarbinary160
68/SAPSLL/TSPEDTax Statement: Hierarchy of Collective Document10GUID_MOBJPrimary Key of Main Objectvarbinary160
69/SAPSLL/TSPHDTax Statement: Customs Duties Totals9GUID_MOBJPrimary Key of Main Objectvarbinary160
70/SAPSLL/TSPITTax Statement: Customs Duties Details9GUID_MOBJPrimary Key of Main Objectvarbinary160
71/SAPSLL/TSTHDTax Statement: Hierarchy Tax Statement Header8GUID_MOBJPrimary Key of Main Objectvarbinary160