topic Re: How to get data from LAGP using VBAP ? in Application Development and Automation Discussions

How to get data from LAGP using VBAP ?

former_member594288 — Tue, 20 Aug 2019 12:22:35 GMT

Hi,

How to get data from LAGP using VBAP ?

Re: How to get data from LAGP using VBAP ?

RobertVit — Tue, 20 Aug 2019 12:31:30 GMT

with functionmodule L_LQUA_COLLECT_FOR_BAPI you will get lqua table with key fields for lagp

Re: How to get data from LAGP using VBAP ?

former_member594288 — Tue, 20 Aug 2019 12:57:35 GMT

How can i get LAGP data using this? there is no VBAK link.

Re: How to get data from LAGP using VBAP ?

Nawanandana — Tue, 20 Aug 2019 20:55:17 GMT

Hi,

you have to link using table LTAK.

LAGP-LGNUM = LTAK -LGNUM

LTAK -VBELN = VBAP-VBELN

Re: How to get data from LAGP using VBAP ?

RobertVit — Wed, 21 Aug 2019 04:33:35 GMT

Hi,

cause of your question i thought you are using custom stock.....

Re: How to get data from LAGP using VBAP ?

RaymondGiuseppi — Wed, 21 Aug 2019 08:00:03 GMT

In which case do you want to identify Storage bins from a sales document item number, did you already look at tables such as LIPS, LQUA, or LTAP?

Re: How to get data from LAGP using VBAP ?

former_member594288 — Wed, 21 Aug 2019 12:32:04 GMT

In LTAK, vbeln is empty.

Re: How to get data from LAGP using VBAP ?

former_member594288 — Wed, 21 Aug 2019 12:32:47 GMT

Can you tell me the link b/w the tables using VBAP.

Re: How to get data from LAGP using VBAP ?

RaymondGiuseppi — Wed, 21 Aug 2019 12:48:45 GMT

Could you define your case or look for the key/criteria fields in the table with SE11.

Re: How to get data from LAGP using VBAP ?

former_member594288 — Wed, 21 Aug 2019 13:47:03 GMT

Hi Raymond,

I followed the below logic. Is it fine to link like below?

FROM vbap AS vp

INNER JOIN mska AS ms

ON vp~vbeln = ms~vbeln

AND vp~posnr = ms~posnr

AND vp~matnr = ms~matnr

AND vp~werks = ms~werks

AND vp~sobkz = ms~sobkz

INNER JOIN lqua AS lq ON

ms~matnr = lq~matnr

AND ms~werks = lq~werks

AND ms~charg = lq~charg

AND ms~sobkz = lq~sobkz

INNER JOIN lagp AS lg

ON lq~lgnum = lg~lgnum

AND lq~lgtyp = lg~lgtyp

AND lq~lgpla = lg~lgpla

Re: How to get data from LAGP using VBAP ?

Nawanandana — Wed, 21 Aug 2019 14:08:33 GMT

You need to check LTAK -BETYP = 'L'. others will be different or let us know what is the senario your looking at.

Re: How to get data from LAGP using VBAP ?

RaymondGiuseppi — Wed, 21 Aug 2019 14:49:05 GMT

Can be correct (depends on your actual requirement: delivered part, customer stock items, transfer order, etc.) also try to minimize redundant join criteria (only when actually required, test/check as usual)