TF90S SAP (Basis Field Catalog Consolidation (Fixed Fields)) Table details

Dictionary Type: Table
Description: Basis Field Catalog Consolidation (Fixed Fields)




ABAP Code to SELECT data from TF90S
Related tables to TF90S
Access table TF90S




Table field list including key, data, relationships and ABAP select examples

TF90S is a standard SAP Table which is used to store Basis Field Catalog Consolidation (Fixed Fields) data and is available within R/3 SAP systems depending on the version and release level.

The TF90S table consists of various fields, each holding specific information or linking keys about Basis Field Catalog Consolidation (Fixed Fields) data available in SAP. These include USGFL (Use flag), ROLNM (Data element (semantic domain)), TIMFL (Flag: Field with time dimension), CHTAB (Check table).. 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. .

Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
FIENMField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
USGFLUse flag CGSUSGFLCHAR1USGFL
ROLNMData element (semantic domain) ROLLNAMECHAR30Assigned to domainROLLNAMEROLDD_DTEL
TIMFLFlag: Field with time dimension CGSTIMFLCHAR1XFELD
CHTABCheck table CGSCHTABCHAR30TABNAME
CHFIECheck table field CGSCHFIECHAR30Assigned to domainFDNAME
VALEXFlag: Domain values CGSVALEXCHAR1XFELD
FIXVLConstant (value of characteristic) CGSFIXVLCHAR18CHAR18
TIMLCTime logic CGSTIMLCCHAR1CGSTIMLC
RETABRead (text) table CGSRETABCHAR30TABNAME
REFIERead (text) field CGSREFIECHAR30Assigned to domainFDNAME
REFILLong Text Field CGSREFILCHAR30Assigned to domainFDNAME
REFLLLength of long text field CGSREFLLNUMC6DDLENG
VIEWNView name CGSVIEWNCHAR30Assigned to domainVIEWNAMEDVI
TCDISTransaction Code: Display Characteristic Values CGSTCDISCHAR20Assigned to domainTCODE
TCMODTransaction Code: Change Characteristic Values CGSTCMODCHAR20Assigned to domainTCODE
ATRFBFunction Module for Reading Attributes CGDATRFBCHAR30Assigned to domainFUNCNAME
SPCTRSpecial handling of fields of an operating concern RKE_SHANDLINGCHAR3RKE_SHANDLING
ORTABOrigin Table CGSORTABCHAR30TABNAME
ORFIEOrigin field CGSORFIECHAR30Assigned to domainFDNAME
OAPPLSource application CGSOAPPLCHAR4Assigned to domainCFAPPLCLAS
OAFIEOriginal field (of the application) CGSOAFIECHAR30Assigned to domainFDNAME
DIMPRCharacteristic Display CGSDIMPRCHAR1DIMPR
REPINReport Indicator CGSREPINCHAR1BERKZ
PLAINPlanning Indicator CGSPLAINCHAR1RKE_PLAKZ
LITINLine Item Indicator CGSLITINCHAR1RKE_EPOSKZ
RCSINRow/Column Structure Indicator CGSRCSINCHAR1RKE_ZSPKZ
RSLINReport Selection Indicator CGSRSLINCHAR1RKE_MKAKZ
CHAINCharacteristic Value Indicator CGSCHAINCHAR1RKE_MKEKZ
AGGDIAggregation CGSAGGDICHAR3AGGDI
AGGTMAggregation based on time CGSAGGTMCHAR3AGGTM
AGGFIReference Field for Time-Based Aggregation CGSAGGFICHAR30Assigned to domainFDNAME
PRDECDecimal Places (Output) CGSDECCHAR1CHAR1
PRSNTScaling factor CGSPRSCHAR1CHAR1
SBGRPKey figure groups CGSSBGRPCHAR3Assigned to domainCGSSBGRPSBG
CCNUMCurrency Translation Number CGSCCNUMNUMC3NUM3
DCURRTarget Currency CGSDCURRCUKY5Assigned to domainWAERS
RFTABTable for reference field REFTABLECHAR30Assigned to domainAS4TAB
RFFIEReference field for currency and qty fields REFFIELDCHAR30Assigned to domainFDNAME
DSRFFReference field in the data structure CGSDSRFFCHAR30Assigned to domainFDNAME
CQMRKQuantity/amount/number indicator CGSCQMRKCHAR1CQMRK
CUKY0Currency CGSCUKYCUKY5Assigned to domainWAERS
UNIT0Unit CGSUNITUNIT3Assigned to domainCUNITMEINS
CQFIEReference field for currency / unit CGSCQFIECHAR30Assigned to domainFDNAME
TFLAGFlag: Text CGSTFLAGCHAR1CHAR1
COBJIDFolder Entry ID (Obj+Fol+Forwarder Name) SO_ENTRYIDCHAR46SO_ENTRYID
DMACMatchcode CGSDMACCHAR31DMAC_____4
CHNAMUser CGSCHNAMCHAR12CHAR12
CHDATChanged On CGSCHDATDATS8AS4DATE
CHTIMTime of Change CGSCHTIMTIMS6AS4TIME
CS_SEQNRSequence number FC_SEQNR3NUMC3NUMC3
CS_TOTALSSubassignment FC_ECMC_FLGCHAR1CHAR1_XFC_ECMC
CS_ITGRPFIXChar. w/fixed value in breakdown cat (SIcat-like char.) FC_ITGRPFIX_FLGCHAR1CHAR1_XFC_ITGRP
CS_DEFAULTDefault value FC_DEFLT_FLGCHAR1CHAR1_X
CS_GENFLGGeneral indicator, SAP Consolidation FC_FLGCHAR1CHAR1

Key field Non-key field



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

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

SELECT SINGLE *
FROM TF90S
INTO CORRESPONDING FIELDS OF WA_TF90S
WHERE...

How to access SAP table TF90S

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!