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

55 columns | Print definition?ERP 6.0  | EXTERNAL_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/D_TOBJECTechnical Object6EXTERNAL_KEYTechnical Object External Keynvarchar600
2GRACMITMSMPVALIMitigation Assignment Workflow Validation9EXTERNAL_KEYUUID of the GRC object (char32)nvarchar320
3GRFNMWRTINSTMSMP Runtime - Instance Header Info4EXTERNAL_KEYExternal Keynvarchar500
4GRFNMWRTINSTWIMSMP Runtime - Work Item execution context cache7EXTERNAL_KEYExternal Keynvarchar500
5N1MCI_MSGMessage Log10EXTERNAL_KEYExternal Key of a Messagenvarchar500
6N1TPI_ELINKAssignment of Object to External Key6EXTERNAL_KEYExternal Key of a Messagenvarchar500
7N1TPI_HISTORYManagement Message Date for External Key and Object Type3EXTERNAL_KEYExternal Key of a Messagenvarchar500
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
8SATC_RT_RUNMovement data (runtime repository) - Header15EXTERNAL_KEYExternal key - Of no particular meaning to ATC itselfnvarchar80
TOPProduct Lifecycle Management
9ACO_ADMIN_OTYPEObject Categories with Authorization Assignment by Sys. Adm.3EXTERNAL_KEYSearch Help Parameter That Displays the External Keynvarchar300
TOPSearch
10/PLMB/SEA_QUERYSearch query head3EXTERNAL_KEYSearch Querynvarchar220
TOPWorkforce Management Application
11WFAC_COSTNCosts: External key2EXTERNAL_KEYSchedule Priority IDnvarchar200
12WFAC_COSTN_DCosts3EXTERNAL_KEYSchedule Priority IDnvarchar200
13WFAC_COSTN_TCosts: External Key Text2EXTERNAL_KEYSchedule Priority IDnvarchar200
14WFAC_DAYSHIFTNDay Shift Definition4EXTERNAL_KEYWeek Breaker IDnvarchar200
15WFAC_DAYSHIFTN_TWeek/day breaker: External Key Text2EXTERNAL_KEYWeek Breaker IDnvarchar200
16WFAC_LOCSETTNGeneral Location Settings3EXTERNAL_KEYExternal Key for General Location Settingsnvarchar200
17WFAC_LOCSETTN_TGen. Location Settings Translation Table2EXTERNAL_KEYExternal Key for General Location Settingsnvarchar200
18WFAC_SCHDEXCPNSchedule Exceptions: External key2EXTERNAL_KEYSchedule Exceptions IDnvarchar200
19WFAC_SCHDEXCPN_DSchedule Exceptions3EXTERNAL_KEYSchedule Exceptions IDnvarchar200
20WFAC_SCHDEXCPN_TSchedule Exceptions: External Key Text2EXTERNAL_KEYSchedule Exceptions IDnvarchar200
21WFAC_SNPRFNSeniority Date Profile4EXTERNAL_KEYSeniority Date Preference IDnvarchar200
22WFAC_SNPRFN_TSeniority Date Profile: External Key Text2EXTERNAL_KEYSeniority Date Preference IDnvarchar200
23WFAC_WKNDDAYSNWeekend Days4EXTERNAL_KEYWeekend Days IDnvarchar200
24WFAC_WKNDDAYSN_TWeekend Days: External Key Text2EXTERNAL_KEYWeekend Days IDnvarchar200
25WFAC_WKRLDFLTNDefault work rules : External key2EXTERNAL_KEYDefault Work Rule IDnvarchar200
26WFAC_WKRLDFLTN_DWork Rules Default3EXTERNAL_KEYDefault Work Rule IDnvarchar200
27WFAC_WKRLDFLTN_TDefault work rules: External Key Text2EXTERNAL_KEYDefault Work Rule IDnvarchar200
28WFAC_WKRLINTVN_DWork Rule Interval3EXTERNAL_KEYDefault Work Rule IDnvarchar200
29WFAC_WRD_MAXPERIPeriod Rule Type3EXTERNAL_KEYDefault Work Rule IDnvarchar200
30WFAC_WRD_RESTPERMaximum Type for a Period3EXTERNAL_KEYDefault Work Rule IDnvarchar200
31WFAFC_BUDGET_SETBudget constraint2EXTERNAL_KEYBudget constraintnvarchar200
32WFAFC_FCSTCFGNForecasting Configuration Parameters for Location Profile4EXTERNAL_KEYExternal key for forecast parameternvarchar200
33WFAFC_FCSTCFGN_TSeniority Date Profile: External Key Text2EXTERNAL_KEYExternal key for forecast parameternvarchar200
TOPWorkforce Management Core
34WFD_ATS_000General Attribute Set data4EXTERNAL_KEYExternal Keynvarchar320
35WFMC_COSTNCosts: External key2EXTERNAL_KEYSchedule Priority IDnvarchar200
36WFMC_COSTN_DCosts3EXTERNAL_KEYSchedule Priority IDnvarchar200
37WFMC_COSTN_TCosts: External Key Text2EXTERNAL_KEYSchedule Priority IDnvarchar200
38WFMC_DAYSHIFTNDay Shift Definition4EXTERNAL_KEYWeek Breaker IDnvarchar200
39WFMC_DAYSHIFTN_TWeek/day breaker: External Key Text2EXTERNAL_KEYWeek Breaker IDnvarchar200
40WFMC_LOCSETTNGeneral Location Settings3EXTERNAL_KEYExternal Key for General Location Settingsnvarchar200
41WFMC_LOCSETTN_TGen. Location Settings Translation Table2EXTERNAL_KEYExternal Key for General Location Settingsnvarchar200
42WFMC_SCHDEXCPNSchedule Exceptions: External key2EXTERNAL_KEYSchedule Exceptions IDnvarchar200
43WFMC_SCHDEXCPN_DSchedule Exceptions3EXTERNAL_KEYSchedule Exceptions IDnvarchar200
44WFMC_SCHDEXCPN_TSchedule Exceptions: External Key Text2EXTERNAL_KEYSchedule Exceptions IDnvarchar200
45WFMC_SNPRFNSeniority Date Profile4EXTERNAL_KEYSeniority Date Preference IDnvarchar200
46WFMC_SNPRFN_TSeniority Date Profile: External Key Text2EXTERNAL_KEYSeniority Date Preference IDnvarchar200
47WFMC_WKNDDAYSNWeekend Days4EXTERNAL_KEYWeekend Days IDnvarchar200
48WFMC_WKNDDAYSN_TWeekend Days: External Key Text2EXTERNAL_KEYWeekend Days IDnvarchar200
49WFMC_WKRLDFLTNDefault work rules : External key2EXTERNAL_KEYExternal key for default work rulesnvarchar200
50WFMC_WKRLDFLTN_DWork Rules Default3EXTERNAL_KEYExternal key for default work rulesnvarchar200
51WFMC_WKRLDFLTN_TDefault work rules: External Key Text2EXTERNAL_KEYExternal key for default work rulesnvarchar200
52WFMC_WKRLINTVN_DWork Rule Interval3EXTERNAL_KEYExternal key for default work rulesnvarchar200
53WFMFC_BUDGET_SETBudget constraint2EXTERNAL_KEYBudget constraintnvarchar200
54WFMFC_FCSTCFGNForecasting Configuration Parameters for Location Profile4EXTERNAL_KEYExternal key for forecast parameternvarchar200
55WFMFC_FCSTCFGN_TSeniority Date Profile: External Key Text2EXTERNAL_KEYExternal key for forecast parameternvarchar200