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

59 columns | Print definition?ERP 6.0  | CSTSCM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPProduct Catalog
1TWIC8000Online store: Profile for product presentation3CSTSCMProduct presentation profilenvarchar40
2TWIC8001Online store: Profile for customer management3CSTSCMCustomer management profilenvarchar40
3TWIC8002Online store: Profile for quotation and order control3CSTSCMProfile for quotation and order controlnvarchar40
TOPSAP Retail Store
4TWIC0100General Settings for SAP Retail Store Goods Receipt3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
5TWIC0101Grouping of Reference Document Categs and Business Processes3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
6TWIC0110Retail Store GR: Basic Settings for Goods Receipt3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
7TWIC0200General Settings for SAP Retail Store Goods Movements3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
8TWIC0210SAP Retail Store GM: Basic Settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
9TWIC0220SAP Retail Store GM: Basic Settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
10TWIC0250General Business Transactions for SAP Retail Store GR3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
11TWIC0252Retail Store GM: Assignment of Business Transaction Group3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
12TWIC0300SAP Retail Store PO: Basic Settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
13TWIC0301SAP Retail Store PO: Allowed Document Types3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
14TWIC0302SAP Retail Store PO: Allowed Reasons for Ordering3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
15TWIC0400SAP Retail Store II: Incoming Invoice Basic Settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
16TWIC0401SAP Retail Store II: Permitted Reference Document Categories3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
17TWIC0403ASAP Retail Store II: Accounts for Cash Payment3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
18TWIC0403BSAP Retail Store II: Accounts for Cash Payment3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
19TWIC0403BTSAP Retail Store II: Accounts for Cash Payment4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
20TWIC0404SAP Retail Store II: Permitted Reversal Reasons3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
21TWIC0500Store Retail Store: Order Entry, Basic Data3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
22TWIC0501Store Retail Store: Order Entry, Allowed Order Types3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
23TWIC0504Delivery Lock with Downpayments3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
24TWIC0510In-Store MIM: Sales Order Basic Data3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
25TWIC0511In-Store MIM: Basic Data for Lean Order3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
26TWIC0515In-Store MIM: Customizing for SO condition types3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
27TWIC0518Retail Store: Customer Maint. - Customizing Baisic Data3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
28TWIC0600SAP Retail Store: Physical Inventory Basic Data3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
29TWIC0610SRS:Physical Inventory for handheld-basic data3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
30TWIC0623SRS Inventory Lookup basic settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
31TWIC0700Global Control of Store Order Function in Retail Store3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
32TWIC0750Global Control for Assortment Lists in Retail Store3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
33TWIC0800SAP Retail Store: Basic Data for Sales Prices Screen3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
34TWIC0900SAP Retail Store: Promotion Basic Data3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
35TWIC1001SRS: Definition of Tabstrips3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
36TWIC1001FSRS Stammdaten: Fields on Tabstrip3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
37TWIC1001TSRS Master Data: Tab Title Texts4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
38TWIC1002SAP Retail Store Master Data: Buttons on Initial Screen3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
39TWIC1002TSAP Retail Store Master Data: Buttons on Initial Screen4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
40TWIC1010ASRSII: Define Grouping Schema and Assign Chart of Accounts3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
41TWIC1010BSAP Retail Store II: Assignn Permitted G/L Accounts3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
42TWIC1010BTSAP Retail Store II: Costs- Texts f. G/L Accounts per Schema4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
43TWIC1020SAP Retail Store: Permitted Units of Measure3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
44TWIC1100SRS Vendor Master: Basic Settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
45TWIC1200Basic Settings for SAP Retail Store Article Master Maint.3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
46TWIC1290SAP Retail Store Material Search: Basic settings3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
47TWIC1291SAP Retail Store Material Search: Plant range grouping3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
48TWIC1301ARetail Store HH: Handheld Device Type Definition3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
49TWIC1301BRetail Store HH: Assign Handheld Tasks3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
50TWIC1301CRetail Store HH: Assign Handheld Function Keys3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
51TWIC1310Retail Store HH: Assign Handheld Applications3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
52TWIC1310ARetail Store HH: Assign Handheld Applications3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
53TWIC1310BRetail Store HH: Assign Handheld Applications3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
54TWIC1320Assignment of menu items3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
55TWIC1320TAssignment of menu item texts4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
56TWICMESSAGESAP Retail Store: Define Characteristics of System Messages3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
57TWICSCMIACs Retail: Customizing schemas3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
58TWICSCMFSAP Retail Store: Assignment of Customizing Schemas to Site4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40
59TWICSCMTIACs Retail: Customizing Schema Texts4CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40