DB View Problem

[Former Member]

Hello Guys,

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

The view ignores client-dependency of the base tables

could you explain the view to get the data.

thanks

Shekar

[varma_narayana]

Hi shekar.

1. Not all the base tables are linked with join conditions.

Solution:

<b> In the Table/Join conditions TAB.</b>

Enter one table name like VBAK.

Use the <b>Relationships</b> button to copy the relationships automoatically.

Select the tables VBAP and MSEG from the List of related tables in the popup.

So that the System will automatically copy the Relationships.

2. The view ignores client-dependency of the base tables

This is bcoz the MANDT field is not included as the First field in the view.

<b>REWARD IF HELPFUL.</b>