If i want to find an open STO which has not been PGI'ed and Shipped, i will search via below way:
1. Search in table VETVG for any STO document# available there for specific Shipping points. Append STO# to Z_VETVG_STO
2. Search in table SHP_IDX_PICK(Outbound Deliveries: Not Picked) for any Delivery# as not picked with same shipping point as above. Append Dlv# to Z_NOPICK
3. Based on above Dlv# from Z_NOPICK, then search in LIPS table for vgbel field to get corresponding STO# document number for those Deliveries. Append Dlv#,Item#,VGBEL# to Z_NOT_DLVed
4. Then append above VGBEL# as VBELN STO# to Z_VETVG_STO, sort Z_VETVG_STO and remove duplicated.
Then get the required open STOs as not PGI'ed and Shipped.
Now my question:
In which table and link relationship could i find the STOs which has been shipped or PGI'ed according the given Shipping point??
Thank you very much.