topic Re: DB View Problem in Application Development and Automation Discussions

DB View Problem

Former Member — Mon, 01 Oct 2007 03:35:45 GMT

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 — Mon, 01 Oct 2007 03:43:48 GMT

Hi shekar.

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

Solution:

In the Table/Join conditions TAB.

Enter one table name like VBAK.

Use the Relationships 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.

REWARD IF HELPFUL.