Sales Order Detail AMDP Class

-

 Sales Order Detail AMDP Class 

AMDP is Different From CDS View in the CDS view we can receive data but ADMP also possibility we can modify the data as per the requirement  

CLASS ztest_001 DEFINITION

 PUBLIC

 FINAL

 CREATE PUBLIC.

PUBLIC SECTION.

*Marker interface for Database Procedures

 INTERFACES: if_amdp_marker_hdb.

*Structure

 TYPES:

 BEGIN OF ty_order,

   vbeln      TYPE vbeln,       "Sales Order Number

   posnr      TYPE posnr_va,    "Item Number

   vkorg      TYPE vkorg,       "Sales Organization

   item_price TYPE netwr_ap,    "Item Price

   status         TYPE char30,  "Delivery Status

 END OF ty_order.

* Table type

 TYPES:

  tt_order TYPE STANDARD TABLE OF ty_order WITH EMPTY KEY.

* Method Definition

 CLASS-METHODS get_salesorder_details

    IMPORTING

      VALUE(iv_vbeln) TYPE vbeln

    EXPORTING

      VALUE(et_order) TYPE tt_order.

PROTECTED SECTION.

PRIVATE SECTION.


ENDCLASS.


CLASS ztest_001 IMPLEMENTATION.

METHOD get_salesorder_details BY DATABASE PROCEDURE

                             FOR HDB

                             LANGUAGE SQLSCRIPT

                             OPTIONS READ-ONLY

                             USING vbak vbap vbup.

*To get Sales Order details

et_order = SELECT vbak.vbeln,

                  vbap.posnr,

                  vbak.vkorg,

                  vbap.netwr as item_price,

                  CASE vbap.LFSTA

                       WHEN '' then 'Not Relevant'

                       WHEN 'A' then 'Not yet processed'

                       WHEN 'B' then 'Partially processed'

                       WHEN 'C' then 'Completely processed'

                  END AS status

            FROM vbak AS vbak INNER JOIN vbap AS vbap

                  ON vbak.vbeln = vbap.vbeln

            INNER JOIN vbup AS vbup

                  ON vbup.vbeln = vbap.vbeln AND vbup.posnr = vbap.posnr

            WHERE vbak.vbeln = iv_vbeln;

            ENDMETHOD.

ENDCLASS.


********************************ROHINI KUMAR*********************************

                               Please support my work : sap.rohini988@gmail.com

                               LinkedIn Link  : https://www.linkedin.com/in/rohini-kumar-14647a13a/
********************************************************************************

Comments

Post a Comment

Popular posts from this blog

all user exit mv45afzz (implicit user exit )

-
MV45AFZZ this is included here all code put related to sales order creation while creating a sales order  va01 this exit trigger so as per your requirement we can write your code here I going to listed different type exit as per the real requirement you find the code and develop your business scenario INCLUDE MV45AFZZ . Modify Screen VA01/VA02/VA03 How to Activated and Deactivated Screen  Export Memory example While Creating a sales order  How to Call workflow While Creating a sales order  TYPES  :  BEGIN  OF  ty_vbak ,           KVGR1  TYPE  vbak - KVGR1 ,           KVGR2  TYPE  vbak - KVGR2 ,          END  OF  ty_vbak . DATA  :  ls_vbak  TYPE  ty_vbak . IF  sy - tcode  =  'VA02'  and  sy - uname  =  'FREDDIE' . BREAK freddie . *SELECT SINGLE KVGR1 KVGR2 *  FROM vbak *  INTO ls_vbak * WHERE vbeln = vbak-vbeln. * *IF vbak-KVGR1 <> ls_vbak-KVGR1 or vbak-KVGR2 <> ls_vbak-KVGR2. *  VBAK-FAKSK = '05'.
Read more

How to Give Dropdown in alv report in sap abap programming Language

-
   IF  p_fieldname  =  'REASONS' .     wa_fcat - f4availabl  =  'X' .    ENDIF .   PERFORM  dropdown_table  CHANGING  g_grid . FORM  dropdown_table  CHANGING  g_grid  TYPE  REF  TO  cl_gui_alv_grid .    DATA  : lt_dropdown  TYPE  lvc_t_drop  WITH  HEADER  LINE .    DATA :  gs_f4  TYPE  lvc_s_f4 ,         gt_f4  TYPE  lvc_t_f4 .    LOOP  AT  it_fcat  INTO  wa_fcat .      IF  wa_fcat - fieldname  =  'REASONS' .       wa_fcat - drdn_hndl  =  '1' .       wa_fcat - outputlen  =  20 .        MODIFY  it_fcat  FROM  wa_fcat .      ENDIF .    ENDLOOP . *CLEAR GT_F4. *  GS_F4-FIELDNAME  = 'REMARK'. *  GS_F4-REGISTER   = 'X'. *  GS_F4-GETBEFORE  = 'X'. *  GS_F4-CHNGEAFTER = 'X'. *  APPEND GS_F4 to GT_F4.    CALL  METHOD  g_grid -> register_f4_for_fields      EXPORTING       it_f4  =  gt_f4 .   lt_dropdown - handle  =  '1' .   lt_dropdown - value  =  'Loadability Issue' .    APPEND  lt
Read more

Long Text in input and output field in module pool

-
Image
display long text in input and output field then below code help you how to display long text your input and output fields in sap ************************************************************************ * Program Name      :  ZLONG_TEXT_EDITOR           Object ID:   p002    * * Description       :  Long text with function module                   * * Create Date       :  26.12.2018                                      * * FO Owner          :  Rohini kumar                                    * * Tech Owner        :  Rohini Kumar                                    * * Project Module    :  SD                                              * ************************************************************************ *                        Change Log                                    * ************************************************************************ *  REQ#         DATE         WHO            CHANGE_ID        DESCR     * *-------------------------------------------
Read more