Altbestand / Detail

import / iwm_articles_kojen

Mandant local-safety-smoke
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_articles_kojen
     GetQuery:   SELECT LBFIRM,
                        LBSPAR,
                        LBVKHS,
                        LBARTE, LBAPNR, LBLAPP, LBLAGN
                  FROM IWMV2R1DTA.LBST01
                  WHERE LBDISP = 'K'
                  GROUP BY LBFIRM, LBSPAR, LBVKHS, LBARTE, LBAPNR, LBLAPP, LBLAGN
                  HAVING LBLAPP Is Not Null

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_articles_kojen", "GetQuery": "SELECT LBFIRM, LBSPAR, LBVKHS, LBARTE, LBAPNR, LBLAPP, LBLAGN FROM IWMV2R1DTA.LBST01 WHERE LBDISP = 'K' GROUP BY LBFIRM, LBSPAR, LBVKHS, LBARTE, LBAPNR, LBLAPP, LBLAGN HAVING LBLAPP Is Not Null" } } ]