Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from Dilli on Jul 17 at 9:12 PM Hi,
I have a VBA Excel macro that create SOs in SAP ERP (T Code: VA01) based on information provided in Sheet1 in Excel. It creates the BOM and adds the sub-materials to it. However, it does not link/loop the sub-materials to the BOM like how we do it manually in "Items details: Configuration" section. It automatically adds values on the tabs in "Characteristic Value Assignment" and so the Services (i.e. SAPLCEI0 screen) but it does not link the same under "Configuration Structure" section.
Please advise.
P.S.: I am giving an example code that adds values in the "Characteristic Value Assignment" but I am looking for a similar code(s) that will loop the materials/services to the BOM, under Configuration Structure.
session.findById("wnd[0]/usr/subCE_INSTANCE:S APLCEI0:1105/tabsTABSTRIP_CHAR/tabpTAB3").Select
session.findById("wnd[0]/usr/subCE_INSTANCE:S APLCEI0:1105/tabsTABSTRIP_CHAR/tabpTAB3/ssubCHARACTERISTI CS:SAPLCEI0:1400/tblSAPLCEI0CHARACTER_VALUES/ctxtRCT MS-MWERT[1,0]").Text = Sheets("Sheet1").Range("Y" & i)
session.findById("wnd[0]/usr/subCE_INSTANCE:S APLCEI0:1105/tabsTABSTRIP_CHAR/tabpTAB3/ssubCHARACTERISTI CS:SAPLCEI0:1400/tblSAPLCEI0CHARACTER_VALUES/ctxtRCT MS-MWERT[1,1]").Text = Sheets("Sheet1").Range("Z" & i)
session.findById("wnd[0]/usr/subCE_INSTANCE:S APLCEI0:1105/tabsTABSTRIP_CHAR/tabpTAB3/ssubCHARACTERISTI CS:SAPLCEI0:1400/tblSAPLCEI0CHARACTER_VALUES/ctxtRCT MS-MWERT[1,5]").Text = Sheets("Sheet1").Range("AA" & i)
session.findById("wnd[0]/usr/subCE_INSTANCE:S APLCEI0:1105/tabsTABSTRIP_CHAR/tabpTAB3/ssubCHARACTERISTI CS:SAPLCEI0:1400/tblSAPLCEI0CHARACTER_VALUES/ctxtRCT MS-MWERT[1,7]").Text = Sheets("Sheet1").Range("AB" & i)
Regards,
Dilli.
| Reply to this email to post your response. __.____._ |   _.____.__ |
