Where the release of a Sales order data is ?

[Former Member]

Hi,

I need to find time and date when sales orders where released.

I found table VBLB, field ERZEI for time. Is this right??, what would be the correct field for date??

thanks for the help.

Mauricio

[Former Member]

Did you mean dellivery block?

Anyway, you can use CDHDR and/or CDPOS:

Change doc. object: VERKBELEG

Object value: ORDER NUMBER (ten dgt).

G. Cicconi

[Former Member]

Thanks to all for the help.

I went to SD consultant and he told me that SO are automatically checked when created against customers profile. Some may get "hold" status, and some others will not. Those "holded ones, needs to be "un-holded" manually. This is what I have to look for. I will use Change log fo that. thanks again.

Mauricio

[Lakshmipathi]

I need to find time and date when sales orders where released.

There is no release procedure for sale orders unlike PO in MM and I presume that it would have been creation date and time. If so, you may check in VBAK.

thanks

G. Lakshmipathi

[Former Member]

Vievk,

thanks for your post,

I see fields UTIME and UDATE. Are these the ones to use?

How do I identify an Order Release change record in this table?

thanks again.

Mauricio

[Former Member]

Hi,

When ever you do any changes in sales order the date and time will be posted in fields UDATE and UTIME. you can get the change log of sales order in the table.

As per my knowledge, when ever you will do any change in sales order profile it will be posted in same table, if so your problem will be solved.

regards

Vivek.

[Former Member]

Hi,

You may use following tables to get the release date upon sales order change:

CDHDR - Change document header

CDPOS - Change document items

regards

Vivek.