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

195 columns | Print definition?ERP 6.0  | TASK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/RUNNING_WFRunning Workflow for AIF4TASKTask IDnvarchar140
2/IAM/WF_LOCKLock table for workflow, will always be empty3TASKTask IDnvarchar140
3/OTEB/SWF_TACTPWorkflow activity profile4TASKWorkflow templatenvarchar140
4/XFT/DIO_DEMO_02Workflow Customizing4TASKTask abbreviationnvarchar140
5/XFT/EPA_DWFL_01Persistence workflow 016TASKTask abbreviationnvarchar140
6CNVMBTSHELLSPECShell Creation: Tables with special handling for copy3TASKShell Creation: Type of shell creationnvarchar50
7CNVMBTSPECSpecial handling of tables3TASKTask Idnvarchar50
8CNVTDMS_06_SPECSpecial handling of tables3TASKTDMS tasknvarchar50
9DMC_JN_TASKMWB: Job Net Task4TASKMWB: Tasknvarchar300
10DMC_JOB_SETTINGJob control information2TASKData element for describing the structure of acronym fieldnvarchar80
11GRFNTASKREGTable to store relations for regulation and task2TASKPlan usagenvarchar100
12IUUC_CCARD_ORDERorder and status information for credit card de-/encryption18TASKIUUC CCARD - task number in RFC starting new tasknvarchar40
13RSDRI_HDB_SPOStatus Table for SAP HANA Conversion of SPOs3TASKCharacter Field Length = 10nvarchar100
14SWDDUSRATTWorkflow Definition: User Attributes1TASKTask abbreviationnvarchar140
15SWDDUSRATTTXTWorkflow Definition: User Attribute Text Table1TASKTask abbreviationnvarchar140
16SWD_USRATTWorkflow Definition: User Attributes2TASKTask abbreviationnvarchar140
17SWD_USRATTTXTWorkflow Definition: User Attribute Texts2TASKTask abbreviationnvarchar140
18SWF_UNIT_MONWorkflow: Unit Monitoring4TASKTask IDnvarchar140
19SWW_TASKCUSTWorkflow: Task Customizing2TASKTask IDnvarchar140
20TTST_PRINT_TSKDATA FOR LOCATION & TASK5TASKChar 80nvarchar800
21TTS_LOCATIONTASKDATA FOR LOCATION & TASK5TASKTask infonvarchar800
22UCS01ACTasks: Data Transfer3TASKTasknvarchar100
23UCS01AD0Tasks: Sign-Off (Matrix Dimension)3TASKTasknvarchar100
24UCS01AD1Tasks: Sign-Off3TASKTasknvarchar100
25UCS01AETasks: Reconciliations3TASKTasknvarchar100
26UPGSQLUpgrade SQL Statements for processing1TASKnvarchar300
TOPAnalyzer
27AFWCH_BPCTLBPMIG: Status Management for AFWCH-Specific Conversion2TASKAFWCH-Specific Conversion Stepsnvarchar20
TOPArchiveLink
28TWFDBWorkflow: NCI document types8TASKTask abbreviationnvarchar140
TOPBasis Technology R3
29/ISDFPS/WF_RECEIWorkflow Recipient3TASKTask abbreviationnvarchar140
TOPBRFplus - ABAP-Based Business Rules
30FDT_ACTN_1200FDT: Action - Start workflow base data4TASKTask IDnvarchar140
31FDT_ACTN_1200AFDT: Action - Start workflow base data4TASKTask IDnvarchar140
32FDT_ACTN_1200SFDT: Action - Start workflow base data3TASKTask IDnvarchar140
33FDT_ACTN_1200TFDT: Action - Start workflow base data3TASKTask IDnvarchar140
34FDT_ACTN_1210FDT: Action - Start workflow container data4TASKTask IDnvarchar140
35FDT_ACTN_1210AFDT: Action - Start workflow container data4TASKTask IDnvarchar140
36FDT_ACTN_1210SFDT: Action - Start workflow container data3TASKTask IDnvarchar140
37FDT_ACTN_1210TFDT: Action - Start workflow container data3TASKTask IDnvarchar140
38FDT_ACTN_1220FDT: Action - Start workflow BOR data4TASKTask IDnvarchar140
39FDT_ACTN_1220AFDT: Action - Start workflow BOR data4TASKTask IDnvarchar140
40FDT_ACTN_1220SFDT: Action - Start workflow BOR data3TASKTask IDnvarchar140
41FDT_ACTN_1220TFDT: Action - Start workflow BOR data3TASKTask IDnvarchar140
TOPBusiness Consolidation
42UCFTL00Data Collection: Overview Screen4TASKTasknvarchar100
43UCFTL01Data Transfer Overview Screen: Methods4TASKTasknvarchar100
44UCFTL10Data Collection: Overview Screen4TASKTasknvarchar100
45UCFTL11Data Collection Overview Screen: Methods4TASKTasknvarchar100
46UCFTL12Data Collection: Hidden Lines in Web Dynpro4TASKTasknvarchar100
47UCS0100Tasks: Method3TASKTasknvarchar100
48UCS0101Tasks: Document Type3TASKTasknvarchar100
49UCS0102Tasks: CU-Dependency of Method Assignment3TASKTasknvarchar100
50UCS0103Tasks: Elimination of IU P/L in Inventory3TASKTasknvarchar100
51UCS0104Tasks: Validation3TASKTasknvarchar100
52UCS0105Tasks: Cons Frequency3TASKTasknvarchar100
53UCS0106Tasks: Posting Levels3TASKTasknvarchar100
54UCS0107Tasks: Processing Type3TASKTasknvarchar100
55UCS0108Tasks: Data Streams for Copy Task3TASKTasknvarchar100
56UCS0109Tasks: Copy Task3TASKTasknvarchar100
57UCS010CTasks3TASKTasknvarchar100
58UCS010STasks4TASKTasknvarchar100
59UCS010TTasks: Text4TASKTasknvarchar100
60UCS0110Tasks: Preceding Tasks3TASKTasknvarchar100
61UCS0120Tasks: Status-bearing Cons Groups3TASKTasknvarchar100
62UCS01A0Tasks: Settings for Log Display3TASKTasknvarchar100
63UCS01A1Tasks: Log Layout: Custom Layouts3TASKTasknvarchar100
64UCS01A2Tasks: Log Layout: Sequence, Active/Inactive3TASKTasknvarchar100
65UCS01A3Tasks: IPA or CVA3TASKTasknvarchar100
66UCS01A4Tasks: Cons Group Selection3TASKTasknvarchar100
67UCS01A5Tasks: Balance Carryforward Task3TASKTasknvarchar100
68UCS01A6Tasks: Workflow Variant3TASKTasknvarchar100
69UCS01A7Measures: Workflow_variant for Sign-Off Task3TASKTasknvarchar100
70UCS01A8Measures: Selection ID for repunit and repgroup3TASKTasknvarchar100
71UCS01A9Measures: Query3TASKTasknvarchar100
72UCS01AATasks: Reclassification3TASKTasknvarchar100
73UCS01ABTasks: Consolidation Group Change3TASKTasknvarchar100
74UCS0400Statusbearing Rep.Groups for Interunit Level 103TASKTasknvarchar100
75UCST001SEM-BCS: Performance Statistics11TASKTasknvarchar100
76UCT920GBusiness Objects for Workflow in Status Changes4TASKTasknvarchar100
TOPBusiness Planning and Simulation
77UPX_PLTASKSettings for Planning Task3TASKPlanning Foldernvarchar100
TOPBusiness Process Engine
78SWFDCRLDLVMODEConfiguration of Inbound Processing2TASKTask IDnvarchar140
79SWFDCRLDVERSVersioning of Configuration of Inbound Processing2TASKTask IDnvarchar140
80SWFXICACHEXI: Cache for Process Definitions6TASKTask IDnvarchar140
81SWFXICLOGXI Cache: Message Log1TASKTask IDnvarchar140
82SWFXIINBQUEUESConfiguration of Inbound Processing; Specified Queues2TASKTask IDnvarchar140
83SWFXIINBSWITCHSwitch Configuration of Inbound Processing2TASKTask IDnvarchar140
84SWFXIINB_TRC_DATWorkflow-Trace: Data Entries14TASKTask IDnvarchar140
85SWFXIINB_TRC_SELWorkflow Trace: Selection Conditions for Trace Start9TASKTask IDnvarchar140
86SWFXIOBJSXI: Cache: Objects of a Process Definition (Proxy, CRL..)1TASKTask IDnvarchar140
TOPClaims Management
87ICL_ACTN_1000BRFplus : Tasks (Customizing)6TASKActivity Management: Tasknvarchar60
88ICL_ACTN_1000ABRFplus : Tasks (Application)6TASKActivity Management: Tasknvarchar60
89ICL_ACTN_1000SBRFplus : Tasks (System)5TASKActivity Management: Tasknvarchar60
90ICL_CRBPTASKRBP: Assignment of Task to Role3TASKTask / Log Entrynvarchar60
91TIAM110Reserved for Future Developments: Tasks in IAM3TASKTasknvarchar60
92TIAM110TActivity Management: Tasks - Texts4TASKTasknvarchar60
93TIAM111IAM: Activities of a Task3TASKTasknvarchar60
94TICL044_2Task/Log Entry: Claim Type Specific Navigation Target2TASKTask / Log Entrynvarchar60
95TICL093SAPscript Texts for Tasks3TASKTask / Log Entrynvarchar60
TOPClient-System Adapter
96MDMFDBEVENTMDM: Message inbound events10TASKnvarchar10
TOPConsolidation
97TFMIG15Migration: Status2TASKMigration tasknvarchar30
TOPCustomer Interaction Center
98ECICWFINBFLTTask Filter for Profile- for CIC Workflow Inbox3TASKTask IDnvarchar140
TOPData Staging
99RSBATCHADMAdministration Settings for Batch Mananger1TASKObject Administration Business Information Warehousenvarchar300
TOPData Transfer Workbench
100DXATTRIBTask Attributes5TASKData transfer tasknvarchar150
101DXATTRIB2Attributes of Task of Type MAP LSMW5TASKData transfer tasknvarchar150
102DXATTRIB3Attribute of Task of Type Split5TASKData transfer tasknvarchar150
103DXATTRIB4Attributes of Task of Type MAP DMCW5TASKData transfer tasknvarchar150
104DXFILETRANSPContainer for Transporting Data Information7TASKData transfer tasknvarchar150
105DXLOASTATStatus of 'Load via BAPI'5TASKData transfer tasknvarchar150
106DXRELATAssignment of Files to Tasks5TASKData transfer tasknvarchar150
107DXTASKSTasks for Mass Data Transfer to R/35TASKData transfer tasknvarchar150
108DXTASKS_TTask Texts for Mass Data Transfer to R/36TASKData transfer tasknvarchar150
TOPEmployee Interaction Center
109THREIC_TASK_LTIDEIC Assignment of Start Transaction ID to Task ID2TASKTask IDnvarchar140
TOPFront Office
110EWAACTAction Manager: Actions10TASKTask IDnvarchar140
TOPGovernance, Risk and Compliance
111GRFNREGTASKTable to store relations for regulation and task2TASKPlan usagenvarchar100
112GRFNSELPRCTASKTable to store relations for selection proc. and task3TASKPlan usagenvarchar100
113GRFNTASKPLANData for task plan4TASKPlan usagenvarchar100
114GRFNTASKPLANGRPData for task plan group3TASKPlan usagenvarchar100
TOPJob Scheduling and Monitoring
115/JCS/FCC_ACTIONSFCc: Notification actions to perform3TASKDescription of a Folder or Tasknvarchar600
TOPKnowledge Warehouse
116IWRELFRZEKEN releases4TASKFunction Codenvarchar700
TOPLink to Geographic Information System
117GCABGBC: Worklist5TASKTasknvarchar40
118GCCBGBC: Field Allocations3TASKTasknvarchar40
119GCCCGBC: Steps3TASKTasknvarchar40
120GCCDGBC: Tasks3TASKTasknvarchar40
121GCCIGBC: Container for Parameter3TASKTasknvarchar40
122GCCJGBC: Default Values3TASKTasknvarchar40
123GCCKGBC: Container for Attributes3TASKTasknvarchar40
TOPManagement of Internal Controls
124FOPCCLOSINGClose5TASKTask IDnvarchar100
125FOPCCLOSINGBGClose: Background5TASKTask IDnvarchar100
126FOPCMTESTERASGNMass Tester Assignment7TASKTask IDnvarchar100
127FOPCMTESTERASGNSMass Tester Assignment - Settings6TASKTask IDnvarchar100
128FOPCREPORTList of Reports3TASKTask IDnvarchar100
129FOPCROLETASKMIC Role - Task Assignments3TASKTask IDnvarchar100
130FOPCSODTASKMIC SOD Conflict Task3TASKTask IDnvarchar100
131FOPCTASKMIC Task2TASKTask IDnvarchar100
132FOPCTASKFREQFrequency of the Tasks2TASKTask IDnvarchar100
133FOPCTASKFREQ_TFTimeframes of Tasks That Can Be Scheduled at Corporate Level2TASKTask IDnvarchar100
134FOPCTASKFREQ_TFCControls for Timeframes of Tasks that Can Be Scheduled2TASKTask IDnvarchar100
135FOPCTASKTMIC Task - Text Table3TASKTask IDnvarchar100
136FOPCWFITEMMIC: Workflow Items3TASKTask IDnvarchar100
137FOPCWFNOTIFCFADetails for Notification System per Work Item2TASKTask IDnvarchar140
138FOPC_REPORTOBSOLETE - Do not use3TASKTask IDnvarchar100
TOPProcess Controls
139GRPCCLOSINGClosed/Frozen organizations5TASKTask IDnvarchar100
140GRPCCLOSINGBGCarry Forward list in Background job for Closing5TASKTask IDnvarchar100
141GRPCMENUTASKMenu Task mapping3TASKTask IDnvarchar100
142GRPCMENUTASKCMenu Task mapping - Customer enhancement3TASKTask IDnvarchar100
143GRPCMTESTERASGNObsolete: Mass Tester Assignment7TASKTask IDnvarchar100
144GRPCMTESTERASGNSObsolete: Mass Tester Assignment - Settings6TASKTask IDnvarchar100
145GRPCREPORTList of Reports4TASKTask IDnvarchar100
146GRPCROLETASKObsolete: PC Role - Task Assignments3TASKTask IDnvarchar100
147GRPCSODTASKObsolete: PC SOD Conflict Task3TASKTask IDnvarchar100
148GRPCTASKObsolete: GRPC authorization tasks2TASKTask IDnvarchar100
149GRPCTASKFREQObsolete: Frequency of the Tasks2TASKTask IDnvarchar100
150GRPCTASKFREQ_TFObsolete: Tasks That Can Be Scheduled at Corporate Level2TASKTask IDnvarchar100
151GRPCTASKFREQ_TFCObsolete: Timeframes of Tasks that Can Be Scheduled2TASKTask IDnvarchar100
152GRPCTASKPLANObsolete: Data for task plan4TASKTask IDnvarchar100
153GRPCTASKTObsolete: PC Task - Text Table3TASKTask IDnvarchar100
154GRPCWFITEMPC: Workflow Items3TASKTask IDnvarchar100
155GRPC_TASK25ROLEPC2.5 task PFCG role mapping1TASKTask IDnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
156DFMCA_BRF490BRF: Parameters for Creation Workflow in Form Processing7TASKTask IDnvarchar140
TOPQuality Management
157QNOTIF_TASK_DSDigital Signature for Notifications - Task Level5TASKSort Number for Tasknvarchar40
TOPResourcen Management
158RMXTC_M02TMS-TLS: Monitor Customizing - Tasks2TASKTrial Monitor Tasknvarchar200
159RMXTC_M02TTMS-TLS: Monitor Customizing - Task Texts3TASKTrial Monitor Tasknvarchar200
160RMXTC_M03TMS-TLS: Monitor Customizing - Assgt of Task to Task Group3TASKTrial Monitor Tasknvarchar200
161RMXTC_M04TMS-TLS: Monitor Customizing - Task Relationship Rules3TASKTrial Monitor Tasknvarchar200
162RMXTC_T16TMS-API: Customizing - Assignment of Trial Type to Classes4TASKTrial Monitor Tasknvarchar200
TOPRuntime
163SWFGPWULACDEFWhere-Used List of Activities in Workflow Definitions2TASKTask abbreviationnvarchar140
TOPSAP Business Workflow
164SWDFACTIONForm Types and Actions4TASKTask abbreviationnvarchar140
165SWDILOGInternal Log of Changes to Workflow Definitions1TASKTask abbreviationnvarchar140
166SWDSHEADERWF Definition: Basic Data38TASKTask abbreviationnvarchar140
167SWDSMNODESWF Definition: Nodes8TASKTask abbreviationnvarchar140
168SWDSSTEPSWF Definition: Steps6TASKTask abbreviationnvarchar140
169SWDSTASKSWF Definition: Tasks7TASKTask abbreviationnvarchar140
170SWD_HEADERWF Definition/Runtime: Basic Data39TASKTask abbreviationnvarchar140
171SWD_MNODESWorkflow Definition: Node Table (Definition)9TASKTask abbreviationnvarchar140
172SWD_STEPSWF-Definition/Runtime: Steps7TASKTask abbreviationnvarchar140
173SWFDLCONFIG2TASKWorkflow: Configured tasks for special deadline handling3TASKTask IDnvarchar140
174SWFRLSUCWorkflow Log: Actions22TASKTask IDnvarchar140
175SWFVGTGeneral Task Visualization2TASKTask IDnvarchar140
176SWFVGTPGeneral Task-Visualization Parameters2TASKTask IDnvarchar140
177SWFVTTask Visualization1TASKTask IDnvarchar140
178SWFVTVTask Visualization Parameter1TASKTask IDnvarchar140
179SWF_WFPRECWF: Recovery information for Workflow Wizards17TASKWorkflow Wizard Workflownvarchar140
180SWL_CTITLEWLC: Column title for task-specific inbox4TASKTask abbreviationnvarchar140
181SWL_CUSTOMWLC: Task-specific columns in inbox3TASKTask abbreviationnvarchar140
182SWWWF2DESTWorkflow: RFC Destination for Workflow4TASKTask IDnvarchar140
183SWW_STAT_CRTWorkflow: Created Workflows6TASKTask IDnvarchar140
TOPSAP System Log
184TSL5DSystem Log Filter Settings Used17TASKSystem log: SAP process namenvarchar20
TOPSchedule Manager
185SCMA_CALL_TRANSSchedule Manager: Transactions to Call Up For Task2TASKTask Managed by the Schedule Managernvarchar400
186SCMA_CALL_TRANSBSchedule Manager: Transactions to Call Up For Task2TASKTask Managed by the Schedule Managernvarchar400
187SMSTNode Structure and Task Name in the Schedule Manager5TASKCharacter field of length 40nvarchar400
TOPSwitch Framework Tools
188SFW_SW_PK_REMOVErequest of a switch, where the act. package has been remove3TASKRequest/Tasknvarchar200
TOPTime Sheet
189TCATSCATS: Data Entry Profiles53TASKTask IDnvarchar140
TOPWaste Management
190EHSWAC_EAOPTYPEApplication Functions5TASKTask for SAP Business Workflownvarchar140
191EHSWAC_ENTAMFOFFunctions for Disposal Processing6TASKTask for SAP Business Workflownvarchar140
TOPWeb Dynpro ALV for ABAP
192SALV_CSQ_TR_RECTrace records8TASKTask namenvarchar600
TOPWeb Services Tool
193CRMOST_GENSTATUSGeneration status of objects from CRM Open Services Tool3TASKOperationnvarchar10
194CRMOST_GEN_TEMPLGeneration templates for Open Services Tool1TASKOperationnvarchar10
195CRMOST_TASKTTask texts and mapping to CRM_OBJKIND1TASKOperationnvarchar10