database views

[Former Member]

Hi all,

I am a fresher to abap.

The following is my question regarding database views,

Create a database view, involving tables KNA1, ADRC, KNVV.

These are all customer master tables and are related through fields MANDT (Client), KUNNR (Customer Number) & ADRNR (Address Number).

To the above questions there are some fields to be viewed which i have entered in the view fields column.

For this above question table/join conditions and selection conditions, please guide me.

[Former Member]

Hi Bharath,

Welcome to SCN.

Check the document for your requirment

http://help.sap.com/saphelp_nw04/helpdata/EN/cf/21ed06446011d189700000e8322d00/content.htm

Regards,

Anirban

[Former Member]

Hi Anirban,

I have checked that weblink previously before posting the thread, but i was not clear with the select conditions.

ADRC-ADDRNUMBER=KNA1-MANDT,

KNVV-KDGRP=KNA1-MANDT.

This is what i have given in the table/join conditions, is this correct for the question i have posted.

Please let me know what is to be entered in select conditions.

Regards,

Bharath kumar P.G

[Former Member]

Hi Bharath,

Check this link:

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

Regards,

Chandra Sekhar

[Former Member]

Hi Chandrashekar,

I have checked that weblink previously before posting the thread, but i was not clear with the select conditions.

ADRC-ADDRNUMBER=KNA1-MANDT,

KNVV-KDGRP=KNA1-MANDT.

This is what i have given in the table/join conditions, is this correct for the question i have posted.

Please let me know what is to be entered in select conditions.

[Former Member]

Hi Anirban,

I have checked that weblink previously before posting the thread, but i was not clear with the select conditions.

ADRC-ADDRNUMBER=KNA1-MANDT,

KNVV-KDGRP=KNA1-MANDT.

This is what i have given in the table/join conditions, is this correct for the question i have posted.

Please let me know what is to be entered in select conditions.

[Former Member]

Hi,

for KNA1 & KNVV...

kna1-mandt = knvv-mandt.
kna1-kunnr = knvv-kunnr.

for KNA1 & ADRC...

kna1-mandt = adrc-mandt.
kna1-adrnr = adrc-addrnumber.

Arunima