Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Zak SQL Stmts5

    Uploaded by

    naveen441
    This document contains an ABAP report that queries data from the VBRP table and outputs it. The report accepts VBRP document number and item number parameters, performs a SELECT statement on the VBRP table to retrieve matching records, appends the results to an internal table, and loops through the table to output the document number, item number, material, and text fields.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Zak SQL Stmts5

    Uploaded by

    naveen441
    21 views1 page
    This document contains an ABAP report that queries data from the VBRP table and outputs it. The report accepts VBRP document number and item number parameters, performs a SELECT statement on the VBRP table to retrieve matching records, appends the results to an internal table, and loops through the table to output the document number, item number, material, and text fields.

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an ABAP report that queries data from the VBRP table and outputs it. The report accepts VBRP document number and item number parameters, performs a SELECT statement on the VBRP table to retrieve matching records, appends the results to an internal table, and loops through the table to output the document number, item number, material, and text fields.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    21 views1 page

    Zak SQL Stmts5

    Uploaded by

    naveen441
    This document contains an ABAP report that queries data from the VBRP table and outputs it. The report accepts VBRP document number and item number parameters, performs a SELECT statement on the VBRP table to retrieve matching records, appends the results to an internal table, and loops through the table to output the document number, item number, material, and text fields.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    of 1

    *&---------------------------------------------------------------------*

    *& Report ZAK_SQL_STMTS4


    *&
    *&---------------------------------------------------------------------*
    *&
    *&
    *&---------------------------------------------------------------------*

    REPORT zak_sql_stmts4.

    TYPES : BEGIN OF t_vbrp,


    vbeln TYPE vbeln_vf,
    posnr TYPE posnr_vf,
    matnr TYPE matnr,
    arktx TYPE arktx,
    END OF t_vbrp.
    TYPES : tt_vbrp TYPE STANDARD TABLE OF t_vbrp.

    DATA : lw_vbrp TYPE t_vbrp,


    lt_vbrp TYPE tt_vbrp.
    DATA : v_vbeln TYPE vbeln_vf,
    v_posnr TYPE posnr_vf,
    v_matnr TYPE matnr,
    v_arktx TYPE arktx.
    PARAMETERS : p_vbeln TYPE vbrp-vbeln,
    p_posnr TYPE vbrp-posnr.

    *-- Fetch the data from VBRP


    *-- SELECT ------- ENDSELECT
    SELECT vbeln posnr matnr arktx FROM vbrp
    INTO lw_vbrp
    WHERE vbeln = p_vbeln.
    APPEND lw_vbrp TO lt_vbrp.
    CLEAR lw_vbrp.
    ENDSELECT.

    IF sy-subrc EQ 0.
    LOOP AT lt_vbrp INTO lw_vbrp.
    WRITE : / lw_vbrp-vbeln,lw_vbrp-posnr , lw_vbrp-matnr , lw_vbrp-arktx.
    CLEAR lw_vbrp.
    ENDLOOP.
    ELSE.
    WRITE : / 'NO DATA FOUND'.
    ENDIF.

    You might also like