Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Jan 8 at 9:45 AM Use a simple variable to capture the "last project header" at the end of your loop and compare the last header to the current header at the start of the loop. If the header is equal, skip the create BAPI. If different, call the create BAPI. Lou
| | | ---------------Original Message--------------- From: pathakvikash72 Sent: Thursday, January 08, 2015 7:27 AM Subject: How To Read Data From Excel Sheet While Same Data Is Existing Multiple Times Hi Guys, I am reading data from Excel in which same Master data existing more than one time and relevant multiple transaction data is there, this is my sample data Project definition header data exist 4 times with different transaction data (TO-00000004) whenever I am reading data and passing it to BAPI BAPI_BUS2001_Create and BAPI_BUS2054_CREATE_MULTI it is going dump, because it's showing (TO-00000004) already created Project Definition Description Project Profile Controlling Area Company Code Person Responsible Start Date Finish Date Tax Jurisdiction WBS Element Description Location Bsic Start Date Basic Finish Date Actual Start Date Tax Jurisdiction Responsible Person Responsible Cost Center Requesting Cost center Requesting Company Code Parent WBS Element TO-00000004 Test_Proj 0000001 1000 1000 00000002 1/1/2014 12/31/2014 TX0000000 TO-00000004.01 Test_level1 WBS 1/1/2014 12/31/2014 1/1/2014 TX0000000 00000002 1101 1001 1000 TO-00000004 Test_Proj 0000001 1000 1000 00000002 1/1/2014 12/31/2014 TX0000000 TO-00000004.01.01 Test_level2 WBS 1/1/2014 12/31/2014 1/1/2014 TX0000000 00000002 1101 1001 1000 TO-00000004.01 TO-00000004 Test_Proj 0000001 1000 1000 00000002 1/1/2014 12/31/2014 TX0000000 TO-00000004.01.02 Test_level2 WBS1 1/1/2014 12/31/2014 1/1/2014 TX0000000 00000002 1101 1001 1000 TO-00000004.01 TO-00000004 Test_Proj 0000001 1000 1000 00000002 1/1/2014 12/31/2014 TX0000000 TO-00000004.02 Test level 1 WBS1 1/1/2014 12/31/2014 1/1/2014 TX0000000 00000002 1101 1001 1000 So, please help me out to solve this issue. Thanks in advance, Vikash | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |