Thursday, December 27, 2012
Download and Upload files in Application Server
Download file from Application server
Tcode: CG3Y
Upload files to Application Server
Tcode: CG3Z
Check files in AL11
Thursday, December 20, 2012
Dynamically make cell readonly in table web dynpro
Now assign to all the fields.
** condition for the editable or read only.
method WDDOINIT .
DATA lo_nd_mara TYPE REF TO if_wd_context_node.
DATA lt_mara TYPE wd_this->elements_mara.
DATA ls_mara TYPE wd_this->element_mara.
* navigate from <CONTEXT> to <MARA> via lead selection
lo_nd_mara = wd_context->get_child_node( name = wd_this->wdctx_mara ).
select matnr mtart mbrsh matkl meins from mara into corresponding fields of table lt_mara up to 10 rows.
loop at lt_mara into ls_mara where matnr = '000000000000000010' or
matnr = '000000000000000023' .
ls_mara-readonly = 'X'.
modify lt_mara from ls_mara transporting readonly where matnr = ls_mara-matnr.
endloop.
lo_nd_mara->bind_table( new_items = lt_mara set_initial_elements = abap_true ).
endmethod.
Done!.
Do Varying with Field symbols
call function 'HR_READ_INFOTYPE'
exporting
tclas = 'A'
pernr = iv_pernr
infty = '0027'
begda = iv_begda
endda = iv_endda
bypass_buffer = ' '
tables
infty_tab = lt_p0027
exceptions
infty_not_found = 1
others = 2.
if sy-subrc = 0.
read table lt_p0027 into ls_p0027 index 1.
do 12 times
varying lv_bukrs from ls_p0027-kbu01 next ls_p0027-kbu02 "25
varying lv_gsber from ls_p0027-kgb01 next ls_p0027-kgb02
varying lv_kostl from ls_p0027-kst01 next ls_p0027-kst02
varying lv_pkprz from ls_p0027-kpr01 next ls_p0027-kpr02
varying lv_fcenter from ls_p0027-fct01 next ls_p0027-fct02 "12
varying lv_fund from ls_p0027-fcd01 next ls_p0027-fcd02
varying lv_farea from ls_p0027-fkber01 next ls_p0027-fkber02
varying lv_grant from ls_p0027-grant01 next ls_p0027-grant02
varying lv_order from ls_p0027-auf01 next ls_p0027-auf02 " order 25
varying lv_wbs from ls_p0027-psp01 next ls_p0027-psp02 " wbs element 25
varying lv_segment from ls_p0027-sgm01 next ls_p0027-sgm02 " SEGMENT 12
varying lv_budget from ls_p0027-budget_pd01 next ls_p0027-budget_pd02." budget 12
clear lv_t1018.
ls_t1018-bukrs = lv_bukrs.
ls_t1018-gsber = lv_gsber.
ls_t1018-kostl = lv_kostl.
ls_t1018-prozt = lv_pkprz.
if ls_t1018-prozt is initial.
exit.
endif.
ls_t1018-fistl = lv_fcenter.
ls_t1018-fincode = lv_fund.
ls_t1018-fkber = lv_farea.
ls_t1018-grant_nbr = lv_grant.
ls_t1018-aufnr = lv_order.
ls_t1018-posnr = lv_wbs.
ls_t1018-sgmnt = lv_segment.
ls_t1018-budget_pd = lv_budget.
append ls_t1018 to lt_t1018.
enddo.
endif.
********************
code in Field Symbols : sample for 2 fields
********************
** dynamic get the field value.
field-symbols: <fs_burks> type any,
<fs_fcenter> type any.
data lv_index(2) type n.
data: s_burkr(5) type c value 'KBU ',
data s_fcenter(5) type c value 'FCT '.
read table lt_p0027 into ls_p0027 index 1.
do 12 times.
lv_index = sy-index.
s_burkr+3(2) = lv_index.
s_fcenter+3(2) = lv_index.
assign component s_burkr of structure ls_p0027 to <fs_burks>.
if <fs_burks> is assigned.
lv_bukrs = <fs_burks>.
endif.
assign component s_fcenter of structure ls_p0027 to <fs_fcenter>.
if <fs_fcenter> is assigned.
lv_fCenter = <fs_fcenter>.
endif.
ls_t1018-bukrs = lv_bukrs.
ls_t1018-fistl = lv_fcenter.
append ls_t1018 to lt_t1018.
end do.
Friday, November 23, 2012
Drop down in Table Web Dynpro
method wddoinit .
data lo_nd_status_drop type ref to if_wd_context_node.
data lt_status_drop type wd_this->elements_status_drop.
data ls_status_drop type wd_this->element_status_drop.
ls_status_drop-status_value = 'Resubmit All'.
append ls_status_drop to lt_status_drop.
ls_status_drop-status_value = 'Reject All'.
append ls_status_drop to lt_status_drop.
ls_status_drop-status_value = 'Approve All'.
append ls_status_drop to lt_status_drop.
data lo_nd_approval_mng type ref to if_wd_context_node.
data lo_element type ref to if_wd_context_element.
data lt_approval_mng type wd_this->elements_approval_mng.
data ls_approval_mng type wd_this->element_approval_mng.
data lv_status_value type wd_this->element_status_drop-status_value.
data lo_el_status_drop type ref to if_wd_context_element.
* navigate from <CONTEXT> to <APPROVAL_MNG> via lead selection
lo_nd_approval_mng = wd_context->get_child_node( name = wd_this->wdctx_approval_mng ).
* import the details of the table
lo_nd_approval_mng->get_static_attributes_table( importing table = lt_approval_mng ).
loop at lt_approval_mng into ls_approval_mng. " binding the drop down
lo_element = lo_nd_approval_mng->get_element( sy-tabix ).
lo_nd_status_drop = lo_element->get_child_node( 'STATUS_DROP' ).
lo_nd_status_drop->bind_table( new_items = lt_status_drop set_initial_elements = abap_true ).
endloop.
** set your values to the drop down
data lv_index type sytabix.
loop at lt_approval_mng into ls_approval_mng where status is not initial.
lv_index = sy-tabix.
lo_element = lo_nd_approval_mng->get_element( sy-tabix ).
lo_nd_status_drop = lo_element->get_child_node( 'STATUS_DROP' ).
lo_el_status_drop = lo_nd_status_drop->get_element( ).
case ls_approval_mng-status.
when 'KEEP'.
lv_status_value = 'Resubmit All'.
when 'REJ'.
lv_status_value = 'Reject All'.
when 'APPR'.
lv_status_value = 'Approve All'.
endcase.
* * set single attribute
lo_el_status_drop->set_attribute(
name = `STATUS_VALUE`
value = lv_status_value ).
modify lt_approval_mng from ls_approval_mng index lv_index
transporting status.
endloop.
endmethod.
data lo_nd_status_drop type ref to if_wd_context_node.
data lt_status_drop type wd_this->elements_status_drop.
data ls_status_drop type wd_this->element_status_drop.
ls_status_drop-status_value = 'Resubmit All'.
append ls_status_drop to lt_status_drop.
ls_status_drop-status_value = 'Reject All'.
append ls_status_drop to lt_status_drop.
ls_status_drop-status_value = 'Approve All'.
append ls_status_drop to lt_status_drop.
data lo_nd_approval_mng type ref to if_wd_context_node.
data lo_element type ref to if_wd_context_element.
data lt_approval_mng type wd_this->elements_approval_mng.
data ls_approval_mng type wd_this->element_approval_mng.
data lv_status_value type wd_this->element_status_drop-status_value.
data lo_el_status_drop type ref to if_wd_context_element.
* navigate from <CONTEXT> to <APPROVAL_MNG> via lead selection
lo_nd_approval_mng = wd_context->get_child_node( name = wd_this->wdctx_approval_mng ).
* import the details of the table
lo_nd_approval_mng->get_static_attributes_table( importing table = lt_approval_mng ).
loop at lt_approval_mng into ls_approval_mng. " binding the drop down
lo_element = lo_nd_approval_mng->get_element( sy-tabix ).
lo_nd_status_drop = lo_element->get_child_node( 'STATUS_DROP' ).
lo_nd_status_drop->bind_table( new_items = lt_status_drop set_initial_elements = abap_true ).
endloop.
** set your values to the drop down
data lv_index type sytabix.
loop at lt_approval_mng into ls_approval_mng where status is not initial.
lv_index = sy-tabix.
lo_element = lo_nd_approval_mng->get_element( sy-tabix ).
lo_nd_status_drop = lo_element->get_child_node( 'STATUS_DROP' ).
lo_el_status_drop = lo_nd_status_drop->get_element( ).
case ls_approval_mng-status.
when 'KEEP'.
lv_status_value = 'Resubmit All'.
when 'REJ'.
lv_status_value = 'Reject All'.
when 'APPR'.
lv_status_value = 'Approve All'.
endcase.
* * set single attribute
lo_el_status_drop->set_attribute(
name = `STATUS_VALUE`
value = lv_status_value ).
modify lt_approval_mng from ls_approval_mng index lv_index
transporting status.
endloop.
endmethod.
Monday, November 19, 2012
Hide the Fields in the Adobe form
Source filed, based on this we need to hide or display fields
//Select value from list
var raw = data.resolveNode("data.#subform[0].ISR_DDL_NoSelected").rawValue;
if(raw == 11)
{
data.resolveNode("data.#subform[0].#subform[3].#field[16]").presence = "visible";
data.resolveNode("data.#subform[0].#subform[3].#field[17]").presence = "visible";
}
else
{
data.resolveNode("data.#subform[0].#subform[3].#field[16]").presence = "hidden";
data.resolveNode("data.#subform[0].#subform[3].#field[17]").presence = "hidden";
}
add code there.(in events with scripts)
Target fields
Add also add the same code in FORMREADY of source field
Useful code in Adobe forms:
read values
var value = data.resolveNode("data.#subform[0].I0962_RSREA").rawValue;
check with message box.. for the values exists or not
xfa.host.messageBox(value);
//Select value from list
var raw = data.resolveNode("data.#subform[0].ISR_DDL_NoSelected").rawValue;
if(raw == 11)
{
data.resolveNode("data.#subform[0].#subform[3].#field[16]").presence = "visible";
data.resolveNode("data.#subform[0].#subform[3].#field[17]").presence = "visible";
}
else
{
data.resolveNode("data.#subform[0].#subform[3].#field[16]").presence = "hidden";
data.resolveNode("data.#subform[0].#subform[3].#field[17]").presence = "hidden";
}
add code there.(in events with scripts)
Target fields
Add also add the same code in FORMREADY of source field
Useful code in Adobe forms:
read values
var value = data.resolveNode("data.#subform[0].I0962_RSREA").rawValue;
check with message box.. for the values exists or not
xfa.host.messageBox(value);
Friday, October 26, 2012
Change Selection Text in Standard Program
DATA: it_tab TYPE TABLE OF rsseltexts.
DATA: is_tab TYPE rsseltexts.
is_tab-name = 'ZPARAMETER'. " parameter name
is_tab-kind = 'P'. " P/S type
is_tab-text = 'Manager'. " Description
APPEND is_tab TO it_tab.
CALL FUNCTION 'SELECTION_TEXTS_MODIFY'
EXPORTING
program = 'RCATS_DISPLAY_ACTIVITIES' " Report Name
TABLES
seltexts = it_tab
EXCEPTIONS
program_not_found = 1
program_cannot_be_generated = 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.
Tuesday, September 25, 2012
Function Modules for reading text descriptions
HOLIDAY_GET Provides a table of all the holidays based upon a Factory Calendar &/ Holiday Calendar.
HR_BEN_GET_FROM_FEATURE_BAREA Call the HR feature to determine the Benefit Area for an employee
HR_BEN_GET_FROM_FEATURE_BENGR Call the HR feature to determine the Benefit Group for an employee
HR_BEN_GET_FROM_FEATURE_BSTAT Call the HR feature to determine the Benefit Status for an employee
HR_BEN_GET_FROM_FEATURE_COVGR Call the HR feature to determine the Cover Group for an employee
HR_BEN_GET_FROM_FEATURE_CSTV1 Call the HR feature to determine the CSTV1 feature for an employee
HR_BEN_GET_FROM_FEATURE_EECGR Call the HR feature to determine the Employee Cost Group for an employee
HR_BEN_GET_FROM_FEATURE_ELIGR Call the HR feature to determine the Eligiblity Group for an employee
HR_BEN_GET_FROM_FEATURE_ERCGR Call the HR feature to determine the Employer Cost Group for an employee
HR_BEN_GET_FROM_FEATURE_EVTGR Evaluate the EVTGR feature for an employee
HR_BEN_GET_FROM_FEATURE_FLXGR Evaluate the FLXGR feature for an employee
HR_BEN_GET_FROM_FEATURE_LDAYW Evaluate the LDAYW feature for an employee
HR_BEN_GET_FROM_FEATURE_LRPGR Evaluate the LRPGR feature for an employee
HR_BEN_GET_FROM_FEATURE_TRMGR Evaluate the TRMGR feature for an employee
HR_BEN_GET_FROM_FEATURE_VARGU Evaluate the VARGU feature for an employee
HR_DISPLAY_BASIC_LIST is an HR function, but can be used for any data. You pass it data, and column headers, and it provides a table control with the ability to manipulate the data, and send it to Word or Excel. Also see the additional documentation here.
HR_GET_LEAVE_DATA Get all leave information (includes leave entitlement, used holidays/paid out holidays)
HR_IE_NUM_PRSI_WEEKS Return the number of weeks between two dates.
HR_INFOTYPE_OPERATION BAPI function module to create/change infotypes in HR
HRWPC_RFC_ABKRS_TEXT_GET Get text description for Payroll Area
HRWPC_RFC_ANRED_TEXT_GET Get text description for Title
HRWPC_RFC_ANSVH_TEXT_GET Get text description for Work Contract
HRWPC_RFC_BLAND_TEXT_GET Get text description for Tax Region
HRWPC_RFC_BTRTL_TEXT_GET Get text description for Personnel Subarea
HRWPC_RFC_BUKRS_TEXT_GET Get text description for Company Code
HRWPC_RFC_BVMRK_TEXT_GET Get text description for Processing indicator
HRWPC_RFC_COMTY_TEXT_GET Get text description for Type of control recipe destination
HRWPC_RFC_COUNC_TEXT_GET Get text description for County Code
HRWPC_RFC_CURCY_TEXT_GET Get text description for Currency Key
HRWPC_RFC_EVGRD_TEXT_GET Get text description for Evaluation Group
HRWPC_RFC_FAMEI_TEXT_GET Get text description for Family Characteristics
HRWPC_RFC_FAMST_TEXT_GET Get text description for Marital Status Key
HRWPC_RFC_FISTL_TEXT_GET Get text description for Funds Center
HRWPC_RFC_FREQU_TEXT_GET Get text description for Period
HRWPC_RFC_GEBER_TEXT_GET Get text description for Funds
HRWPC_RFC_GESCH_TEXT_GET Get text description for Gender Key
HRWPC_RFC_GSBER_TEXT_GET Get text description for Business Area
HRWPC_RFC_IT0XXX_TEXT_GET Get text stored on the infotype
HRWPC_RFC_JCODE_TEXT_GET Get text description for Survery Job
HRWPC_RFC_KOKRS_TEXT_GET Get text description for Controlling Area
HRWPC_RFC_KONFE_TEXT_GET Get text description for Religious Denomination Key
HRWPC_RFC_KOSTL_TEXT_GET Get text description for Cost Center
HRWPC_RFC_LAND_TEXT_GET Get text description for Country of company
HRWPC_RFC_MASSG_TEXT_GET Get text description for Reason for Action
HRWPC_RFC_MASSN_TEXT_GET Get text description for Action Type
HRWPC_RFC_MOLGA_TEXT_GET Get text description for Country Grouping
HRWPC_RFC_NAMZ2_TEXT_GET Get text description for Name Affix for Name at Birth
HRWPC_RFC_NAMZU_TEXT_GET Get text description for Other Title
HRWPC_RFC_NATIO_TEXT_GET Get text description for Nationality
HRWPC_RFC_ORGEH_TEXT_GET Get text description for Organizational Unit
HRWPC_RFC_OTYPE_TEXT_GET Get text description for Object Type
HRWPC_RFC_PERSG_TEXT_GET Get text description for Employee Group
HRWPC_RFC_PERSK_TEXT_GET Get text description for Employee Subgroup
HRWPC_RFC_PLANS_TEXT_GET Get text description for Position
HRWPC_RFC_PLVAR_TEXT_GET Get text description for Plan Version
HRWPC_RFC_RAILW_TEXT_GET Get text description for Social Subscription Railway
HRWPC_RFC_SACHX_TEXT_GET Get text description for Administrator
HRWPC_RFC_SPRSL_TEXT_GET Get text description for Language Key
HRWPC_RFC_STATV_TEXT_GET Get text description for Statistics indicator for pensions
HRWPC_RFC_STELL_TEXT_GET Get text description for Job
HRWPC_RFC_STRDS_TEXT_GET Get text description for Street Abbreviation
HRWPC_RFC_SUBTY_0XXX_TEXT_GET Get text description for Subtype
HRWPC_RFC_SUBTY_1XXX_TEXT_GET Get text description for Subtype
HRWPC_RFC_TITEL_TEXT_GET Get text description for Title
HRWPC_RFC_TITL2_TEXT_GET Get text description for Second Title
HRWPC_RFC_TMART_TEXT_GET Get text description for Task Type
HRWPC_RFC_VDSK1_TEXT_GET Get text description for Organizational Key
HRWPC_RFC_VORS2_TEXT_GET Get text description for Second Name Prefix
HRWPC_RFC_VORSW_TEXT_GET Get text description for Name Prefix
HRWPC_RFC_WERKS_TEXT_GET Get text description for Personnel Area
INIT_TEXT To load long text into SAP
K_WERKS_OF_BUKRS_FIND Return a list of all plants for a given company code.
LIST_FROM_MEMORY Retrieves the output of a report from memory when the report was executed using SUBMIT... EXPORTING LIST TO MEMORY. See also WRITE_LIST.
LIST_TO_ASCII convert an ABAP report (displayed on screen) from OTF to ASCII format
MBEW_EXTEND Get the stock position for the previous month. This displays the same info that you see in MM03.
MONTH_NAMES_GET It returns all the month and names in repective language.
MONTH_PLUS_DETERMINE Add or subtract months from a date. To subtract a month, enter a negative value for the 'months' parameter.
Subscribe to:
Posts (Atom)