How to relate sales shipping number series to invoicing number series

Hi All,

I have an query i have make an sales order and partial ship this sales
order (For eg : SHIP/001,SHIP/002,SHIP/003 are the shipping number series
) now after this i invoice that order ( For eg : INV/001, INV/002 are the
invoicing number series)
Now my query is this if have to find out which shipping series is use against
which invoicing number series.

Or is there any table where i can find both the vaue Shipping and Invoicing Number Series



from ILE filter out the sales shipment entries. For each ILe entry, filter out value entry (filter on Item Ledger Entry No and Document Type as Sales Invoice).

The record that you will get from Value entry will have the document number of the invoice