Skip to main content

Target system

Omada Enterprise Services Import

Omada provides a number of Enterprise Services for reading, changing, creating and deleting data in SAP. The Enterprise Services can also be imported directly into SAP backend systems, such as SAP HCM, ECC, SRM, APO, and CRM.

The Omada Identity utilizes several components to provide connectivity to all SAP modules. These components are Omada SAP Management Agent (SAP MA), Omada Provisioning Service (OPS), and Omada Data Warehouse (ODW).

SAP ABAP Backend

As the first step in preparing the SAP backend, you must import the interfaces provided by Omada.

After installing the SAP Connectivity Interface, you will find the required SAP Transport Requests in the folder C:\Program Files\Omada Identity Suite\Omada SAP Connectivity Interface\SAP Transport Requests.

Transports for SAP 4.7 systems can be found in the folder C:\Program Files\Omada Identity Suite\Omada SAP Connectivity Interface\SAP 4.x Transport Request. For more information about SAP 4.7, see SAP 4.7 backend.

An SAP Basis Administrator would be able to import the Transport Requests into the target SAP system.

The following objects are only relevant for SAP HCM and must therefore only be imported into the SAP HCM system(s):

  • HR Org. Units
  • Org. Positions
  • Cost Centers
  • Company Codes
  • Employees
  • Locations

The following objects are required for the synchronizing and provisioning of Users and Roles and must therefore be imported into all SAP systems:

  • Users
  • Password Reset
  • Roles
  • Profiles *
  • Transaction Codes *

* Profiles and Transaction Codes are bundled into one Transport Request together with Roles as there are dependencies between the objects. However, you do not have to generate web services for these objects if you do not plan to synchronize them.

The below table provides an overview of all objects supported by the SAP Connectivity Interface including the internal names of the services as they appear in transaction SOAMANAGER. The table also shows the corresponding SAP Transport Request.

SAP ObjectName (SOAMANAGER)OperationTransport Request
EmployeesABAP_EMPL_MOD_ReturnChange existing EmployeeED1K900517
EmployeesABAP_EMPL_GET_SendRead all EmployeesED1K900517
EmployeesDependent on ABAP_EMPL_GET_SENDInitial extract configuration rulesED1K900475
Org. UnitsABAP_HR_ORGUNIT_SendRead all Organizational UnitsED1K900502
LocationsABAP_HR_PERS_AREA_SendRead all LocationsED1K900502
Sub LocationsABAP_HR_PERS_SUB_AREA_SendRead all Sub LocationsED1K900502
Org. PositionsABAP_HR_ORGPOS_SendRead all PositionsED1K900502
ED1K900223
UsersABAP_USER_GET_SendRead all UsersED1K900519
UsersABAP_USER_CRE_SendCreate User (Data and Role Assignments)ED1K900519
UsersABAP_USER_MOD_SendChange existing user (Data and Role Assignments)ED1K900519
UsersABAP_USER_REM_SendDelete UserED1K900519
UsersABAP_USER_PWCH_SendChange PasswordED1K900519
UsersABAP_OPS_USER_PROFILE_DELTA_SendUpdate Users Profile AssignmentsED1K900519
UsersABAP_OPS_USER_ROLE_DELTA_SendUpdate Users Role AssignmentsED1K900519
UsersABAP_USER_GET_SINGLE_SendRead a single userED1K900519
RolesABAP_AUTH_ROLES_TCODES_SendRead all SAP RolesED1K900498
ProfilesABAP_AUTH_PROFILE_SendRead all SAP ProfilesED1K900498
Transaction CodesABAP_AUTH_TCODES_SendRead all Transaction CodesED1K900498
Company CodeABAP_FICO_CCODE_SendRead all Company CodesED1K900500
Cost CentersABAP_FICO_COSTC_SendRead all Cost CentersED1K900500

SAP 4.7 backend

Separate transports are provided for SAP 4.7 systems. However, web services with an SAP 4.7 backend must be provided through SAP PI.

Prerequisites

Before you start to generate the Web services for the interfaces or object types, you must fulfill the following prerequisites:

  • Activate the required services in transaction SICF:
    • sap/bc/webdynpro/sap/APPL_SOAP_MANAGEMENT
    • o sap/bc/srt (including sub-nodes)
  • Omada SAP Transport Requests have been imported with the ABAP Proxies.

Minimum required permissions

SAP Connectivity in Omada Identity requires the following minimum permissions to work correctly.

Access to run transaction code SOAMANAGER in the backend system. The Support Package level is SAP Basis and ABA 14 (NW 7.0).

Required Authorizations in SAP

For installing and configuring the Omada SAP MA package, Omada Data Warehouse (ODW), and Omada Provisioning Service (OPS), you can use the SAP Connectivity Interface standard roles.

For the SAP ECC system:

  • Y_OMADA_SAPMA_DEVELOPER_ECC
  • Y_OMADA_SAPMA_CONSUMER_ECC

The two SAP Connectivity Interface composite roles for developers enable you to administer and configure service providers and consumer proxies for your local backend. The roles provide only normal SAP developer system access for the SAP backend.

The consumer role is to be assigned to the user used by the management agent, OPS, and ODW, and who connects to SAP and reads/changes/creates objects in SAP.

The roles are delivered as SAP Transport Requests. After installing the SAP Connectivity Interface, you can find the transport request files at the following location:

C:\Program Files\Omada Identity Suite\Omada SAP Connectivity Interface\SAP ECC\Omadas SAP Transport Request.

Ask the SAP Basis Administrator to import the Transport Requests into the customer's SAP system.

SAP RoleTransport Request
Y_OMADA_SAPMA_DEVELOPER_ECCED1K900513
Y_OMADA_SAPMA_CONSUMER_ECCED1K900513
Roles details

Y_OMADA_SAPMA_DEVELOPER_ECC

The SAP ECC composite role, Y_OMADA_SAPMA_DEVELOPER_ECC, contains the following single roles:

Role nameDescription
Y_OMADA_SAPMA_CONSUMER_ECCMaster role for Omada SAP MA, OPS, and ODW
Y_OMADA_SAPMA_WEBS_ADMINWeb Service Administrator
Y_OMADA_SAPMA_WEBS_ADMIN_BIZUser Role for Business Administrator
Y_OMADA_SAPMA_WEBS_ADMIN_TECStandard Role for Technical Administration of Web Services
Y_OMADA_SAPMA_WEBS_CONSUMERWeb Service Consumer
Y_OMADA_SAPMA_WEBS_DEBUGGERTemplate Role for Web Service Debugger
Y_OMADA_SAPMA_WEBS_OBSERVERUser Role for Viewing All Web Service Information
Y_OMADA_SAPMA_WEB_SERVICE_USERPattern Role for Web Service Runtime Background User

Y_OMADA_SAPMA_CONSUMER_ECC

The SAP ECC role, Y_OMADA_SAPMA_CONSUMER_ECC is a single role which contains all required authorizations for the SAP MA user.

The Transport Requests are client dependent so remember to import into relevant clients from which data is to be synchronized.

Network requirements

For the Omada SAP Connectivity, the following default network ports are required to be open in firewalls.

The TCP/IP ports used by the SAP system are customer specific, typically the SAP Basic administrator can provide this information.

Target system configuration

Here you can find information on how to properly configure the connectivity in the SAP system.

Generate Web Services using SOAMANAGER

  1. Start transaction SOAMANAGER in the SAP backend where you want to generate the Web service. Your standard browser will open (Internet Explorer 11 is shown below):

  2. Open the Service Administration tab and click the Web Service Configuration link.

  3. Set up the following search criteria:

    • Search by: Object Name
    • Search Criteria: contains
    • Search Pattern: /OMADA*
  4. Click the Search button to show the search results.

  5. Choose the relevant interface (see the information in Table 1) by clicking it.

  6. Click the Create Service button.

  7. Enter the Service Name, Description, and Binding Name. Make sure that the names and description reflect the interface that you have chosen. To confirm, click the Next button.

  8. Under the Authentication Settings, Transport Channel Authentication, tick the User ID/Password box, and then click the Next button.

  9. There is nothing to configure in the step SOAP Protocol, click the Next button.

  10. There is nothing to configure in the step Operation Settings, click the Finish buttons.

  11. You can now see the new service and the binding that you have generated.

  12. Now you have to find the corresponding Web service and link to it. In the same screen, click the Open Binding WSDL Generation icon.

  13. Click the Open WSDL document icon for the selected binding.

  14. The WSDL is now shown in your standard browser:

You will require the URL later on as it requires copying into the configuration file for the Omada SAP Web Services MA.

SAP HCM Interface

The SAP HCM interface extracts the identity management relevant information that are related to the identities stored in SAP. The frequently used parameters or information that drive access and provisioning in an identity management solution are provided out of the box.

The interface enables you to carry out a full or delta extract of the identities found in SAP.

Start screen for extracting identities

Delta_date

The solution offers the option to perform either a full or a delta export of identities. You can limit the extract to only capture identities which have been changed as from a specific date. You can do so by entering a date in the Delta_date field using the format DD.MM.YYYY.

If you leave the Delta_date field blank, the BAPI will carry out a full extract of the identities which are active in the SAP solution. By default, the interface is called through MIM with no date.

The solution detects the changes by investigating the records in the SAP infotype tables which are specified in the /OMADA/DLTA_COND customizing table.

The identities are extracted to an internal table called SAPHREMPLOYEEDATA. The table fields are defined in a structure which is only used by this function module. The structure is called ZHRIDENTITYDATA and the predefined fields are listed in the General config section.

The logic makes use of a method (actually a function module) which is included in the SAP standard installation. The method is called 'BAPI_EMPLOYEE_GETDATA' and retrieves data from several crucial infotypes (infotype 0001 - Org. Assignment, infotype 0002 - Personal Data, infotype 0032 - Internal Data, and infotype 0105 -- Communications).

These four infotypes do not normally cover all the relevant data needed. Therefore, logic has been added to retrieve the following:

  • Data from additional infotypes using the SAP standard function module HR_READ_INFOTYPE
  • Organizational structure data using the SAP standard function module RH_SETUP_TREE_TABLE
  • Text of the job and position using the SAP standard function module HR_READ_FOREIGN_OBJECT_TEXT
  • Company code data using the SAP standard function module BAPI_COMPANYCODE_GETDETAIL

SAP HCM background job scheduling

The Read all Employees service either returns information on all employees or only those that have had their information updated after a provided date (the delta date). Returning information on all employees, for example if no delta date is provided, takes a considerable amount of time to execute in environments with large numbers of employees. This can cause timeout errors from multiple places in the SAP stack.

For this reason, rather than computing the result for every call, the service returns results retrieved from a cache table, specifically table /OMADA/HRCACHE. The contents of this cache table need to be refreshed periodically by a background job. The suggested update interval is once per day.

The background job must be scheduled by an SAP administrator in transaction SM36. The report in question is /OMADA/UPDATEHRCACHE. Ad hoc cache updates can be performed by scheduling the report for immediate execution in transaction SM36. Should errors occur during the cache refresh, the job will be flagged red with status "Cancelled" in the background job list (transaction SM37). In this case, the job log will contain more information about why the job failed.

Note that if a delta date is provided in the web service call, the information will always be computed and returned synchronously. Cached data will only be returned if no delta date is provided.

Mapping, Conditions, and Exceptions

The following figure illustrates the three tables that manage and control what is extracted from the particular SAP HCM solution; Mapping, Conditions, and Exceptions.

MapCondExcep

  • Mapping: In the /OMADA/MAPPARAM customized table, you define which fields the solution is to extract data from and how the data is to be mapped to fields in the SAPHREMPLOYEEDATA output table. See the following section.
  • Conditions: This is the table you use to specify the conditions of the extract from SAPHREMPLOYEEDATA. See section /OMADA/XTRACTCND.
  • Exceptions: This is the table you use to specify exceptions which will prevent certain data from being extracted. See section /OMADA/XTRACT_XCE.
Fields to Extract

In the /OMADA/MAPPARAM customized table, you define which fields the solution is to extract data from and how the data is to be mapped to fields in the SAPHREMPLOYEEDATA output table. Based on the import parameter, the identities are extracted one by one. The image below shows the /OMADA/MAPPARAM customized table for mapping extracted data.

FieldsExteract

note

You can use transaction code /OMADA/CONFXHR to access the above maintenance screen.

In addition to the call of the standard function modules, you can also directly retrieve data from tables defined in SAP Dictionary. The mapping of data from these tables must also be defined in the /OMADA/MAPPARAM customized table. However, you must specify the actual call with the specific extract conditions in the /OMADA/XTRACTCND customized table.

Go back to the Mapping, Conditions, and Exceptions

Conditions for extract - /OMADA/XTRACTCND table

This is the table you use to specify the conditions of the extract from SAPHREMPLOYEEDATA.

ExtractCond

The extract is based on the content in the /OMADA/MAPPARAM table. This table comes with some predefined records. If you do not need one or more of the predefined records, you have to delete them from the table.

The extraction order is defined in the ORDEROFEXECUTION field. The ability to retrieve a value might require that other data is available. The order in which data is extracted is therefore of great importance. An incorrect order will lead to incorrect data selection.

Go back to the Mapping, Conditions, and Exceptions

Exception to extract - /OMADA/XTRCT_XCE table

Exceptions is the third tab in the view. This table also comes with predefined exceptions which you can activate by setting a checkmark in the fields in the Active column (the first column). You enter conditions to check whether the identity in question complies with the rules. If the identity complies with the rules, it is not extracted.

ExceptExtract

note

The predefined exceptions require that the synchronized Employees, must be Active and have the attribute PERNO populated - change to match customer requirements.

Maintain Exception Conditions

To specify a dynamic SQL call in ABAP, different parts of the statement can be built dynamically by code to allow more flexibility. This is not offering very good performance and is mostly discouraged for normal use. It can be used in a batch program being executed in the background to reduce the impact on the performance.

The general form of a dynamic SQL statement is:

SELECT [field] INTO TABLE <itab>

FROM [table]

WHERE [where-clause]

The dynamic parts of the statement are enclosed in brackets []. The <itab> is a pointer to an internal table for the resulting data.

  • The [field] is a string with a list of fields as they would be written in OpenSQL.
  • The [table] is the table specification – this can be a single table name or a join of tables including the join condition.
  • The [where-clause] is a string with the where clause using the same syntax as OpenSQL.

There are two limitations when using join of tables:

  • The first table in the join must be the same as Subject ID
  • Only fields from the table specified by Subject ID can be returned. This is because the internal table <itab> is created dynamically from the structure of that table.

Placeholders are named '%1' - '%9' and can be used to insert the value of a program variable. This is often not necessary as the where-clause should be written as a normal ABAP statement would be written. One example where it is necessary is when the value needs to be enclosed between quotation marks.

There is no mechanism to verify if a program variable is valid or if the syntax of the SQL statement is correct.

A note about the "Active" column. To deactivate a statement, all lines of that statement will have to be disabled. If a single line of the statement is marked as active, the whole statement is active. When a line of a statement is checked/unchecked the result will be that all lines get checked/unchecked.

The Delete Row functionality will remove the whole statement.

The CALL_TYPE and DYN_CONDITION are legacy columns that are not used, but remain to avoid deleting data of existing implementations.

How to create a new exception:

  1. Insert a new entry.

    NewExcept

  2. Enter the table in Subject ID and a Subject. The subject must be unique within the Subject ID.

    EnterSubject

  3. Select the new entry and click the edit SQL icon.

    SelectEntr

    This opens the Edit SQL statement window.

    SQLstate

    The "Table" field has already been filled with the table (from the "Subject ID").

  4. Enter the conditions and click Copy Changes.

    EditSQL

  5. The changes are saved.

    SavedExtr

Go back to the Mapping, Conditions, and Exceptions

Solution Extension to find start date

You can use transaction code /OMADA/UPD_STARTDATE to define which action type should update the start date of an employee, by default, action types Hiring HR505 and Re-Hire are used.

Configuration of Termination Types

You can use transaction code /OMADA/UPD_TERM_TYPE to maintain the termination actions which should trigger the TERMDATE property to be filled out. By default, personnel actions type '09' and '10' are used. If a personnel action with a type defined in this transaction is detected on an employee, we set the value for the TERMDATE property to the validfrom date of the previous personnel action. If no personnel action of the type Termination exists for an employee, the TERMDATE property is left blank.

Rules for dates used for conditions or exceptions - /OMADA/DYN_DATE table

This setting enables the customer to extract records with a valid to date in the past. This is relevant and required if an employee's valid to date is updated after the date has passed.

RulesExtr

General config - /OMADA/EXTRACT_C table

This setting is used to determine the Unique ID for the extract to table /OMADA/HRCACHE and thereby the anchor for the SAP MA.

Only employees with values in the selected anchor field will be written to the cache table.

This also drives the value of in the attribute Manager PersonnelNo.

PersonNomb

Initial configurations

The ED1K900475 transport which contains initial extract configuration rules defined by Omada for HR Identities Extraction.

It is recommended to only import the transport during the initial implementation of Omada SAP Connectivity Interface v5.0.

It must be imported only after import of a transport containing any of the versions of Omada SAP Connectivity Interface v5.0 - Employee Interfaces.

If you have defined any extraction rules (Fields, Conditions, Exceptions to extract) or defined rules for dates used for conditions or exceptions selection parameters and general configurations using TCode - /OMADA/CONFXHR then importing this transport will overwrite the configuration with the initial configuration rules provided by Omada for HR Identities extraction.

Implement BAdI in SAP ABAP backend system

BAdi is provided as an Enhancement option in the service interface. Customers have to implement the BAdi to suit the custom requirement. The interface outbound_processing should be implemented to enhance the output structure.

BAdi - /OMADA/EMPL_GET_SEND:

  • Interface - OUTBOUND_PROCESSING

    The screenshot below presents BAdi Code Snippet from the service interface method.

    Outbound

  • Interface -- DELTADATE_CHANGE

    The screenshot below presents BAdi Code Snippet from the extract program (FM {OMADA/GET_HR_IDENTITIES).

    InterfDelta

  • Interface -- BEFORE_FM_FIND_DATA_END

    The screenshot below presents BAdi Code Snippet from the extract program (FM {OMADA/GET_HR_IDENTITIES).

    InterfBefore

Additional information

ComponentComponent TypeData TypeLengthShort Description
INF02INITIALSINITSCHAR10Initials
INF02PERNOPERNR_DNUMC8Personnel Number
INF02PERIDPRDNICHAR20Personnel ID Number
HEADOFORG_UNITHROMLEADERCHAR1Head of Organizational Unit
INF709PERSONID_EXTPERSONID_EXTCHAR20External Person ID
INF00START_DATEBEGDADATS8Start Date
INF00END_DATEENDDADATS8End Date
INF00ACTIONTYPEMASSNCHAR2Action Type
INF00MASSGMASSGCHAR2Reason for Action
INF00EMPL_STATUSSTAT2CHAR1Employment Status
INF01POSITIONPLANSNUMC8Position
INF01POSITIONTXSTEXTCHAR40Object Name
INF01JOBSTELLNUMC8Job
INF01JOBTXSTLTXCHAR25Job Title
INF01COMP_CODEBUKRSCHAR4Company Code
INF01COMP_CODETXBUTXTCHAR25Name of Company Code or Company
INF01EGROUPPERSGCHAR1Employee Group
INF01ESUBGROUPPERSKCHAR2Employee Subgroup
INF01ORG_UNITORGEHNUMC8Organizational Unit
INF01ORGTXSHORTORGTXCHAR25Short Text of Organizational Unit
INF01ORGTXLONGSTEXTCHAR40Object Name
INF01PERS_AREAPERSACHAR4Personnel Area
INF01PERS_AREATXPBTXTCHAR30Personnel Area Text
INF01COSTCENTERKOSTLCHAR10Cost Center
INF01ANSVHANSVHCHAR2Work Contract
INF01BEGIN_DATE_NEXT_RECORDBEGDADATS8Start Date
INF01POSITION_NEXTPLANSNUMC8Position
INF01POSITIONTX_NEXTSTEXTCHAR40Object Name
INF01JOB_NEXTSTELLNUMC8Job
INF01JOBTX_NEXTSTLTXCHAR25Job Title
INF01ORG_UNIT_NEXTORGEHNUMC8Organizational Unit
INF01ORGTXSHORT_NEXTORGTXCHAR25Short Text of Organizational Unit
INF01ORGTXLONG_NEXTSTEXTCHAR40Object Name
INF01SUPERVISORAREAMSTBRCHAR8Supervisor Area
INF02FIRST_NAMEPAD_VORNACHAR40First Name
INF02LAST_NAMEPAD_NACHNCHAR40Last Name
INF02FULL_NAMEPAD_CNAMECHAR80Complete Name
INF02TITLETITELCHAR15Title
INF02NAMEAFFIXVORSWCHAR15Name Prefix
INF02NAME_PREFIXVORS2CHAR15Second Name Prefix
INF02NICK_NAMEPAD_RUFNMCHAR40Nickname
INF02MIDDLE_NAMEPAD_MIDNMCHAR40Middle Name
INF02GENDERGESCHCHAR1Gender Key
INF02ANREDANRDECHAR1Form-of-Address key
INF03FIRST_NAMEPAD_VORNACHAR40First Name
INF03LAST_NAMEPAD_NACHNCHAR40Last Name
INF06STREETPAD_STRASCHAR60Street and House Number
INF06CITYPAD_ORT01CHAR40City
INF06POSTAL_CODEPSTLZ_HRCHAR10Postal Code
INF06TELNRTELNRCHAR14Telephone Number
INF06COUNTRYLAND1CHAR3Country Key
INF06COM01COMKYCHAR4Communication Type
INF06NUM01COMNRCHAR20Communication Number
INF06COM02COMKYCHAR4Communication Type
INF06NUM02COMNRCHAR20Communication Number
INF06COM03COMKYCHAR4Communication Type
INF06NUM03COMNRCHAR20Communication Number
INF06COM04COMKYCHAR4Communication Type
INF06NUM04COMNRCHAR20Communication Number
INF06COM05COMKYCHAR4Communication Type
INF06NUM05COMNRCHAR20Communication Number
INF06COM06COMKYCHAR4Communication Type
INF06NUM06COMNRCHAR20Communication Number
INF32BLDING_NOGEBNRCHAR6Building Number
INF32ROOM_NODZIMNRCHAR6Room Number
INF32TEL01TELINCHAR5In-House Telephone Number
INF32TEL02TELINCHAR5In-House Telephone Number
INF32SUBAREABTRTLCHAR4Personnel Subarea
INF32SUBAREATXBTEXTCHAR20Text for stock type
INF32WAUSWWAUSWCHAR12Company ID
ORGBUILDBUILDCHAR8Building
ORGSTEXTSTEXTCHAR40Object Name
ORGCNAMECNAMECHAR25Address Supplement (c/o)
ORGSTRASPD_STRASCHAR30House Number and Street
ORGORT01KORTCHAR40City
ORGPSTLZPD_PSTLZCHAR10Postal Code
ORGLANDKLANDCHAR3Country
ORGSTRS2STRAS_GPCHAR35House number and street
ORGTELNRTELENRCHAR25Telephone Number
CSKTKTEXTKTEXTCHAR20General Name
CSKTLTEXTKLTXTCHAR40Description
HRR_INITSINITSCHAR10Initials
MGR_INITSINITSCHAR10Initials
MGR_PERNOPERNR_DNUMC8Personnel Number
MGR_EMAILAD_SMTPADRCHAR241E-Mail Address
PERSAREA_COMPANY_NAMENAME2CHAR30Name 2
PERSAREA_STREETSTRASCHAR30House number and street
PERSAREA_PO_BOXPFACHCHAR10PO Box
PERSAREA_POSTAL_CODEPSTLZCHAR10Postal Code
PERSAREA_CITYORT01CHAR25City
PERSAREA_COUNTRY_KEYLAND1CHAR3Country Key
PERSAREA_REGIONREGIOCHAR3Region (State, Province, County)
INFO40LOAN_OBJLEIHGCHAR4Object on loan
INFO40LOAN_OBJ_NAMELOBNRCHAR20Name of object on loan
INFO40LOAN_OBJ_NOANZNRDEC4Number of objects on loan
INFO40UNITPT_ZEINHCHAR3Time/Measurement Unit
INF105SMTPADRAD_SMTPADRCHAR241E-Mail Address
INF105USERIDAD_SMTPADRCHAR241E-Mail Address
INF105TLNMBR1AD_SMTPADRCHAR241E-Mail Address
INF105SUBTYPMAILAD_SMTPADRCHAR241E-Mail Address
ORGOTYPE, (Central Person)OTYPECHAR2Object Type
ORGOBJID, (Central Person)HROBJIDNUMC8Object ID
ORGSOBID, (Central Person)SOBIDCHAR45ID of Related Object
ORGBEGDA, (Central Person)BEGDADATS8Start Date
ORGENDDA, (Central Person)ENDDADATS8End Date
INF105BADGERCOMP_DCHAR6Company
SCLAS_F_AREA, (Functional Area)SYSIDCHAR30Communication ID/Number
SOBID_F_AREA, (Functional Area)SHORT_DCHAR12Object Abbreviation
ORGSHORT_F_AREA, (Functional Area)STEXTCHAR40Object Name
ORGSTEXT_F_AREA, (Functional Area)SCLASCHAR2Type of Related Object
ORGRCOMP_INTSOBIDCHAR45ID of Related Object
PERS_SUB_AREABTRTLCHAR4Personnel Subarea
INF105SUBTYPCELLSYSIDCHAR30Communication ID/Number
EMPLSTATUSTEXTTEXT40CHAR40Text
EMPLGROUPTEXTPGTXTCHAR20Name of Employee Group
PERSUBAREATEXTBTRTXCHAR15Personnel Subarea Text
ACTIONTYPETEXTMNTXTCHAR30Name of Action Type
EMPLSUBGRPTEXTPKTXTCHAR20Name of Employee Subgroup
SITEIDSYSIDCHAR30Communication ID/Number
MYACCESSIDSYSIDCHAR30Communication ID/Number
TERMDATEDATUMDATS8Date