error when loading master data via data stream

[Former Member]

I successfully created and tested a method to "Load from Data Stream" for items using infoobject 0gl_account.

I have successully transported all config to a QA system (or at least think so) and am now getting a hard error message that I have been unable to work through.

The error message no. is UGMD016, Diagnosis: Characteristic Source system ID has no master record with the value . (The non-existing value was stored as an attribute for characteristic G/L Account and value Q5.)

The mystery begins though when I go and look at characteristic Source System ID (0SOURSYSTEM), an entry for Q5 exits.

I think I've searched here on the forumn and within SAP notes for any possible help, but would not mind being proven wrong!

Any ideas??

[Former Member]

solved -

within technical view --> characteristics, source system & source system ID needed a record with QE1CLNT215 & Q5 created manually.

[Former Member]

Right. You had to synchronize master data in BW and SEM-BCS first.

[Former Member]

Within the consolidation area, field FYV is already set as 'Fixed in Cons Area' = K4 & CoA = '0010'.

0SOURSYSTEM is not an available field.

[Former Member]

Eugene -

I just tried to manually create an item/GL account master record within UCWB and I get the same error message(s) for source system & source system ID. So... it does not appear to be specific to the LFDS. Is there some basis setup that is missing even though the following table entry exists in table RSSOURSYSTEM?

LOGSYS SOURSYSID

QE1CLNT215 Q5

I see it as a source system within RSA1 as well...

Lori

[Former Member]

Hello Lori,

Wow, you have so many infoobject with a function of account!

And which one has the FS Item role ? 0GLACCOUNT?

I do not have the system under my hands right now (in order to look at some features). Anyway (correct me if I'm wrong). 0GLACCOUNT has a compounding attribute 0SOURSYSTEM? Usually, in SEM-BCS the infoobject with FS Item role has a compounding attribute that plays the role of chart of accounts.

The key feature of SEM-BCS is that (in order to function properly) all componding attributes should be fixed in the consolidation area (like CoA for items, fiscal year variant for fiscal year etc.). -- certainly, it's true only if these attributes are seen as the separate objects in the ConsArea.

Try to fix them. Should help.

Edited by: Eugene Khusainov on Dec 9, 2008 11:56 AM

[Former Member]

Just in case, fixing the compounds here means setting up the values in the ConsArea.

Like

FYV = K4

0SOURSYSTEM = Q5 or QE1CLNT215

CoA = '0010' etc.

[Former Member]

Ok Lori,

You answered the last part of my questions.

What about the 1st one:

>

> And which one has the FS Item role ?  0GLACCOUNT? 
> 
> I do not have the system under my hands right now (in order to look at some features). Anyway (correct me if I'm wrong). 0GLACCOUNT has a compounding attribute 0SOURSYSTEM?

[Former Member]

FS Item role is the mandatory one. And it must be compounded by CoA role. If you use now 0glaccount with this role, it's the error. You'll must change it to another infooubject with CoA compound. By default the 0CS_ITEM is used.

[Former Member]

Hi Lori,

It's not enough information.

Please describe the mapping in the LFDS method, especially regarding the FS items. And what are the structures (attributes, compounds etc.) of incoming account and BCS-cube FS item infoobjects.

Do not forget abt 0SOURSYSTEM and its role in the settings.

[Former Member]

Fair enough. Here are the steps I have taken:

1. Created a Source Data Basis of 01 for Master Data with Field Catalog value of 0SEM_BCS_CHA02 for InfoObject Catalog for Chars, attributes of tech names /1FB/ACCOUNT, /1FB/BUS_AREA, /1FB/CHRT_ACCTS, /1FB/COMPANY, /1FB/GL_ACCOUNT, /1FB/PBUS_AREA, /1FB/PCOMPANY.

2. Created method DS01 for Upload of GL master data for LFDS function for data type 21 Items, characteristic /1FB/GL_ACCOUNT, Source data base = 01, InfoObject 0GL_ACCOUNT (which resides in catalog 0SEM_BCS_CHA02 & has attributes of 0BAL_FLAG, 0INCST_FLAG, 0LOGSYS, 0SEM_POSIT, 0SOURSYSTEM, 0GLACCEXT and compounded with 0CHRT_ACCTS), Load Master Data checked within Options for Master Data & Hierarchies, Overwrite selected for update mode and no BADI.

Mapping: Chart of accounts Move '0010', G/L Account Move G/L Account, Balance Sheet Acct Move Balance Sheet Acct, Fincl Statement Item Move Fincl Statement Item, Ind.: P&L Account Move Ind.: P&L Account, Source System Move Source System, Planning Item Move Planning Item, Source system ID Move Source system ID, Breakdown Cat. Move Fincl Statement Item, Item Type Condition Balance Sheet Acct;Move '1';Condition Ind.: P&L Account;Move '2' , Dr./Cr. Sign Condition Chart of accounts, G/L Account;Move '+';Condition Chart of accounts, G/L Account;Move '-' , Long description Move Long description, Short description Move Short description

Selection: Chart of accounts = 0010 for Selection of Source.

3. I confirmed that characteristic 0GL_ACCOUNT contains active master data with CoA value = 0010. The master date lines have a Source System value of QE1CLNT215 and Source System ID of Q5.

Anything jump out? Please let me know if there is additional information that may allow you to help me.