SAP KD

Archives

Archive for March, 2010

March 31, 2010 @ 12:15 am

Removing ‘#’ in BEX analyzer

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 solution is based on Visual Basic and consists on creating a  macro like this one:

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

If queryID = “SAPBEXq0001″ Then
resultArea.Select

‘Remove ‘#’
Selection.Cells.Replace What:=”#”, Replacement:=”", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, MatchByte:=True

‘Remove ‘Not assigned’
Selection.Cells.Replace What:=”Not assigned”, Replacement:=”", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, MatchByte:=True

End If

‘ Set focus back to top of results
resultArea(1, 1).Select

End Sub

Our reference was a cool article, located at this link.

Good coding!

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Filed under BW · No Comments »

March 30, 2010 @ 4:49 pm

Date and Time validation

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 the external information to internal information.

If you need more conversions of this kind, take a look at utility class CL_ABAP_DATFM.

Check if is helpful for you too, or if you have any other suggestions feel free to share with us!

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: +1 (from 1 vote)

Filed under BC - ABAP · No Comments »

March 29, 2010 @ 4:13 pm

Difference between KOBED and KOBEV

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 performance may not be the best!

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Filed under BC - ABAP, SD, Tips · No Comments »

March 29, 2010 @ 12:15 am

SAP CRM building blocks / best practices

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 7.0

Good readings and good luck!

VN:F [1.9.3_1094]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.3_1094]
Rating: +1 (from 1 vote)

Filed under CRM · No Comments »

March 28, 2010 @ 12:15 am

Change account group

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 OVT0).

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Filed under SD · No Comments »

March 27, 2010 @ 12:15 am

Inbound/Outbound Emails

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 method :)

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Filed under Tips · No Comments »

March 26, 2010 @ 12:15 am

Hide functions in reports

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
APPEND gs_exclude TO gt_exclude.
gs_exclude-fcode  = ’GET’. ”Hide Call variant
APPEND gs_exclude TO gt_exclude.
gs_exclude-fcode  = ’VSHO’. ”Hide Show variant
APPEND gs_exclude TO gt_exclude.
gs_exclude-fcode  = ’VDEL’. ”Hide Delete variant
APPEND gs_exclude TO gt_exclude.
gs_exclude-fcode  = ’SPOS’. ”Hide Save as Variant
APPEND gs_exclude TO gt_exclude.

*- Do it!
CALL FUNCTION ’RS_SET_SELSCREEN_STATUS’
EXPORTING
p_status  = ’%_00′
p_program = sy-repid
TABLES
p_exclude = gt_exclude.

VN:F [1.9.3_1094]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.3_1094]
Rating: +1 (from 1 vote)

Filed under BC - ABAP · 1 Comment »

March 25, 2010 @ 12:15 am

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

You don’t know? Really?

If not, check excellent Eric Cartman reply at SDN. We cannot do it better :)

click to enlarge

VN:F [1.9.3_1094]
Rating: 3.0/5 (2 votes cast)
VN:F [1.9.3_1094]
Rating: -1 (from 1 vote)

Filed under Fun · No Comments »

March 24, 2010 @ 9:55 am

CRM Database View: Document + Related Information

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: if you want to get information about organizational data from a document (header level), you can use database view CRMV_LINKORGMAN.

Check for database views with prefix CRMV_LINK*, for more combinations.

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Filed under CRM · No Comments »

March 21, 2010 @ 10:59 am

BW monitoring tool

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 :)

VN:F [1.9.3_1094]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)

Filed under BW · No Comments »

About

The absolute best damn Wordpress Gallery on the net. ArenaWP is the sandbox for various designs by Terry Ng of Kineda.
Read More

Social

Subscribe by email:

Delivered by FeedBurner

Pages

  • Loading...


    Loading...

    Login






    Register | Lost password?



    Register





    A password will be mailed to you.
    Log in | Lost password?

    Retrieve password





    A confirmation mail will be sent to your e-mail address.
    Log in | Register
  • Calendar

    March 2010
    M T W T F S S
    « Aug   Apr »
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  

    Sap Websites

    Recent Posts

    Categories

    Disclaimer

    SAP and the SAP logo are registered trademarks of SAP AG. SAPKD.com is a personal blog and is not affiliated with SAP or other companies mentioned here. I capture the things I learn that might be helpful to others here. No warranties on the information provided are offered or implied. Please feel free to use at your own risk