cancel
Showing results for 
Search instead for 
Did you mean: 

View Creation.

Former Member
0 Kudos
43

Dear Friends,

I am first time doing Generic Extraction in BW. Could you please clarify the following doubts in oder to create a view on two tables.

<i><b>1:</b> In a table some of the fields are assigned with check tables.. what is check tables...?

<b>2:</b> I have tables, Tab1 and Tab2. The field in Tab1 is not exist in Tab2 but I need information of this field in reporting. Is it necessary that all field should be same in both the tables then only view is possible?

<b>3:</b> There are some Quantitative and Currency fields( Key figures in BW) in tables and their units are in other tables. Do we need to join those tables as well with the Tab1 and Tab2 tables..?

<b>4:</b> What are the conditions that are to be fulfilled to create a view.

<b>5:</b> Provide me the comple steps if possible</i>.

Thanks in advance for your answers...

Sudga.....

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi check the below links

http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm

/people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

Answers (1)

Answers (1)

RenjithKumar
Advisor
Advisor
0 Kudos

Hi

<b>Check Table :</b>

Before saving a data into the table , The table checks for the existance

of the value in other table , If that value is there in that table only

then it will save , Other wise you cannot save . Thus the table that is checked

before saving data is check table .

Eg: VBAK has VBELN ( SD Doc ) There are many SD NOs

VBAP has VBELN ( SD Doc )

POSNR ( Item )

Before entering any value for VBELN in VBAK you must have same

value in VBELN of VBAK table .

<b>Condition</b>

So if you are creating view here the condition will be

VBAK-VBELN = VBAP-VBELN

Step By Step Doc

<a href="http://sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d3219af2-0c01-0010-71ac-dbb4356cf4bf">http://sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d3219af2-0c01-0010-71ac-dbb4356cf4bf</a>

Renjith Kumar