topic Re: BAPI/RFC function module - accessing with third party tool in Application Development and Automation Discussions

BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 10:09:11 GMT

Hello everyone,

I`m using XTRACTIS+SSIS tool to extract data from SAP ERP R/3 platform and for most of my data i`m reading transparent tables and extracting into my DataWarehouse for further ETL processes.

So far so good, but now i received a business request to read out all Long text Description for all of my materials from material master (MARA).

I have tried to use some BAPI modules but with no luck (e.g. BAPI_MATERIAL_GET_ALL ).

Can any of you experts provide me with a name of a BAPI to be able to access the long text description of material by imputing the MATNR field and receive the long text description obtain directly in ABAP by accessing the READ_TEXT function?

I apologize for posting this question into ABAP Development section!

Best regards,

Nicolae Foldesi

Re: BAPI/RFC function module - accessing with third party tool

SimoneMilesi — Thu, 08 Sep 2016 11:22:07 GMT

Hi Nicolae,

as first step, ask your ABAP collegue, if you have one: he should know the answer.

Did you check BAPI_MATERIAL_GETALL? It has a nice returning table MATERIALTEXT with all the long texts as well MATERIALDESCRIPTION with all the long descriptions

Re: BAPI/RFC function module - accessing with third party tool

Former Member — Thu, 08 Sep 2016 11:32:27 GMT

---------------------------

BAPI_MATERIAL_GET_ALL will give you all long text descriptions for the material

Just put Material number in parameter MATERIAL and retrieve long texts from table MATERIALLONGTEXT

-----------------

Or using READ_TEXT Function module with

NAME = Material number in internal format ( char18 )

LANGUANGE = SY-LANGU

OBJECT = 'MATERIAL'

ID = 'GRUN' or 'BEST' ... [ see the different values for iD in table TTXID ]

---------------------

Thanks

Re: BAPI/RFC function module - accessing with third party tool

SimoneMilesi — Thu, 08 Sep 2016 11:36:10 GMT

If you read the initial thread, the OP says clearly he cannot use READ_TEXT since he's invoking the FM an external system so he needs an RFC function and READ_TEXT isn't.

Re: BAPI/RFC function module - accessing with third party tool

Former Member — Thu, 08 Sep 2016 11:44:35 GMT

This message was moderated.

Re: BAPI/RFC function module - accessing with third party tool

SimoneMilesi — Thu, 08 Sep 2016 11:47:46 GMT

Why you suggest to create a Z RFC function when there is already a standard BAPI?

Re: BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 13:02:01 GMT

Hi Hichma,

I`ve read your answer and tried again with BAPI_MATERIAL_GET_ALL and exactly the long text misses to return - the other data it returns OK.

All the options are filled OK but the return is without LONG Desc

Anyway thanks for the reply!

Re: BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 13:10:02 GMT

Hi Simone,

Yes i did checked this BAPI and the only thing that doesn't return is the long text description.

I`ll ask and ABAP colleague, (even if i don`t have one - but i`ll find one), thank you!

It would be much easier directly in ABAP code of course, but i need the information inserted into my DataWarehouse and converted into nvarchar or text or any other format human readable - exact like you can see in MM03->AditionalData->Basic Data Text

Thanks for the reply!

Re: BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 13:12:30 GMT

I guess that the correct answer is "Ask an ABAP colleague"

Re: BAPI/RFC function module - accessing with third party tool

SimoneMilesi — Thu, 08 Sep 2016 13:16:27 GMT

It's strange that the table with long text is empty: do you pass/filter any language?

Re: BAPI/RFC function module - accessing with third party tool

Former Member — Thu, 08 Sep 2016 13:23:04 GMT

Hi Simone,

Nicolae is trying to access 'Basis Data Text' which I guess the BAPI won't provide. As per my understanding, no BAPI is provided for it. So a BAPI can be created and READ_TEXT can be called inside.

Regards,

Amit Kumar

Re: BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 13:23:49 GMT

I`ve checked table STXL and i have data inhere on two different languages. And yes i have looped for all languages.

I`ve also got some other documentation for this BAPI module and i saw table the table where from this bapi read the long text is "materiallongtext = " bapi_mltx_ga Long Texts" and in MLTX i don`t have any data, this is not even activated in Dictionary.

Re: BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 13:25:58 GMT

Maybe you are right Amit, but unfortunately i cant ask from the SAP guys to create me an Z bapi to read this text. I have to get solved without them, unfortunately.

Re: BAPI/RFC function module - accessing with third party tool

Former Member — Thu, 08 Sep 2016 13:33:56 GMT

If you looking for basic data text in MM03 then use Function Module READ_TEXT with

CLIENT = sy-mandt
ID = 'GRUN'
LANGUAGE = EN
NAME = material number in intern format (CHAR18 ) Add leading 0 if you have to
OBJECT = ' MATERIAL'

Thanks

Re: BAPI/RFC function module - accessing with third party tool

nicolae_foldesi — Thu, 08 Sep 2016 13:52:24 GMT

Yes indeed, you are perfectly right, but with my third party connector XTRACTIS from Theobald i cannot use the function itself i have to pass in a BAPI or a RFC Function module.

Re: BAPI/RFC function module - accessing with third party tool

SimoneMilesi — Fri, 09 Sep 2016 06:32:00 GMT

My fault, on "Basis data Text" i understood the long text under BASIC DATA tab, the material descriptions.

So dumb sometimes!

Re: BAPI/RFC function module - accessing with third party tool

Former Member — Fri, 09 Sep 2016 07:00:22 GMT

Hi Simone,

You followed the right procedure to understand the requirement. But,Sometimes, I do mind reading very fast which I should avoid. I have started contributing recently, so learning it.

Regards,

Amit Kumar