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
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
Post your comment on this topic.