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

69 columns | Print definition?ERP 6.0  | HASH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/QRFC_S_IDXqRFC Standard index table64HASHHASH for tRFC/qRFCvarbinary400
2/AIF/Q_STD_IDX_TqRFC Standard index table64HASHHASH for tRFC/qRFCvarbinary400
3/AIF/TRFC_S_IDXtRFC Standard index table49HASHHASH for tRFC/qRFCvarbinary400
4/AIF/T_STD_IDX_TtRFC Standard index table49HASHHASH for tRFC/qRFCvarbinary400
5/IWBEP/I_SBD_GASB: DM node generated artifact12HASHHash Value (160 Bits)varbinary200
6/IWFND/I_DST_TRAstorage for transported items2HASHnvarchar1040
7/SDF/SQLHISTSQL Monitor: Delta records for top SQL statements12HASHHash Value (160 Bits)varbinary200
8/SDF/SQLTEXTABAP SQL Text with Hash Key1HASHHash Value (160 Bits)varbinary200
9/SDF/SQLTOPSQL Monitor: Top Statements12HASHHash Value (160 Bits)varbinary200
10/UIF/LREPDCONTLRep content table10HASHLRep hash string (40 characters)nvarchar400
11/UIF/LREPDCONTCDLRep content table - client-dependent11HASHLRep hash string (40 characters)nvarchar400
12/UIF/LREPDCONTULRep content table - user-dependent12HASHLRep hash string (40 characters)nvarchar400
13/XFT/STLCHEADxft StorageLink: Headertabelle für Komponenten Infos2HASHxft StorageLink: 2-stelliges Hashfeldnvarchar20
14/XFT/STLHEADxft StorageLink: Header Tabelle2HASHxft StorageLink: 2-stelliges Hashfeldnvarchar20
15/XFT/STLSDBCONTxft StorageLink: Ablagetabelle für Storage in DB2HASHxft StorageLink: 2-stelliges Hashfeldnvarchar20
16CNV_20100_GRIXBackup copy - GRIX_SEL for relevant org.units3HASHnvarchar150
17DFKKSAFTINV_HSAF-T Source Document: Header17HASHPortugal: SAF-T Hashnvarchar2000
18FARR_D_PAOBJMAPProfitability segment hashing2HASHHash Value (160 Bits)nvarchar400
19FIEUD_FIDOC_HSAFT: FI Transaction Document Header28HASHSignature PT: Encryption Key Versionnvarchar30
20FIEUD_SBINV_HSAFT: Self Billing Invoices (Header)- (MM)23HASHSAFT_PT: Signature Associated with Invoicenvarchar2000
21FIEUD_SDINV_HSAFT: Invoices from SD module(Header)21HASHSAFT_PT: Signature Associated with Invoicenvarchar2000
22LXE_PP_TEXTProposal Pool Texts2HASHProposal Pool Hash (MD5)varbinary160
23RODPS_HANA_ADMINSAP HANA ODP Administrative Data8HASHBinary Hash Valuevarbinary200
24SRAL_CONFIG_RTRead Access Logging: Configurations3HASHHash Value (160 Bits)nvarchar400
25SRTCM_SNAPSHOT_FSnapshot: Mapping from Fragment to Hash3HASHnvarchar160
26_sapdbctrl_mss_0_2hashntext10737418230
TOPABAP Authorization and Role Management
27USOB_AUTHVALTRCAuthorization Trace Result: Objects and Values4HASHHash Value (160 Bits)nvarchar400
TOPBusiness Planning and Simulation
28UPC_GREPCATDirectory of Generated Reports (Plan. Func. & Plan. Process5HASHCharacter field, length 32nvarchar320
29UPS_HASHConnection Hierarchy Key/Hash3HASHOrg. Value for Status and Tracking Systemnvarchar320
30UPX_STATUS_DATAUPX: Status of the LaunchPad Item2HASHUPX: MD5 Hashnvarchar320
TOPBusiness Process Engine
31SWFXIDISPATCHBPM: Buffer for Inbound Messages15HASHHash Value (160 Bits)nvarchar400
TOPCollectionsDisbursements
32TKKV_VZK_DATAData Table Additional Account Assignment for Insurance3HASHHash Code for Additional Account Assignment for Insurancenvarchar120
TOPCross-Application Components
33/IXOS/AX_TDELTAtable for update and delta management10HASHMD5 hashnvarchar320
34/IXOS/AX_TDELTALtable for update and delta management11HASHMD5 hashnvarchar320
TOPEnd User Technology
35RSRD_HASH_CNTFrequency of Use of Broadcast Targets2HASHSinge Hash Valuenvarchar400
TOPGenerating, Monitoring for Mass Data Archiving Solutions
36TADWP005Advanced Efficiency Service - Tag Service1HASH16 byte GUIDvarbinary160
TOPGermany
37T5D4X_ZERTRCertificate Request - Admin. Contrib. Statmt Certificates50HASHText length 32nvarchar320
TOPInformation System
38GREPReport Writer: File of Stored Reports3HASHHash encryption of selection criterianvarchar150
39GREP_VARCHARReport Writer: Varied extract characteristics2HASHHash encryption of selection criterianvarchar150
40GRIXReport Writer: Directory of Stored Data5HASHHash encryption of selection criterianvarchar150
41GRIX_SELReport Writer: Selection parameters for stored data2HASHHash encryption of selection criterianvarchar150
42GRIX_TXTReport Writer: Texts for stored data3HASHHash encryption of selection criterianvarchar150
43GRIX_VARPVariation parameters for extracts (Report Writer)5HASHHash encryption of selection criterianvarchar150
TOPInvoicing
44DBEOSBIS-U On-Site Billing35HASHHash Codevarbinary160
TOPPlanning
45RSPLS_REPCATDirectory of Generated Reports2HASHHash Value (160 Bits)nvarchar400
TOPRFC
46ARFCRSTATEStatus of ARFC Calls on Receiver Side18HASHHASH for tRFC/qRFCvarbinary400
47ARFCSSTATEDescription of ARFC Call Status (Send)18HASHHASH for tRFC/qRFCvarbinary400
48TRFCQSTATEDescription of qRFC Call Conditions (Inbound Queue)18HASHHASH for tRFC/qRFCvarbinary400
TOPSAP Business Workflow
49SWFRCRLINSTCorrelation Runtime: Instances2HASHHash Value (160 Bits)nvarchar400
50SWN_TIMESTAMPSWF Notif: Time Stamp4HASHHash codenvarchar30
TOPSAP List Viewer
51LTCXGeneric store for extracts7HASHHashnvarchar200
52SALVTMSExpiration, batch3HASHHashnvarchar200
TOPTranslation Tools
53LXE_PC2_HSHash1HASHText Keynvarchar320
54TRM020Storage for Proposal Pool Texts <= 20 Characters2HASHHash key in Proposal Poolnvarchar200
55TRM040Storage for Proposal Pool Texts <= 40 Characters2HASHHash key in Proposal Poolnvarchar200
56TRM060Storage for Proposal Pool Texts <= 60 Characters)2HASHHash key in Proposal Poolnvarchar200
57TRM080Storage for Proposal Pool Texts <= 80 characters2HASHHash key in Proposal Poolnvarchar200
58TRM255Storage for Proposal Pool Texts <= 255 characters2HASHHash key in Proposal Poolnvarchar200
TOPUse Subcomponents
59SOIMAPSAPoffice: Mapping Table IMAP UID - API2 ID4HASHHash number of AP12 IDnvarchar120
TOPUser and Authorization Management
60LICENSE_HASHIndex Table to Allow Quicker Access to LICENSE_DATA1HASHHash Value of a License Keynvarchar320
TOPWeb Service and SOAP - ABAP
61SRT_CFG_SRV_ASGNAssignment of HTTP URL to Runtime Configuration Web Services2HASHHash Value (160 Bits)nvarchar400
62SRT_CFG_STS_ASGNSTS assignment of binding4HASHHash Value (160 Bits)nvarchar400
63SRT_CFG_VALUESGeneral Configuration Values3HASHHash Value (160 Bits)nvarchar400
64SRT_CFG_VAL_DIRGeneral Client-Wide SRT Configuration Values2HASHHash Value (160 Bits)nvarchar400
65SRT_LP_URL_ASGNAssignment logical ports to access URL application index2HASHHash Value (160 Bits)nvarchar400
66SRT_NAME_CACHESRT Name Cache6HASHHash Value (160 Bits)nvarchar400
67SRT_PX_MSG_ASGNAssignment of proxy and message to logical port3HASHHash Value (160 Bits)nvarchar400
TOPWeb Services Tool
68CRMD_BOL_TRACECRM BOL trace3HASHnvarchar320
69CRMD_BOL_TRACE_RFound relations from CRM BOL trace1HASHnvarchar320