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

109 columns | Print definition?ERP 6.0  | ENABLED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/HNA_DQENGEnable/Disable DQ Engine within HANA configurations2ENABLEDGeneral Flagnvarchar10
2/IWFND/I_MED_OPoperation entity for meta model7ENABLEDOperation enabled flagnvarchar10
3/KORA/MODTXT_Tkr: pool of graphic enabled functions4ENABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
4/OTEI/T_A_LOG_COConfiguration table for activity log3ENABLEDGeneral flagnvarchar10
5/OTEI/T_A_LOG_CUTable for activity logging configuration5ENABLEDActivity enabled for loggingnvarchar10
6/SAPSRM/C_MDFSBMeta Data Configuration for Set Fields9ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
7/SAPSRM/C_MDFSBBBO specific Restriction of Set Field Metadata8ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
8/SAPSRM/C_MDFSBCCustomer Table for Configuration of Set Field Metadata9ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
9/SAPSRM/C_MDFSBLLook-Up Table BO specific Restriction of Set Field Metadata9ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
10/SAPSRM/C_MDFSDMeta Data Configuration for Dependant object Fields7ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
11/SAPSRM/C_MDFSDBDependant object Field Metadata6ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
12/SAPSRM/C_MDFSDLLook-Up Table for Dependant Object/Set Field Metadata7ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
13/SAPSRM/C_MDF_H1Meta Data Configuration for Business Object Header Fields8ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
14/SAPSRM/C_MDF_HBBackground Table for Meta Data Config. for Header Fields6ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
15/SAPSRM/C_MDF_HCCustomer Meta Data Configuration for BO Header Fields8ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
16/SAPSRM/C_MDF_HDMeta Data Configuration for Business Object Header Fields8ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
17/SAPSRM/C_MDF_HLLook-Up Table for Meta Data Configuration for Header Fields7ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
18/SAPSRM/C_MDF_I1Meta Data Configuration for Business Object Item Fields10ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
19/SAPSRM/C_MDF_IBBackground Table for Meta Data Configuration for Item Fields8ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
20/SAPSRM/C_MDF_ICCustomer Meta Data Configuration for BO Item Fields10ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
21/SAPSRM/C_MDF_ILLook-Up Table for Meta Data Configuration for Item Fields9ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
22/SAPSRM/C_MDF_ITMeta Data Configuration for Business Object Item Fields10ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
23/SAPSRM/C_MDF_S1Meta Data Configuration for Set Fields10ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
24/SAPSRM/C_META_HMeta Data Cnofiguration for Business Object Header Fields6ENABLEDPDO Field Property "Editable" (Enabled)nvarchar10
25/SAPSRM/C_PWL_ACPOWL: Customizing Actions7ENABLEDPOWL: enablednvarchar10
26/SAPSRM/C_PWL_DDPOWL: Customizing Actions - Dropdown6ENABLEDPOWL: enablednvarchar10
27/SDF/IVISALETRCVIntegration visibility ALE Receiver ports configuration5ENABLEDEquivalent of ABAP_BOOLnvarchar10
28/SLOAP/MD_SYSSLOAS analysis module to system type mapping5ENABLEDBoolean Variable (X=True, Space=False)nvarchar10
29/SLOAP/MD_SYSTtransport table for /SLOAS/MD_SYS7ENABLEDBoolean Variable (X=True, Space=False)nvarchar10
30BBPC_META_ITMMeta Data for Items Types6ENABLEDEnablednvarchar10
31DD03NDDD: Attributes of a Node of a Structured Object28ENABLEDDD: Indicator whether a field is activenvarchar10
32GRFNCHGHISTCUSTChange History Customizing3ENABLEDIndicatornvarchar10
33GRFNENTACTIONEntity Actions7ENABLEDEnablednvarchar10
34GRFNLISTACTIONSConfigurable List and Actions Assignment7ENABLEDEnablednvarchar10
35IUUC_RL_HEADERIUUC ReplicationLogging Content2ENABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
36IUUC_RL_TABLESIUUC ReplicationLogging Tables3ENABLEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
37MEP_PROV_REGME Provider Registry5ENABLEDME Profile Provider Enabled Statusnvarchar10
38RSBPCW_APP_STATUApplication lock status cache4ENABLEDBPC: Generic indicatornvarchar10
39RSDRI_HDB_ABORTStorage for Aborts / Breakpoints5ENABLEDBooleannvarchar10
40RSDSO_RT_SETTINGRuntime Settings2ENABLEDBooleannvarchar10
41SCTS_TRACK_DGPONDGP: Objects to be enabled for DGP4ENABLEDGeneral Flagnvarchar10
42USMD_CMM_CONFIGConfiguration4ENABLEDConfiguration Parameter Enabled?nvarchar10
TOPArchiveLink
43TOAANWATTLink Table for Application Attributes5ENABLEDSAP ArchiveLink: Status (X = active, otherwise inactive)nvarchar10
44TOAKPROKPro Link Table5ENABLEDSAP ArchiveLink: Synchronous Kpro Indexing Activenvarchar10
45TOALOGCUSTTable for Customizing ArchiveLink Log8ENABLEDActivity Indicator Archivelink Loggingnvarchar10
TOPBasic Functions
46T028PAssign Search Strings to Bank Statement Transactions10ENABLEDSearch string activenvarchar10
TOPBusiness Objects, Common Components
47EHFNDC_FC_NDP_ACField Control BO Node Profile: Action Property6ENABLEDField Control Enablednvarchar10
48EHFNDC_FC_NDP_ASField Control BO Node Profile: Association Property6ENABLEDField Control Enablednvarchar10
49EHFNDC_FC_NDP_ATField Control BO Node Profile: Attribute Property6ENABLEDField Control Enablednvarchar10
50EHFNDC_FC_NDP_NDField Control BO Node Profile: BO Node Property6ENABLEDField Control Enablednvarchar10
TOPChange Transport System
51GTACLIENTSSystems Connected to GTADIR2ENABLEDGTADIR Client Uses RDDPUTGT/RDDGT2TA Comparisonnvarchar10
TOPCustom Development Management Cockpit
52CNVCDMC_STAT_PROCDMC: Programs for Statistics Collection4ENABLED'X' = Considered for stat evaluation, SPACE = not considerednvarchar10
TOPData Basis
53RSODSO_BRKPNTBreakpoint Maintenance for DataStore Objects5ENABLEDActive Breakpoint?nvarchar10
54RSODSO_CONTEXTControl of Runtime Measurements8ENABLEDContext for Measurement Permittednvarchar10
TOPDatabase Interface, Database Platforms
55DBA_DBH_COLL_OPTDBA-DBH: Collector Options4ENABLEDnvarchar10
56DBA_DBH_TPL_COLLDBA-DBH: Collecor Template Collectors5ENABLEDnvarchar10
57DBA_DBH_TPL_OPTDBA-DBH: Collector Template Options6ENABLEDnvarchar10
TOPEasy Enhancement Workbench
58WCF_BSP_BUTTONStandard WCF BSP Button9ENABLEDBooleannvarchar10
TOPEnd User Technology
59RRX_USRMENUUser-defined menu entries10ENABLEDFlag for enabled property of an entry in Excel context menunvarchar10
TOPEnterprise Service Framework Layer
60SESF_SRVMGR_EXT.2ENABLEDnvarchar10
TOPGeneral Application Functions
61BSVWCOUP1System status events6ENABLEDIndicator stating whether event queue admin. is enablednvarchar10
62BSVWCOUP3User Events for Status Object Types5ENABLEDIndicator stating whether event queue admin. is enablednvarchar10
63BSVWCOUP5User Events for Status Object Types6ENABLEDIndicator stating whether event queue admin. is enablednvarchar10
TOPGovernance, Risk and Compliance
64GRFNDOCDOWNLCFGAlternative Document Download3ENABLEDFlag (X or Blank)nvarchar10
65GRPCDOCDOWNLCFGGRC: Alternative Document Download3ENABLEDFlag (X or Blank)nvarchar10
TOPIntegration Engine
66SXMSTSTRIGTable of Troubleshooting Trigger4ENABLEDXMS: Flag (true/false)nvarchar10
TOPIntegration of FPM and Persistency Frameworks like BOPF
67/BOFU/IFBIV_AView: Actions3ENABLEDEnablednvarchar10
68/BOFU/IPBI_POWLAPOWL: Action Definition6ENABLEDEnablednvarchar10
TOPMaintenance Processing
69/MRSS/C_DPR_UIConfiguration of UI elements in C Projects3ENABLEDEnablednvarchar10
TOPManagement of Internal Controls
70FOPCDOCDOWNLCFGAlternative Document Download3ENABLEDFlag (X or Blank)nvarchar10
TOPMobile Applications
71/ISDFPS/METFLDCustomizing: Field Properties (Mobile Application)6ENABLEDReady for Inputnvarchar10
TOPPerformance Monitors TCC
72GVD_DATAFILECopy of GV$DATAFILE10ENABLEDOracle Monitoring: enablednvarchar100
73GVD_TEMPFILECopy of GV$TEMPFILE10ENABLEDOracle monitor: Gtemp. File ENABLEDnvarchar100
TOPPortfolio Management
74/RPM/OBJ_CUS_UIObject type customizing for UI5ENABLEDEnablednvarchar10
75/RPM/OBJ_SAP_UIObject type SAP UI Fields4ENABLEDEnablednvarchar10
76/RPM/PORT_FLD_UIPortfolio Fields UI6ENABLEDEnablednvarchar10
TOPPost Processing Framework Adapter
77/BOFU/C_PPF_CONFBO Node Specific settings for PPF usage5ENABLEDEnablenvarchar10
78/BOFU/C_PPF_DOADirect Outputs: w/o PPF, w/o History; Immediate Outputs5ENABLEDEnablenvarchar10
79/BOFU/C_PPF_PROFAssign PPF Profiles for Business Object Nodes3ENABLEDEnablenvarchar10
TOPProduction and Revenue Accounting
80OIUP_PDM_ONPDM - Customer Configuration To Enable Specific PDM Tables3ENABLEDPDM - Active Flagnvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
81TFMCA_COREL_UIUI Setting for Relationship Maintenance7ENABLEDIndicator: Enabled Fieldnvarchar10
TOPReusable Components of Business Suite Foundation
82/BOFU/CFCNPRAField Control: Attribute Properties7ENABLEDEnabled?nvarchar10
83/BOFU/CFCNPRCField Control: Node Properties(Core Service Properties)7ENABLEDEnabled?nvarchar10
84/BOFU/CFCNPRSField Control: Association Properties7ENABLEDEnabled?nvarchar10
85/BOFU/CFCNPRXField Control: Action Properties7ENABLEDEnabled?nvarchar10
TOPRevenue
86OIUE2_CFGProc 2.0 - Process Config4ENABLEDProc 2.0 - Enablednvarchar10
87OIUE2_PROC_ENABProc 2.0 - Process Enabled?3ENABLEDProc 2.0 - Enablednvarchar10
88OIUE2_PROC_STEPProc 2.0 - Process Steps5ENABLEDProc 2.0 - Enablednvarchar10
TOPRoyalty Reporting
89OIUREP_2014_CONFMMS-2014: Configurable Items3ENABLEDCheckboxnvarchar10
TOPSAP Business Workflow
90SWECDOBJEvents for Change Document3ENABLEDIndicator stating whether event queue admin. is enablednvarchar10
91SWETYPECOUType Linkage Events - Receiver9ENABLEDIndicator stating whether event queue admin. is enablednvarchar10
92SWETYPEENAType Linkage Events - Receiver: Activation Table5ENABLEDIndicator showing whether event type linkage is activatednvarchar10
93SWFDEVENAActivations for Event Linkages6ENABLEDIndicator showing whether event type linkage is activatednvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
94MEREP_206SyncBOs Assigned to Group4ENABLEDEnablednvarchar10
95MEREP_409Synchronizer Control Record2ENABLEDEnablednvarchar10
96MEREP_507Conversation Control (Mobile ID)3ENABLEDEnablednvarchar10
97MEREP_607Receiver Control Record2ENABLEDEnablednvarchar10
98MEREP_608Handler Control Record2ENABLEDEnablednvarchar10
99MEREP_609Mobile Group3ENABLEDEnablednvarchar10
100MEREP_610Sender Control Record2ENABLEDEnablednvarchar10
TOPTax Reporting
101OIUX3_CONFTax Reporting - Config3ENABLEDEnablednvarchar10
102OIUX3_RPT_CONFTax Reporting - Report Specific Configuration4ENABLEDEnablednvarchar10
103OIUX3_RPT_STEPXTax Reporting - Reporting/Step XRef5ENABLEDEnablednvarchar10
104OIUX3_TX_RP_EDT1OBSOLETE - Tax 2.0 - Texas Report Field Attribute Edits10ENABLEDEnablednvarchar10
105OIUX3_TX_RP_EDT2OBSOLETE - Tax 2.0 - Texas Report Field Edits #28ENABLEDEnablednvarchar10
106OIUX7_CONFIGTax 2.0 - WYGP Config2ENABLEDEnablednvarchar10
107OIUXC_RPT_PPTax 2.0 - Report Specific Parallel Processing Config3ENABLEDEnablednvarchar10
TOPWorkforce Management Application
108ITC_EXCPN_MAPMapping table to connect exception profile and type6ENABLEDEnables the exception if checkednvarchar10
109ITC_EXCPN_TYPEPunch Exception Types5ENABLEDEnables the exception if checkednvarchar10