Detailled Mapping of Fields
The following tables present the mapping of fields in the R/3 Project System to Microsoft Project for various objects.
Project Definition
Field in R/3 PS |
Field in MS 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 R/3 PS |
Field in MS 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 oTask.Start |
|
WBS_BASIC_FINISH_DATE oTask.Finish |
|
WBS_FORECAST_START_DATE |
|
WBS_FORECAST_FINISH_DATE |
|
WBS_ACTUAL_START_DATE |
|
WBS_ACTUAL_FINISH_DATE |
|
WBS_BASIC_DURATION |
|
WBS_BASIC_DUR_UNIT |
|
WBS_BASIC_DUR_UNIT_ISO |
|
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 – Auxillary field for transferring PS hierarchy |
SummaryTask.Number20 |
ObjectType |
SummaryTask.Text16 |
SubObjectType |
SummaryTask.Text17 |
Save user project view |
SummaryTask.Number19 |
Network
Field in R/3 PS |
Field in MS Project |
NETWORK |
Task.Text30 |
NETWORK_TYPE |
NetworkType from configuration screen |
SHORT_TEXT |
ProjectDefinition or WBS_Element |
PLANT |
|
PROFIT_CTR |
|
WBS_ELEMENT |
|
TAXJURCODE |
|
OBJECTCLASS |
|
FINISH_DATE |
Task.Finish |
START_DATE |
Task.Start |
MRP_CONTROLLER |
|
SCHED_TYPE |
1 – Forward, 2 - Backward |
PRIORITY |
|
PROJECT_DEFINITION |
|
NOT_AUTO_SCHEDULE (MSP->PS always set) |
|
NOT_AUTO_COSTING (MSP->PS always set) |
|
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 R/3 PS |
Field in MS Project | |
NETWORK |
Task.Text30 | |
ACTIVITY |
Task.Name | |
CONTROL_KEY |
Configuration for object subtypes – Task.Text21 | |
WORK_CNTR |
Task.Resources.Text21 | |
PLANT |
Task.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 | |
DURATION_MINIMUM |
| |
DURATION_MINIMUM_UNIT |
| |
DURATION_MINIMUM_UNIT_ISO |
| |
CONSTRAINT_TYPE_START |
Select Case ScheduleFromStart Case "1" 'Must Start On m_Task.ConstraintType = pjMSO Case "2" 'Start No Earlier Than m_Task.ConstraintType = pjSNET Case "3" 'Start No Later Than m_Task.ConstraintType = pjSNLT Case Else End Select | |
CONSTRAINT_TYPE_FINISH |
Select Case ScheduleFromFinish Case "1" 'Must Finish On m_Task.ConstraintType = pjMFO Case "2" 'Finish No Earlier Than m_Task.ConstraintType = pjFNET Case "3" 'Finish No Later Than m_Task.ConstraintType = pjFNLT Case Else End Select | |
WORK_ACTIVITY |
Sum of activity and activity element work: Task.Work – depends on UN_WORK_UNIT | |
UN_WORK |
| |
UN_WORK_ISO |
Project.DefaultWorkUnits | |
EARLY_START_DATE |
Transter from PS to MSP
Transfer from MSP to PS If MS project is scheduled from start | |
EARLY_START_TIME |
| |
EARLY_FINISH_DATE |
Transfer from PS to MSP
Transfer from MSP to PS
| |
EARLY_FINISH_TIME |
| |
LATEST_START_DATE |
Transter from PS to MSP
Transfer from MSP to PS
| |
LATEST_START_TIME |
| |
LATEST_FINISH_DATE |
Transfer from PS to MSP
Transfer from MSP to PS
| |
LATEST_FINISH_TIME |
| |
FLOAT_FREE |
| |
FLOAT_TOTAL |
| |
CONSTRAINT_START_DATE |
Select Case m_Task.ConstraintType Case pjMSO, pjSNET, pjSNLT Constraint_Start_Date=Task.ConstraintDate Case Else End Select | |
CONSTRAINT_START_TIME |
| |
CONSTRAINT_FINISH_DATE |
Select Case m_Task.ConstraintType Case pjMFO, pjFNET, pjFNLT Constraint_Finish_Date=Task.ConstraintDate Case Else End Select | |
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 |
| |
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 |
| |
FLOAT_FREE_FC |
| |
FLOAT_TOTAL_FC |
| |
OBJECTCLASS_EXT |
| |
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 R/3 PS |
Field in MS Project |
NETWORK |
Task.Text30 |
ACTIVITY |
Task.Name |
ELEMENT |
Next number in loop |
CONTROL_KEY |
|
WORK_CNTR |
Task.Resources.Text21 |
PLANT |
Task.Recources.Text20 |
DESCRIPTION |
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 |
|
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 |
|
UN_WORK |
|
UN_WORK_ISO |
|
EARLY_START_DATE |
Only transfer from MSP to PS
|
EARLY_START_TIME |
|
EARLY_FINISH_DATE |
Only transfer from MSP to PS
|
EARLY_FINISH_TIME |
|
LATEST_START_DATE |
Only transfer from MSP to PS
|
LATEST_START_TIME |
|
LATEST_FINISH_DATE |
Only transfer from MSP to PS
|
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 |
|
Relationship
Field in R/3 PS |
Field in MS 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 |
Unit for DURATION_RELATION |
FACTORY_CALENDAR |
|
PERCENT_OF_SUC_PR |
|
DURATION_KEY |
|
WORK_CNTR |
|
WORK_CNTR |
|
WBS Element Milestone
Field in R/3 PS |
Field in MS Project |
MILESTONE_NUMBER |
MilestoneTask.Name |
WBS_ELEMENT |
Superior SumaryTask.Name ins Task.Text29 |
MILESTONE_USAGE |
|
DESCRIPTION |
Milestone.Text1 |
SCHED_MILESTONE_DATE_BASIC |
MilestoneTask.Start |
SCHED_MILESTONE_TIME_BASIC |
|
SCHED_MILESTONE_DATE_FORECAST |
|
SCHED_MILESTONE_TIME_FORECAST |
|
FIXED_MILESTONE_DATE_BASIC |
|
FIXED_MILESTONE_TIME_BASIC |
MilestoneTask.ConstraintDate |
FIXED_MILESTONE_DATE_FORECAST |
|
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 – Auxilary 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 R/3 PS |
Field in MS 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 |
SCHED_MILESTONE_TIME_BASIC |
|
SCHED_MILESTONE_DATE_FORECAST |
|
SCHED_MILESTONE_TIME_FORECAST |
|
FIXED_MILESTONE_DATE_BASIC |
|
FIXED_MILESTONE_TIME_BASIC |
|
FIXED_MILESTONE_DATE_FORECAST |
|
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 |
|
ActivityUniqueID (NETWORK / ACTIVITY) – Help |
MilestoneTask.Text2 |
Level – Auxilary field for transferring PS hierarchy |
MilestoneTask.Number20 |
Milestone_Indicator |
MilestoneTask.Milestone |
ObjectType |
MIlestoneTask.Text16 |
SubObjectType |
MilestoneTask.Text17 |
Save user project view |
MilestoneTask.Number19 |