SAP TRLV_DERIV_QUERY table - Generated Table for View details in SAP

SAP TRLV_DERIV_QUERY table summary

Object Name: TRLV_DERIV_QUERY
Dictionary Type: Table view
Description: Generated Table for View

Field list for TRLV_DERIV_QUERY table on an S/4 SAP system

Details

TRLV_DERIV_QUERY-MANDT table field - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

TRLV_DERIV_QUERY-OS_GUID table field - Object Identity in Database Format ▼

Description: Object Identity in Database Format
Field Name: OS_GUID
Data Element: TPM_DB_OS_GUID
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: TPM_DB_OS_GUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OS_GUID

TRLV_DERIV_QUERY-USER_DATA_CLS table field - Object Identity in Database Format ▼

Description: Object Identity in Database Format
Field Name: USER_DATA_CLS
Data Element: TPM_DB_OS_GUID
Data Type: CHAR
length (Dec): 32(0)
Check table: TRGT_USER_DATA
Conversion Routine:
Domain Name: TPM_DB_OS_GUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_DATA_CLS

TRLV_DERIV_QUERY-USER_DATA_OID table field - Object Identity in Database Format ▼

Description: Object Identity in Database Format
Field Name: USER_DATA_OID
Data Element: TPM_DB_OS_GUID
Data Type: CHAR
length (Dec): 32(0)
Check table: TRGT_USER_DATA
Conversion Routine:
Domain Name: TPM_DB_OS_GUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_DATA_OID

TRLV_DERIV_QUERY-DERIVTRANSSTAT table field - Status of a Business Transaction of Category: 'Derived BT' ▼

Description: Status of a Business Transaction of Category: 'Derived BT'
Field Name: DERIVTRANSSTAT
Data Element: TPM_DERIVTRANSSTAT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TPM_DERIVTRANSSTAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DERIVTRANSSTAT

TRLV_DERIV_QUERY-DIST_TRANS_ID table field - Identifier of the Distributor Business Transaction ▼

Description: Identifier of the Distributor Business Transaction
Field Name: DIST_TRANS_ID
Data Element: TPM_BUSTRANSID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIST_TRANS_ID

TRLV_DERIV_QUERY-RF_DIST_TRANS_ID table field - Business Transaction ID of Reference Business Transaction ▼

Description: Business Transaction ID of Reference Business Transaction
Field Name: RF_DIST_TRANS_ID
Data Element: TPM_REFBUSTRANSID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RF_DIST_TRANS_ID

TRLV_DERIV_QUERY-POSITION_DATE table field - Position Value Date ▼

Description: Position Value Date
Field Name: POSITION_DATE
Data Element: TPM_POSITION_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: TPM_POSITION_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSITION_DATE

TRLV_DERIV_QUERY-TR_ACC_CODE table field - Accounting Code ▼

Description: Accounting Code
Field Name: TR_ACC_CODE
Data Element: TPM_ACC_CODE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_ACC_CODE
MemoryID: TPM_TAC
AppClass:
SHLP: TRG_ACC_CODE
SHLP Field: TR_ACC_CODE
ConvExit:

See all SAP tables containing field TR_ACC_CODE

TRLV_DERIV_QUERY-VALUATION_AREA table field - Treasury Valuation Area ▼

Description: Treasury Valuation Area
Field Name: VALUATION_AREA
Data Element: TPM_VAL_AREA
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: TPM_VAL_AREA
MemoryID: TPM_VAL_AREA
AppClass:
SHLP: TRG_VALUATION_AREA
SHLP Field: VALUATION_AREA
ConvExit:

See all SAP tables containing field VALUATION_AREA

TRLV_DERIV_QUERY-CREATE_DATE table field - Creation Date of the Operative Business Transaction ▼

Description: Creation Date of the Operative Business Transaction
Field Name: CREATE_DATE
Data Element: TPM_BT_CREATE_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATE_DATE

TRLV_DERIV_QUERY-CREATE_TIME table field - Creation Time of the Operative Business Transaction ▼

Description: Creation Time of the Operative Business Transaction
Field Name: CREATE_TIME
Data Element: TPM_BT_CREATE_TIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATE_TIME

TRLV_DERIV_QUERY-VTR_EXISTS table field - Valuation Transaction Exists ▼

Description: Valuation Transaction Exists
Field Name: VTR_EXISTS
Data Element: TPM_VTR_EXISTS
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TPM_VTR_EXISTS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VTR_EXISTS

TRLV_DERIV_QUERY-REF_BUSTRANSCAT table field - Business Transaction Category ▼

Description: Business Transaction Category
Field Name: REF_BUSTRANSCAT
Data Element: TPM_BUSTRANSCAT
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_BUSTRANSCAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REF_BUSTRANSCAT

TRLV_DERIV_QUERY-DERIV_FLOWNUMBER table field - Number of TRL Flow ▼

Description: Number of TRL Flow
Field Name: DERIV_FLOWNUMBER
Data Element: TPM_TRLDERIVFLOWNR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TPM_TRLFLOW_NR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DERIV_FLOWNUMBER

TRLV_DERIV_QUERY-POSITION_OID table field - Object Identity in Database Format ▼

Description: Object Identity in Database Format
Field Name: POSITION_OID
Data Element: TPM_DB_OS_GUID
Data Type: CHAR
length (Dec): 32(0)
Check table: TRLT_POSITION
Conversion Routine:
Domain Name: TPM_DB_OS_GUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSITION_OID

TRLV_DERIV_QUERY-DIST_FLOW_NUMBER table field - Number of a Distributor Flow ▼

Description: Number of a Distributor Flow
Field Name: DIST_FLOW_NUMBER
Data Element: TPM_TRDFLOWNR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TPM_TRDFLOWNR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIST_FLOW_NUMBER

TRLV_DERIV_QUERY-POS_MAN_PROC table field - Position Management Procedure ▼

Description: Position Management Procedure
Field Name: POS_MAN_PROC
Data Element: TPM_POS_MAN_PROC
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_POS_MAN_PROC
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POS_MAN_PROC

TRLV_DERIV_QUERY-DERIV_METHOD table field - Derivation Method ▼

Description: Derivation Method
Field Name: DERIV_METHOD
Data Element: TPM_DERIV_METHOD
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FUNCNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DERIV_METHOD

TRLV_DERIV_QUERY-POSITION_CURR table field - Position Currency ▼

Description: Position Currency
Field Name: POSITION_CURR
Data Element: TPM_POSITION_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSITION_CURR

TRLV_DERIV_QUERY-POSITION_AMT table field - Amount (Position Currency) ▼

Description: Amount (Position Currency)
Field Name: POSITION_AMT
Data Element: TPM_POSITION_AMT
Data Type: CURR
length (Dec): 21(2)
Check table:
Conversion Routine:
Domain Name: TPM_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSITION_AMT

TRLV_DERIV_QUERY-POSAMT_IDX_CLEAN table field - Amount in Position Currency Index-Clean ▼

Description: Amount in Position Currency Index-Clean
Field Name: POSAMT_IDX_CLEAN
Data Element: TPM_POSITION_AMT_IDX_CLEAN
Data Type: CURR
length (Dec): 21(2)
Check table:
Conversion Routine:
Domain Name: TPM_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSAMT_IDX_CLEAN

TRLV_DERIV_QUERY-VALUATION_CURR table field - Valuation Currency ▼

Description: Valuation Currency
Field Name: VALUATION_CURR
Data Element: TPM_VALUATION_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALUATION_CURR

TRLV_DERIV_QUERY-VALUATION_AMT table field - Amount in Valuation Currency ▼

Description: Amount in Valuation Currency
Field Name: VALUATION_AMT
Data Element: TPM_VALUATION_AMT
Data Type: CURR
length (Dec): 21(2)
Check table:
Conversion Routine:
Domain Name: TPM_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALUATION_AMT

TRLV_DERIV_QUERY-AMT_PM_CAT table field - Position Change Category ▼

Description: Position Change Category
Field Name: AMT_PM_CAT
Data Element: TPM_AMT_PM_CAT
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_PM_CAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AMT_PM_CAT

TRLV_DERIV_QUERY-DIST_FLOWTYPE table field - Update Type ▼

Description: Update Type
Field Name: DIST_FLOWTYPE
Data Element: TPM_DIS_FLOWTYPE
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: TPM_DIS_FLOWTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIST_FLOWTYPE

TRLV_DERIV_QUERY-SOURCETARGET_FLG table field - Indicator: Source or Target of a Flow ▼

Description: Indicator: Source or Target of a Flow
Field Name: SOURCETARGET_FLG
Data Element: TPM_SOURCE_TARGET_FLG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TPM_SOURCE_TARGET_FLG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOURCETARGET_FLG

TRLV_DERIV_QUERY-TRANSFER_GROUP table field - Group of Flows from a Source or Target ▼

Description: Group of Flows from a Source or Target
Field Name: TRANSFER_GROUP
Data Element: TPM_TRANSFER_GROUP
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_SYSTEM_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANSFER_GROUP

TRLV_DERIV_QUERY-EFF_INT_RATE_U table field - For Calculation of Amortization Amts (SAC) for Used EffInR ▼

Description: For Calculation of Amortization Amts (SAC) for Used EffInR
Field Name: EFF_INT_RATE_U
Data Element: TPM_TRL_EFF_INT_RATE_USED
Data Type: DEC
length (Dec): 10(7)
Check table:
Conversion Routine:
Domain Name: DEC3_7
MemoryID:
AppClass: FVV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EFF_INT_RATE_U

TRLV_DERIV_QUERY-EFF_INT_RATE_N table field - Valid Effective Interest Rate for the Next Amortization ▼

Description: Valid Effective Interest Rate for the Next Amortization
Field Name: EFF_INT_RATE_N
Data Element: TPM_TRL_EFF_INT_RATE_NEW
Data Type: DEC
length (Dec): 10(7)
Check table:
Conversion Routine:
Domain Name: DEC3_7
MemoryID:
AppClass: FVV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EFF_INT_RATE_N

TRLV_DERIV_QUERY-SCHED_EFF_RATE table field - Key for Redemption Schedule that Explains Effect. Int. Rate ▼

Description: Key for Redemption Schedule that Explains Effect. Int. Rate
Field Name: SCHED_EFF_RATE
Data Element: RDPT_SCHEDULE_KEY_EFF_RATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHED_EFF_RATE

TRLV_DERIV_QUERY-SCHED_FIX table field - Key for Fixed Redemption Schedule ▼

Description: Key for Fixed Redemption Schedule
Field Name: SCHED_FIX
Data Element: RDPT_SCHEDULE_KEY_FIX
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHED_FIX

TRLV_DERIV_QUERY-SUBPOSITION_OID table field - Globally Unique Identifier ▼

Description: Globally Unique Identifier
Field Name: SUBPOSITION_OID
Data Element: OS_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUBPOSITION_OID

TRLV_DERIV_QUERY-UNITS table field - Units ▼

Description: Units
Field Name: UNITS
Data Element: TPM_UNITS
Data Type: DEC
length (Dec): 22(6)
Check table:
Conversion Routine:
Domain Name: TPM_UNITS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNITS

TRLV_DERIV_QUERY-NOMINAL_CURR table field - Nominal Currency ▼

Description: Nominal Currency
Field Name: NOMINAL_CURR
Data Element: TPM_NOMINAL_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOMINAL_CURR

TRLV_DERIV_QUERY-NOMINAL_AMT table field - Nominal Amount ▼

Description: Nominal Amount
Field Name: NOMINAL_AMT
Data Element: TPM_NOMINAL_AMT
Data Type: CURR
length (Dec): 21(2)
Check table:
Conversion Routine:
Domain Name: TPM_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOMINAL_AMT

TRLV_DERIV_QUERY-NOMINAL_ORG_AMT table field - Original Nominal Amount in Position Currency ▼

Description: Original Nominal Amount in Position Currency
Field Name: NOMINAL_ORG_AMT
Data Element: TPM_NOMINAL_ORG_AMT
Data Type: CURR
length (Dec): 21(2)
Check table:
Conversion Routine:
Domain Name: TPM_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOMINAL_ORG_AMT

TRLV_DERIV_QUERY-QUANT_CAT table field - Position Change Category: Quantity ▼

Description: Position Change Category: Quantity
Field Name: QUANT_CAT
Data Element: TPM_QTY_PM_CAT
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_QTY_PM_CAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUANT_CAT

TRLV_DERIV_QUERY-SUB_SOURCETARGET table field - Source or Target of Subposition Transfer ▼

Description: Source or Target of Subposition Transfer
Field Name: SUB_SOURCETARGET
Data Element: TPM_SUB_SOURCE_TARGET
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TPM_SUB_SOURCE_TARGET
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUB_SOURCETARGET

TRLV_DERIV_QUERY-SUB_TRANSFERGRP table field - Group of Flows in Subposition Transfer ▼

Description: Group of Flows in Subposition Transfer
Field Name: SUB_TRANSFERGRP
Data Element: TPM_SUB_TRANSFER_GROUP
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TPM_SYSTEM_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUB_TRANSFERGRP

TRLV_DERIV_QUERY-EFFTEST_RESULT table field - Result of Effectiveness Test for Flows ▼

Description: Result of Effectiveness Test for Flows
Field Name: EFFTEST_RESULT
Data Element: TPM_EFFTEST_RESULTFORFLOWS
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TPM_EFFTEST_RESULTFORFLOWS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EFFTEST_RESULT

View list of all SAP tables(S4H/ECC)

Select data from SAP table