cancel
Showing results for 
Search instead for 
Did you mean: 

Shipping point/routes table in STO

Former Member

Hi All,

We need to develop a Z report which will show open  PO's (STO)  for which outbound deliveries have not been created.  I can use VL10B or VL10H but in the output we need to have material description,ship to party etc and some other fields which are not available in layout for VL10B/VL10H. So

A ) the selection criteria for Z report  is a follows. The open STO;s needs to be found based on follwoing for every line item and for every schedule line in STO

1 )shipping point, I n eed to know which table  stores shipping point for an STO ?

2) route, which table  stores route for STO ?

3) delivery creation date(material availability date ), which table stores this date   for STO ?

4) STO type (PO type ), which table stores PO type  ?

B ) also if someone can advice, instead of devising a Z program, how  we can extract data from VL10B/H and put the open PO's list in an internal table and then use custom logic on internal to fetch material no, ship to party

regards

Pamela

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member

Hi,

Please find the table names for your questions,

1 )shipping point, I n eed to know which table  stores shipping point for an STO ?

A: EKPV

2) route, which table  stores route for STO ?

A: EKPV

3) delivery creation date(material availability date ), which table stores this date   for STO ?

A: EKPV

4) STO type (PO type ), which table stores PO type  ?

A: EKKO

Regards

Vijay

Former Member
0 Kudos

Hi,

Some more information on how we can fetch the open P.O item and outbound delivery item.

(a)    Logic to find out the first open item for Purchase order:

From EKPO, you will get the EBELN, EBELP & MENGE and compare them in EKBE table.

If MENGE-EKPO for EBELP < sum of all MENGE-EKBE for EBELP, when VGABE=1, then it is a open item

Note: If SHKZG-EKBE = S, then MENGE-EKBE should be taken as positive value                                     

               = H, then MENGE-EKBE should be taken as negative value, when doing Sum for all MENGE-EKBE                              

(b)         (b) The logic for outbound delivery open item:

Pass the VBELN-LIPS & POSNR-LIPS to XBLNR-EKBE & EBELP-EKBE to get the information related to the logic of Purchase order

Regards

Vijay

JL23
Active Contributor
0 Kudos

Most can be found in EKPV table.

Why don't you just enhance VL10 transsaction with the fields you need?

Note 198137 - VL10: Customer-specific
enhancements / user exits