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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Sales and Distribution :: Foreign Trade :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T608P941Legal Control: Sanctioned Party Lists: Phonetic SearchBasic Functions
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, SLCAT, SLNOS, SLNOR, SLPO1, SLPO2, SLPO3, SLPO4, SLPO5, SLPO6, SLPO7, SLPO8, SLP09, SLP10, SLN1A, SLN1B, SLN1C, SLN1D, SLN1E, SLN1F, SLN1G, SLN1H, SLN2A, SLN2B, SLN2C, SLN2D, SLN2E, SLN2F, SLN2G, SLN2H, SLN3A, SLN3B, SLN3C, SLN3D, SLN3E, SLN3F, SLN3G, SLN3H, SLN4A, SLN4B, SLN4C, SLN4D, SLN4E, SLN4F, SLN4G, SLN4H, SLN5A, SLN5B, SLN5C, SLN5D, SLN5E, SLN5F, SLN5G, SLN5H, SLN6A, SLN6B, SLN6C, SLN6D, SLN6E, SLN6F, SLN6G, SLN6H, SLN7A, SLN7B, SLN7C, SLN7D, SLN7E, SLN7F, SLN7G, SLN7H, SLN8A, SLN8B, SLN8C, SLN8D, SLN8E, SLN8F, SLN8G, SLN8H, SLN9A, SLN9B, SLN9C, SLN9D, SLN9E, SLN9F, SLN9G, SLN9H, SLN0A, SLN0B, SLN0C, SLN0D, SLN0E, SLN0F, SLN0G, SLN0H FROM T608P
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SLCATList type for sanctioned party list in legal controlnvarchar50CHAR(N' ')NoT608LSLCAT Allow NULL? 
3SLNOSSearch string for normalization of sanctioned party listnvarchar400CHAR(N' ')NoSLNOS Allow NULL? 
4SLNORReplace string for normalization of sanctioned party listnvarchar400CHAR(N' ')NoSLNOR Allow NULL? 
5SLPO1Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
6SLPO2Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
7SLPO3Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
8SLPO4Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
9SLPO5Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
10SLPO6Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
11SLPO7Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
12SLPO8Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
13SLP09Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
14SLP10Comparison operator for condition for sanctioned party listnvarchar20CHAR(N' ')YesSLPOP Allow NULL? 
15SLN1ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
16SLN1BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
17SLN1CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
18SLN1DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
19SLN1ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
20SLN1FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
21SLN1GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
22SLN1HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
23SLN2ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
24SLN2BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
25SLN2CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
26SLN2DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
27SLN2ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
28SLN2FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
29SLN2GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
30SLN2HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
31SLN3ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
32SLN3BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
33SLN3CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
34SLN3DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
35SLN3ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
36SLN3FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
37SLN3GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
38SLN3HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
39SLN4ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
40SLN4BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
41SLN4CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
42SLN4DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
43SLN4ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
44SLN4FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
45SLN4GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
46SLN4HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
47SLN5ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
48SLN5BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
49SLN5CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
50SLN5DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
51SLN5ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
52SLN5FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
53SLN5GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
54SLN5HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
55SLN6ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
56SLN6BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
57SLN6CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
58SLN6DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
59SLN6ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
60SLN6FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
61SLN6GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
62SLN6HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
63SLN7ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
64SLN7BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
65SLN7CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
66SLN7DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
67SLN7ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
68SLN7FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
69SLN7GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
70SLN7HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
71SLN8ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
72SLN8BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
73SLN8CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
74SLN8DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
75SLN8ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
76SLN8FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
77SLN8GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
78SLN8HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
79SLN9ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
80SLN9BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
81SLN9CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
82SLN9DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
83SLN9ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
84SLN9FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
85SLN9GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
86SLN9HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
87SLN0ACondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
88SLN0BCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
89SLN0CCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
90SLN0DCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
91SLN0ECondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
92SLN0FCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
93SLN0GCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
94SLN0HCondition string for phonetic search of sanct. party listnvarchar100CHAR(N' ')YesSLNOC Allow NULL? 
NamePrimaryUniqueTypeColumns
T608P~0YesYesCLUSTEREDSLNOR, SLNOS, SLCAT, MANDT