SAP Table TRGC_STEP_PROC

Procedure for Steps

TRGC_STEP_PROC (Procedure for Steps) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TRGC_STEP_PROC to other SAP tables.

TRGC_STEP_PROC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
STEP_CAT Type of Step TPM_VAL_STEP_CAT TRGTS_STEPDEF NUMC 3 0
STEP_PROC Procedure for a Step TPM_STEP_PROCEDURE CHAR 4 0
PRICE_TYPE Security Price Type VVSKURSART TW56 CHAR 2 0
CV_TYPE Price/NPV Type for OTC Transactions TV_OKUART ATVOK CHAR 3 0
RATE_CATEGORY Exchange Rate Type KURST_CURR TCURV CHAR 4 0
RULE_UP Write-Up Rule TPM_UP CHAR 1 0
1 No Write-Up
2 Write Up to Purchase Value
3 Write Up to Market Value/Present Value
RULE_DOWN Write-Down Rule TPM_DOWN CHAR 1 0
1 No Write-Down
2 Write Down to Purchase Value
3 Write Down to Market Value/Present Value
4 Write Down to Nominal Value/Repayment Value
FLG_COSTS Write Off Costs Fully TPM_COSTS CHAR 1 0
X Yes
NULL No
RESOLVE_TI Indicator: Clear Gains/Losses TPM_PARTITION CHAR 1 0
X Yes
NULL No
RESOLVE_FE Indicator: Clear Gains/Losses TPM_PARTITION CHAR 1 0
X Yes
NULL No
GAIN_LOSS_HANDL Handling of Gains/Losses TPM_GAIN_LOSS_HANDLING CHAR 1 0
1 Do Not Realize Gains/Losses
2 Hedge Accounting (Hedge Transaction)
3 Hedge Accounting (Underlying Transaction)
RESET_TITLE_VAL Flag for reset of Title valuation during year end valuation TPM_FLG_RESET_TITLE_VAL CHAR 1 0
X Yes
NULL No
COMPUTATION_CAT Calculation Category for Amortization TPM_COMPUTATION_CAT CHAR 2 0
02 LAC
03 SAC
BRUTTO_NETTO Indicator Gross or Net Procedure TPM_BRUTTO_NETTO CHAR 1 0
N Net
S Net; Separate Balance Sheet Accounts for Amortization
B Gross
A Gross: Premium/discount not contained in book value
T Gross: Separate Accounts for Accrual/Deferral Items
RATE_CALC_METHOD Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
PURCHASE_GAAP Purchase GAAP Indicator TPM_PURCHASE_GAAP NUMC 3 0
000 LAC/SAC Value calculation with history
001 LAC/SAC Value calculation without history
DISSOLVE Flag: Reset is Possible TPM_DISSOLVE CHAR 1 0
AMORT_END Amortization to Final Due Date / Termination TPM_AMORT_END INT1 3 0
1 Amortization to End of Term (SE/LO SAC)/ Int. Calc.(LO LAC)
2 Amortization to Issuer's Next Termination Date
3 Amortization to End of Fixed Period (Loans, LAC)
4 Amortization to Date of Termination (SE)/Fixed Per. End (LO)
RATE_CAT_SPOTP Rate Type for Spot - Purchase Currency/Valuation Currency TPM_RATE_CAT_SPOTP TCURV CHAR 4 0
RATE_CAT_SPOTS Rate Type for Spot - Selling Currency/Valuation Currency TPM_RATE_CAT_SPOTS TCURV CHAR 4 0
RATE_CAT_SWAPP Rate Type for Spot - Purchase Currency/Valuation Currency TPM_RATE_CAT_SWAPP TCURV CHAR 4 0
RATE_CAT_SWAPS Rate Type for Swap - Selling Currency/Valuation Currency TPM_RATE_CAT_SWAPS TCURV CHAR 4 0
FORWARD_CAT Rate Valuation Category Forward TPM_FORWARD_CAT CHAR 1 0
1 Market spot rate for forward rate in transaction
2 Market forward rate for forward rate in transaction
3 Market spot rate for spot rate in transaction
6 Valuation with net present value from risk module
CROSS_VAL Indicator: Cross Valuation for Forward Exchange Transaction TPM_CROSS CHAR 1 0
ACCRUE_COMP Additional Components Managed TPM_ACCRUE_COMP CHAR 2 0
01 Deferral Item, Purchase Value
02 Linear Negotiation Spread
03 Exponential Negotiation Spread
04 Negotiation Spread W/out Amortization
SP_VAL_SEC Indicator: Enable Special Write-Up/Write-Down for Securities TPM_SP_VAL_SEC CHAR 1 0
NPV_CATEGORY NPV Category TPM_NPV_CATEGORY CHAR 1 0
1 Dirty
2 Clean
INCL_INTEREST Inclusion of Interest in Amortization Calculation TPM_INCL_INTEREST NUMC 1 0
0 Do Not Include Interest
1 Include Interest, Accrued Interest Adjustment (Sec. Only)
2 Effective Interest Method in Accordance with IAS 39
EFF_INT_SAC Treatment of Effect. Interest Rate for Amort. Acc. to SAC TPM_EFF_INTEREST_SAC NUMC 1 0
0 Adjust Effective Interest Rate Immediately (Standard)
1 Adjust Effective Interest Rate Deferred (obsolete)
2 Constant Effective Insterest Rate
3 Retrospective
SULTVON Month-End Indicator for Start of a Calculation Period VVSULTVON CHAR 1 0
NULL
X Month-end date
SULTBIS Month-End Indicator for the End of a Calculation Period VVSULTBIS CHAR 1 0
NULL
X Month-end date
AMORT_CUT Cut SAC Amortization TPM_AMORT_CUT CHAR 1 0
X Yes
NULL No
ALLOW_CALC_AMORT Allow Calculation of Derived Business Transactions TPM_ALLOW_CALC_DERIVED CHAR 1 0
X Yes
NULL No
VAD_AMORT Amortization of Value Adjustment Components TPM_VAD_AMORT CHAR 1 0
X Yes
NULL No
COMP_VAL Select Component for Valuation TPM_COMP_VAL CHAR 1 0
NULL Book Value
1 Variation Margin
2 Amortized Acquistion Value
4 Amortized Acquistion Value; only at Valuation
3 Hedge Adjustment
POSTING_SPEC_VAL Posting Specifications Selection TPM_POSTING_SPEC_VAL CHAR 1 0
NULL Separate Accounts for P&L
1 Separate Balance Sheet Accounts Asset/Liab.
FX_NETTING_DEAL Indicator: Offsetting Transaction for Forward Exchange Trans TPM_NETTING CHAR 1 0
X Yes
NULL No
CV_TYPE_START Price/NPV Type for OTC Transactions TV_OKUART ATVOK CHAR 3 0
INTEREST_RISK Interest Rate Risk Yes/No TPM_RISK_IR CHAR 1 0
NULL No
X Yes
CREDIT_RISK Credit Risk Yes/No TPM_RISK_CR CHAR 1 0
NULL No
X Yes
FXRATE_RISK Fx Risk Yes/No TPM_RISK_FX CHAR 1 0
NULL No
X Yes
PRICE_RISK Price Risk Yes/No TPM_RISK_PR CHAR 1 0
NULL No
X Yes
EVAL_TYP ID of Risk Management Evaluation JBREVAL_D JBREVAL CHAR 4 0
CONV_RATE_AMORT Amortization Rate Conversion Category TPM_CONV_RATE_AMORT INT1 3 0
0 Book rate
1 Market rate
FLG_DIRTY_PRICE Use Dirty Price (Market Price + Interest Accrual) TPM_FLG_DIRTY_PRICE CHAR 1 0
X Yes
NULL No
ACCRUAL_INCL Indicator for Including Key Date TPM_KEY_DATE_INCL CHAR 1 0
NULL Exclusive
X Inclusive
ACCRUAL_ULTIMO Month-End Indicator for Key Date TPM_KEY_DATE_ULT CHAR 1 0
NULL
X Month-end date
FLG_CLR_VAL_CURR Clear Amount in Valuation Currency if Valuation is Resolved TPM_TI_CLEAR_VAL_CURR_AMT CHAR 1 0
FLG_AMORT_END_EX Exclude Final Amortization Date from Amortization Period TPM_FLG_AMORT_END_EXCL CHAR 1 0
X Yes
NULL No
FLG_EXCL_TB Exclude Interest-Like Flows from Calculation TPM_FLG_AMORT_EXCL_TB_FLOWS CHAR 1 0
X Yes
NULL No
CUSTOM_ATTRIB Custom Setting for Valuation Step TPM_VAL_STEP_ATTRIB CHAR 4 0
ACCRUAL_FUNCTION Accrual/Deferral Method TPM_TRLI_AD_FUNCTION CHAR 3 0
001 Linear
002 Pro Rata
003 Complete
004 Pro Rata with Linear Discounting
FLG_HREL_LIMITED Execute Solely in the Case of Hedge Accounting TPM_HREL_LIMITED CHAR 1 0
NULL No
X Yes
FLG_ADJ_TRANSL4A Adjustment of Translation Flows for Amortization TPM_ADJUST_AMORT_TRANSL CHAR 1 0
NULL No Adjustment
X Adjustment Activated
AFFECT_DERIV_COMP Affect Derive Components TPM_AFFECT_DERIV_COMP CHAR 1 0
A Amortized Acquisition Value

TRGC_STEP_PROC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TRGC_STEP_PROC CV_TYPE TRGC_STEP_PROC MANDT ATVOK Rate types for OTC NPVs MANDT
TRGC_STEP_PROC CV_TYPE TRGC_STEP_PROC CV_TYPE ATVOK Rate types for OTC NPVs OKUART
TRGC_STEP_PROC CV_TYPE_START TRGC_STEP_PROC MANDT ATVOK Rate types for OTC NPVs MANDT
TRGC_STEP_PROC CV_TYPE_START TRGC_STEP_PROC CV_TYPE_START ATVOK Rate types for OTC NPVs OKUART
TRGC_STEP_PROC EVAL_TYP TRGC_STEP_PROC MANDT JBREVAL Risk Management evaluation type - definition MANDT
TRGC_STEP_PROC EVAL_TYP TRGC_STEP_PROC EVAL_TYP JBREVAL Risk Management evaluation type - definition AUSWERTUNG
TRGC_STEP_PROC MANDT TRGC_STEP_PROC MANDT T000 Clients MANDT
TRGC_STEP_PROC PRICE_TYPE TRGC_STEP_PROC MANDT TW56 Security price type MANDT
TRGC_STEP_PROC PRICE_TYPE TRGC_STEP_PROC PRICE_TYPE TW56 Security price type SKURSART
TRGC_STEP_PROC RATE_CATEGORY TRGC_STEP_PROC MANDT TCURV Exchange rate types for currency translation MANDT
TRGC_STEP_PROC RATE_CATEGORY TRGC_STEP_PROC RATE_CATEGORY TCURV Exchange rate types for currency translation KURST
TRGC_STEP_PROC RATE_CAT_SPOTP TRGC_STEP_PROC RATE_CAT_SPOTP TCURV Exchange rate types for currency translation KURST
TRGC_STEP_PROC RATE_CAT_SPOTP TRGC_STEP_PROC MANDT TCURV Exchange rate types for currency translation MANDT
TRGC_STEP_PROC RATE_CAT_SPOTS TRGC_STEP_PROC MANDT TCURV Exchange rate types for currency translation MANDT
TRGC_STEP_PROC RATE_CAT_SPOTS TRGC_STEP_PROC RATE_CAT_SPOTS TCURV Exchange rate types for currency translation KURST
TRGC_STEP_PROC RATE_CAT_SWAPP TRGC_STEP_PROC MANDT TCURV Exchange rate types for currency translation MANDT
TRGC_STEP_PROC RATE_CAT_SWAPP TRGC_STEP_PROC RATE_CAT_SWAPP TCURV Exchange rate types for currency translation KURST
TRGC_STEP_PROC RATE_CAT_SWAPS TRGC_STEP_PROC MANDT TCURV Exchange rate types for currency translation MANDT
TRGC_STEP_PROC RATE_CAT_SWAPS TRGC_STEP_PROC RATE_CAT_SWAPS TCURV Exchange rate types for currency translation KURST
TRGC_STEP_PROC STEP_CAT TRGC_STEP_PROC STEP_CAT TRGTS_STEPDEF Treasury: Step Categories in Position Management STEP_CAT