Display purchasing document details (EKKO + EKPO) in usual ABAP class.

 

1. Goto SE24.

2. Give class name and click on create and give description.



3. Click on save.

4. Give method name, level, visibility, description.


5. Save, check and activate.

6. Click on parameters tab and give parameters.

        * Create structure in SE11.

            - Goto T-code -SE11.

            - Select data type and give name.

            - Click on create and select structure.

            - Give fields, check, activate.

            


        * Create Table type in SE11.

             - Goto T-code -SE11.

            - Select data type and give name.

            - Click on create and select table type.

            - Give description and line type (Structure).

            


        * Create internal table with type table type.

7. Save and activate.

8. Click on source code and write logic.

           METHOD display.

        TYPES: BEGIN OF ty_ekko,
                 ebeln TYPE ebeln,
                 bukrs TYPE bukrs,
                 bstyp TYPE bstyp,
                 bsart TYPE bsart,
               END OF ty_ekko.
        TYPES: BEGIN OF ty_ekpo,
                 ebeln TYPE ebeln,
                 ebelp TYPE ebelp,
                 txz01 TYPE txz01,
                 matnr TYPE matnr,
               END OF ty_ekpo.
        DATA: lt_final TYPE zab_tt_eeko_ekpo,
              lr_final TYPE zab_str_eeko_ekpo,
              lr_ekko  TYPE ty_ekko,
              lt_ekko  TYPE TABLE OF ty_ekko,
              lr_ekpo  TYPE ty_ekpo,
              lt_ekpo  TYPE TABLE OF ty_ekpo.

        SELECT ebeln
                bukrs
                bstyp
                bsart
                FROM ekko
                INTO TABLE lt_ekko
                WHERE ebeln = pebeln.
        IF lt_ekko IS NOT INITIAL.
          SELECT ebeln
                  ebelp
                  txz01
                  matnr
                  FROM ekpo
                  INTO TABLE lt_ekpo
                  FOR ALL ENTRIES IN
                  lt_ekko
                  WHERE ebeln = lt_ekko-ebeln.
        ENDIF.
        LOOP AT lt_ekko INTO lr_ekko.
          lr_final-ebeln = lr_ekko-ebeln.
          lr_final-bukrs = lr_ekko-bukrs.
          lr_final-bstyp = lr_ekko-bstyp.
          lr_final-bsart = lr_ekko-bsart.
          LOOP AT lt_ekpo INTO lr_ekpo WHERE ebeln = lr_ekko-ebeln.
            lr_final-ebelp = lr_ekpo-ebelp.
            lr_final-txz01 = lr_ekpo-txz01.
            lr_final-matnr = lr_ekpo-matnr.
            APPEND lr_final TO gt_ekko_ekpo.
            CLEAR: lr_final.

          ENDLOOP.

        ENDLOOP.

      ENDMETHOD.
9. Activate and execute.

Input


Output



**********************Thank You**********************

Comments

Post a Comment

Popular posts from this blog

New syntax for append- VALUE (new syntax 7.4+) in ABAP

Image
* We use APPEND statement to insert the records at the last of the internal table. * In SAP ABAP new syntax, we can use VALUE expression instead of APPEND statement. * Value expression is a powerful mechanism to declare as well as initialize the internal tables. * It is a powerful utility where we can achieve the result with minimal coding. * Value expression is of 2 types.      -  Define the type before using it with VALUE keyword. The type defined is structure type  or table type.      -  Using # character for type and use it with VALUE keyword. Report REPORT  zab_rp_append_value . TYPES :  BEGIN  OF  ls_stu ,          st_id ( 10 )    TYPE  n ,          st_name ( 15 )  TYPE  c ,         END  OF  ls_stu . DATA :  lt_stu  TYPE  TABLE...
Read more

Read statement new syntax in ABAP. (7.4+).

Image
*  Before ABAP 7.4, we used READ TABLE statement to read the first matching record from the internal table  based upon key or index . * In SAP ABAP new syntax, instead of READ TABLE , we can use the table expressions. * We need to use the square bracket [ ], In the square bracket, we need to specify the key or index. * While using table expression, If the table entry does not exist, system throws the exception CX_SY_ITAB_LINE_NOT_FOUND. * Use line_exists statement to check the existence of a record. Report REPORT  zab_rp_read_new . TABLES :   vbak . SELECT-OPTIONS :   s_vbeln  FOR  vbak - vbeln . SELECT  vbeln , erdat , erzet , ernam , auart         FROM  vbak         INTO  TABLE  @DATA ( lt_vbak )          WHERE  vbeln  IN  @s_vbeln . WRITE :   'Index value'  COLOR  5 . READ  T...
Read more

Concatenation new syntax( 7.4+ ).

Image
  Report REPORT  zab_rp_concat_7_4 . DATA :   lv_str1    TYPE  string  VALUE  'ajay' ,       lv_str2    TYPE  string  VALUE  'babu' ,       lv_str3    TYPE  string  VALUE  'varikallu' ,       lv_final1  TYPE  string ,       lv_final2  TYPE  string . CONCATENATE  lv_str1 lv_str2 lv_str3  INTO  lv_final1  SEPARATED  BY  space . WRITE :   /  'Old syntax: '  ,  lv_final1  COLOR  4 . lv_final2  =  | { lv_str1 } { lv_str2 } { lv_str3 } | . WRITE :   /  'New syntax: '  ,  lv_final2  COLOR  5 . Output ****** *********** ******** Thank You ****** ******* *********
Read more