Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

select query logic needed

Former Member
0 Kudos
79

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
51

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

1 REPLY 1

Former Member
0 Kudos
52

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