Standard SAP Export

This export format corresponds to the standard accounting entry for the SAP accounting software.

This document will detail the data generated.

File format :

File type

CSV

Separator

;

File name format

CompanyName_yyyy-MM-ddThh-mm-ss-ms.csv

Software

SAP

Encoding

UTF8

File content:
  • Lines:

Group

By report

Credit lines

One line per report

Debit lines

One line per VAT rate

Currency

Employee currency

  • Columns :

Column Name

Type

Content

Example

Company Code 

Alphanumerical

Company code (Analytical axis 1)

Paris

Document Number 

Numerical

Report chronological number

1

Fiscal year 

Numerical

Fiscal year

2019

Doc Type

Alphabetical

Fixed Value : KB

KB

Document Date 

Date

Report submission date

Default value : dd.MM.yyyy

Configurable by Expensya support

24.12.2019

Posting Date

Date

Export generation date

Default format: dd.MM.yyyy

Configurable by Expensya support

24.12.2019

Fiscal Period     

Numerical

Fiscal year month number

12

Reference Document Number

Numerical

Report reference in Expensya

716

Currency Key

Alphabetical

Employee local currency in three characters

EUR

Ledger

 

Empty

Empty

Document header text

Alphanumerical

Report name in Expensya

My December 2019 Report

Fiscal year

Numerical

Fiscal year

2019

Company Code

Alphanumerical

Company code (Analytical axis 1)

Paris

Document Number

 

Numerical

Report chronologic reference

1

Posting Key

 

Numerical

· Invoice:

Debit: 40

Credit: 31

·Invoice credit :

Debit: 50

Credit: 21

40

Tax Code

 

Alphanumerical

Code corresponding to VAT rate in debit lines. Empty credit line. VAT codes configurable by Expensya support

Empty

Document Amount

 

Numerical

Amount per line type:

· Debit Line: Tax-free invoice amount in employee's currency by rate of VAT

· Credit Line: reimbursable value to the employee of the report in employee's currency

Value format configurable by Expensya support

400.0

Local cur Amt

 

Numerical

Same as Document Amount

Amount per line type:

· Debit Line: Amount of the base HT of the expenditure in employee's currency (Amount TTC - VAT recoverable) by rate of VAT

· Credit Line: reimbursable value to the employee of the Note in employee's currency

Value format configurable by Expensya support

400.0

Item Text                                        

 

Alphanumerical

Report name

My december 2019 report

Account Number

 

Alphanumerical

Account corresponding to the line

Debit line: Expense category expense account

· Credit Line: Employee Number

625100

Cost center

 

 

Empty

Empty

Profit Center

 

Empty

Empty

Order Number

 

Empty

Empty

WBS Element

 

Empty

Empty

Trading Partner

 

Empty

Empty

Calculate Tax Indicator

 

Fixed value

· Debit Line:

· X: if Recoverable VAT

· Credit Line: Empty

X

Quantity

 

Empty

Empty

Base unit of measure

 

Empty

Empty

Transaction Type

 

Empty

Empty

Business Area

 

Empty

Empty

Reference Key 1

 

Empty

Empty

Local Currency 2

 

Empty

Empty

Assignment

 

Empty

Empty

Special G/L indicator

 

Empty

Empty

SAP CSV export file example :

SAP CSV.xlsm


How did we do?


Powered by HelpDocs (opens in a new tab)