Create a Logical Database Based on Mseg and Bseg

[Former Member]

Hi,

how can i create a Logical database using bkpf,bseg,mkpf,mseg. i need to know , which table is a root node ?

could any one help me?

Thanks

[Former Member]

Hi,

Please got through the link where you can find how create or modify logical database.

http://www.datamanagementgroup.com/Resources/Articles/Article_1005_2.asp

thanks,

Pramod

[Former Member]

hi all,

thanks for your reply.

my recuirement is , to create a logical database based on mseg,bseg,bkpf and mkpf. my selection is based on

Gl account no and Posting date(grn date). my doubt is, which table to be root node of the database.

i am already trying bmm ldb. so apart from BMM ldb, is there any logical database is avilable? otherwise plz tell me , which table is suitable for root node of bseg,mseg,bkpf,mkpf tables?

[Former Member]

Hi neptune,

1. Gl account no and Posting date(grn date).

For this puropse ur root node

should be

MKPF

2. The reason is :

ur requirement seems to trace

something from GRN to Fi document.

Moreover, in usual businesl logic,

GRN Is posted FIRST, then A/c document

is generated.

regards,

amit m.

[Former Member]

hi Amit,

thanks for your reply.

if the root node is mkpf, then how can i construct

the stucture using bseg,mseg,bkpf?

[Former Member]

Hi again,

1. Looking to the business flow and fields in MSEG,

i would recommend

MKPF--> MSEG ---> BKPF --> BSEG

2. Because MSEG contains the fields

BELNR - Accounting Document Number

BUZEI - Number of Line Item Within Accounting Document

Which will CORRELATE with accounting documents

and hence your additional field of GL Account Number.

regards,

amit m.

[Former Member]

Hi Amit,

While I am Creating the Logical Database by selection MKPF as root node, i have one problem.

my selection-screen is,

Plant Bseg-werks,

G/Laccount Bseg-Hkont,

Fin year bseg-gjahr,

Grn Date Bkpf-Budat,

Vendor No Bseg-lifnr,

Po Bseg-ebeln,

MatNr Bseg-matnr.

My LDB structure is

MKPF

-

---

Mseg

-

---

BKPF

-

---

Bseg.

My Doubt is, how can I access the glaccount details from bseg and How can i fetch the data from Mseg and Mkpf

(Grn details) .

If you give the Source code it is very useful to me.

Thanks,

Neptune.M

[Former Member]

Hi amit,

in Above Message, my LDB structure is also changed because of alignment problem.

My LDB Structure is,

MKPF>Mseg>BKPF--->Bseg

Thanks,

Neptune

[Former Member]

hi,

how can i access the glaccounts details from bseg and

grn details from mseg & mkpf?

i create a Logical Database as

mkpf>mseg>bkpf-->Bseg.

Based on Bseg-hkont and Mkpf-budat ,

how can i fetch the data?

could any one send this source code then, it is very useful to me.

Thanks.

Neptune.M

[RichHeilman]

Just use the one that is already there. BMM

Regards,

Rich Heilman

[Former Member]

hi,

thanks for your reply. in BMM selection is based on Mara (Material Number) . but i need the selection based on glaccount number (bseg-hkont and bkpf-budat).

[venkata_ramisetti]

HI ,

Still you can use BMM and the data will be filtered based on the GL a/c.

tHANKS,

Ramakrishna

[Former Member]

Whether you use SQL or a logical database, you still need to use an index. BSEG isn't indexed on hkont, so even if you do use it as a filter, it'll be slow. A better cholce would be BSIS and BSAS.

Rob