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

56 columns | Print definition?ERP 6.0  | AGENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/RUNNING_WFRunning Workflow for AIF13AGENTAgentnvarchar140
2/AIF/TICKETSTicket content table for Ticket System17AGENTAgent for Processing Next Stepnvarchar140
3/OPT/CT_LG_HISTLog event history8AGENTUser Name in User Master Recordnvarchar120
4/OPT/VIM_VAL_AGTTable: DP documents and correspnding VALIDATORs3AGENTUser Name in User Master Recordnvarchar120
5/OPT/VT_WI_ACTVReporting table: Workitem activities5AGENTAgent IDnvarchar350
6/PLMI/PRT_LINEProcess Route Template Line5AGENTAgent for Route Itemnvarchar140
7/SAPSRM/C_SRC_AGSearch: Agent Customizing4AGENTObject Type Namenvarchar300
8/SAPSRM/D_WF_013Table of persistent class /SAPSRM/CL_WF_WORKITEM6AGENTIdentification (PD-Org. ID) of Workflow Agentnvarchar120
9DFKKCLERKBuffer from fkkclear... data5AGENTCollection Specialist from Organizational Managementnvarchar120
10GRFNMWCNSDEFMSMP Stage Definition5AGENTAgent IDnvarchar400
11GRFNMWCNSDEFVMSMP Stage Definitions - Versions7AGENTAgent IDnvarchar400
12GRFNMWCNSTGMSMP Stage8AGENTAgent IDnvarchar400
13GRFNMWCNSTGVMSMP Stage Version9AGENTAgent IDnvarchar400
14GRRMCTXEHSAGStore EH&S Agents with their types2AGENTEHS Agentnvarchar200
15GRRMRESPAUTWFAGResponse Automation - Workflow Agents4AGENTAgent ID in Organizational Managementnvarchar120
16J_1I_EXIM_WFEXIM : Workflow Levels and Approvers at Request Level8AGENTActual Agentnvarchar140
17REFXCN_WF_AGENTMaintain Workflow Agent for REFX6AGENTAgent ID in Organizational Managementnvarchar120
18T7INPEW1P2E: Workflow Levels and Approvers at Request Level12AGENTActual Agentnvarchar140
19T7INPEW10P2E: Policy Workflow Log Table for Reminder Mails8AGENTActual Agentnvarchar140
20T7INPEW2P2E: Follow On Actions for Request Level Workflows14AGENTActual Agentnvarchar140
21T7INPEW5P2E: Workflow Levels and Approvers at Policy Level11AGENTActual Agentnvarchar140
22T7INPEW8P2E: Follow On Actions for Policy Level Workflows12AGENTActual Agentnvarchar140
23T7INPEW9P2E: Workflow Log Table for Resubmission and Reminder Mails8AGENTActual Agentnvarchar140
24T7INPEWAP2E: Workflow Log Table for Reminder Mails-Initator:HR Admin10AGENTActual Agentnvarchar140
TOPBasic Data
25TNM50AIS-H MM: Active Ingredients2AGENTCode for Active Ingredientnvarchar200
26TNM50TIS-H MM: Active Ingredients (Texts)2AGENTCode for Active Ingredientnvarchar200
TOPBusiness Consolidation
27UCT9110Workflow Documents: Approval Actions10AGENTActual Agent of Work Itemnvarchar120
28UCT9210Workflow Documents: Approval Actions8AGENTActual Agent of Work Itemnvarchar120
TOPClinical System
29NAGENTTIS-H*MED: Agents of Drugs - Texts4AGENTMedication: Agent Namenvarchar1600
TOPCommunication Services Mail, Fax, SMS, Telephony
30SRIRAGRPBCOM Internal Router: Agent Group6AGENTSAPphone: Call center user IDnvarchar150
TOPContract Accounts Receivable and Payable
31DFKKWLA_STATWorklist for Notification - Status for Specialist4AGENTCollection Specialist Assignednvarchar120
32DFKKWLIWork Items44AGENTAssigned Specialistnvarchar120
33DFKKWLIAWork Items (Work Item Type)44AGENTAssigned Specialistnvarchar120
34DFKKWLIAHWork Items (History, Work Item Type)21AGENTCollection Specialist Assignednvarchar120
35DFKKWLIHWork Items (History)21AGENTCollection Specialist Assignednvarchar120
36DFKKWL_STATWorklist - Status for Collection Specialist3AGENTCollection Specialist Assignednvarchar120
37FKKMACTIVITIESDunning Activities11AGENTCollection Specialist Assignednvarchar120
38TFKCMCAPCapacity Restriction for Dunning Activities (Customizing)5AGENTCollection Specialist Assignednvarchar120
TOPCustomer Interaction Center
39CCMCLBSCall center callback - Whole6AGENTUser Name in User Master Recordnvarchar120
40CCMSESSIONCall management sessions3AGENTCall center callback - Call center agentnvarchar120
TOPDocument Builder
41/IPRO/TWF_DATAapplication data for workflow3AGENTAgentnvarchar140
TOPEmployee Interaction Center
42THREIC_IBSUBSTEIC Inbox Substitution2AGENTUser Namenvarchar120
TOPLease Accounting
43/LSIERP/WLIWork Items20AGENTAdministrator from Organizational Managementnvarchar120
44/LSIERP/WLIHDO NOT USE -> Can Be Deleted11AGENTAdministrator from Organizational Managementnvarchar120
45/LSIERP/WL_STATWorklist - Status for Collector3AGENTAdministrator from Organizational Managementnvarchar120
TOPPublic Sector
46PA0508HR-AU-PS: Master Data For Prior Service24AGENTName of agent for the last servicenvarchar300
TOPRecords and Case Management
47RMPS_T_RESUBResubmissions (new)4AGENTAgent for Route Itemnvarchar140
TOPRemaining Beverage - Obsolete Objects
48/BEV1/CLSCHShip Information7AGENTAgentnvarchar200
TOPSAP Business Workflow
49SWDAAGNTSAd Hoc Agents3AGENTActual Agentnvarchar140
50SWFREXTPROCWorkflow: Relation Between Work Item and External Process7AGENTAgent of External Processnvarchar120
TOPSAP NetWeaver Mobile - Use subcomponents
51MEMGMT_DEV_MONMonitoring for Devices7AGENTService of the Monitoring Functionnvarchar1280
52MEMGMT_SERVICEDevice Management - Agent Description2AGENTService of the Monitoring Functionnvarchar1280
TOPSAP Records Management
53SRMWFPTHPSProcess Route Item for Workflow6AGENTAgent for Route Itemnvarchar140
TOPSelf-Service Procurement
54/SRMERP/D_WF_013Table of persistent class /SRMERP/CL_WF_WORKITEM6AGENTIdentification (PD-Org. ID) of Workflow Agentnvarchar120
TOPSpain
55PA0968HR master record infotype 096861AGENTTriggering material agentnvarchar80
TOPWork Clearance Management
56WCCPWCM: WCM Object <-> Approvals16AGENTAgentnvarchar140