SAP TCA41 Default values for standard networks and profiles Table data and field list

TCA41 is a standard SAP Table which is used to store Default values for standard networks and profiles data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TCA41 table consists of various fields, each holding specific information or linking keys about Default values for standard networks and profiles data available in SAP. These include PLNAW (Application of the task list), PROFIDNETZ (Profile), FLG_ERF_H (Activate/deactivate entry tool), ESOKZ (Purchasing info record category)... 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. .

TCA41 table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TCA4T


SAP TCA41 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TCA41 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PLNAWApplication of the task list PLNAWCHAR1TCA09PLNAW
PROFIDNETZProfile PROFID_STDCHAR7PROFIDPIN
FLG_ERF_HActivate/deactivate entry tool FLG_ERF_HCHAR1FLAG
ESOKZPurchasing info record category ESOKZCHAR1ESOKZESO
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
KSTAR_FRMDCost element for external processing KSTAR_FRMDCHAR10CSKAALPHAKSTAR
STEUS_WORKControl key for internal activities STEUS_WORKCHAR4T430STEUS
STEUS_FRMDControl key for external services STEUS_FRMDCHAR4T430STEUS
STEUS_PRIMControl key for costs STEUS_PRIMCHAR4T430STEUS
KSTAR_COSTCost element for general costs activities KSTAR_COSTCHAR10CSKAALPHAKSTAR
DAUNENormal duration/unit DAUNOREUNIT3T006CUNITMEINS
ARBEHUnit for work ARBEITEUNIT3T006CUNITMEINS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
SLWIDKey word ID for user-defined fields SLWIDCHAR7TCN00SLWID
LVARIVariant of an object overview LVARICHAR2TCA14LVARI
INDETKey for calculation INDETCHAR1INDET
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
AOB_KEYKey: View of relationships AOB_KEYCHAR1AOB_KEY
VORNR_DELIncrement for automatic operation/activity numbering DEL_VORNRCHAR4NUMCVVORNR
WERKSPredefined plant VOR_WERKCHAR4T001WWERKS
NETSTUFELevel of detail for (standard) networks NETSTUFENUMC2NETSTUFE
PLNMETask list unit of measure PLNMEUNIT3T006CUNITMEINS
VERWETask list usage PLN_VERWECHAR3T411PLN_VERWEH_T411
STATUStatus PLNSTCHAR3T412PLNSTH_T412
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
ZERMAType of standard value calculation DZERMACHAR5T429ZERMA
ESKOZPurchasing info record category ESOKZCHAR1ESOKZESO
BMSCHBase Quantity BMSCHQUAN13(3) BMSCH
STEUSControl key STEUSCHAR4T430STEUS
QMKDELTAIncrement for Insp. Characteristic Number in Inspection Plan QINKR_MKNUMC4QMERKNRP
QMWDELTAIncrement for Assignment Number in Inspection Plan QINKR_MWNUMC4QZUORDNR
QMKEFInsert Increment for Characteristic Number in Insp. Plan QINKR_MKEFNUMC4QMERKNRP
QMWEFInsert Increment for Allocation Number in Inspection Plan QINKR_MWEFNUMC4QZUORDNR
QPROBEMGEHSample Unit of Measure QPROBMEUNIT3T006CUNITMEINS
QPRUEFEINHSample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAKDEC5(2) QPROBEFAK
CF_PSNINCItem number increment for production resources/tools CF_PSNINCNUMC4PSNFH
RSCHL_OFERSequence key for internal operations or activities RSCHL_OFERCHAR6TCA60CIM_RSCHL
RSCHL_OFRDSequence key for external operations or activities RSCHL_OFRDCHAR6TCA60CIM_RSCHL
RSCHL_UFERSequence key for internal sub-operations or elements RSCHL_UFERCHAR6TCA60CIM_RSCHL
RSCHL_UFRDSequence key for external sub-operations or elements RSCHL_UFRDCHAR6TCA60CIM_RSCHL
GRPRF_GRUPProfile group (sort graphics profiles) NETPRFGRUPCHAR4TCNGNETPRFGRUPNHG
GRPRF_NAMEName of graphic profile in Network/Hierarchy Graphics NETPRFNAMECHAR12CHAR12NHN
RSCHL_UCSTActivity element sequence key for general costs activities RSCHL_UCSTCHAR6TCA60CIM_RSCHL
RSCHL_OCSTActivity sequence key for general costs activities RSCHL_OCSTCHAR6TCA60CIM_RSCHL
LVARI_TERMObject overview variants for scheduling CP_LVARI_TCHAR2TCA14LVARI
FTNR_INCIncrement for automatic process instruction numbering FTNR_INCCHAR4NUMCVVORNR
FVNR_INCIncrement for automatic PI characteristic numbering FVNR_INCCHAR4NUMCVVORNR
AOB_DARSTRelationship display AOB_DARSTCHAR1AOB_DARST
VRG_DARSTOperation display in graphic VRG_DARSTCHAR1VRG_DARST
PHS_DARSTDisplay of phase in graphics PHS_DARSTCHAR1PHS_DARST
KSTAR_SERVCost element for services KSTAR_SERVCHAR10CSKAALPHAKSTAR
STEUS_SERVControl key for services STEUS_SERVCHAR4T430STEUS
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
LSTVARVariable overviews: Overview variant CNL_LSTVARCHAR12TCNVLCNL_LSTVAR
LSTVAR_TObject overview variant for scheduling CP_LSTVARCHAR12TCNVLCNL_LSTVAR
EKGRPPurchasing group for external processing VG_EKGRPCHAR3T024EKGRP
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
NT_SEARCH1Number of the first text used for the search. CN_SEARCH1CHAR2VCTCENTRY
NT_SEARCH2Number of the second text used for the search. CN_SEARCH2CHAR2VCTCENTRY
NT_SEARCH3Number of the third text used for the search. CN_SEARCH3CHAR2VCTCENTRY
CHRULEChange rule R_CHRULECHAR1R_CHRULE
CCOAAChange Type for Object CCOAANUMC3TCC13CCOAA
VGWTSStandard value key VORGSCHLCHAR4TC21VORGSCHL
PRESType of Process Instruction Maintenance PRESCHAR1CPS_PRESCHAR1

Key field Non-key field



How do I retrieve data from SAP table TCA41 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TCA41 to SELECT all data from the table
DATA: WA_TCA41 TYPE TCA41.

SELECT SINGLE *
FROM TCA41
INTO CORRESPONDING FIELDS OF WA_TCA41
WHERE...

How to access SAP table TCA41

Within an ECC or HANA version of SAP you can also view further information about TCA41 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).