Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-WHM-DST (Application Component) Data Staging⤷
RSAOLTP (Package) OLTP Metadata <-> BW Metadata Interface
Basic Data
| Data Element | RSDUPREC |
| Short Description | Flag: DataSource returns duplicate records |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | RSDUPREC | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Dup. recs. |
| Medium | 15 | Duplicate recs. |
| Long | 40 | DataSource Delivers Duplicate Records |
| Heading | 3 | DUP |
Documentation
Definition
This indicator gives information on how the DataSource behaves within a request with regard to duplicate records:
' ' The status of the DataSource is unknown.
'0' The DataSource does not deliver any duplicate records within a request, with reference to its key.
'1' The DataSource can deliver duplicate records within a request, with reference to its key. However, no duplicate records are delivered in a data package.
This indicator is particularly important for delta-capable attribute tables and text tables.
For the settings '0' and '1' you also have to define a key for the DataSource. This can be either in the DDIC using the maintenance for the corresponding field property of the extract structure fields, or (alternatively or additionally) in the metadata of the Datasource. A field in the DataSource also has the additional attribute 'DataSource Key Field', which transfersor corrects the DDIC property where necessary.
Use
For a key of time-independent master data or time-independent texts, DataSources can transfer to BW several data records in a request. If data records are transferred to the BW system more than once within a request, this can be the result of the application and you should not see it as an error. In a master data update, the BW system provides functions to handle duplicate data records. When data is loaded into another data target, the corresponding handling must be coded manually, preferably in the end routine of the transformation.
Dependencies
The DataSource carries information about whether there are potentially any duplicate records in the request. If you are loading into an InfoObject, you can deffine the behavior of the sytsem for duplicate data records in the data transfer process or in the InfoPackage (3.x).
Example
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 30A |
