how to get delivery type

[Former Member]

Hi,

I got a requirement to develop BDC.In VL01N->delivery type having ZLKB & ZKKB.If the sales order is having delivery type as ZLKB, i want to pass PLWN as shipping point,if delivery type is ZKKB , i want to enter KHWN in shipping point. Where can i find relation between shipping point & sales order.

reward guaranteed

priya

[Former Member]

Hi,

There is a shipping point field(VSTEL) in the Sales order item table(VBAP)..

Would VBAP-VSTEL be of help for you to relate?

Thanks,

Renjith

[Former Member]

Yours looks like a delivery create and the deliverry type is LIKP-LFART which gets determined based on the sales order or the type that u give on the screen.

VBAP-VSTEL is the shippinpoint as Ranjit has said , maybe u can use these to compare,

[Former Member]

Hi Vijay

Your answer is good.But how to get sales order & item based on delivery type.

thanks

priya

[former_member188685]

I think you might be having delivery number, along delivery type. take the delivery number and get the sales order,item from lips by passing the delivery.

(lips-vgbel,lips-vgpos) sales order and item.

with the order,item assign the vstel of order in vbap.

regards

vijay

[Former Member]

Hi

You can find out the link between delivery and order type in TVAK table: field LFARV.

So:

SELECT SINGLE * FROM TVAK WHERE AUART = VBAK-AUART.

IF TVAK-LFARV = 'ZLKB' OR

TVAK-LFARV = 'ZKKB'.

....

VBAP-VSTEL = ....

Max

Message was edited by: max bianchi

[Former Member]

Hi max bianchi

Thanks a lot.

Points alloted

priya

[former_member188685]

Based on the delivery get the sales order number, item.

pass these to VBAP and find the shipping point attached.

regards

vijay

[Former Member]

Hi priya,

1. VBAK - vbeln

VBLK - lfart

The above are the required tables.

regards,

amit m.

[Former Member]

Hi,

You have delivery type LFART at hand. Then query LIKP table for all the dliveries that belong to LFART = your LFART. For all the dleiveries picked go to VBAP and pass the Delivery number for VBAP-VGBEL = LIKP-VBELN and pick the VBAP-VSTEL and VBAP-VBELN that u need.

Shobana