TXW_S_LIPS SAP (Retrieve LIPS from archive) Table details
Dictionary Type: Table
Description: Retrieve LIPS from archive
Description: Retrieve LIPS from archive
Table field list including key, data, relationships and ABAP select examples
TXW_S_LIPS is a standard SAP Table which is used to store Retrieve LIPS from archive data and is available within R/3 SAP systems depending on the version and release level.
The TXW_S_LIPS table consists of various fields, each holding specific information or linking keys about Retrieve LIPS from archive data available in SAP. These include TXW_VBELN (Delivery), TXW_POSNR (Delivery Item), MANDT (Client), VBELN (Delivery).. 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_LIPS 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_MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| TXW_VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
| TXW_POSNR | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
| POSNR | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
| PSTYV | Delivery item category | PSTYV_VL | CHAR | 4 | Assigned to domain | PSTYV | |||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
| FKREL | Relevant for Billing | FKREL | CHAR | 1 | FKREL | ||||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| VGTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| LFIMG | Actual quantity delivered (in sales units) | TXW_LFIMG | CHAR | 16 | CHAR16 | ||||
| LGMNG | Actual quantity delivered (in base units) | TXW_LGMNG | CHAR | 16 | CHAR16 | ||||
| VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| MTART | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
| VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
| KZUMW | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| WAVWR | Cost in document currency | TXW_WAVWR | CHAR | 16 | CHAR16 | ||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
| CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
| MAGRV | Material Group: Packaging Materials | MAGRV | CHAR | 4 | Assigned to domain | MAGRV | |||
| BUKRS | Company code of the sales organization | VKBUK | CHAR | 4 | Assigned to domain | BUKRS |
| Key field | Non-key field |
How do I retrieve data from SAP table TXW_S_LIPS using ABAP code
The following ABAP code Example will allow you to do a basic selection on TXW_S_LIPS to SELECT all data from the tableDATA: WA_TXW_S_LIPS TYPE TXW_S_LIPS.
SELECT SINGLE *
FROM TXW_S_LIPS
INTO CORRESPONDING FIELDS OF WA_TXW_S_LIPS
WHERE...
How to access SAP table TXW_S_LIPS
Within an ECC or HANA version of SAP you can also view further information about TXW_S_LIPS 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