Finance Automation SAP Contraint REL Functions

The following SAP Constraint REL functions are used in the SAP flavors. The functions reside in the Redwood_FCA library. You call these functions by specifying =Constraint.pairListConstraint('<column1>,<column2>',<partition>.Redwood_FCA.<function>) or =Constraint.listConstraint('<column>',<partition>.Redwood_FCA.<function>) in the Simple Constraint Data field of constraints of type Expression. The examples on this page assume the definition which calls these functions resides in the same partition as the library, specified as $. The default partition of the library is FCA. The REL functions can be accessed via RedwoodScript from the com.redwood.scheduler.custom.fl.sap.rel.FlSapConstraints class.

getSAPApplicationLogOptions

Retrieve a list of SAP Application Log options for use in a constraint.

Syntax

Redwood_FCA.getSAPApplicationLogOptions()

Returns String

Example

=Constraint.listConstraint('Name',$.Redwood_FCA.getSAPApplicationLogOptions())

Result

Returns list of SAP Application Log options:

• Standard
• None
• PDF
• XLS
• HTML
• Text

getSAPApplicationLogOptionsCheck

Validate a list of SAP Application Log options for use in a constraint.

Syntax

Redwood_FCA.getSAPApplicationLogOptionsCheck(String input)

Returns boolean

Example

=Constraint.listConstraint('Name',$.Redwood_FCA.getSAPApplicationLogOptions(), $.Redwood_FCA.getSAPApplicationLogOptionsCheck(value))

Result

Returns list of SAP Application Log options:

• Standard
• None
• PDF
• XLS
• HTML
• Text

getSAPBdcExecutionOptionPairs

Retrieve a list of SAP BDC execution options with descriptions for use in a constraint.

Syntax

Redwood_FCA.getSAPBdcExecutionOptionPairs()

Returns String

Example

=Constraint.pairListConstraint('Name,Description',$.Redwood_FCA.getSAPBdcExecutionOptionPairs())

Result

Returns list of SAP BDC execution option to choose from:

• BDC_CREATION - Replace with target Batch Input name
• BDC_CALL_TRAN - Call Transaction (errors in Batch Input)
• BDC_CALL_USER - Call Transaction for other user
• BDC_CALL_BAPI - Call Bapi (errors in Batch Input)
• BDC_CALL_CHECK - Simulation only

getSAPBdcExecutionOptions

Retrieve a list of SAP BDC execution options for use in a constraint.

Syntax

Redwood_FCA.getSAPBdcExecutionOptions()

Returns String

Example

=Constraint.listConstraint('Name',$.Redwood_FCA.getSAPBdcExecutionOptions())

Result

Returns list of SAP BDC execution options ( <BDC_CREATION>, <BDC_CALL_TRAN>, <BDC_CALL_USER>, <BDC_CALL_BAPI>, and <BDC_CALL_CHECK>) to select from on this system.

getSAPJobLogOptions

Retrieve a list of SAP JobLog options for use in a constraint.

Syntax

Redwood_FCA.getSAPJobLogOptions()

Returns String

Example

=Constraint.listConstraint('Name',$.Redwood_FCA.getSAPJobLogOptions())

Result

Returns list of SAP JobLog options:

• Standard
• None
• PDF
• Text

getSAPOutputOptionPairs

Retrieve a list of SAP output options with description for use in a constraint.

Syntax

Redwood_FCA.getSAPOutputOptionPairs()

Returns String

Example

=Constraint.pairListConstraint('Name,Description',$.Redwood_FCA.getSAPOutputOptionPairs())

Result

Returns list of SAP output options:

• Standard - Standard output format
• None - No transaction output
• XLSX - "Excel 2007 output format
• PDF - PDF output format
• HTML HTML output format
• Text - Text output format
• RAW - Raw output format
• XLS - Excel 97 output format
• RTX - RTX output format

getSAPOutputOptions

Retrieve a list of SAP output options for use in a constraint.

Syntax

Redwood_FCA.getSAPOutputOptions()

Returns String

Example

=Constraint.listConstraint('Name',$.Redwood_FCA.getSAPOutputOptions())

Result

Returns list of SAP output options:

• Standard
• None
• XLSX
• PDF
• HTML
• Text
• RAW
• XLS
• RTX

getSAPOutputOptionsCheck

Validate a list of SAP output options for use in a constraint.

Syntax

Redwood_FCA.getSAPOutputOptionsCheck(String input)

Returns boolean

Example

=Constraint.listConstraint('Name',$.Redwood_FCA.getSAPOutputOptionPairs(), $.Redwood_FCA.getSAPOutputOptionCheck(value))

Result

Returns list of SAP output options:

• Standard
• None
• XLSX
• PDF
• HTML
• Text
• RAW
• XLS
• RTX

getSAPSystemClients

Retrieve a list of SAP Client Descriptions and SAP Clients for use in a constraint.

Syntax

Redwood_FCA.getSAPSystemClients(String sapSystem)

Returns String

Example

=Constraint.pairListConstraint('Name,Description',$.Redwood_FCA.getSAPSystemClients('PR1'))

Result

Returns list of SAP Clients for SAP System PR1 to select from on this system.

getSAPSystemsDescription

Retrieve a list of SAP System Descriptions and SAP Systems for use in a constraint.

Syntax

Redwood_FCA.getSAPSystemsDescription()

Returns String

Example

=Constraint.pairListConstraint('Name,Description',$.Redwood_FCA.getSAPSystemsDescription())

Result

Returns list of SAP Systems to select from on this system.

financeTopic