Inicio del área de contenido

Documentación proceso de fondo Detalle de las equivalencias de campos Localizar documento en árbol de navegación

En la siguientes tablas se muestra la equivalencia entre los campos del Sistema de proyectos del Sistema R/3 y los de Microsoft Project para diversos objetos.

Definición del proyecto

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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

 

Elementos PEP

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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

 

Nivel: Campo auxiliar para transferir jerarquías del Sistema de proyectos

SummaryTask.Number20

ObjectType

SummaryTask.Text16

SubObjectType

SummaryTask.Text17

Grabar vista de proyecto de usuario

SummaryTask.Number19

Grafo

Campo en el Sistema de proyectos del Sistema R/3

Campo en MS Project

NETWORK

Task.Text30

NETWORK_TYPE

NetworkType from configuration screen

SHORT_TEXT

ProjectDefinition o 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

 

Operación

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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 y 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

Transfer from PS to MSP

  • If transfer option „Schedule from start" ® Task.Start

Transfer from MSP to PS

If MS project is scheduled from start
® Task.Start

EARLY_START_TIME

 

EARLY_FINISH_DATE

Transfer from PS to MSP

  • If transfer option „Schedule from start" ® Task.Finish

Transfer from MSP to PS

  • If MS project is scheduled from start
    ® Task.Finish

EARLY_FINISH_TIME

 

LATEST_START_DATE

Transfer from PS to MSP

  • If transfer option „Schedule from finish" - ® Task.Start

Transfer from MSP to PS

  • If MS project is scheduled from finish ® Task.Start

LATEST_START_TIME

 

LATEST_FINISH_DATE

Transfer from PS to MSP

  • If transfer option „Schedule from finish" ® Task.Finish

Transfer from MSP to PS

  • If MS project is scheduled from finish
    ® Task.Finish

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

Nivel: Campo auxiliar para transferir jerarquías del Sistema de proyectos

Task.Number20

ObjectType

Task.Text16

SubObjectType

Task.Text17

TaskType

Task.Type – default pjFixedDuration

Grabar vista de proyecto de usuario

Task.Number19

Operación subordinada

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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

  • If MS project is scheduled from start
    ® Task.Start

EARLY_START_TIME

 

EARLY_FINISH_DATE

Only transfer from MSP to PS

  • If MS project is scheduled from start
    ® Task.Start

EARLY_FINISH_TIME

 

LATEST_START_DATE

Only transfer from MSP to PS

  • If MS project is scheduled from start
    ® Task.Start

LATEST_START_TIME

 

LATEST_FINISH_DATE

Only transfer from MSP to PS

  • If MS project is scheduled from start
    ® Task.Start

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

 

Relaciones de ordenación

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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

DURATION_RELATION_UNIT_ISO

Unit for DURATION_RELATION

FACTORY_CALENDAR

 

PERCENT_OF_SUC_PR

 

DURATION_KEY

 

WORK_CNTR

 

WORK_CNTR

 

Hito de elemento PEP

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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

 

Nivel: Campo auxiliar para transferir jerarquías del Sistema de proyectos

Task.Number20

Milestone_Indicator

Task.Milestone

ObjectType

Task.Text16

SubObjectType

Task.Text17

Grabar vista de proyecto de usuario

MilestoneTask.Number19

 

Hito de operación

Campo en el Sistema de proyectos del Sistema R/3

Campo en 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

Nivel: Campo auxiliar para transferir jerarquías del Sistema de proyectos

MilestoneTask.Number20

Milestone_Indicator

MilestoneTask.Milestone

ObjectType

MIlestoneTask.Text16

SubObjectType

MilestoneTask.Text17

Grabar vista de proyecto de usuario

MilestoneTask.Number19

 

 

 

 

Fin del área de contenido