deleted Bom tables

[Former Member]

Hi Friends,

my requirement is to display deleted component details of material(BOM) ,deleted record is there in cdpos table but it is not present in stpo or stas .if there are any other tables which have deleted records details please send me.

please help.

Regards,

Sravani.

[ThomasZloch]

Doesn't "deletion" usually mean that the data is gone from the tables? Unless it is only a "marked for deletion" indicator. What is the case for material BOMs?

Please highlight the deeper sense of your requirement.

[Former Member]

My report inputs are material,plant, bom usage and date and i should get creaed changed and deleted components of the material.i am getting changed and created components because they are there in stpo table in cdpos table we are having deleted details but there is no component so is there any table other than this tables

Thanks in advance

Edited by: sravanijadala on Nov 11, 2011 9:43 PM

[Former Member]

Read Thomas's post again..... Some IT101 - in IT, 'deleted' does not mean physically removed from a database table... that's why we must always consider deleted and completed indicators. STPO contains field LKENZ, which you should check for 'X' - Deleted.

It is possible, perhaps, that these rows would be physically deleted during a reorg, but I doubt that...

[Former Member]

I have seen that but there is no 'X' in lkenz field

[Former Member]

If there is no 'X", then that row has NOT been marked as 'deleted'.

[Former Member]

Just a thought about CDPOS (and I'm assuming that you would first read CDHDR to get the keys for CDPOS, since that table is usually gigantic), if you're reading CDPOS and finding an entry, can you even tell what BOM an entry originally belonged to? I don't remember...we don't have logistics and it's been a while since I worked on BOM/Explosions, etc.

[Former Member]

Yes i can tell the BOM but by watching in Tcode CS02 in environment-->change document by giving the datewe get thedeleted record details the tablekey which present in change document history with that i am checking it in cdpos and like that i am able to find out the deleted record.

[Former Member]

Hi Thomas thanks for replying,if the component is not marked as deleted can we get the component from the tables.if we can get the data plz suggest me.

thanks in advance

[sjeevan]

In you program concatenate MANDT STLTY STLNR (from table STPO) and pass it to OBJECTID field in table CDPOS. Apply some logic to get CHNGIIND = 'D' etc. See if it meets your requirement.

[Former Member]

hi jeevan thanks for replying,When I delete a BOM component using transaction CS02,I look into the cdhdr and cdpos tables to see the changes.

From the cdpos table,I get a tabkey field which is a KEY to the stpo table.But as the component is deleted,the entry corresponding to this tabkey is not there in STPO.

But I want to find out the "component name", "item number" and "quantity" of the BOM component which got deleted.This information is there in the SPPO fields - idnrk and posnr.

But as the STPO doesnt have the deleted component.where will I get this information from...

I really need this information.

thanks in advnace.

[Former Member]

I suppose that the items were marked for deletion and then archived. This would cause the individual items to be physically deleted, but (probably?) remaining in CDPOS.

If you really need those details, you can read the archive, but it would probably be easier to trust CDPOS.

Rob

[Former Member]

Let me refine that - if the items have been archived, then probably no one cares about them and you can simply use the deletion indicator.

Rob

[sjeevan]

If they're using ECM/ECR to change the BOM (which includes deletion) your program logic may get little bit complex. Because now have to deal with valid to date of the items.

If an item is deleted using ECM/ECR look for entries STPO-LKENZ = 'X' and corresponding STPO-AENNR. You can look up all the change numbers used for that BOM in the product structure in CC04.

I don't think you can archive them at item level. But still you may want to read about PP-BOM archiving here.

http://help.sap.com/saphelp_bw/helpdata/en/8d/3e6694462a11d189000000e8323d3a/frameset.htm

[Former Member]

Thanks to everyone,the deleted record is present in CDPOS table but there not present in STPO and also LKENZ is not assigned with 'X'.My requirement is to get the component material & item details is there any other table other than CDPOS

[Former Member]

Have you found any solution for your requirement?

I am also having same requirement but couldn't find any solution.

Regards,

Chintan

[jdallagnese]

Hello,

In the CDPOS table you can't identify what changed in the bill of material.

Because, if you don't have the ECM (Engineering Change Management), when you delete a item of the BOM, in the PLPO table the iten is deleted.

If you need to do a version of each change you execute, you need the ECM.

Best regards.

José Dallagnese