We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

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

RE:[sap-log-sd] Fields from Two internal tables into a single itab

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

0 Comments

Posted by sagarn
on Dec 7 at 3:21 AM 		Mark this reply as helpfulMark as helpful
Hi Mritunjay,

Declare a type that has a combination of the fields that you need from these two tables.
TYPES: BEGIN OF ty_tab,
fields from vbak,
fields from vbpa,
END OF ty_tab.

Declare an internal table and work area for the same type:
DATA: gt_tab TYPE STANDARD TABLE OF ty_tab,
gs_tab TYPE ty_tab.

Your select query will be an inner join query on VBAK and VBPA, with a JOIN on the field VBELN. Your can select the desired fields in this query into the table.

Thanks,
Sagar

---------------Original Message---------------
From: nagchinta
Sent: Friday, December 03, 2010 6:55 PM
Subject: Fields from Two internal tables into a single itab

I have two internal tables vbak and vbpa. I want some fields from vbak and two fields from vbpa .plz tell me how can i get all fields in a single internal table so i can select all those fields ...
what is the select query for this ....
i am using alv grid...(not in oops)
and 1 more request ..how to validate the fields in select option.
plz help me out with this..
Thanx & Regards.
Mritunjay Biswas
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

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