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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

28 columns | Print definition?ERP 6.0  | WORKLIST_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/W_WLGRP_WLAssignment of Worklist to Worklist Group3WORKLIST_IDWorklist Namenvarchar200
2/GBT/W_WRKLST_HWorklist Header2WORKLIST_IDWorklist Namenvarchar200
3/GBT/W_WRKLST_IWorklist Item2WORKLIST_IDWorklist Namenvarchar200
4SATC_WL_FINDING"Worklist": Findings (transactional data)1WORKLIST_IDUnique ID - hex 16 - raw formatvarbinary160
5SATC_WL_HEAD"Worklist": Header (transactional data)1WORKLIST_IDUnique ID - hex 16 - raw formatvarbinary160
6SATC_WL_OBJECT"Worklist": Objects (transactional data)1WORKLIST_IDUnique ID - hex 16 - raw formatvarbinary160
7SATC_WL_OBJSET"Worklist": Object 2 set assignment (transactional data)1WORKLIST_IDUnique ID - hex 16 - raw formatvarbinary160
8SATC_WL_RAW_CAT"Worklist": Raw data pending for merge (transactional data)1WORKLIST_IDUnique ID - hex 16 - raw formatvarbinary160
9SATC_WL_RAW_SET"Worklist": Raw set pending for merge (transactional data)1WORKLIST_IDUnique ID - hex 16 - raw formatvarbinary160
10SLLS_STATS_ATTRRaw Data From Worklist for Translation Stats (Attributes)3WORKLIST_IDWorklist Numbernvarchar40
TOPIncentive and Commission Management ICM
11CACSCP_RCP_BUFFRCP: Buffer Table for RCP Processing2WORKLIST_IDRCP: Identification of Worklistnvarchar120
12CACSCP_RCP_CASERCP: Initial Commission Cases9WORKLIST_IDRCP: Identification of Worklistnvarchar120
13CACSCP_RCP_WLRCP: Worklist2WORKLIST_IDRCP: Identification of Worklistnvarchar120
14CACSCP_RCP_WL_BORCP: Business Objects in Worklists with Errors2WORKLIST_IDRCP: Identification of Worklistnvarchar120
15CACSCP_RCP_WL_INRCP: Information on Worklist2WORKLIST_IDRCP: Identification of Worklistnvarchar120
16YSVMA_RCP_BUFFRCP: Buffer Table for RCP Processing2WORKLIST_IDRCP: Identification of Worklistnvarchar120
17YSVMA_RCP_CASERCP: Initial Commission Cases9WORKLIST_IDRCP: Identification of Worklistnvarchar120
18YSVMA_RCP_WLRCP: Worklist2WORKLIST_IDRCP: Identification of Worklistnvarchar120
19YSVMA_RCP_WL_BORCP: Business Objects in Worklists with Errors2WORKLIST_IDRCP: Identification of Worklistnvarchar120
20YSVMA_RCP_WL_INRCP: Information on Worklist2WORKLIST_IDRCP: Identification of Worklistnvarchar120
21YTEL05_RCP_BUFFRCP: Buffer Table for RCP Processing2WORKLIST_IDRCP: Identification of Worklistnvarchar120
22YTEL05_RCP_CASERCP: Initial Commission Cases9WORKLIST_IDRCP: Identification of Worklistnvarchar120
23YTEL05_RCP_WLRCP: Worklist2WORKLIST_IDRCP: Identification of Worklistnvarchar120
24YTEL05_RCP_WL_BORCP: Business Objects in Worklists with Errors2WORKLIST_IDRCP: Identification of Worklistnvarchar120
25YTEL05_RCP_WL_INRCP: Information on Worklist2WORKLIST_IDRCP: Identification of Worklistnvarchar120
TOPTranslation Tools
26LXE_UPSETSUser Presets (General / Short Texts / Long Texts /Worklists)38WORKLIST_IDWorklist Numbernvarchar40
27LXE_USER_PRESETSDefault Settings for Translation Engine5WORKLIST_IDWorklist Numbernvarchar40
28SLLS_STATSDATARaw Data From Evaluation for Translation Statistics3WORKLIST_IDWorklist Numbernvarchar40