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

68 columns | Print definition?ERP 6.0  | GUID_POBJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/ADRCONLegal Control: Data on Address Defined for Business Partner32GUID_POBJPrimary Key of Preceding Objectvarbinary160
2/SAPSLL/ADRLRIDGTS: Identification Numbers for Address in Business Partner15GUID_POBJPrimary Key of Preceding Objectvarbinary160
3/SAPSLL/BOPITGTS: General Bill of Product - Item Data9GUID_POBJPrimary Key of Preceding Objectvarbinary160
4/SAPSLL/CASECase4GUID_POBJPrimary Key of Preceding Objectvarbinary160
5/SAPSLL/CORACTLegal & Logistics Services: Activities4GUID_POBJPrimary Key of Preceding Objectvarbinary160
6/SAPSLL/CORCTSDocument - Customs Tariff Numbers: Non-Country-Specific4GUID_POBJPrimary Key of Preceding Objectvarbinary160
7/SAPSLL/CORCTSCL&L Services: Document - Customs Tariff Nos. (Country-Spec.)4GUID_POBJPrimary Key of Preceding Objectvarbinary160
8/SAPSLL/CORCTZCustoms Document Reference Codes4GUID_POBJPrimary Key of Preceding Objectvarbinary160
9/SAPSLL/CORCUITCL&L Srv.: Document - Item- and Country-Specific Customs Data8GUID_POBJPrimary Key of Preceding Objectvarbinary160
10/SAPSLL/CORCUSDCL&L Srv.: Document - Doc.- and Country-Specific Customs Data8GUID_POBJPrimary Key of Preceding Objectvarbinary160
11/SAPSLL/CORDATDeadlines4GUID_POBJPrimary Key of Preceding Objectvarbinary160
12/SAPSLL/CORDIMLegal & Logistics Services: Dimensions4GUID_POBJPrimary Key of Preceding Objectvarbinary160
13/SAPSLL/CORGDCLegal & Logistics Services: Goods Description4GUID_POBJPrimary Key of Preceding Objectvarbinary160
14/SAPSLL/CORPARDocument Partner4GUID_POBJPrimary Key of Preceding Objectvarbinary160
15/SAPSLL/CORREFReference Data4GUID_POBJPrimary Key of Preceding Objectvarbinary160
16/SAPSLL/CORSTALegal & Logistics Services: Document Statuses4GUID_POBJPrimary Key of Preceding Objectvarbinary160
17/SAPSLL/CORSTHChronological Status of a Document4GUID_POBJPrimary Key of Preceding Objectvarbinary160
18/SAPSLL/CORVALSLL: Values4GUID_POBJPrimary Key of Preceding Objectvarbinary160
19/SAPSLL/CTSCONVPNumber System: Relations: Improperly Classified Products5GUID_POBJPrimary Key of Preceding Objectvarbinary160
20/SAPSLL/CTSGENLegal&Logistics Services: Generic Part of Customs Tariff No.9GUID_POBJPrimary Key of Preceding Objectvarbinary160
21/SAPSLL/CTSMAESLL: Measure11GUID_POBJPrimary Key of Preceding Objectvarbinary160
22/SAPSLL/CTSNUMCustoms Tariff Number9GUID_POBJPrimary Key of Preceding Objectvarbinary160
23/SAPSLL/CTSNUMCL & L Services - Country-Specific Customs Tariff No.10GUID_POBJPrimary Key of Preceding Objectvarbinary160
24/SAPSLL/CUHDDATGTS: Customs Document: Header Dates4GUID_POBJPrimary Key of Preceding Objectvarbinary160
25/SAPSLL/CUHDSTAGTS: Customs Doc.: Header Status4GUID_POBJPrimary Key of Preceding Objectvarbinary160
26/SAPSLL/CUITDATGTS: Customs Document: Item Dates4GUID_POBJPrimary Key of Preceding Objectvarbinary160
27/SAPSLL/CUITSTAGTS: Customs Document: Item Status4GUID_POBJPrimary Key of Preceding Objectvarbinary160
28/SAPSLL/CUITSUBLegal Services: Customs Document - Subitem5GUID_POBJPrimary Key of Preceding Objectvarbinary160
29/SAPSLL/CUIVSLL: Customs Document: Bill4GUID_POBJPrimary Key of Preceding Objectvarbinary160
30/SAPSLL/CUPEDRIGTS: Period Entry Reference to Customs Document Item4GUID_POBJPrimary Key of Preceding Objectvarbinary160
31/SAPSLL/EMCHEAAdministrative Document (Excise Duty) - Header4GUID_POBJPrimary Key of Preceding Objectvarbinary160
32/SAPSLL/EMCITMAdministrative Document (Excise Duty) - Item4GUID_POBJPrimary Key of Preceding Objectvarbinary160
33/SAPSLL/ITARAUDDITAR Tracking: Log - Item Data5GUID_POBJPrimary Key of Preceding Objectvarbinary160
34/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results23GUID_POBJPrimary Key of Preceding Objectvarbinary160
35/SAPSLL/LCLICCQLegal Control: License - Quantities per Component4GUID_POBJPrimary Key of Preceding Objectvarbinary160
36/SAPSLL/LCLICCVLegal Control: License - Values per Component4GUID_POBJPrimary Key of Preceding Objectvarbinary160
37/SAPSLL/LEGACTSLL: Customs Document: Activities4GUID_POBJPrimary Key of Preceding Objectvarbinary160
38/SAPSLL/LEGAGRGTS: References to Aggregated Document Items4GUID_POBJPrimary Key of Preceding Objectvarbinary160
39/SAPSLL/LEGCOLContainer Management in Safekeeping4GUID_POBJPrimary Key of Preceding Objectvarbinary160
40/SAPSLL/LEGCOMSLL: Customs Document: Communiation Numbers4GUID_POBJPrimary Key of Preceding Objectvarbinary160
41/SAPSLL/LEGCONLegal Control - Document4GUID_POBJPrimary Key of Preceding Objectvarbinary160
42/SAPSLL/LEGCTRCustoms Document: Involved Countries4GUID_POBJPrimary Key of Preceding Objectvarbinary160
43/SAPSLL/LEGCULCSLL: Customs Document: Customs Processing: Duties4GUID_POBJPrimary Key of Preceding Objectvarbinary160
44/SAPSLL/LEGCUSCustoms Document: Customs Processing4GUID_POBJPrimary Key of Preceding Objectvarbinary160
45/SAPSLL/LEGDOCSLL: Customs Document: Documents4GUID_POBJPrimary Key of Preceding Objectvarbinary160
46/SAPSLL/LEGEVESLL: Customs Document: Events4GUID_POBJPrimary Key of Preceding Objectvarbinary160
47/SAPSLL/LEGFINGTS Customs Document: Closing Portions Item4GUID_POBJPrimary Key of Preceding Objectvarbinary160
48/SAPSLL/LEGLRGILegal Services: List of Services Still to Be Executed5GUID_POBJPrimary Key of Preceding Objectvarbinary160
49/SAPSLL/LEGMESSLL: Customs Document: Messages for Each Activity4GUID_POBJPrimary Key of Preceding Objectvarbinary160
50/SAPSLL/LEGOPRGTS Customs Document: Closing of Outward Processing4GUID_POBJPrimary Key of Preceding Objectvarbinary160
51/SAPSLL/LEGPGESLL: Customs Doc.: Packing Data4GUID_POBJPrimary Key of Preceding Objectvarbinary160
52/SAPSLL/LEGPLOSLL: Customs Document: Seals4GUID_POBJPrimary Key of Preceding Objectvarbinary160
53/SAPSLL/LEGREFSLL: Customs Document: External Reference Objects4GUID_POBJPrimary Key of Preceding Objectvarbinary160
54/SAPSLL/LEGSUSSSL Customs Document: Deferment4GUID_POBJPrimary Key of Preceding Objectvarbinary160
55/SAPSLL/LEGTPRSLL: Customs Document: Shipment Procedure4GUID_POBJPrimary Key of Preceding Objectvarbinary160
56/SAPSLL/PGEREFSLL: Package Data Link Handler4GUID_POBJPrimary Key of Preceding Objectvarbinary160
57/SAPSLL/RECDTRReconciliation Summary: Duties and Totals4GUID_POBJPrimary Key of Preceding Objectvarbinary160
58/SAPSLL/RECSIDReconciliation Summary: Item Details4GUID_POBJPrimary Key of Preceding Objectvarbinary160
59/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities6GUID_POBJPrimary Key of Preceding Objectvarbinary160
60/SAPSLL/SPLAUDLegal Control - SPL - Audit27GUID_POBJPrimary Key of Preceding Objectvarbinary160
61/SAPSLL/SPLAUDKLegal Control - SPL - Audit: Comments4GUID_POBJPrimary Key of Preceding Objectvarbinary160
62/SAPSLL/SPLAUDRAudit Trail for SPL Screening - Additional Object References14GUID_POBJPrimary Key of Preceding Objectvarbinary160
63/SAPSLL/TSCHDTax Statement: Hierarchy Customs Declaration Header4GUID_POBJPrimary Key of Preceding Objectvarbinary160
64/SAPSLL/TSCITTax Statement: Hierarchy Customs Declaration Item4GUID_POBJPrimary Key of Preceding Objectvarbinary160
65/SAPSLL/TSPEDTax Statement: Hierarchy of Collective Document4GUID_POBJPrimary Key of Preceding Objectvarbinary160
66/SAPSLL/TSPHDTax Statement: Customs Duties Totals4GUID_POBJPrimary Key of Preceding Objectvarbinary160
67/SAPSLL/TSPITTax Statement: Customs Duties Details4GUID_POBJPrimary Key of Preceding Objectvarbinary160
68/SAPSLL/TSTHDTax Statement: Hierarchy Tax Statement Header4GUID_POBJPrimary Key of Preceding Objectvarbinary160