SAP

463

Solutions

1

Articles & Videos

715

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

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
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.

What values can be updated on a scheduled report without rescheduling the report?
0
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
One of the SAP server which is in a workgroup has issue in accessing a shared folder with hostname and IP address. We can access the shared folder only with the loopback IP 127.0.0.1, but the same is now accessible while using hostname and IP.

We also have a domain XYZ and a windows 2008 DNS server. And registered A record of the SAP server in a DNS but still the nslookup gives an error and unable to access the share.

Please advise what are the things to be considered for accessing a shared folder in a workgroup with Hostname/IP address.
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
PeopleSoft Has Never Been Easier
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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
Dear All,

  I am working on a Business Objects Web Intelligence Report(Webi).  The presentation of the report is just a table contains rows and columns and export to an Excel File. This report consists of: 1 Report, QueryA, QueryB

  I want  to add a new column to the report.  This column need to check if That row's ID field is exist in a Query of the report.  If it exists in the Query, then Display Yes. If it doesn't exists in the Query , then Display No.

This is what I did:

I added a column to the table and tried to apply a formula to the column:  if ([QueryA].[id]  in list ([QueryB].[id]); "Yes";"No")
However, when I tried to validate the formula: it says Missing Element in [QueryB]

How do I make this new column to display Yes or No based on whether the ID is in QueryB?   What are the approaches to make this happen?

I'm on Business Objects Web Intelligence version 14.0.6


Thank you!

Annie
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
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
Salesforce Has Never Been Easier
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

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
Hello I'm running a report in SO01
After I execute the file and select APPL MESSAGES and the output is only designed to print on a printer.
 
There’s no export to excel or spreadsheet option (see attached)
Every page has a header and the error message is part of the header.
I need to export this data to a table and have the error message along side each employee

Can anything be turned on to allow this report to export to excel.  It’s all in a table somewhere, so shouldn’t there be a way to extract it out?
EE---Export-SAP-Print-File-to-Excel.docx
0
Basically , i want to create  report based on  expense account  in P& L  statement . in which  against each expense  Gl account ,with hold amount appears in the report
0
Hi All,

I want to know what is difference between Standard PO and STO, Why can't we use STO for ordering the material from Vendor.
0

SAP

463

Solutions

1

Articles & Videos

715

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
>