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

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Kunden-Support

Post Comment