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

23 columns | Print definition?ERP 6.0  | WLITYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPContract Accounts Receivable and Payable
1DFKKWLWorklist3WLITYPEWork Item Typenvarchar10
2DFKKWLAWorklist (Work Item Type)2WLITYPEWork Item Typenvarchar10
3DFKKWLA_STATWorklist for Notification - Status for Specialist2WLITYPEWork Item Typenvarchar10
4DFKKWLIWork Items3WLITYPEWork Item Typenvarchar10
5DFKKWLIAWork Items (Work Item Type)2WLITYPEWork Item Typenvarchar10
6DFKKWLIABWTrigger for Delta Extraction for Notification Work Items2WLITYPEWork Item Typenvarchar10
7DFKKWLIAHWork Items (History, Work Item Type)2WLITYPEWork Item Typenvarchar10
8DFKKWLIA_ACActions of Work Item (Work Item Type)2WLITYPEWork Item Typenvarchar10
9DFKKWLIHWork Items (History)5WLITYPEWork Item Typenvarchar10
10DFKKWLI_ACActions of Work Item4WLITYPEWork Item Typenvarchar10
11DFKKWL_STATWorklist - Status for Collection Specialist4WLITYPEWork Item Typenvarchar10
12TFK005_WLAResidence Time for Worklists Dependent on Work Item Type2WLITYPEWork Item Typenvarchar10
13TFK005_WLIAResid. Time for Collection Work Item Dependent on Category2WLITYPEWork Item Typenvarchar10
14TFK052BCustomizing Work Item: Category3WLITYPEWork Item Typenvarchar10
15TFK052BTCustomizing Work Item: Category (Text)4WLITYPEWork Item Typenvarchar10
16TFK052CCustomizing Work Item: Resubmission Reason3WLITYPEWork Item Typenvarchar10
17TFK052CTCustomizing Work Item: Resubmission Reason (Text)4WLITYPEWork Item Typenvarchar10
18TFK052ECustomizing Work Item: Assignment Reason3WLITYPEWork Item Typenvarchar10
19TFK052ETCustomizing Work Item: Assignment Reason (Text)4WLITYPEWork Item Typenvarchar10
20TFK052FSystem Table Work Item: Status2WLITYPEWork Item Typenvarchar10
21TFK052FTWork Item Status3WLITYPEWork Item Typenvarchar10
22TFK052GCustomizing Work Item: Success Description3WLITYPEWork Item Typenvarchar10
23TFK052GTCustomizing Work Item: Success Description (Text)4WLITYPEWork Item Typenvarchar10