topic Re: DISPLAYING in Application Development and Automation Discussions

DISPLAYING

Former Member — Tue, 12 Feb 2008 13:16:36 GMT

hi all

CONACATENATE EBELN AUFNR INTO E_AUFNR

SELECT tdname FROM STXH

INTO TABLE IT_STXH

WHERE TDOBJECT EQ 'VBBP'

AND TDID IN 'ZI01' OR TDID IN 'ZI02'

AND TDNAME EQ E_AUFNR.

this is my code can u please explain where the mistake is <REMOVED BY MODERATOR>

thanks

swaroop

Edited by: Alvaro Tejada Galindo on Feb 12, 2008 9:01 AM

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 13:26:10 GMT

Hi,

Check it once..........u hav not mentioned the language....

TDSPRAS = ? must be sy-langu no.....

better use read_text FM

Cheers,

jose.

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 13:26:44 GMT

Hi,

First of all what error message are you getting?

The points i observed here are:

1) Internal table IT_STXH should only have one field tdname.

2) Where condition must be accompanied with proper brackets.

3) EBELN should be in the proper format like having initial zeros ( Use conversion exits ).

4) Where condition field must be in the order of first primary then secondary keys followed by normal fields. ( Normal fields are not recommended as performance hampers ).

most importantly, IN operator should not be used here as you are checking with a single value. instead use EQ operator. just replace IN with EQ in the query and it will work

<REMOVED BY MODERATOR>

rgds,

Harikrishna

Edited by: harikrishna indugu on Feb 12, 2008 2:27 PM

Edited by: Alvaro Tejada Galindo on Feb 12, 2008 9:09 AM

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 13:34:46 GMT

JYOTHY

FIRST OF ALL YOUR 'CONACATENATE' SPELLING IS WRONG

IT IS 'CONCATENATE'.

IF AGAIN IF U R GETTING PROBLEM POST IT ONCE AGAIN.

<REMOVED BY MODERATOR>

REGARDS

HEMASEKHARA REDDY

Edited by: Alvaro Tejada Galindo on Feb 12, 2008 9:12 AM

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 14:05:36 GMT

MAINLY MY PROBLEM IS I AM NOT ABLE TO CONCATENATE BOTH EBELN AND AUFNR

PLZ HELP ME OUT VERY URGENT

THANKS

SWAROOP

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 14:17:49 GMT

Hi,

Can you check the data type of E_AUFNR?

data: E_AUFNR(22) TYPE C.

why 22 is -- Length of EBELN is 10 and AUFNR is 12.

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 14:18:05 GMT

CONACATENATE EBELN AUFNR INTO E_AUFNR

SELECT tdname FROM STXH

INTO TABLE IT_STXH

WHERE TDOBJECT EQ 'VBBP'

AND TDID IN 'ZI01' OR TDID IN 'ZI02'

AND TDNAME EQ E_AUFNR.

declare the E_AUFNR as char field.

DATA : e_aufnr type char100.

CONCATENATE EBELN AUFNR INTO E_AUFNR.

I think u r using constants as u have given them in Quotes 'ZI01' and 'ZI02'

SELECT tdname

FROM STXH

INTO TABLE IT_STXH

WHERE TDOBJECT EQ 'VBBP'

AND ( TDID EQ 'ZI01' OR TDID EQ 'ZI02' )

AND TDNAME EQ E_AUFNR.

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 14:20:10 GMT

HI,

BUT LENGTH OF TDNAME IS 70 THERE AGAIN IT IS SHOWING PROBLEM

Re: DISPLAYING

Former Member — Tue, 12 Feb 2008 14:23:18 GMT

Then declare like this..

data: E_AUFNR(70) TYPE C.