Detailed Mapping of Fields

The following tables display the mapping of fields in the Project System to Microsoft Project for various objects:

Project Definition

Field in PS

Field in Microsoft Project

PROJECT_DEFINITION

ProjectDefinition from configuration screen

DESCRIPTION

Description from configuration screen

MASK_ID

RESPONSIBLE_NO

APPLICANT_NO

COMP_CODE

BUS_AREA

CONTROLLING_AREA

PROFIT_CTR

PROJECT_CURRENCY

PROJECT_CURRENCY_ISO

NETWORK_ASSIGNMENT

START

Project.ProjectStart

FINISH

Project.ProjectFinish

PLANT

CALENDAR

PLAN_BASIC

PLAN_FCST

TIME_UNIT

TIME_UNIT_ISO

NETWORK_PROFILE

NetworkProfile from configuration screen

PROJECT_PROFILE

ProjectProfile from configuration screen

BUDGET_PROFILE

PROJECT_STOCK

OBJECTCLASS

STATISTICAL

TAXJURCODE

INT_PROFILE

WBS_SCHED_PROFILE

CSH_BDGT_PROFILE

PLAN_PROFILE

JOINT_VENTURE

RECOVERY_IND

EQUITY_TYPE

JV_OBJECT_TYPE

JV_JIB_CLASS

JV_JIB_SUB_CLASS_A

OBJECTCLASS_EXT

WBS Element

Field in PS

Field in Microsoft Project

WBS_ELEMENT

SumaryTask.Name

PROJECT_DEFINITION

ProjectDefinition from configuration screen

DESCRIPTION

SummaryTask.Text1

SHORT_ID

SummaryTask.WBS

RESPONSIBLE_NO

APPLICANT_NO

COMP_CODE

BUS_AREA

CO_AREA

PROFIT_CTR

PROJ_TYPE

NETWORK_ASSIGNMENT

COSTING_SHEET

OVERHEAD_KEY

CALENDAR

PRIORITY

EQUIPMENT

FUNCTIONAL_LOCATION

CURRENCY

CURRENCY_ISO

PLANT

USER_FIELD_KEY

USER_FIELD_CHAR20_1

USER_FIELD_CHAR20_2

USER_FIELD_CHAR10_1

USER_FIELD_CHAR10_2

USER_FIELD_QUAN1

USER_FIELD_UNIT1

USER_FIELD_UNIT1_ISO

USER_FIELD_QUAN2

USER_FIELD_UNIT2

USER_FIELD_UNIT2_ISO

USER_FIELD_CURR1

USER_FIELD_CUKY1

USER_FIELD_CUKY1_ISO

USER_FIELD_CURR2

USER_FIELD_CUKY2

USER_FIELD_CUKY2_ISO

USER_FIELD_DATE1

USER_FIELD_DATE2

USER_FIELD_FLAG1

USER_FIELD_FLAG2

OBJECTCLASS

Configuration – „PR"

STATISTICAL

TAXJURCODE

INT_PROFILE

JOINT_VENTURE

RECOVERY_IND

EQUITY_TYPE

JV_OBJECT_TYPE

JV_JIB_CLASS

JV_JIB_SUB_CLASS_A

OBJECTCLASS_EXT

WBS_PLANNING_ELEMENT

WBS_ACCOUNT_ASSIGNMENT_ELEMENT

WBS_BILLING_ELEMENT

RESPSBL_CCTR

RESPSBL_CCTR_CONTROLLING_AREA

REQUEST_CCTR

REQUEST_COMP_CODE

REQUEST_CCTR_CONTROLLING_AREA

LOCATION

CHANGE_NO

INVEST_PROFILE

RES_ANAL_KEY

WBS_CCTR_POSTED_ACTUAL

WBS_BASIC_START_DATE

Task.Start

Task.Start1 (only PS -> MSP)

WBS_BASIC_FINISH_DATE

Task.Finish

Task.Finish1 (only PS -> MSP)

WBS_FORECAST_START_DATE

Task.Start2 (only PS -> MSP)

WBS_FORECAST_FINISH_DATE

Task.Finish2 (only PS -> MSP)

WBS_ACTUAL_START_DATE

Task.Start3 (only PS -> MSP)

WBS_ACTUAL_FINISH_DATE

Task.Finish3 (only PS -> MSP)

WBS_BASIC_DURATION

Task.Duration

WBS_BASIC_DUR_UNIT

WBS_BASIC_DUR_UNIT_ISO

Task.Duration and Task.Text25

WBS_FORECAST_DURATION

WBS_FORCAST_DUR_UNIT

WBS_FORECAST_DUR_UNIT_ISO

WBS_ACTUAL_DURATION

WBS_ACTUAL_DUR_UNIT

WBS_ACTUAL_DUR_UNIT_ISO

Level – Auxiliary field for transferring PS hierarchy

SummaryTask.Number20

ObjectType

SummaryTask.Text16

SubObjectType

SummaryTask.Text17

Save user project view

SummaryTask.Number19

Network

Field in PS

Field in Microsoft Project

NETWORK

Task.Text30

NETWORK_TYPE

NetworkType from configuration screen and saved in Task.Text 28

SHORT_TEXT

ProjectDefinition or WBS_Element

PLANT

PROFIT_CTR

WBS_ELEMENT

TAXJURCODE

OBJECTCLASS

FINISH_DATE

Task.Finish

START_DATE

Task.Start

MRP_CONTROLLER

Task.Text27

SCHED_TYPE

1 – Forward, 2 - Backward

PRIORITY

PROJECT_DEFINITION

NOT_AUTO_SCHEDULE

NOT_AUTO_COSTING

NOT_MRP_APPLICABLE

MSP->PS always set

PROFILE

Profile from configuration screen

FINISH_DATE_FORECAST

START_DATE_FORECAST

SCHED_TYPE_FORECAST

OBJECTCLASS_EXT

Activity

Field in PS

Field in Microsoft Project

NETWORK

Task.Text30

ACTIVITY

Task.Name

CONTROL_KEY

Configuration for object subtypes – Task.Text21

WORK_CNTR

Resources.Text21

PLANT 

Resources.Text20

DESCRIPTION

Task.Text1 and Task.Text15

VENDOR_NO

PRICE

PRICE_UNIT

COST_ELEM

CURRENCY

CURRENCY_ISO

INFO_REC

PURCH_ORG

PUR_GROUP

MATL_GROUP

FLEXIBLE_DURATION

NUMBER_OF_CAPACITIES

PERCENT_OF_WORK

MILESTONE

ACTTYPE

ACTIVITY_COSTS

PROJECT_DEFINITION

WBS_ELEMENT    

Task.Text29

FACTORY_CALENDAR

DISTRIBUTING_KEY

PRIORITY

TAXJURCODE

OBJECTCLASS

PROFIT_CTR

NOT_MRP_APPLICABLE

PROJECT_SUMMARIZATION

OPERATION_MEASURE_UNIT

OPERATION_MEASURE_UNIT_ISO

PLND_DELRY

DURATION_NORMAL   

Task.Duration – depends on calendar in project and DURATION_NORMAL_UNIT_ISO

DURATION_NORMAL_UNIT

DURATION_NORMAL_UNIT_ISO

Unit for DURATION_NORMAL and Task.Text25

DURATION_MINIMUM

DURATION_MINIMUM_UNIT

DURATION_MINIMUM_UNIT_ISO

CONSTRAINT_TYPE_START

Select Case ScheduleFromStart

Case "1" 'Must Start On

Task.ConstraintType = pjMSO

Case "2" 'Start No Earlier Than

Task.ConstraintType = pjSNET

Case "3" 'Start No Later Than

Task.ConstraintType = pjSNLT

Case Else

End Select

CONSTRAINT_TYPE_FINISH

Select Case ScheduleFromFinish

Case "1" 'Must Finish On

Task.ConstraintType = pjMFO

Case "2" 'Finish No Earlier Than

Task.ConstraintType = pjFNET

Case "3" 'Finish No Later Than

Task.ConstraintType = pjFNLT

Case Else

End Select

WORK_ACTIVITY

Activity work: Task.Assignment.Work if the activity has a plant and work center or personnel resource, otherwise ignored. Depends on UN_WORK_UNIT

UN_WORK

UN_WORK_ISO

Project.DefaultWorkUnits and Task.Text26

EARLY_START_DATE  

Transfer from PS to MSP

If transfer option „Schedule from start"

·         -> Task.Start and Task.BaselineStart

·         -> Task.Start will be recalculated by Microsoft Project if there are confirmations on the Activity or Activity Elements belonging to the Activity

Transfer from MSP to PS

If Microsoft Project is „Schedule from start“

·         -> Task.Start if the StartDate has been modified by the user

·         -> Task.BaselineStart if the user has not made any modifications

EARLY_START_TIME

EARLY_FINISH_DATE  

Transfer from PS to MSP

If transfer option „Schedule from start"

·         -> Task.Finish and Task.BaselineFinish

·         -> Task.Finish will be recalculated by Microsoft Project if there are confirmations on the Activity or Activity Elements belonging to the Activity

·         Task.Finish3

Transfer from MSP to PS

If Microsoft Project is „Schedule from Start“

·         -> Task.Finish if the FinishDate has been modified by the user

·         -> Task.BaselineFinish if the user has not made any notifications

EARLY_FINISH_TIME

LATEST_START_DATE 

Transfer from PS to MSP

If transfer option „Schedule from finish"

·         Task.Start and Task.BaslineStart

·         Task.Start will be recalculated by Microsoft Project if there are confirmations on the Activity or Activity elements belonging to the activity

·         TaskStart3

Transfer from MSP to PS

If transfer option „Schedule from finish“

·          -> Task.Start if the StartDate has been modified by the user

·         -> Task. BaselineStart if the user has not made any modifications

LATEST_START_TIME

LATEST_FINISH_DATE 

Transfer from PS to MSP

If transfer option „Schedule from finish"

·         -> Task.Finish and Task.BaselineFinish

·         -> Task.Finish will be recalculated by Microsoft Project if there are confirmations on the Activity or Activity elements belonging to the activity

·         -> Task.Finish3

Transfer from MSP to PS

If Microsoft Project is „Schedule from finish“

·         -> Task.Finish if the FinishDate has been modified by the user

·         -> Task.BaselineFinish if the user has not made any modifications

LATEST_FINISH_TIME

FLOAT_FREE

FLOAT_TOTAL

CONSTRAINT_START_DATE

Select Case Task.ConstraintType

Case pjMSO, pjSNET, pjSNLT

Constraint_Start_Date=Task.ConstraintDate

Case Else

End Select

and TaskStart1 (only PS -> MSP)

CONSTRAINT_START_TIME

CONSTRAINT_FINISH_DATE

Select Case Task.ConstraintType

Case pjMFO, pjFNET, pjFNLT

Constraint_Finish_Date=Task.ConstraintDate

Case Else

End Select

and Task.Finish1 (only PS -> MSP)

CONSTRAINT_FINISH_TIME

USER_FIELD_KEY

USER_FIELD_CHAR20_1

USER_FIELD_CHAR20_2

USER_FIELD_CHAR10_1

USER_FIELD_CHAR10_2

USER_FIELD_QUAN1

USER_FIELD_UNIT1

USER_FIELD_UNIT1_ISO

USER_FIELD_QUAN2

USER_FIELD_UNIT2

USER_FIELD_UNIT2_ISO

USER_FIELD_CURR1

USER_FIELD_CURR2

USER_FIELD_CUKY1

USER_FIELD_CUKY1_ISO

USER_FIELD_CUKY2

USER_FIELD_CUKY2_ISO

USER_FIELD_DATE1

USER_FIELD_DATE2

USER_FIELD_FLAG1

USER_FIELD_FLAG2

DURATION_NORMAL_FC

DURATION_NORMAL_FC_UNIT

DURATION_NORMAL_FC_UNIT_ISO

DURATION_MINIMUM_FC

DURATION_MINIMUM_FC_UNIT

DURATION_MINIMUM_FC_UNIT_ISO

CONSTRAINT_TYPE_FINISH_FC

CONSTRAINT_TYPE_START_FC

CONSTRAINT_START_DATE_FC

CONSTRAINT_START_TIME_FC

CONSTRAINT_FINISH_DATE_FC

CONSTRAINT_FINISH_TIME_FC

EARLY_START_DATE_FC

Task.Start2 (only PS -> MSP)

EARLY_START_TIME_FC

EARLY_FINISH_DATE_FC

Task.Finish2 (only PS -> MSP)

EARLY_FINISH_TIME_FC

LATEST_START_DATE_FC

LATEST_START_TIME_FC

LATEST_FINISH_DATE_FC

LATEST_FINISH_TIME_FC

FLOAT_FREE_FC

FLOAT_TOTAL_FC

OBJECTCLASS_EXT

FUNC_AREA

FUNC_AREA_LONG

PLANNED_COST

Task.Cost And Task.BaselineCost

Task.Cost will be modified by Microsoft Project if there are Confirmations done on the Activity or the Activity Elements belonging to the Activity

Task.FixedCost = PLANNED_COST - sum of cost for all resources for the task (Only from PS to MSP)

ACTUAL_COST

Microsoft Project calculates this value based on Microsoft Project Settings for calculation of costs.

CONTROLLING_AREA_CURRENCY

ACTUAL_START_DATE

Task.ActualStart (Only from PS to MSP)

ACTUAL_FINISH_DATE

Task.ActualFinish (Only from PS to MSP)

FORECAST_FINISH_DATE

COMPLETE

REFERENCE_POINT

INCLU--AP

ActivityUniqueID (NETWORK / ACTIVITY) – Help

Task.Text20

Level – Auxiliary field for transferring PS hierarchy

Task.Number20

ObjectType

Task.Text16

SubObjectType

Task.Text17

TaskType

Task.Type – default pjFixedDuration

Save user project view

Task.Number19

Activity Element

Field in PS

Field in Microsoft Project

NETWORK

Task.Text30

ACTIVITY

Task.Name

ELEMENT

Next number in loop

CONTROL_KEY

WORK_CNTR

Resources.Text21

PLANT

Recources.Text20

DESCRIPTION

Resources.Text1 if empty then Task.Text1

VENDOR_NO

PRICE

PRICE_UNIT

COST_ELEM

CURRENCY

CURRENCY_ISO

INFO_REC

PURCH_ORG

PUR_GROUP

MATL_GROUP

NUMBER_OF_CAPACITIES

PERCENT_OF_WORK

ACTTYPE

Resource.Text22, Resource.OutlineCode6 contains CostCenter.ActivityType

ACTIVITY_COSTS

PROJECT_DEFINITION

WBS_ELEMENT

DISTRIBUTING_KEY

TAXJURCODE

PROFIT_CTR

NOT_MRP_APPLICABLE

PROJECT_SUMMARIZATION

OPERATION_MEASURE_UNIT

OPERATION_MEASURE_UNIT_ISO

PLND_DELRY

WORK_ACTIVITY

Activity element work: Task.Assignment.Work – depends on UN_WORK_UNIT

UN_WORK

UN_WORK_ISO

EARLY_START_DATE

Transfer from PS to MSP

  • If Microsoft Project is scheduled from start 
    -> Task.Assignment.Start And Task.Assignment.BaselineStart

Task.Start will be recalculated by Microsoft Project if there are confirmations on the Activity Element

EARLY_START_TIME

EARLY_FINISH_DATE

Transfer from PS to MSP

  • If Microsoft Project is scheduled from start 
    -> Task.Assignment.Finish And Task.Assignment.BaselineFinish

Task.Finish will be recalculated by Microsoft Project if there are confirmations on the Activity Element

EARLY_FINISH_TIME

LATEST_START_DATE

Transfer from PS to MSP

  • If Microsoft Project is scheduled from Finish 
    -> Task.Assignment.Start And Task.Assignment.BaselineStart

Task.Start will be recalculated by Microsoft Project if there are confirmations on the Activity Element

LATEST_START_TIME

LATEST_FINISH_DATE

Transfer from PS to MSP

  • If Microsoft Project is scheduled from Finish 
    -> Task.Assignment.Finish And Task.Assignment.BaselineFinish

Task.Finish will be recalculated by Microsoft Project if there are confirmations on the Activity Element

LATEST_FINISH_TIME

USER_FIELD_KEY

USER_FIELD_CHAR20_1

USER_FIELD_CHAR20_2

USER_FIELD_CHAR10_1

USER_FIELD_CHAR10_2

USER_FIELD_QUAN1

USER_FIELD_UNIT1

USER_FIELD_UNIT1_ISO

USER_FIELD_QUAN2

USER_FIELD_UNIT2

USER_FIELD_UNIT2_ISO

USER_FIELD_CURR1

USER_FIELD_CUKY1

USER_FIELD_CUKY1_ISO

USER_FIELD_CURR2

USER_FIELD_CUKY2

USER_FIELD_CUKY2_ISO

USER_FIELD_DATE1

USER_FIELD_DATE2

USER_FIELD_FLAG1

USER_FIELD_FLAG2

EARLY_START_DATE_FC

EARLY_START_TIME_FC

EARLY_FINISH_DATE_FC

EARLY_FINISH_TIME_FC

LATEST_START_DATE_FC

LATEST_START_TIME_FC

LATEST_FINISH_DATE_FC

LATEST_FINISH_TIME_FC

OBJECTCLASS_EXT

OFFSET_START

OFFSET_START_UNIT

OFFSET_START_UNIT_ISO

OFFSET_END

OFFSET_END_UNIT

OFFSET_END_UNIT_ISO

FUNC_AREA

FUNC_AREA_LONG

PERS_NO

Personnel Number - Resource.Text23

PLANNED_COST

ACTUAL_COST

CONTROLLING_AREA_CURRENCY

ACTUAL_START_DATE

Transfer from PS to MSP

-> Task.Assignment.ActualStart

ACTUAL_FINISH_DATE

Transfer from PS to MSP

-> Task.Assignment.ActualFinish

FORECAST_FINISH_DATE

COMPLETE

Relationship

Field in PS

Field in Microsoft Project

NETWORK_PREDECESSOR

Task.Text30

ACTIVITY_PREDECESSOR

Task.Name

NETWORK_SUCCESSOR

Tasks(SuccessorID from Task.Successor).Text30

ACTIVITY_SUCCESSOR

Tasks(SuccessorID from Task.Successor).Name

RELATION_TYPE

RelationType from Task.Successor

DURATION_RELATION_UNIT

DURATION_RELATION

Relationship duration with
DURATION_RELATION_UNIT_ISO

DURATION_RELATION_UNIT_ISO

Unit for DURATION_RELATION

FACTORY_CALENDAR

PERCENT_OF_SUC_PR

DURATION_KEY

WORK_CNTR

WORK_CNTR

WBS Element Milestone

Field in PS

Field in Microsoft Project

MILESTONE_NUMBER

MilestoneTask.Name

WBS_ELEMENT

Superior SumaryTask.Name ins Task.Text29

MILESTONE_USAGE

DESCRIPTION

Milestone.Text1

SCHED_MILESTONE_DATE_BASIC

MilestoneTask.Start

MilestoneTask.Start3 (only PS -> MSP)

SCHED_MILESTONE_TIME_BASIC

SCHED_MILESTONE_DATE_FORECAST

MilestoneTask.Start4 (only PS -> MSP)

SCHED_MILESTONE_TIME_FORECAST

FIXED_MILESTONE_DATE_BASIC

MilestoneTask.ConstraintDate

MilestoneTask.Start1 (only PS -> MSP)

FIXED_MILESTONE_TIME_BASIC

FIXED_MILESTONE_DATE_FORECAST

MilestoneTask.Start2 (only PS -> MSP)

FIXED_MILESTONE_TIME_FORECAST

ACTUAL_DATE

ACTUAL_TIME

LATEST_DATES_INDICATOR

OFFSET_START_END_INDICATOR

OFFSET_MILESTONE_DATE

OFFSET_MILESTONE_DATE_UNIT

OFFSET_MILESTONE_DATE_UNIT_ISO

OFFSET_PERCENTAGE

TREND_ANALYSIS_INDICATOR

EARNED_VALUE_INDICATOR

PERCENTAGE_OF_COMPLETION

SALES_DOC_DATE_INIDICATOR

INVOICE_PERCENTAGE

Level – Auxilliary field for transferring PS hierarchy

Task.Number20

Milestone_Indicator

Task.Milestone

ObjectType

Task.Text16

SubObjectType

Task.Text17

Save user project view

MilestoneTask.Number19

Activity Milestone

Field in PS

Field in Microsoft Project

MILESTONE_NUMBER

MilestoneTask.Name

NETWORK

Superior Task.Text30

ACTIVITY

Superior Task.Name in Task.Text29

MILESTONE_USAGE

DESCRIPTION

MilestoneTask.Text1

SCHED_MILESTONE_DATE_BASIC

MilestoneTask.Start

MilestoneTask.Start3 (only PS –> MSP)

SCHED_MILESTONE_TIME_BASIC

SCHED_MILESTONE_DATE_FORECAST

MilestoneTask.Start4 (only PS -> MSP)

SCHED_MILESTONE_TIME_FORECAST

FIXED_MILESTONE_DATE_BASIC

MilestoneTask.ConstraintDate

Milestone Task.Start1 (only PS -> MSP)

FIXED_MILESTONE_TIME_BASIC

FIXED_MILESTONE_DATE_FORECAST

MilestoneTask.Start2 (only PS -> MSP)

FIXED_MILESTONE_TIME_FORECAST

ACTUAL_DATE

MilestoneTask.Finish_Date

ACTUAL_TIME

LATEST_DATES_INDICATOR

OFFSET_START_END_INDICATOR

OFFSET_MILESTONE_DATE

OFFSET_MILESTONE_DATE_UNIT

OFFSET_MILESTONE_DATE_UNIT_ISO

OFFSET_PERCENTAGE

TREND_ANALYSIS_INDICATOR

EARNED_VALUE_INDICATOR

PERCENTAGE_OF_COMPLETION

SALES_DOC_DATE_INIDICATOR

INVOICE_PERCENTAGE

ActivityUniqueID (NETWORK / ACTIVITY) – Help

MilestoneTask.Text2

Level – Auxilliary field for transferring PS hierarchy

MilestoneTask.Number20

Milestone_Indicator

MilestoneTask.Milestone

ObjectType

MIlestoneTask.Text16

SubObjectType

MilestoneTask.Text17

Save user project view

MilestoneTask.Number19

Organizational Assignment

Field in PS

Field in Microsoft Project

PERNO

Personnel number – mapped to Resource.Text23.

NAME

Formatted name of employee – Resource.Name

CO_AREA

Controlling area – Resource.Text11

COSTCENTER

Cost center – Resource.Text12

COMP_CODE

Company code – Resource.Text13

ORG_UNIT

Organizational unit – Resource.Text14

ORGTXT

Organizational unit text – Resource.Text15

POSITION

Position – Resource.Text16

POSTXT

Name of position – Resource.Text17

JOB

Job-Resource.Text18

JOBTXT

Job title – Resource.Text19

TO_DATE

To date – Resource.Date6

Activity Type

Resource.Text22

CostCenter.ActivityType

Resource.OutlineCode6

Rate for activity type

Resource.StandardRate. If multiple rates exist Resource's cost rate table is populated