Skip to Content
0
Former Member
Feb 18, 2009 at 09:57 AM

creating a view

71 Views

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