on 12-03-2009 7:51 AM
Hi Experts
This is JDBC to IDoc scenarion.
Source: MS SQL Server
Date Data Type: smalldatetime
Date field Format: yyyy-MM-dd hh:mm:ss --> example: 2009-11-13 00:00:00
XI Mapping: Source Date --> Transformation --> Target Date
Transformation: yyyy-MM-dd hh:mm:ss to yyyyMMdd
Target: R/3 System
Date Data Type: ERDAT from VBAK table - Date on Which Record Was Created
Date field Format: Date field (YYYYMMDD) stored as char(8)
Check points:
1. Mapping is working fine in XI and transformation is done with the test data: 2009-11-13 00:00:00 --> to ---> 20091113
2. In SXMB_MONI the data is processed from the source and the IDoc XML data is generated. In the IDoc XML data the date field is containing the value <DATE>20091113</DATE>
3. But when I tried to open the IDoc(SE05) in R/3 the date field is empty and no data is generated.
Request you to let me know why the error is happening.
Regards
Ram
Hi Rama,
You mentioned that the IDoc is in status 51. Does your header record contain appropriate values? If so you can check SAP Note 835058 - "An IDOC without a message type was passed to ALE Layer" assuming this is the same error you are faced with.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ram,
its giving any error in moni or Black and white flag?? check the payload in Moni,if its there then the problem with Connection.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vijay
I have test IDOC in ECC box from the IDoc Test Tool We19 as you asked. The date field has generated in the IDoc with the value.
I set the Current Date to the Date in IDoc and tested the IDoc. Same error repeated. Even I gave current date and transformation to the date field. But still the same error repeated.
Kindly help me in resolving the issue.
Regards
Ram
In the IDoc XML data the date field is containing the value <DATE>20091113</DATE>
Are you sure that IDOC accepts date in the above mentioned format.... and that the format is not causing any issue.
Also i hope that you have already performed basic checks like...IDOC in IR and SAP syste are same, no cache issue, etc
Regards,
Abhishek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.