Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SAP Exexute statement

Posted on 2006-11-09
3
Medium Priority
?
554 Views
Last Modified: 2013-12-08

Hello,

I'm connecting to SAP through Lotus Notes Script.  I want to run a BAPI in SAP which will pull in a load of information which I am using to create lotus notes documents.  I can connect fine, but I am struggling to add a select statement to my connection so that only certain tables in SAP are ran against.

Here's the relevant code...

Dim sapsession As LCConnection
Dim rstfldlist As New LCFieldlist
sapsession.Database = "BAPI_NAME"
sapsession.Metadata = "TABLE_BEING_USED"
selectstatement = |SEL_GROUP=3000 or SEL_GROUP=3001 and CHANGES_ONLY="X" AND CHANGES_SINCE_DATE="dd.mm.yyyy"|
numFound = sapsession.Execute(selectstatement, rstfldlist)

Basically, I only want to pull in information in the table where the Material Group is 3000 or 3001.  And I only want to pull in information changed since a calculated date.


0
Comment
Question by:RichardStarkey
3 Comments
 
LVL 10

Accepted Solution

by:
jonvaughan earned 1000 total points
ID: 17929439
What is the bapi being used ?
Which table are you trying to get the data from ?

What data is it that you want - generally you wouldn't need to format a select statement to get data from SAP, you would use a BAPI that is pre-written to give you the data - although this is only true for standard types of objects. Or you can write a function module to do the same thing.

0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question