DB View Help Required

16 Views

Hello Guys,

I am extracting Data from ECC to BI.

Following the Requirement.

I have MSEG , MKFP , VBAK and VBEP tables data to be extracted.

I am think of creating View for creating Datasource for the extaction. I have linked MKPF and MSEG tables and got the required data.

Now I am trying to Create a View to link between the tables MSEG, VBAK and VBEP tables to get the following info.

The Sales order number in the SO No. field (MSEG-MAT_KDAUF) should be linked to VBAK-LIFSK to get the Header Block information.

The Sales order number in the SO. No. field (MSEG-MAT_KDAUF) and SO Item (MSEG-MAT_KDPOS) should be linked to VBEP-LIFSP to get the item block.

i am getting following errors -

Not all the base tables are linked with join conditions

could you explain the view to get the data. if i need to create 2 view or can i get the data from one view

thanks

Shekar