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
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
9OINM101Whse Journal
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2SLCATList type for sanctioned party list in legal controlnvarchar50 Allow NULL? 
3SLNOSSearch string for normalization of sanctioned party listnvarchar400 Allow NULL? 
4SLNORReplace string for normalization of sanctioned party listnvarchar400 Allow NULL? 
5SLPO1Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
6SLPO2Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
7SLPO3Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
8SLPO4Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
9SLPO5Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
10SLPO6Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
11SLPO7Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
12SLPO8Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
13SLP09Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
14SLP10Comparison operator for condition for sanctioned party listnvarchar20 Allow NULL? 
15SLN1ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
16SLN1BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
17SLN1CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
18SLN1DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
19SLN1ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
20SLN1FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
21SLN1GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
22SLN1HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
23SLN2ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
24SLN2BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
25SLN2CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
26SLN2DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
27SLN2ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
28SLN2FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
29SLN2GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
30SLN2HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
31SLN3ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
32SLN3BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
33SLN3CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
34SLN3DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
35SLN3ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
36SLN3FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
37SLN3GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
38SLN3HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
39SLN4ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
40SLN4BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
41SLN4CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
42SLN4DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
43SLN4ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
44SLN4FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
45SLN4GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
46SLN4HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
47SLN5ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
48SLN5BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
49SLN5CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
50SLN5DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
51SLN5ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
52SLN5FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
53SLN5GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
54SLN5HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
55SLN6ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
56SLN6BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
57SLN6CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
58SLN6DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
59SLN6ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
60SLN6FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
61SLN6GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
62SLN6HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
63SLN7ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
64SLN7BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
65SLN7CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
66SLN7DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
67SLN7ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
68SLN7FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
69SLN7GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
70SLN7HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
71SLN8ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
72SLN8BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
73SLN8CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
74SLN8DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
75SLN8ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
76SLN8FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
77SLN8GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
78SLN8HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
79SLN9ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
80SLN9BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
81SLN9CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
82SLN9DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
83SLN9ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
84SLN9FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
85SLN9GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
86SLN9HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
87SLN0ACondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
88SLN0BCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
89SLN0CCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
90SLN0DCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
91SLN0ECondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
92SLN0FCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
93SLN0GCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
94SLN0HCondition string for phonetic search of sanct. party listnvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
T608P~0YesYesCLUSTEREDSLNOR, SLNOS, SLCAT, MANDT