Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member223938
Discoverer

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:

Data view: 2FR_FI01 creation in transaction FTWY:

Maintenance of DART attributes:

Maintenance of Data Segment as per the business requirement:

Maintain Join condition:

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

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

Data View Field mapping:

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

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

8 Comments
Labels in this area