topic Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP) in Application Development and Automation Discussions

Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

ricardo_fernndezvzquez3 — Wed, 18 Jul 2007 19:28:48 GMT

Hello SAPients!

In transaction VL02N I can see the Handling Units corresponding to a Delivery. I know that the information for the HUs is contained in tables VEKP and VEPO and I know as well that I can link this tables with the delivery using fields VEKP-VPOBJ and VEKP-VPOBJKEY. I don't have any problem with VPOBJKEY but in the case of VPOBJ I found that the values are extracted from the domain VPOBJ which contains fixed values. I'm trying to find a table to convert the value of LIKP-LFART (Delivery Type) to the corresponding VEKP-VPOBJ in order to stablish the whole relationship and avoid performance problems but I can't find it. Do you know the name of this table? Or a better way to get the same result, maybe a FM?

Thanks.

Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

ferry_lianto — Wed, 18 Jul 2007 19:33:35 GMT

Hi,

Please try this.

LIKP-VBELN = VEKP-VBELN_GEN

Regards,

Ferry Lianto

Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

ricardo_fernndezvzquez3 — Wed, 18 Jul 2007 20:07:23 GMT

Ferry,

Thanks for your response, unfortunately the field VEKP-VBELN_GEN is empty. Any other idea?

Thanks.

Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

ferry_lianto — Wed, 18 Jul 2007 20:14:54 GMT

Hi,

Please try FM SD_SHIPMENT_DELIVERY_HUS and fill your delivery number into the I_DELIV internal table.

Regards,

Ferry Lianto

Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

ricardo_fernndezvzquez3 — Wed, 18 Jul 2007 20:37:24 GMT

Ferry,

Thank you very much, that FM solves my problem.

I have one more curiosity question: How do you do it? Do you know all the answers? What's your procedure to find the answer? In the future if I find a problem like this, where do I have to look for the answer? How to search?

Thanks

Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

ferry_lianto — Wed, 18 Jul 2007 20:44:32 GMT

Hi Ricardo,

Try search the SDN forum (I did) for any SAP related question/problem.

You may find a lot of solution and excellent sample codes to the question/problem related.

Regards,

Ferry Lianto

Re: Table Relation between Delivery (LIKP) and Handling Unit (VEKP)

Former Member — Sat, 14 Feb 2015 09:36:19 GMT

hi Ferrry ,
i read this post , but when i use FM SD_SHIPMENT_DELIVERY_HUS i get run time conflict ,

would you please help me handle it .

tanks .