Vendor master data load from flat file

[Former Member]

Hi Experts,

I am trying to load data from flat file. I am confused which info object i should use. My requirement is for info cube 0BBP_C01.

As i found for this info cube only two info objects are available: 0BBP_VENDOR and 0VENDOR. But in my flat file i have following fields: Vendor code, Vendor Name, Ultimate Parent, City, Country, Minority Status, Vendor Payment Terms. which all are together not present in either of info objects.

Please suggest which info object i must use. or should i create Z info object for my requirement?

Thanks in advance.

Regards,

Niranjan Chechani

[former_member188080 · Accepted solution]

Hi,

Just double check on R/3 SIDE most of the fields you mentioned are attributes of vendor.

Check whether those are added or not?

You can also get these from R/3 datasource or if you want to load through flat file you can do it.

If standard objects/fields are not available then you can create Z objects and add it in 0VENDOR as its attributes or you can create new Z Vendor master data object and add these new attributes in it.

I hope its clear for you.

Thanks and regards

Kiran

[Former Member]

RSDG_IOBJ_ACTIVATE is a program and not the function module. To execute it , use tcode SE38 and not SE37.

[former_member182343]

Hi Niranjan,

You can add unavailable attributes to 0vendor (no isssues).

Load master data using Flat file using info package up to PSA and run DTP and Attribute change run.

Make Adaptor as client workstation

Take .csv format.

(,) comma separator.

Regards,

rvc

Edited by: rvc171 on Nov 28, 2011 2:55 PM

[Former Member]

Hi,

If not required, then please delete unwanted fields from flat file.

or else you can create new infoobject.

Thanks & Regards,

Prachi

Edited by: prachinp on Nov 25, 2011 6:39 PM

[Former Member]

Hi,

All fields are necessary in my flat file : Vendor code, Vendor Name, Ultimate Parent, City, Country, Minority Status, Vendor Payment Terms.

Please suggest.

Thanks and Regards,

Niranjan Chechani

[Former Member]

Hi

go to meta data repository and select your cube(0bbp_c01) u will find here to what the characteristics required and key figures and note down the required key figures and characteristics in u cube and load data using OHD to flat file

[Former Member]

Hi Kiran,

I am loading data through flat file. I am not getting your point like how to get attributes present in the R/3 system which I am not using in this case.

Hi rvc,

I have created two characteristics z info objects i.e. ZU_PARENT for Ultimate parent and ZVEN_PAY for Vendor Payment Terms.

When i am trying to add these two as attributes and add it as Navigational attribute, I am getting the error "Characteristic 0VENDOR: The attibutes SID table(s) could not be filled" (Message no. R7586)

Please suggest am i wrong somewhere?

Thanks and Regards,

Niranjan Chechani

Edited by: Niranjan Chechani on Nov 28, 2011 12:15 PM

[Former Member]

Hi,

Try following option,

Go to RSD1 in change mode for the InfoObject. It is under Extras --> Database Tables --> Fill Attribute SID table

Regards,

Durgesh.

[former_member182343]

Hi Niranjan,

Do you want add these attributes as display attr. or navigational attributes.

You can add them as either display or navigational attributes.

After making this change and load data.

Then perform this activity - Extras --> Database Tables --> Fill Attribute SID table

Regards,

rvc

[Former Member]

Hi Durgesh,

I tried as u suggested but i am getting following error "Reconstruction of X/Y table was terminated with an error" (Message no. RSRV288) and now the info object 0Vendor is not in active state.

Hi rvc,

I want to add these attributes as navigational attributes. How can i load data without acivating the info object 0VENDOR (with my navigational attirbutes). First i have to active it. right?

Please suggest,

Thanks and Regards,

Niranjan Chechani

[Former Member]

Hi All,

I tried the methods mentioned in the upper messages but still the error "Characteristic 0VENDOR: The attibutes SID table(s) could not be filled" (Message no. R7586) persists. And now the info object 0VENDOR is not in active state.

One more thing i want to ask that should i use the below method before activating the info object or after actiavting the info object.

method : RSD1 in change mode for the InfoObject. Under Extras --> Database Tables --> Fill Attribute SID table.

Please suggest.

Thanks and Regards,

Niranjan Chechani

[Former Member]

Hi,

Please try to use following to activate.

RSDG_IOBJ_ACTIVATE Activation of InfoObjects

Assign points if helpful.

Regards,

Amit

[Former Member]

Hi Amit,

In which tcode i have to run this module?

I tried in se37 but it is saying that "Function module RSDG_IOBJ_ACTIVATE does not exist"

Please suggest.

Regards,

Niranjan Chechani

[Former Member]

Hi All,

The issue is resolved. I asked the Basis guy. And he has done some index rebuild and re process the temp datafiles. And it's done.

Points are assigned to the useful answers.

Thanks and Regards,

Niranjan Chechani