is it possible to transform one column from loaded table to Row

[#1]

Dear All,

I am facing difficulty in loading KNOV table from SAP system

it is having conditions

So what i am facing is when i am joining KONV with VBRK VBRP it is creating multiple rows for each invoice but having multiple conditions in KONV .

So entries are getting repeated and my qty total value comes double then actual one.

So i thought that in KONV if only condition column can be converted into row i can stop multiple entries and my Column total will then match.

Can i use transpose option to convert condition column only from KONV to a single row.

Regards

Raj

[#2]

Maybe you can use the Crosstable feature ?

[amars]

Hi Raj,

I am not sure, but see if the attached example help's

Regard's

Amar

[#4]

Hi,

But what is correct solution for this.

Thanks

Ritul

[#5]

Hi,

I have a same problem do you get any perfect solution for this. Then please let me know if you get any solution for this.

Thanks