BOM Download To Excel For I&PD Exercise

5 pts.
Tags:
Excel 2007
Microsoft Excel
SAP BOM
SAP Import/Export
Are there easy directions for me to download from the SAP BOM's comprising 7000 lines to Excel for manipulation and pivoting of the data?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Don’t think there’s an easy way. The BOM data is in two different tables – Header data is in MAST and detail component data is in STPO. Depening on what you’re looking to extract you could use SE16 to get the data from the two tables into spreadsheets. It could get tricky with validity dates of components etc.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Nitin2000us
    Hi, I think if you know which BOM or BOM number ten you can directly go to se16 and check whether you wanted to have BOM header details then go to table STKO not MAST and if you want to know the item details in BOM then you can go to table STPO and get the details downloaded into excel sheet and if you want both the details then donload both the BOM tables in two diffrent excel sheet and we can have wheel loop on the two tables . Regrads, Nitin
    65 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following