Generic SAP Replacements

The results of the replacements are stored in the Rule_TaskDetails.txt JobFile attached to the process.

Fiscal Period Information - ${FP:<req>}

With this replacement you can access the fiscal period information synchronized from your SAP target system. Additionally, information is available for the previous and next period.

The replacement depends on the parameters SAP_SYSTEMS, CLIENT, TASKLIST_PERIOD, TASKLIST_YEAR, BUKRS, KOKRS to provide the right context to retrieve the information.

Table Maintenance

The replacements use the Redwood Finance Automation table FCA_SAP_FiscalPeriods which can be synchronized with your SAP system using the FCA_SAP_OrgStructure_Synchronize robot.

Syntax

${FP:<context>_<sequence><range><request>}

• <context> - Context in which to retrieve the information; accepts CA (Controlling Area), CC (Company Code), or FY (Fiscal Year).
• <sequence> - Sequence of <range>; C (Current), P (Previous), N (Next), F (First, requires <range> to be set to P), L (Last, requires <range> to be set to P).
• <range> - Context in which to retrieve <request>; accepts P (Period), Y (Year), F (First, requires <request> to be set to P), or L (Last, requires <request>).
• <request> - Requested datum type to be returned; accepts P (Period), Y (Year), Q (Quarter), F (First day), L (Last day).

The following <sequence><range><request> combinations are supported in conjunction with the sources ( CA, CC, FY ):

• CFP - Returns the first period of the current fiscal year.
• CLP - Returns the last period of the current fiscal year.
• CPF - Returns the first day of the current period.
• CPL - Returns the last day of the current period.
• CPP - Returns the current period.
• CPQ - Returns the quarter of the current period.
• CPY - Returns the year of the current period.
• CYF - Returns the first day of the current fiscal year.
• CYL - Returns the last day of the current fiscal year.
• CYY - Returns the current fiscal year.
• FPP - Returns the first period of the current fiscal year.
• FPY - Returns the year of the first period.
• LPP - Returns the period of the last period.
• LPY - Returns the year of the last period.
• NFP - Returns the first period of the next fiscal year.
• NLP - Returns the last period of the next fiscal year.
• NPF - Returns the first day of the next period.
• NPL - Returns the last day of the next period.
• NPP - Returns the period of the next period.
• NPQ - Returns the quarter of the next period.
• NPY - Returns the year of the next period.
• NYF - Returns the first day of the next fiscal year.
• NYL - Returns the last day of the next fiscal year.
• NYY - Returns the year of the next fiscal year.
• PFP - Returns the first period of the previous fiscal year.
• PLP - Returns the last period of the previous fiscal year.
• PPF - Returns the first day of the previous period.
• PPL - Returns the last day of the previous period.
• PPP - Returns the period of the previous period.
• PPQ - Returns the quarter of the previous period.
• PPY - Returns the year of the previous period.
• PYF - Returns the first day of the previous fiscal year.
• PYL - Returns the last day of the previous fiscal year.
• PYY - Returns the year of the previous fiscal year.

Example

In this example, the current fiscal year is 2017; the following table contains the replacement expressions using company code ( CC ) and the resulting values.

Parameter	Value
${FP:CC_CFP}	001
${FP:CC_CLP}	0-1
${FP:CC_CPF}	20171101
${FP:CC_CPL}	20171130
${FP:CC_CPP}	011
${FP:CC_CPQ}	4
${FP:CC_CPY}	2017
${FP:CC_CYF}	20170101
${FP:CC_CYL}	20171231
${FP:CC_CYY}	2017
${FP:CC_FPP}	001
${FP:CC_FPY}	2017
${FP:CC_LPP}	012
${FP:CC_LPY}	2017
${FP:CC_NFP}	001
${FP:CC_NLP}	012
${FP:CC_NPF}	20171201
${FP:CC_NPL}	20171231
${FP:CC_NPP}	012
${FP:CC_NPQ}	4
${FP:CC_NPY}	2017
${FP:CC_NYF}	20180101
${FP:CC_NYL}	20181231
${FP:CC_NYY}	2018
${FP:CC_PFP}	001
${FP:CC_PLP}	012
${FP:CC_PPF}	20171001
${FP:CC_PPL}	20171031
${FP:CC_PPP}	010
${FP:CC_PPQ}	4
${FP:CC_PPY}	2017
${FP:CC_PYF}	20160101
${FP:CC_PYL}	20161231
${FP:CC_PYY}	2016

SAP User data - ${SU:<?>}

With this replacement you have access to data specific to the User.

Table Maintenance

The replacements use the Redwood Finance Automation table FCA_SAP_LocalUserDetails which can be synchronized with your SAP system using the FCA_SAP_UserDetails_Synchronize robot.

Syntax

${SU:<parameter>}

Parameter	Description
AMOUNT,<Value>,[inUser]	Returns a formatted amount from a provided amount which can be formatted differently (as it is created for another user (inUser)).
DATE[,<inBatchDate>]	Returns a formatted date. If an input Batch date (YYYYMMDD) is provided it is converted. If not, then the current date is used.
TIME[,<inBatchTime>]	Returns a formatted time. If an input Batch time (HHMMSS) is provided it is converted. If not, then the current time is used.
EMAIL	Returns the eMail address of the user.
PHONE	Returns the phone number of the user.
NAME	Returns the name of the user.

Example

The following returned 12.03.2018 as the current date.

${SU:DATE}

The following returned 12:34:56 as the current time.

${SU:TIME}

SAP TVARV/C Parameter value - ${TP:<name>}

Returns the Parameter value defined in tables TVARVC and TVARV accordingly.

Table Maintenance

The replacements use the Redwood Finance Automation table FCA_SAP_TvarvParameters which can be synchronized with your SAP system using the FCA_SAP_TvarvParameters_Synchronize robot.

Syntax

${TP:<name>}

Parameter	Description
<name>	Returns the value specified as type=P

Example

The following example returned 1000 on this system:

${TP:SAP_FAST_CLOSE_KOKRS_P}

SAP TVARV/C Select Option value - ${TS:<name>}

Returns the Select Option value defined in tables TVARVC and TVARV accordingly.

Table Maintenance

The replacements use the Redwood Finance Automation table FCA_SAP_TvarvParameters which can be synchronized with your SAP system using the FCA_SAP_TvarvParameters_Synchronize robot.

Syntax

${TS:<name>}

Parameter	Description
<name>	Returns the value specified as type=S converted so that it can be used for select-options in temporary variants. Surrounding [] are not added.

Example

The following example returned 2017-2017 on this system.

${TS:SAP_FAST_CLOSE_GJAHR_S}

See Also

Usage of Replacements

financeTopic