what is lfa1 and lifnr? can anyone one help me with details about it.

[Former Member]

what is lfa1 and lifnr? can anyone one help me with details about it.

&

another q:

data: begin of vbak occurs 5,

f1(10),

f2(10),

f3(10),

f4(10),

f5(10),

end of vbak.

vbak-f1 = 'vbeln'.

vbak-f2 = 'erdat'.

vbak-f3 = 'vkorg'.

vbak-f4 = 'vtweg'.

vbak-f5 = 'kunnr'.

append vbak.

loop at vbak.

write : vbak.

endloop.

this program is written normally i want to get this program

retrive and display with a <u><b>query from the above structure instead of write vbak</b></u>.please help

[former_member386202]

Hi,

LFA1 is a vendor master table n lifnr is a vendor number

Regards,

Prashant

[Former Member]

1.

LFA1 is VEndor master table & LIFNR is Vendor code

2.

SELECT vbeln erdat vkorg vtweg kunnr into (vbak-f1, vbak-f2, vbak-f3, vbak-F4, vbak-f5) from VBAK.

APPEND vbak.

ENDSELECT. 

"But define ur interanl table like this..
DATA: BEGIN OF vbak OCCURS 5,
vbeln LIKE vbak-vbeln,
erdat LIKE vbak-erdat,
vkorg LIKE vbak-vkorg,
vtweg LIKE vbak-vtweg,
kunnr LIKE vbak-kunnr,
END OF vbak.
"then query will be like this
SELECT vbeln erdat vkorg vtweg kunnr INTO  CORRESPONDING FIELDS OF TABLE vbak FROM vbak.

Message was edited by:

Perez C

Message was edited by:

Perez C

[Former Member]

lifnr is Account Number of Vendor or Creditor..

which is used in sales and distribution for keeping a purchase order,or converting into sales order..

for your second query u have already created an internal table,so check this..

select vbeln erdat vkorg vtweg kunnr from vbak into vbak.

append vbak.

use where condition if ur using select options..