1. Home
  2. Resources
  3. SAP Tables
  4. TWRF2 - Plant Profiles

SAP Table TWRF2

Plant Profiles

TWRF2 (Plant Profiles) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TWRF2 to other SAP tables.

Source: TWRF2 (Plant Profiles)

TWRF2 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BETRP Plant profile BETRP CHAR 4 0
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
CLINT Internal Class Number CLINT NUMC 10 0
REF_WKFIL Reference for plant REF_WKFIL T001W CHAR 4 0
REF_BUKRS Reference Company Code REF_BUKRS T001 CHAR 4 0
REF_VKORG Reference sales organization REF_VKORG TVKO CHAR 4 0
REF_VTWEG Reference distribution channel REF_VTWEG TVTW CHAR 2 0
REF_SPART Division that is used as a reference REF_SPART TSPA CHAR 2 0
KTOKK Vendor account group KTOGK T077K CHAR 4 0
KTOKD Customer account group KTOGD T077D CHAR 4 0
FAUSW Field status bar, plant master for IS-R data FAUSW_077D CHAR 40 0
CLINT_ABTL Internal Class Number CLINT NUMC 10 0
FAUSS Field status definition plant master FAUSS_WRF2 CHAR 40 0
WRKRG Copy rule for plant WRKRG TWRF3 CHAR 2 0
REF_KUNNR Reference for customer (matchcode field) REF_KUNNR CHAR 16 0
REF_LIFNR Reference for vendor (matchcode field) REF_LIFNR CHAR 16 0
REF_BUKRSK Reference Company Code REF_BUKRS T001 CHAR 4 0
REF_EKORG Reference Purchasing Organization REF_EKORG T024E CHAR 4 0
FAUSW_Z1 Field status bar, plant master for IS-R data FAUSW_077D CHAR 40 0
UPD_FLAG Single-Character Indicator CHAR1 CHAR 1 0
ADDR_EXTRACTION Address origin ADDRESS_EXTRACTION CHAR 1 0
NULL Plant
C Customer
V Vendor

TWRF2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TWRF2 KTOKD TWRF2 KTOKD T077D Customer account groups KTOKD
TWRF2 KTOKD TWRF2 MANDT T077D Customer account groups MANDT
TWRF2 KTOKK TWRF2 MANDT T077K Vendor account groups MANDT
TWRF2 KTOKK TWRF2 KTOKK T077K Vendor account groups KTOKK
TWRF2 MANDT TWRF2 MANDT T000 Clients MANDT
TWRF2 REF_BUKRS TWRF2 MANDT T001 Company Codes MANDT
TWRF2 REF_BUKRS TWRF2 REF_BUKRS T001 Company Codes BUKRS
TWRF2 REF_BUKRSK TWRF2 REF_BUKRSK T001 Company Codes BUKRS
TWRF2 REF_BUKRSK TWRF2 MANDT T001 Company Codes MANDT
TWRF2 REF_EKORG TWRF2 MANDT T024E Purchasing Organizations MANDT
TWRF2 REF_EKORG TWRF2 REF_EKORG T024E Purchasing Organizations EKORG
TWRF2 REF_SPART TWRF2 REF_SPART TSPA Organizational Unit: Sales Divisions SPART
TWRF2 REF_SPART TWRF2 MANDT TSPA Organizational Unit: Sales Divisions MANDT
TWRF2 REF_VKORG TWRF2 REF_VKORG TVKO Organizational Unit: Sales Organizations VKORG
TWRF2 REF_VKORG TWRF2 MANDT TVKO Organizational Unit: Sales Organizations MANDT
TWRF2 REF_VTWEG TWRF2 REF_VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
TWRF2 REF_VTWEG TWRF2 MANDT TVTW Organizational Unit: Distribution Channels MANDT
TWRF2 REF_WKFIL TWRF2 REF_WKFIL T001W Plants/Branches WERKS
TWRF2 REF_WKFIL TWRF2 MANDT T001W Plants/Branches MANDT
TWRF2 WRKRG TWRF2 WRKRG TWRF3 Copy rules plant WRKRG
TWRF2 WRKRG TWRF2 MANDT TWRF3 Copy rules plant MANDT