Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-WHM-DBA (Application Component) Data Basis⤷
RSB (Package) Business Information Warehouse: Data Marts
Basic Data
| Data Element | RSBWRITEMODE |
| Short Description | Open Hub: Database Table Write Mode |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | RSBWRITEMODE | |
| 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 | Mode |
| Medium | 15 | Write Mode |
| Long | 35 | Database Table Write Mode |
| Heading | 35 | Database Table Write Mode |
Documentation
Definition
Write mode into the database table for an Open Hub Destination
Use
The write mode has two characteristic values:
- Delete Table before Extraction is deactivated
In this case, the extracted data records are added to the database table using an 'INSERT'. Any structural differences between the database table and extracted data are bridged using a 'MOVE-CORRESPONDING', which involves combining fields which have the same name. BEWARE: Where a record is extracted with the same key as a record already in the system, a short cump occurs due to the presence of duplicate records. We recommend this record when wanting to keep a history of the extracted data.
- Delete Table before Extraction activated
In this case, the table is completely deleted and then regenerated before extraction takes place. Structural changes made in the template structures are copied into the InfoSpoke template structures. The insertion of duplicate records is thus implicitly avoided. We recommend this mode when a data history is not to be stored in the table.
Dependencies
Example
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 30A |
