ISJPINVSUM30_FORMS SAP Report - Include ISJPINVSUM30_FORMS

ISJPINVSUM30_FORMS is a standard ABAP report available within your SAP system (depending on your version and release level). Below is the standard documentation available for this report and a few details of other objects it interacts with such as tables, function modules, includes etc. If you would like to see the full code listing simply enter ISJPINVSUM30_FORMS into the relevant SAP transaction such as SE38 or SE80

Contribute (Add Comments)
Below is the basic information available for SAP report ISJPINVSUM30_FORMS and is provided for your convenience to access as and when required. Although the basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name ISJPINVSUM30_FORMS or its description.

Transaction Code:

N/A

Includes used within report:

No INCLUDES are used within this report code!

Tables used within report and the associated select statement:

KNA1

        SELECT SINGLE kunnr name1 adrnr FROM kna1 INTO is_kna1_recip

          WHERE kunnr = is_mi-invsumrecip.

KNA1

        SELECT SINGLE kunnr name1 FROM kna1 INTO is_kna1_payer

          WHERE kunnr = is_pi-invsumpayer.

ISJPINVSUMHD

  SELECT * FROM isjpinvsumhd INTO TABLE it_mi

     WHERE (lv_where_condition) .

ISJPINVSUMHD

    SELECT * FROM isjpinvsumhd INTO TABLE it_pi

    FOR ALL ENTRIES IN it_mi

    WHERE bukrs       = it_mi-bukrs

      AND invsumnr    = it_mi-pinr

      AND invsumnr    IN s_pinr

      AND invsumtype  EQ const_p

      AND invsumpayer IN s_payer

      AND closdate    IN s_cdate

      AND netdt       IN s_ddate

      AND cancelled   NE lc_true.

ISJPINVSUMIT

    SELECT * FROM isjpinvsumit INTO TABLE it_cr

      FOR ALL ENTRIES IN it_mi

      WHERE bukrs       EQ p_bukrs

        AND invsumpayer IN s_payer

        AND closdate    IN s_cdate

        AND netdt       IN s_ddate

        AND minr        = it_mi-invsumnr

        AND creadate    LE p_date.

ISJPINVSUMIT

    SELECT * FROM isjpinvsumit APPENDING TABLE it_cr

             WHERE bukrs       EQ p_bukrs

               AND invsumpayer IN s_payer

               AND closdate    IN s_cdate

               AND netdt       IN s_ddate

               AND minr        EQ const_b

               AND creadate    LE p_date.

KNA1

    SELECT kunnr name1 adrnr FROM kna1 INTO TABLE it_kna1_payer

      FOR ALL ENTRIES IN it_cr

      WHERE kunnr = it_cr-invsumpayer.

KNA1

    SELECT kunnr name1 adrnr FROM kna1 INTO TABLE it_kna1_recip

      FOR ALL ENTRIES IN it_cr

      WHERE kunnr = it_cr-invsumrecip.

BSEG SELECT bukrs belnr gjahr buzei augdt augbl zterm FROM bseg INTO TABLE it_bseg FOR ALL ENTRIES IN it_cr WHERE bukrs = p_bukrs AND belnr = it_cr-belnr AND buzei = it_cr-buzei.

BKPF

    SELECT * FROM bkpf INTO TABLE it_bkpf                      "invoices, reversal of invoices, payments

     FOR ALL ENTRIES IN it_bseg

     WHERE bukrs = p_bukrs

     AND   belnr = it_bseg-belnr

     AND   gjahr = it_bseg-gjahr.

T001

  SELECT SINGLE butxt FROM t001 INTO c_code_t

          WHERE bukrs = p_bukrs.

Function Modules used within report and the associated call statement:

No SAP FUNCTION MODULES are executed within this report code!

Text pool values

Title: Include ISJPINVSUM30_FORMS

ISJPINVSUM30_CLASSES

ISJPINVSUM30_ALV