Hi all,
I am trying to give heading to my excel sheet data,
but my probelem is i am unable to get all the headings
Its missing after showing somewhere arong 10 heading.
Below i m providing my code which i have used for populating the headings.
<code>
IT_OBJBIN TYPE TABLE OF SOLISTI1,
FORM HEADING .
CLEAR WA_OBJBIN.
REFRESH : IT_OBJBIN.
CONCATENATE CL_ABAP_CHAR_UTILITIES=>CR_LF
'Sales order number'(025) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'PAX'(005) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Booking Date'(008) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Tour ID'(10) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Hotel Name'(035) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Tour Revenue'(020) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'negative Sales Discounts'(020) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Supplem from Break down '(013) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Total Revenue'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Commission'(013) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Commission %'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'COGS - Hotel'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'COGS - Transfers'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'COGS - Misc. Supplem, Wrong??'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Rev Cancellation Fee + Adjstment'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'CC Fees est at 2.5%'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
' Cont. Margin (was Cost Margin)'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Cost Margin per Pax'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'AVOK'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'COGS - Insurance'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
' Net AVOK Revenue'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Type'(002) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'COGS - Sked Air Cost'(015) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'NO-ZERO Air markup %'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Planned seat cost'(004) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
'Day of Week'(003) CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB
CL_ABAP_CHAR_UTILITIES=>CR_LF
INTO WA_OBJBIN.
APPEND WA_OBJBIN TO IT_OBJBIN.
CLEAR WA_OBJBIN.
</code>
regards,
satish
Bluesky
