SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

58 columns | Print definition?B1 9.2  | 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