Show TOC

Function documentationCustomizing for SPED ECD

 

Before running the SPED ECD (electronic accounting file) report, make the following Customizing settings:

Mandatory Customizing:

  • Enter your company's business place CNPJ:

    Choose Start of the navigation path Financial Accounting Next navigation step Financial Accounting Global Settings Next navigation step Company Code Next navigation step Enter Global Parameters End of the navigation path.

    Select your company code, and then choose the Additional details pushbutton. Enter the CNPJ business place number. Use the value you entered in the technical key BRANCH of the table J_1BBRANCH.

  • Add the required entries to your Financial Statement Version:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transaction Next navigation step Closing Next navigation step Documenting Next navigation step Define Financial Statement Versions End of the navigation path.

    You may create a new financial statement version (FSV) or adapt an existing one.

    Caution Caution

    If you create a new FSV entry, do not select the Item keys auto. checkbox.

    End of the caution.

    Select the Fin. statement items pushbutton and customize the tree hierarchy of the FSV. The following internal codes, as defined by SPED, must be used in the hierarchy, regardless of the level:

    SPED Internal Code

    SPED Description

    01

    Asset Accounts

    02

    Liability Accounts

    03

    Net Equity Accounts

    04

    P+L Accounts

    05

    Contra-Accounts

    09

    Others

    Note Note

    The FSV may contain as many hierarchy levels as needed. Make sure that all accounts that are relevant for the report are maintained under a node with one of the above SPED codes.

    End of the note.
  • Define a document type to be used for all closing activities:

    Choose Start of the navigation path Financial Accounting Next navigation step Financial Accounting Global Settings Next navigation step Document Next navigation step Document Header Next navigation step Define Document Types End of the navigation path.

    Create the document type to be used for all year-end closing activities.

  • Define the codes of the government entities:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Government Entities End of the navigation path, or go to Transaction SM30, view J_1BECD_CUST01V, and enter the following information:

    • Your company code

    • The government entity code

    • The subscription code of your company with the government entity

    Note Note

    You have to create an entry for each government entity you must send the ECD to.

    End of the note.
  • Define the qualification for the person responsible:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Qualification for Person Responsible End of the navigation path, or go to Transaction SM30, view J_1BECD_CUST02V, and enter the following information:

    • The qualification code of the person responsible

    • The qualification of the person responsible

    Note Note

    The code and the qualification of the person responsible are defined by the government.

    End of the note.

    Example Example

    Qualification Code

    Qualification

    205

    Administrador

    900

    Contador

    999

    Outros

    End of the example.
  • Maintain the person responsible

    The person responsible refers to the person or people who approve the information contained in the SPED ECD file. By SPED definition, you have to specify at least one person responsible for the file per company code.

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Maintain Person Responsible End of the navigation path, or go to Transaction SM30, view J_1BECD_CUST03V, and enter the following information:

    • Your company code

    • A sequence number

    • The name of the person responsible

    • The CPF number of the person responsible

    • The qualification code

    • The CRC number

  • Define the number range for the report execution number:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Number Range for Electronic Accounting File History End of the navigation path, or go to Transaction J1BECD_NUM.

    Select the Number Ranges pushbutton and enter the following values:

    • No: 01

    • From number: 0000000001

    • To number: 9999999999

Optional Customizing:

  • Define intercompany relations codes:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Intercompany Relations Codes End of the navigation path, or go to Transaction SM30, view J_1BECD_CUST07V and enter the following information:

    • The relationship code

    • The relationship description

    Note Note

    You can find examples of relationship codes and the corresponding descriptions in the Customizing activity documentation.

    End of the note.
  • Define intercompany relations:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Intercompany Relations End of the navigation path, or go to Transaction SM30, view J_1BECD_CUST06V and enter the following information:

    • Company code

    • Related company code

    • Relation code

    • Initial date of the relation

    • Final date of the relation

    Note Note

    The intercompany relations are relevant for registers 0150 and 0180. You can also fill these registers by implementing the corresponding methods of the business add-in J_1BECD.

    End of the note.
  • Define BCB country codes:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Next navigation step Accounting Next navigation step Business Next navigation step Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil SPED Reporting Next navigation step Assign BCB Country Codes to ISO Country Codes End of the navigation path, or go to Transaction SM30, view J_1BEFDV_COUNTRY and enter the following information:

    • Country

    • Country name

    • BCB Country code

  • Define register category

    The register category refers to the category for each register per accounting bookkeeping type for the SPED ECD file. There are four possible values: mandatory, optional, mandatory hierarchy dependent or not applicable. For more information, refer to the field help.

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Register Category End of the navigation path, or go to Transaction SM30, view J_1BECD_CUST05V and enter the following information:

    • The register number

    • The register category for bookkeeping type G, R, B or Var

    Note Note

    • If you do not maintain this table or make a choice in the Default Register group box on the selection screen, the report is executed with the default register categories as defined by the government. For more information, see the highest version of the ECD Content File attached to SAP Note 1234056Information published on SAP site.

    • If you maintain this table only for specific registers, the other registers are executed with the default settings.

      For Bookkeeping Type B, you can maintain a second variant of register categories. You can use this variant, for example, for the semester closing, in which you have to set different register categories as for the monthly closing.

    • If you switch a register from not applicable to mandatory, the extraction logic does not change, and the register is not included in the output file.

    End of the note.

Additional Customizing for Bookkeeping Types R and B:

  • Define subledgers:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step Define Subledgers End of the navigation path, or go to Transaction SM34, enter the object J_1BECD_CUST08VC and enter the following information:

    • Company code

    • Subledger name

    • Type of book

    • Purpose of the subledger book

    • Account numbers per subledger

Business Add-in (BAdI) Implementations:

  • Create an implementation:

    Choose Start of the navigation path Financial Accounting Next navigation step General Ledger Accounting Next navigation step Business Transactions Next navigation step Closing Next navigation step Reporting Next navigation step Statutory Reporting: Brazil Next navigation step SPED Reporting Next navigation step BAdI: Electronic Accounting File Routines End of the navigation path, or via transaction SE18, BAdI BADI_J_1BECD.

    You can use the methods of the BAdI to fill in certain registers of the flat file with customer-specific data.

    For more information, refer to the highest version of the ECD Content File attached to SAP Note 1234056Information published on SAP site.