Delivery items extraction without key fields

[Former Member]

Hi,

I have a question, How can I select delvery items if I don't have key fields in the selection screen?

Which is the best way to selct the following fields?

(LIPS-VBELN) and (LIPS- POSNR) selecting with (LIPS- WERKS) and (LIPS-MBDA)

Many thanks

Roberta

[harry_wu]

Hi,

If I understand your question correctly, you want to select LIPS by WERKS and MBDAT.

Am I right?

I have an additional question for you.

What do you want to do with the selected delivery? What kind of delivery do you want to select? (delivery to be picked? delivery to be loaded, or derlivery to be PGI)?

For deliveries at different stage, it's updated into different index table. (read note 920245).

If you can select from index table firstly depending on your usage, and then select from LIPS with selected index entry,it would save time. As of which index to use, it depends on what kind of deliveries you want to select.

What I suggest is:

- LIPS-MBDAT would be the same as picking date (KODAT). So, you can select index table with KODAT.

- WERKS is normally asiggned to several shipping point. So, you can aslo select the index table with VSTEL. And then check LIPS with selected index entries to find the items with certain WERKS.

Edited by: Harry Wu on Apr 19, 2010 10:53 AM

[Former Member]

Hi,

I've need to extract info about delivery that are to be picked.

I thought to follow thefollowing steps, but I'm not sure of program performances:

Access to LIKP with :(LIKP- LFDAT) and (LIKP- LFART) and select (LIKP -VBELN)

Access to LIPS with

(LIPS- WERKS)

(LIPS-MBDA)

(LIPS-VBELN) =(LIKP u2013VBELN) and select

(LIPS-VBELN)

(LIPS- POSNR)

(LIPS- MATNR)

What do you think about these?

Many thanks

Roberta

[harry_wu]

Hi,

If you are selecting deliveries to be picked, you should use SHP_IDX_PICK.

All the deliveries to be picked is updated to that index table.

I suggest you to select the deliveries with shipping point / picking date (material available date) / plant.

1.

Creat an internal table IT_SELECT with 1 feild VBELN.

2.

select SHP_IDX_PICK with VSTEL, KODAT, into IT_SELECT.

3.

SELECT LIPS with the VBLEN in IT_SELECT, and WERKS.

-

---

Actually, there is a standard transaction VL06P to select deliveries to be picked.

Maybe you can debug that transaction to see how SAP do that.

Edited by: Harry Wu on Apr 19, 2010 11:45 AM