cancel
Showing results for 
Search instead for 
Did you mean: 

Table of correspondence of outbound delivery and billing document/

Former Member
0 Kudos

Dear all,

Could you please tell me if there is any tables where I can find outbound delivery and billing document?

I really need to find the correspondence of these two documents.

BR,

Linh.

Discussion locked.

Reported abuse as being a basic & generic query.

Please put little effort in searching and elaborating the requirement.

Message was edited by: Jyoti Prakash

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member182378
Active Contributor
0 Kudos

Van, Kesari, Pitabash,

It is interesting to see that both members have taken different "input parameters".

Kesari has taken billing document as input parameter and found the related delivery number.

On the other hand, Pitabash has taken delivery number as input parameter and found the billing document number.

Van, what is / are the input parameters and what are you trying to extract?

Note: There could be n:m relationship between delivery note:billing document

moazzam_ali
Active Contributor
0 Kudos

Have you searched forum before posting this query? This has been discussed many times.

Former Member
0 Kudos

Hi,

You can check with table VBFA,

pass delivery number with VBFA-VBELV and pick the value from the field VBFA-VBELN correspondent to the VBTYP_N ,

M- for Invoice

Q - for Tranfer order

R - For PGI

O    Credit memo

P    Debit memo

ets..

Hope it will help you.

Regards

Pitabash

former_member184080
Active Contributor
0 Kudos

Hi Linh,

For this you have to go the line item table VBRP - VGBEL and VGTYP = J. Otherwise you will get credit memo request numbers also.

Regards, Sai Krishna.

former_member182378
Active Contributor
0 Kudos

Kesari,

One question - In the billing document, at line item level, field "Reference doc" (you mentioned in your post) and associated Doc. category; are these fields configurable?

If yes, where can we do these configuration settings?

I checked VTFL, at header level, fields Assignment and Reference are configurable.

But at item level, where are the settings?

Thank you!