Problem in the backend trigger.

[Former Member]

Hi all,

I am trying to push data from the backend into the middle ware using the function "SMMW_BE_CALL_DELTABO"

I have written a report in the backend which updates my table and then the DELTABO function is called to update this changes to the middleware. Here are my codings

TABLES: ZRECGEN_TBL.
DATA: WA_RECGEN TYPE ZRECGEN_TBL OCCURS 0 WITH HEADER LINE.
DATA: BEGIN OF ST_BEKEYS OCCURS 0,
 R3KEY TYPE c LENGTH 255,
MSGFN TYPE c LENGTH 3,
END OF ST_BEKEYS.
PARAMETERS : client like ZRECGEN_TBL-MANDT,
              SWCV LIKE ZRECGEN_TBL-BASIS_SWCV
             NAME LIKE ZRECGEN_TBL-NAME ,
             USER LIKE ZRECGEN_TBL-CREATED_BY,
             ENABLED LIKE ZRECGEN_TBL-ENABLED,
             CITY LIKE ZRECGEN_TBL-CITY.
WA_RECGEN-MANDT = CLIENT.
WA_RECGEN-BASIS_SWCV = SWCV.
WA_RECGEN-NAME = NAME.
WA_RECGEN-CREATED_BY = USER.
WA_RECGEN-ENABLED = ENABLED.
WA_RECGEN-CITY = CITY.
INSERT INTO ZRECGEN_TBL VALUES WA_RECGEN.
COMMIT WORK.
IF SY-SUBRC = 0.
WRITE:/ 'SUCCESSFULY UPDATED'.
ENDIF.
ST_BEKEYS-R3KEY = 'BASIS_SWCV'.
ST_BEKEYS-MSGFN ='009'.
APPEND ST_BEKEYS.
CALL FUNCTION 'SMMW_BE_CALL_DELTABO' DESTINATION 'MIACLNT100'
EXPORTING
BEBO_NAME =  'BE_TRGR'
TABLES
R3KEYS  =  ST_BEKEYS. 

But there is no updation in the middleware when I execute this report.

Someone please give me a solution.

Thanks,

Krutheeka.

Edited by: krutheeka on Apr 14, 2011 2:07 PM

[sivasatyaprasad_yerra · Accepted solution]

ST_BEKEYS should contain backend key value.

Is BASIS_SWCV the key value in Backend table?

ST_BEKEYS-R3KEY = 'BASIS_SWCV'.

Regards,

Siva.

[Former Member · Accepted solution]

Hi Siva,

Yes "BASIS_SWCV" is the key field in the backend.

Krutheeka.

[sivasatyaprasad_yerra · Accepted solution]

Sorry. You didn't get my question.

Is this the record value in table?

[Former Member · Accepted solution]

Sorry Siva I am not able to get your question.

Anyway I will tell you wat I have done.

I have a table in the backend where I have the fields BASIS_SWCV,NAME and USER. Here the Field BASIS_SWCV is the key field, It is the name of the field not the value.

[sivasatyaprasad_yerra · Accepted solution]

You need to provide the exact value of the record when you call this function module.

[Former Member · Accepted solution]

you mean that I shud give the value like "ZRECGEN_TBL-BASIS_SWVC"...

How can I provide the Exact value?

Please explain to me further as I am a beginner in this.

[sivasatyaprasad_yerra · Accepted solution]

Let's suppose Table has 10 records with actual key values (KEY1, KEY2, KEY3 etc.,)

now your code should be like this.

loop at internal table with records.

ST_BEKEYS-R3KEY = record key value from workarea of internal table.

ST_BEKEYS-MSGFN ='009'.

APPEND ST_BEKEYS.

endloop

[Former Member · Accepted solution]

Thanks Siva I understand now.

i will incorporate that in my code and check if it is working, If not get back with further questions

[Former Member · Accepted solution]

Hi,

I rewrote the code as u said

LOOP AT IT_BACKEND_TRGR.
ST_BEKEYS-R3KEY = IT_BACKEND_TRGR-BASIS_SWCV.
ST_BEKEYS-MSGFN = '009'.
APPEND ST_BEKEYS.
ENDLOOP.

But in the middleware I am only getting the key value records the other field's values and not coming in their columns are blank.

Please give me a solution.

Krutheeka.

[sivasatyaprasad_yerra · Accepted solution]

Does your GET DETAIL function module returns all these values?

[Former Member · Accepted solution]

Hi Siva,

I am using only a GET LIST function module. Yes I checked it and it is returning all these values.

Regards,

Krutheeka.

[Former Member · Accepted solution]

Hi

Please tell me where might be the problem. I have been trying to figure out but I am stuck with this as I am a beginner.

Thanks,

Krutheeka.