topic Re: Problem in data selection with Logical database in Application Development and Automation Discussions

Problem in data selection with Logical database

former_member421809 — Wed, 02 Aug 2017 16:10:22 GMT

Hello All ,

I try to get some posts in BSEG with BKPF Key
GET BSIK
GET BKPF
GET BSEG
append gs_bseg to gt_bseg

i found just the first post for each header bkpf data
so just bseg-buzei = 1

in my case in bseg table i have three posts for a header data

Please , i'm beginner in logical database
can you please provide me an answer to my question

Thanks in advance,
Rachid

Re: Problem in data selection with Logical database

retired_member — Wed, 02 Aug 2017 16:32:11 GMT

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenldb.htm

Re: Problem in data selection with Logical database

former_member421809 — Wed, 02 Aug 2017 16:42:27 GMT

Thanks Horst ,
but i didn't found what i need there , i'm asking if i can get all posts for a bkpf header ,because here it retrieves just the first post for each header data

Re: Problem in data selection with Logical database

Jelena_Perfiljeva — Wed, 02 Aug 2017 19:38:29 GMT

Why are you using a logical database? If you have the document number then just do SELECT yourself. It's not clear what you're doing or trying to achieve though.

Re: Problem in data selection with Logical database

RaymondGiuseppi — Thu, 03 Aug 2017 05:51:38 GMT

Your first GET is GET BSIK so I suppose your are using logical database KDF (?) which only contains the record with vendor account in BSEG node, so usually only one per document, except if you add GET GSEG for offset accounts. If you want every item you must append BSEG and GSEG records to rebuild the full document.

Hint: As logical database are now obsolete (and rarely used outside of HR) why wouldn't you build you report with direct access to database table so BSIK and BSAK -> BKPF -> BSEG every records.

NB: In cas of doubt, build a simple test query/dataset with SQ01/SQ02 on the logical database. Or look for statements PUT bseg/gseg in the logical database program. (You should find a SELECT SINGLE with equal BUZEI and a SELECT INTO TABLE with non-equal BUZEI)

Re: Problem in data selection with Logical database

retired_member — Thu, 03 Aug 2017 06:00:45 GMT

The idea is, if you want to use obsolete Logical Databases, you have to learn how they work and with that knowledge analyze your problem, e.g. by debugging the program flow.

Re: Problem in data selection with Logical database

former_member421809 — Thu, 03 Aug 2017 08:22:51 GMT

Thanks Raymond
Yes , i'm working with 'KDF' as logical database

I add a GET GSEG to retrieve other posts
That's what i want to achieve