Datatype Conversion [NUMC5 to NUMC6]

[ullas_u2]

Dear All,

Is there any way to connect EKPO-ebelp to KONV-kposn [the two fields are type incompactable; one is numc5 and the other is numc6].

-Ullas

[ullas_u2]

Hi

Thers is a option to do that. Please follow the belo things in your code.

declare L_ebelp type KONV-kposn.

Move the data EKPO-EBELP to L_EBELP.

while you extact the data from KONV in the where condition you can compare Where KPOSN = L_EBELP.

This will not show any error. It will works fine. Please check and let me know.

[Former Member]

Hi,

it is completely false that the fields are type incompatible. They have a different length but it is not an impediment to move values from EKPO-ebelp to KONV-kposn and both are of type NUMC.

DATA: var1 TYPE ekpo-ebelp VALUE '45',
      var2 TYPE konv-kposn.


MOVE var1 TO var2.
WRITE:/10 var2.

in the other way it is not possible, because you´re losing one digit.

[Former Member]

Hi

Thers is a option to do that. Please follow the belo things in your code.

declare L_ebelp type KONV-kposn.

Move the data EKPO-EBELP to L_EBELP.

while you extact the data from KONV in the where condition you can compare Where KPOSN = L_EBELP.

This will not show any error. It will works fine. Please check and let me know.

[Former Member]

Hi UllasU,

for what purpose do you want convert the data types?

below statement works fine - table konv cannot be uses in JOIN.

SELECT *
      FROM konv
      WHERE knumv = ekko-knumv
      AND   kposn = ekpo-ebelp.

regards

REA