topic Function module to get VBAK using VGBEL in Application Development and Automation Discussions

Function module to get VBAK using VGBEL

Subbaka11 — Fri, 22 Jan 2021 09:01:56 GMT

Hello team,

As per project requirement.. I have to fetch VBAK data using VGBEL.

Since VGBEL is not a key field of VBAK I am facing performance issues.

Can any one suggest me a function module to get VBAK-VBELN using LIPS-VGBEL.

We also need to fetch TKNUM from vttp using vbeln (non key field of VTTP)

Re: Function module to get VBAK using VGBEL

FredericGirod — Fri, 22 Jan 2021 09:26:15 GMT

First, stop thinking Function Module will solved everything because it is ... a FM

it is old school, forget it

VGBEL is a reference document, it could be the key of VBAK

The performance optimization depends of the context, how did you access the data, what do you need in VBAK ?

Re: Function module to get VBAK using VGBEL

MateuszAdamus — Fri, 22 Jan 2021 09:40:14 GMT

Hello dubbaka

If you're facing performance issue reading VBAK by VGBEL then consider creating an additional index on the VBAK table with the VGBEL field as one of the fields.

Kind regards,
Mateusz

Re: Function module to get VBAK using VGBEL

Subbaka11 — Fri, 22 Jan 2021 11:25:19 GMT

Hi Frederic,

I am fetching TKNUM from VTTP table passing VBELN in where condition

since VBELN is not a key field of VTTP it would be bad in performance, so I am looking for FM.

Select

tknum,

tpnum,

vbeln

from VTTP

into table @dat(it_vttp)

for all entries in @it_likp_lips

where vbeln = @it_likp_lips-vbeln.

Thank you.

Re: Function module to get VBAK using VGBEL

FredericGirod — Fri, 22 Jan 2021 12:46:28 GMT

Check VEPVG Index, it is a link between Sales order & Transport.

Re: Function module to get VBAK using VGBEL

Sandra_Rossi — Fri, 22 Jan 2021 12:53:15 GMT

Your question is not very clear. I'm afraid I can't answer precisely.

Why do you want to read via a function module?

What is your LIPS-VGTYP value? (example, if VGTYP='C' then VGBEL refers to a sales order in VBAK i.e. LIPS-VGBEL -> VBAK-VBELN directly)

Concerning VTTP, it has THE index VBL over field VBELN in my S/4HANA system.