Service Entry Sheet Status Upload

This integration updates Service Entry Sheets (SES) for SOW line items associated to the SAP S4 and Ariba 4R2 integration workflow.

This connector is designed to work primarily with S/4 HANA and Ariba Network as part of 4R2; therefore, it cannot be customized for any other systems.

While this connector is similar in structure to the Service Entry Sheet Status Update XML Upload, this connector does not just approve the line item in pending approval, but approves all remaining levels and creates an automatic invoice in SAP Fieldglass, regardless of the invoice settings defined on the item. It populates the invoice code on the generated invoice object. The core purpose of the connector is to create a pro-forma invoice in SAP Fieldglass for the approved SES returning from SAP S/4 HANA. While the final and official supplier invoice is generated in Ariba Network (and sent to SAP Fieldglass via the Ariba Network Invoice Upload), the use of this upload generates an invoice in SAP Fieldglass sooner, allowing for an SES or line item revision to occur in SAP Fieldglass earlier in the workflow.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-A-V1.0

Format

XML

Prerequisites

Company Details Setting must be turned on for Integration – Service Entry Sheet Status Upload.

User role permission must be turned on for Upload Data and Download Data.

Predecessors

N/A

Related Connectors

Service Entry Sheet Status Update XML Upload

Ariba Network Invoice Upload

File Formatting

Data Dictionary

Elements and Attributes

Data Type

Length

Min/Max Occurrences

Value(s)/Format

Description/Use/Field Rules

<ServiceEntrySheetStsNotifMsg>

Wrapper

1/1

Group element for the download XML file. This group indicates the start and end of the entire XML file.

<Message Header>

Wrapper

1/1

Group element for the object reference.

<ReferenceID>

Text

16

1/1

Valid SAP Timesheet ID, Fieldglass ID of object that is approved/rejected.

Expense Sheet ID, SOW Fee, SOW Event, and SOW Schedule ID.

Example:

  • ABCDTU00000002

<ServiceEntrySheetStatusEntity>

Wrapper

1/*

Group Element for the status.

<ServiceEntrySheet>

Text

100

1/1

Example:

  • ABCDPE00000002

Indicates custom field.

<ApprovalStatus>

Number

1/1

Valid values are:

  • 30 (Approved)

  • 40 (Rejected)

Indicates status of approval.

<HasError>

Text

3

0/1

Valid values are:

  • Yes

  • No

  • Blank (no value)

Indicates if error.

<LogMessage>

Wrapper

0/1

Group Element for the log message. Only required when Has Error is true.

<LogMessageCode>

Text

100

Valid values are:

  • Code 404

Indicates message code. Only required when Has Error is true.

<LogMessageText>

Text

1000

1/1

Valid values are:

  • Error: Invalid

Indicates if error. Only required when Has Error is true.

The Service Entry Sheet Status Upload’s XML Schema Definition is also available at the following link if that format is preferred for the description of the connector: https://xxxx.us.fieldglass.cloud.sap/schema/ServiceEntryServiceUpload.xsd

Unique Identifier

  • Reference ID field

Custom Fields

  • This upload utilizes the provided <ServiceEntrySheet> id as the “invoice code” on the associated invoice when the item gets approve by the upload.

Assumptions/Tips

  • The upload uses the Approver ID of a user found in the current approval level of the item.

  • If there is more than one approver found in the level, the upload uses the top one. If no approver is found, then the upload generates an error.

  • The upload works for any approval level. If the item has four approval levels, but it is currently on the second approval level, then the upload progresses the item to the third level if the value is to approve the item. If the item is in the last approval level, then it approves the entire item altogether.

  • When the upload is to reject an item, then it updates the comment section using the concatenated values found on the tags <LogMessageCode> and <LogMessageText>.

  • If tag <ApprovalStatus> is set to '30', then the item is approved. If the tag '<ApprovalStatus> is set to '40' and tag <HasError> is set to 'Yes', then the item is rejected by the upload.

Errors

The following errors can occur when processing this upload file:

Possible Errors and Resolutions

Error Message

Resolution

Connector is not executed because migration is in progress for buyer

A buyer migration is in progress. The upload cannot be processed until the migration completes. Contact your System Administrator for information on when the migration will be complete.

Invalid values for ApprovalStatus

Enter one of the accepted values: 20 (Delete Acknowledgement), 30 (Approved), or 40 (Rejected) in the ApprovalStatus element.

Invalid values for ExternalReqId

The ReferenceID provided does not match a resolvable line item. Verify the ReferenceID in the upload file corresponds to a valid record and resubmit.

Invalid values for HasError

When ApprovalStatus is 40 (Rejected), HasError must be set to yes. Enter yes in the HasError element.

Invalid values for ReferenceID

An error occurred while resolving the ReferenceID. Verify the value is a valid Fieldglass reference ID and resubmit.

Missing data for ApprovalStatus

ApprovalStatus is required. Enter one of the accepted values: 20 (Delete Acknowledgement), 30 (Approved), or 40 (Rejected) in the ApprovalStatus element.

Missing data for IsDeleted

IsDeleted is required when ApprovalStatus is 20 (Delete Acknowledgement). Enter a valid value in the IsDeleted element.

Missing data for LogMessage

When ApprovalStatus is 40 (Rejected) and HasError is yes, at least one of LogMessageText, LogMessageCode, or Comments must be provided. Enter a rejection reason in one of these elements.

Missing data for ReferenceID

ReferenceID is required. Enter a valid Fieldglass reference ID in the ReferenceID element.

Missing data for ServiceEntrySheet ID

ServiceEntrySheet ID is required. Enter a valid value in the ServiceEntrySheet element.

This record has been archived. Contact your System Administrator if you believe you should have access to the record.

The line item referenced in the ReferenceID field has been archived and cannot be updated. Contact your System Administrator if you need to restore access to this record.