topic Re: Problem with structure and sql in Application Development and Automation Discussions

Problem with structure and sql

Former Member — Wed, 06 May 2009 07:34:21 GMT

Hi,

I only speak a little englis so I wait that you can understand me.

I have two structures. When I use the first structure in a sql I have an error: Unknown column name PEDIDO. field list. field list. field list. field list.

DATA: BEGIN OF t_pedidos OCCURS 0,

pedido TYPE VBAP-VBElN,

posnr TYPE VBAP-POSNR,

matnr TYPE VBAP-MATNR,

pstyv TYPE VBAP-PSTYV,

kwmeng TYPE VBAP-KWMENG,

vrkme TYPE VBAP-VRKME,

werks TYPE VBAP-WERKS,

factura TYPE VBRP-VBELN,

posicion TYPE VBRP-POSNR,

END OF t_pedidos.

DATA: BEGIN OF t_entregas OCCURS 0,

pedido TYPE VBAP-VBElN,

posnr TYPE VBAP-POSNR,

entrega LIKE LIPS-VBELN,

lfimg LIKE LIPS-LFIMG,

meins LIKE LIPS-MEINS,

END OF t_entregas.

SELECT

pedido

posnr

LIPS~VBELN AS entrega

LIPS~LFIMG

LIPS~MEINS AS meinsEntrega

FROM

LIPS

INTO TABLE t_entregas

FOR ALL ENTRIES IN

t_pedidos

WHERE

LIPS~VGBEL = t_pedidos-pedido AND

LIPS~VGPOS = t_pedidos-posnr.

I can't see what's the problem.

Thank you very much.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 07:38:41 GMT

Hi Jose,

try below

SELECT
VBELN "you need to use like this...use the refefecnec filed  of table not the internal table
posnr
LIPS~VBELN AS entrega
LIPS~LFIMG 
LIPS~MEINS AS meinsEntrega
FROM
LIPS
INTO TABLE t_entregas
FOR ALL ENTRIES IN
t_pedidos
WHERE
LIPS~VGBEL = t_pedidos-pedido AND
LIPS~VGPOS = t_pedidos-posnr.

Thanks!

Edited by: Prasanth Maddela on May 6, 2009 1:10 PM

Edited by: Prasanth Maddela on May 6, 2009 1:13 PM

Re: Problem with structure and sql

Sandeep_Panghal — Wed, 06 May 2009 07:39:20 GMT

Try this:

SELECT

vgbel as pedido

posnr

VBELN AS entrega

LFIMG

MEINS

FROM LIPS

INTO TABLE t_entregas

FOR ALL ENTRIES IN t_pedidos

WHERE

VGBEL = t_pedidos-pedido AND

VGPOS = t_pedidos-posnr.

Edited by: I039643 on May 6, 2009 1:09 PM

Edited by: I039643 on May 6, 2009 1:12 PM

Re: Problem with structure and sql

former_member222860 — Wed, 06 May 2009 07:40:09 GMT

Hi Jose,

As there's no field with PEDIDO in the table LIPS , so is the error

thanks

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 07:45:09 GMT

Thanks for your answer Prasanth Maddela.

The fields pedido and posnr belong to t_pedidos table and I need use this.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 07:46:14 GMT

I try your code I039643 but I receibe the same error.

Thank you very much.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 07:47:12 GMT

Hello Mahesh Reddy, I want use fields of my internal table t_pedidos. Pedido and posnr belong to this table.

Re: Problem with structure and sql

Sandeep_Panghal — Wed, 06 May 2009 07:49:01 GMT

can you try again with this:

SELECT

vgbel as pedido

posnr

VBELN AS entrega

LFIMG

MEINS

FROM LIPS

INTO TABLE t_entregas

FOR ALL ENTRIES IN t_pedidos

WHERE

VGBEL = t_pedidos-pedido AND

VGPOS = t_pedidos-posnr.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 07:51:20 GMT

HI Jose,

While fetching data from the Data base level you need to use the referecnce fileds of the data base table not the internal table.

after fetching you t_pedidos-pedidos fills automatically as it is the referece field of VGBEL in the LIPS.

hope these info helps you .

Thanks!

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 08:34:20 GMT

I understand it, but, if I want to use a field of t_pedidos that is owner of t_pedidos and itsn't in the tables of data base how LIPS, ¿how can I use it?.

Thank you very much.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 08:44:51 GMT

SELECT

pedido

posnr

LIPS~VBELN AS entrega

LIPS~LFIMG

LIPS~MEINS AS meinsEntrega

FROM

LIPS

INTO TABLE t_entregas

FOR ALL ENTRIES IN

t_pedidos

WHERE

LIPS~VGBEL = t_pedidos-pedido AND

LIPS~VGPOS = t_pedidos-posnr.

In the above query PEDIDO should be given with table reference

Ex: VBAP~PEDIDO

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 08:45:47 GMT

similar thing for POSNR also Ex: VBAP~POSNR

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 08:54:47 GMT

hi,

> DATA: BEGIN OF t_pedidos OCCURS 0,

> pedido TYPE VBAP-VBElN,

> DATA: BEGIN OF t_entregas OCCURS 0,

> pedido TYPE VBAP-VBElN,

write like this..

DATA: BEGIN OF t_pedidos OCCURS 0,

pedido TYPE VBAP-VBELN,

DATA: BEGIN OF t_entregas OCCURS 0,

pedido TYPE VBAP-VBELN,

hope this helps

Regards

Ritesh Jha

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 09:10:45 GMT

Thank you for your answers.

Ajay kumar, in my code I have a first sql that put tha data in t_pedidos. This sql use VBAP for get the data.

Hello Ritesh Jha, sorry, but in the code, i put the L in lower case and is similar to i, but i have VBELN.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 09:18:19 GMT

Is it possible for u to change the PEDIDOS field to VBELN in your table t_entregas definition.

And also in the SELECT statement replace PEDIDOS with VBELN.

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 09:19:30 GMT

Hi..

Your Code is below.

SELECT

pedido

posnr

LIPS~VBELN AS entrega

LIPS~LFIMG

LIPS~MEINS AS meinsEntrega

FROM

LIPS

INTO TABLE t_entregas

FOR ALL ENTRIES IN

t_pedidos

WHERE

LIPS~VGBEL = t_pedidos-pedido AND

LIPS~VGPOS = t_pedidos-posnr.

Instead of this you use below code.

SELECT

LIPS~VGBEL as pedido

LIPS~VGPOS as posnr

LIPS~VBELN AS entrega

LIPS~LFIMG

LIPS~MEINS AS meinsEntrega

FROM

LIPS

INTO TABLE t_entregas

FOR ALL ENTRIES IN

t_pedidos

WHERE

LIPS~VGBEL = t_pedidos-pedido AND

LIPS~VGPOS = t_pedidos-posnr.

Instead of pedido use VGBEL and instead of posnr use VGPOS in select query as in LIPS table no such fields exsist(pedido or posnr).And as you are passing pedido and posnr in where clause the values will be same with this query.

Hope it helps you.

Vidhi

Re: Problem with structure and sql

Former Member — Wed, 06 May 2009 10:48:00 GMT

Perhaps, I can't use the fields of a internal table like fields of a sql. I can use this fields to filter the registers but I can't put in the select of sql.