Skip to Content
0
Former Member
Aug 15, 2008 at 03:51 AM

select query logic needed

26 Views

I want to extract below fields in to one internal table. any body help me pls

DATA: BEGIN OF it_billing OCCURS 0,

SEL(1) TYPE C,
        werks LIKE vbrp-werks,
        vkorg LIKE vbrk-vkorg,
        kunag LIKE vbrk-kunag,
        kunwe LIKE vbrk-kunwe,
        vstel LIKE likp-vstel,
        land1 LIKE vbpa-land1,
        ddl   LIKE lips-vbeln,
        posnr LIKE lips-posnr,
        vbeln LIKE vbrk-vbeln,
        fkart like vbrk-fkart ,
        BSTNK_VF like vbrk-BSTNK_VF,
        vbpa like vbpa-land1,
        idnkd like vbdpr-idnkd,
        fkimg like vbrp-fkimg,
        WAERK like vbrk-WAERK,
        WAERs like t001-WAERs,
        KURRF like vbrk-KURRF,
        Kbetr like komvd-Kbetr,
        Kmein like komvd-Kmein,
        Kwert like komvd-Kwert,
        mwsbp like vbrp-mwsbp,
        FKDAT like vbrk-FKDAT,
END OF it_billing.

selection screen

PARAMETERS : p_vkorg LIKE vbrk-vkorg   OBLIGATORY.
SELECT-OPTIONS :
  s_vtweg FOR vbrk-vtweg   ,
  s_spart FOR  vbrk-spart.

SELECTION-SCREEN SKIP.
SELECT-OPTIONS :
  s_fkdat FOR  vbrk-fkdat OBLIGATORY,
  s_fkart FOR vbrk-fkart,
  s_vbeln FOR vbrk-vbeln,
  s_kunwe FOR vbrk-kunwe,
  s_vstel FOR likp-vstel,
  s_labd1 FOR vbpa-land1,
  s_auart FOR vbak-auart NO-DISPLAY.