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
Friday, 4 January 2019
Thursday, 11 October 2018
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
Subscribe to:
Posts (Atom)
