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

76 columns | Print definition?ERP 6.0  | DEST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_RFC_FGLOGFunction Module List Generation Log23DESTLogical Destination (Specified in Function Call)nvarchar320
2/WSCGMBH/LOGSKommunikationsprotokolle17DESTRFC-Destinationnvarchar320
3BBP_BACKEND_DESTDefinition of Back-End Systems in SAP SRM3DESTLogical Destination (Specified in Function Call)nvarchar320
4PA0615HR Master Record: Infotype 061530DESTHESA: Destination on leavingnvarchar20
5PA0616HR Master Record: Infotype 061656DESTHESA: Destination on leavingnvarchar20
6PAPBSGB_HESA_PHESA: Archive table for NISR Person table26DESTHESA: Destination on leavingnvarchar20
7T164CSAPcomm: Destination server assignment3DESTSAPcomm: Destination patternnvarchar40
8T390DPM: Destinations and database names for download3DESTDestination for Downloadnvarchar320
9T5GPBSH_DESHESA: Destination on leaving - obsolete2DESTHESA: Destination on leavingnvarchar20
10T5GPBSH_DES2HESA: Destination on leaving2DESTHESA: Destination on leavingnvarchar20
11T5GPBSH_DESTHESA: Destination on leaving (text) - obsolete3DESTHESA: Destination on leavingnvarchar20
12TN1SNSE_CFGConfiguration for sense3DESTLogical Destination (Specified in Function Call)nvarchar320
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
13CRM_ECLOG_SCRReplicated Log Entries of a Script Line16DESTLogical Destination (Specified in Function Call)nvarchar320
TOPALE Integration Technology
14IDOCSTYLETable of Style IDs with the Objects to Be Loaded6DESTStorage Locationnvarchar10
TOPAppointment Calendar
15SCDESTDestination for Scheduler and Mail3DESTLogical Destination (Specified in Function Call)nvarchar320
TOPASAP AcceleratedSAP
16SASAPBCSETBC Sets in Q&Adb6DESTName of SAP Systemnvarchar80
TOPBackground Processing
17TBTC_EXT_SDLExtSdl: Registration Table: External Schedulers1DESTExtSdl: Name of Destination for External Schedulernvarchar320
TOPBusiness Application Support
18CNVWDRFCCNV watchdog: RFC destinations from customer to SAP (OSS)1DESTLogical Destination (Specified in Function Call)nvarchar320
TOPBW Service API
19RSC2QOUTDescription of BW Outbound Queue7DESTLogical Destination (Specified in Function Call)nvarchar320
TOPCATT Computer Aided Test Tool
20CATRCATT: Reset table changes14DESTLogical Destination (Specified in Function Call)nvarchar320
TOPClinical System
21N1PRTIS-H: Printers per institution3DESTSpool: Output devicenvarchar40
TOPCustomer Interaction Center
22CIMAPInput Sequence for BDC Sessions5DESTTransfer of Data to Batch Input Sessionnvarchar10
23CRMC_CIC_ASP_AIC WinClient: ASP, application4DESTLogical Destination (Specified in Function Call)nvarchar320
TOPData Transfer
24KCDEDATARFlexible Excel Upload: Data Area5DESTSender structurenvarchar400
TOPDealer Portal
25/SAPDII/CPRSYSMPartner to System Mapping3DESTDestination IDnvarchar100
26/SAPDII/CSYSRFCMLogical system to RFC dest mapping2DESTDestination IDnvarchar100
TOPeCATT Extended Computer Aided Test Tool
27ECGUI_STATable of Started GUIs1DESTLogical Destination (Specified in Function Call)nvarchar320
28ECLOG_RESTABeCATT - Table Changes Reset6DESTLogical Destination (Specified in Function Call)nvarchar320
29ECLOG_SCRTable of Log Entries for a Script Line15DESTLogical Destination (Specified in Function Call)nvarchar320
30ECSCR_CMDNOT USED - Table with eCATT Script Commands10DESTLogical Destination (Specified in Function Call)nvarchar320
31ECTWB_DESTecATT Connections to Test Administration Systems3DESTLogical Destination (Specified in Function Call)nvarchar320
TOPJapan
32PA0559HR Master Record: Infotype 0559 (Commuting allowance Info.)28DESTDestinationnvarchar300
TOPMaintenance Orders
33/MRSS/D_QSTATEt-RFC Q-State3DESTLogical Destination (Specified in Function Call)nvarchar320
TOPMonitoring
34SCMLPSMOI_WS: Configuration of Logical Ports for SAPSTARTSRV1DESTSMOI_WS: Destination for CCMS Agents (sapstartsrv)nvarchar320
TOPOLAP Technology
35RSDDLOGITIP(Obsolete)1DESTDestination of Analytic Indexnvarchar320
TOPPeriodical Sales and Distribution
36TJYCIC_FR_APPLIS-M: CIC, Application for Remote CIC3DESTLogical Destination (Specified in Function Call)nvarchar320
37TJYCIC_FR_DESTIS-M: CIC, Destinations for Remote CIC2DESTLogical Destination (Specified in Function Call)nvarchar320
TOPPricing
38PRCC_COND_DESTTarget Fields for Condition Purposes4DESTTarget Field Name in Return Structure for Cumulationnvarchar300
TOPPrint and Output Management
39TSP0LSpool events11DESTSpool: Output devicenvarchar40
TOPResults Recording
40QISUBSubsytems for recording measured value data in QM7DESTLogical Destination (Specified in Function Call)nvarchar320
TOPRFC
41DESTLOGLogging Destinations2DESTLogical Destination (Specified in Function Call)nvarchar320
42QDIST001tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
43QDIST002tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
44QDIST003tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
45QDIST004tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
46QDIST005tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
47QDIST006tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
48QDIST007tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
49QDIST008tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
50QDIST009tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
51QDIST010tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
52QDIST011tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
53QDIST012tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
54QDIST013tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
55QDIST014tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
56QDIST015tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
57QDIST016tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
58QDIST017tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
59QDIST018tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
60QDIST019tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
61QDIST020tRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
62QOWKTABTable of qRFC Outbound Queues to Activate Automatically4DESTLogical Destination (Specified in Function Call)nvarchar320
63QRFCLOGTrace Description8DESTLogical Destination (Specified in Function Call)nvarchar320
64QRFCTRACETrace Description8DESTLogical Destination (Specified in Function Call)nvarchar320
65QSENDDESTTable of Registered tRFC/qRFC Destinations2DESTLogical Destination (Specified in Function Call)nvarchar320
66QUEUESTATEQueue, destination status2DESTLogical Destination (Specified in Function Call)nvarchar320
67RFCSTXTABRFC statistics administration12DESTLogical Destination (Specified in Function Call)nvarchar320
68TRFCQINtRFC Queue Description (Inbound Queue)9DESTLogical Destination (Specified in Function Call)nvarchar320
69TRFCQINSDescription of Saved tRFC-Queues (Inbound Queue)9DESTLogical Destination (Specified in Function Call)nvarchar320
70TRFCQOUTtRFC Queue Description (Outbound Queue)7DESTLogical Destination (Specified in Function Call)nvarchar320
TOPSAP NetWeaver Mobile - Use subcomponents
71MEREP_606Default RFC Destination2DESTDefault RFC Destinationnvarchar320
TOPService Processing
72/WSCGMBH/C_DESTClickSchedule: RFC-Destination2DESTClick Schedule: Destination for sending XMLnvarchar320
TOPWarranty Claim Processing
73DPCOMMON_MAP_P_SPartner to System Mapping3DESTDestination IDnvarchar100
74DPCOMMON_MAP_S_RLogical system to RFC dest mapping2DESTDestination IDnvarchar100
TOPWorkforce Management Application
75WFATM_URL_DESTWFM ESS URL Destination2DESTESS Destination Namenvarchar200
TOPWorkforce Management Core
76WFMTM_URL_DESTWFM ESS URL Destination2DESTESS Destination Namenvarchar200