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
Solved

Which SQL tables make up cluster table BSET?

Posted on 2007-11-30
4
2,764 Views
Last Modified: 2013-12-08
Question:
I'm doing some work with SAP R3 v4 (installed on Microsoft SQL Server 2000) and need to get at VAT details held in cluster table BSET. Which SQL tables is the cluster table BSET comprised of (or how do I determine same)? The specific fields I'm looking for are HWBAS, FWBAS, HWSTE and FWSTE.
0
Comment
Question by:masbe
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:BACR
ID: 20418511
Hi!

Question doesn't fully specify access environment.
1. Access to BSET within SAP
  You can use normal select statement to get required data.  
2. Access to BSET on DB level.
 I would strongly recommend no to do this. There are two ways to get required data:
  - RFC with interface according to your requirements;
  - ABAP report that generates file (Excel, TXT, etc) with required data.

Hope this helps.
BACR



0
 

Author Comment

by:masbe
ID: 20418769
BACR wrote:

"1. Access to BSET within SAP
  You can use normal select statement to get required data."

How do I achieve this?

"2. Access to BSET on DB level.
 I would strongly recommend no to do this."

For what reasons? (If the reasons are valid, I'll accept the recommendation!)

Thanks!
0
 
LVL 2

Accepted Solution

by:
BACR earned 250 total points
ID: 20419611
Hi!

1. Access table within SAP

The following code read data from BSET table:

select (1) from bset into table (2) where bukrs = so_bukrs and BELNR = so_belnr.

(1)
* to access all fields of table
list of required fields (preferred)

(2)
internal table with fields according to (1) option.

Access this table with other WHERE conditions (ex. BUKRS and GJAHR) will result in sequential table read, e.g. this will take a lot of time.


2. Direct access to DB table.
1. SAP licenses are usually based on "named" users as defined in the user master table. Directly accessing the database would bypass user logging procedures and therefore violate your SAP license.
2. A direct connection to the database would bypass SAP authorizations and require maintenance of table access authorizations within the database itself.
3. There are thousands of SAP tables in the database and the SAP maintains the referential integrity of those tables through standard code executed by SAP transactions. Updating any tables directly, either through ABAP code or by external access to the SAP database is highly discouraged.
4. Directly accessing the SAP database could have a negative impact on the performance of the SAP production system.
5. Access cluster table adds complexity since data are stored only in binary format that should be correct interpreted.

Hope this helps
BACR
0
 

Author Closing Comment

by:masbe
ID: 31411920
BCAR - thank you for a comprehensive answer.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

840 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