Posts

Showing posts from July, 2021

Fill the sflight data in sap abap

 The below Program help you to fill the data flight for testing purpose  SAPBC_DATA_GENERATOR ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/rohini-kumar-14647a13a/ ********************************************************************************

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 DATABA

Inner Join

simple example in inner join more then two table with inline coding    SELECT  a ~ matnr , e ~ maktx , d ~ mtart , d ~ matkl , a ~ lfgja , a ~ lfmon  , b ~ mtbez  , a ~ bwkey , c ~ wgbez , a ~ lbkum  , a ~ salk3 , M ~ LGORT     FROM  mbew  AS  a INNER  JOIN  mara  AS  d  ON  d ~ matnr  =  a ~ matnr INNER  JOIN  t134t  AS  b  ON  b ~ mtart  =  d ~ mtart  AND  b ~ spras  =  'E'    INNER  JOIN  t023t  AS  c  ON  c ~ matkl  =  d ~ matkl    INNER  JOIN  makt  AS  e  ON  e ~ matnr  =  a ~ matnr  AND  e ~ spras  =  'E'    INNER  JOIN  mard  AS  m  ON  m ~ matnr  =  a ~ matnr  AND  m ~ WERKS  =  a ~ bwkey        into  table  @data ( gt_mseg )  where  a ~ lbkum  ne  0. ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/rohini-kumar-14647a13a/ *******************************************************

Calling the ADOBE FORM IN SAP ABAP Programming

  REPORT  zcall_adobe_form. &-----------------------------------------------------------------------& *& Author  : P Surjith Kumar *& Purpose : Call the Adobe form in the ABAP Program *&------------------------------------------------------------------------ DATA: fm_name           TYPE rs38l_fnam,      " CHAR  30   0   Name of Function Module        fp_docparams      TYPE sfpdocparams,    " Structure  SFPDOCPARAMS Short Description  Form Parameters  for   Form Processing        fp_outputparams   TYPE sfpoutputparams, " Structure  SFPOUTPUTPARAMS Short Description  Form Processing Output Parameter        it_mari           TYPE zmari_tbl.       " Table Type ZMARI_TBL MARI Table Tyoe * Sets the output parameters and opens the spool job CALL FUNCTION  'FP_JOB_OPEN'                     "& Form Processing: Call Form    CHANGING      ie_outputparams = fp_outputparams    EXCEPTIONS      cancel          =  1      usage_error     =  2