amdp


13 video [amdp procedure -1]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



CLASS zajay_class_amdp_procedure DEFINITION PUBLIC.


  PUBLIC SECTION.

  INTERFACES if_amdp_marker_hdb.

  TYPES: begin of typ_sales,

         vbeln type vbeln,

         auart type auart,

         end of TYP_SALES.

  TYPES:  begin of typ_mat,

          matnr type matnr,

          mtart type mtart,

          END OF TYP_MAT.

   TYPES: tt_sales_details type table of typ_sales,

          tt_mat_details type table of typ_mat.

  class-METHODS get_sales_details IMPORTING value(im_auart) type auart

                                    EXPORTING value(ex_sales_details) type tt_sales_details .

  CLASS-METHODS get_materail_details EXPORTING value(ex_mat_details) type tt_mat_details.

  PROTECTED SECTION.

  PRIVATE SECTION.

ENDCLASS.


CLASS zajay_class_amdp_procedure IMPLEMENTATION.

    METHOD get_sales_details BY DATABASE PROCEDURE FOR HDB LANGUAGE

        SQLSCRIPT OPTIONS READ-ONLY USING vbak.


        ex_sales_details = select vbeln , auart from vbak where auart = :im_auart;

    ENDMETHOD.


    METHOD get_materail_details BY DATABASE PROCEDURE FOR HDB LANGUAGE

        SQLSCRIPT OPTIONS READ-ONLY USING mara.


        ex_mat_details = select matnr , mtart from mara;


    ENDMETHOD.


ENDCLASS.



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

*& Report ZAJAY_AMDP_CALL

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

*&

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

REPORT zajay_amdp_call.


DATA(obj) = NEW zajay_class_amdp_procedure( ) .


CALL METHOD zajay_class_amdp_procedure=>get_sales_details

  EXPORTING

    im_auart         = 'TA'

  IMPORTING

    ex_sales_details = data(it_sales_details)


  .

BREAK-POINT.




14 video [amdp procedure -2]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


amdp  }  --> function  --> cds views

--> procedure --> abap objects

















Comments

Post a Comment

Popular posts from this blog

bapi introduction

 45 video ([bapi  introduction]) ---------------------------------- --> se84 --> business application programing interface. BOR--> business object repository | |__> business object type | |__>    interfaces  key fields attributes methods events 
Read more

ABAP for all

   1) INTRODUCTION TO ABAP ~~~~~~~~~~~~~~~~~~~~~~ sap --> System application and products functional ---------- > sales > finance > material management > quality > production > hr > logistics > plant maintanace technical ---------- > abap abap--> advanced business application programming. 2) DATA TYPES ,DATA , PARAMETERS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -> simple english to make the program statements. -> every statement must end with period(.). -> space between abap keywords , variables are mandatory. -> alll literals are enclosed with single codes. -> abap key word is not case sensitive. -> three steps--> saved-checked-activated. DATA TYPES ~~~~~~~~~~ --> elementary types --> referance types --> complex data types C -character N- numeric D- date T- time X- hexadecimal String I- integer F -float P- packed declarative keywords -------------------- > data > parameters ...
Read more