Transcription

SAP Configuration Guide for theStandard Financial InformationStructure (SFIS – BEA 8.0)May 16, 2011SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 1

Version HistoryVersionPublication DateAuthorDescription of Change1.0May 16, 2011BTA EI COE TeamStandard Financial Information StructureSAP Configuration Guide 8.0SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 2

Table of ContentsVersion History . 2Acronym List . 5Executive Overview . 7A1 - Department Regular Code . 9A2 - Department Transfer Code . 11A3 - Main Account Code. 13A4 - Sub-Account Code. 15A5 - Apportionment Category Code . 17A6 - Receipt Indicator . 19A7 - Sub Classification Code . 21A9 - Reimbursable Flag Indicator . 23A10 - Fund Type Code . 25A11 - Advance Flag Code. 27A12 - Authority Type Code . 29A13 - Availability Time Indicator . 31A14 - Borrowing Source Code . 33A15 - Definite Indefinite Flag Indicator . 35A17 - Program Report Code . 37A18 - TAFS Status Indicator . 39A19 - Year of Budget Authority Indicator. 41A20 - Direct Transfer Agency Code . 43A21 - Direct Transfer Account Code . 45A24 - Availability Type Code . 47A25 - Expiration Flag Indicator . 49A26 - Financing Account Indicator Code. 51A27 - Beginning Period of Availability . 53A28 - Ending Period of Availability. 55B1 - Budget Function/Sub-Function Code . 57B2 - Budget Activity Identifier. 59B3 - Budget Sub Activity Identifier. 61B4 - Budget Line Item Identifier . 63B6 - Object Class Code . 65B8 - Contingency Code . 68B9 - BEA Category Indicator Code . 70CA1 - Funding Center Identifier . 72CA3 - Cost Center Identifier. 74CA4 - Project Identifier . 76CA5 - Activity Identifier . 78CA6 - Cost Element Code. 80CA7 - Work Order Number . 82CA9 - Transaction Quantity . 84CA10 - Unit of Measure Code . 85CA12 - Asset Unique ID . 87CA14 - MEPR Code. 89O1 - Organization Unique Identifier . 91O2 - Agency Disbursing Identifier Code . 93O3 - Agency Accounting Identifier Code . 95T1 - Transaction Type Code . 97SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 3

T2 - USSGL/DoD Account Code . 99T3 - Debit/Credit Indicator . 101T4 - Begin/End Indicator . 103T5 - Transaction Effective Date. 105T6 - Transaction Post Date . 107T7 - Transaction Amount . 109T9 - Exchange/Non-Exchange Indicator . 111T10 - Custodial/Non-Custodial Indicator . 113T11 - Foreign Currency Code . 115T12 - Country Code . 117T13 - Entity/Non-Entity Indicator . 119T14 - Covered/Uncovered Indicator . 121T15 - Current/Non-current Indicator . 123T20 - Business Event Type Code . 125T21 - FMS Customer Code . 126T22 - FMS Case Identifier . 128T23 - FMS Case Line Item Identifier . 130TP1 - Federal/Non-Federal Indicator . 132TP2 - Trading Partner Indicator Code . 134TP3 - Business Partner Number . 136SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 4

Acronym nts PayablesBudget Control SystemBudget Enforcement ActBusiness Enterprise ArchitectureBusiness Event Type CodeBusiness Partner NumberBusiness Transformation AgencySAP Controlling ModuleCenter of ExcellenceDefense Agencies InitiativeDefense Information Systems AgencyDisbursements-In-TransitDepartment of DefenseAgency Disbursing IdentifierData Universal Numbering SystemExpeditionary Combat Support System (ERP System)BTA Enterprise IntegrationSAP Enterprise PortalEnterprise Resource PlanningFederal Agencies' Centralized Trial-Balance SystemFunds Balance with TreasurySAP Finance ModuleSAP Funds Management ModuleForeign Military SalesFiscal YearGeneral Fund Enterprise Business System (ERP System)General LedgerHypertext Transfer Protocol SecureInternational Organization for StandardizationMedical Expense and Performance ReportingMilitary ConstructionMilitary PersonnelMedical Treatment FacilityOperations & MaintenanceOffice of Management and BudgetOffice of the Secretary of DefenseOrganization Unique IdentifierOffice of the Under Secretary of DefenseSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 5

USCUSSGLWBSWCFXMLSAP Project Systems ModuleResearch, Development, Test & EvaluationReal Property Unique IdentifierSub Account GroupService(s) in this document refer to Web Service(s)Standard FormStandard Financial Information StructureStandard General LedgerSubject Matter ExpertSecure Sockets LayerTreasury Appropriation Fund SymbolUnique Asset IDUnique Item IdentifierUnited States CodeUnited States Standard General LedgerWork Break Down StructureWorking Capital FundExtensible Markup LanguageSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 6

Executive OverviewStandard Financial Information Structure (SFIS), commonly pronounced "ess-fis", is acomprehensive "common business language" that supports information and data requirements forbudgeting, financial accounting, cost/performance management, and external reporting across theDoD enterprise. SFIS standardizes financial reporting across the Department of Defense (DoD),thereby reducing the cost of auditability.This document was developed in support of the SFIS directive identified in the BEA 8.0 andprovides guidance to system owners and reviewers on what should be implemented in their SAPbased system(s) to be compliant with the overall SFIS program guidance for both data and businessand required business rules.This Guide encompasses directions for configuring the SFIS elements within the SAP ERP familyof programs. The contents and format of the guide will be advantageous to both experienced SAPconfigurators as well as subject matter experts (SMEs) and auditors whose tasks are more specific.Users of this guide should at least posses working knowledge of the SAP application and its financialcapabilities. It is highly recommended that the guide be consulted before attempting to configureany SFIS elements.The configuration settings contained herein provide relevant information for each of the SFISelements following a consistent sintax structure so that users can easily obtain the necessaryinformation for configuring each of the elements. Each SFIS element is described as follows: SFIS Element Details – Element Number, Name and Attributes, SFIS Component, aDescription, an Example, Comments and the Authoritative Source.Associated Business Rules – Business Rule Number and Description.Design Considerations – Field Types and Characteristics.Process Walthrough – Module, Navigation, SAP Transaction Code, Form Field Name, TableName, and Related Transactions.Screen Captures – Illustrates the relevant windows and fields as appropriate.SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 7

The guide presumes that the following characteristics are configured and assigned to appropriateclassification.SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 8

A1 - Department Regular CodeSFIS Element:SFIS Component:Description:Example:Comment:Source:A1 - Department Regular CodeLength:3Appropriation Account InformationDepartment Regular is the U.S. Treasury designated code representing thegovernment agency accountable for one or more fund accounts establishedand maintained by the Treasury. The Department Regular element is anintegral part of the Treasury Appropriation Fund Symbol (TAFS).CodeAgency097DoD, Office of the Secretary of Defense021Department of the Army017Department of the Navy057Department of the Air Force096Corps of EngineersDepartment Regular is a field on the Application of Funds Master Recordin SAP. Application of Funds Master Data is equivalent to“Appropriation” in that the Application of Funds describes a “mainaccount” tied to a particular “beginning and ending FY” and linked to a“department regular” and “department transfer” value if applicable.Allowed treasury values are inserted in the “Department Regular” fieldwhen creating a new “Application of Funds”. Since Funds are alwaysassigned to an Application of Funds – the Department Regular for theAppropriation will be linked to all financial transactions in the system.http://fms.treas.gov/fastbook/BUSINESS RULES#Business RuleA1 Department Regular Code must be 3 numeric characters. ex. 097 (Note: Programs mayuse the two character code and derive the three character version - with a leading zero - attime of reporting if the software system in use has not yet been updated).Authoritative source: http://fms.treas.gov/fastbook/A1 Each accounting system must store and maintain Department Regular Code values.A1 A Department Regular Code must be established in the accounting classification structurewhen the appropriation is signed by the President and must be maintained until availablefunding has been canceled.DESIGN CONSIDERATIONSDeliveredFieldXDerivedFieldFACTSI & IIXFundXSAP Configuration Guide for SFIS – BEA emAreaMay 2011FundedProgramApplicationof FundsPage 9

PROCESS WALKTHRUModule:FMNavigation:Accounting-Public Sector Management-Funds Management- MasterData-Account Assignment Element- Fund- Application of FundsDisplaySAP Trans Code:CT04 & FM6SForm Field Name:Display Application of FundsTable Name:IFMFUSEField Name:DEPT REG & ATNAMRelated Transactions: FM6I, CT10Screenshot: Location of “Department Regular” Field on Field on Display CharacteristicsSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 10

A2 - Department Transfer CodeSFIS Element:SFIS Component:Description:Example:Comment:Source:A2 - Department Transfer CodeLength:3Appropriation Account InformationThe Department Transfer Code identifies the federal agency of obligationauthority to the DoD or one of its components. For the transfer ofobligation authority, the transfer agency retains responsibility for the fundaccount and the recipient agency charges against the fund account of thetransfer agency.Department Transfer No.089 - In this example, the Department TransferValue "089"indicates transfer of obligation authority from Dept of Energy.The field is left blank if no transfer is involved.Department Transfer is a field on the Application of Funds Master Recordin SAP. Application of Funds Master Data is equivalent to“Appropriation” in that the Application of Funds describes a “mainaccount” tied to a particular “beginning and ending FY” and linked to a“department regular” and “department transfer” value if applicable.http://fms.treas.gov/fastbook/BUSINESS RULES#Business RuleA2 Department Transfer Code must be 3 numeric characters. ex. 097 (Note: Programs mayuse the two character code and derive the three character version - with a leading zero - attime of reporting if the software system in use has not yet been updated).Authoritative source: http://fms.treas.gov/fastbook/A2 Department Transfer Code must be used for accounting classification, general ledgerposting, financial reporting, budgetary control, and funds control.A2 Each accounting system must store and maintain Department Transfer Code values.DESIGN CONSIDERATIONSDeliveredFieldXDerivedFieldFACTSI & alItemAreaFundedProgramApplicationof FundsXPROCESS WALKTHRUModule:FMNavigation:Accounting-Public Sector Management-Funds Management- MasterData-Account Assignment Element- Fund- Application of FundsDisplaySAP Trans Code:CT04 & FM6SForm Field Name:Display Application of FundsTable Name:IFMFUSEField Name:DEPT TRANRelated Transactions: FM6I, CT10SAP Configuration Guide for SFIS – BEA 8.0May 2011Page 11

Screenshot: Location of “Department Transfer” Field on Display CharacteristicsSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 12

A3 - Main Account CodeSFIS Element:SFIS Component:Description:Example:Comment:Source:A3 - Main Account CodeLength:4Appropriation Account InformationThe main account is identified by a four digit numeric data elementrepresenting a specific appropriation or fund account established by the USTreasury for expenditure or receipt authority issued by the US Congress.Main Account Account Name0740Family Housing Construction, Air Force2020Operation & Maintenance, Army2040Research, Development, Test & Eval, Army2050Military Construction, Army4557Revolving Fund, National Defense Sealift5095Wildlife Conservation, Military Reservations8097Military Retirement Fund, DefenThe main account is identified by a four digit numeric data elementrepresenting a specific appropriation or fund account established by the USTreasury for expenditure or receipt authority issued by the US Congress.http://fms.treas.gov/fastbook/BUSINESS RULES#Business RuleA3 Each Main Account Code must be associated with only one Fund Type Code.A3 Each Main Account Code must be associated with only one Budget Function/SubFunction Code.A3 Main Account Code must be 4 numeric characters. ex. 0740Authoritative source: http://fms.treas.gov/fastbook/A3 Main Account Code must be used for accounting classification, general ledger posting,financial reporting, budgetary control, and funds control.A3 Each accounting system must store and maintain Main Account Code values.A3 A Main Account Code must be established in the accounting classification structure whenthe appropriation is signed by the President and will be maintained until available fundinghas been canceled.DESIGN CONSIDERATIONSDeliveredFieldXDerivedFieldFACTSI & IIXFundSAP Configuration Guide for SFIS – BEA emAreaMay 2011FundedProgramApplicationof FundsXPage 13

PROCESS WALKTHRUModule:FMNavigation:Accounting-Public Sector Management-Funds Management- MasterData-Account Assignment Element- Fund- Application of FundsDisplaySAP Trans Code:FM6SForm Field Name:Display Application of FundsTable Name:IFMFUSEField Name:DEPT TRANRelated Transactions: FM6I, FM6UScreenshot: Location of “Main Account” Field on Application of Funds Master RecordSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 14

A4 - Sub-Account CodeSFIS Element:SFIS Component:Description:Example:Comment:Source:A4 - Sub-Account CodeLength:3Appropriation Account InformationSub-Account Code is a field on the Application of Funds Master Record inSAP. Application of Funds Master Data is equivalent to “Appropriation”in that the Application of Funds describes a “main account” and “subaccount” tied to a particular “beginning and ending FY” and linked to a“department regular” and “department transfer” value if applicable.Allowed treasury values are inserted in the “Main Account” and “SubAccount” field when creating a new “Application of Funds”. Since Fundsare always assigned to an Application of Funds – the Sub-Account will belinked to all financial transactions in the system.The following Sub-Accounts have been established specifically for thepurpose of subdividing the DoD Defense Wide Working Capital FundAccount 4930, as follows:97X4930.001 Defense Working Capital Fund, Army 31USC153597X4930.002 Defense Working Capital Fund, Navy 31USC1535The Sub-Account might indicate a series of subsidiary level receiptaccounts or represent special subsidiary level accounts requested for use byan agency and approved by the US Treasury.http://fms.treas.gov/fastbook/BUSINESS RULES#Business RuleA4 Every financial transaction processed must have a valid Sub-Account Code.A4 The Sub-Account Code must be defaulted to “000” when one of the Treasury SubAccount Code conditions does not apply.A4 Sub-Account Code must be 3 numeric characters. ex. 97X4930.001 (last 3 positionsfollowing period)Authoritative source: http://fms.treas.gov/fastbook/A4 Sub-Account Code must be used for accounting classification, general ledger posting,financial reporting, budgetary control, and funds control.A4 Each accounting system must store and maintain Sub-Account Code values.DESIGN CONSIDERATIONSDeliveredFieldXDerivedFieldFACTSI & IIXFundSAP Configuration Guide for SFIS – BEA emAreaMay 2011FundedProgramApplicationof FundsXPage 15

PROCESS WALKTHRUModule:FMNavigation:Accounting-Public Sector Management-Funds Management- MasterData-Account Assignment Element- Fund- Application of FundsDisplaySAP Trans Code:FM5SForm Field Name:Display Application of FundsTable Name:IFMFUSEField Name:DEPT TRANRelated Transactions: FM5I. FM5UScreenshot: Location of “Sub-Account” Field on Application of Funds Master RecordSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 16

A5 - Apportionment Category CodeSFIS Element:SFIS Component:Description:Example:Comment:Source:A5 - Apportionment Category CodeLength:1Appropriation Account InformationAn OMB distribution of budgetary resources, using Standard Form (SF)132, Apportionment and Re-apportionment Schedule, to distribute budgetor obligational authority by calendar quarter (category A) or by otherspecified time periods, or programs, activities, projects, or combinationsthereof (category B). The category code indicates whether amountsdistributed are category A or B apportionments, or not subject toapportionment (category C). The apportionment distribution representsthat portion of the appropriation authorized for the obligation andexpenditure of funds.Examples of Apportionment Categories A, B and CCategory A - Period Apportionments 1st quarter amount, 2nd Quarter amount, 3rd Quarter Amount and 4thQuarter Amount.Category B Examples- Apportionments for Specific Purposes, e.g.,: Tri-annual Apportionment-Research, Development of Product XYZ, Terrorist Defense Education (Special purpose)Category C - Accounts Exempted from SF 132 ApportionmentRequirements; Example for a no-year or multi-year account: Other Category C uses include: Non-expenditure transfers to otheraccounts; Expired accounts; Accounts that are fully obligated (expended)at the beginning of a fiscal period; Foreign currency accounts.The apportionment distribution represents that portion of theappropriation authorized for the obligation and expenditure of funds.http://fms.treas.gov/fastbook/BUSINESS RULES#Business RuleA5 Apportionment Category Code must be 1 alpha character. ex. AData values: A - Category AB - Category BC - Not subject to apportionmentA5 Apportionment Category Code must be used for accounting classification, general ledgerposting, financial reporting, budgetary control, and funds control.A5 Each accounting system must store and maintain Apportionment Category Code values.DESIGN CONSIDERATIONSDeliveredFieldXDerivedFieldFACTSI & IIFundSAP Configuration Guide for SFIS – BEA emAreaMay 2011FundedProgramApplicationof FundsXPage 17

PROCESS WALKTHRUModule:FMNavigation:Accounting-Public Sector Management-Funds Management- MasterData-Account Assignment Element- Fund- Application of FundsDisplaySAP Trans Code:FMUSFG1Form Field Name:FACTS I & II Derivation of AttributesTable Name:IUSFGFDERIVEField Name:FLG APPORTRelated Transactions: NoneScreenshot: Location of “Apportionment Category” Field on FACTS I & II Derivation ofAttributesSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 18

A6 - Receipt IndicatorSFIS Element:SFIS Component:Description:Example:Comment:Source:A6 - Receipt IndicatorLength:1Appropriation Account InformationThe Receipt Indicator identifies a main account balance, or mainaccount/subaccount combination, as either receipt or expenditure.Not Applicable - This is a simple Yes or No field.Nonehttp://fms.treas.gov/fastbook/BUSINESS RULES#Business RuleA6 Receipt Indicator must be 1 alpha character. ex. YData values: Y - YesN - NoA6 Receipt Indicator must be used for accounting classification and financial reporting.A6 Each accounting system must identify and be able to report accounts or portions ofaccounts used for receipt purposes.DESIGN CONSIDERATIONSDeliveredFieldXDerivedFieldFACTSI & lItemAreaFundedProgramApplicationof FundsXPROCESS WALKTHRUModule:FMNavigation:Accounting-Public Sector Management-Funds Management- MasterData-Account Assignment Element- Fund- Application of FundsDisplaySAP Trans Code:FM5SForm Field Name:Table Name:IFMFUSEField Name:Receipt IndicatorRelated Transactions: NoneSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 19

Screenshot: Location of “Receipt Indicator” Field on Display CharacteristicsSAP Configuration Guide for SFIS – BEA 8.0May 2011Page 20

A7 - Sub Classification CodeSFIS Element:SFIS Component:Description:Example:Comment:Source:A7 - Sub Classification CodeLength:2Appropriation Account InformationSub-Classification Codes are assigned in certain cases for groupingdesignated disbursement and/or receipt transactions below the level ofappropriation or fund account represented by the main account, (referenceItem A3, Main Account) for an Appropriation, Fund, or Receipt Account.Separate sub-class identification codes are assigned to agencies by theTreasury to be used as parenthetical prefixes to the main a

Comment: Department Transfer is a field on the Application of Funds Master Record in SAP. Application of Funds Master Data is equivalent to “Appropriation” in that the Application of Funds describes a “main account” tied