10-15-2007 4:46 AM
Hai Gurus,
I had a problem while checking an Logical DataBase Program.
I have created One Structure(SE36) name ZCVTEST and I have taken two Nodes
First One is LFA1 and brach node is LFB1.
and i have write in selctions :
SELECT * FROM LFA1
WHERE LIFNR IN SLIFNR.
and my problem is while checking it will shown an error.
The databse program SAPDBZCVTEST must have type '1' in the attributes.
why this happen .
and i wants to execute simple DataBaseProgram using Two nodes Root Node is LFA1 and branch node is LFB1.
I wants to the steps during Structure, Selection and DataBase program Attributes in SE36.
Please Help, Me ..
10-15-2007 4:54 AM
Hi Reddy..
We cannot Test/Execute the LDB in SE36.
First activate ur LDB in SE36.
Then
In SE38 create a new Report.
In the Attributes of the Report Assign the LDB.
In the Source code of the Report :
<b>
TABLES : LFA1, LFB1.
Get LFA1.
WRITE 😕 LFA1-LIFNR,
LFA1-NAME.
Get LFB1.
WRITE 😕 LFb1-LIFNR,
LFb1-BUKRS.</b>
<b>reward if Helpful.</b>
10-15-2007 4:59 AM
it cant activate in SE36, It will shows an error message while Checking in SE36
The database program SAPDBZCVTEST must have been type '1' in the attributes.
How can I activate in SE36 to avoid this error message.
please help me