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

144 columns | Print definition?ERP 6.0  | USERA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/C1_DBSTGDashboard Analytics staged data8USERAUser namenvarchar120
2/NAKISA/C2_IMPDashboard analytics import parameters temporary table8USERAUser namenvarchar120
3/XLSO/FAVORITESFavorites8USERAUser namenvarchar120
4BBPD_DATA_CACHEBBP: Cluster Table for Cache7USERAUser namenvarchar120
5BBP_AGENT_TEMPTemporary Storage of Search Results (INDX Structure)8USERAUser namenvarchar120
6CNVCMIS_A_30_SELCMIS table to store export and Import data8USERAUser namenvarchar120
7CNVC_NR_CLUSTERSystem table for storing NR analysis data6USERAUser namenvarchar120
8CNV_10993_PDFCLUTable for PDF strings8USERAUser namenvarchar120
9INDXNClike INDX, w/o CLIENT7USERABenutzernamenvarchar120
10J_1I_INDXIndia System Table INDX for Octroi in PO8USERAUser namenvarchar120
11SCI_INDX_COPYSystem Table INDX8USERAUser namenvarchar120
12SHDB_CLUSTERINDX type cluster table for access via cl_lib_cluster8USERABenutzernamenvarchar120
13ZLCRT_INDXAI LCR: Buffer Table9USERAUser namenvarchar120
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
14PROC_VERSIONSSystem Table INDX8USERAUser namenvarchar120
TOPAccounting - General
15TCC_INDXClosing Cockpit: System Table INDX8USERAUser namenvarchar120
TOPActual CostingMaterial Ledger
16CKML_INDX_RUNSystem table INDX6USERAUser namenvarchar120
TOPAdditional Material Functions
17WSD_INDXSystem Table INDX9USERAUser namenvarchar120
TOPAddress ManagementBusiness Address
18ADQUINDXINDX-type table for quarterly adjustment addresses8USERAUser namenvarchar120
TOPAvailability Check
19ATP_INDXATP_INDX8USERAUser namenvarchar120
TOPBalanced Scorecard
20UMB_MC104Scorecard: Graphic - BLOBs (Obsolete from SEM 3.5)8USERAUser namenvarchar120
21UMB_SC144Scorecard: BLOB for Cause-Effect Chain (OBSOLETE)8USERAUser namenvarchar120
TOPBank Customer Accounts
22BKKINDXBCA: Cluster Table5USERAUser namenvarchar120
TOPBasic Functions
23EMMA_JOBRUNIDMSGMonitoring Mass Run: Buffer for Messages (INDX)8USERAUser namenvarchar120
24RFRRAccounting data - A/R and A/P information system9USERAUser namenvarchar120
TOPBasis Components
25/XFT/GEN_REP_VARVariants for Generic Reporting7USERAUser namenvarchar120
26/XFT/INV_Q_8Text sample5USERAUser namenvarchar120
27/XFT/INV_Q_8_SText sample5USERAUser namenvarchar120
28/XFT/INV_TEXTTText templates invoice receipt log7USERAUser namenvarchar120
TOPBatch-Oriented Parallel Processing of Mass Data
29BANK_PP_SRV_PCKAssignment Server -> Package Area8USERAUser namenvarchar120
TOPBusiness Accounting
30UREXECTRCTrace Option for Realignment Runs10USERAUser namenvarchar120
TOPBusiness Analytics
31UABSURINDXSystem Table INDX8USERAUser namenvarchar120
TOPBusiness Context Viewer
32/BCV/D_INDXINDX table for shared memory8USERAUser namenvarchar120
TOPBusiness Planning
33UPB_CMI_110Graphic - BLOBs8USERAUser namenvarchar120
TOPBusiness Process Engine
34SWFDXMPINDXXML Message Proxy: INDX table7USERAUser namenvarchar120
TOPClaims Management
35TICL105Storage of Picture Files in Data Clusters (see INDX)8USERAUser namenvarchar120
TOPClasses
36CLBUFCluster Table for Classes and Variants8USERAUser namenvarchar120
TOPClinical System
37N2TRANSPORTBCSETIS-H*MED: Structured Cluster Table for N2TRANSPORT7USERAUser namenvarchar120
38N2TRANSPORTCLUSTIS-H*MED: Cluster Structure for N2TRANSPORT7USERAUser namenvarchar120
TOPCollectionsDisbursements
39CDTESTDATACluster Table for Correspondence Data7USERAUser namenvarchar120
TOPCondition
40BKK9CAcct Balancing (Interest and Charges) Enhancement to BKK929USERAUser namenvarchar120
TOPConstruction Equipment Management
41/SAPCEM/INDXStorage for CEM Similar to INDX Table (Note 3992)8USERAUser namenvarchar120
TOPContract Accounts Receivable and Payable
42DFKKDTAccounting Data (INDX Structure)6USERAUser namenvarchar120
43DFKKUMBINDXCluster for Variant Storage in Transaction FPU28USERAUser namenvarchar120
TOPCorporate Performance Monitor
44UMC_STD_BLOBSStandard - Graphic - BLOBs (Obsolete from SEM 3.5)8USERAUser namenvarchar120
45UMR_RI130OBSOLETE RMS: Graphic - BLOBs8USERAUser namenvarchar120
46UMV_TR122Value Driver Tree: Graphic - BLOBs (Obsolete from SEM 3.5)8USERAUser namenvarchar120
TOPCorrespondence Tool
47DFKKCORRRFDTCluster Table for Correspondence Data8USERAUser namenvarchar120
TOPCross-Application Components
48/IXOS/DCRSA_OUTSystem table INDX8USERAUser namenvarchar120
49/IXOS/DC_TAVINDXVariant INDX table for data cluster.9USERAUser namenvarchar120
50/IXOS/RS_T_CLUSTSystem table INDX8USERAUser namenvarchar120
TOPCross-Application Mass Maintenance
51MASSVARDATData for Variants8USERAUser namenvarchar120
52MASSVARIANTVariants: Basic Information6USERAUser Namenvarchar120
53MASSVARIANT_SSystem Variants: Basic Information5USERAUser Namenvarchar120
54MASSVARTRMass Maintenance Variants in Transportable Form18USERAUser namenvarchar120
TOPData Conversion
55DMC_PROTDMC: Logs and Tables for Backwards Navigation8USERAUser namenvarchar120
TOPDB-Independent Database Interface
56SQLT_INDXSystem table INDX (shared buffer) for ST05 initial screen7USERAUser namenvarchar120
TOPDefault Risk and Limit System
57KLCLUSTCluster for Distributed Data Use6USERAUser namenvarchar120
58KLCLUSTERCluster for Distributed Data Use6USERAUser namenvarchar120
TOPEnvironment, Health and Safety
59/TDAG/CPC_TCATCP: Definition of Task Categories4USERAUser Name in User Master Recordnvarchar120
60/TDAG/CPC_TCUSRObsolete: CP: Link User to Task Categories3USERAUser Name in User Master Recordnvarchar120
61/TDAG/CPT_TASKHHeader data for tasks13USERATask Processornvarchar120
62/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv13USERATask Processornvarchar120
63/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten9USERAAssigned Usernvarchar160
64/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv9USERAAssigned Usernvarchar160
TOPFinancial Accounting
65RFDTAccounting Data (INDX Structure)8USERAUser namenvarchar120
TOPFinancial Supply Chain Management
66TBNK_RULE_SELOPRule select options14USERAUser namenvarchar120
TOPFinancials Basis
67UBC_CL_BIBatch Input Sessions (INDX-Structure)8USERAUser namenvarchar120
68UBC_CL_INVBill Data (INDX-Structure)8USERAUser namenvarchar120
TOPFramework for the Principle of Dual Control
69TBCA_RELPROC_EXPCustomizing Release Procedure14USERAUser namenvarchar120
TOPFund Accounting
70FMCCAVC_PRLCluster table for different purposes8USERAUser namenvarchar120
TOPFunds Management
71FMFGRCN_SAVSaved reconciliation report results8USERAUser namenvarchar120
TOPGeneral Application Functions
72TABADRXSystem Table INDX8USERAUser namenvarchar120
TOPImplementation Guide
73INDXBCSETINDX-Type Table to Save Check Results4USERAUser namenvarchar120
74TVARINDSave screen variants7USERAUser namenvarchar120
75VORINDXProcedure model data buffer7USERAUser namenvarchar120
TOPIncentive and Commission Management ICM
76CACS_OAINDXFOA: Storage of Structured Data8USERAUser namenvarchar120
77CACS_TGMEMTarget Agreements: Table for Shared Memory (Internal)8USERAUser namenvarchar120
78CACS_TXTCLSTICM: Cluster Table for Text Strings8USERAUser namenvarchar120
TOPInformation System
79PSINFO_INDXSystem Table INDEX: Project Information System8USERAUser namenvarchar120
TOPIntegrated Product and Process Engineering
80CPPE_CULLINDXSystem Table INDX8USERAUser namenvarchar120
81PPEXPL_RTO_INDXSystem table INDX8USERAUser namenvarchar120
TOPIntegration of Catalogs, Partner Directories OCI, OPI
82WSI_OCI_BGSEARCHTemporary Storage of Search Results (INDX Structure)8USERAUser namenvarchar120
TOPInventory Accounting
83UAIDETAILDATATrace Option for Realignment Runs8USERAUser namenvarchar120
TOPliveCache Applications
84/SAPAPO/OMTSINDXSystem Table INDX for SAPTS Test Framework8USERAUser namenvarchar120
TOPLocalization
85J_1BEFD_INDXJ_1BEFD_INDX - Serialization of the obj. in Ato Cotepe 828USERAUser namenvarchar120
TOPLogical Database Builder
86RSDSQOBJSelection views7USERAUser namenvarchar120
TOPLogistics - General
87ECP_KEY_INDXE&C portal: Index Table for E&C Portal5USERAUser namenvarchar120
TOPLogistics Basic Data
88DMF_D_LOGapplication log table for DMF RFC content7USERAUser namenvarchar120
TOPLogistics Information System LIS
89MCEXHASHLO Extraction - Memory Tabele for Hash Values8USERAUser namenvarchar120
TOPManagement Cockpit
90UMM_FR106Frames : Graphic - BLOB (Obsolete from SEM 3.5)8USERAUser namenvarchar120
TOPMarket Risk Analyzer
91VTVCLUSTCluster for Distributed Data Use6USERAUser namenvarchar120
92VTVSVCARCXRM: Data Cluster for Index per Set7USERAUser namenvarchar120
TOPMobile Applications
93/ISDFPS/ME_INDXCluster Tables (INDX) for Temporary Storage8USERAUser namenvarchar120
TOPMonitoring
94CSMBK_CLClass Definitions in CCMS Repository11USERAUser namenvarchar120
95CSMBK_TKToken Definition in CCMS Repository12USERAUser namenvarchar120
96CSM_EXTVALExtended Keys for SCR Objects9USERAUser namenvarchar120
TOPNetWeaver Demonstration
97SNWD_EPM_INDXEPM: Table for EPM Data Snapshots8USERAUser Namenvarchar120
TOPOLAP Technology
98RSCDSSHMCLUSTTABTable for RSCDS SHM Cluster4USERAUser namenvarchar120
TOPOrganization and Planning
99INDX_ESSEmployee Self-Service (ESS) Settings8USERAUser namenvarchar120
TOPPeople Centric UI Framework
100CRM_BSP_SYSINDXSystem Table INDX8USERAUser namenvarchar120
TOPPersonal Object Worklist
101POWL_CHECK_LOGResults of consistency checks7USERAUser namenvarchar120
TOPPersonnel Time Management
102T552AMonthly Work Schedule10USERAUser Namenvarchar120
TOPProduction and Revenue Accounting
103OIUT2_CLUSTERSystem table INDX10USERAUser namenvarchar120
TOPProfitability Analysis
104TKEDRXSystem Table INDX8USERAUser namenvarchar120
TOPProject Planning Board
105PSPPT_INDXSystem table INDX8USERAUser namenvarchar120
TOPProject System
106PLM_PS_INDXSystem table INDX8USERAUser namenvarchar120
TOPProxy Generation
107SPROXINDXSystem Table INDX8USERAUser namenvarchar120
TOPRetail Information System RIS
108MCWPSFile for storing results of function group MCWPS13USERAUser namenvarchar120
TOPReuse Services for Country Development
109T7TW10System table for VB Up/download5USERAUser namenvarchar120
TOPRevenue
110OIUH_REP_HISTReporting History old Razorfish8USERAUser namenvarchar120
TOPRFC
111QUEUESTATE_INDXINDX Table for qRFC Data7USERAUser namenvarchar120
TOPRisk Analysis
112AMORTCLUSTCluster for Distributed Data Usage in ALM: P+L Results6USERAUser namenvarchar120
113GAPCLUSTCluster for Distributed Data Use6USERAUser namenvarchar120
TOPRoyalty Reporting
114OIUREP_REG_HISTReporting history (System table INDX)8USERAUser namenvarchar120
TOPRuntime Analysis
115SATR_TABABAP Traces (INDX)8USERAUser namenvarchar120
TOPSAP Business Workflow
116SWFSLSINDXDeadline Service: Index Table for Temporary Data6USERAUser namenvarchar120
117SWWINDXObsolete 6.1/ INDX Table for SWW Internal Runtime Constructs8USERAUser namenvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
118ISH_IDX_LOGGINGIndex Table for Logging Communication Data8USERAUser namenvarchar120
TOPSAP Query
119AGDBABAP/4 Generation Tool: Pattern database8USERAUser namenvarchar120
120AQDBSAP Query: Tables and Data8USERAUser namenvarchar120
121TAQTSSAP Query: Transprt of Queries, Functn. Areas and User Grps7USERAUser namenvarchar120
TOPSAP Records Management
122SRM_INDX1Table for Queue Elements20USERAUser namenvarchar120
123SRM_INDX2Table for Report Profiles7USERAUser namenvarchar120
124SRM_INDX3Table for Deleted Queue Elements20USERAUser namenvarchar120
125SRM_INDX4Table for Search Variants7USERAUser namenvarchar120
TOPSAP Utilities
126ESMON_MARUNIDMSGMonitoring Mass Run: Buffer for Messages (INDX)8USERAUser namenvarchar120
TOPSCM Basis
127CIF_LAYPREF_INDXCluster Table for Storing Layout Settings5USERAUser namenvarchar120
128CIF_PREF_INDXCluster Table for Storing User Settings5USERAUser namenvarchar120
TOPService Station Retailing
129OIRC_PASSFuels pricing pass prices export table8USERAUser namenvarchar120
TOPSets
130SETSSets - Contents (before Release 2.2)8USERAUser namenvarchar120
TOPSyntax, Compiler, Runtime
131INDXSystem Table INDX8USERAUser namenvarchar120
132TPDAINDXTPDA: Cluster für den neuen Debugger8USERABenutzernamenvarchar120
133VER_SEC_INDXData-Cluster8USERABenutzernamenvarchar120
TOPSystem Landscape DirectoryComponent Repository
134LCRT_INDXAI LCR: Buffer Table8USERAUser namenvarchar120
TOPTag Library
135CRMD_UIF_SYSINDXSystem Table INDX for CRM UI Framework8USERAUser namenvarchar120
TOPTerminologyGlossary
136GLOSSARYGlossary Table7USERAUser namenvarchar120
137STERM_INDXINDX-Style Tables for Saving Possible Entry Tables7USERAUser namenvarchar120
138TERMTerminology Table7USERAUser namenvarchar120
TOPTraders and Schedulers Workbench
139OIJ02_DS_INDXSystem Table INDX8USERAUser namenvarchar120
TOPTransaction Manager
140GTHMEXINDXTHMEX cluster table5USERAUser namenvarchar120
TOPUI Framework Service Provider Infrastructure
141/PLMB/FRW_BUFFERFramework buffer10USERAUser namenvarchar120
TOPUpstream Graphics
142OIUGT_BASECONFIGUpstream Graphics Base Configuration7USERAUser namenvarchar120
143OIUGT_INDXUpstream Graphics INDX Table8USERAUser namenvarchar120
TOPWeb Service and SOAP - ABAP
144SRT_WSIL_TMPWSIL Buffer Table9USERAUser namenvarchar120