Clearing of Cenvat Clearing Account

[former_member221103]

HI All,

Please guide me how can I clear the Cenvat Clearing Account for Year end closing. I tried using F.13 but none of the items are getting cleared since the Assignment field is getting populated by "000000" for MIRO line items instead of PO. No.

Please suggest how can I get the Assignment field filled up by Purchase order# for the entries entered in Past so that I can do clearing. The sort key used is 014 in Cenvat Account.

I have attached the screenshot for your reference. Please suggest.

Thanks 

[Former Member · Accepted solution]

Hi Andy,

I have done it successfully in one of my projects..and also posted reply on this post several times in this forum.. so if you can search for past posts..

To repeat once again:-

1. You need to write a substitution using an exit to populate ZUONR field with PO no. and item no. concanetated.

2. In OB74, define automatic rules for clearing for your CENVAT clearing account, on the basis of ZUONR field.. because at the time of J1IEX, Cenvat clearing account gets populated with P.O. no. and item no. and with this substitution your Cenvat Clearing Account also gets populated at the time of MIRO with P.O. No. and Item no. and then this can be cleared in F.13

3. Regarding your old entries.. this substitution will not help..you need to find ways to populate your ZUONR field for old entries through the FB02 route with some BDC.. and then you can clear it..

Hope this helps..

Regards,

SAPFICO

[suma_mani · Accepted solution]

Hi Andy,

I would like to clear one thing in standard SAP! While posting the MIRO ,GL account sort key wasn't work well. Cenvat clearing never update with PO line item number. We did the same as workaround solution as substitution rule. Once activated mentioned rule ,automatically PO number & its line item update in assignment field.Month end you have run F.13 to clear the same. But for that criteria should be GSBER |ZUONR|DMBTR.

Substitution rule :- GGB1 Transaction code . Use user exit :- RGGBS000

U201 Pool > Logic as follows :-

TYPES : BEGIN OF TY_BSEG,

            EBELN TYPE BSEG-EBELN,

  END OF TY_BSEG.

  DATA : IT_BSEG TYPE TABLE OF TY_BSEG.

  DATA : WA_BSEG TYPE TY_BSEG.

  DATA : COUNT   TYPE I.

  IF BSEG-KTOSL = 'WRX'.

    IMPORT IT_BSEG FROM MEMORY ID 'DEF'.

    WA_BSEG-EBELN = BSEG-EBELN.

    APPEND WA_BSEG TO IT_BSEG.

    CLEAR WA_BSEG.

    EXPORT IT_BSEG TO MEMORY ID 'DEF'.

  ENDIF.

  IF BSEG-KTOSL = 'VS1' OR BSEG-KTOSL = 'VS6'.

    IMPORT IT_BSEG FROM MEMORY ID 'DEF'.

    READ TABLE IT_BSEG INTO WA_BSEG INDEX 1.

    IMPORT COUNT FROM MEMORY ID 'CNT'.

    COUNT = COUNT + 1.

    BSEG-ZUONR = WA_BSEG-EBELN.

    IF COUNT = '3'.

      DELETE IT_BSEG INDEX 1.

      EXPORT IT_BSEG TO MEMORY ID 'DEF'.

      FREE MEMORY ID 'CNT'.

    ELSE.

      EXPORT COUNT TO MEMORY ID 'CNT'.

    ENDIF.

  ENDIF.

Every GRIR Clearing account updated with PO Number and saved in BSEG table >Here GRIR Account is base to pick PO Number and it line item and update the same in to assignment field of cenvat accounts.

Rgds

Mani

[nico_dewaele]

Can't you use the BSEG-EKKO & BSEG-EKPO fields for automatic clearing?

otherwise, you'll need specific ABAP program to update the assignment fields.

[former_member221103]

Can you please guide how I can do that? As per ABAPER the 'ZUONR' must be populated with PO#....but how can it be done?

[nico_dewaele]

can't you use option 1?  change criteria in V_TF123

option 2: use document flow to find the po & line number en simulate FB02 to change ZUONR

option 3: look up manually what it should be and use FB02 in LSMW.

[former_member221103]

Hi Nico....can you explain me in detail as I am not able to understand it clearly since I am new to these things.....please help.

Regards,

[nico_dewaele]

sorry my field names were incorrect of course, they are tables...

make a new line with

- your chart of accounts

- Account type: S

- from/to account: your account

- criterion 1:  EBELN

- criterion 2: EBELP

[former_member221103]

What would be the best process to change the entries that had already been entered in the past?

[nico_dewaele]

past will be done likewise as it's not using the incorrect filled zuonr