Programme SAP RFKK_CUST_EXTR_EXP - Customizing Data Extraction


trados = docu -> fi -> fica

Purpose
The report creates an FI-CA Customizing extract and exports this as textfile.

Efg_integration
In Germany, auditors must have access to all document posted in the last10 years as part of the German Tax Reduction Act. In Contract AccountsReceivable and Payable, all documents are therefore stored in short formin tables DFKKKO_SHORT, DFKKOP_SHORT, andDFKKOPK_SHORT (provided byFPDE_EXP, FPDE_IMP). However, thereare some fields in these tables whose meaning is not clear without thelong text. You can therefore save the long texts for documents in tableDFKKCUST_SHORT. You can use the following transactions tomanage thistable:

  • FPDEC_EXP: Export extract (key fields and long texts) to a file

  • FPDEC_IMP: Import Customizing extract
  • to table DFKKCUST_SHORT
    • FPDE_EXTR: Export data extract (reduced
    • data from DFKK*_SHORT) for furtheranalysis purposes (audit)
      • FPDE: Overview of imported extracts

      • FPDEC_DEL: Deletion of imported extracts
      • Selection
        The selection is made according to the language key of the long text.All Customizing tables supported are always exported together. You needthe fiscal year to differentiate between different datasets. This meansthat Customizing can be exported and imported once each fiscal year. Thedocuments posted in this fiscal year reference to Customizing from thisextract.

        Output

        CSV for SAP Import
        The report generates a file with an extract from Customizing. The fileconsists of several records. Each record is displayed in one line. Thefields are separated by semicolon (;).
        The following record types are used:

        • 00 Fields for each record type used

        • CH Extract header, once per file

        • CP Customizing data, the key fields are grouped

        • You can import data in this format to an FI-CA evaluation system (
          FPDE_IMP).

          SAP Audit Format
          In the SAP Audit Format, the file contains a data description in thefirst eight lines. This format can be imported directly to IDEA. Foreach Customizing table exported, a separate file is created.

          Note