Programme SAP RTINV_DOC_EXTR_EXTR - Evaluation and Export of Incoming Bills in Evaluation System

Purpose
In an evaluation system based on short tables, this report selects thetax-relevant information from IS-U incoming invoices and

  • Extracts the data to a CSV file

  • Extracts this data to AIS files

  • Displays the data in ALV

  • This depends on the parameters in the selection screen.

    Prerequisites
    The data must have been imported into the short tables of the evaluationsystem previously (Report RTINV_DOC_EXTR_IMP).

    Selection
    You can make the following entries in the selection screen:

    • In the "Selection of Data Range" frame, you limit the amount of extract
    • data for incoming invoices to be processed according to transfer date(to FI-CA), business partner, contract account, internal document numberand company code.
      • In the "Output Format" frame you define the processing type:

      • Select the "Screen Output ALV" to display the data in ALV lists. Uponexecution you get an overview list in which all invoice document data isdisplayed in a big ALV grid list. If you double-click an invoicedocument, all header data, document data, line items and transfer dataare displayed on another screen. You can use the buttons in the detailview to navigate to the previous or next document.
        Select parameter "File (CSV)" to extract the selected data to a CSVfile.
        Select parameter "File (SAP Audit Format)" to extract the selected datato an AIS file (each record type - invoice header, document, line item,transfer data - has its own file).
        In the "Line Layout" parameter you can optionally specify the ID of alayout (maintenance with transaction FPSELP1") which defines the recordtypes and fields of the respective record types to be taken intoaccount. If you leave this parameter empty, all short tables with alltheir columns are taken into account. You can display the definition ofthe specified layout by clicking the "Detail" button.
        • In the "Output File" frame you define the target file if you want to
        • output a file:
          Under Name, enter a file name to be created. In the case of an AIS fileexport, for each extracted structure the extract ID is added to thisname (IH=Incoming Invoice Header, ID=Incoming Invoice Document,IL=Incoming Invoice Line Item, IT=Incoming Invoice Transfer Data) tocreate a unique file name.
          For extract to a local file, the file name thus constructed is useddirectly.
          For extract to a file on the application server, the file name isgenerated from the parameter for creating the file name via the logicalfile name "TINV-DOC-EXTRACT" (transaction FILE). There the compound filenames are applied as the physical file name. The files are stored in thelogical path TMP.
          Select the parameter "Local File" if you want to extract to a local fileon the front end.
          Select "Overwrite File" if you want to overwrite a file with the samename.
          Please note that processing a large volume of data in the dialog foroutput in a list or a local file is not useful and can cause runtime orcapacity problems.

          Output
          Depending on how the parameters are set, the selected data is written toCSV or AIS files or output on the screen in ALV lists.
          In an ALV list you have the option of displaying the data of a singledocument in detail by double-clicking or selecting the document andclicking the button.