Go Premium for a chance to win a PS4. Enter to Win

x

SAP

496

Solutions

759

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 want to increase the width of label border to 1 pt as for now it is only hairline.
The options available in the format section are single border, double, dashed and dotted.

I will be exporting this report to excel, so how to avoid the unwanted spacing of sections?

Attached is the report:
https://drive.google.com/open?id=1YTkq8UP5MtVJqMF_MvIlXkLVZm2DnDUe
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Is there a standard report in SAP showing contract number and ship to?  I see a lot of sold to and contract reports, but I need to see the ship to’s for all sales contracts. Thanks.
0
TQ77 contains a characteristics 'attribute' but I cannot figure out the relationship to CABN/CABNT/CAWN (perhaps over an additional table) - can anyone help on this?
0
I would like to know if there is a report I can run in SAP to show me the project codes opened per WBS and each end date. We want to monitor the opening of codes, so instead of the individual asking for the code once it has disappeared from their time sheet we want to run a report to flag up any codes due to expire in 2 weeks time then we can ensure the end date is changed.
0
I made a c# program that will display crstal reports. it works on my local computer by using start. when i publish the program and try to run on another computer i got this error Asembly 10g4net version 1.2.10.0 be installed.
i installed sap crystal reports runtime (64bit)to the computer i want the program on. it than installed.

when i try to get to the report i get the error of the type initialer for crstaildescsions.shared.shardUlitis threw an execption

did i do something wrong when i publish it or what. I need to get this working someone is waiting on the program
0
dears, I use reorg rebuild index to maintain indexes on table with data lock ,

but what can I use with allpages locking table? how to maintain its indexes, then update statistics??

kindly help
0
Dears, kindly note this case,
we have Sybase ASE, I take a full dump daily at midnight, and an incremental dump every 30 minutes, I know the dump transaction truncates the log and this is what happened usually, but sometimes the dump transaction taken successfully while the transaction log INCREASE its size for a period maybe 3 days, I think this is because an open transaction which is not committed yet,
how can I be sure about my thinking, and how can I found what is the uncommitted transaction, such a transaction is executed by other employees and in the background of our application , i.e  no body know exactly what is a statement

Regards
0
dear all

i have a web application where i have created a webform where i dragged and dropped inside a  crystal report viewer Version=13.0.2000
in order to load a report.
i need to know the time that takes a crystal report to load the report
i am using the below command:
 With CrystalReportViewer1
                .ReportSource = CrReport
                .ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None
                .ToolbarImagesFolderUrl = "~/Images/ReportToolbarImages/"
                .ToolPanelWidth = 0 'to hide parameter panel, do not open group tree
                .HasCrystalLogo = False ' to remove log sap crystal report from the viewer
            End With
how can i trace the performance of crystal report viewer.
0
I have replication server. REP 15.7.1
From last 2 weeks the replication delay is more.
When we check we can see some bulk insert happen and Identity_burn_max error for 2 tables.
So we just restart the thread and fixing the issue.
We need to fix it permanently.
I suspect identity_burn_max is the problem.
I checked the two tables in database. Both are empty.
Not sure why identify_burn_max error occurs for empty tables.

Is there any way to fix the issue permanently.

1. num_mutexes is greater than num_threads
2. dsi_bulk_copy is OFF -
3. sqt_max_cache_size is 20971520
4. dsi_large_xact_size is 100
5. dsi_max_xacts_in_group is 20
0
Samsung DS5014S Landline phone

I have a Samsung OfficeServ DS-5014S with the message light flashing, even though there are no messages pending  does anyone have any ideas how to reset
0
Free Tool: Site Down Detector
LVL 11
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

sap Crystal server 2016, how to run and check, how to connect to Oracle, how to call the reports which is published in crs server using visual studio
0
I have created a desktop application and designed some reports using sap crystal report. First to design report I used database from sql server management studio and put all the field on report. But I have to deploy it client side with localDB after connecting my application with local db I am able to access database on my forms but cant getting data on report. I fetched data in datatable then I am setting datatable as datasource for report but I am getting error."Failed to open the connection Details: Database Vendor Code:4060"

Please provide me correct answer as soon as possible.
Error.PNG
0
Hi

Is there any issue if we setup 'abort tran on log full' for primary database? Does sybase try to kill repagent process in case replication marker is blocking the transaction? Kindly advise.

thanks
Chan
0
Hello,

I am working with VS2015 C#. Trying to execute a stored procedure from a Sybase db.

It seems to be not receiving the parameters I am trying to send it. I attached the code I'm using with the error msg that I'm receiving.

I'm using this connection string:
Data Source={Adaptive Server Enterprise};server=ppw.amgreetings.com; db=db_cis00;uid=cis;pwd=hotstam;

I am able to receive data back from this db by using embedded sql, but the sp is having issues.

Do you guys see anything I could try differently?

Thanks,
David
DevError1.png
0
We are looking to replace our current SAP systems with a new one.  We were thinking of pointing using a friendly URL to point to the database such as  prodcutionSQLDB.ACME.com  and  productionOracleDB.ACME.com instead of using DB Server name.

This way our application servers just get this FQDN to point to the database.  THis would simplify our DR planning and future migrations.

The question is, does SAP require certificates or something similar where the application servers would not be able to communicate with the DB  (SQL or Oracle).  My understanding is SQL and Oracle use username\pass to authenticate,  or does SAP rely on certificates to communicate with the DB servers?
0
This is for my web assessmet SAP S/4 Hana Sales: which steps need to be performed for existing customers to migrate to SAP S/4 HANA? enablement of digital transformation, verification of all data layers, techincal migration, implementation of additional high security measures. In my opinion there are available all the answers, but i`m not sure; without a digital transformation you cannot migrate to S/4HANA, you must verify all the data but I don`t know what all layers means; you  it will be a technical migration, and the experte say there are additional security measures implemented. I really don`t know if my answer is correct because I have multiple choises, but I don`t know the number of correct answers; Thanks a lot! Best regards, Cris!
0
Hi

Is SAP Replication server 15.7.1 certified on Solaris 11 (sparc T-7)? Can anyone confirm please?

thanks
0
Hi All,
We are about to commence a project to start the decommissioning of SAP as we have replaced it with several other pieces of software.
SAP is internally hosted and we intend to archive the data and software as we will not be migrating all of the data to the new systems.  We will also need to keep historic data in order to meet several pieces of legislation.
Below are some of the points I thought that we need to consider, however I have never undertaken such a project before.  From the below, is there anything else I should be thinking about and taking into consideration in terms of the existing SAP infrastructure, the new archiving solution and how we make the move?

Any thoughts are appreciated.

  • Scope of data to be kept in archived SAP
  • Access to the system
- Who has access and what type of access
- Everyone to have read-only access?
- Any requirements for Admin/Developer type access?
- How will Admin/Developer access be granted (fire call)?
  • Decommissioning of old SAP Hardware – How will the hard drives be destroyed or recycled bearing in mind they hold significant private and confidential data.
  • SAP still supported for several years so how do we manage patching to keep it line with PSN requirements.
0
Hello experts,
I'm quite struggling with a date-time problem at Universe (IDT 4.1 SP7)&BO Webinar (14.1.7).

Let's start with customer request:
He needs a Webi report where he can filter by prompt -date and time in separately

For example, if he filters:
Date between 01/01/2016-30/02/2016
Time between 11:00-15:00
He wants to see all data between these dates and time 11:00-15:00

The problem -
In universe -Data Foundation I'm getting from EVENTS table a date-time filed (SQL server) - for example "04:26:47 24/07/2017"
So, on the Data Foundation level (in the EVENTS table) I created 2 "calculation columns"
Date filed - "toDate(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")
Time filed - "toTime(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")

In the Business Layer I created 2 dimentions (date&time)that brings these calculated columns.
Their DataType -Date
On the date filed I'm getting just the date-as I need.
On the Time dimention, on the "Advanced" tab- "Edit display format"-I costumed the format as customer need - "hh:mm"
When I create a query I'm getting the "he:mm" as I need.
Now on BO Webi I created the 2 prompts and here are my problems:
Problem no. 1 : "Time" prompt - I'm getting date only (!!!!). It doesn't recognize the costume I made on the IDT.
I need it to be filtered by "hh:mm" only
Problem no.2 : when I display chosen date filter (by - userResponse("psEnter Value for date (start):") I'm still getting the …
0
Veeam Disaster Recovery in Microsoft Azure
LVL 1
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

#option3
                                update top(10) ud_$REAL_TABLE_NAME
                                set $UD_FIELD_NAME=@id
                                where $$UD_FIELD_NAME is NULL

                                while @@rowcount > 0
                                begin transaction
                                update top(10) ud_$REAL_TABLE_NAME
                                set $UD_FIELD_NAME=@id
                                where $UD_FIELD_NAME is NULL

                                     if @@rowcount > 0
                                       begin
                                            print 'Successfully update @@rowcount no of rows'
                                            commit transaction
                                       end


                                end

                                go

                                set rowcount 0
                                go
0
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
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
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

SAP

496

Solutions

759

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
>