How to create "Help Value Request"

It will appear when user pressing F4 (help) on an input field to request list of available value.

To do this we are using function module F4IF_INT_TABLE_VALUE_REQUEST.

Credit: Sourav Bhaduri [https://answers.sap.com/questions/4287951/example-for-fm-f4ifinttablevaluerequest.html]

REPORT ztest123 .

TABLES: usr02.

parameters: p_bname LIKE usr02-bname,
p_class LIKE usr02-class.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_bname.
PERFORM f_valuerequest_vbeln.
*&---------------------------------------------------------------------*
*& Form f_valuerequest_vbeln
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM f_valuerequest_vbeln.

DATA: BEGIN OF t_data OCCURS 1,
data(20),
END OF t_data.

DATA: lwa_dfies TYPE dfies.

data h_field_wa LIKe dfies.
data h_field_tab like dfies occurs 0 with header line.
data h_dselc like dselc occurs 0 with header line.

SELECT * FROM usr02.
t_data = usr02-bname. APPEND t_data.
t_data = usr02-class. APPEND t_data.
ENDSELECT.

PERFORM f_fieldinfo_get USING 'USR02'
'BNAME'
CHANGING h_field_wa.
APPEND h_field_wa TO h_field_tab.
PERFORM f_fieldinfo_get USING 'USR02'
'CLASS'
CHANGING h_field_wa.
APPEND h_field_wa TO h_field_tab.

h_dselc-fldname = 'BNAME'.
h_dselc-dyfldname = 'P_BNAME'.
APPEND h_dselc.
h_dselc-fldname = 'CLASS'.
h_dselc-dyfldname = 'P_CLASS'.
APPEND h_dselc.

DATA: ld_repid LIKE sy-repid.
ld_repid = sy-repid.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
retfield = 'P_BNAME'
dynpprog = ld_repid
dynpnr = '1000'
dynprofield = 'P_BNAME'
* multiple_choice = ''
* value_org = 'S'
TABLES
value_tab = t_data
field_tab = h_field_tab
* return_tab = return_tab
DYNPFLD_MAPPING = h_dselc
EXCEPTIONS
OTHERS = 0.

ENDFORM. " f_valuerequest_vbeln
*&---------------------------------------------------------------------*
*& Form f_fieldinfo_get
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* -->P_0079 text
* -->P_0080 text
* <--P_H_FIELD_WA text
*----------------------------------------------------------------------*
FORM f_fieldinfo_get USING fu_tabname
fu_fieldname
CHANGING fwa_field_tab.


CALL FUNCTION 'DDIF_FIELDINFO_GET'
EXPORTING
TABNAME = fu_tabname
FIELDNAME = fu_fieldname
LFIELDNAME = fu_fieldname
IMPORTING
DFIES_WA = fwa_field_tab
EXCEPTIONS
NOT_FOUND = 1
INTERNAL_ERROR = 2
OTHERS = 3
.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.


ENDFORM. " f_fieldinfo_get

How to insert authority object to single role

AUTHORITY-CHECK OBJECT 'S_RZL_ADM'
     ID 'ACTVT' FIELD '03'.

Want : insert object "S_RZL_ADM" to Single Role "ZSERPGL_TMB_LIQUIDITY"

1. TCode : PFCG (Role Maintenance)

2. Input Role name and Click Edit

3. Select Tab Authorizations and Click Change Authorization

4. Click Manually and Insert Authorization Object "S_RZL_ADM"

How to post clearing with partial

ทำจ่าย Doc. Invoice (39) แบบ Partial

1. กรอก Document Date, Posting Date แล้วกด Choose open items

2. กรอก Customer ที่ช่อง Account แล้วเลือก Document Number (ถ้าทราบ Invoice Doc.)

    จากนั้นกดปุ่ม Process open items

3. กรอก Invoice Doc. แล้วกดปุ่ม Process open items

4. เลือก Tab Partial Pmt จากนั้นกรอกจำนวนเงินที่ต้องการจ่าย แล้วกดปุ่ม Display

    ปล. ถ้าเลือก Tab Standard จะเป็นการจ่ายเต็มจำนวน

5. กรอก Posting Key 40 (Debit GL) และกรอก GL Bank ในช่อง Account

6. กรอกจำนวนตามที่กรอกไปใน Tab Partial (ถ้าไม่ทราบให้กรอก * แล้ว Enter)

    จากนั้นให้เลือก Menu Tab Document > Simulate

7. กด Save จะได้เลขที่ Clearing Doc.

How to set and get value on table TVARVC

Set 

SM30 > Table/View = TVARV

GET

Function : Z_INITIAL_VALUE_GET

CLEAR gr_hkont.
  CALL FUNCTION 'Z_INITIAL_VALUE_GET'
    EXPORTING
*     IM_REPID = SY-CPROG
      im_filed = 'HKONT'
    TABLES
      tr_data  = gr_hkont.

How to add budget

Create Budget Document

Step 1: Tcode FMBBC
Step 2: Key data & Save

Release Budget Data

Step 1: Tcode FMMPRELE
Step 2: Key Data & Execute

No commitment item entered in item

Tcode : SPRO

Public Sector Management >
     Funds Management Government >
          Actual and Commitment Update/Integration >
               Activate/Deactivate Funds Management

Or Config at Tcode : FMDERIVE

Font Substritution

Courier New              MS Sans Serif
Courier              MS Sans Serif
Arial              Arial
Times New Roman      MS Sans Serif
Helv              MS Sans Serif
Tms Rmn      MS Sans Serif
Times              MS Sans Serif