SELECT F42119.SDDOCO as sales_order, F42119.SDLNID/1000 as line, F42119.SDMCU AS BRANCH_PLANT,
F42119.SDAN8 AS AB_SELLTO, F0101.ABALPH AS SELL_TO, F42119.SDSHAN AS AB_SHIPTO, F0101_1.ABALPH as SHIP_TO,
19 + substr( F42119.SDTRDJ, 1, 1 ) ||
substr(F42119.SDTRDJ, 2,2) || '-' ||
to_char( to_date( substr( F42119.SDTRDJ, 4, 3 ) , 'DDD') , 'MM' ) || '-' ||
to_char( to_date( substr( F42119.SDTRDJ, 4, 3 ) - 1 , 'DDD') , 'DD' ) AS transaction_date,
19 + substr( F42119.SDDRQJ, 1, 1 ) ||
substr(F42119.SDDRQJ, 2,2) || '-' ||
to_char( to_date( substr( F42119.SDDRQJ, 4, 3 ) , 'DDD') , 'MM' ) || '-' ||
to_char( to_date( substr( F42119.SDDRQJ, 4, 3 ) - 1 , 'DDD') , 'DD' ) as requested_date,
19 + substr( F42119.SDPDDJ, 1, 1 ) ||
substr(F42119.SDPDDJ, 2,2) || '-' ||
to_char( to_date( substr( F42119.SDPDDJ, 4, 3 ) , 'DDD') , 'MM' ) || '-' ||
to_char( to_date( substr( F42119.SDPDDJ, 4, 3 ) - 1 , 'DDD') , 'DD' ) AS promised_date
 , 19 + substr( F42119.SDADDJ, 1, 1 ) ||
substr(F42119.SDADDJ, 2,2) || '-' ||
to_char( to_date( substr( F42119.SDADDJ, 4, 3 ) , 'DDD') , 'MM' ) || '-' ||
to_char( to_date( substr( F42119.SDADDJ, 4, 3 ) - 1 , 'DDD') , 'DD' ) AS actual_delivery,
19 + substr( F42119.SDIVD, 1, 1 ) ||
substr(F42119.SDIVD, 2,2) || '-' ||
to_char( to_date( substr( F42119.SDIVD, 4, 3 ) , 'DDD') , 'MM' ) || '-' ||
to_char( to_date( substr( F42119.SDIVD, 4, 3 ) - 1 , 'DDD') , 'DD' ) AS invoice_date,
19 + substr( F42119.SDDGL, 1, 1 ) ||
substr(F42119.SDDGL, 2,2) || '-' ||
to_char( to_date( substr( F42119.SDDGL, 4, 3 ) , 'DDD') , 'MM' ) || '-' ||
to_char( to_date( substr( F42119.SDDGL, 4, 3 ) - 1 , 'DDD') , 'DD' ) AS gl_date,
F42119.SDLITM as item_number, F42119.SDITM as short_item_number, F42119.SDLOCN as location,
F42119.SDLOTN as lot_number, F42119.SDDSC1 as description, F42119.SDSRP1 as sales_reporting_1,
F42119.SDSRP2 as sales_reporting_2, F42119.SDSRP3 as sales_reporting_3, F42119.SDSRP4 as sales_reporting_4,
F42119.SDSRP5 as sales_reporting_5, F42119.SDUOM1 as unit_of_measure_primary,
F42119.SDPQOR/10000 as order_quantity_primary, F42119.SDAEXP/100 as order_amount,
F42119.SDECST/100 as extended_cost, (F42119.SDAEXP/100)-(F42119.SDECST/100) as order_profit,
(((F42119.SDAEXP/100)-(F42119.SDECST/100))*100)/(F42119.SDAEXP/100) as profit_percent
FROM EXPDDTA.F0101 F0101, EXPDDTA.F0101 F0101_1, EXPDDTA.F42119 F42119
WHERE F0101.ABAN8 = F42119.SDAN8 AND F42119.SDSHAN = F0101_1.ABAN8 AND ((F42119.SDLTTR>='620') AND (F42119.SDITM<>0))
ORDER BY F42119.SDDOCO