SAP SIMAFLDSTEXT IO: Work and Screen Fields: Text Fields Table data and field list

SIMAFLDSTEXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IO: Work and Screen Fields: Text Fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SIMAFLDSTEXT TYPE SIMAFLDSTEXT.

The SIMAFLDSTEXT table consists of various fields, each holding specific information or linking keys about IO: Work and Screen Fields: Text Fields data available in SAP. These include TREASON_DUN (Description of Lock Reason), TREASON_IPAY (Description of Lock Reason), TREASON_OPAY (Description of Lock Reason), TREASON_POST (Description of Lock Reason)... 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. .

SIMAFLDSTEXT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP SIMAFLDSTEXT structure 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 SIMAFLDSTEXT 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
TREASON_DUNDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_IPAYDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_OPAYDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_POSTDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_INTDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_INVDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_CODDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_BRODescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_DUN_PPPDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_PAY_PPPDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_CLR_PPPDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TREASON_INT_PPPDescription of Lock Reason LOCKREASONTEXT_KKCHAR40TEXT40
TINSOBJECTTYPCIO: Text for Category of Insurance Object TINSOBJECTTYP_MDCHAR30TEXT30
TVKTYPDescription of Contract Account Category VKTYP_TXT_KKCHAR50TEXT50
TPARTNERText for business partner GPTXT_KKCHAR55GPTXT_KK
TCPERSText for business partner GPTXT_KKCHAR55GPTXT_KK
TABWRE_NAMEText for business partner GPTXT_KKCHAR55GPTXT_KK
TABWRA_NAMEText for business partner GPTXT_KKCHAR55GPTXT_KK
TBROKERText for business partner GPTXT_KKCHAR55GPTXT_KK
TBROKER_TCText for business partner GPTXT_KKCHAR55GPTXT_KK
COPARTNERTXTText for business partner GPTXT_KKCHAR55GPTXT_KK
TDEF_RECText for business partner GPTXT_KKCHAR55GPTXT_KK
TOPAYPARTNERText for business partner GPTXT_KKCHAR55GPTXT_KK
TGPARVText for business partner GPTXT_KKCHAR55GPTXT_KK
TCB_GPARTText for business partner GPTXT_KKCHAR55GPTXT_KK
TRCL_PARTNERText for business partner GPTXT_KKCHAR55GPTXT_KK
TEMGPAText for business partner GPTXT_KKCHAR55GPTXT_KK
TVGPART2Text for business partner GPTXT_KKCHAR55GPTXT_KK
TVGPART3Text for business partner GPTXT_KKCHAR55GPTXT_KK
TALTBROKText for business partner GPTXT_KKCHAR55GPTXT_KK
TALTBRCOIO: Name of an Insurance Object INSOBEZ_MDCHAR35INSOBEZ_MD
TADRNRBP: Address Description BU_ADDSCCHAR60TEXT60
TABWRE_ADRBP: Address Description BU_ADDSCCHAR60TEXT60
TABWRA_ADRBP: Address Description BU_ADDSCCHAR60TEXT60
TOPAY_ADRBP: Address Description BU_ADDSCCHAR60TEXT60
TEMGPA_ADRBP: Address Description BU_ADDSCCHAR60TEXT60
TPARAM_ACTIVText (80 Characters) TEXT80CHAR80TEXT80UEB
TPARAM_INACTIVText (80 Characters) TEXT80CHAR80TEXT80UEB
TCPARAM_ACTIVText (80 Characters) TEXT80CHAR80TEXT80UEB
TCPARAM_INACTIVText (80 Characters) TEXT80CHAR80TEXT80UEB
TPYMETName of Payment Method in Language of the Country TEXT1_042ZCHAR30TEXT30
TEZAWEName of Payment Method in Language of the Country TEXT1_042ZCHAR30TEXT30
TAZAWEFS-CD: Meaning of Outgoing Payt Methods in Country Language TEXT_AZAWE_MDCHAR160
TEBVTYText For Bank Details ID BVTYT_KKCHAR140TEXT140
TABVTYText For Bank Details ID BVTYT_KKCHAR140TEXT140
TOPAYABVTYText For Bank Details ID BVTYT_KKCHAR140TEXT140
TEMBVTText For Bank Details ID BVTYT_KKCHAR140TEXT140
TCCARDINText for credit card ID CCARD_TXT_KKCHAR140TEXT140
TCCARDOUTText for credit card ID CCARD_TXT_KKCHAR140TEXT140
TOPAYCCARDOUTText for credit card ID CCARD_TXT_KKCHAR140TEXT140
TEMCCIDText for credit card ID CCARD_TXT_KKCHAR140TEXT140
TQSSKZ_EDescription of Withholding Tax Code QSBEZCHAR40TEXT40
TQSSKZ_ADescription of Withholding Tax Code QSBEZCHAR40TEXT40
COTXTName of Correspondence Type COTXT_KKCHAR40TEXT40
COACTTXTName of Correspondence Activity CORR_ATEXT_KKCHAR60TEXT60
TDEF_REC_INDName of Correspondence Activity CORR_ATEXT_KKCHAR60TEXT60
TATARTDescription of Splitting Type ATTXT_KKCHAR60TEXT60
TENDTYPEShort Text for Fixed Values VAL_TEXTCHAR60DDTEXT
TBLARTDocument Type Description LTEXT_003TCHAR20TEXT20
TCCODEName of Company Code or Company BUTXTCHAR25TEXT25
TOPCCODEName of Company Code or Company BUTXTCHAR25TEXT25
TGSBERBusiness area description GTEXTCHAR30TEXT30
TOPGSBERBusiness area description GTEXTCHAR30TEXT30
THVORGName of Main Transaction HVORG_TXTCHAR30TEXT30
TOPHVORGName of Main Transaction HVORG_TXTCHAR30TEXT30
TTVORGName of Subtransaction TVORG_TXTCHAR30TEXT30
TOPTVORGName of Subtransaction TVORG_TXTCHAR30TEXT30
TH_HKONTG/L account short text TXT20_SKATCHAR20TEXT20
TS_HKONTG/L account short text TXT20_SKATCHAR20TEXT20
TCOINS_CODECoinsurance Key Description REPID_TEXT_VKCHAR40REPID_TEXT_VK
TCOINS_CATShort Text for Fixed Values VAL_TEXTCHAR60DDTEXT
TPRGRPDescription of Product Group (Line of Business) PRGRX_VKCHAR50TXTF5_VK
TVSARL_VXLong text BEZEL_VXCHAR50TXTF5_VX
TAUGRPDescription BU_BEZ50CHAR50TEXT50
TQSSEWText TXT30CHAR30TEXT30
T1099Form and Field Name for 1099 Reporting T1099_KKCHAR40TEXT40
TPROC_CODEDescription of Web Broker Type BROKREP_PROC_CODET_BROCHAR30BROKREP_PROC_CODET_BRO
TLDGRPText Field TEXT50CHAR50TEXT50
TMWSKZName for value-added tax TEXT1_007SCHAR50TEXT50
TQSSKZDescription of Withholding Tax Code QSBEZCHAR40TEXT40
TSTRKZFree Tax Code (Text) STRKZ_TXT_KKCHAR50TXT50
TINSTAXSInsurance Tax Schedule INSTAXS_TXT_VKCHAR50TXT50
MNDID_TXTShort Description of a SEPA Mandate MANDAT_DESCR_KKCHAR50TXT50
TORIGFIKRSName of FM area FITXTCHAR25TEXT25
TFMTYPShort Text for Fixed Values VAL_TEXTCHAR60DDTEXT
TFIPEXText (20 Characters) TEXT20CHAR20TEXT20
TFISTLText (20 Characters) TEXT20CHAR20TEXT20
TFONDSText (20 Characters) TEXT20CHAR20TEXT20
TFKBERName of the functional area FKBTXCHAR25TEXT25
TGRANT_NBRText (20 Characters) TEXT20CHAR20TEXT20
TBUDGET_PDFM: Budget Period Name FM_BUDGET_PERIOD_NAMECHAR35NAME

Key field Non-key field



How do I retrieve data from SAP structure SIMAFLDSTEXT using ABAP code?

As SIMAFLDSTEXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SIMAFLDSTEXT as there is no data to select.

How to access SAP table SIMAFLDSTEXT

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

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