Cancelled material document

[former_member222120]

Hi SAP Experts,

Greetings to all...

I wish to ask following question:

I performed a Goods receipt (with movement type 101) and it created a material document 'A' and later the material document was reversed (with movemement tyoe 102) and system created one more material document 'B'.

So I wanted to ask is there any data/field in material document 'A' gets updated after cancellation? (where as i know that I can find the material 'B' contains the reference material document 'A').

If there is any field in material document 'A' that gets updated after cancllation then one of my report query will be easier.

Thanking you in advance,

Regards,

UK.

[Former Member · Accepted solution]

hi,

i hope nothing will be updated in material document A.

But when u cancel a document a new material document is generated. in the new document you can find a field "Ref. material document" field name "LFBNR" which will have the previous/first material document number.

hope this helps.

Regards.

[Former Member]

Hi Uday,

There are many fields are linked Between documnetA & Document B.

i.e.

1.Article/Material/Site/Sloc will be same.

2. Vendor Code

3. PO No.

4. Item No (Line Item)

5. Transaction/Event Type

6. Dabit/Credit Indicator.. for eg. Move Type 102 Credit (indicator H) and 101 will be debit (indicator S)

For the detail you can seen in TCode: MB51

Regards,

Sanjeet Kumar

[kailas_ugale]

HI,

as per above explanation check in following screen shot for movement type 101 and 102

[sushant_wanjari]

Hi,

There is no field which gets updated in the document A. SAP keeps the document in the same state.

All the information is updated in the purchase order history with your documents for 101 and 102.

You can pull a report combining the purchase order history and the MB51 (material document list). The PO history will give you all the GR documents, and for those documents you can check the relevant movement type.

Regards,

Sushant

[kailas_ugale]

Hi,
So I wanted to ask is there any data/field in material document 'A' gets updated after cancellation? (where as i know that I can find the material 'B' contains the reference material document 'A').
If there is any field in material document 'A' that gets updated after cancllation then one of my report query will be easier.

in table MSEG display document for both movement type 101 and 102

Now Material document B of 102  = Reference of Material document of A for 101 in same table

then don't select 101 movement type document

Kailas Ugale

[Former Member]

All material movments are tracked individually and through movement types and hence even though your requirement of having some type of notification in record for original document sounds logical, you must understand that SAP considers every movement as correct only, it do not capature any posted document as mistake or corrections and hence when you consider this documents for any reports you should consider movements in totality and consider the ref. documents like PO, SO, etc for the entire flow, do not consider reports based on mov. types or consider every possible mov. types and its reversal while developing a report.

Regards,

Dakshesh

[sjeevan]

Following fields in the table MSEG for material document B will have the following values

SJAHR = Year of document A

SMBLN = Document number of A

SMBLP = Item number of document A which is cancelled.

No update in MSEG for document A

[Former Member]

Uday,

A posted material document never gets updated.

It is always the subsequent document which provides reference of the original document, in your case 'A'.

Thus, whenever we want to create a logic to check if a document has been cancelled , it is always by looking at the fields as mentioned by Jeevan in the cancellation documents.

eg. check all 102 documents for references to your 101 documents. This will let you know of any documents that were cancelled.

[former_member182379]

Hi,

  You have material document 'A'  which is cancel and material document 'B' is created the material document data is updated in header table MKPF  and item table MSEG,  but in this case after cancellation of 'A'  there is no data or field is updated for document number 'A'  but the document number 'B'  will be having the number 'A'  in the MSEG table filed SMBLN also with year SJAHR.

regards,

zafar

[Former Member]

but both the material documents A & B gets updated in EKBE table based on this you can take the report for both A & B documents...