How to get data from LAGP using VBAP ?

[former_member594288]

Hi,

How to get data from LAGP using VBAP ?

[former_member594288]

Hi,

How to get data from LAGP using VBAP ?

[RobertVit]

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

[former_member594288]

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

[Nawanandana]

Hi,

you have to link using table LTAK.

LAGP-LGNUM = LTAK -LGNUM

LTAK -VBELN = VBAP-VBELN

[former_member594288]

In LTAK, vbeln is empty.

[Nawanandana]

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

[RobertVit]

Hi,

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

[RaymondGiuseppi]

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?

[former_member594288]

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

[RaymondGiuseppi]

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

[former_member594288]

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

[RaymondGiuseppi]

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)