topic Programming Using Queries vs. Loops (and traversing multiple tables) in Application Development and Automation Discussions

Programming Using Queries vs. Loops (and traversing multiple tables)

Former Member — Wed, 02 Sep 2009 02:57:22 GMT

I had a very generic question regarding programming in SAP - ABAP. I notice that our developers seem to struggle while creating complex looping and traversing of data (based on how complex some of the SAP tables get).

Especially for Forms (where some complex summarization is required), why aren't they utilizing Views or Queries to link the data???

Thanks for your response, its frustraiting as a former developer in VB / SQL to see the structured development I am seeing. (maybe I just am not up to speed in SAP land!)

Re: Programming Using Queries vs. Loops (and traversing multiple tables)

Former Member — Wed, 02 Sep 2009 03:15:30 GMT

we have a concept of Logical databases , through which all inked tables are set up in easy to access fashion , using GET <table> and GET LATE events.

These are pure report like statements , however its been converted to FM's i..e more modularized with no performance differences.

Your own logical databases can be created aswell, however performance tuning is a advanced level concept in SAP land.

Re: Programming Using Queries vs. Loops (and traversing multiple tables)

Former Member — Wed, 02 Sep 2009 03:30:34 GMT

Another part of the frustration is that assumptions get made.......So as an example with Sales and Distribution:

You have a Consolidate Invoice (Invoice List), where you need to Summerize by Master Contract. The Developer was Going from Invoice to Sub-Contract and Summerizing by Master Contract. When he did this he lost the integrity of what was Invoiced and therefore picked up all items that exist in the contract.

Bottom line I think that I have to ensure the development retains the relational integrity regardless of the approach..!