cancel
Showing results for 
Search instead for 
Did you mean: 

Key Field Name Problem

Former Member
0 Kudos

Hi everyone,

Our data type is like this:

Line_Item 1,unbounded

Footer 1,1

In the LINE_ITEM we don't have any key field so we cannot specify key field name in the FCC.

How can we define our FCC for this scenario? Definitely key field option will not work.

Thanks a lot!

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi all,

The structure of the file is somewhat like this:

LINE_ITEM

DATE

MATERIAL

AMOUNT

PLANT

FOOTER

ID

DATE

TIME

Values in the file would be like this

2007010852345680WN1

2008010953324510WN2

EF20080208120101

Could you tell me how I can define the FCC? Thanks in advance!

Former Member
0 Kudos

Hi,

I think u can not achieve this without the key values u need to have a key values to identify the line item and footer record.

Thnx

Chirag

Former Member
0 Kudos

Hi Mariel,

Going by the pattern of data that you have given, I believe you can use 'DATE' as your key field and proceed.

For eg:

Line_Item...........................0..unbounded

|___ DATE

|___ MATERIAL

|___ AMOUNT

|___ PLANT

Footer............................... 1...1

|__ ID

|__ Date

|__ Time

The content conversion parameters would look like:

Recordset structure: Line_Item,*, Footer, 1

Key Filed Name: DATE

Key field type: Integer

Please let me know, if you need more help.

Regards,

Varun

Former Member
0 Kudos

Mariel,

Since you dont have a key field in content conversion give as Line_Item,9999999999,Footer,1.

Here 9999999999 is the maximum no. of line items you will have. But here you have to make sure that your line items will not exceed this number. If you think it exceeds then increase the 9's accordingly.

Regards,

---Satish

Former Member
0 Kudos

Hi,

Can you please provide test file how it looks like.

Strucutre along will not help in giving solutions.

Thnx

Chirag