Up gradation or Adding a fields
INCLUDE (or) APPEND or the keywords for adding a structure to the tales.
*******************************************************************************
* In SAP R/3 it is not possible for adding the fields directly to SAP tables. With database structures uses can add a fields for SAP tables.
The previous program
Using 3.1F SAO version ad have 100 fields vendor table and vendor application. Up gradation takes place when new version coming into market then it will upgraded by using conversion presentation is applicable server to new version i.e. 4.7 and put it database servers as it is in any type of technology. If we wand to add some fields to already existing database table i.e. vendor table we can add it by using structure and following keywords.
*******************************************************************************
STRUCTURE CREATION STEPS : -
§ Go to ABAP dictionary in which
§ Select (1) Data type and give name of YSTR structure
§ Go for CREATE it will display a option then
§ select (1) Structure then enter it display a window in which provide shorttext for structure Structure for Yemp
§ Provide component (fields in a structure ) Address what we want to add
§ provide component type (Data element) : ZADDRESSDATA
§ Ctrl +s for saving
§ Leave Development class as Blank
§ Go for Local object then
§ Double click on dataelement i.e. ZADDRESSDATA what we gave component type previous step
§ Select Dataelement
§ Enter
§ Provide shorttext for dataelement Dataelement for ADD
§ Provide domain ZADDRESS DOMAIN
§ This domain is not yet created we create it in corning steps so we create by using to domain name
So, whatever domain name given in this box we remember for to create domain in coming steps.
Then select field label option in that window then provide field label length i.e.
Medium 20 EMPLOYEE ADDRESS fields label name
§ Ctrl +s
§ leave Development class as blank
§ Go with Local object then
§ Select Definition option in that window.
§ Double click in domain i.e. ZADDRESSDOMAIN - enter
(Just we created in above)
§ Provide short text for domain Domain for ADD
§ Provide datatype : CHAR
Length : 30
§ Ctrl+S
§ Ctrl + F3 then F3 for back
§ Activate Data element then F3 for back
§ F3 for back
§ Activate structure
§ Go with ABAP Dictionary
§ Select database table YEMP which we created in last class i.e. for which table we want to add a structure.
§ Go to change mode
§ Go with New rows
§ Apply logic for including a field i.e.
INCLUDE YSSTR
§ Enter
§ Ctrl+S
§ Ctrl+f3
§ Go to utilities from menu
§ Choose Table contents
§ Go for Display
§ Then press F8 for execute then it will the inserted recorder of that fields.
v Once we add a structure to the table it can holds data different b/w . include and. Append. :
Here we have 3 tables and we can add a field DNO, ENO ENO, End respectively. Here we can use two structure for add that field bec ENO fields is reusable so
With – APPEND structure will restrict for specific tables only
With – include structure can relies different tables and include is a keyword
Þ In one table we can add 9 structures
We can add structures with in structure also.How to maintain previous data properly.
Download the file to update from database to presentation server
We have to maintain all records in proper way after add a field through structure we can follow a above logical for that
v First we download the records which are we going to update
v Sap provide some program for that logic in presentation server
v Download record will store in flat file or text file
v Flat file can be transferred to application server by using BDE
v Then we can update a record and transfer to database.
Flat File :
is nothing but a text file or excess sheet after completion of logic flat file transfer to Application server
No comments:
Post a Comment