TWRF2 SAP (Plant Profiles) Table details
Dictionary Type: Table
Description: Plant Profiles
Description: Plant Profiles
Table field list including key, data, relationships and ABAP select examples
TWRF2 is a standard SAP Table which is used to store Plant Profiles data and is available within R/3 SAP systems depending on the version and release level.
The TWRF2 table consists of various fields, each holding specific information or linking keys about Plant Profiles data available in SAP. These include BETRP (Plant profile), VLFKZ (Plant category), CLINT (Internal Class Number), REF_WKFIL (Reference for plant).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TWRF2T
SAP TWRF2 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BETRP | Plant profile | BETRP | CHAR | 4 | BETRP | KGP | |||
| VLFKZ | Plant category | VLFKZ | CHAR | 1 | VLFKZ | ||||
| CLINT | Internal Class Number | CLINT | NUMC | 10 | Assigned to domain | CLINT | |||
| REF_WKFIL | Reference for plant | REF_WKFIL | CHAR | 4 | T001W | WERKS | RWK | ||
| REF_BUKRS | Reference Company Code | REF_BUKRS | CHAR | 4 | T001 | BUKRS | RBU | ||
| REF_VKORG | Reference sales organization | REF_VKORG | CHAR | 4 | TVKO | VKORG | RVK | ||
| REF_VTWEG | Reference distribution channel | REF_VTWEG | CHAR | 2 | TVTW | VTWEG | RVT | ||
| REF_SPART | Division that is used as a reference | REF_SPART | CHAR | 2 | TSPA | SPART | RSP | ||
| KTOKK | Vendor account group | KTOGK | CHAR | 4 | T077K | KTOKK | |||
| KTOKD | Customer account group | KTOGD | CHAR | 4 | T077D | KTOKD | KGD | ||
| FAUSW | Field status bar, plant master for IS-R data | FAUSW_077D | CHAR | 40 | FA040 | ||||
| CLINT_ABTL | Internal Class Number | CLINT | NUMC | 10 | Assigned to domain | CLINT | |||
| FAUSS | Field status definition plant master | FAUSS_WRF2 | CHAR | 40 | FA040 | ||||
| WRKRG | Copy rule for plant | WRKRG | CHAR | 2 | TWRF3 | WRKRG | |||
| REF_KUNNR | Reference for customer (matchcode field) | REF_KUNNR | CHAR | 16 | ALPHA | KUN16 | RKN | ||
| REF_LIFNR | Reference for vendor (matchcode field) | REF_LIFNR | CHAR | 16 | ALPHA | LIF16 | RLF | ||
| REF_BUKRSK | Reference Company Code | REF_BUKRS | CHAR | 4 | T001 | BUKRS | RBU | ||
| REF_EKORG | Reference Purchasing Organization | REF_EKORG | CHAR | 4 | T024E | EKORG | REO | ||
| FAUSW_Z1 | Field status bar, plant master for IS-R data | FAUSW_077D | CHAR | 40 | FA040 | ||||
| UPD_FLAG | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| ADDR_EXTRACTION | Address origin | ADDRESS_EXTRACTION | CHAR | 1 | ADDRESS_EXTRACTION |
| Key field | Non-key field |
How do I retrieve data from SAP table TWRF2 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TWRF2 to SELECT all data from the tableDATA: WA_TWRF2 TYPE TWRF2.
SELECT SINGLE *
FROM TWRF2
INTO CORRESPONDING FIELDS OF WA_TWRF2
WHERE...
How to access SAP table TWRF2
Within an ECC or HANA version of SAP you can also view further information about TWRF2 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