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

105 columns | Print definition?ERP 6.0  | PATH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_EXP_VALUEexpected values table for AIF ECATT4PATHPath of Structurenvarchar2550
2/GEOE/CONFIG_17Picture Marker Path7PATHGeoServicePathnvarchar1000
3/GSINS/BRBPFLSETBrazil: User File settings13PATHFile Pathnvarchar2550
4/MRE/RSC_TGT_DEFDCN target Definitions8PATHPath Prefix for Connection Types G and Hnvarchar2550
5/OPT/VIM_ARB_CFGVIM Ariba Interface configuration3PATHPath to a field in ARIBA interface structurenvarchar800
6/PERSONAS/M_FILEMIME-File3PATHntext10737418230
7/PERSONAS/M_PCKGMIME Paket3PATHntext10737418230
8/PICM/C_BGCTYPPICM : Business Graphics Chart Type5PATHSettings Stored Atnvarchar2550
9/PICM/D_I_BGCTYPPICM : Business Graphics Chart Type4PATHSettings Stored Atnvarchar2550
10/SAPPSSRM/PATHUserpath to PC3PATHUser PC Pathnvarchar2550
11/SDF/CCM_CUSTCustom Code Management Customizing table2PATHCommandnvarchar2550
12/UI5/MIME_FILEUI Theming: File from ZIP archive3PATHntext10737418230
13/UI5/MIME_PCKGUI Theming: ZIP archive header3PATHntext10737418230
14APC_APPLABAP Push Channel application definition3PATHABAP Push Channel application pathnvarchar3800
15BBP_CUSTConfiguration of Values for EBP3PATHnvarchar2000
16BBP_TRCUConfiguration of Values for EBP3PATHnvarchar2000
17CNVC_SCWB_SPRFSpreadsheets filesnames3PATHPathnamenvarchar600
18CNVMBTDEXFILSTATDMIS PCL Status of Data Extract Files14PATHLogical path namenvarchar600
19LOCINFOOS dependent locale information.3PATHText Fieldnvarchar500
20NWS_EXT_PROJNData Transport Management Tool Projects9PATHPath Namenvarchar550
21PSSRM_USERPATHUser PC identification3PATHUser PC Pathnvarchar2550
22RSCRMREPTABRSCRM: Report Table Catalog8PATHPath Namenvarchar2550
23SRAL_FIELDS_DYNPRAL: Channel specific fields6PATHRAL: Path of a container in Dynpro (/PROG(DYNNO)CONTAINER*)ntext10737418230
24T5FDSNXMLPATHDSN: XML parser path for the response XML of GIP3PATHntext10737418230
25T7RUPACKGRPFR Packages group8PATHLocal file for upload/downloadnvarchar1280
26USR_CUST_SYSTEMSystem Settings for Users / Authorizations2PATHField attributesnvarchar2000
27ZSIM_ARIBA_AR_ERSAP IM ARIBA interface - archiving error protocol3PATHSAP ArchiveLink file pathsnvarchar700
28ZXMII_M_PATHPath to xMII pages/transactions7PATHURLnvarchar2550
TOPABAP Authorization and Role Management
29PRGN_CUSTCustomizing settings for authorization process2PATHAttributes of the menunvarchar100
30SSM_EXValue Configuration2PATHField attributesnvarchar2000
31SSM_SYSTSet workplace values2PATHField attributesnvarchar2000
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
32CRM_ECLOG_SCRReplicated Log Entries of a Script Line15PATHName of Path for Script Variantsnvarchar300
TOPArchiveLink
33TOAC1SAP ArchiveLink: Frontend Customizing3PATHSAP ArchiveLink file pathsnvarchar700
34TOACACache for frontend files4PATHSAP ArchiveLink file pathsnvarchar700
35TOACRAsynchronous ArchiveLink Requests20PATHChar255nvarchar2550
36TOAR7SAP ArchiveLink: Request table (asynchronous storage)16PATHSAP ArchiveLink file pathsnvarchar700
TOPAuthoring Environment
37LSOLU_CLearning Nets11PATHLearning Net Path in WMCntext10737418230
TOPBusiness Package for Manager Self-Service FI
38FPB_EXP_PATHSNavigation Paths for Express Planning2PATHString for multiple usentext10737418230
TOPBusiness Partner
39FSBPC_PRX_CPATHCustomizing Communication Path2PATHAccess Modenvarchar10
TOPClinical System
40N1ANFTYPIS-H*MED: Request Type24PATHPath for the Graphical F4-Helpnvarchar800
41TN2DOCEXE_CUSTPMD Customizing for Branch to File Processing8PATHPhysical File Path of Document to Be Processednvarchar1280
TOPCollaboration Folders
42CFX_VER_CHECKOUTCFX: Local File Path4PATHCharacter String for Collaboration Foldersntext10737418230
TOPCross-Application Components
43/IXOS/DC_TCNTHLTable for nodetype hyperlinks10PATHURL path of a hyperlinknvarchar2550
44J_2GLPLPLogical Papers3PATHPath to VBFAnvarchar40
45J_8A3MERKmemorize last selection - Old Version, don't use7PATHpath at file system - Old Version, don't usenvarchar2500
46J_8A3T0006memorize last selection12PATHpath at file systemnvarchar2500
47SWKHANDTURI of Workflow Launch Handler for external HTTP Services7PATHService Pathnvarchar2550
TOPData Basis
48RSBFILEOpen Hub Destinations: Files4PATHPath Namenvarchar2550
TOPData Retention Tool
49TXX_ADMI_RESDART-Administration ---Resource Management ---10PATHArchive Pathnvarchar2550
TOPDatabase Interface, Database Platforms
50DB6ALRTCFGDB6: Alert Configuration Data14PATHnvarchar1000
TOPeCATT Extended Computer Aided Test Tool
51ECLOG_SCRTable of Log Entries for a Script Line14PATHName of Path for Script Variantsnvarchar300
52ECSCR_CMDNOT USED - Table with eCATT Script Commands9PATHName of Path for Script Variantsnvarchar300
TOPECM ABAP Stack
53NWECMD_NODEtable for persistent node objects6PATHnwecm: Stringntext10737418230
TOPElectronic Bank Statement
54FEB_FILEPATHClient-Dependent Definition of Logical File Paths2PATHLogical Path Namenvarchar600
55FEB_FILEPATHTDescription of Logical File Paths3PATHLogical Path Namenvarchar600
TOPEmployee Self-Service
56T7XSSSERSDBXSS: Server definition5PATHDirectory Pathnvarchar1320
TOPEnd User Technology
57RSZWMIMEIOBUFFERBuffer for Translation from Mime Repository Path Accrd to IO1PATHPath to a MIMEnvarchar800
TOPF1 Help
58IWR_31_PRMIWR: System Parameters (Only for Cust. Solution for 3.1)3PATHLocal file for upload/downloadnvarchar1280
59SHLPADM1Administration: Display of the SAP Library6PATHSIWR: Path for online helpnvarchar640
60SHLPADM2TText Table for Administration Online Help6PATHSIWR: Path for online helpnvarchar640
61SHLPUSRVALUser Settings for SAP Library (Display)6PATHSIWR: Path for online helpnvarchar640
TOPFast Search Infrastructure
62SFSRFW_ALIAS_DIRAlias Service Directory3PATHntext10737418230
TOPFinancial Accounting
63FERC_F1Detailed audit trace file3PATHPath for audit trace fileint100
TOPGeneric Interaction Layer
64CRMC_GIL_APPMODLAssignment Between Application and Model in Generic IL3PATHText, 255 Charactersnvarchar2550
TOPGlobal Trade Services
65/SAPSLL/BOMITSLL: BOM - Item7PATHBills of Material: Sequential Number Within BOM Leveldecimal50
66/SAPSLL/RXPMRARe-Export: Log: Assemblies in Bill of Product5PATHBills of Material: Sequential Number Within BOM Leveldecimal50
TOPHelp Infrastructure for ABAP
67WDHC_CONFIGHelp Center Configuration4PATHPath to Repository Foldernvarchar1280
TOPInteraction Center WebClient
68CRMC_IC_ACTSRCActivity Clipboard Additional Sources Definitions3PATHRelation Path to Sourcenvarchar2550
TOPInternet Communication Framework
69ICFINSTACTICF: Table for Activating Services in Installation4PATHICF: Domain for URL (Case-Sensitive)nvarchar2000
70ICF_SERV_STATInterim Storage of ICF Statistics Data2PATHSAP Workload NW Collector: Text Field of 255 Charactersnvarchar2550
TOPLanguage Transport
71TLANIMPLanguage Transport: Import Action17PATHDirectory namenvarchar600
TOPLogistics - General
72MGWPICTURECustomizing Image Data3PATHServer Path for Fullscreen Image Datanvarchar2300
TOPMenu Painter
73RSMPTEXTSMenu Painter: Texts8PATHFastpath IDnvarchar10
74RSMPTEXTSIMenu Painter: Texts8PATHFastpath IDnvarchar10
75RSNORMTXTTexts for Menu Painter norm suggestions7PATHFastpath IDnvarchar10
TOPMigration
76TEMRUNMass import: Header data6PATHPath for Migration Batchnvarchar600
TOPNetWeaver Demonstration
77SNWD_ECMAEPM: Table for Enterprise Content Management attachments7PATHEPM: Stringntext10737418230
TOPOrganizational Flexibility
78/ISDFPS/PM_TPCRWEmployees for Maintenance Order7PATHFastpath IDnvarchar10
TOPProduct Cost Planning
79TSETTINGSEinstellungen für COPCDATEN und COPCOBJ3PATHLokale Datei für Upload bzw. Downloadnvarchar1280
TOPReporting
80P05T_RESP_LINEWage Return: Table for Response Message Errors8PATHClass-Dependent Error Location Codenvarchar10240
TOPResults Recording
81QISUBSubsytems for recording measured value data in QM8PATHName of Access Path for the Interface Filesnvarchar640
TOPRetention Warehouse
82IWP_WP_PATHPaths of an Audit Package7PATHntext10737418230
TOPSAP Business Workflow
83SWFWSHANDTHandler Customizing for Web Service Execution in Workflow6PATHHandler Pathnvarchar2550
84SWLWPHANDTURLs for Workflow Launch and Callback Handler (Ext. Service)8PATHService pathnvarchar2550
85SWLWPSWorkflow: External Services6PATHService pathnvarchar2550
86SWRWEBSERVCustomizing Web Server4PATHPath of Service in URLnvarchar2550
TOPSAP Internet Transaction Server
87SITSICONUPLOADITS: Customizing for Report SIAC_ICON_UPLOAD3PATHITS: File/ICON Upload, Path in Theme (e.g. 'TEST/ICON/')nvarchar1200
TOPService Data Download
88/SDF/DB6ALRTCFGDB2 UDB: Alert Configuration Data13PATHnvarchar1000
TOPSession Manager
89SSM_CUSTSet Values for the Session Manager / Profile Generator2PATHField attributesnvarchar2000
90START_GUIDSet Values for the Session Manager / Profile Generator3PATHField attributesnvarchar2000
TOPSyntax, Compiler, Runtime
91SPTHPath ID for backup and authorization1PATHPath in file systemnvarchar860
TOPTranslation Tools
92LXE_LOG_DATA_TRPExport/import log23PATHntext10737418230
93LXE_PC_ADHeader Data for PC* Objects3PATHText Lineimage21474836470
94LXE_TDC_VERSIONVersion and Path for Compatible TDControl.exe2PATHntext10737418230
95TSTPHSAP Relesae for Translation Statistics2PATHText, 40 Characters Longnvarchar400
TOPTREX Enterprise File Search
96SEFS_CR_HOSTHost Information for Crawl4PATHPathntext10737418230
TOPUser and Authorization Management
97USR_CUSTCustomizing Settings for Users / Authorizations3PATHField attributesnvarchar2000
TOPWeb Application Builder
98WBXMLCUSTObsolete: Settings for XML Workbench Connection2PATHnvarchar1200
TOPWeb Dynpro
99WRC_CUSTSet Values for Recording Web Dynpro3PATHnvarchar2000
TOPWeb Dynpro ABAP
100WDG_UR_WEB_ICONDefinition of icons4PATHnvarchar1000
TOPWeb Dynpro ABAP Rendering
101WDR_MIME_FILEMIME File3PATHntext10737418230
102WDR_MIME_PCKGMIME Package3PATHntext10737418230
TOPWeb Dynpro Integration of Office Products and Graphic
103WDR_ACF_WL_EXECWhitelist for Executable Programs4PATHWhitelist: Application Path (incl. Application)nvarchar2550
TOPWithout Description
104CCMSBI_CPH_GUIDSGUIDs for Long MTE Name7PATHPath of an MTE in the Monitoring Treenvarchar1280
105CCMSBI_GUIDS_CPHGUIDs for Long MTE Names (Extended)7PATHPath of an MTE in the Monitoring Treenvarchar1280