on 08-06-2010 10:20 AM
Hi,
I have a requirement to have a delimiter on the file to be '@', so I have set '@' as delimiter for segment groups, segments and composites on the format attributes. However, for the level 2 sort (Invoice details) the record should end with a delimiter '.' to say it is end of that invoice record. Next invoice for the same vendor continues in next record as shown below.
I tried many different ways, but it always puts a '@' for invoice record (at the end), as I have set delimiter '@' for seg group, segment and composites on the format attributes.
Have anyone encountered this issue? How do we accomplish this?
Thanks,
Kumar
DD@IN@8429324@INR@67640.00@@20080228@340045603@@@@@@@@@@@@NAM 530013@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@CITI02@3@CITIBA@@@@P@@@@@@@@@@@@@@@@@@
INV@Invoice-Number Inv.-Date Invoice - Amount Paid .
INV@1001113 28.10.07 320000.00 .
INV@1001114 28.10.07 360000.00 .
INV@TAVERA/006/07 01.01.08 40000.00 .
INV@INNOVA/005/07 01.01.08 40000.00 .
INV@UATBK 27.02.08 587640.00 .
INV@INNOVA/004/07 26.11.07 40000.00 .
INV@TAVERA/005/07 26.11.07 40000.00 .
DFT@IN@8429324@INR@128385.00@@20080228@3404500005@@@@@@@@@@@@ABC WOOD WORKS@@@@01@24681357@@@@@@CPCOTH@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@00000000@@@@@@@@@@@@@@@@@@
INV@Invoice-Number Inv.-Date Invoice - Amount Paid .
INV@04012008 04.01.08 99150.00 .
INV@04012008-2 04.01.08 29235.00 .
Hi,
We have achieved this by putting the delimiter as a separate field after each field instead of defining the seperator at group level.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can some one please advise how you entered the file format in the first place.
I have a requirement to transfer a payroll file which is currently in MT100 format to CITI bank in format GDFF.
I am using standard SAP program RFFOM100.
Regards,
Robyn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Include a new field in the Level 2 segment at the end as a constant with the value '.' Then in the segment level properties, choose 'Define different settings for this segment' in the 'Node Info' Tab for 'End of Segment' frame and enable CR/LF, instead of 'Copy settings from format header'.
This should work irrespective of what you have defined in your Format Attributes.
Ravi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
9 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.