Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Changing logical database DDF select order, and restricting the selection

Former Member

‎2007 Feb 09 2:07 AM

0 Likes
796

HI all,

I am using logical database DDF for a report. I would like to do two things:

1) Change the sort order of records so that when my GET statements are processing, they are bringing the data back in sorted by a field of my choice (such as KNA1-REGIO, or KNB1-BUSAB).

2) I would like to add KNA1-REGIO and KNB1-BUSAB as fields for selection during the LDB's initial selection, instead of filtering out records during the GET statements.

FYI, I did find the field DD_BUSAB in the LDB selection structure which I can use to restrict KNB1-BUSAB. I am still not sure how to restrict by KNA1-REGIO though.

Any thoughts?

Thanks so much,

L

HI all,

I am using logical database DDF for a report. I would like to do two things:

1) Change the sort order of records so that when my GET statements are processing, they are bringing the data back in sorted by a field of my choice (such as KNA1-REGIO, or KNB1-BUSAB).

2) I would like to add KNA1-REGIO and KNB1-BUSAB as fields for selection during the LDB's initial selection, instead of filtering out records during the GET statements.

FYI, I did find the field DD_BUSAB in the LDB selection structure which I can use to restrict KNB1-BUSAB. I am still not sure how to restrict by KNA1-REGIO though.

Any thoughts?

Thanks so much,

L

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Feb 09 3:24 AM

0 Likes
545

for selecting the data as per KNA1-REGIO and KNB1-BUSAB you can use dynamic selection of ldb. in the selection screen after execute button there is dynamic selection button is there you can click there and add your choice in the selection screen.

regards

shiba dutta

Read only

Former Member
In response to Former Member

‎2007 Feb 09 5:42 PM

0 Likes
545

Thanks for the reply Shiba. For that particular problem, the business wants to not have to use the dynamic selection, and just have KNA1-REGIO and KNB1-BUSAB as regular select options. Like I said as well, I did find DD_BUSAB which I can use for KNB1-BUSAB, but KNA1-REGIO is still a problem.

Right now I just use a CHECK statement and filter kna1-regio after the GET kna1 statement.

Thanks again,

L