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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

58 columns | Print definition?B1 9.3  | LOGINS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AWL1Potential Processor of Tasks5LogInsLog InstanceInt110
2AWL2Input data for tasks7LogInsLog InstanceInt110
3AWL3Task Notes8LogInsLog InstanceInt110
4AWL4Task Output Data6LogInsLog InstanceInt110
5AWL5Task Field Mapping Information7LogInsLog InstanceInt110
6AWLSWorkflow - Task Details20LogInsLog Instance - HistoryInt110
7AWMGWorkflow Manager10LogInsLog Instance - HistoryInt110
8OWLSWorkflow - Task Details20LogInsLog Instance - HistoryInt110
9OWMGWorkflow Manager10LogInsLog Instance - HistoryInt110
10WLS1Potential Processor of Tasks5LogInsLog InstanceInt110
11WLS2Input data for tasks7LogInsLog InstanceInt110
12WLS3Notes of Tasks8LogInsLog InstanceInt110
13WLS4Task Output Data6LogInsLog InstanceInt110
14WLS5Task Field Mapping Information7LogInsLog InstanceInt110
TOPBusiness Partners
15ACP1Campaign - BPs18LogInsLog Instance - HistoryInt110
16ACP2Campaign - Items7LogInsLog Instance - HistoryInt110
17ACP3Campaign - Partners7LogInsLog Instance - HistoryInt110
18ACPNCampaign14LogInsLog Instance - HistoryInt110
19CPN1Campaign - BPs18LogInsLog Instance - HistoryInt110
20CPN2Campaign - Items7LogInsLog Instance - HistoryInt110
21CPN3Campaign - Partners7LogInsLog Instance - HistoryInt110
22OCPNCampaign14LogInsLog Instance - HistoryInt110
TOPInventory and Production
23AIN1Inventory Counting - Rows35LogInsLog Instance - HistoryInt110
24AIN10Inventory Counting - Individual Counters - Row UoM7LogInsLog Instance - HistoryInt110
25AIN2Inventory Counting - UoM13LogInsLog Instance - HistoryInt110
26AIN4Inventory Counting - Team Counters6LogInsLog Instance - HistoryInt110
27AIN5Inventory Counting - Team Counters - Row Counted Qty5LogInsLog Instance - HistoryInt110
28AIN6Inventory Counting - Team Counter - Row UoM7LogInsLog Instance - HistoryInt110
29AIN8Inventory Counting - Individual Counters6LogInsLog Instance - HistoryInt110
30AIN9Inventory Counting - Individual Counter - Row Counted Qty5LogInsLog Instance - HistoryInt110
31AINCInventory Counting14LogInsLog Instance - HistoryInt110
32AIQIInventory Opening Balance23LogInsLog Instance - HistoryInt110
33AIQRInventory Posting22LogInsLog Instance - HistoryInt110
34AQR2Inventory Counting - UoM13LogInsLog Instance - HistoryInt110
35ICD1Inventory Counting Draft - Rows35LogInsLog Instance - HistoryInt110
36ICD10Inventory Counting Draft - Individual Counter - Row UoM7LogInsLog Instance - HistoryInt110
37ICD2Inventory Counting Draft - UoM13LogInsLog Instance - HistoryInt110
38ICD4Inventory Counting Draft - Team Counters6LogInsLog Instance - HistoryInt110
39ICD5Inventory Counting Draft - Team Counter - Row Counted Qty5LogInsLog Instance - HistoryInt110
40ICD6Inventory Counting Draft - Team Counter - Row UoM7LogInsLog Instance - HistoryInt110
41ICD8Inventory Counting Draft - Individual Counters6LogInsLog Instance - HistoryInt110
42ICD9Inventory Counting Draft - Individual Counter - Row Counted Qty5LogInsLog Instance - HistoryInt110
43INC1Inventory Counting - Rows35LogInsLog Instance - HistoryInt110
44INC10Inventory Counting - Individual Counters - Row UoM7LogInsLog Instance - HistoryInt110
45INC2Inventory Counting - UoM13LogInsLog Instance - HistoryInt110
46INC4Inventory Counting - Team Counters6LogInsLog Instance - HistoryInt110
47INC5Inventory Counting - Team Counter - Row Counted Qty5LogInsLog Instance - HistoryInt110
48INC6Inventory Counting - Team Counter - Row UoM7LogInsLog Instance - HistoryInt110
49INC8Inventory Counting - Individual Counters6LogInsLog Instance - HistoryInt110
50INC9Inventory Counting - Individual Counters - Row Counted Qty5LogInsLog Instance - HistoryInt110
51IPD2Inventory Posting Draft - UoM13LogInsLog Instance - HistoryInt110
52IQR2Inventory Posting - UoM13LogInsLog Instance - HistoryInt110
53OICDInventory Counting Draft14LogInsLog Instance - HistoryInt110
54OINCInventory Counting14LogInsLog Instance - HistoryInt110
55OIODInventory Opening Balance Draft23LogInsLog Instance - HistoryInt110
56OIPDInventory Posting Draft22LogInsLog Instance - HistoryInt110
57OIQIInventory Opening Balance23LogInsLog Instance - HistoryInt110
58OIQRInventory Posting22LogInsLog Instance - HistoryInt110