Application Development 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: 

Dynamic selection in SAP report

Former Member

‎2015 Dec 23 10:46 AM

0 Kudos
582

Hi ,


S_ALR_87012301 report does not have profit center selection field under dynamic selection.

We have tried below steps to enable the selection field profit center under dynamic selection

  • Copied origin of view as CUS from SAP.
  • Created new function group and assigned (BSEG -PRCTR) and selected preselect check box & assigned corresponding function group as well.

Even though done the above settings unable to view the newly created function group & profit center in dynamic selection.

Also please suggest on how to bring profit center in FS10N, S_ALR_87012284 under dynamic selection

Under node for dynamic selection BSEG is not available( refer attachment)

System status - version SAP ECC 6.0

Preview file
11 KB
3 REPLIES 3

PeterJonker
Active Contributor

‎2015 Dec 23 12:49 PM

0 Kudos
139

Isn't it available in the BSIS dynamic selection (BSIS belongs to the same cluster as BSEG, basically BSIS is a subset of BSEG only containing the entries that are needed in the report),  although I must admit that I am not sure since I do not have the report in my system. But since BSIS is available for dynamic selections, my guess is that you only need this tabel (BSIS) and no need for BSEG,.

Former Member
In response to PeterJonker

‎2015 Dec 23 1:16 PM

0 Kudos
139
once the document got cleared document moves to BSAS

then how would report fetch the data

??????

raymond_giuseppi
Active Contributor
In response to PeterJonker

‎2015 Dec 23 2:27 PM

0 Kudos
139

Hint: The report RFSUSA00 behind transaction use logical database FBS, so read both BSIS and BSAS in same node BSIS.

> use SE36 to check

AFAIK every transaction you reference is a balance report, not a booking report, even if it reads item to adjust balance or display detail of analyzed period, it first read an end-of-month record from another table for performance, so they can only generate one line per account and Business Area

> execute a SQL trace, check primary keys of GLT0

Even if you were able to filter on profit center, then the detail sum may differ from the displayed opening/closing balance difference, so may baffle inexperienced users.

Better build your own report, but without an equivalent of GLT0 you will be required to read item since creation of company (even archived records ?) or consider usage of BI/BW.

Regards,

Raymond