topic Re: creating a view in Application Development and Automation Discussions

creating a view

Former Member — Wed, 18 Feb 2009 09:57:01 GMT

Hello Dear Abap Experts,

the requirement is to create a view and join both tables. Please help me to create this view.

Table First has already some data in it but the Table Second is empty.

Thanks

Sas

Table First:

MANDT	MANDT	CLNT	3
SPARTE	CHAR2	CHAR	2
ZSDGU	ZGU	CHAR	20
HEADER_ID	GUID_32	CHAR	32

Table Second:

MANDT	MANDT	CLNT	3	0
HEADER_ID	GUID_32	CHAR	32	0
MATNR	MATNR	CHAR	18	0
PARTNR	NUMC2	NUMC	2	0
PHASEN	ZPHASEN	NUMC	2	0
CHANGENR	NUMC4	NUMC	4	0
TEMPLATEID	GUID_32	CHAR	32	0
DESC_MC	CHAR40	CHAR	40	0
DOKNR	DOKNR	CHAR	25	0
DOKAR	DOKAR	CHAR	3	0
SKETCH_PATH	FILEP	CHAR	255	0
STATUS	CHAR2	CHAR	2	0

Re: creating a view

Former Member — Wed, 18 Feb 2009 09:59:08 GMT

you can create a VIEW in SE11.

there in you can make it of 4 type of view depending on the requirement

use link for more detail

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

regards

Edited by: Mohit Kumar on Feb 18, 2009 10:59 AM

Re: creating a view

former_member242255 — Wed, 18 Feb 2009 10:03:00 GMT

you can create the view in SE11 and you need to give the two tables and also the fields that are to be joined in the "Join Conditions" tab and the tables in the TABLES tab..

There should not be any problem even is the 1st table is having some data or the 2nd table is empty.

Re: creating a view

Former Member — Wed, 18 Feb 2009 10:04:38 GMT

hi,

you can create view from se11 t-code.

in se11 ,Select View radio-button.

Click Create button.

Give the tables and table fields that you want to join ad relationship between table..( Join with primary keys) in the subsequent screens.

Save the technical attributes and then activate the table definition.

Refer this link for more info:

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

thanks

Re: creating a view

faisalatsap — Wed, 18 Feb 2009 10:06:53 GMT

Hi,

To Create View Please Follow the following Steps,

--> T-Code SE11

--> Enter the View Name in the 2nd Input Field and Press Create Button.

--> in Short Description Give Description.

~~> In the TAB~~> Table/Join Conditions Give all the table name in the Table Sub Menu and Join condition in the Join Conditions Sub Menu.

--> Give the Field Names you want to View in the View Fids Tab.

--> Selection Conditions in the Selection Condition Tab

--> if you want this view Read only or Read and Change you can Select from Maint Status.

Hope above will help you to solve out your problem.

Please Reply if any Problem,

Kind Regards,

Faisal