Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to combine the transparent table with cluster table.

Answer Posted / debabrata patra

We cant perform joins on cluster tables, so first get the data from cluster table(BSEG) into internal table and use SELECT..with FOR ALL ENTRIES option on transparent table(BKPF).

SELECT * FROM BSEG

INTO TABLE IT_BSEG

WHERE <CONDITION>.

IF IT_BSEG[] IS NOT INITIAL.

SELECT field1, field2 FROM BKPF

INTO TABLE IT_BKPF

FOR ALL ENTRIES IN IT_BSEG

WHERE <CONDITON>.

ENDIF.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....

2060


What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization

1055


What is append search help? : sap abap data dictionary

1141


HOW TO DIFFERENT CALL TRANSACTION ON THE BASIS OF DOUBLE CLICKING ON DIFFERENT FIELD.

2231


What are the difference between tables and structures? : abap data dictionary

1135


What are the system table used in abap?

1084


What is the difference between collect and append statements?

1050


Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?

1951


Explain the advantages and disadvantages of abap query tool?

923


When, how and how would you control changes to standard SAP objects.

1838


What are the dynamic actions and how to configure it? : sap abap hr

1112


Explain what are the various types of selection screen event?

1048


What are the data classes in abap?

1098


How many ways can a sap system be accessed?

1200


While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization

1085