SAP GRAC_BI_EXTRACT_TRANSACT_DATA Function Module for Transactional Data Extractors

Search SAP Function Modules

GRAC_BI_EXTRACT_TRANSACT_DATA is a standard grac bi extract transact data SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Transactional Data Extractors processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.

See here to view full function module documentation and code listing for grac bi extract transact data FM, simply by entering the name GRAC_BI_EXTRACT_TRANSACT_DATA into the relevant SAP transaction such as SE37 or SE38.

Function Group: GRAC_EXTRACTION
Program Name: SAPLGRAC_EXTRACTION
Main Program: SAPLGRAC_EXTRACTION
Appliation area: S
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:

Function GRAC_BI_EXTRACT_TRANSACT_DATA pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.

CALL FUNCTION 'GRAC_BI_EXTRACT_TRANSACT_DATA'"Transactional Data Extractors
  EXPORTING
   I_REQUNR =  "
*  I_ISOURCE =  "
*  I_MAXSIZE =  "
*  I_INITFLAG =  "
*  I_UPDMODE =  "
*  I_DATAPAKID =  "
*  I_PRIVATE_MODE =  "
*  I_CALLMODE =  "

TABLES
*  I_T_SELECT =  "
*  E_T_GRAC_S_BI_MITROLEORG_A =  "Extract of Role Org Mitigation Control assignments
*  E_T_GRAC_S_BI_ROLEPRMVL =  "Role Permission Violation
*  E_T_GRAC_S_BI_ROLEPRMVLEXT =  "Role Permission Violation Extension
*  E_T_GRAC_S_BI_USERACTVL =  "User Action Violation
*  E_T_GRAC_S_BI_USERACTVLEXT =  "User Action Violations for Extended Objects
*  E_T_GRAC_S_BI_USERCRPVL =  "User Critical Role/Profile Violation
*  E_T_GRAC_S_BI_USERMGMTSUM =  "User Management Total
*  E_T_GRAC_S_BI_USERMGVCOUNT =  "Management User Violation Count
*  E_T_GRAC_S_BI_USERPRMVL =  "User Permission Violation Table
*  E_T_GRAC_S_BI_USERPRMVLEXT =  "User Permission Violations for Extended Objects
*  I_T_FIELDS =  "
*  E_T_GRAC_S_BI_PROFILEPRMVL =  "Profile Permission Violation
*  E_T_GRAC_S_BI_PROFMGMTSUM =  "Profile Management Total
*  E_T_GRAC_S_BI_PROFMGVCOUNT =  "Profile Level Management  Violation Data
*  E_T_GRAC_S_BI_PROFPRMVLEXT =  "Profile Permission Violations for Extended Objects
*  E_T_GRAC_S_BI_ROLEACTVL =  "Role Action Violation Table
*  E_T_GRAC_S_BI_ROLEACTVLEXT =  "Role Action Violations for Extended Objects
*  E_T_GRAC_S_BI_HROBJACTVL =  "HR Object Action Violation Table
*  E_T_GRAC_S_BI_HROBJCRPVL =  "HR Object Critical Role/Profile Violation Table
*  E_T_GRAC_S_BI_HROBJPRMVL =  "User Permission Violation Table
*  E_T_GRAC_S_BI_MGALERTS =  "Management Alerts
*  E_T_GRAC_S_BI_PROFACTVLEXT =  "Profile Action Violations for Extended Objects
*  E_T_GRAC_S_BI_MGRISKD =  "Risk Analysis Mgmt Sum data  for Batch Risk Analysis.
*  E_T_GRAC_S_BI_MGRULECOUNT =  "Management Report Rule Count by Period and Connector.
*  E_T_GRAC_S_BI_PROFILEACTVL =  "Profile Action Violation Table
*  E_T_GRAC_S_BI_PROFILECRPVL =  "Profile Critical Role/Profile Violation Table
*  E_T_GRAC_S_BI_ROLECRPVL =  "Role Critical Role/Profile Violation Table
*  E_T_GRAC_S_BI_ROLEMGMTSUM =  "Role Management Total
*  E_T_GRAC_S_BI_ROLEMGVCOUNT =  "Role Level Management Violation Count
*  E_T_GRAC_S_BI_REQ_ITEM =  "Access Request Provisioning Item
*  E_T_GRAC_S_BI_ALACTLOG_A =  "Alerts Action Log
*  E_T_GRAC_S_BI_FF_LOG =  "Extarction of FF User Log
*  E_T_GRAC_S_BI_MITUSER_A =  "Extract of User Mitigation Control assignments
*  E_T_GRAC_S_BI_FF_ROLE_LOG =  "Extarction of FF Role Log
*  E_T_GRAC_S_BI_ROLE_USAGE_A =  "Extractor of Role Usage Attribute
*  E_T_GRAC_S_BI_ACTION_USAGE_A =  "Action Usage Extraction
*  E_T_GRAC_S_BI_FUNC_PERM_A =  "Function Action Permission relationship Attributes
*  E_T_GRAC_S_BI_MITUSERGP_A =  "Extract of User Group Mitigation Control assignments
*  E_T_GRAC_S_BI_MITUSERORG_A =  "Extract of User Org Mitigation Control assignments
*  E_T_GRAC_S_BI_MITOBJECT_A =  "Extract of Mitigation Control assignments
*  E_T_GRAC_S_BI_MITPROF_A =  "Extract of Profile Mitigation Control assignments
*  E_T_GRAC_S_BI_MITROLE_A =  "Extract of Role Mitigation Control assignments

EXCEPTIONS
   NO_MORE_DATA = 1    ERROR_PASSED_TO_MESS_HANDLER = 2 

.

IMPORTING Parameters details for GRAC_BI_EXTRACT_TRANSACT_DATA

I_REQUNR -

Data type: SBIWA_S_INTERFACE-REQUNR
Optional: No
Call by Reference: No ( called with pass by value option)

I_ISOURCE -

Data type: SBIWA_S_INTERFACE-ISOURCE
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_MAXSIZE -

Data type: SBIWA_S_INTERFACE-MAXSIZE
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_INITFLAG -

Data type: SBIWA_S_INTERFACE-INITFLAG
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_UPDMODE -

Data type: SBIWA_S_INTERFACE-UPDMODE
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_DATAPAKID -

Data type: SBIWA_S_INTERFACE-DATAPAKID
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_PRIVATE_MODE -

Data type:
Optional: Yes
Call by Reference: No ( called with pass by value option)

I_CALLMODE -

Data type: ROARCHD200-CALLMODE
Optional: Yes
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for GRAC_BI_EXTRACT_TRANSACT_DATA

I_T_SELECT -

Data type: SBIWA_T_SELECT
Optional: Yes
Call by Reference: No ( called with pass by value option)

E_T_GRAC_S_BI_MITROLEORG_A - Extract of Role Org Mitigation Control assignments

Data type: GRAC_S_BI_MITROLEORG_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLEPRMVL - Role Permission Violation

Data type: GRAC_S_BI_ROLEPRMVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLEPRMVLEXT - Role Permission Violation Extension

Data type: GRAC_S_BI_ROLEPRMVLEXT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERACTVL - User Action Violation

Data type: GRAC_S_BI_USERACTVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERACTVLEXT - User Action Violations for Extended Objects

Data type: GRAC_S_BI_USERACTVLEXT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERCRPVL - User Critical Role/Profile Violation

Data type: GRAC_S_BI_USERCRPVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERMGMTSUM - User Management Total

Data type: GRAC_S_BI_USERMGMTSUM
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERMGVCOUNT - Management User Violation Count

Data type: GRAC_S_BI_USERMGVCOUNT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERPRMVL - User Permission Violation Table

Data type: GRAC_S_BI_USERPRMVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_USERPRMVLEXT - User Permission Violations for Extended Objects

Data type: GRAC_S_BI_USERPRMVLEXT
Optional: Yes
Call by Reference: Yes

I_T_FIELDS -

Data type: SBIWA_T_FIELDS
Optional: Yes
Call by Reference: No ( called with pass by value option)

E_T_GRAC_S_BI_PROFILEPRMVL - Profile Permission Violation

Data type: GRAC_S_BI_PROFILEPRMVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_PROFMGMTSUM - Profile Management Total

Data type: GRAC_S_BI_PROFMGMTSUM
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_PROFMGVCOUNT - Profile Level Management Violation Data

Data type: GRAC_S_BI_PROFMGVCOUNT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_PROFPRMVLEXT - Profile Permission Violations for Extended Objects

Data type: GRAC_S_BI_PROFPRMVLEXT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLEACTVL - Role Action Violation Table

Data type: GRAC_S_BI_ROLEACTVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLEACTVLEXT - Role Action Violations for Extended Objects

Data type: GRAC_S_BI_ROLEACTVLEXT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_HROBJACTVL - HR Object Action Violation Table

Data type: GRAC_S_BI_HROBJACTVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_HROBJCRPVL - HR Object Critical Role/Profile Violation Table

Data type: GRAC_S_BI_HROBJCRPVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_HROBJPRMVL - User Permission Violation Table

Data type: GRAC_S_BI_HROBJPRMVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MGALERTS - Management Alerts

Data type: GRAC_S_BI_MGALERTS
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_PROFACTVLEXT - Profile Action Violations for Extended Objects

Data type: GRAC_S_BI_PROFACTVLEXT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MGRISKD - Risk Analysis Mgmt Sum data for Batch Risk Analysis.

Data type: GRAC_S_BI_MGRISKD
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MGRULECOUNT - Management Report Rule Count by Period and Connector.

Data type: GRAC_S_BI_MGRULECOUNT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_PROFILEACTVL - Profile Action Violation Table

Data type: GRAC_S_BI_PROFILEACTVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_PROFILECRPVL - Profile Critical Role/Profile Violation Table

Data type: GRAC_S_BI_PROFILECRPVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLECRPVL - Role Critical Role/Profile Violation Table

Data type: GRAC_S_BI_ROLECRPVL
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLEMGMTSUM - Role Management Total

Data type: GRAC_S_BI_ROLEMGMTSUM
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLEMGVCOUNT - Role Level Management Violation Count

Data type: GRAC_S_BI_ROLEMGVCOUNT
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_REQ_ITEM - Access Request Provisioning Item

Data type: GRAC_S_BI_REQ_ITEM
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ALACTLOG_A - Alerts Action Log

Data type: GRAC_S_BI_ALACTLOG_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_FF_LOG - Extarction of FF User Log

Data type: GRAC_S_BI_FF_LOG
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MITUSER_A - Extract of User Mitigation Control assignments

Data type: GRAC_S_BI_MITUSER_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_FF_ROLE_LOG - Extarction of FF Role Log

Data type: GRAC_S_BI_FF_ROLE_LOG
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ROLE_USAGE_A - Extractor of Role Usage Attribute

Data type: GRAC_S_BI_ROLE_USAGE_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_ACTION_USAGE_A - Action Usage Extraction

Data type: GRAC_S_BI_ACTION_USAGE_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_FUNC_PERM_A - Function Action Permission relationship Attributes

Data type: GRAC_S_BI_FUNC_PERM_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MITUSERGP_A - Extract of User Group Mitigation Control assignments

Data type: GRAC_S_BI_MITUSERGP_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MITUSERORG_A - Extract of User Org Mitigation Control assignments

Data type: GRAC_S_BI_MITUSERORG_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MITOBJECT_A - Extract of Mitigation Control assignments

Data type: GRAC_S_BI_MITOBJECT_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MITPROF_A - Extract of Profile Mitigation Control assignments

Data type: GRAC_S_BI_MITPROF_A
Optional: Yes
Call by Reference: Yes

E_T_GRAC_S_BI_MITROLE_A - Extract of Role Mitigation Control assignments

Data type: GRAC_S_BI_MITROLE_A
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

NO_MORE_DATA -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

ERROR_PASSED_TO_MESS_HANDLER -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for GRAC_BI_EXTRACT_TRANSACT_DATA Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

ABAP code using 7.40 inline data declarations to call FM GRAC_BI_EXTRACT_TRANSACT_DATA

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

Search for further information about these or an SAP related objects