Kontakt

Ansicht
Dokumentation

REBRDAICMS - Registro de Apuração do ICMS - DAICMS

REBRDAICMS - Registro de Apuração do ICMS - DAICMS

RFUMSV00 - Advance Return for Tax on Sales/Purchases   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Description

This Report creates the Legal Book 'Registro de Apuração do ICMS (DAICMS). It reads the data of the Notas Fiscais, Conhecimentos and FICA documents that have been posted during the selected period and accumulates, sorts and displays them accordingly to brazilian utility company requirements. In addition to that, it collects special postings that were created manually but without creating a Nota Fiscal or a Conhecimento or a FICA document from different accounts. These accounts have to be created and maintained by the user before starting this Report.

The Output consists of the Registro de Apuração do ICMS, containing only ICMS information (DAICMS).

Requirements

  1. Maintainance of the table EBRLIVICMS using transaction EBR_LIVICMS :
    To read the relevant data for the last part the book that can be generated by this report, the user has to create and maintain the following G/L accounts (with line item display set to 'ACTIVE') per company code and branch and maintain the fields in table EBRLIVICMS as described below:
    1. Outros Débitos:
      assignable to row 007 with D/C indicator 1 (only credits, which means here: only reversals of debits) and assignable to row 002 with D/C indicator 2 (only debits).
    2. Outros Créditos:
      assignable to row 006 with D/C indicator 1 (only credits) and assignable to row 003 with D/C indicator 2 (only debits, which means here: only reversals of credits).
    3. Saldo Credor no Periodo Anterior:
      assignable only to row 009 with D/C indicator 1 (only credits).
    4. Deduções:
      assignable only to row 012 with D/C indicator 1 (only credits).

      The first number of each row indicator (ZXY) determines, the book (DAICMS: 0XY) the respective postings will appear.
      If there are several accounts of the same type (belonging to the same row indicator), then they have to be numbered - for this purpose use the field Sequence number in the table.
  2. Mandatory selection criteria:
    Nota Fiscal selection criteria:
    1. Company Code ... of the company that issues the Registro
    2. Branch Code ... of the company's branch that issues the Registro
    3. Posting date ... first and last date of the period for which posted documents shall be reported in the Registro
      Output selection:
    4. Selection of postings:
      Here, you select, if the report will show only information on incoming and/or outgoing Notas Fiscais, or if also the 'Apuração' part will be generated.

  3. Optional selection criteria:
    Additional selection criteria:
    1. Series ... the Nota Fiscal / Conhecimento Series number
    2. Nota Fiscal number ... the external, not unique number of the Nota Fiscal or Conhecimento
    3. FICA Document Number

Output

The Output consists of three parts of the book, depending on the output selection:

  • Entradas:
    ICMS relevant incoming goods, condensed and sorted by CFOP number (without extension), or by state of the partner in the case of the Substituição tributária interstate book.
  • Saídas:
    ICMS relevant outgoing goods, condensed and sorted by CFOP number (without extension), or by state of the partner in the case of the Substituição tributária interstate book.
  • Débito do Imposto:
    ICMS tax debits - the relevant amounts resulting from the 'Saídas'-part and other debits/reversals of other credits that were not created via a Nota Fiscal or Conhecimento but posted directly via FI. The amounts appearing here are read directly from special FI accounts which have to be maintained by the user and which are linked to this report via the table EBRLIVICMS (See above).
  • Crédito do Imposto:
    ICMS tax credits - the relevant amounts resulting from the 'Entradas'- part and other credits/reversals of other debits/credits from former periods that were not created via a Nota Fiscal or Conhecimento but posted directly via FI. The amounts appearing here are read directly from special FI accounts which have to be maintained by the user and which are linked to this report via the table EBRLIVICMS (See above).
  • Apuração do Saldo:
    Final determination of the tax debit to be paid or the tax credit to be transported to the next period.

Recommendation

In order to allow this report to access data efficiently, the following
database index for table DFKKREP06 should be created:

  • Company Code, Contract Account Document Number, Net Due Date:
    Fields: BUKRS, OPBEL, FAEDN

Example

... for the maintainance of the table EBRLIVICMS:

the entries

company code: 0001, branch: 0001, row: 002, seq no.: 1, G/L account: xyz, D/C ind: 2

will be interpreted in the following way:
The report 'Registro de Apuração do ICMS' will read the debit postings (D/C ind = 2) in account number xyz for the given company/branch and report them in the third part of the 'Registro de Apuração' under 'Outros Débitos' (Row: 2).






General Material Data   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 5772 Date: 20240601 Time: 055648     sap01-206 ( 98 ms )