Solved

SAP Exexute statement

Posted on 2006-11-09
3
542 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 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Connect MS Access to Cloud JD Edwards Database 4 441
Oracle Flash_recovery_area -- ARCHIVELOG buildup ? 10 952
Prevent Windows 10 6 70
MS Dynamic CRM online Queries 1 89
Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
A short film showing how OnPage and Connectwise integration works.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now