2012 Jan 11 7:47 AM
Hi Friends,
I have to Include a new field in the Standard DB table FKKVKP.
Is there any alternative available other than Customizing Includes and Append Structures.
If not, which will be the best way to add the new field ?
Kindly suggest me a solution for this Issue.
Our systems are going to undergo Upgrade in few months from 4.7 version to ECC 6.0.
Thanks & Regards,
Yogesh.
2012 Jan 11 9:07 AM
Hi,
Go for append structure. Even if you make any changes in future you can do it in the structure itself and it will get adjusted in table automatically.
2012 Jan 11 10:45 AM
This is an application table. The known best solution is to APPEND structure. If you find any better option, kindly share that knowledge with us...
2012 Jan 11 10:58 AM
Hi Yogesh,
There will be no problem for append structure or customizing include after upgrade.
you can use either of the method.
No alternative available and not required.
Thanks,
Pankaj
2012 Jan 11 11:00 AM
Hi,
You can use append structure and add your fields. That will be best.
Thanks,
Renuka
2012 Jan 11 11:35 PM
Yes as suggested append structure is the best way
Make sure you have developer key to append struture to a standard SAP table
Cheers
2012 Jan 12 10:41 AM
Hi Yokesh,
The best way to move forward is by using an append structure. Any changes made to this structure will be automatically reflected in the table and also it will be adjusted automatically.
Thanks!
Praveenkumar T.
2012 Jan 12 12:06 PM
Hi,
There is only one option to include extra field for standard tables that is Append Structure other than we don't have any option.
For Customizing tables we can use Append structure as well as Include Structure.
Rules: Append Structure should be in last in Field column but include structure you can insert in any where it means between the fields.
Delivery class option and data class will take care automatically while upgrading the sap system one version to Another version.(upgrading).
For that you should maintain the those properties when data base table creation.
i hope the above information may helpful to you.
Best Regards
Sreenivas Pachva
2012 Jan 13 12:41 PM
Hi,
We create append structures in the customer namespace. The append structure is thus protected against overwriting during an upgrade. The fields in the append structure should also reside in the customer namespace, that is the field names should begin with ZZ or YY. This prevents name conflicts with fields inserted in the table by SAP.
Link: [http://help.sap.com/saphelp_nw04s/helpdata/en/cf/21eb61446011d189700000e8322d00/content.htm]
Regards,
Danish