Current Position:Home > Issue with Mapping Spaces for Receiver Flat File Fixed Length

Issue with Mapping Spaces for Receiver Flat File Fixed Length

Update:10-11Source: network consolidation
Advertisement
Hi Mapping experts,
my scenario is receiver FILE (fixed length)
so if a validation applied on a target field returns false then I need to pass the spaces having the number of characters defined for that field
example
targetField length = 8
using "IF" function to perform validation,   if validation is true  THEN = FIELD
if validation is false ELSE = "________"    (underscore to represent 8 spaces)
the problem is the validation is of multiple occurences in one queue and if the "true" statement is on the 6th row, I get _________ which is the value of the 1st row (which is correct because rows 1 to 5 are all false therefore having the value of ELSE which is _______ mapped to it)
How can I get the value of the TRUE row regardless of what row it is located?
e.g. IF = input is 5 rows of validation,     TRUE is in the 3rd row,   i will get the 3rd row value
       IF = input is 5 rows of validation,     NO TRUE Value,   return 8 spaces
right now when i Display Queue values are
iF:in0          iF:in1          iF:in2          iF:out
1111          false          [_________]     [_________]
2222          false                    [_________]
3333          true                    3333
4444          false                    [_________]
5555          false                    [_________]
In above Queue i only get the value of the 1st row which is ________   --> because my target field occurrences definition in Data Type is 0....1
if I change Data Type occurrences to 1...unbounded I get 5 target fields generated --> WRONG because target file is fixed field, so only one occurence of that target field is required

The Best Answer

Advertisement
Can you give me the idea of what validation are you using so that anyone can help you with the UDF straightaway
because you need to have a UDf in place which will iterate the number of times the field occurs and then it will check the entire queue first ,where validation is true and only at the instant it will return the value
if the entire queue is value it will return the  8 underscores
I hope this is what you wanted
regards
ninad
  • Issue with Mapping Spaces for Receiver Flat File Fixed Length Update:10-11

    Hi Mapping experts, my scenario is receiver FILE (fixed length) so if a validation applied on a target field returns false then I need to pass the spaces having the number of characters defined for that field example targetField length = 8 using "IF&

  • Issue with Xi File Receiver "Content Conversion" fixed length and kanji Update:10-11

    I need to create a fixed length file for a customer that has kanji (SJIS) characters in it.  The issue is when the length of the value is less than the fixed length.  It is padding out with spaces, but it is putting 2 bytes per space instead of one (

  • How to receive flat file from XI to R/3 system? Update:10-11

    Hello guys, The XI will receive XML files from other source. I have to pick that XML file  and convert it in flat file so that i can receive it in R/3 with required BAPI. Guys plz tell me necessary steps need to follow to do the whole process. I dont

  • How to delete extra tab space in the flat file?? Update:10-11

    Hi all,     I have a flat file on presentation server which has 20000 records. In this file there are 16 fields and distance between each field is different and what I want is each field should have one tab space between another. Thanks & Regards Jer

  • Issue in calling webdynpro for loading flat file in IP Update:10-11

    Hello, We have implemented the How-To load flat files in IP paper and we are facing an issue in that. The generated webdynpro runs on ABAP Application server but we need to call this from a Web template which runs on portal server. These two servers

  • Mapping problem - trying to map lowerlevel field to flat file Update:10-11

    Dear experts, I have a rpoblem mapping my data. my input-xml looks like this: . orderheader ...orderdetail (1..n) .....delivery header (1..n) .......delivery detail (1..n) .........invoice header (always max 1 per delivery detail) ...........invoice

  • Issue with characterset setting in OWB flat file target Update:10-11

    an OWB mapping reads from the database source and writes to flat file target in unix os but junk characters are displayed for non english characters in the target file . The database table contains french,spanish,german,arabic characters.The nls db p

  • Issue in Production Support Due to FLAT-FILE Update:11-30

    Hi friends, Good morning to every one!!!        I got an issue from end user..        He was having an issue for a particular reoprt that his report values are not matched for R/3 values it seems...       In his report selection,  the selections are.

  • Issue in How-To document "Load flat file using SAPGUI"? Update:10-11

    Hi, I'm having an issue with following lines in the How-To document. I've a characteristic "CHAR1" which is restricted with multuple values in the planning level. after the upload using this document, CHAR1 is being loaded incorrect & during

  • SSIS: Why do columns become misaligned when importing flat files? Update:10-11

    Hi All I am stumped with the following. When I try to load a fixed length flat file into a table, the first few thousand records load correctly but then the columns start going out of sync. Visually it looks like the data is drifting off to the right