Skip to Content

Cancelled material document

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Apr 27, 2012 at 04:53 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2012 at 04:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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...

  • Apr 27, 2012 at 05:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Apr 27, 2012 at 05:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2012 at 05:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27, 2012 at 05:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27, 2012 at 05:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2012 at 05:24 AM

    HI,

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

    Add comment
    10|10000 characters needed characters exceeded