Goods Issue link with SD

[Former Member]

Hi Experts,

I have a requirement to extract data from goods issue (MSEG, MKPF). However there's a need to determine fields like Sold-Tos and Ship-Tos which can only be found in sales document. Are there any means in connecting/linking Goods issue to SD? Thanks!

Best Regards,

Kurtt

[pankaj_singh9 · Accepted solution]

Hi,

Check in MKPF Table, Material Documents with Field Trans./Ev. Type having value as WL i.e. Goods Issue for Delivery will be for SD Delivery. Also you can have field Transaction Code having value as VL01N, VL10B, VL10D, etc... if for SD Delivery.

Also in table MKPF, in field "XBLNR" (i.e. Reference Document Number), it populates the Delivery Document No ( VBELN ), get this No and then pass this to tables LIKP and LIPS and get the necessary details.

[Pawan_Kesari]

Use value in field LFBNR and LFPOS to get required Sales document from table VBFA