sales order missing in table and document flow

[Former Member]

Hi

This is my client sales process sales order-- delivery -- billing.

but when client check billing document flow ,found that some billing document don't have sales order no in document flow, checked in table as well but some sales order are missing but delivery and billing no's are there .

How to fetch missing sales order.

Regards

Sanjit

[Former Member · Accepted solution]

Hi,

Check whether that order has deleted by using tcode : SARA r in tables : CDHDR.

Regards,

Ramesh.

[Former Member · Accepted solution]

checked table CDHDR but missing sales order is not there.

Regards

Sanjit

[Former Member · Accepted solution]

Hi

I had asked you to check the Relationship Browser from your delivery document display.

Did you check that? Relationship Browser gives the relationship between the delivery and all its preceding and succeeding docuements even if they are missing from doc flow.

Please check

Regards

Madhu

[Former Member · Accepted solution]

Already checked not showing missing order.

Regards

Sanjit

[Former Member · Accepted solution]

Hi Please check this table also : CDPOS

Use Change doc. Obje = VERKBELEG (sales documents)

If not found in the above table please try with the programme : RKEAEDEL with SA38 Tcode.

Hope this will help you.

Regards,

Ramesh.

[Former Member · Accepted solution]

Checked but still sales order no is not there

Regards

Sanjit

[safeer_rahman2]

This message was moderated.

[former_member365422]

Dear Sanjit,

Though this is abnormal but possible.

You can check following scenario yourself in Ides or test system

Create one sales order using VA01

create delivery with reference to sales order before saving delete all items from delivery and enter same items again. and save the delivery.

Now go to VL02n and check the document flow of that delivery. you will find sales order reference missing.

It looks like delivery type LF is created without reference to sales order.

And if you check the document flow of sales order it show no reference delivery is created.

Actually once you delete items form delivery all the references also gets deleted and then you can enter not only same material but can enter any material, any quantity and you can do PGI and billing also, system will not stop you anywhere but you can not find the reference sales order.

The only possible solution i think is delete the delivery doc and create again.

Regards

Mayank

[jpfriends079]

Use Tcode SE16N, check Table VBFA.

Provide your invoice number in VBFA-VBELN (Follow-on doc.)

And execute.

You will get sales order & delivery doc in VBFA-VBELV(Preceding Doc.).

There may be possibility that the sales order might have many delivery doc.

And in your copying control VTLA for Delivery Doc - Item, in Control data section - Update document flow indicator is not active.

Regards

JP

[Former Member]

Already checked table VBFA and maintain copy control.

Regards

Sanjit

[jpfriends079]

Go to your delivery doc and check the doc flow.

if table VBFA result is not giving you any Sales doc.

That means you don't have a sales order for the transaction or same is archived/deleted.

Regards

JP

[Former Member]

If archived/deleted then how fetch that sales order back

Regards

Sanjit

[Former Member]

Hi,

Can you check is this happening for some specific documents or it is happening for all the documents, if it is happening to all the documents, please raise a message with SAP, as most of the check you have already carried out. If its happening to some specific documents, it is definitely some missing customizing or enhancement.

[Former Member]

Happening with some document not with all the documents.

Regards

Sanjit

[Former Member]

Hi,

You better raise it to SAP, as I checked some of the notes also, most of the same checks: update document flow in the copy control and VBFA table.

Just before raising to SAP check if any exits are used, which might hamper this process.

Thank you.

[prasanna_kumar4]

HI

Kindly check the below link , the below link will help to retrieve the archived sale order number

[How to retrieve the ARCHIVED Sales order data|;

Try to check in the Sandbox

Regards,

Prasanna

[Former Member]

Hi

Go to your display delivery transaction and click on 'Environment-->Relationship browser'.

There see if you can find the sales order.

Hope this helps.

Regards

Madhu

[prasanna_kumar4]

HI

Please check once gain the tables

go to SE16N,Enter the Table LIKP , enter the Delivery number and Execute

check What Delivery Document type system has picked

if it is delivery based on sale order reference, delivery type LF (Standrad ) , otherwise without Order reference it is LO(Standrad )

please check & revert

Regards,

Prasanna

[Former Member]

Already checked in LIKP table with reference document no is not there.Delivery type is LF .

Regards

Sanjit

[prasanna_kumar4]

HI

Check the Copy Control, T-code : VTLA

Control data Tab , check the Field Update Document Flow, it should be TICK

Regards,

Prasanna

[Former Member]

Already maintain copy control.My issue is some sales order no are missing.

Regards

Sanjit