TREAT_SUMMARY SAP (Treasury: Summary Statement) Table details
Dictionary Type: Table
Description: Treasury: Summary Statement
Description: Treasury: Summary Statement
ABAP Code to SELECT data from TREAT_SUMMARY
Related tables to TREAT_SUMMARY
Access table TREAT_SUMMARY
Related tables to TREAT_SUMMARY
Access table TREAT_SUMMARY
Table field list including key, data, relationships and ABAP select examples
TREAT_SUMMARY is a standard SAP Table which is used to store Treasury: Summary Statement data and is available within R/3 SAP systems depending on the version and release level.
The TREAT_SUMMARY table consists of various fields, each holding specific information or linking keys about Treasury: Summary Statement data available in SAP. These include STATEMENT_OID (Globally Unique Identifier), COMPANY_CODE (Company Code), EXT_ACCOUNT (External Account), STATEMENT_DATE (Statement Date).. 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_SUMMARY 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 |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| STATEMENT_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
| COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| EXT_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
| STATEMENT_DATE | Statement Date | TPM_DATE | DATS | 8 | TPM_DATE | ||||
| IM_AMT_BEFORE | Initial Margin Amount on Previous Day | TPM_TREA_IM_AMT_BEFORE | CURR | 21(2) | TPM_AMOUNT | ||||
| IM_AMT_CURR_BEFO | Currency of Initial Margin Amount on Previous Day | TPM_TREA_IM_AMT_CURR_BEFORE | CUKY | 5 | Assigned to domain | WAERS | |||
| IM_AMT | Current Initial Margin Amount | TPM_TREA_IM_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
| IM_AMT_CURR | Currency of Current Initial Margin Amount | TPM_TREA_IM_AMT_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| VM_AMT_BEFORE | Previous Net Present Value (TREA) | TPM_TREA_VAR_MARGIN_PREVIOUS | CURR | 21(2) | TPM_AMOUNT | ||||
| VM_AMT_CURR_BEFO | Currency of Variation Margin Amount on Previous Day | TPM_TREA_VM_AMT_CURR_BEFORE | CUKY | 5 | Assigned to domain | WAERS | |||
| VM_AMT_EXT | External Variation Margin Amount | TPM_TREA_VM_EXT_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
| VM_AMT_CURR_EXT | Currency of External Variation Margin Amount | TPM_TREA_VM_EXT_AMT_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| DELTA_IM_AMT | Initial Margin Delta Value | TPM_TREA_DELTA_IM | CURR | 21(2) | TPM_AMOUNT | ||||
| DELTA_IM_AMT_CUR | Currency of Delta IM | TPM_TREA_DELTA_IM_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| DELTA_VM_AMT | Variation Margin Delta Value | TPM_TREA_DELTA_VM | CURR | 21(2) | TPM_AMOUNT | ||||
| DELTA_VM_AMT_CUR | Currency of Variation Margin Delta Value | TPM_TREA_DELTA_VM_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| IM_EXCHANGE_RATE | Exchange Rate for Initial Margin | TPM_IM_EXCHANGE_RATE | DEC | 9(5) | EXCRT | UKURS | |||
| VM_EXCHANGE_RATE | Exchange Rate for Variation Margin | TPM_VM_EXCHANGE_RATE | DEC | 9(5) | EXCRT | UKURS |
| Key field | Non-key field |
How do I retrieve data from SAP table TREAT_SUMMARY using ABAP code
The following ABAP code Example will allow you to do a basic selection on TREAT_SUMMARY to SELECT all data from the tableDATA: WA_TREAT_SUMMARY TYPE TREAT_SUMMARY.
SELECT SINGLE *
FROM TREAT_SUMMARY
INTO CORRESPONDING FIELDS OF WA_TREAT_SUMMARY
WHERE...
How to access SAP table TREAT_SUMMARY
Within an ECC or HANA version of SAP you can also view further information about TREAT_SUMMARY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects