cancel
Showing results for 
Search instead for 
Did you mean: 

MSDS report in Report Information System

nirajsikligar
Active Contributor
0 Kudos

Hello all,

Have couple of queries related to MSDS report in Report Information System.

1) For the purpose of displaying Company Information in section 1 of MSDS, have used parameter report symbols under - CVDSENADRC EHS: Address data for initiator (sales organization) for report symbol group 05 Parameter: Shipping point-dependent data. (e.g. EHS_SNNAM1 NAME1, EHS_SNNAM2 NAME2, EHS_SNCTY CITY1 etc.)

Now when I preview the report in CG02 using report from template or in Report Information System (CG54) after generating report, as these are parameter symbols, it is promted to enter the data for user entries. My question here is, can values for these parameter symbols be defaulted? So that every time when user opens the report in Report Information System, he/she does not need to enter the same data all over again. In our case, as there is only one plant, address data for all the specification / material is going to remain same and it is cumbersome for user to enter same data manually every time he /she opens the report.

Please note that there is no Report shipping scenario involved.

2) We have another requirement of opening MSDS report in PDF directly in Report Information System (Tcode: CG54). It is possible to create PDF during report shipping, but we do not have report shipping scenaio. It is required that report opens in PDF directly in CG54. Is it possible? how? I have seen SAP note: 0001535067, but I believe it is for Report shipping and Report Export.

Appreciate early reply.

Thanks.

Regards,

Niraj

View Entire Topic
Former Member
0 Kudos

Hi Niraj,

We have the name of the sales organization in the generation variant.

In a function module, we start from the generation variant to find the address data in ADRC.

Advantage is that you have these contact details available in the raw sds.

Downside is that you may need additional generation variant.

Kind regards,

Luk

nirajsikligar
Active Contributor
0 Kudos

Hello Luk,

Can you please explain me details how you have mapped this scenario? Which FM is used and where?

Regards,

Niraj

Former Member
0 Kudos

Hi Niraj,

The function modules we use are custom build.

An example FM you can check for interface is C128_DUMMY_CONVERSION_METHOD

the first 4 characters of the generation variant correspond to the sales organisation.

The code looks somewhat like the following:

DATAW_SO(4) TYPE C,

         W_ADDR TYPE ADRNR,

         W_EMAIL TYPE AD_SMTPADR,

         W_RES TYPE TDLINE,

         W_RECN TYPE RCGLSYSELC-RECNTLP,

         W_RCGLSYSELC TYPE RCGLSYSELC.



  " Assign the import of Selection criteria for symbol values to a locale variable. After that, get the RECN from the RGV.



  W_RCGLSYSELC = I_SEL_CRIT.

  W_RECN = W_RCGLSYSELC-RECNTLP.



  " Select Sales Organization, first 4 characters from the name of RGV are equal to the name of SO...

  SELECT SINGLE LDEPID FROM ESTLP INTO W_SO WHERE RECN = W_RECN.

  " Select the Adress RECN from the SO. Adress data is saved in table ADRC with a unique adnr key...

  SELECT SINGLE ADRNR FROM TVKO INTO W_ADDR WHERE VKORG = W_SO.

  IF SY-SUBRC EQ 0.

    SELECT SINGLE SMTP_ADDR FROM ADR6 INTO W_EMAIL WHERE ADDRNUMBER = W_ADDR.

    IF SY-SUBRC EQ 0 AND ( W_EMAIL NE ' ' OR W_EMAIL NE '' ).

      W_RES = W_EMAIL.

    ELSE.

      W_RES = 'Not available.'.

    ENDIF.

  ELSE.

    W_RES = 'Not available.'.

  ENDIF.



  X_RCGLSYVAL-VAL_STRING = W_RES.

I hope this helps.

Kind regards,

Luk

nirajsikligar
Active Contributor
0 Kudos

Hello Luk,

Thanks a lot. Very helpful answer.

I was looking for some standard solution.

Regards,

Niraj