Filter data in transfer rules using start routine
I am an absolute newbie here, but I have a question regarding start routines and I noticed many questions get solved around here. My situation is the following: I have to create a start routine where the data to be transferred is filtered on an attribute "DESTINAT" in info object "0BILL_TYPE". DESTINAT can be 'M' or 'D' and depending on that letter, data must flow to a separate ODS.
Well,I came up with the following:
somewhere in my start routing I guess I'll have to put:
loop at data_pak.
DELETE DATAPAK Where DESTINAT = 'D'
When I place this in my start routine of my transfer rules leading to the ODS where data must be of DESTINAT type 'M', will this do the trick?
I want to put the following code in the transfer rules leading to my other ODS, where data must be of type DESTINAT = 'D':
loop at data_pak.
DELETE DATAPAK Where DESTINAT = 'M'
I'm sorry that this is a very basic question, but like I said: I'm a newbie in SAP...
have a lok at the foll help docs.:
Hi! Anyone aware how to get todays' date in the Transfer Rules Formula Editor? Aim is to calculate ones actual age based on a given birthday-month-year using the dateDifference function. CheersHi, The summary of both posts: Use a formula DATE_DIFF( S
I did the following: 1) Go into table RSAABAP and got all the CODEID's for my search string. 2) Take those CODEID values and use them as a filter for table RSUPDROUT. No entries came back which tells me that these CODEID's are NOT for update rul
Hello all, I've got a "little" problem (or bug?). I created an infosource which sends its datas to a cube. The infosource has got datas from a datsource (TXT file) . All was good. I could see datas on Bex... But i wanted to change (and not creat
Hi Our R3 client 100 is mapped to BW client 100. R3 client 100 is source system in BW. As the master data is created by users in R3 client 200 we want to get the data from client 200 to BW. We dont want to replicate each datasource and do all stuff f
Hi, Is it possible to create a start routine in a transfer rule of a Datamart update (from ODS to Cube)? Thxs. LauQRoberto, If I read well the content of note 499404 - referred to in 630854 - I conclude that it is recommended to use update rules rath
Can anyone help me with regards to writing some ABAP code in a transfer rule so that I can assign "99991231" value into a date characteristics if it is blank? Many thanks for advance.I would like to check if the value of EXPIRYDATE is blank in d
Can anyone help me with regards to writing some ABAP code in a transfer rule so that I can change the format of a date (from 04/01/06 in the PSA) so that it's wrtitten as 01.04.06 into the cube? Many thanks in advance, Matt Message was edited by:
Hi, when i am loading master data from R/3 into BW, i need to filter some records based on material type. there is no option in RSA6 (on R/3) or in Infopackage (BW) to make it available for filter. So i assume i need to write ABAP routine in transfer
I'VE CREATE a start routine, seel bleow. Now I want to get at one of the fieds for a Key figure. How do i do that? do I need to add it to the transfer structure LOOP AT ROUTEDAY INTO WA_ROUTEDAY. CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT' EX
Dear all, I have a requirement to Activate mapping field in Infosource - transfer rule. I have to map ZDATE (datatype - DEC) with ZOLDDATE (Datatype - DATS). I know it can be directly mapped so DATS field will be automatically converted to DEC like b
Hello I would like to use the same variable in data selection of infopackage (1) and as a value in transfer rules (2). Example : If I pass 1 I want to see value1 in data selection of infopackage (1) and as a value in transfer rules (2). If I pass 2 I
HI all, I am extracting the data from xRPM 4.0 to BW 7.0.Even though i am using BI 7.0 presently we are using 3.5 only.I have installed the transfer rules after that i am trying to activate the transfer rules .But i am getting the error with standard
hi I want create filter data in using routine by DTP I want dowload data in my DSO, if the material exist in my infoobject 0material. But my code donu2019t worked: =============================================================== *& Include
<Moderator Message: Even as a newbie you should be able to copy and paste or read here and write there> Hi All, In the datasource '0CO_OM_OPA_6' , in the transfer rules for infoobject 0PART_CCTR' , we have a ruotine written 'Fill Partner Cost Cente
Hello Experts, Could someone please help me to fix the following issue with DATE AND TIME format. I have two info objects zdate with data type DATS (length 8) and ztime with data types TIMS (length 6). The data in the data source (alalertdb table) is
Hi friends, Small qns...Can u plz ans..i have routine for source field in transfer rules u2026 Now I donu2019t want assign any routine, constant, source field or formula for that source object and I want to delete that routine assignment..How we will
Hello experts, I want to use the SQL DISTINCT keyword to return non-duplicate results from a table in a DataSource (data base) in a the start routine for the transfer rules. How do I address that table in the start routine of the TR? I thought about
Hi guys, We r extracting data from generic extractor into BW.My target is to fill Attributes of 0Customer(Infoprovider) Infoobject. We have added two navigational attributes to it CLASS A and CLASS B. Data coming from R/3 has three fields Customer,Cl
Dear SDNers, I have a scenario to implement a start rouine code in the transfer rulesfor the Extractor - 0CO_OM_CCA_1 , please give a light on this. Scenario: The extractor 0C0_OM_CCA_1 brings in Cost Center transactional data for costs and allocatio