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

73 columns | Print definition?ERP 6.0  | APPLICATION_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/ERR_APPError handling Application2APPLICATION_IDApplication IDnvarchar30
2/AIF/T_APPL_KFLDApplication ID <-> Key fields mapping2APPLICATION_IDApplication IDnvarchar30
3/AIF/T_ERR_APPError handling Application2APPLICATION_IDApplication IDnvarchar30
4/AIF/T_ERR_APP_TApplication ID text table2APPLICATION_IDApplication IDnvarchar30
5/AIF/T_FUNC_LSTFunction codes for Applications (views)2APPLICATION_IDApplication IDnvarchar30
6/AIF/T_FUNC_LSTTText table for /AIF/T_FUNC_LSTT2APPLICATION_IDApplication IDnvarchar30
7/SAPSRM/C_EX_TAGExpose the tags in Foorplan1APPLICATION_IDWeb Dynpro: Name of Applicationnvarchar300
8/SAPSRM/C_SWITCHDefinition of Customizing Switches and their Attributes15APPLICATION_IDApplication IDnvarchar70
9/XLSO/RATING_AVGAverage Ratings6APPLICATION_IDShop IDnvarchar2550
10AMC_APPLData Table for Workbench Object.1APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
11AMC_APPL_TEXTText table for AMC Channel1APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
12AMC_CHANNELABAP Messaging Channel definition1APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
13AMC_CHNL_AUTHABAP Messaging Channel Authority definition1APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
14AMC_COMMUNITYConfiguration of ABAP Online Community Messaging Channels3APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
15AMC_LOG_ADMINAMC logging administration table (activation, deactivation)4APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
16AMC_LOG_STORAGEAMC logging storage6APPLICATION_IDABAP Messaging Channel Application IDnvarchar300
17APC_APPLABAP Push Channel application definition1APPLICATION_IDABAP Push Channel Application IDnvarchar300
18APC_APPL_TEXTText table for APC Application1APPLICATION_IDABAP Push Channel Application IDnvarchar300
19CLB2D_BO_ENTITYCollaboration: Business Object - Entity Assignment2APPLICATION_IDCollaboration: Application IDnvarchar500
20FDT_BRS_DSM_0020BRS DSM:Statistics5APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
21FDT_BRS_DSM_0030BRS DSM: Application Service Exit Relation2APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
22FDT_PROC_ENQUEUEFDT: Generic Processing Enqueue Table for FDT Object2APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
23FUDC_DOCVERRULEConfiguration Data for FI Document Verification Rule5APPLICATION_IDApplication IDnvarchar320
24RSBPC0_PARAM_APPBPC Extension: Environment/Model Parameters3APPLICATION_IDBPC: Application IDnvarchar200
25STWD_BO_TOPICStreamWork: Business Object - Topic Assignment2APPLICATION_IDCollaboration: Application IDnvarchar500
26T77OVIS_APP_IDApplication Definition2APPLICATION_IDVisualization IDnvarchar150
27T77OVIS_APP_ID_TText Table for Application ID2APPLICATION_IDVisualization IDnvarchar150
28T77OVIS_OTYDFNObject Type Definition2APPLICATION_IDVisualization IDnvarchar150
29T77OVIS_OTYDFN_TObject Type definition texts2APPLICATION_IDVisualization IDnvarchar150
30T77OVIS_STRUCStructure Definition2APPLICATION_IDVisualization IDnvarchar150
31T77OVIS_STRUC_TText Table for Structure Name2APPLICATION_IDVisualization IDnvarchar150
32T7UNESS_APPSCRWorkflow Customization for HR Administrator Desk4APPLICATION_IDnvarchar1000
33TN1EVMG_SWFAssignment i.s.h.med Event to Business Object Event3APPLICATION_IDEvent Mgmt: Application Definition IDnvarchar100
34ZRDB_DEL_DIR16.09.2009: Delete DIR63APPLICATION_IDLogisches Dokumentnvarchar320
TOPBatches
35TCUDB_APPL_PROCDocumentary Batch - Application: Supported Processed1APPLICATION_IDDocumentary Batch - Application IDnvarchar20
TOPBRFplus - ABAP-Based Business Rules
36FDT_ADMN_0000FDT: Central Administrative Data6APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
37FDT_ADMN_0000AFDT: Central Administrative Data6APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
38FDT_ADMN_0000SFDT: Central Administrative Data5APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
39FDT_ADMN_0000TFDT: Central Administrative Data5APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
40FDT_ADMN_0010FDT: Central Administrative Data (version dependent)4APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
41FDT_ADMN_0010AFDT: Central Administrative Data (version dependent)4APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
42FDT_ADMN_0010SFDT: Central Administrative Data (version dependent)3APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
43FDT_ADMN_0010TFDT: Central Administrative Data (version dependent)3APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
44FDT_ENQUEUE_IDFDT: Generic Enqueue Table for FDT Objects2APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
45FDT_JOB_0000FDT: Job Header Table15APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
46FDT_QUERY_0000Obsolete => USE FDT_ADMN_0000T instead5APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
47FDT_QUERY_0000AObsolete => USE FDT_ADMN_0000T instead5APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
48FDT_QUERY_0000BFDT: Query Table5APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
49FDT_QUERY_0000SObsolete => USE FDT_ADMN_0000T instead4APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
50FDT_QUERY_0000TObsolete => USE FDT_ADMN_0000T instead4APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
51FDT_WD_FILTERFDT WD: Filter Assignment to user4APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
TOPCollaborative Cross Applications
52/POA/BNDL_APINFOTable to store app info for a bundle in flex client platform4APPLICATION_IDFCP Stringnvarchar2550
TOPLaunchpad
53APB_LPD_CHNGELOGLogs changes made to launchpad for updating user version6APPLICATION_IDGUIDnvarchar320
54APB_LPD_HITLISTMost frequently used Applications5APPLICATION_IDGUIDnvarchar320
55APB_LPD_REPOSWhere used list for Repositories6APPLICATION_IDGUIDnvarchar320
56APB_LPD_SEARCHSearch over Launchpads1APPLICATION_IDGUIDnvarchar320
57APB_LPD_TRANSLOGTransports change logs to lpd for updating user version6APPLICATION_IDGUIDnvarchar320
TOPMaterial Master
58WER_CTX_MAP_AMapping information between object data and item fields2APPLICATION_IDApplication identifiernvarchar320
59WER_CTX_MAP_SMapping information between object data and item fields1APPLICATION_IDApplication identifiernvarchar320
60WER_RE_MAP_AMapping btw data object and assigned rule element (Customer)2APPLICATION_IDApplication identifiernvarchar320
61WER_RE_MAP_SMapping between data object and assigned rule element1APPLICATION_IDApplication identifiernvarchar320
62WGDS_PROC_APP_CApplication used in a process3APPLICATION_IDApplication id (char version)nvarchar320
63WGDS_PROC_EVT_CRule engine's Events called during a process2APPLICATION_IDApplication id (char version)nvarchar320
TOPOffice Suite Program
64SOSP_T_BKT_PERFMBook Keeping table for Performance4APPLICATION_IDApplication IDnvarchar60
TOPPublic Sector Contract Accounts Receivable and Payable
65TFMCA_BRFP_DOBJBRF+ Dataobject Mapping Table4APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
66TFMCA_BRFP_EXPRBRF+ Expression for phase concept3APPLICATION_IDFDT: Universal Unique Identifiernvarchar320
TOPStreamWork ABAP Library
67STWD_BO_ENTITYCollaboration: Business Object - Entity Assignment2APPLICATION_IDCollaboration: Application IDnvarchar500
TOPTransport Organizer
68CTS_IMEXP_LOCKContains all locks for transport of collections5APPLICATION_IDnvarchar400
69CTS_QA_APPROVEDContains collections that were already approved by QA7APPLICATION_IDnvarchar400
TOPWeb Channel UM ERP aspects
70ERPD_WEC_BP_CPCheckout Profile for a customer3APPLICATION_IDHolds Shop IDnvarchar400
71ERPD_WEC_CUST_CPCheckout Profile for a customer4APPLICATION_IDHolds Shop IDnvarchar400
TOPWeb Service and SOAP - ABAP
72SRT_UTIL_TRCFUNCSRT Utilities: Functional Trace Data21APPLICATION_IDnvarchar320
73SRT_UTIL_TRCPLOASRT Utilities: Payload Trace Data23APPLICATION_IDnvarchar320