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

Need Batch Text in BI Report

Posted on Mar 13, 2014 at 07:13 AM 341 Views

Hi all,


One of my Client needs batch text in my BI Report.

I checked the transaction MSC3N in which, they are maintaining description of that.

The structure name for that is RCTAV and the field name is ATNAM.

can you please guide me how to get batch(0BATCH) text into sap bi.


Thanks & Regards,

Kavitha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Pavan Kumar K R
    Pavan Kumar K R
    Posted on Mar 13, 2014 at 09:51 AM
    1

    Hi Kavitha,

    Pass the following values to the FM : READ_TEXT

    ID : VERM

    Lang : EN

    NAME : Material + batch (Check the tables STXH and STXL )

    OBJECT : CHARGE

    Execute.

    In the result you can see the Text of the Batch number which is entered in

    Tcode : MSC3N --> Basic data 2 -- > Short Text.

    Hope it helps!!

    -- KRPK

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Abdullah Qureshi
    Abdullah Qureshi
    Posted on Mar 13, 2014 at 07:25 AM
    0

    Hi,

    I think it can done by creating a generic data source based on table or view from which you are getting 0BATCH text. In BI side do its modelling for getting text.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo SESHU PS
    SESHU PS
    Posted on Mar 13, 2014 at 08:21 AM
    0

    Need to create Custom Data source For table RCTAV/DFBATCH in ECC (Check either these table values are Matching or not with tcode MSC3N ) & then create data source. Pull same Data into BI .

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Abdullah Qureshi
    Abdullah Qureshi
    Posted on Mar 13, 2014 at 09:12 AM
    0

    Just check with client/Functional guy about the table; they will tell you exact table from which they want 0BATCH text.

    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.