Posts tagged with "abap"



06. August 2019
In our current project we had to deal with the requirement that the enduser only want to show a certain node of a hierarchy to filter. So we used the F4 restriction from the transaction spro. You find the entry under Business Warehouse >> Enhancements >> BAdI: Restricting the Value Help in the Variables Screen. We implemented it in the method GET_RESTRICTION_NODE. At this time I had only experience with the method GET_RESTRICTION_FLAT and searched for implementation examples. I...
Hide hierachy node in BEx Query Designer
04. March 2019
In my current project we have the hide a position in a hierarchy, because it is a departmental requirement. The hierarchy is used by many departments so we cannot change it and we also don't want to have the same hierarchy two times (except for the one position). So we first excluded the position in the query.

DTP Extraction tab
26. November 2018
In my current project I have to filter data with a lot of logic. So I build some ABAP routines in a DTP filter to receive the necessary data. First you have to open the DataTransferProcess (DTP) in change mode and select the Filter button on the Extraction tab.

Z-Table to decode information
06. February 2018
In my current project I have a file to import, which only delivers me a string with a length of 1000. I also get a description what is in this file. Like the following points: Customer from 1 to 10 City from 11 to 50 The file looks like: 0000123456London............................ So I have a file and a description how to decode this file. Now I need to find a way to separate this information into InfoObjects. I build a Z-Table which contains the decode information.

Old booked value
12. January 2018
Lately, all my posts started with "In my current project", so now something else, even if it was developed in the current project. The problem we are facing with is that we get a data extraction which deliver us only the new data records, not the reverse data record.

Query Hierarchy Structure
12. December 2017
In my current project we have a lots of source systems which delivers our data in a key figure model. In a normal case is this not a problem. But we need the values of the key figures in a hierarchy. So there are two ways to realize it. First way would be we build a structure with restricted key figures and get our hierarchy. Here is the problem, the customer will need different queries to realize his needs. If there is a change, we need to adjust different queries (each has a light different...

Create a field with a length of 1333 in Eclipse
08. November 2017
In my current project I created with a collegue a really cool function to analyze a string with 1333 characters. We are using a BW 7.4 SP 17 on HANA. First we have to build an Advanced DataStoreObject with a Field which has a length of 1333. For further understanding, we call the field Field_1333. As data type I used SSTRING.

30. December 2014
From time to time it happens that the source system delivers special characters and the Business Warehouse system can not handle it. So the loading process may be crashed. One solution is the following ABAP code: DATA: zeichen(1) TYPE c, muster(2) TYPE c, field TYPE c LENGTH 000060. field = SOURCE_FIELDS-YYSTREET. DO. IF field CO ' !"%&()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜßabcdefg' & & 'hijklmnopqrstuvwxyzäöü '. EXIT. ELSE. zeichen = field+sy-fdpos(1)....