DB Selection

Connector Type DB Selection is used to call Database Validation Rulesets on remote SAP Backend systems. It follows principle of passing input in a XML representation package into common Connector envelope:

XML

<DBSelection name="DBRULE" rfcdest="ED1">
  <VariablesSet>
    <VAR1>
      <Value>1000</Value>
    </VAR1>
    <VAR2>
      <Value>ABC</Value>
    </VAR2>
  </VariablesSet>
</DBSelection>

Key values to be passed in the call:

@name - name of the Database Validation Ruleset
@rfcdest - RFC Destination pointing to the system when Database Validation Ruleset must be executed - passed from Business Object template in field DESTINATION
VariablesSet - variables are leveraged by the Database Validation Rulesets as condition values in where statements. VAR1 and VAR2 in above example are Variable names that are used in Database Validation Ruleset.

Result of DB Selection Connector execution are return in format as below:

XML

<DBSelection name="BOAPOLIST" rfcdest="ED1">
	<Result>
		<DATA>
			<EKKO>
				<item>
					<EBELN>4500017208</EBELN>
					<BUKRS>3000</BUKRS>
					<AEDAT>2025-10-05</AEDAT>
					<EKPO>
						<item>
							<EBELN>4500017208</EBELN>
							<EBELP>00001</EBELP>
						</item>
						<item>
							<EBELN>4500017208</EBELN>
							<EBELP>00002</EBELP>
						</item>			
					</EKPO>					
				</item>
			</EKKO>
		</DATA>
	</Result>
</DBSelection>

Relation between tables build in Database Validation Ruleset is reflected in the results. In above example table EKKO is a parent of table EKPO. Resulting fields and and tables are fully controlled from Database Validation Ruleset.

DB Selection Connector specific parameters:

Parameter Counter	Parameter Function
1	Database Validation Ruleset name