How can be an existing database table or structure be enhanced with new fields in SAP?
Mainly there are three types to enhance a database table:-
1. Using Customer Include (CI)
2. Using System Include (SI)
3. Using Append Structure to Database table
1.- Using Customer Include (CI) : A customer include is structure which has been provided by SAP in a database table or structure already to be implemented by customer (very rare cases when we use it for SAP solution). A customer can create that customer include with his own field to enhance the database table or structure. If there is no customer include then you can use Append structure to enhance that database table or structure.
Name of customer include will always be started using “CI” as prefix.
Note: - If you are using Customer Include for SAP solutions then please keep in mind that it’s not preferable because CI includes can’t be shipped to customer. And you cannot use reference for that field directly.
2. Using System Include (SI): A system include is also a structure which has been provided by SAP in a database table. It can be used for SAP internal solutions and can be delivered to customer directly.
Name of system include will always be started using “SI” as prefix.
3. Using Append Structure to Database table: An append structure is a structure which is specially created for a database table or structure. It is used to enhance DB table or structures. If you want to enhance more than one DB table or structure with same fields then you have to create multiple append structures with same fields for each DB table or structure.
0 comments:
Post a Comment