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

29 columns | Print definition?ERP 6.0  | LAST_CHANGED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/C_MGDEAMCustomizing table: Routing for OData Services7LAST_CHANGEDUser Namenvarchar120
2BBP_ATTR_VALUE_TTexts for Attribute Values7LAST_CHANGEDChanged Onnvarchar80
3BICS_BOOKMARKHeader table for bookmarks created via ABAP BICS6LAST_CHANGEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
4CNVMBTNEADMINUsers and COT objects they want get notifications for6LAST_CHANGEDTimestamp of Changedecimal150
5CNVMBTNEREFReference Handling for Inheritance Between Scopes6LAST_CHANGEDTimestamp of Changedecimal150
6CNVMBTNEUSERKnown Observer Instances7LAST_CHANGEDTimestamp of Changedecimal150
7RS2HANA_AUTH_AUMAuth: Mapping of user/authorizations4LAST_CHANGEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
8SATC_AC_NAMESPCSCustomer Namespaces3LAST_CHANGEDDate of Last Changenvarchar80
9SATC_CI_EXEMPTExemptions for Code Inspector mode22LAST_CHANGEDChanged on ... (timestamp)decimal150
10SRAL_TRACE_CFGSRAL Trace Configuration6LAST_CHANGEDUser Namenvarchar120
11SRA_TSUSETTINGSSRA Application table for Tiime Sheet user settings4LAST_CHANGEDDatenvarchar80
TOPDocument Builder
12/IPRO/TTEMPLDocument Builder Templates19LAST_CHANGEDTimestampdecimal150
TOPE-Recruiting
13HRP5135DB Table for Infotype 513531LAST_CHANGEDTime Stamp of Last Changedecimal150
14HRP5136DB Table for Infotype 513631LAST_CHANGEDTime Stamp of Last Changedecimal150
15HRP5137DB Table for Infotype 513731LAST_CHANGEDTime Stamp of Last Changedecimal150
16HRP5138DB Table for Infotype 513831LAST_CHANGEDTime Stamp of Last Changedecimal150
17HRP5139DB Table for Infotype 513931LAST_CHANGEDTime Stamp of Last Changedecimal150
18HRP5140DB Table for Infotype 514031LAST_CHANGEDTime Stamp of Last Changedecimal150
19HRP5141DB Table for Infotype 514131LAST_CHANGEDTime Stamp of Last Changedecimal150
20HRP5142DB Table for Infotype 514231LAST_CHANGEDTime Stamp of Last Changedecimal150
21HRP5143Database Table for Infotype 514331LAST_CHANGEDTime Stamp of Last Changedecimal150
22HRP5144Database Table for Infotype 514431LAST_CHANGEDTime Stamp of Last Changedecimal150
23HRP5145Database Table for Infotype 514531LAST_CHANGEDTime Stamp of Last Changedecimal150
TOPGeneral
24LWMHR_D_MYM_AGNDAgenda Header6LAST_CHANGEDSystem Datenvarchar80
25LWMHR_D_MYM_QYVAQuery Variants of HR Business Partner13LAST_CHANGEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
26LWMHR_D_MYM_QYVRQuery Variants of HR Business Partner, enhanced14LAST_CHANGEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPProfile Maintenance
27OPMODE_EXT_TOOLOperation Mode Control Using an External Tool (SXOPM)5LAST_CHANGEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPProxy Generation
28SPROX_TEST_DATAStorage for test data6LAST_CHANGEDTime of Changenvarchar140
TOPServices
29FINB_PR_TOBJSPersistence Objects32LAST_CHANGEDTimestamp (date and time) for usernvarchar140