How to read sort sequence and other properties of a specification in Cg02 .

[Former Member]

hello ,

i need to update the specification properties in CG02 basing on sort sequence for hazards and mariane pollutant of a specification.

do we have any standard Bapi or Fm to read the properties of Specification .

thanks for your help

Ananta

[kesavadas_thekkillath]

Hi,

Check for the functions available in function group C1F5 and also check the business object BUS1077

Kesav

[Former Member]

Yes - BAPI_BUS_1077* or FUGR C1F5 should be used.

Do not forget to call BAPI_COMMIT (BUS1007) or C1F2_SUBSTANCES_SAVE_TO_DB (when using e.g. C1F5_SPECIFICATIONS_READ followed by C1F5_SPECIFICATIONS_MODIFY). Otherwise the changes are stored in memory only.

have fun!

hp

[Former Member]

hello ,

how can i read a specifcation data for Transporation data .in that transportation data i need to read hazards inducers and mariane pollutants .

For example : for specifcation roh-tst-019 ... i need to read sort sequences , regulatry basis and specifcations at value assignements .

thanks

Ananta

[Former Member]

Hello ,

How to update the values in CG02 under Transport Information , in that Hazards Inducers tab .

need to update the specification based on the DG regulation ,hazards inducer type .

Ananta

[Former Member]

hello ,

How to read data of specifcation under the Property tree -

---

>transport information----

---

>Hazards inducers data in Cg02 Tcode ?

please help with any standard Fm or any table ......

Anant

[Former Member]

well -

specifications are rather complicated - there are many tables linked by internal keys. As most of them (and all in the folowing overview) begin with 'EST' I only use the subseqent letters - so table ESTRH is written as RH below.

Here an - uncomplete - overview

Header: RH

2nd level:

- RR References

- RI Identifiers

- MJ Material Joins

- VH Valuation Headers (containing field ESTCAT for valuation type)

3rd level:

- VA - Valuation (instance - containing sequence number (field ORD - non unique!)

4th level - data of the valuation:

- PR Data stored in class system (such as regulation, DG-Class)

- DU Usage

- VP Components

- 0F Transport Classification (containing Hazard Inducers)

-...

In general you can determine the related table if you look at the technical info at CG02. The structure name will be like

"RCGxxIOT" where xx stands for the last two letters of the table ESTxx. The structure of interfaces in FUGR C1F5 are defined with a similar pattern: ESPRH_APIxx_TAB_TYPE.

To read the data, you may use FM C1F5_SPECIFICATIONS_READ which has sufficient documentation. You may refer to the documentation of obsolete FM C1F2_SUBSTANCES_READ as well.

A good alternative is BAPI_BUS1077_GETDETAIL - as this is a BAPI Function it should work after an upgrade while FM of C1F5 migh make some adaption necessary.

However - it will take some days to understand both - the data model of specifications and the related FMs. I personally would recommend a developer familar with this 1yr+ before asking for implementations that are not only reading data - but they are hard to find....

have fun!

hp

[Former Member]

hello ,

Upfront thanks , I am also looking into same BAPI function module to get the information ....

but i am not able to get the right information which i need ...even the structure(PROP_TAB0F) is empty in the following bapi

BAPI_BUS1077_GETDETAIL.but other informations like PROP_HEADER and others .

could you please help me out wat r the values i need to send to BAPI ..that would be great help to me ...

thanks

Ananta

[Former Member]

Hi,

yuo really should read the documentation. Beside this

- fill keydate

- set flags of for tables you like to read with 'X' (FLG_PROPERTIES, FLG_PROP_DATA, FLG_PROP_DETAILS, FLG_DANG_GOOD_DATA) I always flag header too.

- fill field SUBSTANCE in table SUB_HEADER

- append lines with filled field SUBCHACAT (valuation type) for the valuations you want to read - otherwise all valuations are read (can be very time consuming).

CAUTION: Be sure that the data you need is maintained at the substance you are reading. If you try to read all this at a real substance which is classified for transport by reference to a dangerous goods classification you will NOT be able to read any data at UN-listed substances used there. In this cases you must first read the components of dangerous goods classification (UN-Listed substances) and read the data from those. Refer to SAPDOCU on Dangerous Goods Masterdata and its filling for more details.

have fun!

Holger

[Former Member]

hello ,

i need to read the data in Cg02 under property tree -

---

Transport information -

---

Hazards inducers ---in that tab the values i need to read for a specifaction and need to updae one value in that tab ?

can any one please help how to do that using BAPI_BUS1077_GETDETAIL.

Anant

[Former Member]

Hi,

the hazard inducers are in table PROP_TAB0F.

Please note that not the substance id but the record no. is stored in field REF_RECNVP. So you may use a select single on ESTRH or a simple BAPI call at header level to convert subid to recn. FM C148_TRANSLATE_SUBID_TO_RECN_1 and C148_TRANSLATE_RECN_TO_SUBID would do as well.

It will take some time to become familar with the datamodel and the BAPI . SAP delivered some examples:

RC1_1077_BAPI_EXAMPLE_CHANGE

RC1_1077_BAPI_EXAMPLE_DG

RC1_1077_BAPI_EXAMPLE_GENERAL

In addition SAP-Notes 1111161 & 800918 (for some background reading) might be helpfull.Together with the documentations of FM BAPI_BUS1077* and C1F5* (C1F2* for background) you should master your task.

Kind regards,

hp

[Former Member]

hello ,

Thanks for your reply ...

i am doing analysis .

How to read under transport Information tab i need to read the Value Assignement and Spec.listing values in CG02.Based on this values i need to update against Transport information in that Hazards inducers specification (Subid).

i am using the BAPI_BUS1077_GETDETAIL ,but unfortunaltly i am not able to get the data required in table sturucres .

Even i am keeping X in the importing parameters for FLG_READ_ALL_CHARACT, FLG_DANG_GOOD_DATA,FLG_IDENT,and so on ....

Could you please tell me what is the values i need to put for this BAPi to read the values ...

thanks for reply

Annat

[Former Member]

Hi,

1) you may not have authorization to read the data - check in CG02 - only if you see data there you will be able to access them by BAPI

2) read documentation:

Depending on the import parameters, the following output tables are expected at the interface and assigned values:

- FLG_HEADER = 'X'  SUB_HEADER 
- FLG_HEADER_USAGE = 'X'  PROP_USAGE 
- FLG_REFSUBS = 'X'  REFSUBS 
- FLG_IDENT = 'X'  IDENT_HEADER, IDENT_SUBLIST 
- FLG_IDENT_LONGTEXT = 'X'  IDENT_LONGTEXT 
- FLG_IDENT_USAGE = 'X'  PROP_USAGE 
- FLG_MATJOIN = 'X'  MATJOIN 
- FLG_TPLREL = 'X'  TPLREL 
- FLG_APPLSCP = 'X'  APPLSCP 
- FLG_PROPERTIES = 'X'  PROP_HEADER, PROP_VAL 
- FLG_PROP_DATA = 'X'  PROP_DATA, PROP_COMPONENT 
- FLG_PROP_DETAILS = 'X'  PROP_USAGE, PROP_RELIABILITY 
 PROP_SOURCE 
- FLG_PROP_FTEXT_LONGTEXT = 'X' PROP_FTEXT, PROP_FTEXT_LONGTEXT 
- FLG_DANG_GOOD_DATA = 'X'  PROP_TAB07, PROP_TAB0B, PROP_TAB0D 
 PROP_TAB0F

so you shoud check Header, Properties and DANG_GOOD_DATA

- and don't forget to filll table sub_header.

kid regards,

hp

[Former Member]

hello Hp,

i can access CG02 and i can see the data ...

but when i try to execute the BAPI , i can see some data of PROP_TAB0F like DANGODREG as 12 records but HISCAT(EH&S: Hazard Inducer Type) and i am not able to find the data of Spec.listing in the BAPI. like fields (SUBID and sort sequence )

Thanks

Anant

[Former Member]

Hi,

SUBID is not in 0F but REF_RECNVP - this is the record no (key of ESTRH) of the hazard inducing substance (type HI_CAT). Use C148_TRANSLATE_RECN_TO_SUBID to get subid.

For changes you nned the recn of the new substance - you may use C148_TRANSLATE_SUBID_TO_RECN_1 for that.

There is no sort sequence in table 0F - The sort sequence of valuation is in table VA. Read the VA entry with key RECORD_NO = 0f~REF_RECNVA to get field SEQUENCE from there.

kind regards,

hp

[Former Member]

Thnaks HP,

in that bapi ,where we can find the identifer values ...i am getting in BAPI1077RI but those are header identifier ...

i want identifer of hazards ...

Anant

[Former Member]

Hello,

How to read the values of Specification listing ?

Like sort sequence and Specification (SUBID) and identifier ....

can u please tell me how to read all these values into BAPI....

For eq: i have specification values like numbers (SUBID) -

---

sort seq 1 : 000000000307 sort seq 2 : 000000000473

Plz

Anant

[Former Member]

"i want identifer of hazards ..."

another bapi call with subid of HazInds

[Former Member]

"How to read the values of Specification listing ?

"

- they are in ESTVP (only HazInds are in 0F).

kind regards,

hp