Removing ‘#’ in BEX analyzer

Archive for March, 2010

Removing ‘#’ in BEX analyzer

By BMG on Wednesday, March 31st, 2010 | No Comments

GA_googleFillSlot(“POSTSAP”); In BEX analyzer, a query cell with blank value (in characteristics) is filled by default with values like ‘not assigned’ or ‘#’ , and sometimes this is not the best output to present to an end-user. Googling the web, we found a easy solution to replace those values with the desired blank value. The [...]

Date and Time validation

By BMG on Tuesday, March 30th, 2010 | No Comments

Sometimes, we need to validate some inputs from users that are inserted by external sources (like files). For this purpose, we found very useful function modules like CONVERT_DATE_TO_INTERNAL and CONVERT_TIME_INPUT to validate external dates formats and external times formats (ex: dates like ’24.06.1978′ or times like ’11:00:00′) This functions are also very useful to convert [...]

Difference between KOBED and KOBEV

By admin on Monday, March 29th, 2010 | No Comments

In pricing there are requirements, and inside this requirements there are 2 forms, KOBED and KOBEV. What’s the difference between them? KOBED – This is called at header and item level KOBEV – Used for header level Use KOBEV if you only need header changes. If you use KOBED and only need header data your [...]

SAP CRM building blocks / best practices

By BMG on Monday, March 29th, 2010 | No Comments

Building blocks are a very useful resource that SAP offers to you to help configuring a vast set of scenarios. They’re simple step-by-step instructions and they’re also called SAP best practices. If you need a guide to start your CRM project, here’s a good starting point: – Building blocks CRM 2007 – Building blocks CRM [...]

Change account group

By BMG on Sunday, March 28th, 2010 | No Comments

Do you need to change a customer account group? You can do it by using t-code XD07. Just enter the customer number, and enter the new account group. It’s easy as that, but just be careful with compatibilities with field settings between two account groups and number range interval (you can check it on t-code [...]

Inbound/Outbound Emails

By BMG on Saturday, March 27th, 2010 | No Comments

Sometimes, we must deal with a system that receives/sends emails, and you want to check the ‘traffic’. This are the most used ways that we use to check this information. For inbound emails – Running report RSBCSIN – Running t-code SOIN For outbound emails – Running t-code SOST Feel free to share with us your [...]

Hide functions in reports

By BMG on Friday, March 26th, 2010 | No Comments

Have you ever need that your program don’t show the execute button, or background execution option, or even the variant selection option? You can do it but declaring this info: REPORT bla bla bla. …. *- Data declaration DATA gt_exclude TYPE TABLE OF rsexfcode. DATA gs_exclude TYPE rsexfcode. … INITIALIZATION. *- Hide options gs_exclude-fcode = ’ONLI’. ”Hide execute APPEND gs_exclude TO gt_exclude. gs_exclude-fcode = ’PRIN’. ”Hide Print+Execute APPEND gs_exclude TO gt_exclude. gs_exclude-fcode = ’SJOB’. ”Hide Execute in backgroun [...]

What is the differences between 4.6, 4.7, 5.0, 6.0, versions

By BMG on Thursday, March 25th, 2010 | No Comments

You don’t know? Really? If not, check excellent Eric Cartman reply at SDN. We cannot do it better

CRM Database View: Document + Related Information

By BMG on Wednesday, March 24th, 2010 | No Comments

Database views are very useful to gather information from various related tables. Especially when programming…. SAP CRM provides some database views in a way that can be easy to collect massive data about documents. One example: if you want to get information about partners from a document, you can use database view CRMV_LINKPARTNER. Another example: [...]

BW monitoring tool

By BMG on Sunday, March 21st, 2010 | No Comments

Have you ever wished for a good single-access point for BW monitoring? The answer is a tool called ‘Analysis&Service tools launchpad’. Just enter t-code ST13, enter BW-TOOLS and execute. From there you can analyse process chains, requests or even agregates. Just try it yourself

SAP KD

Archive for March, 2010