on 09-30-2008 12:47 AM
Hi,
I have a question,
i need to create generic data source on KNVV table, should i used direct table or create the view 1st, if i can use direct table KNVV then please guide me how to create it,.
Thanks
HI
in your case you no need to create the VIEW, directly you can use the table and create the data source, for creating the VIEW you need the two tables for joining these two tables you need the logic also.if you use the view the data source extraction time will increase coz it has to picj the data from two tables based on the logic which you write.
simply create the data source on the TABLE whrn you want to extract the data from only table.
Regards,
chandra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rob,
Since u r using KNVV table it means u r creating Master data source...am I right.
Steps are
Tcode - RSO2
select Master data source
Give Data source name
In next screen
Give description
Select table/view option
Give table name KNVV
save
and generate
select fields for seletion and fields to be hidden.
Regards,
Mahendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ANY comment why we need to create view on table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rob
View:
Data about an application object is often distributed on several tables. By defining a view, you can define an application-dependent view that combines this data. The structure of such a view is defined by specifying the tables and fields used in the view. Fields that are not required can be hidden, thereby minimizing interfaces. A view can be used in ABAP programs for data selection.
A view is nothing but a virtual table which is built on some other tables.
For More info on Views Refer this
http://help.sap.com/saphelp_nw70/helpdata/EN/cf/21ec5d446011d189700000e8322d00/content.htm
Scenario where we use VIEWS in BI:
IF for example we want to retrive 10 fields from 3 different R/3 tables, then instead of creating 3 datasources one on each table we will go for views.
We will create a View on those 3 tables and then create a DS on this view.
We will use this while creating DS as we can create a DS on this view type of table.
So if you need to create your generic DS on KNVV table you can create it directly on the table itself. No need to create views unless u want to hide the fields tat are not required from the KNVV table.
Regards
Gaurav
Hi Rob
As you are using just one table i would suggest you to directly use the table
All you have to do is put your table name in table/view then press save
You will be taken to the next screen
Here chech-uncheck the hide option for each field as per your requirement
If a field is marked hide(checked), it will not be considered in your Data Source.
Why not view?
This is because you unnecessary create one more object which is not very usefukl to you in any prospect be it performance or ease of use.
Hope this helps
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.