Is there any Deletion Flag in Orginal migo doc which cancelled?

[Former Member]

Hello Everyone,

Is there any Deletion Flag in Orginal migo document which cancelled?

Need your support..

Regards,

Narendra

[vijay2006ece · Accepted solution]

Hi,

There will be no deletion flag for a material document after reversed.

We can find the details at table level by passing 101 document number to MSEG-LFBNR,

It shows 101 entry as well as 102 (if it is reversed).

[Former Member · Accepted solution]

Sir,

Thank you for your valuation information.

Regards,

Narendra

[Prasoon]

Hi,

   There is no direct indicator through which you can find whether the 101 document is reversed or not. As explained by Mr. Vjay, you can compare the same with MSEG-LFBNR

   In short, the material documents updated in MSEG-LFBNR field for any reversal document (for example 102 doc) are cancelled material docs.

Regards,

AKPT

[Former Member]

Sir,

Thank you for your valuation information.

Regards,

Narendra

[Prasoon]

Hi,

   You may refer the thread:

Regards,

AKPT

[Former Member]

There is no deletion flag as such but you can find the credit flag as "H" for 102 movement type from field MSEG-SHKZG.

[Former Member]

Sir,

Thank you for your valuation information.

Regards,

Narendra

[former_member183424]

There are no deletion flag for material document number.

You can check the document is cancelled or not?

Go to MBSM t-code

Put the original material document number.

Then execute..

You can see if the document is cancelled or not?

Right side is original and left side is cancelled document number.

[Former Member]

Sir,

Yes i know that but i was looking any alternate way MM. In SD when invoice get cancelled there is "X" indicator in table. As you can see below screen-shot.

Regards,

Narendra

[former_member183424]

Okay.. Got your point.

As all says "there are no option for material document number" (me too)

In MM it can founded in Purchasing document number.

We can see the deletion flag for document in some table.

But not for a material document.

[Former Member]

Dev,

Yes you are right when GR/IR Qty is Zero then PO can be flag for Deletion. Then we can trace from Table EKPO.

But there is Scenario where GR is Not Zero ( Migo Done & Cancelled Multiple times). If there would be any "X" indicator then it would be very easy for us. MBSM is very long exercise when we calculate profit report for the year.

Regards,

Narendra

[former_member183424]

After a R& D,

I have found a things.

I share with you. If it helps you.

There is a field in MSEG, SMBLN-Material Document

Give the Material document on this field.

Then press Execute.

The all data is pulled If the material document is cancelled/reversed.

If the material document number is not cancelled/reversed, then you will find no entry.

[Former Member]

Dev,

This also i know my friend.. but for ABAP programmer it is very lengthy process and report will become very slow. If i want take last purchase for each material then reportwill fetch data from starting and passing in table for checking and then deleting those reversed entry. Report will die..

We have around 15000 material.. You can assume how much time it will take. So i can't suggest this way to my programmer. Sap will become down.

Hope you understand..

Regards,

Narendra

[JL23]

But SAP will not change its design for you.

Maybe you can explain exactly what you want to achieve with such report, maybe there something in standard  which you don't know yet, or there might be an alternative solution.

To infuence the speed of database search you can e.g. create a new index that includes the necessary fields

[former_member183424]

If you really want to take ABAP help.

Then go for a new Z field in MSEG or EKBE table.

This field will be contain the information for the reversal/Cancellation information.

Suppose if the document reverse then the field value will be X, If no then Blank.

As like as our company has also create a Z field in MARA for these same types of requirement.

Just write a FS and give it to your ABAPer.

I am sure he will do it.

As you can see the screen shot above, The all Z fields are updated with material creation.

As well as your requirement can be fulfill via a new Z field, which contain the reversal/cancellation information.

[Former Member]

Thank You..

[Former Member]

Thank You