WFAC_DFTSETGRP SAP (Default Settings Group) Table details

Dictionary Type: Table
Description: Default Settings Group




ABAP Code to SELECT data from WFAC_DFTSETGRP
Related tables to WFAC_DFTSETGRP
Access table WFAC_DFTSETGRP




Table field list including key, data, relationships and ABAP select examples

WFAC_DFTSETGRP is a standard SAP Table which is used to store Default Settings Group data and is available within R/3 SAP systems depending on the version and release level.

The WFAC_DFTSETGRP table consists of various fields, each holding specific information or linking keys about Default Settings Group data available in SAP. These include MANDT (Client), LOCATION_TYPE (Location Profile), DFTSET_GRP_ID (Default Settings Group), START_DATE (Start Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = WFAC_DFTSETGRP_T


SAP WFAC_DFTSETGRP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LOCATION_TYPELocation Profile WFA_LOCATION_TYPECHAR20Assigned to domainALPHAWFA_LOCATION_TYPE
DFTSET_GRP_IDDefault Settings Group WFA_DFTSET_GRP_IDCHAR20ALPHAWFA_DFTSET_GRP_ID
START_DATEStart Date WFA_BEGDATEDATS8
END_DATEEnd Date WFA_ENDDATEDATS8
PAYCLASS_IDCost Profile ID WFACFG_PAYCLS_IDCHAR20WFAC_PAYCLASSALPHAWFA_PAYCLS_ID
WKRLTEMPIDWork Rule Template Set ID WFA_WKRLTEMPIDCHAR20WFAC_WKRLTEMPNALPHAWFA_WKRLTEMPID
BREAKRULESETIDBreak Rule Set ID WFA_BREAKRULESETCHAR20WFAC_BRKRULSETALPHAWFA_BREAKRULESET_ID
PAYTYPEPay Type for Groups WFA_PAYTYPENUMC2WFA_PAYTYPE
AGENT_TYPEEmployee Type WFA_AGENT_TYPENUMC2WFA_EMPTYPE
DFLTDefault Flag WFA_DEFAULTCHAR1WFA_BOOLEAN
MIN_AGEMinimum Age WFA_MIN_AGEINT13WFA_AGE
MAX_AGEMaximum Age WFA_MAX_AGEINT13WFA_AGE
AGE_QUAL_IDAge Qualifier ID WFA_AGE_QUAL_IDCHAR20WFAC_AGE_QUALALPHAWFA_AGE_QUAL_ID
AVAIL_TMP_IDAvailability Template ID WFA_AVAIL_TMP_IDCHAR20WFAC_AVAIL_TMPALPHAWFA_AVAIL_TMP_ID
RESTRPROF_IDRestriction Profile ID WFA_TM_TCA_CONFIG_RESTRPRF_IDCHAR20WFATM_RSTR_PRFWFATM_TCA_CONFIG_RESTRPRF_ID
CONTRACT_EMPContract Employee WFA_CONTRACT_EMP_FLAGCHAR1WFA_BOOLEAN
CALC_PROF_IDiTime Clock Calculation Profile ID ITC_CALCPRF_IDCHAR20ITC_CALC_PRFWFA_PAR_EXTERNAL_ID
EXCPN_PROF_IDException Profile ID ITC_EXCPNPRF_IDCHAR20ITC_PNCH_EXCPNWFA_PAR_EXTERNAL_ID

Key field Non-key field



How do I retrieve data from SAP table WFAC_DFTSETGRP using ABAP code

The following ABAP code Example will allow you to do a basic selection on WFAC_DFTSETGRP to SELECT all data from the table
DATA: WA_WFAC_DFTSETGRP TYPE WFAC_DFTSETGRP.

SELECT SINGLE *
FROM WFAC_DFTSETGRP
INTO CORRESPONDING FIELDS OF WA_WFAC_DFTSETGRP
WHERE...

How to access SAP table WFAC_DFTSETGRP

Within an ECC or HANA version of SAP you can also view further information about WFAC_DFTSETGRP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!