TXW_S_COFI SAP (Retrieve COFIS from archive) Table details
Dictionary Type: Table
Description: Retrieve COFIS from archive
Description: Retrieve COFIS from archive
Table field list including key, data, relationships and ABAP select examples
TXW_S_COFI is a standard SAP Table which is used to store Retrieve COFIS from archive data and is available within R/3 SAP systems depending on the version and release level.
The TXW_S_COFI table consists of various fields, each holding specific information or linking keys about Retrieve COFIS from archive data available in SAP. These include TXGL_SIRID (Record number of the line item record), RLDNR (Ledger), DOCCT (Document Type), RCLNT (Client).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP TXW_S_COFI table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| TXW_RCLNT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| TXGL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18 | OBJNR | OBN | |||
| RLDNR | Ledger | RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN | H_T881 |
| DOCCT | Document Type | DOCCT | CHAR | 1 | DOCCT | GCT | |||
| RCLNT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| DOCNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| DOCLN | Document line | DOCLN | CHAR | 3 | DOCLN | ||||
| POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
| RYEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| RBUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| RACCT | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
| RBUSA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| RFAREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
| SBUKRS | Company code of partner | PBUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
| SACCT | Cost element of partner | PKSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
| SBUSA | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| SFAREA | Partner Functional Area | SFKBER | CHAR | 16 | Assigned to domain | FKBER | |||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| RTCUR | Currency Key for Amounts in Controlling Area Currency | RACUR | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| TSL | Amount in transaction currency | TXW_TSL | CHAR | 19 | CHAR19 | ||||
| HSL | Amount in local currency | TXW_HSL | CHAR | 19 | CHAR19 | ||||
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR | 16 | BVORG | ||||
| AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
| AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY |
| Key field | Non-key field |
How do I retrieve data from SAP table TXW_S_COFI using ABAP code
The following ABAP code Example will allow you to do a basic selection on TXW_S_COFI to SELECT all data from the tableDATA: WA_TXW_S_COFI TYPE TXW_S_COFI.
SELECT SINGLE *
FROM TXW_S_COFI
INTO CORRESPONDING FIELDS OF WA_TXW_S_COFI
WHERE...
How to access SAP table TXW_S_COFI
Within an ECC or HANA version of SAP you can also view further information about TXW_S_COFI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects