Altbestand / Detail

import / import_iwm_atab00

Mandant connection-overlay-smoke-20260406
Altbestand
Managed Definition öffnen
engine Typ
valid Parse-Status
Managed Status
draft
importEngine Kurzinfo

Raw YAML

Dateiinhalt

Engine: Import
Source_Config: oster400_adminecomm
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService

Queries:
 - Query:
     TargetDatapool: iwm_atab00
     GetQuery: SELECT
                 CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(ATFIRM,'-'),ATLINR),'-'),ATSYSN),'-'),ATAA01),'-'),ATAFNR) as tab_key,
                 ATFIRM,
                 ATLINR,
                 ATSYSN,
                 ATAFNR,
                 TRIM(ATKUBZ) as ATKUBZ,
                 TRIM(ATLABZ) as ATLABZ,
                 TRIM(ATZUBZ) as ATZUBZ,
                 ATPGRP
               from IWMV2R1DTA.ATAB00 WHERE ATSTAT = 'A'

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Engine Import
Source_Config oster400_adminecomm
Target_Config importEngine
Mysql_Engine InnoDB
Default_Charset latin1
Source_Connection_Type database
Source_Database_Connection_Service DatabaseConnectionService
Queries [ { "Query": { "TargetDatapool": "iwm_atab00", "GetQuery": "SELECT CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(ATFIRM,'-'),ATLINR),'-'),ATSYSN),'-'),ATAA01),'-'),ATAFNR) as tab_key, ATFIRM, ATLINR, ATSYSN, ATAFNR, TRIM(ATKUBZ) as ATKUBZ, TRIM(ATLABZ) as ATLABZ, TRIM(ATZUBZ) as ATZUBZ, ATPGRP from IWMV2R1DTA.ATAB00 WHERE ATSTAT = 'A'" } } ]