Legacy YAML iwm_articles_new_bssp_and_aslf

Legacy-Definition sicher vergleichen

Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.

Zum Raw YAML Zu den Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

importEngine Kurzinfo

Raw YAML

Dateiinhalt

Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.

Engine: Import
Source_Config: oster400_adminecomm
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
#verkaufshaus is always set to 0 to have a propper match in the join of unitizing
#all articles with a bestellsperre or auslauf in either verkaufshaus = 96 or verkaufshaus = 0 should be excluded in the following process logic
Queries:
 - Query:
     TargetDatapool: iwm_articles_new_bssp_and_auslauf
     GetQuery: SELECT AMFIRM as firma,
                       CASE AMAPNR
                       WHEN 0
                         THEN CAST(AMARTE AS VARCHAR(10))
                       ELSE CONCAT(CONCAT(CAST(AMARTE AS VARCHAR(10)),'-'),AMAPNR)
                       END       AS ordernumber,
                       AMAPNR,
                       AMARTE,
                       AMVKHS as verkaufshaus,
                       AMASLF as auslauf,
                       AMBSSP as bestellsperre
               FROM IWMV2R1DTA.ARVK00 arvk
               WHERE
                 arvk.AMSTAT = 'A' AND
                 arvk.AMDGBM >= 1 and
                 arvk.AMDGBM <=12 and
                 arvk.AMDGAM >= 1 and
                 arvk.AMDGAM <=12 and
                 arvk.AMDGAT >=1 and
                 arvk.AMDGAT <=31 and
                 arvk.AMDGBT >=1 and
                 arvk.AMDGBT <=31 and
                 (arvk.AMVKHS = 0 or arvk.AMVKHS = 96 or arvk.AMVKHS = 97 or arvk.AMVKHS = 86 or arvk.AMVKHS = 87) and
                 TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk.AMDGBT, '-'), arvk.AMDGBM), '-'), arvk.AMDGBJ), 'DD-MM-YYYY')
                 >= CURRENT_DATE AND
                 TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk.AMDGAT, '-'), arvk.AMDGAM), '-'), arvk.AMDGAJ), 'DD-MM-YYYY')
                 <= CURRENT_DATE AND
                 TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk.AMDGAT, '-'), arvk.AMDGAM), '-'), arvk.AMDGAJ), 'DD-MM-YYYY')
                 = (SELECT DISTINCT (max(TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk2.AMDGAT, '-'), arvk2.AMDGAM), '-'), arvk2.AMDGAJ), 'DD-MM-YYYY'))) as maxdatega
                    FROM IWMV2R1DTA.ARVK00 as arvk2
                    WHERE  arvk2.AMSTAT = 'A' AND
                           arvk2.AMDGBM >= 1 and
                           arvk2.AMDGBM <=12 and
                           arvk2.AMDGAM >= 1 and
                           arvk2.AMDGAM <=12 and
                           arvk2.AMDGAT >=1 and
                           arvk2.AMDGAT <=31 and
                           arvk2.AMDGBT >=1 and
                           arvk2.AMDGBT <=31 and
                           (arvk2.AMVKHS = 0 or arvk2.AMVKHS = 96 or arvk2.AMVKHS = 97 or arvk2.AMVKHS = 86 or arvk2.AMVKHS = 87) and
                           TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk2.AMDGAT, '-'), arvk2.AMDGAM), '-'), arvk2.AMDGAJ), 'DD-MM-YYYY') <= CURRENT_DATE and
                           TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk2.AMDGBT, '-'), arvk2.AMDGBM), '-'), arvk2.AMDGBJ), 'DD-MM-YYYY') >= CURRENT_DATE
                           and arvk2.AMFIRM = arvk.AMFIRM and arvk2.AMARTE = arvk.AMARTE and arvk2.AMAPNR = arvk.AMAPNR and arvk2.AMVKHS = arvk.AMVKHS
                    GROUP BY arvk2.AMFIRM, arvk2.AMARTE, arvk2.AMVKHS, arvk2.AMAPNR
                 )

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_new_bssp_and_auslauf", "GetQuery": "SELECT AMFIRM as firma, CASE AMAPNR WHEN 0 THEN CAST(AMARTE AS VARCHAR(10)) ELSE CONCAT(CONCAT(CAST(AMARTE AS VARCHAR(10)),'-'),AMAPNR) END AS ordernumber, AMAPNR, AMARTE, AMVKHS as verkaufshaus, AMASLF as auslauf, AMBSSP as bestellsperre FROM IWMV2R1DTA.ARVK00 arvk WHERE arvk.AMSTAT = 'A' AND arvk.AMDGBM >= 1 and arvk.AMDGBM <=12 and arvk.AMDGAM >= 1 and arvk.AMDGAM <=12 and arvk.AMDGAT >=1 and arvk.AMDGAT <=31 and arvk.AMDGBT >=1 and arvk.AMDGBT <=31 and (arvk.AMVKHS = 0 or arvk.AMVKHS = 96 or arvk.AMVKHS = 97 or arvk.AMVKHS = 86 or arvk.AMVKHS = 87) and TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk.AMDGBT, '-'), arvk.AMDGBM), '-'), arvk.AMDGBJ), 'DD-MM-YYYY') >= CURRENT_DATE AND TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk.AMDGAT, '-'), arvk.AMDGAM), '-'), arvk.AMDGAJ), 'DD-MM-YYYY') <= CURRENT_DATE AND TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk.AMDGAT, '-'), arvk.AMDGAM), '-'), arvk.AMDGAJ), 'DD-MM-YYYY') = (SELECT DISTINCT (max(TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk2.AMDGAT, '-'), arvk2.AMDGAM), '-'), arvk2.AMDGAJ), 'DD-MM-YYYY'))) as maxdatega FROM IWMV2R1DTA.ARVK00 as arvk2 WHERE arvk2.AMSTAT = 'A' AND arvk2.AMDGBM >= 1 and arvk2.AMDGBM <=12 and arvk2.AMDGAM >= 1 and arvk2.AMDGAM <=12 and arvk2.AMDGAT >=1 and arvk2.AMDGAT <=31 and arvk2.AMDGBT >=1 and arvk2.AMDGBT <=31 and (arvk2.AMVKHS = 0 or arvk2.AMVKHS = 96 or arvk2.AMVKHS = 97 or arvk2.AMVKHS = 86 or arvk2.AMVKHS = 87) and TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk2.AMDGAT, '-'), arvk2.AMDGAM), '-'), arvk2.AMDGAJ), 'DD-MM-YYYY') <= CURRENT_DATE and TO_DATE(CONCAT(CONCAT(CONCAT(CONCAT(arvk2.AMDGBT, '-'), arvk2.AMDGBM), '-'), arvk2.AMDGBJ), 'DD-MM-YYYY') >= CURRENT_DATE and arvk2.AMFIRM = arvk.AMFIRM and arvk2.AMARTE = arvk.AMARTE and arvk2.AMAPNR = arvk.AMAPNR and arvk2.AMVKHS = arvk.AMVKHS GROUP BY arvk2.AMFIRM, arvk2.AMARTE, arvk2.AMVKHS, arvk2.AMAPNR )" } } ]