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  | CSTOBJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPProduct Catalog
1TWIC8000Online store: Profile for product presentation2CSTOBJRetail IACs: Customizing objectnvarchar40
2TWIC8001Online store: Profile for customer management2CSTOBJRetail IACs: Customizing objectnvarchar40
3TWIC8002Online store: Profile for quotation and order control2CSTOBJRetail IACs: Customizing objectnvarchar40
4TWIC8003IACs Retail: Selection of countries for customer address2CSTOBJRetail IACs: Customizing objectnvarchar40
TOPSAP Retail Store
5TWIC0100General Settings for SAP Retail Store Goods Receipt2CSTOBJRetail IACs: Customizing objectnvarchar40
6TWIC0101Grouping of Reference Document Categs and Business Processes2CSTOBJRetail IACs: Customizing objectnvarchar40
7TWIC0110Retail Store GR: Basic Settings for Goods Receipt2CSTOBJRetail IACs: Customizing objectnvarchar40
8TWIC0200General Settings for SAP Retail Store Goods Movements2CSTOBJRetail IACs: Customizing objectnvarchar40
9TWIC0210SAP Retail Store GM: Basic Settings2CSTOBJRetail IACs: Customizing objectnvarchar40
10TWIC0220SAP Retail Store GM: Basic Settings2CSTOBJRetail IACs: Customizing objectnvarchar40
11TWIC0250General Business Transactions for SAP Retail Store GR2CSTOBJRetail IACs: Customizing objectnvarchar40
12TWIC0251Retail Store GM: Key for Business Transaction Group2CSTOBJRetail IACs: Customizing objectnvarchar40
13TWIC0251TRetail Store GM: Text for Business Transaction Group3CSTOBJRetail IACs: Customizing objectnvarchar40
14TWIC0252Retail Store GM: Assignment of Business Transaction Group2CSTOBJRetail IACs: Customizing objectnvarchar40
15TWIC0300SAP Retail Store PO: Basic Settings2CSTOBJRetail IACs: Customizing objectnvarchar40
16TWIC0301SAP Retail Store PO: Allowed Document Types2CSTOBJRetail IACs: Customizing objectnvarchar40
17TWIC0302SAP Retail Store PO: Allowed Reasons for Ordering2CSTOBJRetail IACs: Customizing objectnvarchar40
18TWIC0400SAP Retail Store II: Incoming Invoice Basic Settings2CSTOBJRetail IACs: Customizing objectnvarchar40
19TWIC0401SAP Retail Store II: Permitted Reference Document Categories2CSTOBJRetail IACs: Customizing objectnvarchar40
20TWIC0403ASAP Retail Store II: Accounts for Cash Payment2CSTOBJRetail IACs: Customizing objectnvarchar40
21TWIC0403BSAP Retail Store II: Accounts for Cash Payment2CSTOBJRetail IACs: Customizing objectnvarchar40
22TWIC0403BTSAP Retail Store II: Accounts for Cash Payment3CSTOBJRetail IACs: Customizing objectnvarchar40
23TWIC0404SAP Retail Store II: Permitted Reversal Reasons2CSTOBJRetail IACs: Customizing objectnvarchar40
24TWIC0500Store Retail Store: Order Entry, Basic Data2CSTOBJRetail IACs: Customizing objectnvarchar40
25TWIC0501Store Retail Store: Order Entry, Allowed Order Types2CSTOBJRetail IACs: Customizing objectnvarchar40
26TWIC0504Delivery Lock with Downpayments2CSTOBJRetail IACs: Customizing objectnvarchar40
27TWIC0510In-Store MIM: Sales Order Basic Data2CSTOBJRetail IACs: Customizing objectnvarchar40
28TWIC0511In-Store MIM: Basic Data for Lean Order2CSTOBJRetail IACs: Customizing objectnvarchar40
29TWIC0515In-Store MIM: Customizing for SO condition types2CSTOBJRetail IACs: Customizing objectnvarchar40
30TWIC0518Retail Store: Customer Maint. - Customizing Baisic Data2CSTOBJRetail IACs: Customizing objectnvarchar40
31TWIC0600SAP Retail Store: Physical Inventory Basic Data2CSTOBJRetail IACs: Customizing objectnvarchar40
32TWIC0610SRS:Physical Inventory for handheld-basic data2CSTOBJRetail IACs: Customizing objectnvarchar40
33TWIC0623SRS Inventory Lookup basic settings2CSTOBJRetail IACs: Customizing objectnvarchar40
34TWIC0700Global Control of Store Order Function in Retail Store2CSTOBJRetail IACs: Customizing objectnvarchar40
35TWIC0750Global Control for Assortment Lists in Retail Store2CSTOBJRetail IACs: Customizing objectnvarchar40
36TWIC0800SAP Retail Store: Basic Data for Sales Prices Screen2CSTOBJRetail IACs: Customizing objectnvarchar40
37TWIC0900SAP Retail Store: Promotion Basic Data2CSTOBJRetail IACs: Customizing objectnvarchar40
38TWIC1000FMSAP Retail Store: Master for Fields on Tabstrips1CSTOBJSAP Retail Store Customizing Objectnvarchar40
39TWIC1000TSKSAP Retail Store: Tasks for Field Attribute Control1CSTOBJSAP Retail Store Customizing Objectnvarchar40
40TWIC1000TSKTSAP Retail Store: Texts for Tasks for Field Attribute Cntrl1CSTOBJSAP Retail Store Customizing Objectnvarchar40
41TWIC1001SRS: Definition of Tabstrips2CSTOBJRetail IACs: Customizing objectnvarchar40
42TWIC1001FSRS Stammdaten: Fields on Tabstrip2CSTOBJRetail IACs: Customizing objectnvarchar40
43TWIC1001TSRS Master Data: Tab Title Texts3CSTOBJRetail IACs: Customizing objectnvarchar40
44TWIC1002SAP Retail Store Master Data: Buttons on Initial Screen2CSTOBJRetail IACs: Customizing objectnvarchar40
45TWIC1002TSAP Retail Store Master Data: Buttons on Initial Screen3CSTOBJRetail IACs: Customizing objectnvarchar40
46TWIC1010ASRSII: Define Grouping Schema and Assign Chart of Accounts2CSTOBJRetail IACs: Customizing objectnvarchar40
47TWIC1010BSAP Retail Store II: Assignn Permitted G/L Accounts2CSTOBJRetail IACs: Customizing objectnvarchar40
48TWIC1010BTSAP Retail Store II: Costs- Texts f. G/L Accounts per Schema3CSTOBJRetail IACs: Customizing objectnvarchar40
49TWIC1020SAP Retail Store: Permitted Units of Measure2CSTOBJRetail IACs: Customizing objectnvarchar40
50TWIC1100SRS Vendor Master: Basic Settings2CSTOBJRetail IACs: Customizing objectnvarchar40
51TWIC1200Basic Settings for SAP Retail Store Article Master Maint.2CSTOBJRetail IACs: Customizing objectnvarchar40
52TWIC1290SAP Retail Store Material Search: Basic settings2CSTOBJRetail IACs: Customizing objectnvarchar40
53TWIC1291SAP Retail Store Material Search: Plant range grouping2CSTOBJRetail IACs: Customizing objectnvarchar40
54TWIC1301ARetail Store HH: Handheld Device Type Definition2CSTOBJRetail IACs: Customizing objectnvarchar40
55TWIC1301BRetail Store HH: Assign Handheld Tasks2CSTOBJRetail IACs: Customizing objectnvarchar40
56TWIC1301CRetail Store HH: Assign Handheld Function Keys2CSTOBJRetail IACs: Customizing objectnvarchar40
57TWIC1310Retail Store HH: Assign Handheld Applications2CSTOBJRetail IACs: Customizing objectnvarchar40
58TWIC1310ARetail Store HH: Assign Handheld Applications2CSTOBJRetail IACs: Customizing objectnvarchar40
59TWIC1310BRetail Store HH: Assign Handheld Applications2CSTOBJRetail IACs: Customizing objectnvarchar40
60TWIC1320Assignment of menu items2CSTOBJRetail IACs: Customizing objectnvarchar40
61TWIC1320TAssignment of menu item texts3CSTOBJRetail IACs: Customizing objectnvarchar40
62TWIC1321AAssigment of buttons to device type: Device assignment2CSTOBJRetail IACs: Customizing objectnvarchar40
63TWIC1321BAssigment of buttons to device type: Device, task assignment2CSTOBJRetail IACs: Customizing objectnvarchar40
64TWIC1321CAssigment of buttons to device type: Device, task, buttons2CSTOBJRetail IACs: Customizing objectnvarchar40
65TWIC1321CTAssigment of buttons to device type: Device, task, buttons3CSTOBJRetail IACs: Customizing objectnvarchar40
66TWICMESSAGESAP Retail Store: Define Characteristics of System Messages2CSTOBJRetail IACs: Customizing objectnvarchar40
67TWICOBJIACs Retail: Customizing objects2CSTOBJRetail IACs: Customizing objectnvarchar40
68TWICOBJTIACs Retail: Customizing objects, texts3CSTOBJRetail IACs: Customizing objectnvarchar40
69TWICSCMIACs Retail: Customizing schemas2CSTOBJRetail IACs: Customizing objectnvarchar40
70TWICSCMFSAP Retail Store: Assignment of Customizing Schemas to Site2CSTOBJRetail IACs: Customizing objectnvarchar40
71TWICSCMTIACs Retail: Customizing Schema Texts3CSTOBJRetail IACs: Customizing objectnvarchar40
72TWICSKEYSAP Retail Store: Key for Selection in Selection Boxes2CSTOBJRetail IACs: Customizing objectnvarchar40
73TWICSKEYTSAP Retail Store: Selection Box Key Texts3CSTOBJRetail IACs: Customizing objectnvarchar40