cancel
Showing results for 
Search instead for 
Did you mean: 

need to make quer ?

Former Member
0 Kudos

hello all

I need to have raport which shows

invoice nr / payer nr / invoice creation date / text field from invoice / delivery nr / delivery creation date / order nr / order creation date / person who created order /

as I know I need to use tables

VBAK

LIKP

VBRK

...

but what is sequence of this tables in quer ?

what kind of connection ?

anyone could give me instructions how to do that ?

thx

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

flow is Sales order-->Delivery-> billing.

get data from VBAK and VBAP into GT_VB

based on SOs get data from LIKP and LIPS into table GT_LI

based Delivery get data from VBRK and VBRP into table GT_VB

if want do validations , check these entries are existed in the table VBFA or not..

and populate data from above three internal tables.

Answers (0)