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

68 columns | Print definition?ERP 6.0  | PARAM_VALUE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOFU/C_TXC_PVParameter Name and Value : Database Table4PARAM_VALUEParameter Value Definitionnvarchar300
2/CIDCAD/CP_PARAMCideon Parameter Copy and Replace3PARAM_VALUEGeneral Flagnvarchar10
3/FLDQ/AD_CFGPRMSMaintain Operating parameters3PARAM_VALUEParameter Valuenvarchar800
4/FLDQ/INT_STATEStrack state of rsadrini options2PARAM_VALUETrue/Falsenvarchar10
5/PLMB/CGOS_PARAMAdditional Settings for PLM Objects4PARAM_VALUEParameter Valuenvarchar1320
6/SDF/CMO_TR_CONFConfiguration Parameters for Transport Check Report3PARAM_VALUEGeneral Flagnvarchar10
7/SLOAP/WORD_COLMDisplay number of columns for table in word output2PARAM_VALUENatural Numberint100
8/SLOAP/WRD_COLUMDisplay number of columns for table in word output2PARAM_VALUENatural Numberint100
9/SYCLO/AP001Syclo Integration Framework Runtime Settings5PARAM_VALUESyclo generic parameter valuenvarchar1000
10/SYCLO/AP002Runtime overwrite for mobile app param, globals6PARAM_VALUESyclo generic parameter valuenvarchar1000
11/SYCLO/CA000PMobile application - parameters5PARAM_VALUESyclo generic parameter valuenvarchar1000
12/SYCLO/STG03Syclo cluster data cache storage - supplement parameters5PARAM_VALUESyclo generic parameter valuenvarchar1000
13BTP_SGI_CBPBTP Sap-GUI Call-Back Parameters3PARAM_VALUEBTP Call-Back Parameter Valuenvarchar750
14CNV_00001_PARSParameters of form routines used in conversion7PARAM_VALUEConversion: Value of a parameter for a conversion routinenvarchar400
15CNV_MBT_ME_CNSTRTable for constraints of the Mapping Engine5PARAM_VALUEValue of a parameter in a constraint of the MEnvarchar500
16DMC_CONFIGPARAMSStorage for Parameters Depending on an Organisational Unit4PARAM_VALUEDMC: Value of a Parameternvarchar2550
17DMC_RT_PARAMSDMC: Storage for Parameters to be Used at Runtime2PARAM_VALUEDMC: Value of a Runtime Parameternvarchar400
18DMC_RT_VALUESDMC: Storage for temporary Parameters and Values3PARAM_VALUEDMC: Value of a Runtime Parameternvarchar400
19DOUI_USR_SESSIONDBOS Cockpit: User Session Settings4PARAM_VALUEDBOSC-CR: Long Identifiernvarchar2550
20DSHCONFIGSearch Help Configuration Parameter2PARAM_VALUESearch Help Configuration: Valuenvarchar5000
21FAGL_SETTINGSNew General Ledger: Technical Tax Data3PARAM_VALUENew General Ledger: Parameter Valuenvarchar400
22GRACCONFIGSETConfiguration Description4PARAM_VALUEConfiguration Value Setnvarchar1000
23HRSFI_C_PARAMSParameters4PARAM_VALUEParameter Valuenvarchar1280
24HRSFI_RCT_PARAMSParameters4PARAM_VALUEParameter Valuenvarchar2550
25IUUC_REPL_CONPARConnection parameters -> linked to iuuc_repl_hdr4PARAM_VALUEconnection parameter valuenvarchar1280
26IUUC_TABNAME_DRBTables for specific delete / rollback handling2PARAM_VALUEnvarchar400
27SMI_PARAMSSocial Intelligence Parameters3PARAM_VALUEParameter Valuenvarchar100
28T77PAOPARAMSParameters4PARAM_VALUEParameter Valuenvarchar1280
29T7PIQRLCOND_DEFAssign Conditions to Subrequirements6PARAM_VALUEParameter Valuenvarchar400
30T7PIQRLFILTERAssign Filters to Subrequirements6PARAM_VALUEParameter Valuenvarchar400
31T7PIQ_SI2_INDXPAParameter/Academic Performance Index Assignments5PARAM_VALUEParameter Valuenvarchar400
TOPAP-LIM Logistics Inventory Management Engine
32/LIME/PN_ITEM_TB/LIME/DOC Collective Table of Param, Quant, Serial No, ACC9PARAM_VALUEParameter Valuenvarchar2550
TOPApplication Frame
33WCFC_ALT_NAV_LDPAlternative Navbar Loader Profile Parameters4PARAM_VALUEAlternative Navigation Bar Loader Parameter Valuenvarchar2550
TOPAuto-ID Infrastructure
34/AIN/TACT_PARVALRule activity parameter values6PARAM_VALUEActivity Parameter Valuenvarchar500
TOPBRFplus - ABAP-Based Business Rules
35FDT_WD_PARAMSFDT WD: User Configuration parameters table5PARAM_VALUEConfig parameter valuenvarchar2560
TOPBusiness Consolidation
36UCSWDGCUSTCustomizing - CL_UC_WATCHDOG3PARAM_VALUEText, 255 Charactersnvarchar2550
TOPBusiness Package for Manager Self-Service FI
37FPB_EXP_SETTINGSExpress Planning Customizing: General Settings3PARAM_VALUEText, 255 Charactersnvarchar2550
38FPB_SETTINGSFPB: Control Table for Possible Tuning Parameters3PARAM_VALUECharacter field of length 40nvarchar400
TOPCondition Technique
39/SAPCND/CONFIGConstant Strings for Condition Technique2PARAM_VALUEValue of Global Parameters for Condition Techniquenvarchar500
40/SAPCND/CONFIGCCClient-Specific Configuration Parameters for Customers3PARAM_VALUEValue of Global Parameters for Condition Techniquenvarchar500
TOPCross-Application Components
41CCMSBI_DSR_CONFConfiguration Data for BI Connection for DSR10PARAM_VALUECCMSBI: Konfiguration Data Valuenvarchar450
42CCMSBI_WAST_CONFConfiguration Data for BI Connection of Statistic Data7PARAM_VALUECCMSBI: Konfiguration Data Valuenvarchar450
43ETP_SETTINGSEasy Task Planning: Control Table3PARAM_VALUECharacter field of length 40nvarchar400
TOPData Mining
44RSDMTPN_CONN_PARDatamining Connection Parameters - Name - Value4PARAM_VALUEValue of a Data Mining Vendor specific connection parameternvarchar400
TOPDatabase Interface, Database Platforms
45DBA_DBH_COLL_OPTDBA-DBH: Collector Options6PARAM_VALUEnvarchar2550
46DBA_DBH_TPL_OPTDBA-DBH: Collector Template Options8PARAM_VALUEnvarchar2550
TOPDocument Management System
47DMS_USER_DEF01DMS: User-Specific Settings7PARAM_VALUEOriginal of documentnvarchar2550
TOPFrance
48T77TNM_S0TNM settings table3PARAM_VALUEParameter valuenvarchar320
TOPGeneral
49LWMHR_C_PARAMSParameters4PARAM_VALUEParameter Valuenvarchar1280
TOPGeographical Information System
50GEOPROC_PARAMSGeo Processing Paramters5PARAM_VALUEParam Valuenvarchar2550
TOPGRC Access Control Plug-In
51/GRCPI/GRIA_CONConfiguration Description4PARAM_VALUEParam Valuenvarchar400
TOPIndustry Solution Oil
52TOI0_ADMINGeneral setting (value/parameter setting)4PARAM_VALUEParameter Valuenvarchar300
TOPIndustry-Specific Component Automotive
53OMCONFITable with Configuration Data for COM Objects4PARAM_VALUEValue of Configuration Parameter of COM Routinesint100
TOPInformation System
54FTI_PARAMETERSControl Parameters3PARAM_VALUEControl Parameter Valuenvarchar200
TOPInformation System, iViews
55BWOM_SETTINGSBW CO-OM: Control Data4PARAM_VALUECharacter field of length 40nvarchar400
TOPIntegration of FPM and Persistency Frameworks like BOPF
56/BOFU/IFBIV_APView: Action parameters5PARAM_VALUEParameter Valuenvarchar1000
57/BOFU/IPBIPOWLAPPOWL: Action Parameter Definition5PARAM_VALUEParameter Valuenvarchar1000
TOPliveCache Applications
58/SAPAPO/OM_CONFITable with Configuration Data for APO COM Objects4PARAM_VALUEValue of a COM Routine Configuration Parameterint100
59LCA_CONFITable with Configuration Data for LCA Objects4PARAM_VALUEValue of a Configuration Parameter of the LCA Routinesint100
TOPLoans Management
60VDCHK_PARAMTable for Global Parameters6PARAM_VALUECharacter field, 8 characters longnvarchar80
TOPNetWeaver Demonstration
61SNWD_DG_PARAMSEXM: Data Generator Parameters5PARAM_VALUEntext10737418230
TOPPlanning
62RSPLS_PM_PARAMSPlanning Modeler: Parameters4PARAM_VALUEParameter: Valuenvarchar2550
TOPRevenue
63OIUH_SORT_PARAMOil & Gaz - Program Parameters by Jil Steps8PARAM_VALUECharacter 1200nvarchar12000
TOPSAP Business Workflow
64SWN_FILTVALWF Notif: Filter Values6PARAM_VALUEFilter Parameter Valuenvarchar2550
65SWN_SUBSVALWF Notif: Subscription Values9PARAM_VALUESubscription Parameter Valuenvarchar2550
TOPSet Types and Attributes
66COMS_SETTYPE_CONParameter Table - Generation of Set Types and Attributes3PARAM_VALUEParameter Valuenvarchar640
TOPTalent Management
67T77TMCPARAMSParameters4PARAM_VALUEParameter Valuenvarchar1280
TOPWorkforce Management Application
68WFAFC_GEN_CUSTCustomizing settings for above store level adjustments3PARAM_VALUE128 characternvarchar1280