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 | 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 :
