Deletes SC from datenbase, BBP_PD_SC_DB_DELETE

[Former Member]

I need to delete SCs from database (from all tables completelly). I tried BBP_PD_SC_DB_DELETE BBP_PD_SC_DB_DELETE_MULTI, they should delete SCs based on Header GUID but it doesn't work. Must the SCs have a corresponding status before deletion? What kind of? Are there any othe functions for SC deletion?

[Former Member · Accepted solution]

Hi,

in the following status is possible to delete SC:

hold	deletion on header level

in approval

deletion on header level

approved

deletion on item level

follow-on document created

deletion on item level

|follow-on document of the follow-on documents | SC can not be deleted |

After the SC saved, you are not able to delete it from the database, you can only set deleted status.

There are no standard report to delete from the database.

To delete the SC completly from the system you need to delete from the following tables:

Header level: CRMD_ORDERADM_H, BBP_PDHGP, BBP_PDBEH

Item level: CRMD_ORDERADM_I, BBP_PDIGP, BBP_PDBEI

There is not recommended to delete direct from the database!

System should be inconsistent!

Regards

Laszlo

[peter_novoth]

Hi,

is not recommended to delete SCs directly from the database.

In my suggestion do the following:

Delete the SC from the browser in the "normal way"

If this is not possible, set the deletion flags hard, on the database. The following indicators have to be set for a completly deletion:

• Deletion on the header level: BBP_PDIGP-DEL_IND -> 'X'

• Deleted status: CRMD_JEST -> 'I1040'

• Deletion on the item level: BBP_PDHGP-DOC_CLOSED -> 'X'

Archive the SC.

Regards,

Peter

[Former Member]

Hallo zusammen,

ich hoffe,dass Sie mir verstehen werden, vielen Dank fur Hilfe,

Tabelle TJ02 ist nicht getaugt, denn sie beantwortet nur Eigenschaft (anzeigen oder nicht anzeigen).

und aber Ich soll hartest Loschung aus DB machen, ich glaube das sit moglich uber Standart Archivierung JOB zu machen.(mit Anderung Vorlaufprogramm). Wie denken Sie ist es moglich? und wissen Sie was macht Programm BBP_PD_SC_DB_DELETE und wie es arbeitet (selbst (loescht uber Guid-Header) oder nur im Komplexs mit den anderen standarent Programmen mit der Anwendung der vorhandenen Daten (Status SC 'archivbar' , 'geloscht' und andere) ). Danke in voraus.

[Former Member]

hello,

look into the table TJ02 , there you can find the status