Beim Wechsel auf Release 4.9 sind zusätzlich zu den Allgemeinen Hinweisen noch folgende Punkte zu beachten.

Zuordnung neuer Kindtabellen

IAG_RAT

• IAG_RAT6
  

IAG_WAS

• IAG_WAS9
  

IAG_WRK

• IAG_WRK2
• IAG_WRK4
• IAG_WRK5
• IAG_WRK6
  

*Die folgenden Änderungen sollten vom Upgrade-Wizard vollautomatisch angewendet werden. Die manuelle Durchführung ist nur nötig falls während des Upgrade-Prozesses Fehler auftreten.

Vorbelegung für neue Datenbankfelder in bestehenden Tabellen

HANA

update
    "@IAG_ERS0"
set
    "U_VFABR002" = 'I'
where
    ifnull("U_VFABR002", '') = ''

update
    "@IAG_MHU_LGP0"
set
    "U_SvcLst" = 'Y'
where
    ifnull("U_SvcLst", '') = ''"

update
    u
set
    u."U_RejRat" = o."U_RejRat"
from
    "@IAG_PRD8" u,
    "@IAG_PRD0" o
where
    u."U_RejRat" is null and
    o."U_Type" = 'P' and
    u."DocEntry" = o."DocEntry"

update
    "@IAG_PRD0"
set
    "U_Mrprst" = '0'
where
    "U_Mrprst" is null

update
    "@IAG_MHU_LGP0"
set
    "U_WgtUsed" = '0'
where
    "U_WgtUsed" is null

update
    "@IAG_MHU_LGP0"
set
    "U_VolUsed" = '0'
where
    "U_VolUsed" is null

update
    "@IAG_MHU_MHU0"
set
    "U_Volume" = '0'
where
    "U_Volume" is null

SQL

update
    [@IAG_ERS0]
set
    U_VFABR002 = 'I'
where
    isnull(U_VFABR002, '') = ''

update
    [@IAG_MHU_LGP0]
set
    U_SvcLst = 'Y'
where
    isnull(U_SvcLst, '') = ''

update
    u
set
    u.U_RejRat = o.U_RejRat
from
    [@IAG_PRD8] u
    inner join [@IAG_PRD0] o on u.DocEntry = o.DocEntry
where
    u.U_RejRat is null and
    o.U_Type = 'P'

update
    [@IAG_PRD0]
set
    U_Mrprst = '0'
where
    U_Mrprst is null

update
    [@IAG_MHU_LGP0]
set
    U_WgtUsed = '0'
where
    U_WgtUsed is null

update
    [@IAG_MHU_LGP0]
set
    U_VolUsed = '0'
where
    U_VolUsed is null

update
    [@IAG_MHU_MHU0]
set
    U_Volume = '0'
where
    U_Volume is null