SAP Program RFFMFG_IPACED - IPAC Download File Process

Title
US Federal IPAC Download File Process - Receiving Incoming 'Download'File

Purpose
The IPAC Download File process is to respond to an incoming"download" file from other U.S. Federal agency as a trading partner ofours. The incoming download file was downloaded by another agency andsent to Treasury as an outgoing IPAC bulk file.
This program handles both collection and payment transactions. Its mainfunctions are as follows:

  • Upload the incoming download file originally sent by another Federal
    • agency to the Treasury department. After consolidation by the Treasurydepartment, the download file composes collection and paymenttransactions for multiple agencies.
    • Convert CSV file - Comma Separated Values, to be readable by the program

    • Extract transactions from the incoming download file according to the
      • selection criteria
      • Identify the appropriate original invoice, either payment or collection

        • ,per extracted transaction from the incoming download file. The maindrivers for this process are the incoming file fields as follows:
        Invoice Document Number
        Obligating Document Number
        Purchase Order Number
        Application of Funds (Receiver Treasury Account Symbol).
        • Determine process to be performed for the 'matched' document. This
          • couldbe a partial payment, full payment, document clearing and/orcreation of a new document. All of these actions are posted against theFunds Balance with Treasury (FBT) account.
          • Generate a result list containing cleared and failed invoices out of the
            • transactions from the incoming download file
            • Generate a standard error log.

              • Integration
              If you would need to reverse the documents created by the IPAC DownloadFile process, you can use the report IPAC Download File Reverse Process
              ,transaction FMFG_IPACED_REVERSE to dothis.

              Selection
              Input interface of the program is "US Federal IPAC Download File ProcessReceive Incoming 'Download' File". The selection screen has thefollowing sections:

              • Receiver Information

                • The receiver is IPACed by the initiator, receiving the incoming downloadfrom the Treasury department. The file contains payment and collectiontransactions of receiver's (IPACed agency) trading partners.
                The IPACed agency information includes its company code and AgencyLocation Code (ALC).
                • Download File Information

                  • Input incoming IPAC download file's fully qualified address and itsphysical location. This can be either in a local workstation or anapplication server. The expected file format is a CSV file.
                  • Clearing Document

                    • Enter the document date, posting date, and posting period of the newdocuments to be created.
                    • Post SGL File

                      • Input Post SGL file's fully qualified address and its physical location.can be either in a local workstation or an application server.
                      • Processing Options

                        • Check the Test Run box if you want to run the program in testmode first.

                        Output
                        A standard ALV result list, rejected records list, and an error log aregenerated to reflect the contents of the IPAC Download File processingand a processing log.
                        If you execute the program online, you will be able to process multiplerows from the ALV results list.
                        If you execute the program in background processing, we recommend thatyou schedule a background job using transaction SM36. In this way, youcan specify the application server where the Incoming Download File is.

                        Activities
                        If you want use the Auto Document Creating feature, you must first carryout the following steps in Customizing:

                        • Public Sector Management -> Functions for US Federal Government ->
                          • Payment Processing -> Intragovernmental Payments and Collections (IPAC)-> Activate IPACed Automatic InvoiceGeneration.
                          • Public Sector Management -> Functions for US Federal Government ->
                            • Payment Processing -> Intragovernmental Payments and Collections (IPAC)-> IPACed Auto Doc Creation - AccountAssignment Derivation.
                            • Public Sector Management -> Functions for US Federal Government ->
                              • Payment Processing -> Intragovernmental Payments and Collections (IPAC)-> IPACed Automatic Document Creation:Default fields for Invoice .
                              If you want to change the original 'Matched' account assignment you havethe possibility to implement the Business Add-In (BAdI) MethodGET_ACCOUNT_ASSGM of the BaDI Definition BADI_IPAC. You can do this intransaction SE19 or in Customizing as follows:
                              • Public Sector Management -> Functions for US Federal Government ->
                                • Payment Processing -> Intragovernmental Payments and Collections (IPAC)-> BAdI: Override IPAC Standard Code