cancel
Showing results for 
Search instead for 
Did you mean: 

0MAT_PLANT_ATTR update

Former Member
0 Kudos
169

Hi,

We need field SERNP from MARC table for a Report, this field doesn't exist in BI.

As of now I could see the field in Datasource 0MAT_PLANT_ATTR and also in Extractor Structure BIW_MARC_S.

I think no data is extracted to this field and also no infoobject to do the mapping in communication structure.

Could anybody help how could we get the data for this field, any step by step info would be helpful.

Thanks

Cheers

Venkat

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

The Info Object 0MAT_PLANT doesn't have an attribute to accomodate this field so if you want this data available in 0MAT_PLANT you should have an attribute to accomodate that.

As the reporting requirement is not clearly mentioned you can add a DSO in between the DS and IO so that you can accomodate this particular data over there and report it from DSO.

Regards,

Vishnu

Former Member
0 Kudos

Venkat,

SERNP (Serial Number Profile) field is available on the standard datasource 0MAT_PLANT_ATTR and does get replicated to BW. Have you replicated the datasource to the BW side and SERNP still does not show up?

Data will only be populated in this field if it has been recorded in ECC. So just do a quick load and pull some records for this datasource. Go to the PSA and check whether SERNP is populated. Once confirmed, you can start mapping it out to the right infoobject. Perhaps this may not be available as an attribute on the Infoobject that datasource 0MAT_PLANT_ATTR feeds into.

Former Member
0 Kudos

Hi Venkat,

check in rsa3 whther data displaying or not if the data is not displaying in rsa3 check with your code.

Regards

sivaraju