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