abapquery的概念以及基本用途

《abapquery的概念以及基本用途》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、ABAPQUERY的概念以及基本用途SummaryThisarticlewillintroduceABAPQUERY,firstwewillintroducetheconceptofQUERYABAPaswe11asthebasicpurpose,thenwewillintroducehowtocreateaBasicList,andthebasicstepstocreateitandhowtouseittogenerateABAPcode・briefintroductionFordevelopersandfunctionalconsuitants,i

2、t'snotABAPQUERYthatwantstoimplementreportsinlesstimethandevelopingcode.Sometimes,weneedtofindsomedatatotestourprogram.Inthiscase,wemightneedtofindthedataweneedfromseveraldifferenttables・Forexample,lookforinvoiceswithaninvoicevaluegreaterthan1000.TherearethreemainstepsincreatingS

3、APQUERY:1)createausergroup2)creatinganinformationset3)createSAPQUERYThetransactioncodescorrespondingtothesethreestepsare:SQ01-SAPQUERYSQ02-InfoSetSQ03-UserGroupNextwewilldescribethestepsinvolvedCreateusergroupThetransactioncodethatcreatestheusergroupisSQ03ClicktheCreatebuttontow

4、ritethedescriptioninformationandclicksave・CreateinformationsetThetransactioncodethatcreatestheinformationsetisSQ02ClickingtheCreatebuttonpopsupaform,describesthedescriptionoftheinputset,specifiestheunderlyingtableVBRKfortheconnection,andthenclicksOKInthenextscreen,youcaninsertan

5、otherconnectiontablebyclickingontheapplicationtoolbarInsertTable・EnterVBRPthroughthepop-upinserttableform・Thedefaultconnectioninformationwillbedisplayed,andyoucansettheconnectionyourselfbyclickingonJoinCondition.Clickbackwardtoappearinthedialogboxforthemaintenanceinformationset:

6、selecttheoptionbuttonforCreateemptyfieldgroups,andclickOKTwoemptyfieldgroupsarecreated・Ontheleftpanel,weseefieldsfromtwotablesofVBRKandVBRP・Wecandragthesefieldsintotwoemptyfieldgroups.ClickthedeleteFieldGroupbuttontodeletetheFieldGroup2thatdoesnotcontainthefield・Clickgeneratetog

7、eneratetheinformationset・ClickbackonthestandardtoolbartoreturntothehomescreenofSQ02.Assigntheinformationsettotheappropriatefunctionbyclickingontheassignedrole/usergroupHouseholds・CreateSAPQUERYThetransactioncodeforcreatingSAPQUERYisSQO1Bydefault,thegroupofusersrecentlyopenedinSQ

8、03willshowup.EnterZXXB_QUERYasthequerynameandcl