on 08-20-2008 9:53 AM
Dear Friends,
We are doing the scenario SAP ERP ==> XI ==> SAP POS. This is IDoc to File scenario. The file is picked from FTP site by receiver(where the Triversity server pick ascii files).
Here problem is after picking the file, data is not inserted, updated, deleted in the Customer Profile table of Triversity Store Manager. (We follow the Technical Reference Guide for creating files).
Regards,
Jagan.
Hi
This problem occurs due to mandatory fields of customer.
if a field is mandatory and you're not passing any value...the file created on ftp will skip that field and asc file will not upload in customer store manager...
use IF-ELSE condition in mapping for mandatory fields...
if value exits ..pass the value...else pass blank...
Hope this will help...
Abhijit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Friends,
In mapping we have to use if-else condition for all fields. We have to pass blank constant if no data for that field. This is applied for all fields. Even though Customer Number and Updtate type fields only mandatory, the target file should contain minimun 46 commas. That is customer table may contains 47 fields. We do the FCC in receiver adapter and create the file successfully. The file is picked and updated by SAP POS system.
Thanks for your valuable suggestions friends...
Regards,
Jagan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI experts ,
After integration of SAP retail and SAP POS, we are receiving file from PI for e.g DEPTTXN.asc (below) ,
As according to DEPTTXN.ASC file format update type ,department, department group ,description should be of Decimal 2.0,decimal4.0, decimal 3.0 and string 20 respectively,
But we are receiving data in below mentioned format ,because of that when we are posting this file to Xpress sever-> parm folder to view its data in Store manager we are not
able see all the details of DEPTTXN.asc ,only price point details with the linked category and department are shown there. We are facing same difficulties with other two files also.
Do we have to do some modification in PI for the naming of department and department group?
It will be great help ,if you can guide us to solve this particular issue.
99
2,MC11111,MC11110,"class. dresses, long",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC11142,MC11140,"skirts, short",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC11151,MC11150,"shirts, 1/1 sleeve",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC11152,MC11150,"shirts, 1/2 sleeve",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC11422,MC11420,"sweatshirts",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC11441,MC11440,"shirts,le.1/1 sleeve",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC11451,MC11450,"ties, classic",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC13101,MC13100,"meat, sausage",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC13102,MC13100,"fruits, vegetables",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC13103,MC13100,"dairy goods",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC13104,MC13100,"bread and pastries",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC14501,MC14500,"garden equipment",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC22003,MC22000,"Rolling trolleys",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
2,MC_ECKP,,"price point",,,,,N,N,,Y,,,,,,Y,,,N,N,,,,,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Y,,,,N,N,N,N,N,N,N,N,N,N,N,N,,,,,,,,,N,N
HI jagan.
could you please share your mobile number.
regards
abhishek
09008833411
Edited by: abhishek011 on Jul 16, 2009 7:56 AM
HI,
Check the File Encoding format ...it is in readable format for Customer Profile table of Triversity Store Manager.
May be Text encoding format be the problem or...check if you are processing the file after completion of whole XI transcation to put file on FTP.
Thanks
Swarup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Swarup,
Actually we did the scenario and file is coming correctly. For Vendor scenario it is working correctly. Even we are putting file manually it hasn't work. The structure differ from Customer Table in DB and it mentioned in Technical Reference. The fields are not in order while comparing both, and mandatory fields are not mentioned in Technical Reference.
Regards,
Jagan.
Edited by: Jaganmohan Ponmani on Aug 20, 2008 4:21 PM
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.