Solved

SAP Exexute statement

Posted on 2006-11-09
3
548 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Restore Imformix Database to different server 5 255
randomize a list of search results 4 151
What make java scalable ? 6 113
Help with Progress 4gl Rounding Function 6 60
Introduction This article provides a high-level overview of the Quick Campaign and Campaign features of Microsoft CRM. The purpose of both types of campaign is to track outgoing marketing activity and customer responses in a single record. F…
Read about achieving the basic levels of HRIS security in the workplace.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
Suggested Courses

739 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