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
Materials Management :: Purchasing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WRFT_ACT_PROF451Activity ProfilePurchasing
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, ACT_PROF, MONITOR_ACTIVE, DNG_AWD, CNCL_ANC_AWD, CNCL_AWD, CNCL_AUTO, CNCL_AF_ANC, DNG_1_AUTO, DNG_2_AUTO, DNG_3_AUTO, DNG_G3_AUTO, DATE_SHIFT_AWD, DATE_SHFT_AUTO, STAT_DAT_SHIFT, DEFAULT_DIST, N_DNG_CNCL_ANC, N_DNG_CNCL, QTY_MONITOR, QTY_OVERDEL, QTY_UNDERDEL, REM_QTY_AUTO, REM_QTY_PR_TYP, DATESHIFT_NUM, DNG_AWD_X, CNCL_ANC_AWD_X, CNCL_AWD_X, CNCL_AUTO_X, CNCL_AF_ANC_X, DNG_1_AUTO_X, DNG_2_AUTO_X, DNG_3_AUTO_X, DNG_G3_AUTO_X, DATE_SHIFT_AWD_X, DATE_SHFT_AUTO_X, STAT_DAT_SHIFT_X, DEFAULT_DIST_X, N_DNG_CNCL_ANC_X, N_DNG_CNCL_X, QTY_MONITOR_X, QTY_OVERDEL_X, QTY_UNDERDEL_X, REM_QTY_AUTO_X, REM_QTY_PR_TYP_X, DATESHIFT_NUM_X FROM WRFT_ACT_PROF
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2ACT_PROFActivity Profile for PO Controllingnvarchar40 Allow NULL? 
3MONITOR_ACTIVEIndicator - Monitoring Activechar10 Allow NULL? 
4DNG_AWDIndicator: Reminder Allowedchar10 Allow NULL? 
5CNCL_ANC_AWDIndicator: Cancellation Threat Allowedchar10 Allow NULL? 
6CNCL_AWDIndicator: Cancellation Allowedchar10 Allow NULL? 
7CNCL_AUTOIndicator: Carry Out Cancellation Automaticallychar10 Allow NULL? 
8CNCL_AF_ANCIndicator: Only Allow Cancellation After Cancellation Threatchar10 Allow NULL? 
9DNG_1_AUTOIndicator: Send First Reminder Automaticallychar10 Allow NULL? 
10DNG_2_AUTOIndicator: Send Second Reminder Automaticallychar10 Allow NULL? 
11DNG_3_AUTOIndicator: Send Third Reminder Automaticallychar10 Allow NULL? 
12DNG_G3_AUTOIndicator: Send Reminders >3 Automaticallychar10 Allow NULL? 
13DATE_SHIFT_AWDIndicator: Date Shift Allowedchar10 Allow NULL? 
14DATE_SHFT_AUTOIndicator: Carry Out Date Shift Automaticallychar10 Allow NULL? 
15STAT_DAT_SHIFTIndicator: Shift Statistical Datechar10 Allow NULL? 
16DEFAULT_DISTDefault Interval for Date Shiftdecimal30
17N_DNG_CNCL_ANCNumber of Reminders Before Cancellation Threatnvarchar20 Allow NULL? 
18N_DNG_CNCLNumber of Reminders Before Cancellationnvarchar20 Allow NULL? 
19QTY_MONITORMonitor Quantity Variancechar10 Allow NULL? 
20QTY_OVERDELMonitor Overdeliverychar10 Allow NULL? 
21QTY_UNDERDELMonitor Underdeliverychar10 Allow NULL? 
22REM_QTY_AUTOProcess Remaining Quantity Automaticallychar10 Allow NULL? 
23REM_QTY_PR_TYPProcurement Controlling: Processing Type Remaining Quantitychar10 Allow NULL? 
24DATESHIFT_NUMNumber of Current Date Shiftsdecimal30
25DNG_AWD_XFixed-Date Purchase: Indicator - Reminder Allowedchar10 Allow NULL? 
26CNCL_ANC_AWD_XFixed-Date Purchase: Cancellation Threat ID Allowedchar10 Allow NULL? 
27CNCL_AWD_XFixed-Date Purchase: Cancellation Indicator Allowedchar10 Allow NULL? 
28CNCL_AUTO_XFixed-Date Purchase: Carry Out Cancellation Automaticallychar10 Allow NULL? 
29CNCL_AF_ANC_XFixed-Date Purchase: Cancellation Only After Cancell. Threatchar10 Allow NULL? 
30DNG_1_AUTO_XFixed-Date Purchase: Send First Reminder Automaticallychar10 Allow NULL? 
31DNG_2_AUTO_XFixed-Date Purchase: Send Second Reminder Automaticallychar10 Allow NULL? 
32DNG_3_AUTO_XFixed-Date Purchase: Send Third Reminder Automaticallychar10 Allow NULL? 
33DNG_G3_AUTO_XFixed-Date Purchase: After 3rd Reminder, Send Automaticallychar10 Allow NULL? 
34DATE_SHIFT_AWD_XIndicator: Date Shift Allowedchar10 Allow NULL? 
35DATE_SHFT_AUTO_XFixed-Date Purchase: Carry Out Date Shift Automaticallychar10 Allow NULL? 
36STAT_DAT_SHIFT_XFixed-Date Purchase: Shift Statistical Datechar10 Allow NULL? 
37DEFAULT_DIST_XFixed-Date Purchase: Default Interval for Date Shiftdecimal30
38N_DNG_CNCL_ANC_XFixed-Date Purchase: No. of Reminders Before Cancell. Threatnvarchar20 Allow NULL? 
39N_DNG_CNCL_XFixed-Date Purchase: Number of Reminders Before Cancellationnvarchar20 Allow NULL? 
40QTY_MONITOR_XMonitor Quantity Variance Fixed-Date Purchasechar10 Allow NULL? 
41QTY_OVERDEL_XMonitor Overdelivery Fixed-Date Purchasechar10 Allow NULL? 
42QTY_UNDERDEL_XMonitor Underdelivery Fixed-Date Purchasechar10 Allow NULL? 
43REM_QTY_AUTO_XProcess Remaining Quantity Automatically Fixed-Date Purchasechar10 Allow NULL? 
44REM_QTY_PR_TYP_XProcurement Controlling: Procesing Type Rem. Qty Fixed-Datechar10 Allow NULL? 
45DATESHIFT_NUM_XFixed-Date Purchase: Number of Current Date Postponementsdecimal30
NamePrimaryUniqueTypeColumns
WRFT_ACT_PROF~0YesYesCLUSTEREDMANDT, ACT_PROF