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

75 columns | Print definition?ERP 6.0  | IDX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UI2/NWBC_CFG_SOBSOLETE NetWeaver Business Client Configuration1IDX3-Byte fieldnvarchar30
2CVP_UNBLK_REQSTCustomer/Vendors unblocking requests6IDXKey index incrementalint100
3DITAT_D_PREDPhysical objects predecessors3IDXIntegerint100
4DITAT_D_TMCNTTransfer table for a (buildable) map's content3IDXIntegerint100
5INDEXDTSecurity price type - Text table3IDXSecurities Indexnvarchar100
6J_3RFREP_ADP_RETParameters Definition of XML Data Provider3IDXIndexestinyint30
7J_3RFREP_ADP_XXML Data Provider Parameters of Reporting Object3IDXIndexestinyint30
8SRT_REQ_D_CI_CONSRT: Business Scenario Consumer -> Contract Implementation4IDXNatural Numberint100
9SRT_REQ_D_CI_PROSRT: Business Scenario Provider -> Contract Implementation4IDXNatural Numberint100
TOPAP-LIM Logistics Inventory Management Engine
10/LIME/CUST_WIDTHAlternative Determination of Node Width3IDXCurrent Nummer of Key Tablenvarchar30
11/LIME/GEN_IDXCOLGeneration Information for LIME Index Tables3IDXCurrent Nummer of Key Tablenvarchar30
12/LIME/GEN_IDXTABGeneration Information for LIME Index Tables3IDXCurrent Nummer of Key Tablenvarchar30
13/LIME/LOG_TREELog Changes in Table /LIME/TREE12IDXCurrent Nummer of Key Tablenvarchar30
14/LIME/NLOG_TREELogging of Changes in Table /LIME/NTREE8IDXCurrent Nummer of Key Tablenvarchar30
15/LIME/NTREELIME - Tree Structure5IDXCurrent Nummer of Key Tablenvarchar30
16/LIME/TREELIME - Tree Structure7IDXCurrent Nummer of Key Tablenvarchar30
TOPAuthentication and SSO
17SAML2_ENT_SRVCSAML2 Service Definition for Each Entity4IDXSAML2 Index Valuesmallint50
TOPBudgeting
18FMORGFAVBCS : Organizer Favorites3IDXnvarchar50
TOPClinical System
19N2RADMPPS_RADIS-H*MED RAD: MPPS Radiation Attribute4IDXRAD: MPPS Counternvarchar20
20N2RADMPPS_TAGIS-H*MED RAD: MPPS Attribute4IDXRAD: MPPS Counternvarchar20
TOPCross-Application Components
21CCMSBI_MTEMAP_SSelection Conditions for MTEs with Names That Are Converted2IDXNatural Numberint100
22MSR_SELECTMSR: Selection Range Entries for Import Parameters5IDXnvarchar20
TOPFinancial Supply Chain Management
23BNK_STSRP_CNTControl table2IDXnvarchar50
TOPGateway Business Eventing and Provisioning
24/IWBEP/D_SUBS_FLSubscription Filter Criteria3IDXtinyint30
TOPliveCache Applications
25/SAPAPO/OMTSANCGAnchor Table for DP Master Data (Time Bucket) vs. LC Objects3IDXtinyint30
TOPMarket Risk Analyzer
26ATVO64Volatilities - Mapping from Security Indexes2IDXSecurities Indexnvarchar100
27FTBB_MDG_VAR_IDXTable for Saving Start Parameters for Indexes4IDXSecurities Indexnvarchar100
28VTVSZIDXScenario Database: Stock Indices3IDXSecurities Indexnvarchar100
29VTVSZIDXVOScenario Database: Index Volatilities3IDXSecurities Indexnvarchar100
TOPMonitoring
30ALPFREP_DATTable for PerfDB Report Data2IDXNatural Numberint100
31CPH_TRACETable for CPH Log Information4IDXNatural Numberint100
TOPNetweaver Business Client
32NWBC_CFGNetWeaver Business Client Configuration2IDXnvarchar30
33NWBC_CFG_SAPNetWeaver Business Client Configuration1IDXnvarchar30
TOPPortfolio Analyzer
34BMA_GUIDIDXOLD <<Boundary>> CFM-BM: Assignment of BMGUID Index3IDXSecurities Indexnvarchar100
TOPProcess Management
35CMX_XS_DB_HRELXSteps: Links to Historical Objects (Relationships)3IDXXSteps: Item Counter in Object Listsnvarchar40
36CMX_XS_DB_NRELXSteps: Links to Non-Historic Objects (Relationships)3IDXXSteps: Item Counter in Object Listsnvarchar40
37CMX_XS_DB_PREDXSteps: Predecessor3IDXXSteps: Item Counter in Object Listsnvarchar40
38CMX_XS_DB_PREXXSteps: Predecessor before the Generation3IDXXSteps: Item Counter in Object Listsnvarchar40
TOPProvisions for Awards
39ACE_SOP_INDTYPEType of Index Used for Award Program4IDXSecurities Indexnvarchar100
40ACE_SOP_SCRT_INDHypothetical Index Performance for Simulation3IDXSecurities Indexnvarchar100
TOPRecords and Case Management
41RMPSPRO_FOLDHISTHistory Table for Used Folder4IDX2 byte integer (signed)smallint50
TOPRisk Analysis
42JBRDBKOETRM: DB Table Header, HIERA and BEST Extended Cat.Prim.Trans.27IDXSecurities Indexnvarchar100
43JBRHKOETRM: Version Table Header, HIERA and BEST Ext.Cat.Prim.Trans.28IDXSecurities Indexnvarchar100
44JBRSVKOETRM: Header Table of Cat. of Prim. Trans for Saved Datasets26IDXSecurities Indexnvarchar100
45JBRSVMSEGRM: Val. Parameters of Cat.of Prim. Trans.for Saved Datasets80IDXSecurities Indexnvarchar100
TOPSAP Business Workflow
46SWELCFSelection Criteria for Selective Logging3IDXNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPSAP List Viewer
47SALVTMSExpiration, batch5IDXNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPSAP Records Management
48SRMORGFAVBC-RM: Organizer Favorites3IDXnvarchar50
49SRMORGHISSRM Organizer : Worklist4IDXsmallint50
50SRMORGRL2BC-RM : Roles (new)5IDXnvarchar50
51SRMORGRL2TText Table: View Elements6IDXnvarchar50
TOPService Implementation Workbench
52TSIW_LRULeast recently used projects2IDXNatural Numberint100
TOPSyntax, Compiler, Runtime
53DEMO_LOB_TABLETable with BLOBS and CLOBS1IDXint100
TOPTransaction Manager
54VWPANINAssign Security Class to Security Index3IDXSecurities Indexnvarchar100
TOPTranslation Tools
55LXE_TAMO_ABORTTable to Deactivate Hard Termination After TAMO Errors1IDXnvarchar10
TOPTreasury
56ATXVOSecurity Index Volatilities3IDXSecurities Indexnvarchar100
57INDEXDIndex definition (security index)2IDXSecurities Indexnvarchar100
58INDEXWIndex Values (Secur. Index)2IDXSecurities Indexnvarchar100
59MDUIRMarket Data: Assign New Key for Index Name4IDXSecurities Indexnvarchar100
TOPTreasury and Risk Management
60INDEXZAllocations for datafeed2IDXSecurities Indexnvarchar100
TOPUse Subcomponents
61SODSATSAPoffice: User-friendly LDAP attribute names2IDXSequence number for LDAP attribute namesnvarchar100
TOPWeb Service and SOAP - ABAP
62SRT_CFG_CFGVALSOAP Runtime Framework: Configuration Values4IDXint100
63SRT_DEST_CFGVSOAP Runtime Framework: Destination Configuration Values4IDXint100
64SRT_FW_SETTINGSSRT Framework Settings3IDXint100
65SRT_PRF_CFGVALSOAP Runtime Framework: Configuration Values4IDXint100
66SRT_RTC_CFGVALSOAP Runtime Framework: Configuration Values3IDXint100
67SRT_RTC_CG_DATASOAP Runtime Cache: CG Data9IDXNatural Numberint100
68SRT_RTC_CG_DATALSOAP Runtime Cache: CG Data9IDXNatural Numberint100
69SRT_SYS_SETTINGSSRT System Settings2IDXint100
70SRT_TMP_CG_DATASOAP Runtime Cache: CG Data8IDXNatural Numberint100
71SRT_TMP_CG_DATALSOAP Runtime Cache: CG Data8IDXNatural Numberint100
TOPWithout Description
72CCMSBICFGSTEPSCCMSBI Setup: Configuration Steps4IDXCounternvarchar100
73CCMSBICONFRepository for Configuration Data6IDXCounternvarchar100
74CCMSBICONFTYPESConfiguration Types2IDXCounternvarchar100
75CCMSBIPROTCCMSBISETUP Status and Log Table5IDXNatural Numberint100