Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Purged Data in SAP

Former Member
0 Kudos

How does SAP manage the purged data in SAP databse.

Lets sa i have deleted a Business Partner or any transaion in SAP.

what happens to it.

I guess it resides somewhere in archive mode or format or files.

WHere does it store all the purge data.

Does it a physical delete, move to history tables... or set a flag etc.

5 REPLIES 5

Former Member
0 Kudos

Nothing in SAP will be permanently deleted what ever you delete those documents will be only flagged for deletion ie only logical deletion will be done.

Especially with master data you can block them or flag them for deletion, but nothing will be deleted like that.

0 Kudos

Thanks.

it is understood that once a data is deleted/archived from SAP, it is no longer available in the main database.

Wat happens to the data once it marked for Deletion.

Is it a physical delete, Move to hisory table....

0 Kudos

Deleted and Archived data is going to be stored in the below tables:-

TXW_C_BUKRS Settings for company codes

TXW_C_GLO Global settings (fields from structure TXW

TXW_C_REF Reference for currency/amount fields

TXW_C_RELA Relations of tables and domains

TXW_C_SOEX Source tables and export structures

TXW_C_STRC Segment structures

TXW_C_V0 Data view: Header

TXW_C_V0T Data view: Description

TXW_C_V1 Data view: Data segments

TXW_C_V2 Data view: Join conditions

TXW_C_V2S Data view: Standard join conditions

TXW_C_V3 Data view: View fields

TXW_C_V4 Data view: Selection conditions

TXW_C_VOL Data file directory sets

TXW_C_VOLD Data file directories

TXW_C_VOLT Data file directory set descriptions

TXW_DIR Data file log (replaced by txw_dir2, use o

TXW_DIR2 Data file log

TXW_DIRAL Data file log - ArchiveLink (obsolete afte

TXW_DIRAL2 Data file log - ArchiveLink

TXW_DIRSEG Data file segment directory (replaced by t

TXW_DIRSG2 Data file segment directory

TXW_FSZH DART: file size settings header

TXW_FSZR DART: file size estimator settings records

TXW_FSZT DART: file size settings description

TXW_IBU DART: IBU add-on extraction function modul

TXW_INDEX Temporary table for data segment index

TXW_INDEX_01 Temporary table for data segment index

TXW_INDEX_02 Temporary table for data segment index

TXW_INDEX_03 Temporary table for data segment index

TXW_INDEX_04 Temporary table for data segment index

TXW_INDEX_05 Temporary table for data segment index

TXW_LOCK1 Lock object for INDX (Tax Data retention)

TXW_LOCK2 Lock object for data file

TXW_R_STAT Status/Trace for TXW-data retrieval from a

TXW_S_ANEA Retrieve ANEA from archive

TXW_S_ANEK Retrieve ANEP from archive

TXW_S_ANEP Retrieve ANEP from archive

TXW_S_BKPF Retrieve BKPF from archive

TXW_S_BSEG Retrieve BSEG from archive

TXW_S_COBK Retrieve COBK from archive

TXW_S_COEP Retrieve COEP from archive

TXW_S_COFI Retrieve COFIS from archive

TXW_S_EKKO Retrieve EKKO from archive

TXW_S_EKPO Retrieve EKPO from archive

TXW_S_GLT0 Retrieve archived GLT0 data

TXW_S_KNC1 Retrieve archived Customer master data

TXW_S_LFC1 Retrieve archived Vendor master (transacti

TXW_S_LIKP Retrieve LIKP from archive

TXW_S_LIPS Retrieve LIPS from archive

TXW_S_MKPF Retrieve MKPF from archive

TXW_S_MSEG Retrieve MSEG from archive

TXW_S_VBAK Retrieve VBAK from archive

TXW_S_VBAP Retrieve VBAP from archive

TXW_S_VBPA Retrieve VBPA from archive

TXW_S_VBRK Retrieve VBRK from archive

TXW_S_VBRP Retrieve VBRP from archive

TXW_VARIA Contents of Variant of TXW-archive retriev

TXW_VWLOG View query log (replaced by txw_vwlog2: uu

TXW_VWLOG2 View query log

TXW_VWLOG2_U Data view query log

Data will be stored in different tables depending upon the document.

Thanks,

Mahesh.

0 Kudos

Where will the busines partner details be stored.

Which is the transaction to see this data again.

0 Kudos

You can the archived data of both customer and vendor in the below tables TXW_S_KNC1

TXW_S_LFC1 respectively.