sap - How to transpose an internal table rows into columns? -

-

i want transpose internal table rows column , want fix first column,i trying following code not getting expected result....it not converting rows columns

*types declaration types: begin of ty_t001w,          ekorg type t001w-ekorg,          werks type t001w-werks,          name1 type t001w-name1,        end of ty_t001w.  **field symbols declaration  field-symbols:  <fs1> type any,                  <fs2> type any.  **internal table , work area declaration  data: it1_col_row type standard table of ty_t001w,        wa1_col_row type ty_t001w,        it2_col_row type standard table of ty_t001w,        wa2_col_row type ty_t001w,        cline   type sy-tabix.  **filling internal table data  select *   t001w corresponding fields of table it1_col_row   ekorg = p_ekorg   , fabkl = p_fabkl.  **looping internal table display data  loop @ it1_col_row wa1_col_row.    write: / wa1_col_row-ekorg, wa1_col_row-werks,wa1_col_row-name1.  endloop.  write: /.  **looping internal table change rows columns  loop @ it1_col_row wa1_col_row.    clear wa2_col_row.    assign component sy-tabix of structure wa2_col_row <fs1>.    cline = sy-tabix.    do.      assign component sy-index of structure wa1_col_row <fs2>.      if sy-subrc ne 0.        exit.      endif.      if cline = 1.        <fs1> = <fs2>.        append wa2_col_row it2_col_row.      else.        read table it2_col_row wa2_col_row index sy-index.        <fs1> = <fs2>.        modify it2_col_row wa2_col_row index sy-index.      endif.    enddo.  endloop. * **looping internal table display  loop @ it2_col_row wa2_col_row.    write: / wa2_col_row-ekorg,wa2_col_row-werks, wa2_col_row-name1.  endloop.

notice field types of ty_t001w have different length:

  • ekorg type t001w-ekorg has char 4
  • werks type t001w-werks has char 4, but
  • name1 type t001w-name1 has char 30

you using same type ty_t001w source table (it1_col_row) target table (it2_col_row). when mapping source rows table target columns table 30 character field name1 mapped 4 character field ekorg. when executed program in system had following output (dependent on contents of db table t001w):

0001 0001 werk 0001 0001 0002 werk 0002 0001 0003 werk 0003 0001 rad1 werk rad1  0001 0001 0001 0001 0002 rad1 werk werk werk rad1

at first glance looks "it not converting rows columns". in debugger noticed "werk 0001" one value, not two! value truncated "werk" because mapped 30 character field 4 character field. happens bottom value of column 1 ("werk 0002") , 2 ("werk 0003"). bottom value of column 3 ("werk rad1") mapped correctly because here it's mapped 30 character field 30 character field.

to correct issue have created types definition ty_t001w_col target table it2_col_row. in type fields have maximum length of 30 characters ensuring no truncation may occur (see abap code below). generates following output:

0001 0001 werk 0001 0001 0002 werk 0002 0001 0003 werk 0003 0001 rad1 werk rad1  0001                           0001                           0001 0001                           0002                           rad1 werk 0001                      werk 0002                      werk rad1

the corrected report:

report zhd_stackoverflow_q27163908.  perform function       using '0001'             '01'.  form function   using p_ekorg type ekorg         p_fabkl type fabkl.  types declaration types: begin of ty_t001w,          ekorg type t001w-ekorg,          werks type t001w-werks,          name1 type t001w-name1,        end of ty_t001w. types: begin of ty_t001w_col,          ekorg type t001w-name1,          werks type t001w-name1,          name1 type t001w-name1,        end of ty_t001w_col.  *field symbols declaration  field-symbols:  <fs1> type any,                  <fs2> type any.  *internal table , work area declaration  data: it1_col_row type standard table of ty_t001w,        wa1_col_row type ty_t001w,        it2_col_row type standard table of ty_t001w_col,        wa2_col_row type ty_t001w_col,        cline   type sy-tabix.  *filling internal table data  select *   t001w corresponding fields of table it1_col_row   ekorg = p_ekorg   , fabkl = p_fabkl.  *looping internal table display data  loop @ it1_col_row wa1_col_row.    write: / wa1_col_row-ekorg, wa1_col_row-werks,wa1_col_row-name1.  endloop.  write: /.  *looping internal table change rows columns  loop @ it1_col_row wa1_col_row.    clear wa2_col_row.    assign component sy-tabix of structure wa2_col_row <fs1>.    cline = sy-tabix.    do.      assign component sy-index of structure wa1_col_row <fs2>.      if sy-subrc ne 0.        exit.      endif.      if cline = 1.        <fs1> = <fs2>.        append wa2_col_row it2_col_row.      else.        read table it2_col_row wa2_col_row index sy-index.        <fs1> = <fs2>.        modify it2_col_row wa2_col_row index sy-index.      endif.    enddo.  endloop.  *looping internal table display  loop @ it2_col_row wa2_col_row.    write: / wa2_col_row-ekorg,wa2_col_row-werks, wa2_col_row-name1.  endloop.   endform.

Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more