SAP Loop Statement with Group by

Now you can use group by statement in loop Syntax :- loop at lt_vbrp into data(ls_vbrp) group by ls_vbrp-vbeln into data(lt_vbrp_g). loop at group lt_vbrp_g into data(ls_vbrp_g). add ls_vbrp-netpr to ls_output-netpr. endloop. append ls_output to lt_output. endloop.

Continue reading »

IFRS – REFX SAP Database Table

Below Tables will be helpful for the reporting requirement   Tables Description 1 VICNCN Contract Data Header 2 VIBDOBJASS Contract Start Date & End Date 3 VITMOA Business Area & Profit Center 4 VICERULE Valuation Rule ID & Asset Number […]

Continue reading »

Select in ABAP 7.40 and Above

Now you can use When Condition in select statement. select ERDAT, DMBTR, RTCUR, WF_STATUS, CASE WHEN WF_STATUS = ‘P’ THEN ‘IN-PRGORESS’ WHEN WF_STATUS = ‘C’ THEN ‘Complete’ END AS STATUS_CLAIM from ztest where ERNAM = SY-UNAME INTO TABLE @DATA(LT_TEST). When […]

Continue reading »

SAP Workflow BO Key

In SAP when ever a business object is triggered it have a KEY Ex- FIPP have Companycode/Document/Fiscal Year which makes a key. If you which to find the WI_ID based on the Key there is a Table SWW_WI2OBJ it provide […]

Continue reading »

SAP AdobeForm Logo

In Adobe forms Interface or Driver Program you need to call the Functional Module CALL METHOD cl_ssf_xsf_utilities=>get_bds_graphic_as_bmp   EXPORTING     p_object       = ‘GRAPHICS’     p_name         = lv_logoname     p_id           = ‘BMAP’   “‘BMON’     p_btype        = ‘BMON’   “‘BCOL’   RECEIVING     p_bmp          = xstring   EXCEPTIONS     not_found      = 1     internal_error = 2     OTHERS         = 3.P_ID &P_BTYPE depends on the type logo you wish to display. XSTRING Should be of […]

Continue reading »

SAP Adobe Form Translation

You can do the SAP Adobe form translation from SE63. You can also do translation from SFP, Open Form navigate Goto-> Translations once it open you need to double click on PDF-Based Forms for the 1st time you can select […]

Continue reading »
1 2 3 4 19