2LIS_02_itm -reversal of GRN

[Former Member]

Dear all,

I have to create simple report of contry wise purchses

I am using 2lis_02_itm as a datasource ,i am piking GRN qty from current GR qty filed,

BUt not able to pick reversal of same

Please suggest any workaround for that

[Former Member]

As said earlier, ROCANCEL in the reversal indicator field.

ROCANCEL = 'X' --> before image

ROCANCEL = blank --> after image

In your Source system/ Start Routine/ DTP/ Infopackage, check if the records where ROCANCEL = 'X' are getting filtered or not.

If that is the case, then you'll have to check the implications of changing this filter.

If the 1st level staging is a Write Optimized DSO, it should have all the records - new/ changed/ deleted etc.

And normally the 2nd level is a Standard DSO, where in the filters are applied.

Just check for such filters and if there is a possibility of changing them, go ahead.

[former_member188080]

Hi,

Look at following

ROCANCEL - Cancellation of Data Record

This field can contain the following values:

· u2018blanku2018 u2013 New data record

· u2018Xu2019 u2013 Cancellation of data record

· u2018Ru2019 u2013 Deletion of data record

For more information, see SAP Note 578471: Deleted Items in BW and Statistics

You can see these records in BW and in source system those records will be vanished. In BW report you can find those records.

http://help.sap.com/saphelp_sm32/helpdata/en/58/f6383fdb800804e10000000a114084/content.htm

Thanks and regards

Kiran

[Former Member]

Hi,

If GR is done using movement type - 101, then the reversal would be with 102. Check out for the GR transaction movement types and also as mentioned in the above threads, check for reverse indicator.

Regards,

Geeta

[Former Member]

Hi

In data source level check the reverse indicator for this field.

open the data source in RSA2, put the reverse indicator for this field, then you can get the reverse value.

Regards,

Venkatesh

[Former Member]

Hi Venkatesh,

It is "ROCANCEL"

Regards,

Amit