topic Re: database views in Application Development and Automation Discussions

database views

Former Member — Fri, 31 Oct 2008 05:59:06 GMT

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.

Re: database views

Former Member — Fri, 31 Oct 2008 06:05:38 GMT

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

Re: database views

Former Member — Fri, 31 Oct 2008 06:11:56 GMT

Hi Bharath,

Check this link:

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

Regards,

Chandra Sekhar

Re: database views

Former Member — Fri, 31 Oct 2008 06:18:24 GMT

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.

Re: database views

Former Member — Fri, 31 Oct 2008 06:31:33 GMT

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.

Re: database views

Former Member — Fri, 31 Oct 2008 06:32:49 GMT

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

Re: database views

Former Member — Mon, 03 Nov 2008 11:24:18 GMT

Hi,

for KNA1 & KNVV...


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

for KNA1 & ADRC...


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

Arunima