BusinessObjects Board

SAP table lookup

dataservices metadata reports
#1

Hi,

I am using SAP sources in my dataflow. Now , i need to do a lookup on a SAP table. MY dataflow is the normal one, not R/3 dataflow.

I am getting error while looking up on the SAP table.
(<Cannot parse expression, SAP table in Datastore … etc>)

Please help. Its v urgent.

Sree

p.sree (BOB member since 2009-06-15)

#2

Hi,

As per above mentioned problem, i am using a r/3 dataflow with the following specifications :-

Data Transfer Method - Direct Download
Working Directory on SAP server - xref\bodi
Local Directory - c:\local
Generated ABAP directory- c:\ABAP

Now , in r/3 dataflow properties, am giving the following values :-

Generated ABAp file name - xtest
ABAP PROGRAM NAME IN R/3 - YPROG
.
.
.

When i am running the dataflow, it is throwing this error …

30449 4134251280 R3C-150301 8/5/2009 6:36:51 AM Error opening file <c:\ABAP/xtest>.

Kindly help please, its v urgent. i dnt knw exactly how to use and extract data from SAP . Please help.

Sree

p.sree (BOB member since 2009-06-15)

#3

https://wiki.sdn.sap.com:443/wiki/display/BOBJ/Connecting+to+SAP

https://wiki.sdn.sap.com:443/wiki/display/BOBJ/Reading+via+ABAP

Werner Daehn :de: (BOB member since 2004-12-17)

#4

Hi P.sree

was this issue resolved. I am running into similar issues for normal dataflows using SAP R/3 system as lookup.

Thanks,
Shawn

DI.net (BOB member since 2007-07-26)

#5

lookup(), lookup_ext() cannot be used inside a dataflow against a SAP system. The lookup() function can be used within an R/3 dataflow.

Werner Daehn :de: (BOB member since 2004-12-17)

#6

Hi Werner,

Thank you for your reply. what about other lookups lookup_ext, lookup_seq can they be used in R/3 data flows.

Thanks
shawn

DI.net (BOB member since 2007-07-26)

#7

Nope, lookup is all we can inside an R/3 dataflow.

What’s you requirement, maybe we can suggest an alternative approach?

Werner Daehn :de: (BOB member since 2004-12-17)

#8

Hi Werner,

I have similar requirements to validate the data. I am getting external data and want to load to SAP BW, but before I load it want to validate against the Master data in SAP BW. I have created the BW Source connection and can view the Master data in BW from DS.

Here is my custom function code,

lookup_ext([EWD…"/BI0/PCUST_SALES", ‘PRE_LOAD_CACHE’, ‘MAX’], [CUST_SALES],[NULL],[SOURCESYSTEM,’=’,$SourceSystem ], [SALESORG,’=’,$SalesOrg ],[CUST_SALES,’=’,‘1569’]);

When try save/run the job, it returns error:
[Function:Val_Distributor_Code]
The function <Val_Distributor_Code> contains an invalid expression. Additional information: <SAP table </BI0/PCUST_SALES> in datastore cannot be used in a lookup.>. (BODI-1111182)

If the lookup or lookup_ext function is not supported in Custom FUnction or in Column Validation, what’s option SAP/BOBJ recommends?
Do I need to maintain the copy of BW Master data in local RDBMS table to do the validation?

Regards,
Abhay

amhatre :us: (BOB member since 2012-02-07)