*load only those transaction data in target whose master data exists *need to lookup master data table and if record is not there, delete it * source fields are cno, salesid, matid, amount * master data attribute table name – …
Scenario: The source data is coming in the form of ytd numbers. Below is an example of year to date (YTD) numbers: The user wants to see the monthly values instead of the YTD values, below is the data which …
Scenario: There is a requirement to load data with a filter on a certain infoObject. This filter is a parent node of a hierarchy. The data in the source is having rows with leaf nodes only for this infoObject. See …
Learn step by step approach of writing start routine, field routine and end routine in BW transformations. Learn about ABAP routine filters in DTP and info packages and use of OLAP variables as Filters. Access the ebook on Amazon at …
Here I will site an example of how to enhance a BEx variable using BW customer exit. More details and insightful examples can be accessed in my ebook , click here Display only two years of data in the BEx …
In this post, I will detail on how to write an ABAP program which checks for a specific file in the application server and triggers a process chain. If no file is found, it just displays a message and does …
In some scenarios, it may happen that business has loaded multiple files in a period for sales for example. All these files should be merged into one consolidation file and loaded once to target instead of loading each file separately. …
*–Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *–Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB …
*–Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *–Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB …
*–Attaching type group to the program TYPE-POOLS TRUXS. *–Structure Type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10, END OF TY_STD. *–Header line and …