SAP BW options in update rules

by Calvin on June 30, 2008

SAP BW options in update rules

  1. one to one move of info objects
  2. constant
  3. lookup for master data attributes
  4. formula
  5. routine (ABAP)
  6. initial value

{ 0 comments }

SAP BW options available in the transfer rule

Assign info object, assign a constant, ABAP routine or a Formula (From version 3.x); example are :

  • Assign info object - direct transfer; no transformation
  • Constant - for example if you are loading data from a specified country in a flat file, you can make the country as constant and assign the value
  • ABAP routine - for example if you want to do some complex string manipulation; assume that you are getting a flag file from legacy data and the cost center is in a field and you have to “massage” the data to get it; in this case use ABAP code
  • For simple calculations use formula; for example you want to convert all lower case characters to upper case; use the TOUPPER formula

{ 0 comments }