Purchase Unit Upload

This integration uploads purchase units.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Purchase Unit Upload

Company plug-ins must be turned on for Integration – Purchase unit and Use legal entity

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

Predecessors

Legal Entity

Related Connectors

Legal Entity Upload

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

Upload file type

Purchase Unit Upload

Language

No

Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language.

The valid language values are:

Arabic (Standard Arabic)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

Number Format

No

Determines the number format to be used in the file.

The valid values are:

  • “#,##9.99" (Example: "1,234,567.99”)

  • “#.##9,99" (Example: "1.234.567,99”)

  • “#'##9.99" (Example: "1'234'567.99”)

  • “# ##9,99" (Example: "1 234 567,99”)

The quotes are required even if the value does not have a comma in it. If this field is not included in the header, the default value will be "#,##9.99" (Example: "1,234,567.99").

Comments

No

Upload Comments

 This is a comment field containing notes about the upload file.

Immediately following the Header section of the upload is one blank line.

Detail

Column Header Name

Data Type

Field Length

Required?

Value(s)/Format

Description/Use/Field Rules

Modification Type

Char

1

Yes, for Deletes only.

Valid values are:

  • A

  • U

  • D

  • Blank (no value)

A – Add

U – Update

D – Delete

Blank – When an existing Purchase Unit Code is entered, SAP Fieldglass identifies it as an update, whereas, when a new Purchase Unit Code is entered, SAP Fieldglass identifies it as an Add.

Purchase Unit Code

Text

100

Yes

A valid SAP Fieldglass Purchase Unit Code.

Example:

  • 1001

Code that uniquely identifies the purchase unit.

Purchase Unit Name

Text

100

Yes

Valid SAP Fieldglass Purchase Unit Name.

Example:

  • Accounting

Value that uniquely describes the purchase unit in more recognizable terms than the Purchase Unit Code.

Purchase Unit Description

Text

1000

No

Optional long text description of the purchase unit.

Unique Identifier

  • Purchase Unit Code field

Assumptions/Known Issues

  • The Purchase Unit can be linked to the Legal Entity in the Legal Entity Upload.