List of upgrade procedures by module

List of control procedures before the upgrade

These procedures must be launched from the folder that has to be upgraded before data extraction. They can be launched in batch execution.

ModuleProcedureDescription
FinancialsUUMGCTLCTP00Entries
A/P-A/R accountingUUMGCTLTRS00BP invoices
SalesUUMGCTLSAL01Quotation
UUMGCTLSAL02Orders
UUMGCTLSAL06Deliveries
UUMGCTLSAL07Returns
UUMGCTLSAL08Invoices
PurchasingUUMGCTLPUR01Purchase requests
UUMGCTLPUR02Normal orders
UUMGCTLPUR03Contract orders
UUMGCTLPUR06Receipts
UUMGCTLPUR07Returns
UUMGCTLPUR08Invoices

List of pre-upgrade procedures

These procedures must be launched from the folder that has to be upgraded before the data extraction. They can be launched in batch execution.

ModuleProcedureDescription
Common dataUUMGPRETRC04Pre-loading of fields
GACCDUDATE table: BPAPAY
UUMGPRETRC07Pre-loading of fields
BPCUSTOMER table: BPAPYR, BPCRSK, CUR, NTNAM, BPAADD, DAYMON, UVYCOD2
UUMGPRETRC08Pre-loading of fields
BPSUPPLIER table: BPAPAY, BPAINV, BPSRSK, CUR, CNTNAM, BPAADD
SalesUUMGPRESAL01Pre-loading of fields
SQUOTE table: BPAORD, BPIEECNUM, EECICT, EECLOC
SQUOTED table: PJT
UUMGPRESAL02Pre-loading of fields
SORDER table: BPAORD, BPAPYR , BPAINV, EECICT, EECLOC
SORDERQ table: PJT
UUMGPRESAL03Pre-loading of fields
SORDERC table: BPIEECNUM, EECICT, EECLOC
UUMGPRESAL04Pre-loading of fields
VSORDER table: BPAORD, BPAINV, EECICT, EECLOCC
UUMGPRESAL05Pre-loading of fields
VSORDERC table: BPIEECNUM, EECICT, EECLOC
UUMGPRESAL06Pre-loading of fields
SDELIVERY table: BPAINV
SDELIVERYD table: PJT
UUMGPRESAL07Pre-loading of fields
SRETURN table: BPIEECNUM, EECICT, EECTRN
SRETURND table: PJT
UUMGPRESAL08Pre-loading of fields
SINVOICE table: BPAPAY
SINVOICED table: PJT
PurchaseUUMGPREPUR02Pre-loading of fields
PORDER table: EECICT, EECLOC, EECNUM, BPOADD, BPONAM, BPOADDLIG, BPOPOSCOD, BPOCTY, BPOSAT, BPOCRY, BPOCRYNAM, BPAPAY, BPAINV
PORDERC table: EECNUM2
UUMGPREPUR04Pre-loading of fields
UPORDER table: EECICT, EECLOC, EECNUM, BPOADD, BPONAM, BPOADDLIG, BPOPOSCOD, BPOCTY, BPOSAT, BPOCRY, BPOCRYNAM, BPAPAY, BPAINV
UPORDERC table: EECNUM2
UUMGPREPUR06Pre-loading of fields
PRECEIPT table: FFWADD, BPAINV, EECNUM
UUMGPREPUR07Pre-loading of fields
PRETURN table: FFWADD, BPAINV, BPRPAY, BPAPAY, EECNUM
PRETURND table: POHTYP
UUMGPREPUR08Pre-loading of fields
PINVOICE table: FFWADD, EECNUM, BPAPAY
PINVOICED table: CMMNUM
## List of upgrade proceduresThese initialization procedures will be launched using the sequencing monitor.
ModulePhaseProcedureDescription
Sales4UUMGINISAL01Quotation
UUMGINISAL02Normal orders
UUMGINISAL06Deliveries
UUMGINISAL07Returns
UUMGINISAL08Invoices

These procedures will be launched using the sequencing monitor.

ModulePhaseProcedureDescription
Common data1UUMGTRTTRC01Products
UUMGTRTTRC02Product-sites
UUMGTRTTRC03A/P - A/R Accounting
2UUMGTRTTRC04Open items
UUMGTRTTRC06Sales reps
UUMGTRTTRC07Customers
UUMGTRTTRC08Suppliers
UUMGTRTTRC09Carriers
UUMGTRTTRC10On-hand orders
UUMGTRTTRC11BOM (detail)
UUMGTRTTRC12MRP results
UUMGTRTTRC13MDS results
UUMGTRTTRC14Products - BOMs
UUMGTRTTRC15Component requirements
UUMGTRTTRC16Products - BOMs (Configurator)
UUMGTRTTRC17Scenario (Configurator)
UUMGTRTTRC18Configuration history header (Configurator)
Accounting1UUMGTRTCPT01General accounting entry
2UUMGTRTCPT02IAS accounting entry
1UUMGTRTCPT03Commitments
UUMGTRTCPT04Batch of entries
UUMGTRTCPT05Budget
UUMGTRTCPT06Budget MO
8UUMGTRTCPT51General balance resync - open fiscal years
UUMGTRTCPT52Dimension balance resync - open fiscal years
UUMGTRTCPT53Commitment balance resync - open fiscal years
UUMGTRTCPT54Quantity balance resync - open fiscal years
A/P-A/R accounting1UUMGTRTTRS01Customer BP invoices
UUMGTRTTRS02Supplier BP invoices
UUMGTRTTRS03Payments
UUMGTRTTRS04Expense notes
2UUMGTRTTRS05Payment entry batch
Sales1UUMGTRTSAL01Quotation
UUMGTRTSAL02Normal orders
2UUMGTRTSAL03Contract orders
1UUMGTRTSAL04Normal orders hist.
2UUMGTRTSAL05Open orders hist.
1UUMGTRTSAL06Deliveries
3UUMGTRTSAL07Returns
UUMGTRTSAL08Invoices
4UUMGTRTSAL51Customer transactions
5UUMGTRTSAL52Customer balances resync
Purchase1UUMGTRTPUR01Purchase request
UUMGTRTPUR02Normal orders
2UUMGTRTPUR03Contract orders
1UUMGTRTPUR04Normal order hist.
2UUMGTRTPUR05Open order hist.
3UUMGTRTPUR06Receipts
UUMGTRTPUR07Returns
UUMGTRTPUR08Invoices/Credit memos
UUMGTRTPUR09Transport
UUMGTRTPUR10Containers
4UUMGTRTPUR11Shipments
UUMGTRTPUR41Signatures/Assignment rules
5UUMGTRTPUR42Signatures/User assignment
4UUMGTRTPUR43Signatures/Workflow tracking history
5UUMGTRTPUR44Signatures/Screen and window deletion
4UUMGTRTPUR51Supplier transactions
5UUMGTRTPUR52Supplier balances resync
Stocks1UUMGTRTSTO01Stock journal
UUMGTRTSTO02Product-costs
2UUMGTRTSTO03Product-site totals + Stock FIFO cost
1UUMGTRTSTO04Stock change
Manufacturing1UUMGTRTGPA01Production WIP
UUMGTRTGPA02Production cost
UUMGTRTGPA03WO
2UUMGTRTGPA04WO trackings
Customer Relation1UUMGTRTHDK01Service contracts
UUMGTRTHDK05Service requests

List of post-upgrade procedures

These procedures must be launched after the complete upgrade of the folder using the sequencing monitor. Their execution can be deferred: they can be launched after the upgrade.

ModulePhaseProcedureDescription
Common data1UUMGPOSTRC03GACCDUDATE - TYPDUD fields
(new field in V140, case of a upgrade V130-V6 with TYPECH under CPTMAJ14)
2UUMGPOSTRC04GACCDUDATE - FIY/PER fields
1UUMGPOSTRC51SINVOICE (VEN & TRS) - FIY/PER fields
UUMGPOSTRC52PINVOICE (ACH & TRS) - FIY/PER fields
2UUMGPOSTRC53TRCVCRDOC from SINVOICE
3UUMGPOSTRC54TRCVCRDOC from PINVOICE
Accounting1UUMGPOSCPT03GCOMMITD: UOM
UUMGPOSCPT05BUD: UOM
UUMGPOSCPT11GACCENTRYD: CAPFLOTYP field (KPO activity code) – V6-V7 upgrade
UUMGPOSCPT51BALANCE - closed fiscal years
UUMGPOSCPT52BALANA - closed fiscal years
UUMGPOSCPT53BLACMM - closed fiscal years
UUMGPOSCPT54BLAQTY - closed fiscal years
UUMGPOSCPT55Journals - reports per period
A/P-A/R accounting1UUMGPOSTRS03PAYMENTH - FIY/PER fields
Sales1UUMGPOSSAL01SQUOTE - Valuation
Specific case: This processing performs the valuation of quotes if the VALORISATION variable has been set to 0 in the entry point in UUMGTRTSAL01
UUMGPOSSAL02ORDERS - Back-to-back
Assignment creation for back-to-back orders
SORDER - Sales order
VSORDER - Sales order history
This process performs the initialization of INRNOT and INRATI
UUMGPOSSAL06SDELIVERY- Deliveries
This process performs the initialization of the RTNSTA field
To do only when you upgrade from V8 (AKIRA)

List of temporaty tables for transactions tables upgrade procedures

TableTemporary tableOptimization index
ITMMASTERUITMMASTER
ITMFACILITUTMFACILIT
GACCDUDATEUACCDUDATEACCNUM+DUDLIG
ORDERSUORDERS
BOMDUBOMD
BOMRETUBOMRET
ITMBOMUITMBOM
ITMBOMCFGUITMBOMCFG
CFGSCEUCFGSCE
CFGHISHEAUCFGHISHEA
CBNHEAUCBNHEA
PDPHEAUPDPHEA
BPARTNERUBPARTNER
SALESREPUSALESREP
BPCUSTOMERUPCUSTOMERBPCPYR+BPCNUM
BPDLVCUSTUBPDLVCUST
BPSUPPLIERUPSUPPLIER
BPCARRIERUBPCARRIER
GACCENTRYUGACCENTRYCPY+TYP+NUM
GACCENTRYAUACCENTRYA
GACCENTRYDUACCENTRYD
GACEIASUGACEIASCPY+TYP+NUM
GACEIASDUGACEIASD
GCOMMITUGCOMMITCPY+NUM
GCOMMITDUGCOMMITD
GENTLOTUGENTLOTCPY+LOT
GENTLOTHUGENTLOTH
GENTLOTDUGENTLOTD
GENTLOTAUGENTLOTA
BUDUBUDFCY+BUD+FIY+CNA+CCE1+CCE2+CCE3
BUDODUBUDOD
BUDODSUBUDODSNUM+FCY+LINNUM
SINVOICEUSINVOICECPY+NUM
PINVOICEUPINVOICECPY+FCY+NUM
BPCINVLIGUBPCINVLIG
BPCINVLIGAUPCINVLIGA
BPSINVLIGUBPSINVLIG
BPSINVLIGAUPSINVLIGA
PAYMENTHUPAYMENTHCPY+NUM
PAYMENTDUPAYMENTD
PAYMENTAUPAYMENTA
EXPENSESUEXPENSESCPY+ACCNUM
SQUOTEUSQUOTE
SQUOTEDUSQUOTEDSALFCY+SQHNUM+SQDLIN
SORDERUSORDERSOHCAT+SALFCY+SOHNUM
SORDERPUSORDERPSOHCAT+SALFCY+SOHNUM+SOPLIN+SOPSEQ
SORDERQUSORDERQ
SORDERCUSORDERC
VSORDERUVSORDERSOHCAT+SALFCY+SOHNUM+REVNUM
VSORDERPUVSORDERP
VSORDERQUVSORDERQ
VSORDERCUVSORDERC
SDELIVERYUSDELIVERY
SDELIVERYDUSDELIVERYDSTOFCY+SDHNUM+SDDLIN
SRETURNUSRETURNSTOFCY+SRHNUM
SRETURNDUSRETURND
SINVOICEVUSINVOICEVSALFCY+NUM
SINVOICEDUSINVOICED
BPCUSTMVTUBPCUSTMVT
PREQUISUPREQUISPSHFCY+PSHNUM
PREQUISDUPREQUISD
PORDERUPORDERUPOHTYP+POHFCY+POHNUM
PORDERPUPORDERPUPOHNUM+POPLIN+POPDAT+POPSEQ
PORDERQUPORDERQU
PORDERCUPORDERCU
UPORDERUUPORDERUPOHTYP+POHFCY+POHNUM+REVNUM
UPORDERPUUPORDERPUPOHNUM+LINREVNUM+POPLIN+POPDAT+POPSEQ
UPORDERQUUPORDERQU
UPORDERCUUPORDERCU
PRECEIPTUPRECEIPTPRHFCY+PTHNUM
PRECEIPTDUPRECEIPTD
PRETURNUPRETURNPNHFCY+PNHNUM
PRETURNDUPRETURND
TRANSPORTUTRANSPORT
CONTAINERUCONTAINER
CONTAINERDUCONTAINERD
SHIPMENTUSHIPMENT
SHIPMENTDUSHIPMENTD
PINVOICEVUPINVOICEV
PINVOICEDUPINVOICED
BPSUPPMVTUBPSUPPMVT
PAPPCONFUPAPPCONFAPPRUL+CPY
PAPPRECORDUAPPRECORD
PAPPROVALUPAPPROVAL
STOJOUUSTOJOUSTOFCY+ITMREF+IPTDAT+UPDCOD+MVTSEQ+MVTIND
ITMCOSTUITMCOST
ITCNATUITCNAT
ITMMVTUITMMVT
STOCOSTUSTOCOST
MFGWIPUMFGWIP
WIPCOSTUWIPCOST
MFGCOSTUMFGCOST
MFCNATUMFCNAT
MFGHEADUMFGHEADMFGFCY+MFGNUM
MFGITMUMFGITMMFGFCY+MFGNUM+MFGLIN
MFGMATUMFGMATMFGFCY+MFGNUM+MFGLIN+BOMSEQ+ITMREF
MFGOPEUMFGOPEMFGFCY+MFGNUM+OPENUM+OPESPLNUM
MFGHEADTRKUFGHEADTRKMFGFCY+MFGTRKNUM
MFGITMTRKUMFGITMTRKMFGFCY+MFGTRKNUM+ITMTRKLIN
MFGMATTRKUMFGMATTRKMFGFCY+MFGTRKNUM+MATTRKLIN
MFGOPETRKUMFGOPETRKMFGFCY+MFGTRKNUM+OPETRKLIN
PAYLOTUPAYLOT
SERREQUESTUSERREQUEST[F :SREM]
CONTSERVUCONTSERV[F :CONM]

Availability of CRITSEL entry point in upgrade procedures

List of the concerned upgrade procedures and abbreviations to use for the Where clause:

ModuleFLOWDescriptionAbbreviation
Common dataUUMGTRTTRC01ProductsITMM
UUMGTRTTRC02Product-sitesITFM
UUMGTRTTRC03A/P - A/R AccountingBPRM
UUMGTRTTRC04Open itemsDUDM
UUMGTRTTRC06Sales repsREPM
UUMGTRTTRC07CustomersBPCM
UUMGTRTTRC08SuppliersBPSM
UUMGTRTTRC09CarriersBPTM
UUMGTRTTRC10On-hand ordersORDM
UUMGTRTTRC11BOM (detail)BODM
UUMGTRTTRC12MRP resultsCBHM
UUMGTRTTRC13MDS resultsPDHM
UUMGTRTTRC14Products - BOMsITMB
UUMGTRTTRC15Component requirementsBMRM
UUMGTRTTRC16Products - BOMs (Configurator)CFBM
UUMGTRTTRC17Scenario (Configurator)CSCM
UUMGTRTTRC18Configuration history header (Configurator)CHHM
AccountingUUMGTRTCPT01General accounting entryHAEM
UUMGTRTCPT02IAS accounting entryHIAM
UUMGTRTCPT03CommitmentsCMMM
UUMGTRTCPT04Batch of entriesLOTM
UUMGTRTCPT05BudgetBUDM
UUMGTRTCPT06Budget MOBDEM
UUMGTRTCPT51General balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
UUMGTRTCPT52Dimension balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
UUMGTRTCPT53Commitment balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
UUMGTRTCPT54Quantity balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
A/P-A/R accountingUUMGTRTTRS01Customer BP invoicesSIHM
UUMGTRTTRS02Supplier BP invoicesPIHM
UUMGTRTTRS03PaymentsPYHM
UUMGTRTTRS04Expense notesEXSM
UUMGTRTTRS05Lot entryPYLM
SalesUUMGTRTSAL01QuotationSQHM
Specific case: The VALORISATION variable can be set to 0 in this entry point in order to skip the valuation of quotes at this step. In this case, it will be necessary to launch UUMGPOSSAL01 to perform the valuation of quotes after the upgrade.
UUMGTRTSAL02Normal ordersSOHM
UUMGTRTSAL03Contract ordersSOHM
UUMGTRTSAL04Normal orders hist.VOHM
UUMGTRTSAL05Open orders hist.VOHM
UUMGTRTSAL06DeliveriesSDHM
UUMGTRTSAL07ReturnsSRHM
UUMGTRTSAL08InvoicesSIHM
UUMGTRTSAL51Customer transactionsMVCM
PurchaseUUMGTRTPUR01Purchase requestPSHM
UUMGTRTPUR02Normal ordersPOHM
UUMGTRTPUR03Contract ordersPOHM
UUMGTRTPUR04Normal orders hist.UOHM
UUMGTRTPUR05Open orders hist.UOHM
UUMGTRTPUR06ReceiptsPTHM
UUMGTRTPUR07ReturnsPNHM
UUMGTRTPUR08Invoices/Credit memosPIHM
UUMGTRTPUR09TransportTRNPM
UUMGTRTPUR10ContainersCTRHM+CTRDM
UUMGTRTPUR11ShipmentsSHHM+SHDM
UUMGTRTPUR41Signatures/Assignment rulesPACM
UUMGTRTPUR42Signatures/User assignmentPAPM
UUMGTRTPUR43Signatures/Workflow tracking historyPADM
UUMGTRTPUR44Signatures/Screen and window deletionPACM
UUMGTRTPUR51Supplier transactionsMVSM
StocksUUMGTRTSTO01Stock journalSTJM
UUMGTRTSTO02Product-costsITCM
Specific case: The LICAFLT variable can be set to 0 in this entry point to avoid deleting the duplicated revised standard costs.
UUMGTRTSTO03Product-site totals + Stock FIFO costITVM
ManufacturingUUMGTRTGPA01Production WIPMWHM
UUMGTRTGPA02Production costMFCM
UUMGTRTGPA03WOMFGM
UUMGTRTGPA04WO trackingsMTKM
Customer relationUUMGTRTHDK01Service contractsCONM
UUMGTRTHDK02Service requestSREM

List of the concerned post-upgrade procedures and abbreviations to use:

ModuleFLOWDescriptionAbbreviation
AccountingUUMGPOSCPT51General balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
UUMGPOSCPT52Dimension balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
UUMGPOSCPT53Commitment balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
UUMGPOSCPT54Quantity balance resyncParticular case: filter only on the COMPANY table, CPY9 abbreviation
SalesUUMGPOSSAL01QuotationSQH
Specific case: This processing performs the valuation of quotes if the VALORISATION variable has been set to 0 in the CRITSEL entry point in UUMGTRTSAL01

Availability of VERIFSEL entry point in upgrade procedures

List of the concerned upgrade procedures and abbreviations to use:

ModuleFLOWDescriptionAbbreviation
Common dataUUMGTRTTRC01ProductsITMM
UUMGTRTTRC02Product-sitesITFM
UUMGTRTTRC03A/P - A/R AccountingBPRM
UUMGTRTTRC04Open itemsDUDM
UUMGTRTTRC06Sales repsREPM
UUMGTRTTRC07CustomersBPCM
UUMGTRTTRC08SuppliersBPSM
UUMGTRTTRC09CarriersBPTM
UUMGTRTTRC10On-hand holdersORDM
UUMGTRTTRC11BOM (detail)BODM
UUMGTRTTRC12MRP resultsCBHM
UUMGTRTTRC13MDS resultsPDHM
UUMGTRTTRC14Products - BOMsITBM
UUMGTRTTRC15Component requirementsBMRM
UUMGTRTTRC16Products - BOMs (Configurator)CFBM
UUMGTRTTRC17Scenario (Configurator)CSCM
UUMGTRTTRC18Configuration history header (Configurator)CHHM
AccountingUUMGTRTCPT01General accounting entryHAEM
UUMGTRTCPT02IAS accounting entryHIAM
UUMGTRTCPT03CommitmentsCMMM
UUMGTRTCPT04Batch of entriesLOTM
UUMGTRTCPT05BudgetBUDM
UUMGTRTCPT06Budget MOBDEMA/P-A/R accountingUUMGTRTTRS01Customer BP invoicesSIHM
UUMGTRTTRS02Supplier BP invoicesPIHM
UUMGTRTTRS03PaymentsPYHM
UUMGTRTTRS04Expense notesEXSM
UUMGTRTTRS05Batch inputPYLM
SalesUUMGTRTSAL01QuotationSQHM
UUMGTRTSAL02Normal ordersSOHM
UUMGTRTSAL03Contract ordersSOHM
UUMGTRTSAL04Normal orders hist.VOHM
UUMGTRTSAL05Open orders hist.VOHM
UUMGTRTSAL6DeliveriesSDHM
UUMGTRTSAL07ReturnsSRHM
UUMGTRTSAL08InvoicesSIHM
UUMGTRTSAL51Customer transactionsMVCM
PurchaseUUMGTRTPUR01Purchase requestPSHM
UUMGTRTPUR02Normal ordersPOHM
UUMGTRTPUR03Contract ordersPOHM
UUMGTRTPUR04Normal orders hist.UOHM
UUMGTRTPUR05Open orders hist.UOHM
UUMGTRTPUR06ReceiptsPTHM
UUMGTRTPUR07ReturnsPNHM
UUMGTRTPUR08Invoices/Credit memosPIHM
UUMGTRTPUR09TransportTRNPM
UUMGTRTPUR10ContainersCTRHM+CTRDM
UUMGTRTPUR11ShipmentsSHHM+SHDM
UUMGTRTPUR41Signatures/Assignment rulesPACM
UUMGTRTPUR42Signatures/User assignmentPAPM
UUMGTRTPUR43Signatures/Workflow tracking historyPADM
UUMGTRTPUR44Signatures/Screen and window deletionPACM
UUMGTRTPUR51Supplier transactionsMVSM
StocksUUMGTRTSTO01Stock journalSTJM
UUMGTRTSTO02Product-costsITCM
UUMGTRTSTO03Product-site totals + Stock FIFO costITVM
ManufacturingUUMGTRTGPA01Production WIPMWHM
UUMGTRTGPA02Production costMFCM
UUMGTRTGPA03WOMFGM
UUMGTRTGPA04WO trackingsMTKM
Customer relationUUMGTRTHDK01Service contractsCONM
UUMGTRTHDK02Service requestSREM

List of the concerned post-upgrade procedures and abbreviations to use:

ModuleFLOWDescriptionAbbreviation
SalesUUMGPOSSAL01QuotationSQH
UUMGPOSSAL02Sales ordersSOH+VOH
UUMGPOSSAL06DeliveriesSDH