Skip to Content

Applies to:

FICO DART Extract being developed in SAP ECC 6.0.

Summary:

This document will help in creating a DART Extract for the France country Article A47 A-1

  – To provide an overview of the France Article A47 A-1

  – Explain the Field requested by France administrative

  – To list the configuration steps needed to activate France DART View

Introduction

France Article A47 A-1

Computerized accounting systems and transfer of electronic data to the tax administration for the purpose of tax inspections

An administrative order dated 29 July 2013 has modified the provisions of article A47 A-1 of the French tax procedure handbook with regard
to requirements for copies of computer files. It requires companies to communicate, if so requested by the French administration in the context of tax
inspections announced on or after 1st January 2014, all their accounting records in the form of aunique dematerialized “accounting records file” in a predefined format.

The file must include the detailed final accounting entries booked throughout the financial year, as well as the applicable opening balances. All the accounting data available in the company’s computerized accounting system must be included in the file, whose first eighteen fields for each accounting entry must obligatorily reflect, in the same order, those listed in a table defined by the tax authority.

Objective

This document explains step by step in setting up Data view creation as per the French administrative requirement.

Business Requirement

As per new French fiscal procedure article A47 A-1 , French company should be able to deliver an extraction of general ledger for complete
fiscal year with a certain list of fields and in a particular format.

Solution 

To meet the legal requirements of France where DART is used to report to tax authorities. The pre-requisite DART release in the system should be DART 2.6 or DART 2.6e or DART 2.7.

Following SAP note implementation has to be done as prerequisites for the View configuration:

-1935509 – Carry forward postings for new GL in France

-1923322 – DART: View file creation for France Legal Requirement

-1906078 – FTW1A: BADI for additional selections from BKPF

They are all contained in the note 1933144. These notes also refer to the French law and to the general flow up to the production of the DART.

  1. S.No

INFORMATION

FIELD NAME

1

The log book entry code

JournalCode

2

The newspaper wording of the accounting entry

JournalLib

3

The number on a continuous sequence of the accounting entry

EcritureNum

4

The accounting date of the accounting entry

EcritureDate

5

Account number, the first three characters must match figures
  respecting the norms of French accounting plan

CompteNum

6

The wording of account in accordance with the nomenclature of
  the French accounting plan

CompteLib

7

Sub-account number (blank if not used)

CompAuxNum

8

The wording of sub-account (blank if not used)

CompAuxLib

9

Reference Exhibit

PieceRef

10

The date of the voucher

PieceDate

11

The wording of the accounting entry

EcritureLib

12

The debit amount (Sens)

Debit  (Sens)

13

The amount of credit(Sens)

C redit (Sens)

14

Lettering writing (blank if not used)

EcritureLet

15

Date of lettering (white if not used)

DateLet

16

The date of validation of the accounting entry

Validdate

17

C urrency amount (blank if not used)

Montantdevise

18

The identifier of the C urrency (blank if not used)

Idevise

 

SAP Mapping Fields:

sdart_1.PNG

Data view: 2FR_FI01 creation in transaction FTWY:

Capture.PNG

Maintenance of DART attributes:

Capture.PNG

Maintenance of Data Segment as per the business requirement:

Capture.PNG

Maintain Join condition:

Capture.PNG

Creation a set to restrict the extract selection based on business requirement if any:

Capture.PNG

Set Creation to restrict the extract selection based on business requirement if any:

Capture.PNG

Data View Field mapping:

Capture.PNG

Capture.PNG

Save the Dart View and Activate view
After Activation of the Dart View a program will be generated 

Capture.PNG

Note:

1. In addition to the 18 fields I have included Year in the report to restrict the values of the specific fiscal Year

2. If you want to add any field which is not in SAP note 0001923322 take the proactive step on following things:

  1. To update additional field entries in the tableTXW_LANGU_TEXT, create customized view for the table TXW_LANGU_TEXT as the program
    ZTXW_LANGU_TEXT only update 18 field text.
  2. Include additional field in the View Fields (FTWY)

3. In the View Fields of DART mark Entry Date (CPUDT) as a group so that sort will be done based on Entry date

4. Further restriction on the extract can be controlled by Selection condition in the DART data Segment

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Sathish K

    Hi George,

    The French requirement specifies the particular sorted order which is why the view definition is maintained in that way.

    To have further information there is also FAQ note 1951943 which is available .

    (0) 
    1. Sathish K

      Hi Cara,

      The BADI has substitute if the field is blank. There is a note 2162977 which lists all the notes that are to be implemented!

      Sathish

      (0) 

Leave a Reply