Enhancing Dynamic selections

[Former Member]

Hi,

I need to add field BKPF-USNAM in the dynamic selections of report FBL5N.

please let me know how to do that.

Thanks

[Former Member]

Is it not already there?

Rob

[Former Member]

No,

Its not there.

Thanks

[Former Member]

I need to add in the Documents folder of Dynamic selections,

I need to make it appear on the screen, I know in the LDB selections,

there is field selection for BKPF table, I can see field Entry date appear on the dynamic selections, I dont know how to make appear other fields from BKPF table.

Thanks

[Former Member]

can anyone let me know

Thanks

[Former Member]

FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 2:30 PM Reply E-mail this post

I am trying to insert "Profit center" from BSEG table of Logical database DDF into the dynamic selection screen of FBL5N.

Procedure I followed:

Program -> Attributes -> Logical database -> Extras -> Selection views.

Interestingly when I add "Profit center" from BSID table instead of BSEG, it appears on dynamic selection screen. But this is not working for BSEG. I have no clue why this is so? If someone can help me in this regard, that would be great.

P.S: I can not insert Profit center from BSID table as BSEG contains profit center values and BSID is not storing the same info.

Saquib Khan

Posts: 1,241

Questions: 32

Forum Points: 2,030

Registered: 1/31/06

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 2:40 PM Reply E-mail this post

Answer is BESG is a cluster table ..!!!

Checkout other table has PRCTR

BSAD

BSAK

BSAS

BSID

BSIK

BSIS

Thanks

SK

Rob Burbank

Posts: 2,825

Questions: 2

Forum Points: 3,430

Registered: 5/16/05

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 2:45 PM Reply E-mail this post

I'm a little surprised that BSID has different data than BSEG. As far as I know, they should have the same data for fields that are included in both tables. Could you give an example of where they're different?

Rob

Phani

Posts: 38

Questions: 4

Forum Points: 24

Registered: 8/2/04

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 3:02 PM Reply E-mail this post

Rob,

Below is the BSEG contents:

Company code Document Number Customer Profit Center

1000 1800001111 0000100006

1000 1800001111 0000000401

BSID contents:

Company code Customer Document Number Profit Center

1000 0000100006 1800001111

As BSID stores customer info, I believe only line item that has customer info is stored here.

I guess, that is the reason.

I will try the option told by prev post. Will keep you guys posted.

Thanks,

Phani

Phani

Posts: 38

Questions: 4

Forum Points: 24

Registered: 8/2/04

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 3:03 PM Reply E-mail this post

I think,I did not copy properly the table contents. 2nd record of BSEG has no customer and 1st record has no profit center.

Rob Burbank

Posts: 2,825

Questions: 2

Forum Points: 3,430

Registered: 5/16/05

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 3:13 PM Reply E-mail this post

I meant that I'd like to see an entry in BSEG that has a profit center and the corresponding entry in BSID (same company code, document number, fiscal year and line item number).

Rob

Phani

Posts: 38

Questions: 4

Forum Points: 24

Registered: 8/2/04

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 3:26 PM Reply E-mail this post

Yes Rob.... the entry in BSEG that has profit center has no customer value stored and hence no corresponding entry in BSID.

Rob Burbank

Posts: 2,825

Questions: 2

Forum Points: 3,430

Registered: 5/16/05

Re: FBL5N - Logical databases - Dyanamic selection screen fields

Posted: May 25, 2006 8:04 PM Reply E-mail this post

So, if you try to get the profit center from BSEG, it won't be there either. It will likely be on one or more of the offsetting entries and therefore not available to the logical database and therefore this program.

Rob