SAP Commitments Import - EcoSys - 1.3 - Connectors & Integration - Hexagon

SAP Connector Field Mappings (1.3)

ft:locale
en-US
Product
EcoSys
Search by Category
Connectors & Integration
EcoSys Version
1.3

SAP Field

SAP Table

SAP Field Description

EcoSys Field

EcoSys Field Type

OBJNR

COOI

Object number

Cost Object External Key

*

COOI

N/A

External Key

SAKTO

COOI

Cost element

Cost Account

REFBN

COOI

Reference Document Number

PO Task External Key

BLDAT

COOI

Document Date

Transaction Date

MEGBTR/GESMNG

COOI

Total Quantity

Transaction Units

WTGBTR

COOI

Total Value in Transaction Currency

Transaction Cost

ORGWTT

COOI

Planned Value in Transaction Currency

SAP Plan Value in Transaction Currency

Custom Field

ORGWTO

COOI

Planned Value in Object Currency

SAP Plan Value in Object Currency

Custom Field

ORGWTK

COOI

Planned Value in Controlling Area Currency

SAP Plan Value in CA Currency

Custom Field

GESMNG

COOI

Planned Quantity

SAP Plan Quantity

Custom Field

MEGBTR

COOI

Total Quantity

SAP Total Quantity

Custom Field

WTGBTR/ORGWTT

COOI

Total Value in Transaction Currency

SAP Total Value in Transaction Currency

Custom Field

WOGBTR

COOI

Total Value in Object Currency

SAP Total Value in Object Currency

Custom Field

N/A

N/A

N/A

SAP Original Object Path

Custom Field

WKGBTR

COOI

Total Value in Controlling Area Currency

Transaction External Cost

TWAER

COOI

Transaction Currency

Transaction Currency

WAERS

T001

Company Code Currency

SAP Object Currency

Custom Field

WAERS

TKA01

Controlling Area Currency

External Currency

MEINH

COOI

Unit of Measure

Unit of Measure

Custom Field

BUKRS

COOI

Company Code

SAP Company Code

Category

KOKRS

COOI

Controlling Area

SAP Controlling Area

Category

WERKS

EKPO

Plant

SAP Plant

Category

REFBT

COOI

Reference Document Category (Conversion Exit; See REFBTYP)

SAP Reference Document Category

Category

RFTYP

COOI

Reference procedure

SAP Purchasing Transaction Type

Category

WRTTP

COOI

Value Type

SAP Commitment Type

Category

LOEKZ

COOI

Deletion Indicator in Purchasing Document

SAP PO Status

Category

EREKZ

EKPO

Final Invoice Indicator

SAP Commitment Status

Category

ELIKZ

EKPO

Delivery Completed Indicator

SAP Delivery Completed Indicator

Category

WEPOS

EKPO

Goods Receipt Indicator

SAP Goods Receipt Indicator

Category

SGTXT

COOI

Segment text

Line Item Text

Custom Field

BUDAT

COOI

Expected Debit Date

SAP Expected Debit Date

Custom Field

BLDAT

COOI

Document Date

Document Date

Custom Field

UNAME

COOI

User Name

SAP User Name

Custom Field

TIMESTMP

COOI

Seconds since 1.1.1990,0:00 GMT * 10000

SAP Timestamp

Custom Field

GJAHR

COOI

Fiscal Year

SAP Fiscal Year

Custom Field

LEDNR

COOI

Ledger for Controlling Objects

SAP Ledger Number

Custom Field

NETPR

EKPO

Net Price in Purchasing Document (in Document Currency)

Purchase Order Net Price Per Unit

Custom Field

INCO1

EKPO

Incoterms (Part 1)

Delivery Terms

Custom Field

INCO2

EKPO

Incoterms (Part 2)

Point of Freight On Board

Custom Field

BANFN

EKPO

Purchase Requisition Number

SAP Purchase Requisition Number

Custom Field

TXZ01

EKPO

Short Text

Item Description

Custom Field

KONNR

EKPO

Number of principal purchase agreement

SAP Contract Number

Custom Field

KTPNR

EKPO

Item Number of Principal Purchase Agreement

SAP Item Number

Custom Field

RFPOS

COOI

Item Number of Reference Document

SAP Purchasing Document Line Item Number

Custom Field

MATKL

EKPO

Material Group

SAP Items Group

Custom Field

MATNR

COOI

Material Number

SAP Material

Custom Field

WKURS

COOI

Exchange Rate

Currency Exchange Rate

Custom Field

ABLAD

EKKN

Unloading Point

Unloading Point

Custom Field

AUGDT

BSAK

Clearing Date

SAP Clearing Date

Custom Field

LIFNR

COOI

Account Number of Supplier

SAP Vendor

Category

RFKNT

COOI

Account Assignment Number of Reference Document

SAP Account Assignment Number

Custom Field

RFTRM

COOI

Deadline Item of Reference Document

SAP Deadline Item of Reference Document

Custom Field

RFART

COOI

Reference Document Type

SAP Reference Document Type

Category

HRKFT

COOI

CO key subnumber

SAP CO Key Subnumber

Custom Field

RFORG

COOI

Reference Organizational Units

SAP Reference Organizational Units

Custom Field

RFSYS

COOI

Logical system of source document

SAP Logical System of Source Document

Custom Field