Hi there ,
I'm looking for some experience working with SAP,
I need to unload BOM from sap.
Did anyone do it ?
Can you give some insights on how to do it.
Thanks,
Happy new year
Amos
Work with SAP BOM
Moderators: chulett, rschirm, roy
Hi,
BOM is Bill of Material. It provides a complete, formally structured list of the components that make up a product or assembly. Also called as Material List in process manufacturing. Transation code:CS01/02/03
I believe you are asking from which SAP tables can BOM details be derived. If that is your question then here is my reply:
Following SAP Tables will give you BOM details:
1. STKO (BOM Header details)
2. STPO (BOM Items)
3. MAST (Material to BOM link)
You need to use ABAP_Extract stage to connect to SAP . You can make an inner join between tables and get the desired result set.
Hope your query is answered.
Regards,
______________________
Rachana Singh
Capgemini / Bangalore
DataStage-SAP Consultant
______________________
BOM is Bill of Material. It provides a complete, formally structured list of the components that make up a product or assembly. Also called as Material List in process manufacturing. Transation code:CS01/02/03
I believe you are asking from which SAP tables can BOM details be derived. If that is your question then here is my reply:
Following SAP Tables will give you BOM details:
1. STKO (BOM Header details)
2. STPO (BOM Items)
3. MAST (Material to BOM link)
You need to use ABAP_Extract stage to connect to SAP . You can make an inner join between tables and get the desired result set.
Hope your query is answered.
Regards,
______________________
Rachana Singh
Capgemini / Bangalore
DataStage-SAP Consultant
______________________
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
Hi,
There are many SAP programs on BOM and I am not sure which one fits your requirement best.
If you don't want to read the BOM tables in DataStage and get the results directly from SAP then the only alternative I can think of is to have some customized ABAP program where the required result set goes into a "Z" table and then the DataStage can pick up the data from this "Z" table.
Again the design will differ at what level the BOM is to be exploded, if it has to be exploded for all materials or for parameterized materials or for all levels. BOM can be exploded level by level, multi level or a summary cen be derived.
I will appreciate if you could provide me with more details on the BOM requirement.
Regards,
Rachana
There are many SAP programs on BOM and I am not sure which one fits your requirement best.
If you don't want to read the BOM tables in DataStage and get the results directly from SAP then the only alternative I can think of is to have some customized ABAP program where the required result set goes into a "Z" table and then the DataStage can pick up the data from this "Z" table.
Again the design will differ at what level the BOM is to be exploded, if it has to be exploded for all materials or for parameterized materials or for all levels. BOM can be exploded level by level, multi level or a summary cen be derived.
I will appreciate if you could provide me with more details on the BOM requirement.
Regards,
Rachana
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
Thanks again,
This is what I expected, I thing I can always use a BAPI to get this data.
The mission is to read the material BOM, I just want to learn the sap pack.
The documentation is very poor.
I have 3 questions I want to ask you, I hope you don't mind if I send them to you.
Thanks
and happy new year
Amos
This is what I expected, I thing I can always use a BAPI to get this data.
The mission is to read the material BOM, I just want to learn the sap pack.
The documentation is very poor.
I have 3 questions I want to ask you, I hope you don't mind if I send them to you.
Thanks
and happy new year
Amos
Hi Amos,
Please post your questions, I will be glad if I can be of any assistence.
If they are related to DataStage you can use Dsxchange as the medium else you can reach me at: rachana_aries@yahoo.com
Regards,
Rachana
Please post your questions, I will be glad if I can be of any assistence.
If they are related to DataStage you can use Dsxchange as the medium else you can reach me at: rachana_aries@yahoo.com
Regards,
Rachana
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
Hi Rachana ,
Thanks again for sharing some of your DS-SAP expiriance,
I have 3 questions I could not find the answer to:
1. Can SAP PACK utilize the "X-Structure" mechanism when updating a record? (This mechanism enables to deliver a whole record for update to the SAP side, while noting within a parallel structure of flags which re the exact fields needed to be updated).
2. Can SAP PACK utilize the "check tables" mechanism when updating/inserting a record? (This SAP mechanism enables to validate specific fields' values according to pre-defined reference tables, prior to actually inserting them to the DB).
3. How can you utilize recovery mechanisms when inserting/updating the SAP. For example, can we roll-back a transaction? Control the transaction size? Etc.
Thanks for your time
Thanks in advance,
Amos
Thanks again for sharing some of your DS-SAP expiriance,
I have 3 questions I could not find the answer to:
1. Can SAP PACK utilize the "X-Structure" mechanism when updating a record? (This mechanism enables to deliver a whole record for update to the SAP side, while noting within a parallel structure of flags which re the exact fields needed to be updated).
2. Can SAP PACK utilize the "check tables" mechanism when updating/inserting a record? (This SAP mechanism enables to validate specific fields' values according to pre-defined reference tables, prior to actually inserting them to the DB).
3. How can you utilize recovery mechanisms when inserting/updating the SAP. For example, can we roll-back a transaction? Control the transaction size? Etc.
Thanks for your time
Thanks in advance,
Amos