SAP

470

Solutions

727

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

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
Free Tool: Site Down Detector
LVL 9
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.

Hi,

I am studying the pros and cons of multi site architecture of MS SQL, oracle, MySQL and sybase. I know about MySQL and I am focusing on MS SQL now.

other than AOG, anything else can be good for MS SQL on 2 x data center MS SQL configuration/topology ?
0
#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 All
i'm looking to get SAP certification in "Finance controlling" module,   any advice?
and is ther any online programm
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
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
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
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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
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
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
Hi Experts,

Hope everyone is doing excellent.

Pls see the attached screenshot of an error which i am getting while trying to log into SAP. Pls guide what may be the issue and how to correct the same.

Thanks
Asha Kanta Sharma
made_ash@yahoo.co.in

ERROR.png
0
I'm trying to print a PDF from my SAP application.  When it prints to the SAP printer, it's not correctly lined up on the page.  They're designated columns and the text is not in its designated side of the page.  It prints okay if you don't select the PDF format.

I've attached a file that we use to set up a default SAP printer
Instruction-to-change-printer-in-SA.docx
0
Hi Guru's


I have 10 item material in sales order, 8 from 10 material already delivered and delivery status is complete.
But 2 from 10 material it wasn't delivery and delivery status "not delivered" and overall status is open.
I want to try complete this open status with "reason for rejection", but I can't do it because field reason for rejection still "blue" and can't maintain. I was try complete status with tcode MASS, but it didn't work.

So wht should I do?


Thanks & Regards,
Yulia
0
Hello EE,

We are migrating to SAP as our ERP system and I am in IT support.
I am the current ERP admin and would like to get my feet wet in being able to admin/support the SAP platform going forward.

There are many training classes and I don't know if anyone would have anything to recommend
0
Get free NFR key for Veeam Availability Suite 9.5
LVL 1
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

I want to create a new mapping for the DWH model. Currently the table that I want to map exists at model A but I want to "use" as it comes from model B in order to map it to DWH.
 With that way I won't need to create the same table in another DB, with the same processes, as the data that I want to use are the same.
Do the synonyms do the job? I am using SAP PowerDesigner 16.5
Let me know if my question is clear enough.
0
i am unable to view pdf attachment within SAP   help
0
FromDateTime DATE;
   ToDateTime DATE;  
   S_DATE DATE;
   
     S_DATE:=TRUNC(NVL(D_DATE,SYSDATE));

   IF flag='1' THEN
   FromDateTime :=TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 00:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 11:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='2' THEN
   FromDateTime :=TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 11:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 13:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='3' THEN
   FromDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 13:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 15:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='4' THEN
   FromDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 15:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 17:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='5' THEN
   FromDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 17:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 19:00:00', 'DD-MON-YYYY HH24:MI:SS');  
   ELSE
    FromDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 19:15:01', 'DD-MON-YYYY HH24:MI:SS') ;
    ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 20:15:00', 'DD-MON-YYYY HH24:MI:SS');
   END IF;
0
Does a Windows 10 client need Java installed to access the SAP NetWeaver Portal ?
Thanks in advance for your help
0
Hi Experts,

I am trying to generate a GS1-128 barcode string and I am having the issues with the check digit. My barcode has combination of subset B and C. I have tried to calculate based on calculations given in some websites. But I am not getting correct check digit.

Below mentioned are the examples of my barcodes.

40327641468+99000952123001
40327605999+99000900000000

Example of combination of subsets: Start C  FCN1  '4032764146'  Set B  '8+'  Set C '9900095212300'

Please help me how to calculate the check digit manually.
0
I am doing LSMW Recording through CG12 transaction, and it is working fine in the Forground as well as in the Display mode error but it through error in Background?

Error which I am getting in the background is :-

RAISE_ERROR was called!
Look at System -> Own spool requests and search
for C14Z_ERROR_RAISE. (An output-device
(= printer) must be given in the defaults
of your user-profile.)
Runtime error OBJECTS_OBJREF_NOT_ASSIGNED has occurred
Transaction error.
0

SAP

470

Solutions

727

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.