SAP table TWRF2 (Plant Profiles)

SAP table TWRF2 has 2 primary key fields being MANDT,BETRP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BETRP Plant profile CHAR 4 0 BETRP
VLFKZ Plant category CHAR 1 0 VLFKZ
A Store
B Distribution Center
CLINT Internal Class Number NUMC 10 0 CLINT
REF_WKFIL Reference for plant CHAR 4 0 T001W REF_WKFIL
REF_BUKRS Reference Company Code CHAR 4 0 T001 REF_BUKRS
REF_VKORG Reference sales organization CHAR 4 0 TVKO REF_VKORG
REF_VTWEG Reference distribution channel CHAR 2 0 TVTW REF_VTWEG
REF_SPART Division that is used as a reference CHAR 2 0 TSPA REF_SPART
KTOKK CHAR 4 0
KTOKD CHAR 4 0
FAUSW Field status bar, plant master for IS-R data CHAR 40 0 FAUSW_077D
CLINT_ABTL Internal Class Number NUMC 10 0 CLINT
FAUSS Field status definition plant master CHAR 40 0 FAUSS_WRF2
WRKRG Copy rule for plant CHAR 2 0 TWRF3 WRKRG
REF_KUNNR CHAR 16 0
REF_LIFNR CHAR 16 0
REF_BUKRSK Reference Company Code CHAR 4 0 T001 REF_BUKRS
REF_EKORG Reference Purchasing Organization CHAR 4 0 T024E REF_EKORG
FAUSW_Z1 Field status bar, plant master for IS-R data CHAR 40 0 FAUSW_077D
UPD_FLAG Single-Character Flag CHAR 1 0 CHAR1
ADDR_EXTRACTION -obsolete- CHAR 1 0 ADDRESS_EXTRACTION
Plant
B Business Partner
MANUFACTURING Producing CHAR 1 0 PRODUCING
No
X Yes
BP_GRP_SITE Business Partner Grouping for Plant Maintenance CHAR 4 0 TB001 BP_GRP_SITE
SITE_WITH_BP_GRP_SUPPL Creation of Plant with Supplier CHAR 1 0 SITE_WITH_BP_GRP_SUPPL
REF_BP Reference for Business Partner CHAR 10 0 BUT000 REF_BP
RLTGR BP Role Grouping CHAR 6 0 TB003G BP_RLGROUP_SITE

TWRF2 foreign key relationships

Table Field Check Table Check Field
0 TWRF2 BP_GRP_SITE TB001 BP groupings MANDT
0 TWRF2 BP_GRP_SITE TB001 BP groupings BU_GROUP
1 TWRF2 REF_BP BUT000 BP: General data I PARTNER
0 TWRF2 REF_BUKRS T001 Company Codes BUKRS
1 TWRF2 REF_BUKRSK T001 Company Codes BUKRS
0 TWRF2 REF_EKORG T024E Purchasing Organizations EKORG
1 TWRF2 REF_SPART TSPA Organizational Unit: Sales Divisions MANDT
1 TWRF2 REF_SPART TSPA Organizational Unit: Sales Divisions SPART
0 TWRF2 REF_VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 TWRF2 REF_VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 TWRF2 REF_VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 TWRF2 REF_VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 TWRF2 REF_WKFIL T001W Plants/Branches MANDT
0 TWRF2 REF_WKFIL T001W Plants/Branches WERKS
1 TWRF2 RLTGR TB003G BP Role Groupings RLTGR
0 TWRF2 WRKRG TWRF3 Copy rules plant MANDT
0 TWRF2 WRKRG TWRF3 Copy rules plant WRKRG