SAP WRFT_ACT_PROF Activity Profile Table
Overview
WRFT_ACT_PROF is a standard SAP S/4HANA table that stores Activity Profile data. There are total 45 fields in the WRFT_ACT_PROF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRFT_ACT_PROF belongs to Scheduling (LO-RFM-PUR-SCD) module and is located in the package Seasonal Procurement: Subject Area Scheduling (Part 2) (WRF_PRC_SCD_APPL2).
In addition, following links provide an overview of foreign key relationships, if any, that link WRFT_ACT_PROF to other SAP tables and standard CDS views available based on WRFT_ACT_PROF table in S/4HANA 2020.
Techincal Settings of WRFT_ACT_PROF
Below are technical details of the table WRFT_ACT_PROF
- Buffering switched on
- Full table is passed to buffer
- Storage type is Column Store
List of WRFT_ACT_PROF Fields
The following table gives you an overview of the fields available in WRFT_ACT_PROF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ACT_PROF | Activity Profile for PO Controlling | WRF_PCTR_ACT_PROF | CHAR | 4 | |
| MONITOR_ACTIVE | Indicator - Monitoring Active | WRF_PCTR_MONITORING_ACTIVE | CHAR | 1 | |
| DNG_AWD | Indicator: Reminder Allowed | WRF_PCTR_DNG_ALLWD | CHAR | 1 | |
| CNCL_ANC_AWD | Indicator: Cancellation Threat Allowed | WRF_PCTR_CNCL_ANCMT_ALLWD | CHAR | 1 | |
| CNCL_AWD | Indicator: Cancellation Allowed | WRF_PCTR_CNCL_ALLWD | CHAR | 1 | |
| CNCL_AUTO | Indicator: Carry Out Cancellation Automatically | WRF_PCTR_CNCL_AUTO | CHAR | 1 | |
| CNCL_AF_ANC | Indicator: Only Allow Cancellation After Cancellation Threat | WRF_PCTR_CNCL_AFTER_ANCMT | CHAR | 1 | |
| DNG_1_AUTO | Indicator: Send First Reminder Automatically | WRF_PCTR_DNG_1_AUTO | CHAR | 1 | |
| DNG_2_AUTO | Indicator: Send Second Reminder Automatically | WRF_PCTR_DNG_2_AUTO | CHAR | 1 | |
| DNG_3_AUTO | Indicator: Send Third Reminder Automatically | WRF_PCTR_DNG_3_AUTO | CHAR | 1 | |
| DNG_G3_AUTO | Indicator: Send Reminders >3 Automatically | WRF_PCTR_DNG_G3_AUTO | CHAR | 1 | |
| DATE_SHIFT_AWD | Indicator: Date Shift Allowed | WRF_PCTR_DATE_SHIFT_ALLWD | CHAR | 1 | |
| DATE_SHFT_AUTO | Indicator: Carry Out Date Shift Automatically | WRF_PCTR_DATE_SHIFT_AUTO | CHAR | 1 | |
| STAT_DAT_SHIFT | Indicator: Shift Statistical Date | WRF_PCTR_STAT_DAT_SHIFT | CHAR | 1 | |
| DEFAULT_DIST | Default Interval for Date Shift | WRF_PSCD_DEFAULT_DIST | DEC | 3 | |
| N_DNG_CNCL_ANC | Number of Reminders Before Cancellation Threat | WRF_PCTR_NMB_DNG_CNCL_ANCMT | NUMC | 2 | |
| N_DNG_CNCL | Number of Reminders Before Cancellation | WRF_PCTR_NMB_DNG_CNCL | NUMC | 2 | |
| QTY_MONITOR | Monitor Quantity Variance | WRF_PCTR_QTY_MONITORING | CHAR | 1 | |
| QTY_OVERDEL | Monitor Overdelivery | WRF_PCTR_OVERDELIVERY | CHAR | 1 | |
| QTY_UNDERDEL | Monitor Underdelivery | WRF_PCTR_UNDERDELIVERY | CHAR | 1 | |
| REM_QTY_AUTO | Process Remaining Quantity Automatically | WRF_PCTR_REM_QTY_AUTO | CHAR | 1 | |
| REM_QTY_PR_TYP | Procurement Controlling: Processing Type Remaining Quantity | WRF_PCTR_REM_QTY_PROC_TYPE | CHAR | 1 | |
| DATESHIFT_NUM | Number of Current Date Shifts | WRF_PCTR_DS_NUMBER | DEC | 3 | |
| DNG_AWD_X | Fixed-Date Purchase: Indicator - Reminder Allowed | WRF_PCTR_DNG_ALLWD_X | CHAR | 1 | |
| CNCL_ANC_AWD_X | Fixed-Date Purchase: Cancellation Threat ID Allowed | WRF_PCTR_CNCL_ANCMT_ALLWD_X | CHAR | 1 | |
| CNCL_AWD_X | Fixed-Date Purchase: Cancellation Indicator Allowed | WRF_PCTR_CNCL_ALLWD_X | CHAR | 1 | |
| CNCL_AUTO_X | Fixed-Date Purchase: Carry Out Cancellation Automatically | WRF_PCTR_CNCL_AUTO_X | CHAR | 1 | |
| CNCL_AF_ANC_X | Fixed-Date Purchase: Cancellation Only After Cancell. Threat | WRF_PCTR_CNCL_AFTER_ANCMT_X | CHAR | 1 | |
| DNG_1_AUTO_X | Fixed-Date Purchase: Send First Reminder Automatically | WRF_PCTR_DNG_1_AUTO_X | CHAR | 1 | |
| DNG_2_AUTO_X | Fixed-Date Purchase: Send Second Reminder Automatically | WRF_PCTR_DNG_2_AUTO_X | CHAR | 1 | |
| DNG_3_AUTO_X | Fixed-Date Purchase: Send Third Reminder Automatically | WRF_PCTR_DNG_3_AUTO_X | CHAR | 1 | |
| DNG_G3_AUTO_X | Fixed-Date Purchase: After 3rd Reminder Send Automatically | WRF_PCTR_DNG_G3_AUTO_X | CHAR | 1 | |
| DATE_SHIFT_AWD_X | Indicator: Date Shift Allowed | WRF_PCTR_DATE_SHIFT_ALLWD_X | CHAR | 1 | |
| DATE_SHFT_AUTO_X | Fixed-Date Purchase: Carry Out Date Shift Automatically | WRF_PCTR_DATE_SHIFT_AUTO_X | CHAR | 1 | |
| STAT_DAT_SHIFT_X | Fixed-Date Purchase: Shift Statistical Date | WRF_PCTR_STAT_DAT_SHIFT_X | CHAR | 1 | |
| DEFAULT_DIST_X | Fixed-Date Purchase: Default Interval for Date Shift | WRF_PSCD_DEFAULT_DIST_X | DEC | 3 | |
| N_DNG_CNCL_ANC_X | Fixed-Date Purchase: No. of Reminders Before Cancell. Threat | WRF_PCTR_NMB_DNG_CNCL_ANCMT_X | NUMC | 2 | |
| N_DNG_CNCL_X | Fixed-Date Purchase: Number of Reminders Before Cancellation | WRF_PCTR_NMB_DNG_CNCL_X | NUMC | 2 | |
| QTY_MONITOR_X | Monitor Quantity Variance Fixed-Date Purchase | WRF_PCTR_QTY_MONITORING_X | CHAR | 1 | |
| QTY_OVERDEL_X | Monitor Overdelivery Fixed-Date Purchase | WRF_PCTR_OVERDELIVERY_X | CHAR | 1 | |
| QTY_UNDERDEL_X | Monitor Underdelivery Fixed-Date Purchase | WRF_PCTR_UNDERDELIVERY_X | CHAR | 1 | |
| REM_QTY_AUTO_X | Process Remaining Quantity Automatically Fixed-Date Purchase | WRF_PCTR_REM_QTY_AUTO_X | CHAR | 1 | |
| REM_QTY_PR_TYP_X | Procurement Controlling: Procesing Type Rem. Qty Fixed-Date | WRF_PCTR_REM_QTY_PROC_TYPE_X | CHAR | 1 | |
| DATESHIFT_NUM_X | Fixed-Date Purchase: Number of Current Date Postponements | WRF_PCTR_DS_NUMBER_X | DEC | 3 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WRFT_ACT_PROF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRFT_ACT_PROF | MANDT | : | T000 |