on 09-23-2009 1:58 PM
Source File Format
Ref. Field Name Field Type Length Description Mandatory (M) / Optional (O)
Structure: DTACHKH
1 BANKL CHAR 15 Bank number M
2 NAME CHAR 25 Name of Company Code or Company M
3 EXTRD DATS 8 Date of Extract Creation M
4 EXTRT TIMS 6 Time of Extract Creation M
5 DBUPD CHAR 1 Update Flag (Selected if the Database is Updated) M
6 VOID NUMC 8 Number of Records with Invalid Checks M
7 UNVD NUMC 8 Number of Records with Valid Checks M
8 TOTAL NUMC 8 Total Number of Edited Records (Valid + Invalid) M
9 AMNT NUMC 15 Whole digits of the amount converted M
10 DECM NUMC 3 Decimal places of the amount converted M
11 FILLER CHAR 31 Filler Field to Total Length: 128 Bytes M
Structure: DTACHKP
1 BANKN CHAR 18 Bank account number M
2 CHECF CHAR 13 Check Number From M
3 CHECT CHAR 13 Check number M
4 ZNME1 CHAR 35 Name of the payee M
5 AMNT NUMC 15 Whole digits of the amount converted M
6 DECM NUMC 3 Decimal places of the amount converted M
7 ZALDT DATS 8 Date of Issue M
8 VOIDR NUMC 2 Check void reason code M
9 FILLER CHAR 21 Filler Field to Total Length: 128 Bytes M
Target File Format
Ref. Field Name Field Type Length Description Expected Value /
SAP field
Mandatory (M) / Optional (O)
Transmission header
1 Identifier CHAR 5 Constant Value $$ADD M
2 Space CHAR 1 SPACE Space M
3 ID CHAR 3 Constant Value ID= M
4 RID CHAR 8 Constant Value ZQZUSRF1 M
5 SPACE CHAR 1 SPACE SPACE M
6 BIDID CHAR 4 Constant Value BID= M
7 BATCH ID CHAR 26 Provided by Wells Fargo FKI9600085651 M
File Header
1 record id CHAR 3 constant Value *03 M
2 Bank Id CHAR 5 constant value 00259 M
3 account number CHAR 15 Right justified, zero filled numeric DTACHKP-BANKN M
4 file status CHAR 1 always zero 0 M
Detail Records
1 check number CHAR 10 Right justified ,zero filled, numeric DTACHKP-CHECF M
2 Issue Date CHAR 6 Format MMDDYY. If check is voided then it should be '000000' DTACHKP-ZALDT M
3 Account number CHAR 10 Account number DTACHKP-BANKN M
4 Transaction Code CHAR 3 if DTACHKP-VOIDR IS '00' i.e. check is not voided then '320' ELSE '370' 320' or '370' M
5 AMOUNT CHAR 10 Right justified ,zero filled, numeric DTACHKP-AMNT M
6 ADDITIONAL DATA CHAR 40 DTACHKP-ZNME1 M
7 Unused CHAR 81 space space M
Trailer Records
1 record id CHAR 1 constant value 1 M
2 spaces CHAR 14 constant value spaces M
3 Detail Record Count CHAR 5 Total Number Records DTACHKH-TOTAL M
4 spaces CHAR 3 spaces spaces M
5 Total Amount CHAR 10 Total Amount, right justified zero filled, numeric DTACHKH-AMNT M
6 spaces CHAR 47 spaces spaces M
Give me configuration total senario?
Hi Sreenu,
Plz format your question properly to make it easily readable. What is you requirement and whats the problem??
regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Could you explain more clearly your requeriment?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.