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

Home | ERP 6.0  | WRFT_ACT_PROF
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ACT_PROFActivity Profile for PO Controllingnvarchar40CHAR(N' ')NoWRF_PCTR_ACT_PROF Allow NULL? 
3MONITOR_ACTIVEIndicator - Monitoring Activechar10CHAR(N' ')YesWRF_PCTR_MONITORING_ACTIVE Allow NULL? 
4DNG_AWDIndicator: Reminder Allowedchar10CHAR(N' ')YesWRF_PCTR_DNG_ALLWD Allow NULL? 
5CNCL_ANC_AWDIndicator: Cancellation Threat Allowedchar10CHAR(N' ')YesWRF_PCTR_CNCL_ANCMT_ALLWD Allow NULL? 
6CNCL_AWDIndicator: Cancellation Allowedchar10CHAR(N' ')YesWRF_PCTR_CNCL_ALLWD Allow NULL? 
7CNCL_AUTOIndicator: Carry Out Cancellation Automaticallychar10CHAR(N' ')YesWRF_PCTR_CNCL_AUTO Allow NULL? 
8CNCL_AF_ANCIndicator: Only Allow Cancellation After Cancellation Threatchar10CHAR(N' ')YesWRF_PCTR_CNCL_AFTER_ANCMT Allow NULL? 
9DNG_1_AUTOIndicator: Send First Reminder Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_1_AUTO Allow NULL? 
10DNG_2_AUTOIndicator: Send Second Reminder Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_2_AUTO Allow NULL? 
11DNG_3_AUTOIndicator: Send Third Reminder Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_3_AUTO Allow NULL? 
12DNG_G3_AUTOIndicator: Send Reminders >3 Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_G3_AUTO Allow NULL? 
13DATE_SHIFT_AWDIndicator: Date Shift Allowedchar10CHAR(N' ')YesWRF_PCTR_DATE_SHIFT_ALLWD Allow NULL? 
14DATE_SHFT_AUTOIndicator: Carry Out Date Shift Automaticallychar10CHAR(N' ')YesWRF_PCTR_DATE_SHIFT_AUTO Allow NULL? 
15STAT_DAT_SHIFTIndicator: Shift Statistical Datechar10CHAR(N' ')YesWRF_PCTR_STAT_DAT_SHIFT Allow NULL? 
16DEFAULT_DISTDefault Interval for Date Shiftdecimal30DEC((0))YesWRF_PSCD_DEFAULT_DIST
17N_DNG_CNCL_ANCNumber of Reminders Before Cancellation Threatnvarchar20NUMC(N'00')YesWRF_PCTR_NMB_DNG_CNCL_ANCMT Allow NULL? 
18N_DNG_CNCLNumber of Reminders Before Cancellationnvarchar20NUMC(N'00')YesWRF_PCTR_NMB_DNG_CNCL Allow NULL? 
19QTY_MONITORMonitor Quantity Variancechar10CHAR(N' ')YesWRF_PCTR_QTY_MONITORING Allow NULL? 
20QTY_OVERDELMonitor Overdeliverychar10CHAR(N' ')YesWRF_PCTR_OVERDELIVERY Allow NULL? 
21QTY_UNDERDELMonitor Underdeliverychar10CHAR(N' ')YesWRF_PCTR_UNDERDELIVERY Allow NULL? 
22REM_QTY_AUTOProcess Remaining Quantity Automaticallychar10CHAR(N' ')YesWRF_PCTR_REM_QTY_AUTO Allow NULL? 
23REM_QTY_PR_TYPProcurement Controlling: Processing Type Remaining Quantitychar10CHAR(N' ')YesWRF_PCTR_REM_QTY_PROC_TYPE Allow NULL? 
24DATESHIFT_NUMNumber of Current Date Shiftsdecimal30DEC((0))YesWRF_PCTR_DS_NUMBER
25DNG_AWD_XFixed-Date Purchase: Indicator - Reminder Allowedchar10CHAR(N' ')YesWRF_PCTR_DNG_ALLWD_X Allow NULL? 
26CNCL_ANC_AWD_XFixed-Date Purchase: Cancellation Threat ID Allowedchar10CHAR(N' ')YesWRF_PCTR_CNCL_ANCMT_ALLWD_X Allow NULL? 
27CNCL_AWD_XFixed-Date Purchase: Cancellation Indicator Allowedchar10CHAR(N' ')YesWRF_PCTR_CNCL_ALLWD_X Allow NULL? 
28CNCL_AUTO_XFixed-Date Purchase: Carry Out Cancellation Automaticallychar10CHAR(N' ')YesWRF_PCTR_CNCL_AUTO_X Allow NULL? 
29CNCL_AF_ANC_XFixed-Date Purchase: Cancellation Only After Cancell. Threatchar10CHAR(N' ')YesWRF_PCTR_CNCL_AFTER_ANCMT_X Allow NULL? 
30DNG_1_AUTO_XFixed-Date Purchase: Send First Reminder Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_1_AUTO_X Allow NULL? 
31DNG_2_AUTO_XFixed-Date Purchase: Send Second Reminder Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_2_AUTO_X Allow NULL? 
32DNG_3_AUTO_XFixed-Date Purchase: Send Third Reminder Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_3_AUTO_X Allow NULL? 
33DNG_G3_AUTO_XFixed-Date Purchase: After 3rd Reminder, Send Automaticallychar10CHAR(N' ')YesWRF_PCTR_DNG_G3_AUTO_X Allow NULL? 
34DATE_SHIFT_AWD_XIndicator: Date Shift Allowedchar10CHAR(N' ')YesWRF_PCTR_DATE_SHIFT_ALLWD_X Allow NULL? 
35DATE_SHFT_AUTO_XFixed-Date Purchase: Carry Out Date Shift Automaticallychar10CHAR(N' ')YesWRF_PCTR_DATE_SHIFT_AUTO_X Allow NULL? 
36STAT_DAT_SHIFT_XFixed-Date Purchase: Shift Statistical Datechar10CHAR(N' ')YesWRF_PCTR_STAT_DAT_SHIFT_X Allow NULL? 
37DEFAULT_DIST_XFixed-Date Purchase: Default Interval for Date Shiftdecimal30DEC((0))YesWRF_PSCD_DEFAULT_DIST_X
38N_DNG_CNCL_ANC_XFixed-Date Purchase: No. of Reminders Before Cancell. Threatnvarchar20NUMC(N'00')YesWRF_PCTR_NMB_DNG_CNCL_ANCMT_X Allow NULL? 
39N_DNG_CNCL_XFixed-Date Purchase: Number of Reminders Before Cancellationnvarchar20NUMC(N'00')YesWRF_PCTR_NMB_DNG_CNCL_X Allow NULL? 
40QTY_MONITOR_XMonitor Quantity Variance Fixed-Date Purchasechar10CHAR(N' ')YesWRF_PCTR_QTY_MONITORING_X Allow NULL? 
41QTY_OVERDEL_XMonitor Overdelivery Fixed-Date Purchasechar10CHAR(N' ')YesWRF_PCTR_OVERDELIVERY_X Allow NULL? 
42QTY_UNDERDEL_XMonitor Underdelivery Fixed-Date Purchasechar10CHAR(N' ')YesWRF_PCTR_UNDERDELIVERY_X Allow NULL? 
43REM_QTY_AUTO_XProcess Remaining Quantity Automatically Fixed-Date Purchasechar10CHAR(N' ')YesWRF_PCTR_REM_QTY_AUTO_X Allow NULL? 
44REM_QTY_PR_TYP_XProcurement Controlling: Procesing Type Rem. Qty Fixed-Datechar10CHAR(N' ')YesWRF_PCTR_REM_QTY_PROC_TYPE_X Allow NULL? 
45DATESHIFT_NUM_XFixed-Date Purchase: Number of Current Date Postponementsdecimal30DEC((0))YesWRF_PCTR_DS_NUMBER_X
NamePrimaryUniqueTypeColumns
WRFT_ACT_PROF~0YesYesCLUSTEREDMANDT, ACT_PROF

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy