Linking Table for Sales Document Number and Object Number

[Former Member]

Hi Frens,

We have in Header data < Status tab < Object Status sub tab. In this we have Object Number (OBJNR). Can you pls suggest the linking table for Sales Document Number and Object Number.

Thanks

CK

[Former Member]

There is a function module STATUS_READ which will return the status information when passed VBAK-OBJNR if you are using this information programatically.

[former_member183879]

Hi,

It is very well available in VBAK. The field is VBAK-OBJNR. You should have to give the document number in VBAK-VBELN and get the field VBAK-OBJNR to know the object number.

Hope this helps

[Former Member]

Hi,

You can develop a query using this three tables if you want to link with status profile also.

1) JSTO - you will get object no. and Status profile.

2) TVAK - You will get status profile and order type.

3) VBAK - you will get order type and sales doc. no. ( OBJNR is already available)

Also for your information the table related to object number are JCDO,JEST and JCDS

Hope this will help you to resolve your issue .

Regards,

Krishna O

Edited by: Krishna O on May 25, 2010 3:10 PM