cancel
Showing results for 
Search instead for 
Did you mean: 

New data source on MSEG, MKPF, PA0002, PA0001, T503T

Former Member
0 Kudos

Hi all,

I have a requirement where I have to pull data from MSEG, MKPF, PA0002, PA0001, T503T tables in o BI.

I need the following fields from

MKPF:--

CPUDT, CPUTM, FRBNR, USNAM

MSEG:--

BWART, LGNUM, LGTYP, MBLNR

PA0001:--

BEGDA, ENDDA, PERSK

PA0002:--

NACHN, PERNR, RUFNM, VORNA

T503T:--

PTEXT

I am planning to create a view based on these tables.

But I am not sure whether it is the best approach or not.

Can you guys help me in coming out with the best option.

I did do some research before coming up with a view but I am new to BI so wanted to see what the Guru's suggest.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

The view is one of the solutions here. But you have to be very careful with the join conditions, look for deltas and also look at your key values here.

A more robust solution might be to go with a function module rather than view. Also, if you are doing any data manipulations or calculations for this particular datasource, a function module would serve your needs.

Cheers,

Kedar