Kontakt

Ansicht
Dokumentation

RFFMFG_DATA_ACT_FILE_C_CREATE - US Federal: DATA Act File C Creation

RFFMFG_DATA_ACT_FILE_C_CREATE - US Federal: DATA Act File C Creation

TXBHW - Original Tax Base Amount in Local Currency   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You use this report to display and download US federal agency financial data for 'File C - Award Financial Detail' in support of the Digital Accountability and Transparency Act (DATA Act).

Prerequisites

Data elements not captured in the SAP US Federal Ledger, (for example 'Procurement Instrument Identified (PIID)', 'Financial Assistance Award' (FAIN)', 'Object Class', 'Program Activity' and 'Program Activity Name') can be derived at reporting time using secondary derivation rules (Transaction FMUSFG1 - Select GTAS Attribute Derivation at Time of Reporting).

Note: in the derivation steps, you can also use the derivation type 'Enhancement' (function module EXIT_SAPLFMFG_DERIVE_001, create SMOD for FMFGDT01) to maintain some of the derivations in ABAP code (use 'F5 - Source Text Enhancement') and retrieve additional attributes stored in further SAP tables and customer specific tables and fields.

To enable and optimize secondary derivation, you must add the RFFMFG_DATA_ACT_FILE_C_CREATE report name to the Report Selection table in Customizing activity Select Reports and Fields for Derivation. You must configure the Target Field Selectionand Source Field Selectionnodes under the Report Selectiondialog structure.

Note: The report is optimized to call the secondary derivation tool only once for each unique combination of source field values. If you select many source fields in the configuration, the report may take a long time to run. However, if you exclude a field from the source and target field lists, the result of the secondary derivation is affected: before the program calls the derivation, it clears the values of fields not defined as source fields (nonsource fields). For fields not defined as target fields (nontarget fields), the derivation is performed, but the original values of the fields are restored after the derivation call. Therefore, select source and target fields carefully.

You can further customize the call to the derivation tool at the time of reporting by implementing the Business Add-In BAdI: Reporting Attributes.

The report provides information on the level of Procurement Award Identifier (PIID) or Financial Award Identifier (FAIN) and it is therefore necessary to read information from the US federal ledger line item table (FMUSFGA). Both, the PIID and FAIN are not stored on the US Federal ledger itself but can be captured in other applications (see below) in the SAP ECC system. Using reporting derivation, a linkage can be established using the ledger field 'commitment string' (FMUSFGA- FMCMMTSTR_9) in conjunction with the above mentioned enhancement spot. The PIID can be stored using the SAP Smart Number functionality (https://help.sap.com/saphelp_srm70/helpdata/en/0b/59ee350831479eb83529e93994c902/content.htm ). For Procurement Awards (Purchase Orders) originating in SAP's Supplier Relationship Solution (SRM) the Smart number is passed along with the Purchase Order to the ECC Purchasing application. If an external procurement solution is interfaced into the ECC Purchasing application, BAPI 'BAPI_PO_CREATE1' can be used to fill the Smart number. This is done in the structure 'EXTENSIONIN'. In both cases (SRM interface or external procurement), the Smart Number is then stored in table/field '/SAPPSPRO/EADD-LONGNUM_UC'. Note that if manual entry of the PIID is required on the Purchase Order in SAP's Materials Management Application, it is also possible to store this in a customer defined field and read the data from there.

If you are using Earmarked Funds documents, the PIID or FAIN can be entered on the header of the earmarked fund (KBLK-XBLNR2). The enhancement spot needs to be maintained in this case as well.

Features

If you select the Use Secondary Derivationcheckbox and complete the required prerequisite configuration, the program calls the secondary derivation only once for each unique combination of source field values.

If you slect the option Check PIID and FAINand enter individual PIID's or FAIN's (multiple entries possible, ranges are not allowed) in the selection, an application log is created in the report output. The application log then lists all the PIID's and FAIN's from the selection for which no record could be found.

Selection

On the DATA Act File Creation screen in the Selections section, enter the following:

  • Company code
  • Fiscal year
  • Posting Period (from-to)
  • Business area(s)
  • SGL account(s)
  • Funds Application
  • Fund
  • Commitment Item
  • PIID (Procurement Instrument Identifier)
  • FAIN (Financial Award Identifier)
  • Commitment String

In the Output Controlsection, specify the path and file name where you want the report output to be saved. Choose 'Test Run' if applicable.

You can also limit the display to a certain number of records by filling the 'Records Displayed' field.

Output

The system downloads all the data as a comma separated file (.csv). You can access the file using Microsoft Excel, Microsoft Notepad or other common text editors. After reviewing the file and ensuring it is correct, you can submit it to the US Treasury.

Note: Due to the size and length, the file might need to be downloaded with transaction 'CG3Y- Download File' rather than with transaction 'AL11 - Display SAP Directories'.

The records that are downloaded to the file are also displayed in the SAP List Viewer (ALV) results screen with additional fields for validation (such as Company Codeand FM Area).






General Material Data   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 6596 Date: 20240601 Time: 053238     sap01-206 ( 138 ms )