We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-abap] Code to fetch records from VBRK and VBRP table

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by amit_hbti
on Mar 21 at 4:49 AM
Problem is with the select statement.
Please check SAP help (F1 key) for syntax. This should solve your issue.

Regards,
Amit

---------------Original Message---------------
From: rajivvarma
Sent: Monday, March 21, 2011 4:16 AM
Subject: Code to fetch records from VBRK and VBRP table

Hi Experts,

In my query report I want to get invoice value in local currency by calculating two fields vbrp-netwr * vbrk-kurrf .
I am in new to ABAP code and tried the following code.
tables:vbrk,vbrp.
DATA:
znetwr LIKE vbrp-netwr,
zkurrf LIKE vbrk-kurrf,


SELECT netwr kurrf INTO (znetwr,zkurrf) from vbrk inner join vbrp on vbrk-mandt = vbrp-mandt and vbrk-vbeln = vbrp-vbeln

ENDSELECT.
zdmbtr = znetwr * zkursk.
WRITE:/ zdmbtr.
Could anyone tell me what is wrong with my code?
Thank you in advance.

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Most Popular White Papers

In the Spotlight
Get Fast, Reliable Enterprise-Class Storage. Learn About IBM Storwize v7000
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language