TWRF2

Transparent Table Customizing Table
27 Fields 1 CDS Views

Plant Profiles

TWRF2 is an SAP database table in S/4HANA. Plant Profiles. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SiteProfile view from BASIC CDS view for Site Profile

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY betrp BETRP Plant profile
vlfkz VLFKZ Plant Cat.
clint CLINT Int class no.
ref_wkfil REF_WKFIL Plant
ref_bukrs REF_BUKRS Company Code
ref_vkorg REF_VKORG Sales organiz.
ref_vtweg REF_VTWEG Distr. channel
ref_spart REF_SPART Division
ktokk abap.char
ktokd abap.char
fausw FAUSW_077D FieldStat.plant
clint_abtl CLINT Int class no.
fauss FAUSS_WRF2 FieldStat.plant
wrkrg WRKRG Copy rule
ref_kunnr abap.char
ref_lifnr abap.char
ref_bukrsk REF_BUKRS Company Code
ref_ekorg REF_EKORG Purchasing Org.
fausw_z1 FAUSW_077D FieldStat.plant
upd_flag CHAR1 Single-Character Flag
addr_extraction ADDRESS_EXTRACTION Address origin
manufacturing PRODUCING Producing
bp_grp_site BP_GRP_SITE BP Grouping
site_with_bp_grp_suppl SITE_WITH_BP_GRP_SUPPL With Supp.
ref_bp REF_BP Business Partner
rltgr BP_RLGROUP_SITE Role Grouping

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Plant Profiles
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWRF2 (
    MANDT,                   -- Client [MANDT]
    BETRP,                   -- Plant profile [BETRP]
    VLFKZ,                   -- Plant Cat. [VLFKZ]
    CLINT,                   -- Int class no. [CLINT]
    REF_WKFIL,               -- Plant [REF_WKFIL]
    REF_BUKRS,               -- Company Code [REF_BUKRS]
    REF_VKORG,               -- Sales organiz. [REF_VKORG]
    REF_VTWEG,               -- Distr. channel [REF_VTWEG]
    REF_SPART,               -- Division [REF_SPART]
    KTOKK,                   -- abap.char
    KTOKD,                   -- abap.char
    FAUSW,                   -- FieldStat.plant [FAUSW_077D]
    CLINT_ABTL,              -- Int class no. [CLINT]
    FAUSS,                   -- FieldStat.plant [FAUSS_WRF2]
    WRKRG,                   -- Copy rule [WRKRG]
    REF_KUNNR,               -- abap.char
    REF_LIFNR,               -- abap.char
    REF_BUKRSK,              -- Company Code [REF_BUKRS]
    REF_EKORG,               -- Purchasing Org. [REF_EKORG]
    FAUSW_Z1,                -- FieldStat.plant [FAUSW_077D]
    UPD_FLAG,                -- Single-Character Flag [CHAR1]
    ADDR_EXTRACTION,         -- Address origin [ADDRESS_EXTRACTION]
    MANUFACTURING,           -- Producing [PRODUCING]
    BP_GRP_SITE,             -- BP Grouping [BP_GRP_SITE]
    SITE_WITH_BP_GRP_SUPPL,  -- With Supp. [SITE_WITH_BP_GRP_SUPPL]
    REF_BP,                  -- Business Partner [REF_BP]
    RLTGR,                   -- Role Grouping [BP_RLGROUP_SITE]
    PRIMARY KEY (MANDT, BETRP)
);

Learn More