File Content Conversion Parmeter

[Former Member]

Hi Experts !!!

Just want to know about the parameters "keyFieldValue" and "keyFieldName"in the File sender Comm Channel FCC parameters. In the "keyFieldValue" can we specify more than one value.

I have refered the blog:

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

In the txt file, the header/Title record is identified by "H" and the trailer record is identified by "T". The remaining records are identified by either "Y" or "N"

H 00000 SAPPI 000999

0001 Richard 111.99 08/23/1999 Y

0001 Rich 111.99 08/23/1999 N

0001 Ria 111.99 08/23/1999 N

0001 Richar 111.99 08/23/1999 Y

0001 Rid 111.99 08/23/1999 N

0001 Rachar 111.99 08/23/1999 N

0001 Richard 111.99 08/23/1999 Y

T 00007

For the above requirement, Can i define the data.keyFieldValue as Y,N (Should be able to assign multiple values)

Recordset Structure : header,1,data,*,trailer,1

keyFieldName:Identifier

header.keyFieldValue : H

data.keyFieldValue : "Y","N"

trailer.keyFieldValue : T

If not how can i accomodate mutiple values.

Regards

Ramani

[former_member518917 · Accepted solution]

.

[Former Member]

Hi,

No its not possible to specify multiple values for the same key. The key field is specified to generate a substructure.

Here is what the help.sap.com document says :

NameA.keyFieldValue

Specify the value of the key field for the structure. This entry is mandatory if the key field name is set. Otherwise, the entry is ignored.

So its clear that you cannot have multiple key values for XI to create a same Substructure.

But you can create 2 substructures in your case,, 1 for value Y and the other for value N. If thats what you want to achieve

Best regards,

Advait.

[Former Member]

for your requirement the field key value would be 0001. when you give like this XI can differentiate Header and Trailer from Data records.

Check some links for FCC

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

[Former Member]

Hi,

Please find the revised text file, the header/Title record is identified by "H" and the trailer record is identified by "T". The remaining records are identified by the last column either "Y" or "N".

H 00000 SAPPI 000999

0001 Richard 111.99 08/23/1999 Y

0002 Rich 111.99 08/23/1999 N

0003 Ria 111.99 08/23/1999 N

0004 Richar 111.99 08/23/1999 Y

0005 Rid 111.99 08/23/1999 N

0006 Rachar 111.99 08/23/1999 N

0007 Richard 111.99 08/23/1999 Y

T 00007

How do we specify the keyFieldValues if at all it has multiple values.

Thanks

Ramani

[Former Member]

try as below

Recordset Structure : header,1,data,*,trailer,1

keyFieldName:Identifier

header.keyFieldValue : H

data.keyFieldValue : "Y"

data.keyFieldValue:,"N"

trailer.keyFieldValue : T

or

header.keyFieldValue : H

data.keyFieldValue : "Y"

data1.keyFieldValue:,"N"

trailer.keyFieldValue : T

if it works it shd give you all the records with Y and then all the records with N, but i don't think it will work, as i know the key value shd be first record of the record set.

if this doesn't work, you shd be able to get a file with D infornt of data records. this can be achieved by writing a script program which excutes before FCC runs.

Edited by: Chirumamilla Sukarna on Sep 25, 2008 11:00 PM