TREAT_EXT_ACC SAP (Treasury: External Account General Master Data) Table details

Dictionary Type: Table
Description: Treasury: External Account General Master Data




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




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

TREAT_EXT_ACC is a standard SAP Table which is used to store Treasury: External Account General Master Data data and is available within R/3 SAP systems depending on the version and release level.

The TREAT_EXT_ACC table consists of various fields, each holding specific information or linking keys about Treasury: External Account General Master Data data available in SAP. These include OS_GUID (Globally Unique Identifier), COMPANY_CODE (Company Code), EXT_ACCOUNT (External Account), EXT_ACCOUNT_TYPE (External Account Type).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TREAT_EXT_ACC 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
MANDTClient MANDTCLNT3T000MANDT
OS_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
COMPANY_CODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
EXT_ACCOUNTExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
EXT_ACCOUNT_TYPEExternal Account Type TPM_EXT_ACCOUNT_TYPECHAR3TPM_EXT_ACCOUNT_TYPE
EXT_ACCOUNT_TEXTExternal Account Name TPM_EXT_ACC_TEXTCHAR30TPM_EXT_ACC_TEXT
EXT_ACCOUNT_IDExternal Account ID TPM_EXT_ACC_IDCHAR35CHAR35
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
ATTRIBUTE_SA01Value of the Short Attribute (4 Characters) TPM_ATTR_SHORTCHAR4TRFT_ATTR_STPM_ATTR_SHORT
ATTRIBUTE_SA02Value of the Short Attribute (4 Characters) TPM_ATTR_SHORTCHAR4TRFT_ATTR_STPM_ATTR_SHORT
ATTRIBUTE_SA03Value of the Short Attribute (4 Characters) TPM_ATTR_SHORTCHAR4TRFC_ATTR_STPM_ATTR_SHORT
ATTRIBUTE_SA04Value of the Short Attribute (4 Characters) TPM_ATTR_SHORTCHAR4TRFC_ATTR_STPM_ATTR_SHORT
ATTRIBUTE_MA01Value of the Medim Attribute (10 Characters) TPM_ATTR_MEDIUMCHAR10TRFT_ATTR_MCHAR10
ATTRIBUTE_MA02Value of the Medim Attribute (10 Characters) TPM_ATTR_MEDIUMCHAR10TRFT_ATTR_MCHAR10
ATTRIBUTE_MA03Value of the Medim Attribute (10 Characters) TPM_ATTR_MEDIUMCHAR10TRFC_ATTR_MCHAR10
ATTRIBUTE_MA04Value of the Medim Attribute (10 Characters) TPM_ATTR_MEDIUMCHAR10TRFC_ATTR_MCHAR10
ATTRIBUTE_LA01Value of Long Attribute (20 Characters) TPM_ATTR_LONGCHAR20TRFT_ATTR_LCHAR20
ATTRIBUTE_LA02Value of Long Attribute (20 Characters) TPM_ATTR_LONGCHAR20TRFT_ATTR_LCHAR20
ATTRIBUTE_LA03Value of Long Attribute (20 Characters) TPM_ATTR_LONGCHAR20TRFC_ATTR_LCHAR20
ATTRIBUTE_LA04Value of Long Attribute (20 Characters) TPM_ATTR_LONGCHAR20TRFC_ATTR_LCHAR20
EXTENSION_OIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
EXTENSION_CLSGlobally Unique Identifier OS_GUIDRAW16SYSUUID

Key field Non-key field



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

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

SELECT SINGLE *
FROM TREAT_EXT_ACC
INTO CORRESPONDING FIELDS OF WA_TREAT_EXT_ACC
WHERE...

How to access SAP table TREAT_EXT_ACC

Within an ECC or HANA version of SAP you can also view further information about TREAT_EXT_ACC 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!