Skip to Content
0

HCI DS: Lookup data not passed to target S&OP Tables

Apr 19, 2017 at 06:46 AM

106

avatar image

Hi Experts,

I am working on Location Master data extract from SAP ECC to S&OP staging table using custom data flow (attached). In the flow, I am fetching 2 fields, LOCAREA & LOCREGION (both varchar10) from a lookup file present on HCI Agent server by passing the unique key - LocationID to the file. The file structure is created in HCI datastore with correct type/length.

This lookup file will be maintained for values of LOCAREA & LOCREGION against unique values of LocationID by business. When I run the Task in Sandbox, it completes successfully in HCI & after post processing in IBP gives error in IBP Data Integration cockpit. The reason being value of field LOCREGION and LPRIMESECONDFCST (Location Primary Secondary Forecasting Flag - VARCHAR1) is passed as BLANK to IBP as seen in error report.

When I use the print() function inside the Target_Query, it prints the proper values in Trace Log but does not pass value of LOCREGION from Lookup and also LPRIMESECONDFCST. Even if I hardcode the LOCREGION and LPRIMESECONDFCST in Target_Query these dont get reflected in the IBP Rejection report sheet. I tried to use ltrim_blanks & rtrim_blanks but that too does not work.

I also tried to push the data from ECC to local file on Agent server in one task and from there load the data to IBP in different Task, the file already had LOCAREA & LOCREGION fields fetched via Lookup and LPRIMESECONDFCST was also therelocationm-sap-task.png, but then too it does not work, the fields LOCREGION & LPRIMESECONDFCST remain blank. Kindly suggest what the issue may be.

Regards,

Rajesh Shinde

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers