Solved

SAP Exexute statement

Posted on 2006-11-09
3
540 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
Comment Utility
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Supply Chain Event Management Supply chain visibility is the ability of a company to track its products and business processes in supply chain towards building operational excellence. The goal of supply chain visibility is to improve and strength…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 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

14 Experts available now in Live!

Get 1:1 Help Now