‎2008 Jan 30 12:38 PM
Hi,
i just started learning VBAK and VBAP tables. I want to see the salesorder#, item#, material#, material description, quantity, and rate fields from VBAP table. But I am not sure what fields to take from VBAP. Please help.
Thanks in advance.
‎2008 Jan 30 12:48 PM
Hi,
salesorder# - VBAP-VBELN,
item# - VBAP-POSNR,
material# - VBAP-MATNR
material description - MAKT-MAKTX
quantity - VBAP-ZMENG, and
rate - VBAP-ZWERT.
Regards,
Satish
‎2008 Jan 30 12:44 PM
salesorder# VBELN
item# POSNR
material# MATNR
material description ARKTX
quantity KWMENG
rate (I guess you mean price, if I'm wrong correct me) NETPR
The last 2 fields may depend more specifically on what you are developing, but generally those fields are used.
Regads,
Pablo
‎2008 Jan 30 12:46 PM
Him,
material description
you have to get it from mara table
MAKT
MAKTX is the field
Material Description
regards,
Venkatesh
‎2008 Jan 30 12:48 PM
Hi,
salesorder# - VBAP-VBELN,
item# - VBAP-POSNR,
material# - VBAP-MATNR
material description - MAKT-MAKTX
quantity - VBAP-ZMENG, and
rate - VBAP-ZWERT.
Regards,
Satish
‎2008 Jan 30 12:52 PM
salesorder#, -VBAP-VBELN
item#, VBAP--POSNR
material#, -VBAP-MATNR
material description, VBAP-ARKTX OR MAKT-MAKTX
quantity -VBAP-ZMENG
rate PER ITEM VBAP--netpr
total price - VBAP-NETWR
‎2008 Jan 30 12:56 PM