select query logic needed

Former Member — Fri, 15 Aug 2008 03:51:24 GMT

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.

Re: select query logic needed

Former Member — Fri, 15 Aug 2008 07:52:53 GMT

Have you tried if for yourself first, before you ask for someone else to do your job.

topic select query logic needed in Application Development and Automation Discussions

select query logic needed

Re: select query logic needed