TCN41

Transparent Table Customizing Table
78 Fields 1 CDS Views

Network Defaults

TCN41 is an SAP database table in S/4HANA. Network Defaults. It contains 78 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_NetworkProfile view from BASIC Network Profile Details

Fields (78)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnaw PLNAW Application
KEY profidnetz PROFIDNZPL Network Profile
flg_erf_h FLG_ERF_H Entry tool
esokz ESOKZ Infotype
ekorg EKORG Purchasing Org.
kstar_frmd KSTAR_FRMD Cost element
steus_work STEUS_WORK Control key
steus_frmd STEUS_FRMD Control key
steus_prim STEUS_PRIM Control key
kstar_cost KSTAR_COST Cost element
kstar_serv KSTAR_SERV Cost element
steus_serv STEUS_SERV Control key
daune DAUNORE Norm.duratn un.
arbeh ARBEITE Unit for work
waers WAERS Currency
slwid SLWID Field key
lvari LVARI Overview var.
indet INDET Calculation key
bukrs BUKRS Company Code
aob_key AOB_KEY Rel. view
vornr_del DEL_VORNR Op./act. incrmt
terkz TERMKZ Scheduling type
auart AUFART Order Type
werks WERKS_D Plant
dispo CO_DISPO MRP controller
rschl_ofer RSCHL_OFEA Internal act.
rschl_ofrd RSCHL_OFRA Ext. proc. act.
rschl_ufer RSCHL_UFEA Int. act. elem.
rschl_ufrd RSCHL_UFRA Ext. act. elem.
rschl_ocst RSCHL_OCSA Gen costs act.
rschl_ucst RSCHL_UCSA Gen. costs act.
gr_prf_gr NETPRFGRUP Group
gr_prf_nam NETPRFNAME Name
fhori FHORI Margin Key
netstufe NETSTUFE Level of detail
vagrp VAGRP Planner Group
msgty PS_MSGTY Check. WBS act.
aob_darst AOB_DARST Rel. display
vrg_darst ACT_DARST Display options
no_disp NO_DISP_PLUS Eff. mat. plng
colkz_elem COLKZ_ELEM Color for elem.
colkz_teil COLKZ_TEIL Color-Subnetwk.
colkz_mlst COLKZ_MLST Color milestone
colkz_doku COLKZ_DOKU Color for doc.s
colkz_mat COLKZ_MAT Color for mat.
vsprf VER_PROFIL Prof.
clasf CLASF Summarization
profile_id CY_GESPROF Overall profile
balk_prof BPPROFILE Plan.board prf
kbed KBED_D No Cap. Reqmts.
kkalkr COMP_CALC CostCompInd
lstvar CNL_LSTVAR Overview var.
matkl MATKL Material Group
matexit MATEXIT User exit-mat.
ekgrp EKGRP Purch. Group
matkl_frmd MATKL Material Group
ekgrp_frmd EKGRP Purch. Group
posnr_mat POSNR_MAT Comp. increment
sched_end SCHED_END Align.Fin. Date
scend_act SCEND_ACT Purch.Req. fin.
nt_search1 CN_SEARCH1 SearchTxtIndex1
nt_search2 CN_SEARCH2 SearchTxtIndex2
nt_search3 CN_SEARCH3 SearchTxtIndex3
mflic CN_MFLIC Procurement
meinh_frmd MEINH_FRMD Order unit
meinh_serv MEINH_SERV Unit of measure
kstar_matvorpl KSTAR_MATVORPL Mat.cost elem.
kzerb PS_KZERB Proj. summ. MastDa
valid VALID Validation
valid_vg VALID Validation
subst SUBST_ID Substitution
subst_vg SUBST_ID Substitution
fpart FPART BillingPlanType
ipps PS_IPPS iPPE Proj. Rel.
template_key KTSCH Std Text Key
psacl PS_ACL_DELE ACL (No Inhr.)
psaclh PS_ACLH_DELE ACL (With Inh.)

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.

-- Network Defaults
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCN41 (
    MANDT,           -- Client [MANDT]
    PLNAW,           -- Application [PLNAW]
    PROFIDNETZ,      -- Network Profile [PROFIDNZPL]
    FLG_ERF_H,       -- Entry tool [FLG_ERF_H]
    ESOKZ,           -- Infotype [ESOKZ]
    EKORG,           -- Purchasing Org. [EKORG]
    KSTAR_FRMD,      -- Cost element [KSTAR_FRMD]
    STEUS_WORK,      -- Control key [STEUS_WORK]
    STEUS_FRMD,      -- Control key [STEUS_FRMD]
    STEUS_PRIM,      -- Control key [STEUS_PRIM]
    KSTAR_COST,      -- Cost element [KSTAR_COST]
    KSTAR_SERV,      -- Cost element [KSTAR_SERV]
    STEUS_SERV,      -- Control key [STEUS_SERV]
    DAUNE,           -- Norm.duratn un. [DAUNORE]
    ARBEH,           -- Unit for work [ARBEITE]
    WAERS,           -- Currency [WAERS]
    SLWID,           -- Field key [SLWID]
    LVARI,           -- Overview var. [LVARI]
    INDET,           -- Calculation key [INDET]
    BUKRS,           -- Company Code [BUKRS]
    AOB_KEY,         -- Rel. view [AOB_KEY]
    VORNR_DEL,       -- Op./act. incrmt [DEL_VORNR]
    TERKZ,           -- Scheduling type [TERMKZ]
    AUART,           -- Order Type [AUFART]
    WERKS,           -- Plant [WERKS_D]
    DISPO,           -- MRP controller [CO_DISPO]
    RSCHL_OFER,      -- Internal act. [RSCHL_OFEA]
    RSCHL_OFRD,      -- Ext. proc. act. [RSCHL_OFRA]
    RSCHL_UFER,      -- Int. act. elem. [RSCHL_UFEA]
    RSCHL_UFRD,      -- Ext. act. elem. [RSCHL_UFRA]
    RSCHL_OCST,      -- Gen costs act. [RSCHL_OCSA]
    RSCHL_UCST,      -- Gen. costs act. [RSCHL_UCSA]
    GR_PRF_GR,       -- Group [NETPRFGRUP]
    GR_PRF_NAM,      -- Name [NETPRFNAME]
    FHORI,           -- Margin Key [FHORI]
    NETSTUFE,        -- Level of detail [NETSTUFE]
    VAGRP,           -- Planner Group [VAGRP]
    MSGTY,           -- Check. WBS act. [PS_MSGTY]
    AOB_DARST,       -- Rel. display [AOB_DARST]
    VRG_DARST,       -- Display options [ACT_DARST]
    NO_DISP,         -- Eff. mat. plng [NO_DISP_PLUS]
    COLKZ_ELEM,      -- Color for elem. [COLKZ_ELEM]
    COLKZ_TEIL,      -- Color-Subnetwk. [COLKZ_TEIL]
    COLKZ_MLST,      -- Color milestone [COLKZ_MLST]
    COLKZ_DOKU,      -- Color for doc.s [COLKZ_DOKU]
    COLKZ_MAT,       -- Color for mat. [COLKZ_MAT]
    VSPRF,           -- Prof. [VER_PROFIL]
    CLASF,           -- Summarization [CLASF]
    PROFILE_ID,      -- Overall profile [CY_GESPROF]
    BALK_PROF,       -- Plan.board prf [BPPROFILE]
    KBED,            -- No Cap. Reqmts. [KBED_D]
    KKALKR,          -- CostCompInd [COMP_CALC]
    LSTVAR,          -- Overview var. [CNL_LSTVAR]
    MATKL,           -- Material Group [MATKL]
    MATEXIT,         -- User exit-mat. [MATEXIT]
    EKGRP,           -- Purch. Group [EKGRP]
    MATKL_FRMD,      -- Material Group [MATKL]
    EKGRP_FRMD,      -- Purch. Group [EKGRP]
    POSNR_MAT,       -- Comp. increment [POSNR_MAT]
    SCHED_END,       -- Align.Fin. Date [SCHED_END]
    SCEND_ACT,       -- Purch.Req. fin. [SCEND_ACT]
    NT_SEARCH1,      -- SearchTxtIndex1 [CN_SEARCH1]
    NT_SEARCH2,      -- SearchTxtIndex2 [CN_SEARCH2]
    NT_SEARCH3,      -- SearchTxtIndex3 [CN_SEARCH3]
    MFLIC,           -- Procurement [CN_MFLIC]
    MEINH_FRMD,      -- Order unit [MEINH_FRMD]
    MEINH_SERV,      -- Unit of measure [MEINH_SERV]
    KSTAR_MATVORPL,  -- Mat.cost elem. [KSTAR_MATVORPL]
    KZERB,           -- Proj. summ. MastDa [PS_KZERB]
    VALID,           -- Validation [VALID]
    VALID_VG,        -- Validation [VALID]
    SUBST,           -- Substitution [SUBST_ID]
    SUBST_VG,        -- Substitution [SUBST_ID]
    FPART,           -- BillingPlanType [FPART]
    IPPS,            -- iPPE Proj. Rel. [PS_IPPS]
    TEMPLATE_KEY,    -- Std Text Key [KTSCH]
    PSACL,           -- ACL (No Inhr.) [PS_ACL_DELE]
    PSACLH,          -- ACL (With Inh.) [PS_ACLH_DELE]
    PRIMARY KEY (MANDT, PLNAW, PROFIDNETZ)
);

Learn More