topic Dynamic Excel Template mapping to internal table in Application Development and Automation Discussions

topic Dynamic Excel Template mapping to internal table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783051#M2023855 <P>I have an requirement to upload excel with dynamic template from abap program i.e..the excel template won't be a constant, it might change.</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228828-image.png" /></P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228827-image.png" /></P> <P>move gt_intern[] TO gt_intern2[].<BR />DELETE gt_intern2 WHERE row NE 1.<BR /></P> <P></P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228829-image.png" /></P> <P>I need to get the get the fieldnames "LOC" and fields starts with "Charge for"</P> <P>I need the fields that starts with "Charge for" for calculation</P> <P>so i use this logic </P> <P>IF gwa_intern2-value+(10) EQ 'Charge for' OR gwa_intern-Value EQ 'Loc'.</P> <P>MOVE : gwa_intern2-col to gwa_intern3-col,<BR /> gwa_intern2-Value to gwa_intern3-value.<BR /> APPEND gwa_intern3 TO gt_intern3.<BR /></P> <P>then</P> <P>loop at gt_intern into gwa_intern.<BR />read table gt_intern3 ASSIGNING FIELD-SYMBOL(<FS_MA>) with key col = gwa_intern-col.<BR />if sy-subrc = 0.<BR /></P> <P> append to GT_BODY.</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228826-image.png" /></P> <P>After uploading the invoice and select necessary information from (Loc, Charge for: etc...) The question is how can I map the fields and their respective values from excel to another internal table. </P> <P>I tried this logic</P> <P>If Field01 = 'Charge for: Con'</P> <P> MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if Field01 = 'Charge for Dg'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if field01 ='Charge for FRT'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>endif.</P> <P>If Field02 = 'Charge for: Con'</P> <P> MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if Field02 = 'Charge for Dg'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if field02 ='Charge for FRT'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>endif.</P> <P>If Field03 = 'Charge for: Con'</P> <P> MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if Field03 = 'Charge for Dg'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if field03='Charge for FRT'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>endif.</P> <P>The things is I have 24 fields so I need to do this 24 times. </P> <P>is there another way to identify specific charges?</P> Fri, 17 Nov 2023 13:37:42 GMT calvinkarlo 2023-11-17T13:37:42Z Dynamic Excel Template mapping to internal table https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783051#M2023855 <P>I have an requirement to upload excel with dynamic template from abap program i.e..the excel template won't be a constant, it might change.</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228828-image.png" /></P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228827-image.png" /></P> <P>move gt_intern[] TO gt_intern2[].<BR />DELETE gt_intern2 WHERE row NE 1.<BR /></P> <P></P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228829-image.png" /></P> <P>I need to get the get the fieldnames "LOC" and fields starts with "Charge for"</P> <P>I need the fields that starts with "Charge for" for calculation</P> <P>so i use this logic </P> <P>IF gwa_intern2-value+(10) EQ 'Charge for' OR gwa_intern-Value EQ 'Loc'.</P> <P>MOVE : gwa_intern2-col to gwa_intern3-col,<BR /> gwa_intern2-Value to gwa_intern3-value.<BR /> APPEND gwa_intern3 TO gt_intern3.<BR /></P> <P>then</P> <P>loop at gt_intern into gwa_intern.<BR />read table gt_intern3 ASSIGNING FIELD-SYMBOL(<FS_MA>) with key col = gwa_intern-col.<BR />if sy-subrc = 0.<BR /></P> <P> append to GT_BODY.</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2228826-image.png" /></P> <P>After uploading the invoice and select necessary information from (Loc, Charge for: etc...) The question is how can I map the fields and their respective values from excel to another internal table. </P> <P>I tried this logic</P> <P>If Field01 = 'Charge for: Con'</P> <P> MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if Field01 = 'Charge for Dg'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if field01 ='Charge for FRT'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>endif.</P> <P>If Field02 = 'Charge for: Con'</P> <P> MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if Field02 = 'Charge for Dg'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if field02 ='Charge for FRT'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>endif.</P> <P>If Field03 = 'Charge for: Con'</P> <P> MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if Field03 = 'Charge for Dg'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>else if field03='Charge for FRT'</P> <P>MOVE: <FS_INPTFL>-FIELD01 TO E_invoice-BASE.</P> <P>endif.</P> <P>The things is I have 24 fields so I need to do this 24 times. </P> <P>is there another way to identify specific charges?</P> Fri, 17 Nov 2023 13:37:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783051#M2023855 calvinkarlo 2023-11-17T13:37:42Z Re: Dynamic Excel Template mapping to internal table https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783052#M2023856 <P>Check out the many blogposts and questions related to #abap2xlsx</P> Fri, 17 Nov 2023 13:49:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783052#M2023856 abo 2023-11-17T13:49:54Z Re: Dynamic Excel Template mapping to internal table https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783053#M2023857 <P>I don't get why GT_BODY contains these non-functional names FIELD01, etc.</P><P>Why don't you just indicate the component names you want, e.g. LOC, CHARGE_FOR_CON, etc.</P><P>I don't know your ABAP version, let's admit it's an old one (< 7.40):</P><PRE><CODE>read table GT_INTERN INTO LS_INTERN_LOC with key value = 'Loc'.<BR />read table GT_INTERN INTO LS_INTERN_CON with key value = 'Charge for: CON'.<BR />read table GT_INTERN INTO LS_INTERN_DG with key value = 'Charge for: DG'.<BR />read table GT_INTERN INTO LS_INTERN_FRT with key value = 'Charge for: FRT'. LOOP AT gt_intern INTO ls_intern WHERE row >= 2.<BR /> CASE ls_intern-col.<BR /> WHEN ls_intern_loc-col. E_invoice-LOC = ls_intern-value. WHEN ls_intern_loc-con. E_invoice-charge_for_con = ls_intern-value. WHEN ls_intern_loc-dg. E_invoice-charge_for_dg = ls_intern-value. WHEN ls_intern_loc-frt. E_invoice-charge_for_frt = ls_intern-value. ENDCASE. ... </CODE></PRE><P></P><P>Remarks:</P><UL><LI>Your variable names are awful, they should express the functional meaning.</LI><LI>MOVE has been obsolete for 15 years.</LI></UL> Fri, 17 Nov 2023 14:43:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dynamic-excel-template-mapping-to-internal-table/m-p/12783053#M2023857 Sandra_Rossi 2023-11-17T14:43:09Z