topic Re: Left outer join in OPEN SQL in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513792#M568619 <HTML><HEAD></HEAD><BODY><P>Ans:</P><P></P><P>1.C</P><P>2.A</P><P>3.A</P><P>4.C</P><P>5.B</P><P>6.A</P><P>7.B</P><P>8.A</P><P>9.C</P><P>10.D</P><P>11.ID is mandatory</P><P>12.B</P><P>13.ALL</P><P>14.B,C,E</P><P>15.A</P><P>16.ABDE</P><P>17.C</P><P>18.A</P><P>19.ALL ARE CORRECT</P><P>20.ACD</P><P>21.B</P><P>22.C</P><P>23.CD</P><P>24.AB</P><P>25.B</P><P></P><P>Hey Make your question as simple as possible <SPAN __jive_emoticon_name="happy"></SPAN></P><P></P><P>Cheers,</P><P>Hakim</P></BODY></HTML> Mon, 09 Jul 2007 19:04:58 GMT abdul_hakim 2007-07-09T19:04:58Z Left outer join in OPEN SQL https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513789#M568616 <HTML><HEAD></HEAD><BODY><P>Can someone help me to solve this query please?</P><P></P><P>1. What conditions apply for a LEFT Outer Join in OPEN SQL?</P><P></P><P>a) Only 'Or' can be used as a logical operator in the ON condition</P><P></P><P>b) A join statement is found to the right of the join operator</P><P></P><P>c) At least one field from the table on the right is required for comparison in the ON condition</P><P></P><P>d) A Left Outer Join is not permitted in OPEN SQL</P><P></P><P>2. What is true about a check table?</P><P></P><P>a) Foreign key fields can accept only values which exist in the check table</P><P></P><P>b) Check table fields can accept only values which exist in the check table</P><P></P><P>c) Foreign key fields can accept any values regardless of the check table</P><P></P><P>d) Check tables are not used for restricting values in the foreign key tables</P><P></P><P>3. When you EXPORT an internal table that has a header line to ABAP/4 memory, what is the result?</P><P></P><P>a) Only the contents of the internal table is stored</P><P></P><P>b) Only the header line is stored</P><P></P><P>c) The header line and contents of the internal table are stored</P><P></P><P>d) You cannot EXPORT an internal table with a header line.</P><P></P><P>4. Where does information come from when you press F1 on a screen field?</P><P></P><P>a) Domain short text</P><P></P><P>b) Search help</P><P></P><P>c) Data element documentation</P><P></P><P>d) Domain Help values</P><P></P><P>5. What are the main functions of a Data Dictionary? More than one answer is correct.</P><P></P><P>a) To insulate the ABAP/4 developer from the database</P><P></P><P>b) To support the creation and management of metadata (data about data)</P><P></P><P>c) To provide data security at the application level</P><P></P><P>d) To connect to the operating system</P><P></P><P>6. Which Report Statement option determines the width of a list?</P><P></P><P>a) Line-Size</P><P></P><P>b) Line-Count</P><P></P><P>c) Line-Width</P><P></P><P>d) Report Size</P><P></P><P>7. What is the recommended method to modify a standard search help to include customer defined search paths?</P><P></P><P>a) Add an elementary search help to the standard search help</P><P></P><P>b) Enhance the standard search help with an append search help</P><P></P><P>c) Add a collective search help to the standard search help</P><P></P><P>d) Perform a modification to the standard search help</P><P></P><P>8. Where are Dictionary runtime objects used ?</P><P></P><P>a) in the dictionary</P><P></P><P>b) in structures</P><P></P><P>c) in table "nametab"</P><P></P><P>d) in work processes</P><P></P><P>9. If you want a subroutine U to have a formal parameter P that is used to return a value to the actual parameter . Which of the following definitions of U would you use to ensure that the value is passed back to the calling program only if the processing of U ends normally and is not terminated with a message statement ?</P><P></P><P>a) Form U changing P.</P><P></P><P>b) Form U using P.</P><P></P><P>c) Form U changing value(P).</P><P></P><P>d) Form U using value(P).</P><P></P><P>e) Form U using P local P.</P><P></P><P>10. You want to go from dialog processing to list processing using a selection screen . Which statements would you use?</P><P></P><P>a) call screen .</P><P></P><P>b) read list.</P><P></P><P>c) call transaction .</P><P></P><P>d) leave to ist processing followed by call selection-screen &lt;nnn&gt;.</P><P></P><P>e) selection-screen followed by parameters.</P><P></P><P>11. What happens to memory when the Export is executed without specifying ID. i.e EXPORT object to memory ?</P><P></P><P>a) The ABAP memory is completely overwritten</P><P></P><P>b) SAP Memory is overwritten</P><P></P><P>c) ABAP memory sets up a new default area</P><P></P><P></P><P>12. When does the processing block for a Get statement end?</P><P></P><P>a) When the next keyword event is encountered</P><P></P><P>b) When all data has been retrieved for the Get</P><P></P><P>c) After each PUT in the LDB</P><P></P><P>d) When the END GET statement is encountered</P><P></P><P></P><P>13. Which of the following steps should be carried out in a transaction that implements updates ? More than one answer is correct.</P><P></P><P>a) read the record that is to be updated.</P><P></P><P>b) lock the record that is to be updated.</P><P></P><P>c) pass the changed data to the update process.</P><P></P><P>d) unlock the record that is to be updated.</P><P></P><P>e) call the Abap command commit work.</P><P></P><P>14. Which enhancements planned by SAP are maintained in transaction CMOD (SAP enhancements)? More than one answer is correct.</P><P></P><P>a) Table appends</P><P></P><P>b) Menu exits</P><P></P><P>c) function module exits</P><P></P><P>d) User exits</P><P></P><P>e) Screen exits</P><P></P><P>15. Why would you group corrections together? More than one answer is correct.</P><P></P><P>a) To enable several corrections to be assigned to the same transport.</P><P></P><P>b) To transport objects from different development classes.</P><P></P><P>c) To prevent other developers from processing the same objects.</P><P></P><P>d) To enable several developers to process the same object in parallel.</P><P></P><P>e) To retain versions of several objects together.</P><P></P><P>16. Which statements are allowed if you are working with an internal table of type sorted? More than one answer is correct.</P><P></P><P>a) Append</P><P></P><P>b) Collect</P><P></P><P>c) Sort</P><P></P><P>d) Read</P><P></P><P>e) Modify</P><P></P><P>17. How can you set the status and title for a modal dialog box?</P><P></P><P>a) In the attributes of the corresponding screen.</P><P></P><P>b) Before the corresp. call screen statement.</P><P></P><P>c) In a PBO module of the corresponding screen.</P><P></P><P>d) In the PAI module of the corresponding screen.</P><P></P><P>18. Which ABAP data type would you use for calculations which require high degree of precision?</P><P></P><P>a) P</P><P></P><P>b) I</P><P></P><P>c) F</P><P></P><P>d) N</P><P></P><P>e) X</P><P></P><P>19. Which of the following statements about R/3 instances are correct? More than one answer is correct.</P><P></P><P>a) An R/3 instance is an administrative unit that combines together all the components of a R/3 system that provide one or more services.</P><P></P><P>b) A central R/3 system consists of one or more Instances.</P><P></P><P>c) Each instance has its own SAP buffer area.</P><P></P><P>d) Each instance contains at least one dialog service .</P><P></P><P>20. Where can you find the SET/GET parameters that has been assigned to a screen field? More than one answer is correct.</P><P></P><P>a) in table TPARA.</P><P></P><P>b) in the object list of the module pool.</P><P></P><P>c) in the F1 help for the screen field under technical info.</P><P></P><P>d) in the field list of the screen in the screen painter.</P><P></P><P>e) in the window with possible values.</P><P></P><P>21. What must you do to undo DB changes previously issued in a dialog? More than one answer is correct.</P><P></P><P>a) output E message.</P><P></P><P>b) perform rollback work.</P><P></P><P>c) raise exception.</P><P></P><P>d) Analyze log record.</P><P></P><P>e) code rollback LUW.</P><P></P><P>22. An update function module VF is called within subprogram VU .The program contains the call , VU on commit . At which point are the parameters for the update function VF evaluated?</P><P></P><P>a) when perform is executed</P><P></P><P>b) at the beginning of function</P><P></P><P>c) at commit work</P><P></P><P>d) at start of v1 update</P><P></P><P>e) at the end of the dialog step</P><P></P><P>23. Which events and statements determine the end of an SAP LUW in an online program with synchronous update? More than one answer is correct.</P><P></P><P>a) call function in update task</P><P></P><P>b) the start of the next dialog step</P><P></P><P>c) commit work (explicit)</P><P></P><P>d) call screen</P><P></P><P>e) leave to list processing</P><P></P><P>24. What methods can be used to set the values for printing an online list? More than one answer is correct.</P><P></P><P>a) Include SET_PRINT_PARAMTERS</P><P></P><P>b) Function SET_PRINT_PARAMETERS</P><P></P><P>c) NEW-PAGE PRINT ON</P><P></P><P>d) Function GET_PRINT_PARAMETERS</P><P></P><P>25. What does a LDB (Logical Database) provide?</P><P></P><P>a) Consistent and flexible user interface</P><P></P><P>b) Central performance improvements for update accesses</P><P></P><P>c) A method to access the data in a random manner</P><P></P><P>d) Centrally defined authorization checks</P><P></P><P></P><P>Regards,</P><P>Mau</P></BODY></HTML> Mon, 09 Jul 2007 16:33:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513789#M568616 Former Member 2007-07-09T16:33:03Z Re: Left outer join in OPEN SQL https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513790#M568617 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Start with this.Refer this</P><P>For BDC:</P><P><A href="http://myweb.dal.ca/hchinni/sap/bdc_home.htm" target="test_blank">http://myweb.dal.ca/hchinni/sap/bdc_home.htm</A></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/bdc&amp;" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/bdc&amp;</A>;</P><P><A href="http://www.sap-img.com/abap/learning-bdc-programming.htm" target="test_blank">http://www.sap-img.com/abap/learning-bdc-programming.htm</A></P><P><A href="http://www.sapdevelopment.co.uk/bdc/bdchome.htm" target="test_blank">http://www.sapdevelopment.co.uk/bdc/bdchome.htm</A></P><P><A href="http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm" target="test_blank">http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm</A></P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/69/c250684ba111d189750000e8322d00/frameset.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/69/c250684ba111d189750000e8322d00/frameset.htm</A></P><P><A href="http://www.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html" target="test_blank">http://www.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html</A></P><P></P><P></P><P>Check these link:</P><P><A href="http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm" target="test_blank">http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm</A></P><P><A href="http://www.sap-img.com/abap/question-about-bdc-program.htm" target="test_blank">http://www.sap-img.com/abap/question-about-bdc-program.htm</A></P><P><A href="http://www.itcserver.com/blog/2006/06/30/batch-input-vs-call-transaction/" target="test_blank">http://www.itcserver.com/blog/2006/06/30/batch-input-vs-call-transaction/</A></P><P><A href="http://www.planetsap.com/bdc_main_page.htm" target="test_blank">http://www.planetsap.com/bdc_main_page.htm</A></P><P></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="2491514"></A> </P><P></P><P></P><P><A href="http://www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_DATADICTIONARY_FAQ.html" target="test_blank">http://www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_DATADICTIONARY_FAQ.html</A></P><P><A href="http://www.saptechnical.com/InterviewQ/interviewQ.htm" target="test_blank">http://www.saptechnical.com/InterviewQ/interviewQ.htm</A></P><P><A href="http://help.sap.com/saphelp_46c/helpdata/en/35/2cd77bd7705394e10000009b387c12/frameset.htm" target="test_blank">http://help.sap.com/saphelp_46c/helpdata/en/35/2cd77bd7705394e10000009b387c12/frameset.htm</A></P><P>Reports</P><P><A href="http://www.sapgenie.com/abap/reports.htm" target="test_blank">http://www.sapgenie.com/abap/reports.htm</A></P><P><A href="http://www.allsaplinks.com/material.html" target="test_blank">http://www.allsaplinks.com/material.html</A></P><P><A href="http://www.sapdevelopment.co.uk/reporting/reportinghome.htm" target="test_blank">http://www.sapdevelopment.co.uk/reporting/reportinghome.htm</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=58286" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=58286</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=76490" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=76490</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=20591" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=20591</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=66305" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=66305</A> - this one discusses which way should you use - ABAP Objects calls or simple function modules.</P><P>ALE/ IDOC</P><P><A href="http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm" target="test_blank">http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm</A></P><P><A href="http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc" target="test_blank">http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc</A></P><P><A href="http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419" target="test_blank">http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419</A></P><P><A href="http://www.netweaverguru.com/EDI/HTML/IDocBook.htm" target="test_blank">http://www.netweaverguru.com/EDI/HTML/IDocBook.htm</A></P><P><A href="http://www.sapgenie.com/sapedi/index.htm" target="test_blank">http://www.sapgenie.com/sapedi/index.htm</A></P><P><A href="http://www.sappoint.com/abap/ale.pdf" target="test_blank">http://www.sappoint.com/abap/ale.pdf</A></P><P><A href="http://www.sappoint.com/abap/ale2.pdf" target="test_blank">http://www.sappoint.com/abap/ale2.pdf</A></P><P><A href="http://www.sapgenie.com/sapedi/idoc_abap.htm" target="test_blank">http://www.sapgenie.com/sapedi/idoc_abap.htm</A></P><P><A href="http://help.sap.com/saphelp_erp2005/helpdata/en/0b/2a60bb507d11d18ee90000e8366fc2/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005/helpdata/en/0b/2a60bb507d11d18ee90000e8366fc2/frameset.htm</A></P><P><A href="http://help.sap.com/saphelp_erp2005/helpdata/en/78/217da751ce11d189570000e829fbbd/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005/helpdata/en/78/217da751ce11d189570000e829fbbd/frameset.htm</A></P><P><A href="http://www.allsaplinks.com/idoc_sample.html" target="test_blank">http://www.allsaplinks.com/idoc_sample.html</A></P><P><A href="http://www.sappoint.com/abap.html" target="test_blank">http://www.sappoint.com/abap.html</A></P><P></P><P><A href="http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm" target="test_blank">http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm</A></P><P><A href="http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc" target="test_blank">http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc</A></P><P><A href="http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419" target="test_blank">http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419</A></P><P><A href="http://www.netweaverguru.com/EDI/HTML/IDocBook.htm" target="test_blank">http://www.netweaverguru.com/EDI/HTML/IDocBook.htm</A></P><P><A href="http://www.sapgenie.com/sapedi/index.htm" target="test_blank">http://www.sapgenie.com/sapedi/index.htm</A></P><P><A href="http://www.allsaplinks.com/idoc_sample.html" target="test_blank">http://www.allsaplinks.com/idoc_sample.html</A></P><P></P><P>Check these step-by-step links</P><P></P><P><A href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/ccab6730-0501-0010-ee84-de050a6cc287" target="test_blank">https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/ccab6730-0501-0010-ee84-de050a6cc287</A></P><P></P><P><A href="https://sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/8fd773b3-0301-0010-eabe-82149bcc292e" target="test_blank">https://sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/8fd773b3-0301-0010-eabe-82149bcc292e</A></P><P></P><P><A href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/3c5d9ae3-0501-0010-0090-bdfb2d458985" target="test_blank">https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/3c5d9ae3-0501-0010-0090-bdfb2d458985</A></P><P></P><P>for Smartforms material</P><P><A href="http://www.sap-basis-abap.com/sapsf001.htm" target="test_blank">http://www.sap-basis-abap.com/sapsf001.htm</A></P><P><A href="http://www.sap-press.com/downloads/h955_preview.pdf" target="test_blank">http://www.sap-press.com/downloads/h955_preview.pdf</A></P><P><A href="http://www.ossincorp.com/Black_Box/Black_Box_2.htm" target="test_blank">http://www.ossincorp.com/Black_Box/Black_Box_2.htm</A></P><P><A href="http://www.sap-img.com/smartforms/sap-smart-forms.htm" target="test_blank">http://www.sap-img.com/smartforms/sap-smart-forms.htm</A></P><P><A href="http://www.sap-img.com/smartforms/smartform-tutorial.htm" target="test_blank">http://www.sap-img.com/smartforms/smartform-tutorial.htm</A></P><P><A href="http://www.sapgenie.com/abap/smartforms.htm" target="test_blank">http://www.sapgenie.com/abap/smartforms.htm</A></P><P></P><P>How to trace smartform</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/49/c3d8a4a05b11d5b6ef006094192fe3/frameset.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/49/c3d8a4a05b11d5b6ef006094192fe3/frameset.htm</A></P><P></P><P><A href="http://www.help.sap.com/bp_presmartformsv1500/DOCU/OVIEW_EN.PDF" target="test_blank">http://www.help.sap.com/bp_presmartformsv1500/DOCU/OVIEW_EN.PDF</A></P><P></P><P><A href="http://www.sap-img.com/smartforms/smart-006.htm" target="test_blank">http://www.sap-img.com/smartforms/smart-006.htm</A></P><P><A href="http://www.sap-img.com/smartforms/smartforms-faq-part-two.htm" target="test_blank">http://www.sap-img.com/smartforms/smartforms-faq-part-two.htm</A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="1234083"></A></P><P></P><P>check most imp link</P><P><A href="http://www.sapbrain.com/ARTICLES/TECHNICAL/SMARTFORMS/smartforms.html" target="test_blank">http://www.sapbrain.com/ARTICLES/TECHNICAL/SMARTFORMS/smartforms.html</A></P><P></P><P>step by step good ex link is....</P><P></P><P><A href="http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Build_SMARTFORMS/How_To_Build_SMARTFORMS.html" target="test_blank">http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Build_SMARTFORMS/How_To_Build_SMARTFORMS.html</A></P><P></P><P>SAPScripts</P><P></P><P><A href="http://esnips.com/doc/1ff9f8e8-0a4c-42a7-8819-6e3ff9e7ab44/sapscripts.pdf" target="test_blank">http://esnips.com/doc/1ff9f8e8-0a4c-42a7-8819-6e3ff9e7ab44/sapscripts.pdf</A></P><P><A href="http://esnips.com/doc/1e487f0c-8009-4ae1-9f9c-c07bd953dbfa/script-command.pdf" target="test_blank">http://esnips.com/doc/1e487f0c-8009-4ae1-9f9c-c07bd953dbfa/script-command.pdf</A></P><P><A href="http://esnips.com/doc/64d4eccb-e09b-48e1-9be9-e2818d73f074/faqss.pdf" target="test_blank">http://esnips.com/doc/64d4eccb-e09b-48e1-9be9-e2818d73f074/faqss.pdf</A></P><P><A href="http://esnips.com/doc/cb7e39b4-3161-437f-bfc6-21e6a50e1b39/sscript.pdf" target="test_blank">http://esnips.com/doc/cb7e39b4-3161-437f-bfc6-21e6a50e1b39/sscript.pdf</A></P><P><A href="http://esnips.com/doc/fced4d36-ba52-4df9-ab35-b3d194830bbf/symbols-in-scripts.pdf" target="test_blank">http://esnips.com/doc/fced4d36-ba52-4df9-ab35-b3d194830bbf/symbols-in-scripts.pdf</A></P><P><A href="http://esnips.com/doc/b57e8989-ccf0-40d0-8992-8183be831030/sapscript-how-to-calculate-totals-and-subtotals.htm" target="test_blank">http://esnips.com/doc/b57e8989-ccf0-40d0-8992-8183be831030/sapscript-how-to-calculate-totals-and-subtotals.htm</A></P><P></P><P>SAP SCRIPT FIELDS</P><P></P><P><A href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/d1/8033ea454211d189710000e8322d00/content.htm" target="test_blank">http://help.sap.com/saphelp_erp2005vp/helpdata/en/d1/8033ea454211d189710000e8322d00/content.htm</A></P><P></P><P>scripts easy material</P><P></P><P><A href="http://www.allsaplinks.com/sap_script_made_easy.html" target="test_blank">http://www.allsaplinks.com/sap_script_made_easy.html</A></P><P></P><P>Debugging Document.</P><P><A href="http://www.cba.nau.edu/haney-j/CIS497/Assignments/Debugging.doc" target="test_blank">http://www.cba.nau.edu/haney-j/CIS497/Assignments/Debugging.doc</A></P><P></P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/content.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/content.htm</A></P><P><A href="http://www.cba.nau.edu/haney-j/CIS497/Assignments/Debugging.doc" target="test_blank">http://www.cba.nau.edu/haney-j/CIS497/Assignments/Debugging.doc</A></P><P><A href="http://help.sap.com/saphelp_erp2005/helpdata/en/b3/d322540c3beb4ba53795784eebb680/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005/helpdata/en/b3/d322540c3beb4ba53795784eebb680/frameset.htm</A></P><P><A href="http://help.sap.com/saphelp_nw04/helpdata/en/84/1f624f4505144199e3d570cf7a9225/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw04/helpdata/en/84/1f624f4505144199e3d570cf7a9225/frameset.htm</A></P><P><A href="http://help.sap.com/saphelp_bw30b/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/content.htm" target="test_blank">http://help.sap.com/saphelp_bw30b/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/content.htm</A></P><P><A href="http://help.sap.com/saphelp_erp2005/helpdata/en/b3/d322540c3beb4ba53795784eebb680/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005/helpdata/en/b3/d322540c3beb4ba53795784eebb680/frameset.htm</A></P><P></P><P>BAPI</P><P><A href="http://help.sap.com/saphelp_46c/helpdata/en/9b/417f07ee2211d1ad14080009b0fb56/frameset.htm" target="test_blank">http://help.sap.com/saphelp_46c/helpdata/en/9b/417f07ee2211d1ad14080009b0fb56/frameset.htm</A></P><P></P><P><A href="http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci948835,00.html" target="test_blank">http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci948835,00.html</A></P><P>Checkout !!</P><P><A href="http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci948835,00.html" target="test_blank">http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci948835,00.html</A></P><P><A href="http://techrepublic.com.com/5100-6329-1051160.html#" target="test_blank">http://techrepublic.com.com/5100-6329-1051160.html#</A></P><P><A href="http://www.sap-img.com/bapi.htm" target="test_blank">http://www.sap-img.com/bapi.htm</A></P><P><A href="http://www.sap-img.com/abap/bapi-conventions.htm" target="test_blank">http://www.sap-img.com/abap/bapi-conventions.htm</A></P><P><A href="http://www.sappoint.com/abap/bapiintro.pdf" target="test_blank">http://www.sappoint.com/abap/bapiintro.pdf</A></P><P></P><P><A href="http://www.sapgenie.com/abap/bapi/example.htm" target="test_blank">http://www.sapgenie.com/abap/bapi/example.htm</A></P><P><A href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCMIDAPII/CABFAAPIINTRO.pdf" target="test_blank">http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCMIDAPII/CABFAAPIINTRO.pdf</A></P><P><A href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CABFABAPIREF/CABFABAPIPG.pdf" target="test_blank">http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CABFABAPIREF/CABFABAPIPG.pdf</A></P><P><A href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE8/BCFESDE8.pdf" target="test_blank">http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE8/BCFESDE8.pdf</A></P><P></P><P>List of all BAPIs</P><P><A href="http://www.planetsap.com/LIST_ALL_BAPIs.htm" target="test_blank">http://www.planetsap.com/LIST_ALL_BAPIs.htm</A></P><P></P><P><A href="http://www.sappoint.com/abap/bapiintro.pdf" target="test_blank">http://www.sappoint.com/abap/bapiintro.pdf</A></P><P><A href="http://www.sappoint.com/abap/bapiprg.pdf" target="test_blank">http://www.sappoint.com/abap/bapiprg.pdf</A></P><P><A href="http://www.sappoint.com/abap/bapiactx.pdf" target="test_blank">http://www.sappoint.com/abap/bapiactx.pdf</A></P><P><A href="http://www.sappoint.com/abap/bapilst.pdf" target="test_blank">http://www.sappoint.com/abap/bapilst.pdf</A></P><P><A href="http://www.sappoint.com/abap/bapiexer.pdf" target="test_blank">http://www.sappoint.com/abap/bapiexer.pdf</A></P><P><A href="http://service.sap.com/ale" target="test_blank">http://service.sap.com/ale</A></P><P><A href="http://service.sap.com/bapi" target="test_blank">http://service.sap.com/bapi</A></P><P></P><P><A href="http://www.geocities.com/mpioud/Abap_programs.html" target="test_blank">http://www.geocities.com/mpioud/Abap_programs.html</A></P><P><A href="http://www.sapdevelopment.co.uk/reporting/reportinghome.htm" target="test_blank">http://www.sapdevelopment.co.uk/reporting/reportinghome.htm</A></P><P></P><P>Simple ALV report</P><P><A href="http://www.sapgenie.com/abap/controls/alvgrid.htm" target="test_blank">http://www.sapgenie.com/abap/controls/alvgrid.htm</A></P><P></P><P><A href="http://wiki.ittoolbox.com/index.php/Code:Ultimate_ALV_table_toolbox" target="test_blank">http://wiki.ittoolbox.com/index.php/Code:Ultimate_ALV_table_toolbox</A></P><P></P><P>ALV</P><P></P><P>1. Please give me general info on ALV.</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=58286" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=58286</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=76490" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=76490</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=20591" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=20591</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=66305" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=66305</A> - this one discusses which way should you use - ABAP Objects calls or simple function modules.</P><P></P><P>2. How do I program double click in ALV?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=11601" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=11601</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=23010" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=23010</A></P><P></P><P>3. How do I add subtotals (I have problem to add them)...</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=20386" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=20386</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=85191" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=85191</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=88401" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=88401</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=17335" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=17335</A></P><P></P><P>4. How to add list heading like top-of-page in ABAP lists?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=58775" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=58775</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=60550" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=60550</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=16629" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=16629</A></P><P></P><P>5. How to print page number / total number of pages X/XX in ALV?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=29597" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=29597</A> (no direct solution)</P><P></P><P>6. ALV printing problems. The favourite is: The first page shows the number of records selected but I don't need this.</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=64320" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=64320</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=44477" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=44477</A></P><P></P><P>7. How can I set the cell color in ALV?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=52107" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=52107</A></P><P></P><P>8. How do I print a logo/graphics in ALV?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=81149" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=81149</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=35498" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=35498</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=5013" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=5013</A></P><P></P><P>9. How do I create and use input-enabled fields in ALV?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=84933" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=84933</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=69878" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=69878</A></P><P></P><P>10. How can I use ALV for reports that are going to be run in background?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=83243" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=83243</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=19224" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=19224</A></P><P></P><P>11. How can I display an icon in ALV? (Common requirement is traffic light icon).</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=79424" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=79424</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=24512" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=24512</A></P><P></P><P>12. How can I display a checkbox in ALV?</P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=88376" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=88376</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=40968" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=40968</A></P><P><A href="http://www.sapfans.com/forums/viewtopic.php?t=6919" target="test_blank">http://www.sapfans.com/forums/viewtopic.php?t=6919</A></P><P></P><P>Go thru these programs they may help u to try on some hands on</P><P></P><P>ALV Demo program</P><P>BCALV_DEMO_HTML</P><P>BCALV_FULLSCREEN_DEMO ALV Demo: Fullscreen Mode</P><P>BCALV_FULLSCREEN_DEMO_CLASSIC ALV demo: Fullscreen mode</P><P>BCALV_GRID_DEMO Simple ALV Control Call Demo Program</P><P>BCALV_TREE_DEMO Demo for ALV tree control</P><P>BCALV_TREE_SIMPLE_DEMO</P><P>BC_ALV_DEMO_HTML_D0100</P><P></P><P>Remote Function Call:</P><P></P><P>RFC is an SAP interface protocol. Based on CPI-C, it considerably simplifies the programming of communication processes between systems.</P><P></P><P>RFCs enable you to call and execute predefined functions in a remote system - or even in the same system.</P><P></P><P>RFCs manage the communication process, parameter transfer and error handling.</P><P></P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/22/042860488911d189490000e829fbbd/frameset.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/22/042860488911d189490000e829fbbd/frameset.htm</A>.</P><P></P><P>ALE/ IDOC</P><P><A href="http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm" target="test_blank">http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm</A></P><P><A href="http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc" target="test_blank">http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc</A></P><P><A href="http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419" target="test_blank">http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419</A></P><P><A href="http://www.netweaverguru.com/EDI/HTML/IDocBook.htm" target="test_blank">http://www.netweaverguru.com/EDI/HTML/IDocBook.htm</A></P><P><A href="http://www.sapgenie.com/sapedi/index.htm" target="test_blank">http://www.sapgenie.com/sapedi/index.htm</A></P><P><A href="http://www.sappoint.com/abap/ale.pdf" target="test_blank">http://www.sappoint.com/abap/ale.pdf</A></P><P><A href="http://www.sappoint.com/abap/ale2.pdf" target="test_blank">http://www.sappoint.com/abap/ale2.pdf</A></P><P><A href="http://www.sapgenie.com/sapedi/idoc_abap.htm" target="test_blank">http://www.sapgenie.com/sapedi/idoc_abap.htm</A></P><P><A href="http://help.sap.com/saphelp_erp2005/helpdata/en/0b/2a60bb507d11d18ee90000e8366fc2/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005/helpdata/en/0b/2a60bb507d11d18ee90000e8366fc2/frameset.htm</A></P><P><A href="http://help.sap.com/saphelp_erp2005/helpdata/en/78/217da751ce11d189570000e829fbbd/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005/helpdata/en/78/217da751ce11d189570000e829fbbd/frameset.htm</A></P><P><A href="http://www.allsaplinks.com/idoc_sample.html" target="test_blank">http://www.allsaplinks.com/idoc_sample.html</A></P><P><A href="http://www.sappoint.com/abap.html" target="test_blank">http://www.sappoint.com/abap.html</A></P><P></P><P><A href="http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm" target="test_blank">http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm</A></P><P><A href="http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc" target="test_blank">http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc</A></P><P><A href="http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419" target="test_blank">http://edocs.bea.com/elink/adapter/r3/userhtm/ale.htm#1008419</A></P><P><A href="http://www.netweaverguru.com/EDI/HTML/IDocBook.htm" target="test_blank">http://www.netweaverguru.com/EDI/HTML/IDocBook.htm</A></P><P><A href="http://www.sapgenie.com/sapedi/index.htm" target="test_blank">http://www.sapgenie.com/sapedi/index.htm</A></P><P><A href="http://www.allsaplinks.com/idoc_sample.html" target="test_blank">http://www.allsaplinks.com/idoc_sample.html</A></P><P></P><P>Refer this</P><P><A href="http://www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_DATADICTIONARY_FAQ.html" target="test_blank">http://www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_DATADICTIONARY_FAQ.html</A></P><P><A href="http://www.saptechnical.com/InterviewQ/interviewQ.htm" target="test_blank">http://www.saptechnical.com/InterviewQ/interviewQ.htm</A></P><P><A href="http://help.sap.com/saphelp_46c/helpdata/en/35/2cd77bd7705394e10000009b387c12/frameset.htm" target="test_blank">http://help.sap.com/saphelp_46c/helpdata/en/35/2cd77bd7705394e10000009b387c12/frameset.htm</A></P><P></P><P><A href="http://www.techinterviews.com/?p=198" target="test_blank">http://www.techinterviews.com/?p=198</A></P><P><A href="http://www.techinterviews.com/?p=326" target="test_blank">http://www.techinterviews.com/?p=326</A></P><P><A href="http://www.sap-img.com/abap/answers-to-some-abap-interview-questions.htm" target="test_blank">http://www.sap-img.com/abap/answers-to-some-abap-interview-questions.htm</A></P><P><A href="http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm" target="test_blank">http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm</A></P><P><A href="http://www.geekinterview.com/Interview-Questions/SAP-R-3/ABAP" target="test_blank">http://www.geekinterview.com/Interview-Questions/SAP-R-3/ABAP</A></P><P><A href="http://sap.ittoolbox.com/documents/popular-q-and-a/abap-sample-interview-questions-3240" target="test_blank">http://sap.ittoolbox.com/documents/popular-q-and-a/abap-sample-interview-questions-3240</A></P><P><A href="http://www.sap-img.com/abap/abap-interview-question.htm" target="test_blank">http://www.sap-img.com/abap/abap-interview-question.htm</A></P><P><A href="http://www.allinterview.com/Interview-Questions/ABAP.html" target="test_blank">http://www.allinterview.com/Interview-Questions/ABAP.html</A> </P><P></P><P>Reward points for useful Answers</P><P>Regards</P><P>Anji</P></BODY></HTML> Mon, 09 Jul 2007 16:38:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513790#M568617 Former Member 2007-07-09T16:38:57Z Re: Left outer join in OPEN SQL https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513791#M568618 <HTML><HEAD></HEAD><BODY><P>Thanks Anji for the useful links. See points.</P><P>Could you please give me answers for my questions? </P><P>Anyone else if you can answer please? Points ill be rewarded.</P><P></P><P>Regards,</P><P>Mau</P></BODY></HTML> Mon, 09 Jul 2007 18:36:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513791#M568618 Former Member 2007-07-09T18:36:58Z Re: Left outer join in OPEN SQL https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513792#M568619 <HTML><HEAD></HEAD><BODY><P>Ans:</P><P></P><P>1.C</P><P>2.A</P><P>3.A</P><P>4.C</P><P>5.B</P><P>6.A</P><P>7.B</P><P>8.A</P><P>9.C</P><P>10.D</P><P>11.ID is mandatory</P><P>12.B</P><P>13.ALL</P><P>14.B,C,E</P><P>15.A</P><P>16.ABDE</P><P>17.C</P><P>18.A</P><P>19.ALL ARE CORRECT</P><P>20.ACD</P><P>21.B</P><P>22.C</P><P>23.CD</P><P>24.AB</P><P>25.B</P><P></P><P>Hey Make your question as simple as possible <SPAN __jive_emoticon_name="happy"></SPAN></P><P></P><P>Cheers,</P><P>Hakim</P></BODY></HTML> Mon, 09 Jul 2007 19:04:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513792#M568619 abdul_hakim 2007-07-09T19:04:58Z Re: Left outer join in OPEN SQL https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513793#M568620 <HTML><HEAD></HEAD><BODY><P>Thanks Hakim. Points awarded.</P></BODY></HTML> Mon, 09 Jul 2007 21:19:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/left-outer-join-in-open-sql/m-p/2513793#M568620 Former Member 2007-07-09T21:19:26Z