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

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