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

45 columns | Print definition?ERP 6.0  | INDX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ALCCMCUSTVValue table for possible values of parameters2INDXAlert: node indexint100
2CNV_20551_TSTRU2Intransparent fields: Condition for structure description2INDXIndexnvarchar80
3CNV_20551_TSTRUCIntransparent fields: Structure description2INDXIndexnvarchar80
4CNV_INTR_FLD_STPIntransparent fields: Condition for structure description2INDXIndexnvarchar80
5CNV_INTR_FLD_STRIntransparent fields: Structure description2INDXIndexnvarchar80
6FPM_ADAPT_SETAdaptation Sets2INDXint100
7T7UNPF_HR_EMAILEmail Information6INDXNumber of Infotype Record with Same Keynvarchar30
8T7UNPF_HR_PHONEPhone Information6INDXNumber of Infotype Record with Same Keynvarchar30
9TBVZCO-PA report library (no longer used)4INDXIndicator: Data stored in cluster table COIXnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
10DBDCDEPTBDD: Persisting of Dependencies Between DD Objects3INDXUnique Index ID in a Tablenvarchar30
11DBDCGENTBDD: Persisting Activating Ojects in Mass Activation3INDXUnique Index ID in a Tablenvarchar30
TOPActual Update and Commitment Update
12GTR_NOTIFY_TRIGTrigger table for Grantor ERP->CRM Notification7INDXGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220
TOPApplication-Specific Upgrade
13/ASU/STEPSASU Steps4INDXASU Step indexnvarchar60
14/ASU/STEPSTText table for ASU Steps4INDXASU Step indexnvarchar60
15/ASU/STEPST_VText table for ASU Steps (Version)3INDXASU Step indexnvarchar60
16/ASU/STEPS_VASU Steps (Version)3INDXASU Step indexnvarchar60
TOPBusiness Package for Manager Self-Service FI
17FCOM_KSTARCost Elements for Users6INDXint100
18FCOM_OBJECTObjects for Users6INDXint100
19FPB_EXP_CA_ITMExpress Planning: Elements of the Context Area (Obsolete)3INDXItem in a Group or Scenarionvarchar40
20FPB_EXP_CA_ITM1Express Planning: Elements of the Context Area5INDXItem in a Group or Scenarionvarchar40
21FPB_EXP_CUS_ITMExpress Planning: Customizing Elements, Inst, WA, CA1INDXItem in a Group or Scenarionvarchar40
22FPB_EXP_GRP_STPExpress Planning: Assignment of Substeps to Steps3INDXItem in a Group or Scenarionvarchar40
23FPB_EXP_ROLETASKExpress Planning: Persistence Objects for User Role10INDXItem in a Group or Scenarionvarchar40
24FPB_EXP_SCEN_GRPExpress Planning: Assignment of Steps to Scenarios3INDXItem in a Group or Scenarionvarchar40
25FPB_EXP_SECTExpress Planning: Context Area Sections4INDXItem in a Group or Scenarionvarchar40
TOPData Transfer Workbench
26DXMAPTable for Saving Conversion Proposal7INDXCounternvarchar40
27DXOBJTCODETable for Maintaining the Tcode for DX Objects2INDXCounternvarchar40
TOPEnd User Technology
28RSKPI_KPI_ATTRKPI: Attributes4INDXKPI Monitoring: Index for Multi-Value Attributesnvarchar40
29RSKPI_KPI_ATTRTKPI: Language-Dependent Attributes5INDXKPI Monitoring: Index for Multi-Value Attributesnvarchar40
30RSKPI_KPI_DASINKPI: Data Access Services Input Parameters5INDXKPI Monitoring: Index for Database Keysnvarchar40
31RSKPI_KPI_INVALKPI: Values for Input Parameters5INDXKPI Monitoring: Index for Database Keysnvarchar40
32RSKPI_KPI_THDKPI: Threshold Values3INDXKPI Monitoring: Index for Database Keysnvarchar40
33RSKPI_VNT_INVALKPI Variant: Input Parameter Values6INDXKPI Monitoring: Index for Database Keysnvarchar40
34RSKPI_VNT_THDKPI Variant: Threshold Values4INDXKPI Monitoring: Index for Database Keysnvarchar40
TOPMaster Data
35EPDPRODAIS-U Master Data Generator: Attribute5INDXCount parametersnvarchar40
TOPMedia Product
36JPTGENPROFILEParameter Valuation in Generation Profile3INDX5 Character Numeric NUMCnvarchar50
TOPPerformance Monitors TCC
37ORA_SAPKCBFWAITCopy of SAP$KCBFWAIT2INDXOracle monitors: ORA_INDXnvarchar320
TOPPlanning
38RSPLF_SRV_PParameter Value (Elementary Type)5INDXLine Indexint100
39RSPLF_SRV_PSParameter Value (Selection Type)5INDXLine Indexint100
TOPProfitability Analysis
40TKEB1Report Management19INDXIndicator: Data stored in cluster table COIXnvarchar10
TOPRecycling Administration Core Functions
41J_7LC40REA Info System: Recycling Partner-Spec. LIS Update6INDXRanking Sequencenvarchar20
42J_7LC51REA Data Filters: Access Sequences - Accesses4INDXRanking Sequencenvarchar20
43J_7LC64REA Data Filters: Access Sequence Doc. Flow Eval. - Paths4INDXRanking Sequencenvarchar20
44J_7LC65REA Data Filters: Accesses in Document Flow Evaluation Path4INDXRanking Sequencenvarchar20
TOPService Station Retailing
45OIRESPCRSSR PC: Splitting criteria4INDXSSR PC: Index / counternvarchar30