1. Home
  2. Resources
  3. SAP Tables
  4. VALS_CUST - Customizing Settings for a Valuation Step

SAP Table VALS_CUST

Customizing Settings for a Valuation Step

VALS_CUST (Customizing Settings for a Valuation Step) 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 VALS_CUST to other SAP tables.

Source: VALS_CUST (Customizing Settings for a Valuation Step)

VALS_CUST table fields

Field Data element Checktable Datatype Length Decimals
POS_MAN_PROC Position Management Procedure TPM_POS_MAN_PROC CHAR 4 0
POS_MAN_CAT Position mgt categ. TPM_DERIVATION_CAT NUMC 3 0
STEP_CAT Type of Step TPM_VAL_STEP_CAT NUMC 3 0
STEP_PROC Procedure for a Step TPM_STEP_PROCEDURE CHAR 4 0
PRICE_TYPE Security Price Type VVSKURSART CHAR 2 0
CV_TYPE Price/NPV Type for OTC Transactions TV_OKUART CHAR 3 0
RATE_CATEGORY Exchange Rate Type KURST_CURR CHAR 4 0
FLG_CLEAR_VAL Reset Forex Valuation When Record/Reset Impairment TPM_FLG_CLEAR_VAL CHAR 1 0
FLG_FX_IMP Record FX Impairment TPM_FLG_FX_IMPAIRMENT CHAR 1 0
FLG_ALLOW_AMORT Permit Amortization After Impairment TPM_FLG_ALLOW_AMORT CHAR 1 0
CONV_RATE_IMP Exchange Rate for Security Impairment TPM_CONV_RATE_IMP INT1 3 0
0 Market Price
1 Book Rate
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
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
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 CHAR 4 0
RATE_CAT_SPOTS Rate Type for Spot - Selling Currency/Valuation Currency TPM_RATE_CAT_SPOTS CHAR 4 0
RATE_CAT_SWAPP Rate Type for Spot - Purchase Currency/Valuation Currency TPM_RATE_CAT_SWAPP CHAR 4 0
RATE_CAT_SWAPS Rate Type for Swap - Selling Currency/Valuation Currency TPM_RATE_CAT_SWAPS 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
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
IMP_PROC Impairment Procedure TPM_IMP_PROC CHAR 4 0
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
POS_PASSIV Liability/Asset TPM_POSITION_PASSIV CHAR 1 0
X Position Managed as Liability
C Manage Assets and Liabilities Balance Sheet Account
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
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
FLG_TITLE_IMP Allow positive security impairment TPM_FLG_SEC_IMPAIRMENT CHAR 1 0
X Yes
NULL No
CONV_RATE_AMORT Amortization Rate Conversion Category TPM_CONV_RATE_AMORT INT1 3 0
0 Book rate
1 Market rate
ROUND_PROC Rounding Rule for FX Conversion at Valuation TPM_ROUND_PROC CHAR 1 0
NULL Arithmetic Rounding
1 Round Down
FLG_CLR_REAL_TIL Reset Realized Security Valuation TPM_FLG_CLEAR_REAL_TITLE_VAL CHAR 1 0
FLG_CLR_REAL_FX Reset Realized Foreign Currency Valuation TPM_FLG_CLEAR_REAL_FX_VAL CHAR 1 0
FLG_ONE_STEP One-Step Impairment Procedure TPM_FLG_ONE_STEP_IMPAIRMENT CHAR 1 0
FLG_VAL_CURR_DEC Clearing via amount in valuation currency TPM_FLG_VAL_CURR_IMPAIRMENT CHAR 1 0
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
FLG_HREL_LIMITED Execute Solely in the Case of Hedge Accounting TPM_HREL_LIMITED CHAR 1 0
NULL No
X Yes