Need Batch Text in BI Report

[Former Member]

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

[kr_pavankumar]

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

[Former Member]

Hi Pavan,

We gave input in the FM as per ur suggestion and executed. But we are getting 0 records.

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

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

How to get the result and how to check the text of Batch Number.Please help.

Thanks.

Kavitha

[kr_pavankumar]

Hi Kavitha,

Here is an example

Step 1 :

In MSC3N :

For Material : 200-200

      Batch : 200-200-1

Basic data 2

Short text : 200-200-1 Batch text.

Step 2:

To Cross check : SE11 --> STXL

TDID : VERM

TDOBJECT: CHARGE

You can find the TDNAME value as "200-200               200-200-1" 

step 3:

Execute the FM : READ_TEXT by passing

ID : VERM

Lang : EN

NAME : 200-200               200-200-1           **  (fomat should be as in the table STXL)

OBJECT : CHARGE

You will get the one entry as per the selection after executing the FM under Tables.

Click on tables

You can find the TEXT entered in BASIC DATA 2 . PFA for your reference.

Hope it helps.

-- KRPK

[abdullahqureshi]

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

[former_member199945]

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 .

[Former Member]

Hi Seshu,

As per your suggestion we have tried with table RCTNAM/DFBATCH but it is a structure. Kindly suggest

[former_member199945]

CABN table will store all information related to ATNAM  (Batch) .First check either CABN table data is matching or Not with that Code .If its matching means create  a data source for CABN table. & relevant Descrtiption u can find in CABNT table.

[Former Member]

Hi,

We checked the table CABN as you suggested .However couldn't match with MSC3N.

Please give any solution.

Thanks .

[former_member199945]

How u checked ,  Please refer below wiki it will be helpful for better understanding of that MSC3N  tcode & helpful for validating . Especially need to consider  ATINN field from CABN Table.

Issues in fetching internal characteristics of materials - SAP Master Data Management - SCN Wiki

[abdullahqureshi]

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.