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

38 columns | Print definition?ERP 6.0  | ACTIVE_FLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/M_AUT_ASGNMirror for Control table for automatic assignment creation16ACTIVE_FLAGAutomatic Scheduling enablednvarchar10
2/OPT/X050VIM Analytics frequency Group Configuration table7ACTIVE_FLAGVIM Analytics Active flagnvarchar10
3/OPT/X051VIM Analytics frequency Group Configuration Text Table8ACTIVE_FLAGVIM Analytics Active flagnvarchar10
4/OPT/X152OPENTEXT: Approval Diagnostic Program Units7ACTIVE_FLAGIndicator: Status is activenvarchar10
5/OPT/X153OPENTEXT: /ORS/ TABLE CONFIGURATION4ACTIVE_FLAGIndicator: Status is activenvarchar10
6/OPT/Y050VIM Analytics frequency Group Configuration table7ACTIVE_FLAGVIM Analytics Active flagnvarchar10
7/OPT/Y051VIM Analytics frequency Group Configuration Text Table8ACTIVE_FLAGVIM Analytics Active flagnvarchar10
8/OPT/Y152OPENTEXT: Approval Diagnostic Program Units7ACTIVE_FLAGIndicator: Status is activenvarchar10
9/OPT/Y153OPENTEXT: /ORS/ TABLE CONFIGURATION4ACTIVE_FLAGIndicator: Status is activenvarchar10
10/OPT/Z050VIM Analytics frequency Group Configuration table7ACTIVE_FLAGVIM Analytics Active flagnvarchar10
11/OPT/Z051VIM Analytics frequency Group Configuration Text Table8ACTIVE_FLAGVIM Analytics Active flagnvarchar10
12/OPT/Z152OPENTEXT: Approval Diagnostic Program Units7ACTIVE_FLAGIndicator: Status is activenvarchar10
13/OPT/Z153OPENTEXT: /ORS/ TABLE CONFIGURATION4ACTIVE_FLAGIndicator: Status is activenvarchar10
14/ORS/DIAG_PUNITSOPENTEXT: Approval Diagnostic Program Units7ACTIVE_FLAGIndicator: Status is activenvarchar10
15/ORS/DIAG_TABLEOPENTEXT: /ORS/ TABLE CONFIGURATION4ACTIVE_FLAGIndicator: Status is activenvarchar10
16/SAPPSSRM/SCENARActive scenario2ACTIVE_FLAGSingle-Character Indicatornvarchar10
17/SAPSRM/C_APP_SWOBSOLETE: Assignment of Extension Appends to Switches2ACTIVE_FLAGOBSOLETE !!!!! Flag Determining if Entry is Activenvarchar10
18/SYCLO/CA000AMobile application - Satellite Systems6ACTIVE_FLAGActive Flagnvarchar10
19COPC_ACCOUNTCash Account3ACTIVE_FLAGActive flag for cash accountnvarchar10
20HRP7902DB Table for Infotype 790218ACTIVE_FLAGCheckboxnvarchar10
21RFCCBWHITELIST_APositive List for RFC Callbacks2ACTIVE_FLAGActivation Flag of Callback Positive List for Connectionnvarchar10
TOPAuto-ID Infrastructure
22/AIN/TDOD1_NRRANDOD Tag Data Construct #1 Number Range9ACTIVE_FLAGActive or Inactive Indicatornvarchar10
23/AIN/TGIAI_NRRANGIAI Number Range9ACTIVE_FLAGActive or Inactive Indicatornvarchar10
24/AIN/TGRAI_NRRANGRAI Number Range9ACTIVE_FLAGActive or Inactive Indicatornvarchar10
25/AIN/TGTIN_NRRANGTIN Number Range11ACTIVE_FLAGActive or Inactive Indicatornvarchar10
26/AIN/TSSCC_NRRANSSCC Number Range9ACTIVE_FLAGActive or Inactive Indicatornvarchar10
TOPCross-Application Components
27/OPT/VIM_FGROUPVIM Analytics frequency Group Configuration table7ACTIVE_FLAGVIM Analytics Active flagnvarchar10
TOPFinancial Accounting
28/OPT/VIM_FGRPTVIM Analytics frequency Group Configuration Text Table8ACTIVE_FLAGVIM Analytics Active flagnvarchar10
TOPMaintenance Orders
29/MRSS/C_AUT_ASGNControl table for automatic assignment creation14ACTIVE_FLAGAutomatic Scheduling enablednvarchar10
30/MRSS/C_FCHG_FLDChecks During Field Changes5ACTIVE_FLAGCheck Activenvarchar10
TOPMaterials Management
31/SAPPSPRO/SCENARScenario Table2ACTIVE_FLAGSingle-Character Indicatornvarchar10
TOPNetWeaver Enterprise Search
32ESH_QP_QUE_GRAMQuery Grammar7ACTIVE_FLAGnvarchar10
TOPRoyalty Reporting
33OIUREP_ACTIVATEReg./Tax and Royalty Reporting - report activation4ACTIVE_FLAGReg./Tax and Royalty Reporting - Report Activation Flagnvarchar10
TOPSoftware Agent Framework
34CRMC_SAF_FBSAF: Feedback definitions for knowledge bases4ACTIVE_FLAGSAF: Feedback Option Activenvarchar10
TOPSupplier Managed Inventory
35SMI_PROFILESMI Profile3ACTIVE_FLAGProfile is Activenvarchar10
TOPTax Reporting
36OIUX1_MIGR_CNTRLReporting migration control table3ACTIVE_FLAGActive flagnvarchar10
TOPTransaction Manager
37AT210Rules for Determining a Taxes for CFM postings15ACTIVE_FLAGActive Flagnvarchar10
TOPWithout Description
38RSTT_CATTTRACETrace Tool: CATT Trace Specific Properties4ACTIVE_FLAGTrace Tool: Standard Flagnvarchar10