Issue in Customer Exit

[Former Member]

HI all,

I am BI Consultant..

I need to write a code for a small requirement..

We have enahnced a data source with a new field ZZSRVCLEN. Following code has been written to populate the field.

TABLES:PA0041,PA9211.

DATA: LT_DTF LIKE ZOXHRD0040 OCCURS 0 WITH HEADER LINE.

CASE I_DATASOURCE.

WHEN 'ZDSI_PA_NS'.

LOOP AT c_t_data into LT_DTF.

L_TABIX = SY-TABIX.

SELECT PA0041_{DAR01 PA9211}LSTDTWRK FROM PA0041

INNER JOIN PA9211 ON PA0041-PERNR = PA9211-PERNR WHERE PA0041-DAR01 = '01'INTO CORRESPONDING FIELDS OF TABLE LT_DTF.

LT_DTF-ZZSRVCLEN = LT_DTF-LSTDTWRK - LT_DTF-DAR01/365.

MODIFY ZDSI_PA_NS FROM LT_DTF INDEX L_TABIX.

It throws an errror as below:

Description

Include ZXRSAU01

Field "PA0041-PERNR" unknown

Please advice

Regards,

Harika.

[Former Member]

HI all,

I am BI Consultant..

I need to write a code for a small requirement..

We have enahnced a data source with a new field ZZSRVCLEN. Following code has been written to populate the field.

TABLES:PA0041,PA9211.

DATA: LT_DTF LIKE ZOXHRD0040 OCCURS 0 WITH HEADER LINE.

CASE I_DATASOURCE.

WHEN 'ZDSI_PA_NS'.

LOOP AT c_t_data into LT_DTF.

L_TABIX = SY-TABIX.

SELECT PA0041_{DAR01 PA9211}LSTDTWRK FROM PA0041

INNER JOIN PA9211 ON PA0041-PERNR = PA9211-PERNR WHERE PA0041-DAR01 = '01'INTO CORRESPONDING FIELDS OF TABLE LT_DTF.

LT_DTF-ZZSRVCLEN = LT_DTF-LSTDTWRK - LT_DTF-DAR01/365.

MODIFY ZDSI_PA_NS FROM LT_DTF INDEX L_TABIX.

It throws an errror as below:

Description

Include ZXRSAU01

Field "PA0041-PERNR" unknown

Please advice

Regards,

Harika.

[Former Member]

hi

when you use inner join you should use "PA0041~PERNR" instead of "PA0041-PERNR"

mean use '~' in place of '-'

Edited by: mayank jain on Jun 11, 2009 12:03 PM

[Former Member]

Yes,

Mayank is right thats the mistake I can see in your code.

Regards,

Murthy.

[Former Member]

Hi Harika,

In following select statement,

SELECT PA0041_{DAR01 PA9211}LSTDTWRK FROM PA0041

INNER JOIN PA9211 ON PA0041-PERNR = PA9211-PERNR WHERE PA0041-DAR01 = '01'INTO CORRESPONDING FIELDS OF TABLE LT_DTF.

Replace 'PA0041-PERNR' by 'PA0041_{PERNR' and 'PA9211-PERNR' and 'PA9211}PERNR'

Thanks,

Rakesh.

[Former Member]

Hi,

Could you pls check the table exist or active in the database table PA9211.

Regards

Thiru

[Former Member]

Harika,

try,

SELECT PA0041~DAR01

PA9211~LSTDTWRK

INTO CORRESPONDING FIELDS OF TABLE LT_DTF

FROM PA0041 INNER JOIN PA9211

ON PA0041_{PERNR = PA9211}PERNR

WHERE PA0041~DAR01 = '01'.

-Anu