topic Re: problem on LDB in Application Development and Automation Discussions

problem on LDB

Former Member — Mon, 15 Oct 2007 03:46:27 GMT

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 ..

varma_narayana — Mon, 15 Oct 2007 03:54:44 GMT

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>

Former Member — Mon, 15 Oct 2007 03:59:44 GMT

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