Field-level Pre-population

 
 
The field-level pre-population is triggered by function /FLMHR/PRE_GLOBAL, which is called as part of the form-level pre-population.
 
There is no need to add field level pre-population in the FLM Wizard or add any INCLUDE statement at field level.
 

Configuration Table

Field-level pre-population is controlled using configuration table /FLMHR/FLD_CNTRL.
 
 
Customer Code
This is always required.

Form Type
If the same logic is used in multiple form types, this can be left blank in order to reduce the number of entries in this configuration table.

Version
This can also be left blank unless specific logic is required for a specific form version.
 
Status
This can also be left blank unless specific logic is required for a specific status.
 
Form Fieldname
This is the name of the field on the form to be pre-populated.
This can also include 'dummy' entries to store IDs such as Job, Position, Org Unit and Employee, which may not be on the form but are used to pre-populate other fields on the form.
If the form fieldname does not appear in the form schema it will be ignored, however forms with common fieldnames can be automatically pre-populated without addtional configuration.
 
Country Group
Used in scenarios where the same form is used across multiple countries, but different fields are required in different countries.
This is used to specify the country group where specific logic is required for that country and will replace any "global" entry with an identical table key.
 
No.
This is a counter field, a step number, used when several entries for the same field are used in the table.
For example, if there is one entry to control  the field pre-population but a different entry to control the field posting, then this counter would be used to give each entry a unique key.
 
Object Type
This is the HR object type (eg S, P etc) for the object stored in the Ref Fieldname
 
Ref Fieldname
This is the name of the field on the form (or a dummy field defined in this table) to store an object ID such as Position, Employee etc.
 
Priority
This is used to control the order of the pre-population logic which normally runs in HR infotype order 0000 to 9999.  This priorty is a number between 0 and 99.  Higher numbers are prioritised first.
For example you will need to read the PD relationship infotype 1001 to find a related object before reading infotype 1000 to read its descrition, so assign the 1001 entry a priority of 99.
 
Infotype
This is the source infotype for the data to be read.
 
Subtype
This is the source subtype for the data to be read.  (Optional)
This is also used to store relationships to be read for infotype 1001. (eg B008, A003 etc)
 
Infotype Field
This is the field name to be read.
 
Pre-population type
This can be set to 'Pre-populate', 'Check-cycle' or 'Both' in order to control when the field is filled.
 
Notes
This is free text, normally used for a human readable description of the field when not clear from the fieldname.
 
 

Example Configuration

Employee Forms (TXT_IM_DOCUMENT = employee number passed in URL)

 

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

TXT_EMP_NAME

P

TXT_IM_DOCUMENT

0001

 

ENAME

Full Name

DD_ BUSAREA

P

TXT_IM_DOCUMENT

0001

 

GSBER

Business Area

TXT_EMP_ORG_ID

P

TXT_IM_DOCUMENT

0001

 

ORGEH

Org ID

TXT_EMP_PER

P

TXT_IM_DOCUMENT

0001

 

PERNR

Employee Number

DD_EMPGRP

P

TXT_IM_DOCUMENT

0001

 

PERSG

Employee Group

DD_EMPSGRP

P

TXT_IM_DOCUMENT

0001

 

PERSK

Employee Subgroup

TXT_EMP_POS_ID

P

TXT_IM_DOCUMENT

0001

 

PLANS

Position ID

DD_PERSAREA

P

TXT_IM_DOCUMENT

0001

 

WERKS

Personnel area

DD_PERSUBAREA

P

TXT_IM_DOCUMENT

0001

 

BTRTL

Personnel Subarea

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_TITLE

P

TXT_IM_DOCUMENT

0002

 

ANRED

Title

TXT_EMP_NAME

P

TXT_IM_DOCUMENT

0002

 

CNAME

Complete Name

DD_ MARITAL_STAT

P

TXT_IM_DOCUMENT

0002

 

FAMST

Marital Status

DT_ EMP_DOB

P

TXT_IM_DOCUMENT

0002

 

GBDAT

Date of Birth

DD_COB

P

TXT_IM_DOCUMENT

0002

 

GBLND

Country of Birth

DD_ GENDER

P

TXT_IM_DOCUMENT

0002

 

GESCH

Gender

TXT_EMP_M_NAME

P

TXT_IM_DOCUMENT

0002

 

MIDNM

Middle Name

TXT_ EMP_LAST_NAME

P

TXT_IM_DOCUMENT

0002

 

NACHN

Surname

DD_ NATIONALITY

P

TXT_IM_DOCUMENT

0002

 

NATIO

Nationality

TXT_ EMP_NATIONAL_ID

P

TXT_IM_DOCUMENT

0002

 

PERID

National ID

TXT_ EMP_KNOWN_AS

P

TXT_IM_DOCUMENT

0002

 

RUFNM

Known As

TXT_ EMP_FIRST_NAME

P

TXT_IM_DOCUMENT

0002

 

VORNA

First Name

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_ COUNTRY

P

TXT_IM_DOCUMENT

0006

 

LAND1

Country

TXT_ EMP_ADDR1

P

TXT_IM_DOCUMENT

0006

 

STRAS

Address line 1

TXT_ EMP_ADDR

P

TXT_IM_DOCUMENT

0006

 

LOCAT

Address line 2

TXT_EMP_CITY

P

TXT_IM_DOCUMENT

0006

 

ORT01

City

TXT_ EMP_POSTCODE

P

TXT_IM_DOCUMENT

0006

 

PSTLZ

Postcode

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

NUM_ EMP_FTE_PERC

P

TXT_IM_DOCUMENT

0007

 

EMPCT

FTE %

DD_ WORK_PATTERN

P

TXT_IM_DOCUMENT

0007

 

SCHKZ

Work Pattern

NUM_EMP_HRS_PW

P

TXT_IM_DOCUMENT

0007

 

WOSTD

Hours per Week

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

NUM_ EMP_FTE_SALARY

P

TXT_IM_DOCUMENT

0008

 

ANSAL

Annual Salary

NUM_ EMP_HRPAY_RATE

P

TXT_IM_DOCUMENT

0008

 

BET01

Hourly Rate

DD_ PSCALE_TY

P

TXT_IM_DOCUMENT

0008

 

TRFAR

Payscale Type

DD_ PSCALE_AREA

P

TXT_IM_DOCUMENT

0008

 

TRFGB

Payscale Area

DD_ PSCALE_GRADE

P

TXT_IM_DOCUMENT

0008

 

TRFGR

Payscale Grade

DD_ PSCALE_LEV

P

TXT_IM_DOCUMENT

0008

 

TRFST

Payscale Level

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

TXT_ EMP_BNK_KEY

P

TXT_IM_DOCUMENT

0009

 

BANKL

Bank Key

NUM_ EMP_BNK_ACCNO

P

TXT_IM_DOCUMENT

0009

 

BANKN

Bank Account Number

TXT_ EMP_BNK_COUNTRY

P

TXT_IM_DOCUMENT

0009

 

BANKS

Bank Country Key

TXT_ EMP_BNK_PAYMETH

P

TXT_IM_DOCUMENT

0009

 

ZLSCH

Payment Method

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DT_START_DATE_AD

P

TXT_IM_DOCUMENT

0014

 

BEGDA

Payment Start date

NUM_AMOUNT_AD

P

TXT_IM_DOCUMENT

0014

 

BETRG

Payment Amount

DT_END_DATE_AD

P

TXT_IM_DOCUMENT

0014

 

ENDDA

Payment End Date

DD_WAGE_TYPE_AD

P

TXT_IM_DOCUMENT

0014

 

LGART

Payment Wagetype

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DT_EMP_CEND_0016

P

TXT_IM_DOCUMENT

0016

 

CTEDT

Contract End date

DD_CTYPE_0016

P

TXT_IM_DOCUMENT

0016

 

CTTYP

Contract type

DD_EE_NOTICE

P

TXT_IM_DOCUMENT

0016

 

KDGF2

Employee notice

DD_ER_NOTICE

P

TXT_IM_DOCUMENT

0016

 

KDGFR

Employer notice

DD_PROB_UNIT

P

TXT_IM_DOCUMENT

0016

 

PRBEH

Probation (Unit)

NUM_EMP_PROB_LENGTH

P

TXT_IM_DOCUMENT

0016

 

PRBZT

Probation Length

 

 

 

Position (TXT_IM_DOCUMENT = Position ID or use TXT_EMP_POS_ID from Employee)

 

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

TXT_POS_NAME

S

TXT_IM_DOCUMENT

1000

 

STEXT

Position Name

TXT_POS_ABRV

S

TXT_IM_DOCUMENT

1000

 

SHORT

Position Abbreviation

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

TXT_POS_JOB_ID

S

TXT_IM_DOCUMENT

1001

B007

SOBID

Job ID linked to Position

TXT_POS_ORG_ID

S

TXT_IM_DOCUMENT

1001

A003

SOBID

Org Unit ID linked to Position

TXT_POS_EMP_ID

S

TXT_IM_DOCUMENT

1001

A008

SOBID

Employee ID linked to Position

TXT_POS_CC_ID

S

TXT_IM_DOCUMENT

1001

A011

SOBID

Cost Centre linked to Position

DD_POS_QUALS

S

TXT_IM_DOCUMENT

1001

A031

SOBID

Qualification ID linked to Position

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_ POS_PSCALE_TY

S

TXT_IM_DOCUMENT

1005

 

TRFAR

Payscale Type

DD_ POS_PSCALE_AREA

S

TXT_IM_DOCUMENT

1005

 

TRFGB

Payscale Area

DD_ POS_PSCALE_GRADE

S

TXT_IM_DOCUMENT

1005

 

TRFG1

Payscale Grade

DD_ POS_PSCALE_LEV

S

TXT_IM_DOCUMENT

1005

 

TRFS1

Payscale Level (from)

DD_ POS_PSCALE_LEV_TO

S

TXT_IM_DOCUMENT

1005

 

TRFS2

Payscale Level To

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_ POS_VAC_STAT

S

TXT_IM_DOCUMENT

1007

 

STAUS

Vacancy Status

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_POS_PERSA

S

TXT_IM_DOCUMENT

1008

 

PERSA

Personnel area

DD_POS_PERSUBA

S

TXT_IM_DOCUMENT

1008

 

BTRTL

Personnel Subarea

DD_ POS_BUSAREA

S

TXT_IM_DOCUMENT

1008

 

GSBER

Business Area

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

NUM_POS_HRS_PW

S

TXT_IM_DOCUMENT

1011

 

WKAVG

Standard Hours per Week

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_POS_EGRP

S

TXT_IM_DOCUMENT

1013

 

PERSG

Employee Group

DD_POS_ESGRP

S

TXT_IM_DOCUMENT

1013

 

PERSK

Employee Subgroup

 

 

Org Unit (TXT_IM_DOCUMENT = Org ID or use TXT_EMP_ORG_ID from Employee)

 

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

TXT_ORG_NAME

O

TXT_IM_DOCUMENT

1000

 

STEXT

Org Unit Name

TXT_ORG_ABRV

O

TXT_IM_DOCUMENT

1000

 

SHORT

Org Unit Abbreviation

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

TXT_ORG_CHIEF_ID

O

TXT_IM_DOCUMENT

1001

B012

SOBID

Chief Position ID linked to Org Unit

TXT_ORG_HIGHER_ID

O

TXT_IM_DOCUMENT

1001

B002

SOBID

Higher Org Unit ID

TXT_ORG_CC_ID

O

TXT_IM_DOCUMENT

1001

B011

SOBID

Cost Centre ID linked to Org Unit

FIELD_NAME

OTYPE

OBJID

INFTY

SUBTY

INFTY_FIELD

NOTES

DD_ORG_PERSA

O

TXT_IM_DOCUMENT

1008

 

PERSA

Org Unit Personnel area

DD_ORG_PERSUBA

O

TXT_IM_DOCUMENT

1008

 

BTRTL

Org Unit Personnel Subarea

 

 

Using Project Variables for Fixed Values

 The standard FLM Project Settings table should be used to store fixed or default values for fields.
 
 
SID
SAP System ID
 
Client
SAP Client Number
 
Customer
FLM Customer Code
 
Form Type
The Form Type.  This can be left blank if the fields is relevant for ALL forms.
 
Template Option (previously Language)
Not used for HR form pre-population.
 
Version
Not used for HR form pre-population.
 
Field Name
Use the pattern 'FPRE_<fieldname>' where <fieldname> is the name of the field.  See the example 'FPRE_TXT_ACTION' above.
 
Sequence
Not used for HR form pre-population.
 
Sign
Use 'I' (Include)
 
Option
Use 'EQ' (Equals)
 
Low Value
Enter the fixed value for the field
 
High Value
Not used for HR form pre-population.
 
Text
Free text
 
 
 In the above example, the field 'TXT_ACTION' in form type 'HRDX' is given the value 'ZY'.