SAP

466

Solutions

719

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,
I would like to know if there is any configuration parameter or procedure from which I could know how many CPUs or cores is used by ASE?
I am using Sybase ASE 16.0 & 15.7.
0
Online Training Solution
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Hi,
Is there any way to disable automatic truncating some of monitoring tables (monSysSQLText, monSysStatement) after SELECT operation? It will make my work a lot easier. I found only a note that ASE assumes that DB user don't want to see it again, which is not true in my case.
I am using Sybase ASE 16.0 & 15.7.
0
Can the database password on the SAP Crystal Reports in SAP Business Objects Enterprise be updated using an API?

Is there an API .NET Framework available?

Where can the API be downloaded?

Does the API have to be installed on the both the client and server?
0
I am beginner in SAP and ABAP. I must to do program with BAPI_ACC_DOCUMENT_POST which posted account 602101 to 60210101, but tax rate is 0. I have little proglem. Please help me.
0
If you have data rows like

1.  TypeA.     Control 1.  Answer 1
2.  TypeA.      Control1.  Answer2
3.  TypeA.      Control2.  Answer1
3.   TypeB.    
4.   TypeB.     Control1.  


Where you have three different drop downs
0
1
Does SAP BusinessObjects Business Intelligence 4.x. in Linux have any specific software requirements?   Also do the following products have any specific requirements running in Linux?

APOS Security Manager
APOS Insight
APOS Administrator
APOS Publisher
0
My extended family runs a small water sewage utility. I'm building apps that will allow us to increase customer service beyond the norm.

We've recently realized with SAP B1 (Blue Oceans) we can provide customer service that is typically only offered by utilities with 1 million plus customers.

My cousin and I will probably get the B1 cert and I'll get the SDK cert. But we don't have my dad's business mind.

My dad simply does not have the time to learn a complex software like SAP so I was wondering if they would make him learn the software or just teach him ideal configuration so he can instruct us.

My dad went to law school and he has a better business mind than some MBAs. If he learned how it worked we could really improve our business.

Can you answer the question and also do you recommend any schools that have online programs that focus on ERPs for utilities (if that's a thing)?
0
I have a copy of SQL 2008 R2 on a customer site and I am trying to connect a Sybase database to it to query the Sybase tables.  I have tried to understand the Linked Server process.

Can someone tell me how this is done please
0
Microsoft provides a development SQL server that can run on your laptop or PC for developers to work against. I can put a Northwind database on such for example, and devise queries against it. I am looking for similar tools that I can do so for these database formats, if there is such an animal...

DB2
Oracle
SAP
AS400
0
Want Experts Exchange at your fingertips?
LVL 9
Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

I have the need to get a BOM with all components , currently using Tc. CK86 , but this doesn't give enough information, so I want to do this by SQL, I come from oracle background and dont know how could I get this done in DB2 R/3, I do not have access to query builder or quickview , but i do have read access via SQL, I'm currently trying to figure out a way of getting this info using tables :

MAST Material to BOM Link
STKO BOM Header
STPO BOM item

Does any of you  have a solution for this?

In Oracle I did something like the following:
SELECT DISTINCT LEVEL
	,sys_connect_by_path(msil.segment1, ' @ ') AS "BOM TREE"
	,msi.segment1
	,lpad(' ', LEVEL, '') || msil.segment1 Cod_Component
	,msil.item_type
	,msil.description Desc_Component
	,BIC.component_quantity
	,msiL.primary_unit_of_measure
FROM mtl_system_items msi
	,bom_bill_of_materials bom
	,BOM_INVENTORY_COMPONENTS BIC
	,MTL_SYSTEM_ITEMS MSIL
WHERE msi.organization_id = 332
	AND BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID
	AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_id
	AND bom.bill_sequence_id = bic.bill_sequence_id
	AND nvl(bic.disable_date, sysdate) >= SYSDATE
	AND BIC.component_ITEM_ID = MSIL.INVENTORY_ITEM_ID
	AND Bom.ORGANIZATION_ID = MSIL.ORGANIZATION_ID
	AND msil.inventory_item_status_code = 'Active'
	AND msi.inventory_item_status_code = 'Active' connect BY prior bic.component_item_id = bom.assembly_item_id
	START
                  WITH msi.segment1 = trim(:parte)
        ORDER BY 2

Open in new window

0
Hi,

I have fields License Number, Award Date, Drug Action Classification, International Birth Date in a 2*2 grid and all fields can grow. I have another field 'Name of the Product' which is next column of 2*2 grid but the 2 rows are merged. When I set the property fo the field to 'Can Grow' = true, then this layout breaks and below field is overlapped. I also tried putting fields in different sections, but then the layout of 'Name of the Product' all breaks and I am not able to have a layout as per client requirement. Kindly suggest a work around this problem.

Thanks in advance.

Rahul
0
Hi,
I'd like to update automatically the statistics for single table in SYBASE ASE every 3 days.

If anybody had tried updating automatically the statistics for single table in SYBASE, please share the procedure with me.

Thanks in advance!
0
I have one 12U1 SLES machine in which i want to open an port no 31015 for SAP HANA but unable to.

Netstat -tulpn also not showing LISTEN to this port .

I have also tried it with Yast2 firewall advance option but dont same problem

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      2475/sshd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2169/master
tcp        0      0 0.0.0.0:51013           0.0.0.0:*               LISTEN      2341/sapstartsrv
tcp        0      0 0.0.0.0:51014           0.0.0.0:*               LISTEN      2341/sapstartsrv
tcp        0      0 0.0.0.0:1128            0.0.0.0:*               LISTEN      2295/sapstartsrv
tcp        0      0 0.0.0.0:1129            0.0.0.0:*               LISTEN      2295/sapstartsrv
tcp        0      0 :::22                   :::*                    LISTEN      2475/sshd
tcp        0      0 ::1:25                  :::*                    LISTEN      2169/master
udp     5376      0 0.0.0.0:68              0.0.0.0:*                           1308/wickedd-dhcp4


telnet IP 31015
gives keep trying then unable to reach

telnet working for other ports like ssh and 1128 etc.

please help
0
I have a Physcial Server hoste dwitH SAP ECC and BW Modules i am looking at migrating to cloud could any please advice on the best approaches to migrate to cloud considering that time is important factor (may be a image backup and restore will work) ?.

Please advice i will give points to multiple answers every one is welcome....
0
How to setup Table level replication in SAP Sybase ASE Step by Step |Table Level Replication Sybase ASE 15.7
0
Hello,

I am using SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer.

When I drag and drop the date field from my service it shows an incorrect date on the report.

As shown in the screen shot image


How to overcome this issue? Even if I enter different parameter it shows the same incorrect date. It doesn't display date in database.
IncorrectDate.jpg
0
Hi,

i have a code of SAP as below, in the below code instead of 11, i want to give the cell reference of excel ,for example the cell range is in sheet1 J3, how do i relate this SAP. This code is in excel vba.

Please suggest

session.findById("wnd[0]/usr/ctxtPAR_27").text = "11"
session.findById("wnd[0]/usr/ctxtPAR_28").text = "11"
session.findById("wnd[0]/usr/ctxtPAR_31").text = "2017"
session.findById("wnd[0]/usr/ctxtPAR_30").text = "0"

Thank you!
0
Why can not the provider increase the size of the tablespace much more? What does it depend on? According to the image only broadened by 2%
www.png
0
Free Tool: SSL Checker
LVL 9
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

We have an old application that we are in the progress of replacing with a new one.  This is being done by a consultant.
This old system used a fairly basic naming convention but one I believe is fairly standard (perhaps with SAP).  Anything that was customised by us was prefixed with ‘Z_’.  This might be a report, query or a security role.  This was the only naming convention that was strictly adhered to and one we inherited from previous employees and just carried on using.  One benefit of this was that when it came to update time (which stopped a long time ago), we could easily see what was customised and therefore made sure they weren’t removed as part of any update.  There was also a naming convention that wasn’t really stuck to for user roles where further information would be added after the Z_ to perhaps indicate a department or team.

The consultant is in the process of creating reports, security roles etc in the new application but has no plans to use a naming convention, which was a surprise.  Are there any serious usability or security issues associated with not using a convention?  Ideally I would like it to be agreed and implemented asap before too much customisation has taken place but want to make sure it is a point I really need to be ensuring is implemented or one I can forget about.
0
Hi all,
i have the unenviable task of updating an onliine sales portal made at least 10 years ago, and which links into a customers SAP system.

there are no problems when i am updating prices, but if i need to add items to the page, there is code i obviously need to alter:
onClick="buyItem('5247 BURN AID GEL 50G PK10','6.10', document.itemsform.box10.value)">

The question is, what and where does the "document.itemsform.box10.value" refer to, and can i just add to the box value if i am adding more items? i.e. if box11.value didnt exist, could i add that code to a new item?

thanks in advance
0
I'm an IT report developer with a few miles on my belt. Officially we are the Business Intelligence team. We use SAP Business Intelligence Suite 4.2, aka BusinessObjects. I remember James Martin back in the day (1990's) but haven't heard or read much about him, not that I'm the most well read person around. But I do have a pretty good library of software development books, from Karl Weigers to Steve McConnell to Gerald Weinberg, and "The Mythical Man Month". At the moment I'm trying to bring our organization into modern times in regards to Business Intelligence. What we have are awful legacy minded reports that no one uses, i.e., 85% of active OLTP users run NO reports (and the OLTP itself is a 1990's style system).

We are also trying to bring in Crystal Reports for high-end reporting, and other tools for "Dashboards".

Around here it's a totally legacy mindset, to include a CIO who's up there in years and is totally old-school, constantly referencing to James Martin and his approach. So is JM still a "classic" who's books should be on my shelf (to include reading them)? In order to influence the organization to "get modern", I have to start by convincing the CIO that there's a better way nowadays (to Business Intelligence).  Also, no one around here knows how to spell "agile".

Do you have a recommended James Martin classic or two, at least so I can be able to step up intellectually to where the CIO is coming from? And while I'm at it, any other classic books / …
0
I want to display a color band on crystal report with percentage on it. Is it possible to achieve by using Horizontal bar graph?
Below Image should be the output. ColorBand.jpg
0
Hi,
I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

I have certain queries w.r.t. cross-tab

a) If I want to merge two fields (e.g. Amount - USD) in one text box in column header, then how is it possible by using Concatenation function in formula?

b) What happens if the field is null? Will I be able to display "X" if value is returning Null?

c) How to suppress null rows

d) How to Give Headers for rows/columns. Please refer Image for better understanding headers.jpg
0
I am unable to send the report to email ,could you please help me to fix ,if possible please explain the necessary steps to take .It's very helpful to me .
0

SAP

466

Solutions

719

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Top Experts In
SAP
<
Monthly
>