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

37 columns | Print definition?ERP 6.0  | FOLDER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/DC_EX_FILEFiles in folders4FOLDERFolder numbernvarchar100
2/IXOS/DC_EX_FOLFolder2FOLDERFolder numbernvarchar100
3/XFT/EPA_T0001Folder visibility4FOLDERAliasnvarchar100
4/XFT/EPA_T0018Visibility folder for info type3FOLDERAliasnvarchar100
5CNV_20308_DLDownloads20FOLDERFolder in file systemnvarchar2550
6RSZCOMPTREEHierarchical Display of Reusable Query Components3FOLDERTree Node of Folder Hierarchynvarchar300
7RSZCOMPTREETXTHierarchical Display of Reusable Query Components (texts)4FOLDERTree Node of Folder Hierarchynvarchar300
8TOACUSAP ArchiveLink Customizing table7FOLDERYes/No (X/ )nvarchar10
TOPABAP Authorization and Role Management
9AGR_HIERTable for Structure Information for Menu5FOLDERCustomized ('C') or standard menu ('S') flagnvarchar10
10AGR_HIER2Menu structure information - Customer version of SAP roles5FOLDERCustomized ('C') or standard menu ('S') flagnvarchar10
11AGR_HIER3Menu structure information - SAP version of SAP roles5FOLDERCustomized ('C') or standard menu ('S') flagnvarchar10
12AGR_TCODE3Assignment of roles to Tcodes8FOLDERCounter for menu IDnvarchar50
13AGR_TCODESAssignment of roles to Tcodes8FOLDERCounter for menu IDnvarchar50
14ROLE_INAKInactive roles buffer5FOLDERCustomized ('C') or standard menu ('S') flagnvarchar10
TOPALE Integration Technology
15EDIPOITable for describing Internet ports5FOLDERFolder for Internet IDocsnvarchar170
TOPCommunication Services Mail, Fax, SMS, Telephony
16SMYOTREEMyObjects Together with Hierarchy5FOLDERName of Folder for My Objects (Key)nvarchar100
TOPData Basis
17RSLPO_DFG_DTPFOLTable for Managing Folders for DTP Templates3FOLDERName of Folder for Organizing DTP Templatesnvarchar300
TOPEnd User Technology
18RSPOR_T_FOLDERKM Folder in Portal3FOLDERKM Foldernvarchar2550
19RSRDE_DOC_CONTDocuments for Broadcasting: Content5FOLDERChar255nvarchar2550
20RSZCOMPICAssignment reuseable component <-> InfoCube5FOLDERTree Node of Folder Hierarchynvarchar300
TOPFinancial Services Localization
21/GSINS/REU_LINKSReserve Excel Book Link2FOLDERFolder linknvarchar500
22/GSINS/REU_VARCoordinates of Reserve Variables2FOLDERFolder linknvarchar500
TOPHierarchy Storage
23TTREV_ROLEVersion Management: Comparison Results5FOLDERCustomized ('C') or standard menu ('S') flagnvarchar10
TOPHR Administrative Services
24T5ASRFAVORITESInfotype Browser Favorites3FOLDERIdentifier of Foldervarbinary160
25T5ASRFOLDERFolder for User Favorites3FOLDERIdentifier of Foldervarbinary160
TOPKnowledge Warehouse
26IWBKEYWRDInfo Workbench: Keywords (language-independent information)8FOLDERID for documents and relationsnvarchar320
TOPProduct Data Management
27CERCLNB2E [PDM] Reconciliation Task2FOLDERObject numbernvarchar220
TOPRecords and Case Management
28RMPS_DESK_TAFDAssignment Folder to Desk3FOLDERFolder for Tasksnvarchar40
29RMPS_DESK_TAIFAssignment Item to Folder2FOLDERFolder for Tasksnvarchar40
30RMPS_DESK_TFLDFolder for Tasks in Organizer2FOLDERFolder for Tasksnvarchar40
31RMPS_DESK_TFLDTFolder Text for Tasks in Organizer3FOLDERFolder for Tasksnvarchar40
TOPSAP Utilities
32ISU_BOLTREE_HIERUtilities BOL Tree: Define Tree Hierarchy8FOLDERUtilities BOL Tree: Node is Foldernvarchar10
TOPTransaction Manager
33TCORIT_FILESTreasury: Uploaded files2FOLDERName of the foldernvarchar2550
TOPTranslation Tools
34LXE_KW_TRANSLKW folders defined for translation6FOLDERTechnical name of an information objectnvarchar400
TOPUse Subcomponents
35AMYOTREEMyObjects Together with Hierarchy5FOLDERNodes in MyObjects (key)nvarchar100
TOPUser Interface
36WCF_FAV_FAVORITEFavorites7FOLDERIDnvarchar320
37WCF_UST_BOXITEMSharebox item8FOLDERCentral Sharing Tool IDnvarchar320