09-08-2009 12:38 PM
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.
09-08-2009 12:45 PM
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.
09-08-2009 12:50 PM
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....
09-08-2009 1:07 PM
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.
09-08-2009 1:50 PM
Where will the busines partner details be stored.
Which is the transaction to see this data again.
09-09-2009 4:39 AM
You can the archived data of both customer and vendor in the below tables TXW_S_KNC1
TXW_S_LFC1 respectively.