viksingh

Tables involved

 
PROJ

PRPS

PRHI

viksingh

<?xml version="1.0" encoding="UTF-8"?>
<!-- 
Name:		ProCon Invoice Mapping
Author: 	Chris Mills
Details: 	Mapping implemented as an XSL as single SAP Invoice message needs to be split to mutliple ProCon messages, 1 per PO
			and financials calculated by unique PO. i.e. if invoice has 3 line items which relate to two PO's then need to split to
			two output messages and calculate the tax and net amounts by PO, recursion much easier in XSL
			
			NOTE: This will only send items from the invoice that relate to a contract, the business rules are meant to be no multi-contract
			invoices and no mix of 1 item against a contract and another not but if it happens ProCon will only see parts of the invoice

viksingh

REPORT  ZCSV.

DATA:
      gt_excel_data TYPE TRUXS_T_TEXT_DATA.

  SELECTION-SCREEN BEGIN OF BLOCK b2 WITH FRAME TITLE text-002.
  PARAMETERS: p_file TYPE  localfile OBLIGATORY.
  SELECTION-SCREEN END OF BLOCK b2 .

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

viksingh

*&---------------------------------------------------------------------*
*& Report  ZCSV
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

report  zcsv.

viksingh

FORM convert_file_to_loading_data  USING    p_file_data TYPE zfile_data_tty " input file data table type
                                   CHANGING c_loading_data TYPE z_data_tty. " Target data table type
 
  DATA:    lt_csv_table_struct TYPE REF TO data,
            lo_csv_table_desc TYPE REF TO cl_abap_tabledescr,
            lo_csv_table_desc_struc TYPE REF TO cl_abap_structdescr,
            lt_csv_table_flds TYPE abap_compdescr_tab,
            lw_csv_table_flds TYPE abap_compdescr,
            lw_file_rawline TYPE LINE OF textline_t,
            lt_file_columns TYPE table_of_strings,

viksingh

Httpconnection connection = null;
BufferedReader reader     = null;
String forecastJsonStr    = null;
 
try {
    URL url    = new URL("http://api.openweathermap.org/data/2.5/forecast/daily?q=94043&mode=json&units=metric&cnt=7");
    connection = (Httpconnection) url.openConnection();
    connection.setRequestMethod("GET");
    connection.connect();
 

viksingh

package org.demo;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.xml.datatype.DatatypeConfigurationException;