cancel
Showing results for 
Search instead for 
Did you mean: 

How to know if an STO has been PGI'ed or Shipped?

Former Member
0 Kudos

Dear Expert,

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.

Accepted Solutions (1)

Accepted Solutions (1)

csaba_szommer
Active Contributor
0 Kudos

Aren't you speaking about Z-fields which are development in your system? What shall we do with these pieces of information which are not standard but specific only to your system? What do you expect???

Delivery STO connection:

- LIPS-VGBEL, LIPS-VGPOS you will find the reference to the STO

- LIKP-LFART --> delivery type, LIKP-VSTEL --> shipping point

Sales document status:

- VBUK (header), VBUP (item)

Edited by: Csaba Szommer on Apr 8, 2011 8:13 AM

Former Member
0 Kudos

Hi Szommer,

Thanks for your reply.

Those Z_tables are internal table, we pulling out data, then populate into those Z_internal table for storing order numbers..etc

I just want to know if there are similiar way like that to find out an STOs which has been shipped or PGI'ed according table link connections etc.

for example: from table SHP_IDX_PICK(Outbound Deliveries: Not Picked) i could know which delivery document as not picked...Is there any simliar table could show (Outbound Deliveries: PGI'ed)??

Thank you very much.

Answers (0)