Inner joing is not fetching any data

[Raxph]

Hi together,

I am having some issues with the inner join select statement, as even though I checked on the tables that are used in the select statement, it is not fetching any data.

 SELECT k~plnnr k~plnal z~ktext
  FROM eapl AS k
  INNER JOIN plko AS z
  ON k~plnnr EQ z~plnnr
  AND k~plnal EQ z~plnal
  INTO TABLE g_t_join
  WHERE k~equnr EQ gv_equipment.

The variable gv_equipment is filled as I checked via debugging. Does anyone know whether I have done any mistake in the select statement?

Thank you all in advance!

[venkateswaran_k]

Hi

Please use the following code. It may be because the equipment number is to be in in the internal format.

** conversion exit function.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    input         = gv_equipment
 IMPORTING
   OUTPUT        = gv_equipment.

SELECT k~plnnr k~plnal z~ktext
  FROM eapl AS k
  INNER JOIN plko AS z ON ( k~plnnr EQ z~plnnr  AND k~plnal EQ z~plnal )
  INTO TABLE g_t_join
  WHERE k~equnr EQ gv_equipment.

Regards,

Venkat

[Raxph]

Yes that was the issue. Many thanks!!

[Sandra_Rossi]

or

gv_equipment = |{ gv_equipment ALPHA = IN }|.

[Sandra_Rossi]

When you have such issues, you need to split your query to identify the cause of the issue, like first trying:

SELECT k~plnnr, k~plnal
  FROM eapl AS k
  INTO TABLE @data(dummy)
  WHERE k~equnr EQ @gv_equipment.

If it returns nothing, you know that the issue is not about the join, but due to the value in the WHERE (or you're in the wrong client).