Videos matching: SAP

Is the SAP Enterprise Services Explorer for .net Free or not ? Can you show me the proof? If it is not free then how much does it cost ?

I am trying to run a query in SQL Server where the columns I select are different than how it is grouped. This query is used in SAP.

The pro...More

I am trying to run a query in SQL Server where the columns I select are different than how it is grouped. This query is used in SAP.

The problem, is that if I group by all the same columns that are selected, nothing is grouped.

Here is my query (which will obviously not work).

SELECT 
   T0.[CardCode], T2.[SlpName] as 'Rep', 
   T0.[CardName] as 'Facility', 
   T1.[Address] as 'Attention', 
   T1.[Street] as 'Address 1', 
   T1.[Block] as 'Address 2', T1.[City] as 'City', 
   T1.[State] as 'State', 
   T1.[ZipCode] as 'Zip' 
FROM OCRD T0 
INNER JOIN CRD1 T1 ON T0.[CardCode] = T1.[CardCode] 
INNER JOIN OSLP T2 ON T2.[SlpCode] = T0.[SlpCode] 
WHERE T1.[State] = 'FL' 
GROUP BY T0.[CardCode]

Any feedback would be appreciated.

Thanks,

I have XML of unknown structure and I want to apply ST (Simple Transformation) on it to get "somehow" that content out of XML into ABAP structures.<...More

I have XML of unknown structure and I want to apply ST (Simple Transformation) on it to get "somehow" that content out of XML into ABAP structures.

For now I have following test report:

report  ztbu_st_with_copy.

data: lf_xml type string.
concatenate '<tab><obj>'
              '<id>A1</id>'
              '<first>Erste</first>'
              '<second>Zweite</second>'
            '</obj><obj>'
              '<id>B2</id>'
              '<item>'
                '<here>Tady</here>'
                '<there>Tam</there>'
              '</item>'
            '</obj>'
            '</tab>'
       into lf_xml.

types: begin of ys_obj,
         id type string,
         rest type string,
       end of ys_obj,
       yt_obj type standard table of ys_obj.

data: lt_obj type yt_obj.

call transformation ztbu_st_copy_test
  source xml lf_xml
  result root = lt_obj.

uline.

data: ls_obj like line of lt_obj.
loop at lt_obj into ls_obj.
  write: / sy-tabix, ls_obj-id.
endloop.

uline.

and I have following ST transformation ZTBU_ST_COPY_TEST (the one called above):

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">

<tt:root name="ROOT"/>

<tt:template>
  <tab>
  <tt:loop ref=".ROOT" name="obj">
      <obj>
        <id>
          <tt:value ref="$obj.ID" />
        </id>
        <tt:skip />
      </obj>
  </tt:loop>
  </tab>
</tt:template>

</tt:transform>

Now it works fine and it will bring IDs into the fields of table LT_OBJ. However the rest is ignored due to use of <TT:SKIP>. My goal would be to get the rest of XML document (these FIRST, SECOND, HERE and THERE or any arbitrary XML) into field REST in "some" format - probably as rough XML stored in STRING variable.

I understand I need to replace <TT:SKIP> with something smarter, but I can't figure it out what that should be... Any idea?

Side note: yes, I know, it would be better to use XSLT or something else, instead of ST, but I have no choice and I need to make it using ST.

I have XML of unknown structure and I want to apply ST (Simple Transformation) on it to get "somehow" that content out of XML into ABAP structures.

For now I have following test report:

report  ztbu_st_with_copy.

data: lf_xml type string.
concatenate '<tab><obj>'
              '<id>A1</id>'
              '<first>Erste</first>'
              '<second>Zweite</second>'
            '</obj><obj>'
              '<id>B2</id>'
              '<item>'
                '<here>Tady</here>'
                '<there>Tam</there>'
              '</item>'
            '</obj>'
            '</tab>'
       into lf_xml.

types: begin of ys_obj,
         id type string,
         rest type string,
       end of ys_obj,
       yt_obj type standard table of ys_obj.

data: lt_obj type yt_obj.

call transformation ztbu_st_copy_test
  source xml lf_xml
  result root = lt_obj.

uline.

data: ls_obj like line of lt_obj.
loop at lt_obj into ls_obj.
  write: / sy-tabix, ls_obj-id.
endloop.

uline.

and I have following ST transformation ZTBU_ST_COPY_TEST (the one called above):

<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">

<tt:root name="ROOT"/>

<tt:template>
  <tab>
  <tt:loop ref=".ROOT" name="obj">
      <obj>
        <id>
          <tt:value ref="$obj.ID" />
        </id>
        <tt:skip />
      </obj>
  </tt:loop>
  </tab>
</tt:template>

</tt:transform>

Now it works fine and it will bring IDs into the fields of table LT_OBJ. However the rest is ignored due to use of <TT:SKIP>. My goal would be to get the rest of XML document (these FIRST, SECOND, HERE and THERE or any arbitrary XML) into field REST in "some" format - probably as rough XML stored in STRING variable.

I understand I need to replace <TT:SKIP> with something smarter, but I can't figure it out what that should be... Any idea?

Side note: yes, I know, it would be better to use XSLT or something else, instead of ST, but I have no choice and I need to make it using ST.

I have a question regarding client copy from different host.

Will the Client Independent data will be copied when Client copy is done from o...More

I have a question regarding client copy from different host.

Will the Client Independent data will be copied when Client copy is done from other system. If so, will it affect thje other client which exists in that system(As the Client Independent Data has been copied)..??

Within BOE 4, using the Java SDK, when scheduling a report, is there a way to store some string attributes onto the actual instance?

I have a question regarding client copy from different host.

Will the Client Independent data will be copied when Client copy is done from other system. If so, will it affect thje other client which exists in that system(As the Client Independent Data has been copied)..??

I am in need of urgent help. I have my form template in SAP by design and I want to edit it using Adobe life cycle designer and I am unable to do th...More

I am in need of urgent help. I have my form template in SAP by design and I want to edit it using Adobe life cycle designer and I am unable to do that. Please help me. I am very new to this. How can I edit the form template.

im trying to send an Idoc to SAP using VB 2010 and the SAP .Net Connector 3.0. I allready achieved to receive Idocs with "IDOC_INBOUND_ASYNCHRONOUS"...More

im trying to send an Idoc to SAP using VB 2010 and the SAP .Net Connector 3.0. I allready achieved to receive Idocs with "IDOC_INBOUND_ASYNCHRONOUS" from the SAP-System. But i dont get it how to send an Idoc the other way. Would be someone so kind helping me out with some explanations or (better) some code sample.

thanks

I use the webservice interface ICT_SERVICE_DESK_API from SAP Solution Manager. I activate the webservice in SAP. I get a connection with the tool so...More

I use the webservice interface ICT_SERVICE_DESK_API from SAP Solution Manager. I activate the webservice in SAP. I get a connection with the tool soapui.

But I have no idea how i configure the endpoint in the WSO2ESB. Until now I configure a proxyservie. There I generate a soap message which send over a adress endpoint to the webservice from SAP.

<soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope"><soapenv:Body><urn:RequestGuid xmlns:urn="urn:sap-com:document:sap:soap:functions:mc-style"/></soapenv:Body></soapenv:Envelope>

The problem is that i get something back. This is not useful. Then I want change the adress endpoint to wdsl endpoint.

How can I configure the endpoint from the wso2esb for the webservice from sap?

Thanks for your help! Marco

I'm trying to implement a file upload in a UI5 application on a HANA XS Server. I can't find many informations how to do that - somebody got an idea...More

I'm trying to implement a file upload in a UI5 application on a HANA XS Server. I can't find many informations how to do that - somebody got an idea? Thanks!

In my java web application, trying to connect SAP Server. This error is generated. I have placed the sapjco3.dll and sapjco3.jar in...More

In my java web application, trying to connect SAP Server. This error is generated. I have placed the sapjco3.dll and sapjco3.jar in WEB-INF/lib/ and also configured in the Java Build Path. I have also set the Path in servlet as

System.setProperty("java.library.path", "/WEB-INF/lib");

But also error existing.

Would you happen to have a sample VBA code in excel 2007 that will automatically extract data from SAP business objects XI?

Thanks.

In my java web application, trying to connect SAP Server. This error is generated. I have placed the sapjco3.dll and sapjco3.jar in WEB-INF/lib/ and also configured in the Java Build Path. I have also set the Path in servlet as

System.setProperty("java.library.path", "/WEB-INF/lib");

But also error existing.

Background: This is accessing SAP BOR(Business Object repository) using JCo(Java)

Information: Function module RPY_BOR_TREE_INIT returns t...More

Background: This is accessing SAP BOR(Business Object repository) using JCo(Java)

Information: Function module RPY_BOR_TREE_INIT returns the BOR tree structure containing the component hierarchy and all object types. It does not include any relationship information. By setting the parameter FILTER_RELATIONSHIPS, you can identify those nodes (field EXPANDABLE in exporting parameter BOR_TREE) that can be expanded into subtrees, i.e. nodes that have subordinate, related nodes or object types.

Question: BOR API Technical document mentions that we need to use RPY_BOR_TREE_EXPAND function module to read the relevant subtrees. But unfortunately it does not give any example or sample.

Additional Information: There are few references on web ex. http://scn.sap.com/thread/3259214 but they are related to GUI and not Jco.

We encountered an annoying heisenbug: A few users (not all) of an ABAP program complain about a problem we are unable to reproduce (the search help ...More

We encountered an annoying heisenbug: A few users (not all) of an ABAP program complain about a problem we are unable to reproduce (the search help for contract accounts in transaction FKKORD1 wouldn't appear for them. The transaction was heavily customized by external contractors).

To find a solution for the problem we temporarily gave the users a permission role to allow debugging in the production system so we could debug the problem under their user account when it occured. But the moment we gave them the role, the problem stopped occuring. When we removed the role, the problem occured again.

Question: What reason could there be that an ABAP program behaves differently when executed by someone with debugging rights?

The role we added contains only one permission:

Object S_DEVELOP
    ACTVT = 03
    DEVCLASS = *
    OBJNAME = *
    OBJTYPE = DEBUG
    P_GROUP = *

We did a permission trace with transaction ST01 and didn't even found a check for that permission when the problem did or didn't occur.

Permanently giving debugging rights to normal users is not an option, because the compliance standards our organization has to follow don't allow that.

I've copied 2 Function Modules (QM06_SEND_PAPER_STEP2 and QM06_FM_TASK_CLAIM_SEND_PAPER) to analogous Z* Function Modules....More

I've copied 2 Function Modules (QM06_SEND_PAPER_STEP2 and QM06_FM_TASK_CLAIM_SEND_PAPER) to analogous Z* Function Modules.

I've put these FuBa's inside a ZQM06 Function group (which was created by another developer).

I want to use Transaction SCC1 to move my developments from one client to another.

In transaction SE01 Transport Oganizer, I don't find the names of my 2 function modules anywhere.

How can I find out the change request with my work?

[EDIT]: I coppied the FM in order to modify functionality (i know FMs are client independent).

I'm not very familiar with working with SAP but my current task is to utilize Rfc calls for creating purchase orders in SAP via a c# project I'm wor...More

I'm not very familiar with working with SAP but my current task is to utilize Rfc calls for creating purchase orders in SAP via a c# project I'm working on.

Is there any advantage to using direct Rfc calls instead of the BAPI? I asked my supervisor this and his reason was "to avoid the unknown/unneeded mess".

Our old program used the BAPI. I find with this task I'm now chasing my tail as I dive into metadata and resolve issues with using/getting the structures I need.

Things are working and coming along, but I just don't understand the insistence on using Rfc instead of BAPI.

Edit to clarify my poor terminology: We currently use a wrapper that then calls the BAPI for us. My task is to not use the wrapper but utilize the same Rfc calls the BAPI would.

Example:

IRfcFunction poCreateFunction = _dest.Repository.CreateFunction("BAPI_PO_CREATE1");
IRfcStructure poHeader = poCreateFunction.GetStructure("POHEADER");
poCreateFunction.SetValue("POHEADER", poHeader);
...
poCreateFunction.Invoke(_dest);

I have a field symbol <lt_something> which points to a table. This table has a single line as content. How do I assign that line ...More

I have a field symbol <lt_something> which points to a table. This table has a single line as content. How do I assign that line in the table to a new field symbol, say <ls_something> ?

I tried :

READ TABLE <lt_something> INDEX 1 REFERENCE INTO <ls_something>.

But the above code dumps, what is the right approach to this problem?

As Horst Keller mentioned in his ABAP and JSON pos...More

As Horst Keller mentioned in his ABAP and JSON post, "with Releases 7.02 and 7.03/7.31 (Kernelpatch 116) JSON is supported natively in ABAP".

Appartently 7.02 in my case of too generic because the line below:

writer = cl_sxml_string_writer=>create( type = if_sxml=>co_xt_json ).

returns the error: "The field CO_XT_JSON is unknown, but there is a field with the similar name CO_XT_XOP".

So is there any way to easily generate JSON?

Edit: Screenshot from SAP - Status

I need to modify a standard form, and to do this, I'm copying it to a Z* form, and I'd like to know where my print program and SapScript form is bei...More

I need to modify a standard form, and to do this, I'm copying it to a Z* form, and I'd like to know where my print program and SapScript form is being assigned to the workflow.

Anyway, since a lot of transactions seem to work like this: T1 - prints, T2-sets the printing options, is there any pattern that I could use to find the T2 type transactions?

Of course, in my case, It's enough if I get the transactions where the settings for QM02 are specified.

I found a 'Z' transaction calling a program not in the customer space. This program "seems" to be something developed by the customer, meaning its n...More

I found a 'Z' transaction calling a program not in the customer space. This program "seems" to be something developed by the customer, meaning its name is "AQZZZFI_ABC=====ZPYORD========", where "ABC" is the name of the company, and the creator of the program is one of the consultants there.

What could this program be doing outside of customer namespace? Is it auto-generated? And if so, what framework generated it, and how can i get to the "real" development object?

Note: this program uses a logical database called "__S".

To use WSDL servies i am referring the code from http://code.goog...More

To use WSDL servies i am referring the code from http://code.google.com/p/wsdl2objc/wiki/UsageInstructions. My code is

  ZESRV_PM_SEARCH_PARAMETERS *binding = [[ZESRV_PM_SEARCH_PARAMETERS alloc] initWithAddress:urlString]; 
   binding.logXMLInOut = YES;
   binding.authUsername = username; 
   binding.authPassword = password;


   NSMutableArray *array=[[NSMutableArray alloc]init];
   [array addObject:@"Karama"];
   [array addObject:@"Commercial"];
   [array addObject:@"Industrial"];


   ZESRV_PM_SEARCH_PARAMETERSSvc_TableOfZesrvLocation *request = [[ZESRV_PM_SEARCH_PARAMETERSSvc_TableOfZesrvLocation alloc] init];

   request.item=array;

   ZESRV_PM_SEARCH_PARAMETERSResponse *response = [binding ZesrvPmSearchParametersUsingParameters:request];
   NSLog(@"response %@",response);

   NSError * responseError = response.error;

   NSLog(@"responseError %@",responseError);

   NSArray *array=response.bodyparts;

   dispatch_async(dispatch_get_main_queue(), ^{
       [self processResponse:response];
   });

Here i am getting the response as and response error is Null.But i am getting response.bodypart also NULL.why response bodyparts getting Null?

Can anybody help me. Thanks

I am new to SAP business one. I have problem with sap business one screen painter forms. I want to validate forms for avoiding null values. I wrote ...More

I am new to SAP business one. I have problem with sap business one screen painter forms. I want to validate forms for avoiding null values. I wrote this code:

If pVal.FormUID = "TRADING" And pVal.ItemUID = "1" And pVal.Before_Action = True And pVal.InnerEvent = False And pVal.EventType = SAPbouiCOM.BoEventTypes.et_ITEM_PRESSED And (pVal.FormMode = SAPbouiCOM.BoFormMode.fm_ADD_MODE Or pVal.FormMode = SAPbouiCOM.BoFormMode.fm_UPDATE_MODE) Then
    oEdit = oForm.Items.Item("10").Specific
    If oEdit.String = "" Then
        SBO_Application.StatusBar.SetText("Select Buyer Code", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error)
        BubbleEvent = False
        Exit Sub
    End If
End If

It works fine when I press ADD button but if I press close button of the right corner of the form it shows confirmation for save data. If I press "Yes" it still allows empty values to insert.

How can I solve this?

I have a program in ABAP where they use the type 'timestampl' in a variable, so they can get the time of certain events. They use it because they ne...More

I have a program in ABAP where they use the type 'timestampl' in a variable, so they can get the time of certain events. They use it because they need the milliseconds.

I now have the mission of getting the difference between 2 of these variables, and I can't seem to find a function module or another solution.

Any help is much appreciated!

when i deploy my asp.net website on windows server 2003 with oracle 10g database in backend.I am using sap crystal report version 13.0.2000.0 It giv...More

when i deploy my asp.net website on windows server 2003 with oracle 10g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as

Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ 
stack.Description: An unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[COMException (0x80041811): Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.]
CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) +0
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) +95
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +270

[CrystalReportsException: Load report failed.]
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +333
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) +877
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) +84
WEBPAGES_srccustomerbill2.setdatasource() +2270
WEBPAGES_srccustomerbill2.Page_Load(Object sender, EventArgs e) +233
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

I'm currently doing web application development in PHP. Management has told us we're standardizing on "J2EE" (and yes, I keep reminding them it's no...More

I'm currently doing web application development in PHP. Management has told us we're standardizing on "J2EE" (and yes, I keep reminding them it's now called "Java EE"). I think the rational behind this mandate is something like "we run our business on SAP. SAP has netweaver. We should use Java so everything is integrated".

The majority of what I do now, and what management wants us to continue doing is rapid web development. My experience with sap so far (bobj, BW, data services) has not been positive. Insider knowledge is hard to come by. Upgrades are expensive and take forever. Every little change requires involvement from 15 different departments. My gut tells me Netweaver will be overkill for most of our projects.

Is netweaver going to slow us down?

I'd like our custom web development to remain independent of our SAP environment. From what I've read, there are plenty of open source Java MVC frameworks. I envision our own test/production servers running open source application servers with our choice of db backend (we have DB2, MYSQL and SQL Server running available in house). Each developer would use local vms as their sandbox\dev environment. Interaction with SAP would be done using web services or the SAP java library.

What will we loose by not deploying our web apps on Netweaver?

Above all I want to make sure our team stays nimble, both in speed of development and in keeping up with current technology. PHP has met those needs so far. I don't want to backtrack 5 technology years just so we can "integrate" with SAP.

Thanks.

I'm new to using screen painter and I am trying to make a payroll add -on for SAP B1. The payroll application I have right now, I made in C# .NET. T...More

I'm new to using screen painter and I am trying to make a payroll add -on for SAP B1. The payroll application I have right now, I made in C# .NET. The forms are winforms and I want to make them again with screen painter using SAP B1 8.81 PL 4.

On the toolbox for screen painter, I do not see any datetimepicker that I can drag onto the form unlike in Visual Studio.

So how do I get to have a datetimepicker using screenpainter?

I'm wondering if anyone knows how SAP B1 (SAP Business One) generates the unique primary keys it uses in various tables. Examples of what I am talki...More

I'm wondering if anyone knows how SAP B1 (SAP Business One) generates the unique primary keys it uses in various tables. Examples of what I am talking about would include OCRD.DocEntry and OCPR.CntctCode. These are integer columns that get "automatically" incremented.

Typical approaches for doing this include identity columns (e.g., SQL Server), sequences (e.g., Oracle), or manual sequence tables holding a Nextval which is programmatically incremented. As best I can tell, B1 is not using any of these techniques for these columns. So how is it handling them?

The particular instance I'm looking at is using a SQL Server Database.

Yes, I'm well aware of the fact that there is no "need" for me to know know about the inner workings, shouldn't be mucking around in the DB, etc. It's just bothering me that I don't know how they are doing it! If anyone can explain, I'd be grateful.

I want to know the relation between Sales Organization( VAKPA -VKORG), Sales Office( VAKPA-VKBUR) and Sales Group ( VAKPA-VKGRP) in SAP.

Rel...More

I want to know the relation between Sales Organization( VAKPA -VKORG), Sales Office( VAKPA-VKBUR) and Sales Group ( VAKPA-VKGRP) in SAP.

Relation in the sense, does One-to-One or One-to-Many relation exist between them..or do they form an hierarchy??

Thanks

I'm trying to read from a Matrix. The code that I have until now is:

SAPbouiCOM.Matrix matrix = (SAPbouiCOM.Matrix SBO_Application.F...More

What is the use of edi - gentran ? what is called mapping in gentran?

I'm trying to read from a Matrix. The code that I have until now is:

SAPbouiCOM.Matrix matrix = (SAPbouiCOM.Matrix SBO_Application.Forms.ActiveForm.Items.Item("38").Specific;              
SAPbouiCOM.Column col = matrix.Columns.Item("1") ;
SAPbouiCOM.Cells cells = col.Cells;
String cell = cells.Item(2).Specific.ToString();
String f = cell.ToString();

None of the Strings (cell and f) give me the value of the cell...

Any Idea?