VBAK and VBFA

[Former Member]

Hello friends,

Is there any relation between

VBELN-VBAK and VBELV-VBFA,

Is there a common field between the two tables for retriveing data from VBAK based on a field from VBFA.

Thanks,

Shejal.

[Former Member]

VBAK-VBELN will exist in VBFA if there it is part of a document flow. In other words, if you have a corresponding sales inquiry or delivery, VBAK-VBELN would be in VBFA-VBELN or VBFA-VBELV respectively.

[Former Member]

Hi Shejal,

Please check this link perhaps it may help.

http://www.erpgenie.com/sap/abap/tables_sd.htm

Regards,

Ferry Lianto

[Former Member]

Hi Shejal,

i think that VBFA-VBELV is equal to VBAK-VBELN.

Look at vbak with an specific VBELN and loop over VBFA

with VBELV = VBAK-VBELN and you see all relations.

Regards, Dieter

[Former Member]

Hi

Yes of course

VBFA is the table of the flow of sales document, so you can find all SD document in VBFA, so sales order.

Now u ave to know the type of a sale document.

You can find this information in field VBTYP:

A Inquiry

B Quotation

C Order

D Item proposal

E Scheduling agreement

F Scheduling agreement with external service agent

G Contract

H Returns

I Order w/o charge

J Delivery

K Credit memo request

L Debit memo request

M Invoice

N Invoice cancellation

O Credit memo

P Debit memo

Q WMS transfer order

R Goods movement

S Credit memo cancellation

T Returns delivery for order

U Pro forma invoice

V Purchase order

W Independent reqts plan

X Handling unit

0 Master contract

1 Sales activities (CAS)

2 External transaction

3 Invoice list

4 Credit memo list

5 Intercompany invoice

6 Intercompany credit memo

7 Delivery/shipping notification

8 Shipment

a Shipment costs

e Allocation table

g Rough Goods Receipt (only IS-Retail)

h Cancel goods issue

i Goods receipt

j JIT call

r TD Shipment (IS-Oil Only)

s Loading Confirmation, Reposting (IS-Oil Only)

t Gain/Loss (IS-Oil Only)

u Placing Back in Stock (IS-Oil Only)

v Two-Step Goods Receipt (IS-Oil Only)

w Reservation (IS-Oil Only)

x Loading Confirmation, Goods Receipt (IS-Oil Only)

$ (AFS)

So: if you need to find the order like preceding document:

VBFA-VBELV = VBAK-VBELN.

VBFA-VBTYP_V = VBAK-VBTYP.

else:

VBFA-VBELN = VBAK-VBELN.

VBFA-VBTYP_N = VBAK-VBTYP.

Max