Importing a business object without a unique key field (Budget)
In order to import the budget, the budget category needs to be identified by Code and Financial year, because the same code can exist over many financial years.
Field configuration
Business Object level | Import policy | Field | Field as … | Part of search key? |
|---|
Budget | Create/update | | | |
| | Code | | No |
| | BudgetSize | | No |
| | Description | | No |
| | BudgetCategory | Sub | No |
BudgetCategory | Skip | | | |
| | Code | | Yes |
| | FinancialYearRef | | Yes |
Input file
<?xml version="1.0" encoding="UTF-8"?>
<document>
<businessobjects>
<Budget>
<BudgetSize>10000.00</BudgetSize>
<Code>15</Code>
<Description>Maintenance budget</Description>
<BudgetCategory>
<Code>0002</Code>
<FinancialYearRef>2011</FinancialYearRef>
</BudgetCategory>
</Budget>
</businessobjects>
</document>
The result will be a budget “15-Maintenance budget” linked to the budget category 0002 of financial year 2011.