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

79 columns | Print definition?ERP 6.0  | TASK_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000149000PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes6TASK_IDnvarchar240
2/FLDQ/HNATASKMAPTable to map DQ Process to IM in HANA task ID6TASK_IDIM in HANA Runtime task IDnvarchar330
3/IWPGW/C_TGW_CTXCustomization table to store context service per task id2TASK_IDtask type for unified inboxnvarchar400
4/IWPGW/C_TGW_TSKTask Gateway customization table for Scenarios Tasks3TASK_IDtask type for unified inboxnvarchar400
5/IXOS/RSA_T_TRCTrace table6TASK_IDGUID in 'RAW' formatvarbinary160
6CNVMBTSUBPARAMSParameters for Subactivities5TASK_IDNumeric Identifyer of Conversion or Migration Tasknvarchar60
7CNVMBTSUBSTATEStatus table for execution of all subactivities and histor4TASK_IDNumeric Identifyer of Conversion or Migration Tasknvarchar60
8EHPRCD_CMP_POSCampaign Position15TASK_IDTask Numbernvarchar200
9GBAPP_C_PO_TASKWorkflowTask ID for Approve Purchase Orders App2TASK_IDTask for MM Approval Appsnvarchar140
10GBAPP_C_PR_TASKWorkflowTask ID for Approve Purchase Requests App2TASK_IDTask for MM Approval Appsnvarchar140
11GRFNMWRTINSTWIMSMP Runtime - Work Item execution context cache5TASK_IDStage Task IDnvarchar140
12GRFNNAVTASKNavigation Targets for Tasks1TASK_IDTask IDnvarchar140
13GRFNTASKBOWorkflow Task Business Objects2TASK_IDTask IDnvarchar140
14GRFNWFTASKNAMEGRFN workflow task name maintenance table3TASK_IDTask IDnvarchar140
15MMIV_ASI_C_TASKSSupplier Invoice Appr.: Workflow Tasks in Approval Process2TASK_IDTask IDnvarchar140
16RSBPCB_ACTIONBPC: Activity action7TASK_IDBPC: Task IDnvarchar200
17SIMDQ_TRK_TASKIM in HANA track tasks on Client3TASK_IDnvarchar190
18SRA001_C_PC_TASKWorkflow Task ID for Approve Purchase Contracts App2TASK_IDTask for Approve Purchase Contracts Appnvarchar140
19WB2_C_TASKApp: Workflow Task ID for Approve Trading Contract2TASK_IDWorkflow Task for Approval Processnvarchar140
20ZPROJ_DETAILSProject and Task details4TASK_IDCharacter Field Length = 10nvarchar100
TOPClinical System
21N2DWSWL_TASKDProvisional Task2TASK_IDTask Keynvarchar330
TOPCross-Application Components
22/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices17TASK_IDTask IDnvarchar140
23/OPT/VIM_NPO_WIDVIM IE Monitortable: WI Header Data for NPO Invoices12TASK_IDTask IDnvarchar140
24/OPT/VIM_NPO_WIHVIM IE Monitortable: WI Header Data for NPO Invoices13TASK_IDTask IDnvarchar140
25/OPT/VIM_PO_WIDVIM Report: WI Header Data for PO Invoices13TASK_IDTask IDnvarchar140
26/OPT/VIM_PO_WIHVIM Report: WI Header Data for PO Invoices14TASK_IDTask IDnvarchar140
27CNV_05010_INFOStatus information on table backup record3TASK_IDnvarchar300
TOPDay-to-Day Activities
28LSOCRPCNTXTPRTCLLSO Correspondence: Log Area2TASK_IDContext GUIDnvarchar320
29LSOCRPCNTXTSTAGELSO Correspondence: Staging Area2TASK_IDContext GUIDnvarchar320
TOPEngineering Change Record
30/PLMB/WFTSK_OTYPWorkflow task ID for GOS object types2TASK_IDWorkflow Task IDnvarchar140
TOPGovernance, Risk and Compliance
31GRFNTASKAUTHRELRelated authorization details per WF task1TASK_IDTask IDnvarchar140
TOPGuided Procedure
32EUP_BSP_CFG_PROPStores the configuration properties for the input value ctx.2TASK_IDGUID in 'CHAR' Format in Uppercasenvarchar320
33EUP_BSP_IV_CTXTemp table to hold the input value context.2TASK_IDGUID in 'CHAR' Format in Uppercasenvarchar320
34EUP_BSP_OV_CTXTable for bsp co output data. Used by j2ee to get the output2TASK_IDGUID in 'CHAR' Format in Uppercasenvarchar320
35EUP_BSP_RSL_STSThe result states associated with the bsp output context.2TASK_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPNetwork and Activity
36MLSTMilestone55TASK_IDWorkflow tasknvarchar140
37SMLSStandard milestone73TASK_IDWorkflow tasknvarchar140
TOPObjective Setting and Appraisals
38HRHAP_GOAL_ERRORGoals: An cascading error occurred in the existing document3TASK_IDTechnical Field: Task IDvarbinary160
TOPOffice Suite Program
39SOSP_T_TASK_INFOTable for Maintaining Task Info10TASK_IDWorkflow Task IDnvarchar140
TOPPeriodical Sales and Distribution
40JVTMCP_ITEMIS-M: TMCP Structures (CRoute/GUnit)22TASK_IDTask IDnvarchar320
TOPPortfolio Management
41RPM_TASKProject Task Data3TASK_IDIDnvarchar240
TOPProcess Controls
42GRPCNWBCMETATask - Link Mapping3TASK_IDTask IDnvarchar100
TOPRuntime
43SWFGPWULTASKSGP Where-Used List for Generated Single-Step Tasks5TASK_IDTask IDnvarchar140
TOPSAP Business Workflow
44SWFMIG_REF_TASKStandard tasks referred by Workflows (ccBPM)2TASK_IDstandard tasks referred by Workflow (ccBPM)nvarchar140
45SWLWPTSSIDTask Linkages for WebFlow Services2TASK_IDTask IDnvarchar140
46SWPSTEPLOGWorkflow: Instance Data of Steps of a Workflow Execution13TASK_IDTask abbreviationnvarchar140
47SWZAIENTRYObject Table for Work Queues (Entries)4TASK_IDTask IDnvarchar140
48SWZAIRETReturn Values of Method Call of a WQ Line4TASK_IDTask IDnvarchar140
TOPSAP Healthcare - Industry-Specific Components for Hospitals
49N2BIRESDWSIS-H*MED: Base Items Result Table DWS Tasks2TASK_IDTask Keynvarchar330
50N2DWSWL_TASKTask2TASK_IDTask Keynvarchar330
51N2DWSWL_TASKPROFOccupational Groups of Tasks in Processing6TASK_IDTask Keynvarchar330
TOPService Data Download
52/BDL/ADDONKEYSAddonkey sequence numbers for requested AddOn download1TASK_IDCharacter Field Length = 10nvarchar100
53/BDL/SESSMAPControl table for SDCC sessions9TASK_IDCharacter Field Length = 10nvarchar100
54/BDL/STAMPLast task runs (service def refresh/session refresh)7TASK_IDID of SDCCN tasknvarchar100
TOPSimulation
55VSMLST_CNVersion: Milestone56TASK_IDWorkflow tasknvarchar140
TOPSoftware Agent Framework
56SAFD_SE_QUEUESAF Queued Jobs4TASK_IDSAF Task IDnvarchar10
TOPStructure
57DPR_TASKTasks5TASK_IDTask Numbernvarchar240
TOPSuite Inbox
58IBO_C_WF_CACList of custom attributes for the task types3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
59IBO_C_WF_CASList of custom attributes for the task types3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
60IBO_C_WF_TACTasks for Inbox Configuration3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
61IBO_C_WF_TAETasks for Inbox Configuration (Exceptions in Multibackend)3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
62IBO_C_WF_TASTasks for Inbox Configuration3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
63IBO_C_WF_TA_P_HCAssociation of Workflow Task ID to POWL Type (Hide)4TASK_IDInbox Workflow Task Identifiernvarchar140
64IBO_C_WF_TA_P_SCAssociation of Workflow Task ID to POWL Type (Show)4TASK_IDInbox Workflow Task Identifiernvarchar140
65IBO_C_WF_TA_P_TYAssociation of Workflow Task ID to POWL Type4TASK_IDInbox Workflow Task Identifiernvarchar140
66IBO_C_WF_TTAClist of actions allowed per task3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
67IBO_C_WF_TTAEList of Allowed Actions per Task3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
68IBO_C_WF_TTASList of Allowed Actions per Task3TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID)nvarchar140
TOPTransport Registry
69TRN_REG_TASKSTransport Requests/Tasks per Application and Service Group4TASK_IDTransport Requestnvarchar200
TOPWeb Service and SOAP - ABAP
70SRTFT_QDATA_LOGFurther Data for Registry Task2TASK_IDTask ID in Web Service Mass Configurationnvarchar320
71SRTFT_QUEUEProcessing FIFO3TASK_IDTask ID in Web Service Mass Configurationnvarchar320
72SRTFT_QUEUE_DATAFurther Data for Registry Task Log Entry2TASK_IDTask ID in Web Service Mass Configurationnvarchar320
73SRTFT_QUEUE_LG_TQueue Log Message Entries3TASK_IDTask ID in Web Service Mass Configurationnvarchar320
74SRTFT_QUEUE_LOGLog of SRT Configuration FIFO3TASK_IDTask ID in Web Service Mass Configurationnvarchar320
75SRT_CNTRL_TASKSSOAManager Central Configuration: Tasks2TASK_IDSOAManager Central Configuration: Task ID (GUID32)nvarchar320
76SRT_CTRL_TSK_MSGSOAManager Central Configuration: Tasks2TASK_IDSOAManager Central Configuration: Task ID (GUID32)nvarchar320
77SRT_PEND_TASKPending SRT Configuration Tasks2TASK_IDTask ID of SRT Configurationnvarchar200
78TASK_VITA_LOSTAdministration of Registered Watcher Functions2TASK_IDTask Identifier for Task Vitalnvarchar320
79TASK_VITA_MAINAdministration of Registered Watcher Functions2TASK_IDTask Identifier for Task Vitalnvarchar320