Customizing 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 .
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 .
You may create a new financial statement version (FSV) or adapt an existing one.
Caution
If you create a new FSV entry, do not select the Item keys auto.
checkbox.
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
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.
Define a document type to be used for all closing activities:
Choose .
Create the document type to be used for all year-end closing activities.
Define the codes of the government entities:
Choose , 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
You have to create an entry for each government entity you must send the ECD to.
Define the qualification for the person responsible:
Choose , 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
The code and the qualification of the person responsible are defined by the government.
Example
Qualification Code | Qualification |
205 | Administrador |
900 | Contador |
999 | Outros |
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 , 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 , 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 , or go to Transaction SM30, view J_1BECD_CUST07V
and enter the following information:
The relationship code
The relationship description
Note
You can find examples of relationship codes and the corresponding descriptions in the Customizing activity documentation.
Define intercompany relations:
Choose , 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
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
.
Define BCB country codes:
Choose , 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 , 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
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 1234056
.
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.
Additional Customizing for Bookkeeping Types R and B:
Define subledgers:
Choose , 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 , 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 1234056
.