![]() ![]() Created join between these two based on REQTSN.Created a hana calculation view containing above SQL view and hana view of planning ADSO.So that it can be used for any ADSO where we need this mechanism. I have defined the ADSO name as input parameter(I_ADSO) for the SQL view.I created a SQL view containing above view with tables (USR21, ADRP, ADR6) to capture user info (e.g.The hana table for the new Z table is available under SAPABAP1 schema.shown below the enhancement spot and logic.The reason is there may be so many ADSO getting through data load in the system and we need only for our planning ADSO. I have enabled only the for the required planning ADSO.updated the information to new Z table created before together with current date and timestamp.I identified the place where I can capture the information about the ADSO and request number.When the data is getting loaded through DTP, there is a set of code which gets executed before loading the records to ADSO.Step 2 (Capture the changes from the data load) the detailed design is explained in the below picture.Used the conversion exit to convert into correct time-time (UTC+8) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |