C-LANG Statements › PARAM Statement—Specify Data Selection Criteria (SAP Jobs)

PARAM Statement—Specify Data Selection Criteria (SAP Jobs)

The PARAM statement specifies the Business Warehouse InfoPackage data selection criteria.

Supported Job Type

This statement is optional for the SAP Business Warehouse InfoPackage job type.

Syntax

This statement has the following format:

PARAM FieldName, {ObjectName|""}, {Sign|""}, {Operation|""}, {LowValue|""}, {HighValue|""}

FieldName

Specifies the Business Warehouse InfoPackage Technical Name.

Limits: Up to 30 valid SAP characters; case-sensitive

ObjectName

Specifies the Business Warehouse InfoPackage InfoObject.

Limits: Up to 30 valid SAP characters; case-sensitive

Note: If no value is assigned to ObjectName, use two double quotation marks ("") as a place holder.

Sign

Specifies the Business Warehouse InfoPackage Sign. Options are the following:

• I—Specifies include.
• E—Specifies exclude.

Note: If no value is assigned to Sign, use two double quotation marks ("") as a place holder.

Operation

Specifies the Business Warehouse InfoPackage Operation. Options are the following:

• BT—Specifies between.
• E—Specifies equal.

Note: If no value is assigned to Operation, use two double quotation marks ("") as a place holder.

LowValue

Specifies the Business Warehouse InfoPackage From Value.

Note: If no value is assigned to LowValue, use two double quotation marks ("") as a place holder.

HighValue

Specifies the Business Warehouse InfoPackage To Value.

Note: If no value is assigned to HighValue, use two double quotation marks ("") as a place holder.

Notes:

• To specify multiple data selection criteria, define a PARAM statement for each set of criteria. Each set of criteria represents a row in the SAP table.
• The value of each statement can be up to 4070 characters.
• The fields on the PARAM statement correspond to the fields on the SAP Administrator Workbench RSA1 transaction.

Example: Specify Multiple Data Selection Criteria

In this example, the data selection criteria for the FieldNames (SAP InfoObjects) /BIC/IO_CMAT, CALDAY, /BIC/ IO_CCUST, and /BIC/IO_CSREP are defined for InfoPackage ZPAK_42RRVI7G0PA005H00BV0ZJV9I on the SAP system.

For the /BIC/IO_CMAT and CALDAY FieldNames, values are provided for each operand.

For the /BIC/IO_CCUST FieldName, double quotation marks are used as place markers for ObjectName, Sign, and Operation.

For the /BIC/IO_CSREP FieldName, double quotation marks are used as place markers for ObjectName, Sign, Operation, LowValue, and HighValue.

AGENT SAPHTNTAGENT
SAPJOBNAME IP05
INFOPACK 'ZPAK_42RRVI7G0PA005H00BV0ZJV9I'
RFCDEST bw2
PARAM /BIC/IO_CMAT, IO_CMAT, I, BT, MAT001, MAT002
PARAM CALDAY, 0CALDAY, I, BT, 20010101, 20050101
PARAM /BIC/IO_CCUST, "", "", "", CUST001,CUST003
PARAM /BIC/IO_CSREP, "", "", "", "", ""