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

73 columns | Print definition?ERP 6.0  | POBJT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/ADRCONLegal Control: Data on Address Defined for Business Partner31POBJTType of Preceding Objectnvarchar20
2/SAPSLL/ADRCONSPGTS: Legal Control: SPL Check Results for Address6POBJTType of Preceding Objectnvarchar20
3/SAPSLL/ADRLRIDGTS: Identification Numbers for Address in Business Partner14POBJTType of Preceding Objectnvarchar20
4/SAPSLL/BOPITGTS: General Bill of Product - Item Data8POBJTType of Preceding Objectnvarchar20
5/SAPSLL/CASECase3POBJTType of Preceding Objectnvarchar20
6/SAPSLL/CORACTLegal & Logistics Services: Activities3POBJTType of Preceding Objectnvarchar20
7/SAPSLL/CORCTSDocument - Customs Tariff Numbers: Non-Country-Specific3POBJTType of Preceding Objectnvarchar20
8/SAPSLL/CORCTSCL&L Services: Document - Customs Tariff Nos. (Country-Spec.)3POBJTType of Preceding Objectnvarchar20
9/SAPSLL/CORCTZCustoms Document Reference Codes3POBJTType of Preceding Objectnvarchar20
10/SAPSLL/CORCUITCL&L Srv.: Document - Item- and Country-Specific Customs Data7POBJTType of Preceding Objectnvarchar20
11/SAPSLL/CORCUSDCL&L Srv.: Document - Doc.- and Country-Specific Customs Data7POBJTType of Preceding Objectnvarchar20
12/SAPSLL/CORDATDeadlines3POBJTType of Preceding Objectnvarchar20
13/SAPSLL/CORDIMLegal & Logistics Services: Dimensions3POBJTType of Preceding Objectnvarchar20
14/SAPSLL/CORGDCLegal & Logistics Services: Goods Description3POBJTType of Preceding Objectnvarchar20
15/SAPSLL/CORPARDocument Partner3POBJTType of Preceding Objectnvarchar20
16/SAPSLL/CORREFReference Data3POBJTType of Preceding Objectnvarchar20
17/SAPSLL/CORSTALegal & Logistics Services: Document Statuses3POBJTType of Preceding Objectnvarchar20
18/SAPSLL/CORSTHChronological Status of a Document3POBJTType of Preceding Objectnvarchar20
19/SAPSLL/CORVALSLL: Values3POBJTType of Preceding Objectnvarchar20
20/SAPSLL/CTSCONVPNumber System: Relations: Improperly Classified Products6POBJTType of Preceding Objectnvarchar20
21/SAPSLL/CUHDDATGTS: Customs Document: Header Dates3POBJTType of Preceding Objectnvarchar20
22/SAPSLL/CUHDSTAGTS: Customs Doc.: Header Status3POBJTType of Preceding Objectnvarchar20
23/SAPSLL/CUITDATGTS: Customs Document: Item Dates3POBJTType of Preceding Objectnvarchar20
24/SAPSLL/CUITSTAGTS: Customs Document: Item Status3POBJTType of Preceding Objectnvarchar20
25/SAPSLL/CUITSUBLegal Services: Customs Document - Subitem4POBJTType of Preceding Objectnvarchar20
26/SAPSLL/CUIVSLL: Customs Document: Bill3POBJTType of Preceding Objectnvarchar20
27/SAPSLL/CUPEDRIGTS: Period Entry Reference to Customs Document Item3POBJTType of Preceding Objectnvarchar20
28/SAPSLL/EMCHEAAdministrative Document (Excise Duty) - Header3POBJTType of Preceding Objectnvarchar20
29/SAPSLL/EMCITMAdministrative Document (Excise Duty) - Item3POBJTType of Preceding Objectnvarchar20
30/SAPSLL/ITARAUDDITAR Tracking: Log - Item Data4POBJTType of Preceding Objectnvarchar20
31/SAPSLL/IVMCSL01Individual Stock Item, Special Customs Proced. - Change Log7POBJTType of Preceding Objectnvarchar20
32/SAPSLL/IVMCSL02Totals Stock, Special Customs Procedures - Change Log7POBJTType of Preceding Objectnvarchar20
33/SAPSLL/IVMFSL01Change Log for Individual Stock item Free Circulation f. PEU7POBJTType of Preceding Objectnvarchar20
34/SAPSLL/IVMPSL01Processing Stock: Log of Changes7POBJTType of Preceding Objectnvarchar20
35/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results22POBJTType of Preceding Objectnvarchar20
36/SAPSLL/LCLICAQLLicense: Change Log: Available Quantity6POBJTType of Preceding Objectnvarchar20
37/SAPSLL/LCLICAVLLicense: Change Log of Available Quantity6POBJTType of Preceding Objectnvarchar20
38/SAPSLL/LCLICCQLegal Control: License - Quantities per Component3POBJTType of Preceding Objectnvarchar20
39/SAPSLL/LCLICCVLegal Control: License - Values per Component3POBJTType of Preceding Objectnvarchar20
40/SAPSLL/LEGACTSLL: Customs Document: Activities3POBJTType of Preceding Objectnvarchar20
41/SAPSLL/LEGAGRGTS: References to Aggregated Document Items3POBJTType of Preceding Objectnvarchar20
42/SAPSLL/LEGCOLContainer Management in Safekeeping3POBJTType of Preceding Objectnvarchar20
43/SAPSLL/LEGCOMSLL: Customs Document: Communiation Numbers3POBJTType of Preceding Objectnvarchar20
44/SAPSLL/LEGCONLegal Control - Document3POBJTType of Preceding Objectnvarchar20
45/SAPSLL/LEGCTRCustoms Document: Involved Countries3POBJTType of Preceding Objectnvarchar20
46/SAPSLL/LEGCULCSLL: Customs Document: Customs Processing: Duties3POBJTType of Preceding Objectnvarchar20
47/SAPSLL/LEGCUSCustoms Document: Customs Processing3POBJTType of Preceding Objectnvarchar20
48/SAPSLL/LEGDOCSLL: Customs Document: Documents3POBJTType of Preceding Objectnvarchar20
49/SAPSLL/LEGEVESLL: Customs Document: Events3POBJTType of Preceding Objectnvarchar20
50/SAPSLL/LEGFINGTS Customs Document: Closing Portions Item3POBJTType of Preceding Objectnvarchar20
51/SAPSLL/LEGLRGILegal Services: List of Services Still to Be Executed4POBJTType of Preceding Objectnvarchar20
52/SAPSLL/LEGMESSLL: Customs Document: Messages for Each Activity3POBJTType of Preceding Objectnvarchar20
53/SAPSLL/LEGOPRGTS Customs Document: Closing of Outward Processing3POBJTType of Preceding Objectnvarchar20
54/SAPSLL/LEGPGESLL: Customs Doc.: Packing Data3POBJTType of Preceding Objectnvarchar20
55/SAPSLL/LEGPLOSLL: Customs Document: Seals3POBJTType of Preceding Objectnvarchar20
56/SAPSLL/LEGREFSLL: Customs Document: External Reference Objects3POBJTType of Preceding Objectnvarchar20
57/SAPSLL/LEGSUSSSL Customs Document: Deferment3POBJTType of Preceding Objectnvarchar20
58/SAPSLL/LEGTPRSLL: Customs Document: Shipment Procedure3POBJTType of Preceding Objectnvarchar20
59/SAPSLL/PGEREFSLL: Package Data Link Handler3POBJTType of Preceding Objectnvarchar20
60/SAPSLL/RECDTRReconciliation Summary: Duties and Totals3POBJTType of Preceding Objectnvarchar20
61/SAPSLL/RECSIDReconciliation Summary: Item Details3POBJTType of Preceding Objectnvarchar20
62/SAPSLL/SECADJWLWorklist for Automatic Adjustment of Securities5POBJTType of Preceding Objectnvarchar20
63/SAPSLL/SPLAUDLegal Control - SPL - Audit26POBJTType of Preceding Objectnvarchar20
64/SAPSLL/SPLAUDKLegal Control - SPL - Audit: Comments3POBJTType of Preceding Objectnvarchar20
65/SAPSLL/SPLAUDRAudit Trail for SPL Screening - Additional Object References13POBJTType of Preceding Objectnvarchar20
66/SAPSLL/TCOATAGTS: Control of Gener. Attrib. Maint.: Assgmt of Attributes2POBJTType of Preceding Objectnvarchar20
67/SAPSLL/TCOATCGTS: Control Settings for Generic Attribute Maintenance2POBJTType of Preceding Objectnvarchar20
68/SAPSLL/TSCHDTax Statement: Hierarchy Customs Declaration Header3POBJTType of Preceding Objectnvarchar20
69/SAPSLL/TSCITTax Statement: Hierarchy Customs Declaration Item3POBJTType of Preceding Objectnvarchar20
70/SAPSLL/TSPEDTax Statement: Hierarchy of Collective Document3POBJTType of Preceding Objectnvarchar20
71/SAPSLL/TSPHDTax Statement: Customs Duties Totals3POBJTType of Preceding Objectnvarchar20
72/SAPSLL/TSPITTax Statement: Customs Duties Details3POBJTType of Preceding Objectnvarchar20
73/SAPSLL/TSTHDTax Statement: Hierarchy Tax Statement Header3POBJTType of Preceding Objectnvarchar20