topic Re: sql statments with constats in Application Development and Automation Discussions

sql statments with constats

Former Member — Thu, 17 Feb 2005 12:42:12 GMT

Hi,

I want to fill an internal table (2 fields) and a constat value ('CONFIRMED') to every line.

Below gives me an error.

Any pointers ?

select

X_EKKO~EBELN

'CONFIRMED'

from EKKO as X_EKKO

inner join LFA1 as X_LFA1 on X_LFA1_{LIFNR = X_EKKO}LIFNR

inner join EKPO as X_EKPO on X_EKPO_{EBELN = X_EKKO}EBELN

inner join EKES as X_EKES on X_EKES_{EBELN = X_EKPO}EBELN AND X_EKES_{EBELP = X_EKPO}EBELP

into table i_MasterDataConf

where

(where_clause)

AND X_EKES~EINDT > l_enddate2.

//Martin

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 12:52:12 GMT

Hello,

First of all you can select all the data from the transparent table into IntTab.

Then you can fill the constant value by LOOP ... MODIFY InTab. ... ENDLOOP.

Regards, Murugesh AS

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 13:02:07 GMT

Hello Martin,

You cannot use the literal 'CONFIRMED' in the SELECT statement !! The SELECT statement allows you to only select the data from the database.

In your code, use the addition INTO CORRESPONDING FIELDS OF i_MasterDataConf.

Then fill the internal table with the value 'CONFIRMED' in the second field of all rows using the statement

MODIFY ITAB FROM ITAB TRANSPORTING <NAME OF THE SECOND FIELD> WHERE <SECOND FIELD> EQ SPACE.

Regards,

Anand Mandalika.

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 13:21:04 GMT

I read the help section but did not understand the Mass Update stuff:

I tried:

MODIFY i_MasterDataConf FROM i_MasterDataConf TRANSPORTING 'CONFIRMED' WHERE X_STATUS EQ SPACE.

//Martin

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 13:26:09 GMT

I assume a particular field of the internal table i_masterdataconf should have the value 'CONFIRMED'.

So code can be :


i_masterdataconf-<i>fieldname</i> = '<b>CONFIRMED</b>'.
MODIFY i_MasterDataConf FROM i_MasterDataConf TRANSPORTING <i>fieldname</i> WHERE X_STATUS EQ SPACE.

if sy-subrc <> 0.
endif.

Regards,

Subramanian V.

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 13:37:48 GMT

oppss... I'm inside BSP. Sorry.

Maybe we can solve this anyway.

Type Def:

types: begin of t_MasterDataStruct,

X_EKKO_EBELN type EKKO-EBELN,

X_STATUS type string,

end of t_MasterDataStruct.

types: tt_MasterDataStruct type table of t_MasterDataStruct.

"i_MasterDataConf is of the type tt_MasterDataStruct"

i_MasterDataConf-X_STATUS = 'CONFIRMED'.

MODIFY i_MasterDataConf FROM i_MasterDataConf TRANSPORTING X_STATUS.

Error:

"I_MASTERDATACONF" is a table without a header line and therefore has no component called "X_STATUS".

//Martin

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 13:44:15 GMT

Hi,

Some minor modifications, look at bold statements:

DATA: wa_t_MasterDataStruct TYPE LINE OF tt_MasterDataStruct .

> "i_MasterDataConf is of the type

> tt_MasterDataStruct"

> wa_t_MasterDataConf-X_STATUS = 'CONFIRMED'.

> MODIFY i_MasterDataConf FROM wa_t_MasterDataConf

> TRANSPORTING X_STATUS.

>

Regards

Message was edited by: Shehryar Khan

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 14:01:09 GMT

Getting there...

I got an error (Internal server error.)

It doesn't like the Modify statement.

data: wa_t_MasterDataStruct TYPE LINE OF tt_MasterDataStruct .

wa_t_MasterDataStruct-X_STATUS = 'CONFIRMED'.

MODIFY i_MasterDataConf FROM wa_t_MasterDataStruct TRANSPORTING X_STATUS.

//MA

Re: sql statments with constats

Former Member — Thu, 17 Feb 2005 14:34:33 GMT

Forgot the where clause ???

Regards,

Subramanian V.