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

43 columns | Print definition?ERP 6.0  | WF_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIAFFLOGDetails related to Firefighter ID Log On Information11WF_IDUUID of the GRC object (char32)nvarchar320
2/GRCPI/GRIARLLOGDetails related to Firefighter ID Log On Information9WF_IDUUID of the GRC object (char32)nvarchar320
3CMCBD_BRF_HSTRYCash Budget Workflow History for BRF+2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
4CMCBD_BRF_LINKSCash Budget Workflow Node Links for BRF+2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
5CMCBD_COMMENT_PLCash Budgeting Workflow History2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
6CMCBD_CYCLECash Budgeting Cycle5WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
7CMCBD_TK_LINKSBRF+ Workflow Task and Link Mapping Table2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
8CMCBD_TK_USERSBRF+ Workflow Task and User Mapping Table2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
9CMCBD_WF_HISTORYCash Budgeting Workflow History2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
10CMCBD_WF_LINKSCash Budgeting Workflow Node Links for Positions2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
11CMCBD_WF_ORGCash Budgeting Org Info2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
12CMCBD_WF_USERSCash Budgeting Workflow Users2WF_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
13GRACFFLOGDetails related to Firefighter ID Log On Information11WF_IDUUID of the GRC object (char32)nvarchar320
14GRACROLEFFLOGDetails related to Firefighter ID Log On Information9WF_IDUUID of the GRC object (char32)nvarchar320
15GRFNMWRTKEYMSMP Runtime - Workflow Instances6WF_IDUUID of the GRC object (char32)nvarchar320
16SCMA_CONT_EL_FCCElements of Workflow Container (TVARV Variable) for FCC4WF_IDWork item IDnvarchar120
17T7INLOAN_WFWork Flow ID based on country grouping and Loan Type5WF_IDWork Flow IDnvarchar120
18WB2_C_WFWorkflow IDs Used for Trading Contract Approval2WF_IDWorkflow IDnvarchar140
TOPMaterials Management
19/ISDFPS/DG_EXCPTDG Management: Exception Requests DG Check OBSOLETE4WF_IDWorkflow IDnvarchar120
TOPOffice Suite Program
20SOSP_T_SAPPL_DETSub Application Detail4WF_IDWorkflow IDnvarchar140
21SOSP_T_WF_DECSNWorkflow Decision3WF_IDWorkflow IDnvarchar140
22SOSP_T_WF_DECS_TWorkflow Decision Description4WF_IDWorkflow IDnvarchar140
TOPOverhead Cost Controlling
23PFSWPPeriod-End Partner: Log (Workflow Log Information)4WF_IDWorkflow IDnvarchar120
TOPPortfolio Management
24/RPM/WF_IDTable of Workflow IDs2WF_IDWorkflow IDnvarchar150
25/RPM/WF_ID_TText table for Workflow IDs3WF_IDWorkflow IDnvarchar150
26/RPM/WF_RECIPObject type and activity type relevant for RPM workflow4WF_IDWorkflow IDnvarchar150
TOPRuntime
27SWFDEBUGWorkflow Debugger: Breakpoints7WF_IDWorkflow IDnvarchar120
TOPSAP Business Workflow
28SWFRPCSTARWorkflow: Process Step in Status of a Process Unit II2WF_IDWork item IDnvarchar120
29SWFRPCSTATWorkflow: Process Step in Status of a Process Unit I2WF_IDWork item IDnvarchar120
30SWH_ABSENCEWorkflow: Demo for Workflow Infos4WF_IDWork item IDnvarchar120
31SWPCMPCONTComponent Container of WFM3WF_IDWork item IDnvarchar120
32SWPNODEWFM: Node Properties and Node Hierarchy at Runtime2WF_IDWorkflow IDnvarchar120
33SWPNODELOGWorkflow: Instance Data of Nodes of a Workflow Execution2WF_IDWorkflow IDnvarchar120
34SWPSTEPLOGWorkflow: Instance Data of Steps of a Workflow Execution2WF_IDWorkflow IDnvarchar120
35SWP_ADM_USWFM: Administrator(s) for a workflow instance2WF_IDWorkflow IDnvarchar120
36SWP_HEADERWorkflow Instances: Header Data of a Workflow Execution2WF_IDWorkflow IDnvarchar120
37SWP_JOINWorkflow instances: Join node of a workflow execution2WF_IDWorkflow IDnvarchar120
38SWP_NODEWIWF: Work items for nodes in a workflow definition2WF_IDWorkflow IDnvarchar120
39SWP_SUSPENWorkflow instances: Suspended work item callbacks2WF_IDWorkflow IDnvarchar120
TOPSchedule Manager
40SCMATREEDTable for Entries that are Dependent on Time and Date10WF_IDWork item IDnvarchar120
TOPWorkflow Modeler
41SWFMOD_ACTIONstore temporary information about action for a workflow2WF_IDNumber of workflow definitionnvarchar100
42SWFMOD_COMP_TMPLTemplates and components for the workflow modeler2WF_IDNumber of workflow definitionnvarchar100
43SWFMOD_USER_WKFLUser specific workflows (created in modeler)2WF_IDNumber of workflow definitionnvarchar100