How Core Fields are populated on Upload from SAP

Modified on Fri, 5 Jun at 3:45 PM

TABLE OF CONTENTS


SAP exports no Calendar, Profile, Successor or Structure objects, and has no real Schedule object. The connector synthesises the Schedule Code and a single global resource (SAP_Manhours) that every activity's work is assigned to. Only the fields SAP actually populates are listed.


Schedule Core Fields

Core field nameApi response fieldFormulaData typeDescription
StartedDate(connector clock)Set to the connector's current time, not read from SAPDateThe date the schedule started (or is planned to start).
Code(new GUID)A new GUID (synthetic; downstream Analytics requires a non-empty Code)TextThe schedule's unique identifier in the host system.


Resource Core Fields

Core field nameApi response fieldFormulaData typeDescription
Description(constant)Description = "SAP_Manhours"TextThe resource's name or title.
Code(constant)Code = "SAP_Manhours" (one global resource for the whole connector)TextThe resource's unique identifier in the host system.


Activity Core Fields

Core field nameApi response fieldFormulaData typeDescription
ActivityType(not set)Defaults to RegularActivityEnumThe kind of activity. Possible values: RegularActivity, MilestoneStart, MilestoneFinish, Hammock.
Descriptionoperation.Description
TextThe activity's name or title.
ActualStartconfirmation.ExecutionStartTimeFirst confirmation's ExecutionStartTime, if any confirmation existsDateThe date the activity actually started.
ActualFinishconfirmation.ExecutionFinishTimeFirst confirmation's ExecutionFinishTime, if any confirmation existsDateThe date the activity actually finished.
ActualWorkHoursconfirmation.ActWorkFirst confirmation's ActWork, if any confirmation existsNumberWork hours already expended on the activity.
EarlyStartoperation.StartTimeConstraint
DateThe earliest the activity can start (forward-pass schedule date).
EarlyFinishoperation.FinishTimeConstraint
DateThe earliest the activity can finish (forward-pass schedule date).
PlannedWorkHoursoperation.WorkActivity
NumberThe planned / budgeted work hours for the activity.
DurationHoursoperation.DurationNormal
operation.DurationNormalUnit
Convert the SAP duration to hours by unit (SEC, MIN, H, DAY, WEE, MON, ANN); work = 0 gives 0; an unknown/empty unit leaves it emptyNumberThe activity's duration in hours.
Codeorder.Orderid
operation.Activity
Code = "{order.Orderid}-{operation.Activity}" (hyphen-joined)TextThe activity's unique identifier in the host system.


Resource Assignment Core Fields

Core field nameApi response fieldFormulaData typeDescription
PlannedHoursoperation.WorkActivitySame hours figure as the activity's PlannedWorkHoursNumberPlanned work hours assigned to the resource on the activity.
Resource(global SAP_Manhours resource)The exported SAP_Manhours resource (same instance for every assignment)ReferenceThe resource assigned to the activity.
Codeactivity.Code
resource.Code
Code = "{activity.Code}|{resource.Code}" (pipe-joined)TextThe assignment's unique identifier in the host system.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article