Skip to Content
author's profile photo Former Member
Former Member

Concetanate

Hi, can we use concatenate in SAP to combine several text field together?

I tried to use add a formatted search to combine Address (Line 1, Line 2, Line 3 of BP) of a vendor together in the OVPM,address (outgoing payment). That means when I pick Vendor A, then it will show that vendor address.

However, it seems that there is no "concatenate" function in SAP. Do you know how to do it?

Thanks.

Raymond

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 04:58 AM

    Raymond,

    Sridharan is true. If you want to have the result more readable in more lines, use it as

    SELECT T1.CardCode + char(10) + char(13) + T1.Street FROM dbo.CRD1 T1

    But be in mind, that at the end you should reflect the size of field where you want to write the result (it cannot exceed). For this use LEFT function.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 03:00 AM

    Hi Raymond,

    When you create a query (or formatted search), SAP Business One passes the query to the database server.

    So if you specify a concatenate function, it validates it against the database server.

    Your database should be able to support Concatenate fuction.

    Here's what you can do, create a query and run it in your database, make sure you remove survey and form variables before you execute the query.

    Laurence Resubal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 04:09 AM

    Hi Raymond,

    Use '+' between the fields to concatenate them.

    Ex:

    SELECT T1.CardCodeT1.StreetT1.Block+ T1.City+ T1.ZipCode + T1.State+T1.Country FROM [dbo].[CRD1] T1

    Regards,

    Sridharan T

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.