topic Re: select in Application Development and Automation Discussions

select

Former Member — Tue, 13 Nov 2007 13:18:32 GMT

Hi gurus,

I just want to ask on whats the purpose of .......RBELBIND = dc_hsemod...........

in this code??

thanks very much,

gerald

Select Single XKBELBEZ From TIV3A Into i_report-hsemod

Where SPRAS = 'E' and

RBELBIND = dc_hsemod.

Former Member — Tue, 13 Nov 2007 13:20:26 GMT

Hi Jose,

RBELBIND is the field in table XKBELBEZ, it is being copmared with dc_hsemod value in the where clause of the select query.

reward if helps,

Satish

Former Member — Tue, 13 Nov 2007 13:49:15 GMT

Hi Jose,

Select Single XKBELBEZ " XKBELBEZ is field of DDIC table TIV3A

From TIV3A " TIV3A is DDIC Table

Into i_report-hsemod " i_report is internal table and hsemod one field of i_report

Where

SPRAS = 'E' and " SPRAS field in DDIC table TIV3A

RBELBIND = dc_hsemod. " RBELBIND field in DDIC table TIV3A

so it will give only single record which matches ur requrirement like SPRAS = 'E' and RBELBIND = dc_hsemod in DDIC table TIV3A

Hope it will solve ur problem..

Reward points if useful

Thanks & Regards

ilesh 24x7