Table Generation After Promoting to another environment

Table Generation After Promoting to another environment

• Many times it happens that we have to add the new field to JDE Custom Table
• When it comes to adding the table we have to make sure that the JDE Specs matches with database otherwise it will lead to many other errors.
• If the new field is added to the table, it is compulsion developer has to generate the table in all the environment where ever the table is promoted.
• Table generation wipes out the entire table and make the JDE Spec and Database

what if we want to add the field into the table having data inside it?

• We have to take the backup of the table before generating the table.
• In my case, i requested my CNC person to perform below activity after promoting the project from DV (Development)to PY (Testing)
• "I received update that the project has been deployed to PY but below request is pendingTake backup of F584312 table from PY 910 and then generate the table as we have added new field in table.After successful generation please restore the data in F584312 as we want to perform test on that data."
• CNC performed below activity and I got table promoted in PY along with new filed and old data

This is complete. I inserted a null value into the new column - ''

• 
  
  CPYF FROMFILE(CRPDTA91/F584312) TOFILE(ERPSUITES/F584312TMP) CRTFILE(*YES)
  CPYF FROMFILE(CRPDTA91/F584312) TOFILE(ERPSUITES/F584312BKP) CRTFILE(*YES)
  Generate the table.
  strsql
  insert into crpdta91/f584312 select ILUKID, ILANBY, ILITM, ILLITM, ILAITM, ILMCU, ILAN8, ILQCENG, ILAN82, ILAN83, ILDESC01, ILDESC02, IL$SDTE, ILMATH01, ILMATH02, ILQTY, ILILSTUS, '', ILREM1, ILUSER, ILPID, ILJOBN, ILUPMT, ILUPMJ from erpsuites/f584312tmp

  ---