Hi All,
Following is my requirement.
Selection-Screen:
Select-Options:
so_vkorg for vbrk-vkorg
so_fkart for vbrk-fkart
so_fkdat for vbrk-fkdat
so_vbeln for vbrk-vbeln
so_kunnr for vbrk-kunnr
so_kunrg for vbrk-kunrg
so_waerk for vbrk-waerk
so_parvw for vbpa-parvw commission recipient role
so_parnr for vbpa-parnr commission recipient number
Parameters:
pa_kschl type konv-kschl (only the values ZPRA,ZPRE,ZPRV,ZALR allowed)
pa_rcv type kunnr (There must be a check, if condition ZARL (pa_kschl) is entered the field pa_rcv u201CCommission
recipient numberu201D must be filled). The pa_rcv is the receiver of the form alpha commision detail.
Radiobutton: pa_head (cumulated on invoice number)
Pa_pos (sorted on invoice number include item data)
parameters: p_vari like disvariant-variant (Display Layout for ALV-Grid)
Processing:
Read the table vbrk with the select-options so_vkorg, so_fkart, so_fkdat, so_vbeln, so_kunnr and so_kunrg into a internal table.
Check the entries of vbrk for the condition price type and read the table konv with vbrk-knumv and pa_kschl. Check the entries of vbrk for the commission recipient role and number and read the table vbpa with vbrk-vbeln, so_parvw and so_parnr. Read the item data of the Billing Document (vbrp) fill cumulate the output structure depending on radio button pa_head / pa_pos.
I have selected the data from database into 4 internal tables, as per the above processing logic.
Now I have to move the data from all internal tables into a single internal table based on above processing.
The structure of the final internal table is
PARVW CHAR2 0 commission recipient role
PARNR NUMC8 0 commission recipient number
VBELN CHAR10 0 Invoice number
FKDAT DATE8 0 Invoice date
KUNRG CHAR10 0 Payer
POSNR CHAR10 0 Invoice pos.
MATNR CHAR18 0 Article no.
ARKTX CHAR15 0 Article
FKIMP QUAN13 3 Quantity
VRKME UNIT3 0 Quantity unit
NETWR CHAR15 0 Net value
KBETR CURR11 2 Value commission
WAERK CUKY5 0 SD Document Currency
PRODH CHAR10 0 Product hierarchy
Now this output table has to be displayed using object oriented ALV.
How do you do it?
Along with this, The address of the commission recipient is displayed in the top of page of the ALV-Grid.
Sum 'Net value' and 'Value commision' for each currency. If the commission recipient number changes, a new sum and new page has to be started.
please help me out.
Bluesky
