help needed

[Former Member]

Hi experts,

my client requirement is Use Sales Org to read table KNVP. Process all partener type PARVW="RG" records found on KNVP and create an output record for each one.

Tanks,

venkat.b

[Former Member]

Do you require a report. The client could just use SE16 and download the list to a spreadsheet.

[Former Member]

In the selection screen pass a parameter p_VKORG type VKORG.

*declare a internal table

data: i_knvp type standard table of knvp.

In the start-of-selection.

if not p_vkorg is initial.

select * from KNVP into table i_knvp

where vkorg = p_vkorg and PARVW= 'RG'.

endif.

In end-of-selection.

if not i_knvp[] is initial.

call screen 100.

endif.

Check the below programs to the final data in ALV:

BCALV_GRID_01

BCALV_GRID_02

BCALV_GRID_03

BCALV_GRID_04

BCALV_GRID_05

BCALV_GRID_06

BCALV_GRID_07

BCALV_GRID_08

BCALV_GRID_09

BCALV_GRID_10

BCALV_GRID_11

Regards,

Prakash.

[Former Member]

hI PRAKASH RAMU.

what i need is suppose different customers having same partenertype parvw='rg' in this case i want diffent outputs for different customers

Thanks,

venkat.b

[former_member758419]

Hi venkat,,

try out the below code,,

tables: knvp. "(include knvp in the tables statement)

SELECT kunnr

parvw

kunn2

FROM KNVP into

corresponding fields of TABLE ITAB_KNVP

WHERE kunnr EQ itab-kunnr and

PARVW EQ 'RG'.

Mark points for helpful answers,,,

Thanks,

Sachidanand.B