TRLT_BACKUPVORAB SAP (Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol.) Table details
Description: Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol.
Related tables to TRLT_BACKUPVORAB
Access table TRLT_BACKUPVORAB
Table field list including key, data, relationships and ABAP select examples
TRLT_BACKUPVORAB is a standard SAP Table which is used to store Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. data and is available within R/3 SAP systems depending on the version and release level.
The TRLT_BACKUPVORAB table consists of various fields, each holding specific information or linking keys about Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. data available in SAP. These include COMPANY_CODE (Company Code), ACCOUNTING_CODE (Accounting Code), VALUATION_AREA (Valuation Area), VALUATION_CLASS (Valuation Class).. 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: Cannot Be Enhanced
SAP TRLT_BACKUPVORAB 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 | |||
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ACCOUNTING_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | Assigned to domain | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | Assigned to domain | TPM_VAL_CLASS | |||
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | Assigned to domain | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
PRODUCT_CATEGORY | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | SYSUUID | ||||
FLOWNUMBER | Numeric Character Field, Length 10 | NUMC10 | NUMC | 10 | NUMC10 | ||||
TRLDATE | Treasury Ledger Date | TPM_TRLDATE | DATS | 8 | DATUM | ||||
FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | Assigned to domain | TPM_DIS_FLOWTYPE | |||
QUANT_CAT | Position Change Category: Quantity | TPM_QTY_PM_CAT | CHAR | 4 | TPM_QTY_PM_CAT | ||||
AMOUNT_CAT | Position Change Category | TPM_AMT_PM_CAT | CHAR | 4 | Assigned to domain | TPM_PM_CAT | |||
UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_CURR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
POSITION_AMT | Amount (Position Currency) | TPM_POSITION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
VALUATION_AMT | Amount in Valuation Currency | TPM_VALUATION_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 1 | TPM_SOURCE_TARGET_FLG | ||||
TRANSFER_GROUP | Group of Flows from a Source or Target | TPM_TRANSFER_GROUP | NUMC | 4 | TPM_SYSTEM_KEY | ||||
GL_ACCOUNT_D | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
GL_ACCOUNT_C | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
FI_DOC_NR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POSTING_DATE | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DOCUMENTID | Distributor Document ID | TPM_TRDDOCID | RAW | 16 | SYSUUID | ||||
BOOKING_STATE | Posting Status Treasury Ledger Business Transaction | TPM_TRL_BOOKINGSTATE | CHAR | 1 | TRLBS | TPM_TRL_BOOKINGSTATE | |||
TRANSTATE | Status of Treasury Ledger Business Transaction | TPM_TRLTRANSTATE | CHAR | 1 | TPM_TRANSACTION_STATE | ||||
POS_MAN_PROC | Position Management Procedure | TPM_POS_MAN_PROC | CHAR | 4 | Assigned to domain | TPM_POS_MAN_PROC | |||
ACC_ASS_REF | Account Assignment Reference (prelim. sol. not CFM 1.0) | TPM_ACC_ASS_REF | CHAR | 10 | Assigned to domain | TPM_ACC_ASS_REF | |||
STOCK_TYPE | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
TRADABLE | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
BPARTNER | Business Partner Number | BP_PARTNR_OLD | CHAR | 10 | Assigned to domain | ALPHA | BP_PARTNR | BPN | |
LEGAL_ORG | Legal Entity of Organization | BP_LEG_ORG_OLD | NUMC | 2 | Assigned to domain | BP_LEG_ORG | |||
COUNTRY | Nationality | BP_CNTR_N | CHAR | 3 | Assigned to domain | LAND1 | |||
IND_SECTOR | Business Partner: Industry (Organization) | BP_SECTOR | CHAR | 10 | Assigned to domain | BU_INDSECT | |||
CONSOLIDATION | Balance Sheet Display | BP_BAL_FLG | CHAR | 1 | BP_BAL_FLG | ||||
MAT_TERM_BEGIN | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
MAT_TERM_END | End of Loan Term | DENDLFZ | DATS | 8 | DATUM | ||||
BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | NUMC | 4 | Assigned to domain | TPM_BUSTRANSCAT | |||
ACC_CODE_T | Name of Accounting Code | TPM_TR_ACC_CODE_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
VALUATION_AREA_T | Name of the Valuation Area | TPM_VAL_AREA_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
VAL_CLASS_T | Description of valuation class | TPM_VAL_CLASS_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
SECURITY_ID_T | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
ACCOUNT_GROUP_T | Name of Securities Account Group | TPM_SEC_ACCT_GRP_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
LOANS_CONTRACT_T | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
GSART_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
QUANT_CAT_T | Position Change Category: Quantity (Text) | TPM_QTY_PM_CAT_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
AMOUNT_CAT_T | Position Change Category (long name) | TPM_AMT_PM_CAT_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
BUSTRANSCAT_T | Name of Business Transaction Category | TPM_BUSTRANSCAT_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
FLOWTYPE_T | Update Type Text | TPM_DFT_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
POS_MAN_PROC_T | Position Management Procedure Text | TPM_POS_MAN_PROC_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
ACC_ASS_REF_T | Name of Account Assignment Reference | TPM_ACC_ASS_REF_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
STOCK_TYPE_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
LEGAL_ORG_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
COUNTRY_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
IND_SECTOR_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
CONSOLIDATION_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
AMOUNT_CAT_OLD | Position Change Category | TPM_AMT_PM_CAT | CHAR | 4 | Assigned to domain | TPM_PM_CAT | |||
BACKUP_DATE | Key Date for Selection According to Time-Related Validity | STICHTAG | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table TRLT_BACKUPVORAB using ABAP code
The following ABAP code Example will allow you to do a basic selection on TRLT_BACKUPVORAB to SELECT all data from the tableDATA: WA_TRLT_BACKUPVORAB TYPE TRLT_BACKUPVORAB.
SELECT SINGLE *
FROM TRLT_BACKUPVORAB
INTO CORRESPONDING FIELDS OF WA_TRLT_BACKUPVORAB
WHERE...
How to access SAP table TRLT_BACKUPVORAB
Within an ECC or HANA version of SAP you can also view further information about TRLT_BACKUPVORAB 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