How to fetch details based on sales order....

[Former Member]

hi,

How to fetch all invoice number with corresponding net value,cost then credit and

debit memo details corresponding to one sales order .

plz reply.

[Former Member · Accepted solution]

Hi

From VBRK and VBRP tables you can get the details of Invoice, Credit and Debit Memo's

Pass

VBRP-AUBEL = VBAP-VBELn and

VBRP-AUPOS = VBAP-POSNR

Invoice, credit and Debit memo's all are billing doc which are differentiated by Billing doc type in VBRk table

all doc data is in VBRK and VBRP only

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member · Accepted solution]

Which all fileds shild i need to fetch frm vbak?

and then for all entries of vbeln Which all fileds shuld i need to fetch frm vbap?

[shahid]

go to sales order tcode...va01, search for the neccessary fields and then ... press f1 on the fields which u want to pull out the list. u can see the table and fieldname in the technical settings

[Former Member]

HI,

See the relation b/w sales order table & billing table

VBAP=VBRLN = VBRP-AUBEL
VBAP-POSNR = VBRP-AUPOS

then for fetching the cost & credit debit indicator , use this relationship.

VBRK-VBELN = BKPF-AWKEY
BKPF-AWTYP = 'VBRK'

Reward Points if it is Useful.

Thanks,

Manjunath MS

[Former Member]

Hi,

You probably could use <b>VBFA</b> table to get all the required details.

<b>

Reward points if this helps.</b>

Kiran

[Former Member]

i think flow of fetching data is VBAK->VBAP->VBFA->VBRP

But i dont know which fields shuld take from these table to get the rrequired output.

[kiran_k8]

Anu,

Select the required fields from VBRK w.r.t the sales document number in VBAK.

K.Kiran.