Import Worklist table (/ECRS/WLEN) of Intrastat Declaration In S/4HANA International Trade

[former_member631208]

Purpose

Get the list of entries in import worklist (temporary table) of the Intrastat declaration.

The functionality and the issues discussed are for S/4HANA 1909 release. Request user to analyze and adapt the content for their respective S/4HANA releases

Problem

System selects all import & export entries applicable for Intrastat and writes in to the /ECRS/WLEN table. From this table data, the system applies inclusion/exclusion rules etc., to come up with the actual Intrastat declaration data for the table /ECRS/RPIT.

User can’t directly influence entries in /ECRS/RPIT table and instead can change entries only in WLEN table through available BAdIs. It is necessary to understand the data in this table, so that the user can use the BAdI ‘BADI_INTRASTAT_SELECTION’ to influence the entries in this table.

Situations Applicable

Dispatch & Receipts Intrastat declarations in S/4HANA

Resolution

Users should be aware of the following fields in the /ECRS/WLEN table, so that the data can be influenced through BAdI

1. Ref. Document Type (RDTYP)

Ref. Doc Type

For dispatches, the original billing document will not have any reference document type & reference document number. The correction data like credit/debit memo, cancellations created with reference to the original billing document will have Ref.Document Type as ‘3’ & Ref.document number field with original billing document number. Corrections made in the same month of original billing document will only be considered in the Intrastat declarations.

For Receipts,  Goods movement data related to Purchase Order/Delivery is considered for Intrastat declarations

2. Entry type (ENTYP)

F.eg:- In Dispatches, the Credit memos are negative corrections, Dedit memos are positive corrections and cancellations are reversal. All dispatch corrections should be created with respect to original billing document number and should be done in same month to actually see them copied in to the RPIT table.

Entry Type

How to access the table:-

User can only access this /ECRS/WLEN table through debugging. When the debugging session is finished, the entries in the table will be automatically deleted.

For Dispatches:

1. Go to SE38 and enter the program ‘RVEXST00’


2. Select Display

Report display

3. Put a break point at the line "PERFORM process_reporting_selection"

Put a Breakpoint

4. Go to VE01 transaction and provide your POI, Month & Year and press Execute, now the debugger automatically starts and comes directly to breakpoint line where you have set the breakpoint. Now select the F6 or select the second icon once as per the screen shot.

Execute the report

5. After selecting F6 or second icon, it will execute the breakpoint step and take user to the next line

Execute the line in the program

6. Now go to /ECRS/WLEN table and use your POI, month, year to search for your entries

Verify data in table

7. After checking the entries in /ECRS/WLEN table, switch to the debug screen and press F8 or select the last icon to exit the debug screen. Do this step only when you don’t want to see entries in WLEN table. If you do this step, then entries in WLEN will be deleted.

Completely run the program

For Receipts:

1. Go to SE38 and enter the program ‘RMIMST00’


2. Select Display


3. Break point at line  "PERFORM process_reporting_selection_mm"


4. Go to MEIS transaction and provide your POI, Month & Year and press Execute, now the debugger automatically starts and comes directly to the breakpoint line. Now select the F6 button.


5. Now go to /ECRS/WLEN table and use your POI, month, year to search for your entries


6. After finished checking the entries in /ECRS/WLEN table, switch to the debug screen and press F8 to exit the debug screen. Do this step only when you don’t want to see entries in WLEN table. If you do this step, then entries in WLEN will be deleted.