Fermé

sap api integration and transaction visualization panel with kpi and api creation to second stage integration

I need you to integrate to api of sap to show the transacrions per user , i need to create an api and a panel to show for example, how many sales have this user, in real time, i need to show all in kpi and nice layout with sort and filters and api working so later i can build a system to create incentives uppon goals.

im attaching querys i need:

Monto Facturado por vendedor durante el mes "select [url removed, login to view],SUM([url removed, login to view]) as Venta

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view]

Order by SlpName"

Nº Facturas por vendedor durante el mes "select [url removed, login to view], SUM(A.NºFacturas) as NºFacturas

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view]

Order by SlpName"

Monto facturado por vendedor durante últimos 30 días "select [url removed, login to view], SUM([url removed, login to view]) as Venta

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view]

Order by SlpName"

Nº Facturas por vendedor durante el mes "select [url removed, login to view], SUM(A.NºFacturas) as NºFacturas

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view]

Order by SlpName"

Monto facturado por familia por vendedor durante mes "select [url removed, login to view],[url removed, login to view], SUM([url removed, login to view]) as Venta

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view], [url removed, login to view]

Order by SlpName"

Monto facturado por familia por vendedor últimos 30 días "select [url removed, login to view],[url removed, login to view], SUM([url removed, login to view]) as Venta

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view], [url removed, login to view]

Order by SlpName"

Nº Facturas por familia por vendedor durante mes "select [url removed, login to view],[url removed, login to view], SUM(A.NºFacturas) as NºFacturas

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view], [url removed, login to view]

Order by [url removed, login to view]"

Nº Facturas por familia por vendedor últimos 30 días "select [url removed, login to view],[url removed, login to view], SUM(A.NºFacturas) as NºFacturas

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view], [url removed, login to view]

Order by SlpName"

Margen Promedio por familia por vendedor últimos 30 días "select [url removed, login to view],[url removed, login to view], SUM([url removed, login to view]ón)/SUM([url removed, login to view])*100 as MargenPromedio

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas, SUM([url removed, login to view]) as Contribución

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view]), -SUM([url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view], [url removed, login to view]

Order by SlpName"

Margen Promedio por familia por vendedor durante el mes "select [url removed, login to view],[url removed, login to view], SUM([url removed, login to view]ón)/SUM([url removed, login to view])*100 as MargenPromedio

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas, SUM([url removed, login to view]) as Contribución

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view]), -SUM([url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view], [url removed, login to view]

Order by SlpName"

Margen promedio por vendedor últimos 30 días "select [url removed, login to view], SUM([url removed, login to view]ón)/SUM([url removed, login to view])*100 as MargenPromedio

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas, SUM([url removed, login to view]) as Contribución

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view]), -SUM([url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view]

Order by SlpName"

Margen promedio por vendedor durante el mes "select [url removed, login to view], SUM([url removed, login to view]ón)/SUM([url removed, login to view])*100 as MargenPromedio

from (select [url removed, login to view], [url removed, login to view], sum([url removed, login to view]) Venta, COUNT(distinct [url removed, login to view]) NºFacturas, SUM([url removed, login to view]) as Contribución

from INV1 full join OINV on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]

union

select [url removed, login to view], [url removed, login to view], -sum([url removed, login to view]) , -COUNT(distinct [url removed, login to view]), -SUM([url removed, login to view])

from RIN1 full join ORIN on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view], [url removed, login to view]) as A

left join OITM on ([url removed, login to view] = [url removed, login to view]) left join OSLP on ([url removed, login to view] = [url removed, login to view]) left join OITB on ([url removed, login to view] = [url removed, login to view])

Group by [url removed, login to view]

Order by SlpName"

Top 3 Monto Facturas últimos 30 días Ranking Vendedores "select top 3 [url removed, login to view] as MontoVenta, [url removed, login to view]

from OINV full join OSLP on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view] and [url removed, login to view] = 'n'

order by [url removed, login to view] desc"

Top 3 Monto Facturas durante el mes Ranking Vendedores "select top 3 [url removed, login to view] as MontoVenta, [url removed, login to view]

from OINV full join OSLP on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view] and [url removed, login to view] = 'n'

order by [url removed, login to view] desc"

Nº Oportunidades Creadas por Vendedor últimos 30 días "select [url removed, login to view], COUNT(distinct [url removed, login to view])

from OOPR left join OSLP on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view]"

Nº Oportunidades Creadas por Vendedor durante el mes "select [url removed, login to view], COUNT(distinct [url removed, login to view])

from OOPR left join OSLP on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view]

group by [url removed, login to view]"

Nº Oportunidades Ganadas por Vendedor últimos 30 días "select [url removed, login to view], COUNT(distinct [url removed, login to view])

from OOPR left join OSLP on ([url removed, login to view] = [url removed, login to view])

where GETDATE()-31 < [url removed, login to view] and [url removed, login to view] = 'w'

group by [url removed, login to view]"

Nº Oportunidades Ganadas por Vendedor durante el mes "select [url removed, login to view], COUNT(distinct [url removed, login to view])

from OOPR left join OSLP on ([url removed, login to view] = [url removed, login to view])

where month([url removed, login to view]) = month(getdate ()) and GETDATE()-31 < [url removed, login to view] and [url removed, login to view] = 'w'

group by [url removed, login to view]"

Compétences : Laravel , node.js, React.js, SAP

Voir plus : second stage, sap ecc magento integration, sap magento api, sap sms api, sap crm 2011 integration, cad sap magento integration, admin panel creation php, admin panel creation, sap transaction inventory vendor, admin panel creation dreamweaver

Concernant l'employeur :
( 69 commentaires ) concon, Chile

N° du projet : #12728828

12 freelance ont fait une offre moyenne de 748 $ pour ce travail

suhelshaikh

Hello! I am a professional having a vast experience in developing web and hybrid mobile applications for 6+ years and have expertise in PHP / CMS / Frameworks / JAVAScript / AJAX / JQuery / CSS / MySql / Laravel / Plus

700 $ USD en 10 jours
(16 Commentaires)
5.9
315 $ USD en 10 jours
(40 Commentaires)
5.6
SevenStarInfo

Hello ! We want to discuss about your project as we have experience in it. What Differentiates us from the other freelancers : # Experience of more than 5 years in Unity 3D, Xcode, CoCoa 2d, Phonegap and major Plus

750 $ USD en 10 jours
(4 Commentaires)
4.2
tudiptechnology

Hi, Let me keep this really short as i am sure you would be swamped with the proposals :)! We have been developing/maintaining web applications in React and various JavaScript libraries/frameworks like AngularJS, Plus

1111 $ USD en 20 jours
(2 Commentaires)
4.3
IMvikings7

Hi,Sir! Please see my portfolio. In my opinion "Quality is never an accident.". My first aim to provide u quality and professional task. It will really be a great opportunity for us in working with you on this proj Plus

555 $ USD en 10 jours
(1 Commentaire)
2.7
maxxsols2

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with you.We mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b Plus

555 $ USD en 6 jours
(0 Commentaires)
0.0
iraam

Hello sir, Greetings ! We are having experience of 7 years in developing websites, software and mobile applications Who we are? Inforaam is an innovative technology and business driven professional services Plus

750 $ USD en 20 jours
(0 Commentaires)
0.0
bonapps

Hello Team, "BONAPPS - Delivering Excellence just a click away" We read your entire proposal and are happy to share that we are interested in your proposal. We would like to have an in-depth discussion about the Plus

1000 $ USD en 10 jours
(0 Commentaires)
0.0
akshr

Dear Client My name is Jyoti & this email is in context to the Web Developer Position (Full Stack).I would like to give you more insight on the Skill set and work experience of mine Since, I have reviewed your s Plus

800 $ USD en 25 jours
(0 Commentaires)
0.0
555 $ USD en 10 jours
(0 Commentaires)
0.0
cracken

Hi, Delivering the task with quality is my goal. My skills fit perfectly to the kind of task you are looking for. In fact, I had delivered tasks to my satisfied clients that is related to this job. You can contact me Plus

749 $ USD en 0 jours
(0 Commentaires)
0.0
RubyOnRail

Hello, Its a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work upon customization part, if we can proceed towards more discussion. I have gone through your project Plus

833 $ USD en 18 jours
(0 Commentaires)
0.0
ramancio

I have more than 10 years with SAP ABAP and I'm integration expert. https://br.linkedin.com/in/rodneyamancio

666 $ USD en 10 jours
(0 Commentaires)
0.0
ominfowave

Dear Sir, Trust us we can do this project as we had done similar project of our clients. We want to work with you and build a healthy longterm relationship so please contact us and discuss for this project before fi Plus

749 $ USD en 25 jours
(0 Commentaires)
0.0