Standard SAP Export

Modified on Wed, 12 Mar, 2025 at 12:35 PM

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	TenantName_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
Tenant Code	Alphanumerical	Tenant 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
Tenant Code	Alphanumerical	Tenant 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