BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Unable to fetch data for the DATE field from 0FI_GL_14


 
Search this topic... | Search DI: SAP-specific ERP/BW... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Author Message
sanjanakuril
Forum Member
Forum Member



Joined: 26 Jul 2018

Posts: 1



PostPosted: Thu Nov 01, 2018 6:26 am 
Post subject: Unable to fetch data for the DATE field from 0FI_GL_14

In the ECC, we have data in date format MM/DD/YYYY in RSA3, when we are trying to pull data in BODS with the same selection, getting error "<The constant string <'31/10/2018'> cannot be converted to a valid <DATE>. The format is yyyy.mm.dd for dates, hh24:mi:ss for time, and yyyy.mm.dd hh24:mi:ss for datetime.>. (BODI-1111078)"

When trying to give date is in YYYY.MM.DD this format, there is no error while validating but not getting single value in output.

In the SAP ECC ODQMON TCODE, I can see the entry as "BUDAT = 2018.10."
as if it is expecting in this format.

Please help to resolve it, I really appreciate quick help!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0313 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0280)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo