I have set up field assignments through the appropriate SPRO task for my query for the following fields: BUDTYPE, BW_BUDCAT, CMMT_ITEM, FISC_YEAR, FM_AREA, FUNDS_CTR, MEASURE, VERSION. I'm not using any derivation strategy.
When I go to transaction FMCYCOPI_BW, I select my source system, the source query and all the relevant parameters and execute the report. I get the error "Query I_YORC_ADPF/YORC_ADPF_1 Contains No Data" - message FM_BP_BWRET001. If I run the query in BW I get a few test records which I was expecting would be retracted to ECC. What am I doing wrong?
It all had to do with the field mappings in the ERP side. I'm not sure exactly what I changed to make it work since I was trying a little blindly but my approach was to try to manually post an FM budget document and see what fields were mandatory. For those fields I either made a mapping to a BW query characteristic or to a constant value. Eventually it started working.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.