Wednesday, 27 March 2019

OPEN DATASET

Always it is best to give the entire path in AL11 directory. In the below, /tmp is the path and trace_vscan.txt is the text file name. REPORT ybtest1. *********************************************************************************************** Data : Trace1 TYPE string VALUE '/tmp/trace_vscan.txt', str TYPE string. OPEN DATASET Trace1 FOR APPENDING IN TEXT MODE ENCODING DEFAULT. CONCATENATE 'Document ID : ' 'is being sent for virus scan.' into str SEPARATED BY Space. TRANSFER str to Trace1. CLOSE DATASET Trace1. below is the statement to delete the dataset. DELETE DATASET Trace1 .

Saturday, 23 February 2019

Best Socks for Men and Women

http://www.flipkart.com/reebok-men-women-ankle-length/p/itmf3y9tra6m8fh2?pid=SOCF3CBFQDBHJST3&affid=bharatmbk

Friday, 1 February 2019

Best Washing Machine , Samsung

https://www.flipkart.com/samsung-6-2-kg-fully-automatic-top-load-washing-machine-grey/p/itmewa2xkfkeq9cz?pid=WMNEWA2XKFSHQZZG&affid=bharatmbk

Sunday, 20 January 2019

Best sofa set

https://www.flipkart.com/flipkart-perfect-homes-porto-fabric-4-seater-sofa/p/itmf4ff7gsg3vfb5?marketplace=FLIPKART&lid=LSTSOFF4YZZXGMCWGRB5HSVD3&pid=SOFF4YZZXGMCWGRB&affid=bharatmbk

Tuesday, 31 July 2018

MESH and Group by in Internal tabel examples

Mesh Program *&---------------------------------------------------------------------* *& Report YBTEST_MESH *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT YBTEST_MESH. TYPES: BEGIN OF ty_customer, customer TYPE char10, NAME TYPE char30, city TYPE char30, route TYPE char30, END OF ty_customer. TYPES: tt_customers TYPE SORTED TABLE OF ty_customer WITH UNIQUE KEY customer. TYPES: BEGIN OF ty_orders, order TYPE char10, customer TYPE char10, END OF ty_orders. TYPES: tt_orders TYPE SORTED TABLE OF ty_orders WITH UNIQUE KEY order. TYPES: BEGIN OF MESH ty_rep_mesh, order_info TYPE tt_orders ASSOCIATION order_to_customer TO customer_info ON customer = customer, customer_info TYPE tt_customers, END OF MESH ty_rep_mesh. DATA(t_customres) = VALUE tt_customers( ( customer = 'C0001' NAME = 'Test Customer 1' city = 'NY' route = 'R0001' ) ( customer = 'C0002' NAME = 'Customer 2' city = 'LA' route = 'R0003' ) ( customer = 'C0003' NAME = 'Good Customer 3' city = 'DFW' route = 'R0001' ) ( customer = 'C0004' NAME = 'Best Customer 4' city = 'CH' route = 'R0003' ) ). DATA(t_orders) = VALUE tt_orders( ( order = '90001' customer = 'C0001' ) ( order = '90002' customer = 'C0002' ) ( order = '90003' customer = 'C0001' ) ( order = '90004' customer = 'C0001' ) ( order = '90005' customer = 'C0004' ) ( order = '90006' customer = 'C0004' ) ( order = '90007' customer = 'C0003' ) ). DATA t_mesh TYPE ty_rep_mesh. t_mesh-order_info = t_orders. t_mesh-customer_info = t_customres. LOOP AT t_mesh-order_info INTO DATA(ls_order). WRITE: / ls_order-order. DATA(ls_cust) = t_mesh-order_info\order_to_customer[ t_mesh-order_info[ order = ls_order-order ] ]. WRITE: ` `, ls_cust-customer, ls_cust-NAME. ENDLOOP. ______________________________________________________________________________________________________ Group by Program