1. Home
  2. Resources
  3. SAP Tables
  4. TRLIC_AD - TR: Customizing: Accrual/Deferral

SAP Table TRLIC_AD

TR: Customizing: Accrual/Deferral

TRLIC_AD (TR: Customizing: Accrual/Deferral) 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 TRLIC_AD to other SAP tables.

TRLIC_AD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PRODUCT_GROUP Product Group TPM_PRODUCT_GROUP NUMC 3 0
001 Securities
002 Loans
003 OTC Transactions: Money Market, FX, Derivatives
004 Listed Options / Futures
005 External Accounts
ACCOUNTING_CODE Accounting Code TPM_ACC_CODE TRGC_TR_ACC_CODE CHAR 4 0
VALUATION_AREA Valuation Area TPM_VAL_AREA TRGC_VAL_AREA CHAR 3 0
PRODUCT_CATEGORY Product Category SANLF TZAF NUMC 3 0
PRODUCT_TYPE Product Type VVSART TZPA CHAR 3 0
POS_MAN_PROC Position Management Procedure TPM_POS_MAN_PROC TRGC_PM_PROC CHAR 4 0
FLOWTYPE_INCOME Accrual/Deferral: Update Type for Profit-Related Flow TPM_TRLI_FLOWTYPE_INCOME TRDC_DFLOWTYPE CHAR 8 0
METHOD Accrual/Deferral Procedure TPM_TRLI_AD_METHOD CHAR 1 0
1 Reset Procedure
2 Difference Procedure
COMPENSATION Accrual/Deferral: Taking Netting Account into Consideration TPM_TRLI_AD_COMPENSATION CHAR 1 0
NULL No
X Yes
FUNCTION Accrual/Deferral Method TPM_TRLI_AD_FUNCTION CHAR 3 0
001 Linear
002 Pro Rata
003 Complete
004 Pro Rata with Linear Discounting
FT_ACCRUAL Update Type Accrual TPM_TRLI_FLOWTYPE_ACCRUAL TRGC_DFTSOURCASS CHAR 8 0
FT_ACCRUAL_RES Update Type Accrual Reset TPM_TRLI_FLOWTYPE_ACCRUAL_RES TRGC_DFTSOURCASS CHAR 8 0
FT_ACCRUAL_CORR Update Type for Correction of Accrual TPM_TRLI_FLOWTYPE_ACCRUAL_COR TRGC_DFTSOURCASS CHAR 8 0
FT_DEFERRAL Update Type Deferral TPM_TRLI_FLOWTYPE_DEFERRAL TRGC_DFTSOURCASS CHAR 8 0
FT_DEFERRAL_RES Update Type Deferral Reset TPM_TRLI_FLOWTYPE_DEFERRAL_RES TRGC_DFTSOURCASS CHAR 8 0
FT_DEFERRAL_CORR Update Type for Correction of Deferral TPM_TRLI_FLOWTYPE_DEFERRAL_COR TRGC_DFTSOURCASS CHAR 8 0
FT_AD_DIFF_METH Update Type for Accrual/Deferral Difference Procedure TPM_TRLI_FLOWTYPE_AD_DIFF_METH TRGC_DFTSOURCASS CHAR 8 0
FT_AD_CORR Update Type for Accrual/Deferral Offsetting Flow TPM_TRLI_FLOWTYPE_CORRECT TRGC_DFTSOURCASS CHAR 8 0
FT_AD_FX_INC Update Type: Forex Valuation Write-Up TPM_TRLI_FLOWTYPE_FX_INCR TRGC_DFTSOURCASS CHAR 8 0
FT_AD_FX_DEC Update Type: Forex Valuation Write-Down TPM_TRLI_FLOWTYPE_FX_DECR TRGC_DFTSOURCASS CHAR 8 0
DAY_METHOD Days Calculation Method TPM_DAY_METHOD NUMC 1 0
1 360E
2 Act
3 365
4 360
5 ActW
6 360 ISDA
7 m+act
8 m+30
9 360 German
FLOWTYPE_INCOME2 Accrual/Deferral: Update Type for Profit-Related Flow TPM_TRLI_FLOWTYPE_INCOME CHAR 8 0
AGGREGATION_TERM Accrual/Deferral: Grouping Term TPM_AD_AGGREGATION_TERM CHAR 8 0
EXCH_RATE_CAT Accrual/Deferral: Exchange Rate Category TPM_AD_EXCH_RATE_CAT CHAR 2 0
0 Default
1 Market Price
EXCH_DATE_CAT Accrual/Deferral: Translation Date Category TPM_AD_EXCH_DATE_CAT CHAR 2 0
0 Translation on Accrual/Deferral Key Date
1 Translation on Posting Date
FT_AD_CC_POST Update type posting after currency conversion TPM_TRLI_FLOWTYPE_CC_POST TRDC_DFLOWTYPE CHAR 8 0
FT_AD_CC_CLEAR Update type clearing after currency conversion TPM_TRLI_FLOWTYPE_CC_CLEAR TRDC_DFLOWTYPE CHAR 8 0
FT_AD_CC_POST_N Update type posting after currency conversion TPM_TRLI_FLOWTYPE_CC_POST TRDC_DFLOWTYPE CHAR 8 0
FT_AD_CC_CLEAR_N Update type clearing after currency conversion TPM_TRLI_FLOWTYPE_CC_CLEAR TRDC_DFLOWTYPE CHAR 8 0
FLOWTYPE_EXPENSE Accrual/Deferral: Update Type for Expense-Related Flow TPM_TRLI_FLOWTYPE_EXPENSE TRDC_DFLOWTYPE CHAR 8 0
OVERDUE_DAYS Number of Days of Overdue Accrual TPM_DAYS_OVERDUE INT4 10 0

TRLIC_AD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TRLIC_AD ACCOUNTING_CODE TRLIC_AD MANDT TRGC_TR_ACC_CODE Accounting Code MANDT
TRLIC_AD ACCOUNTING_CODE TRLIC_AD ACCOUNTING_CODE TRGC_TR_ACC_CODE Accounting Code TR_ACC_CODE
TRLIC_AD FLOWTYPE_EXPENSE TRLIC_AD MANDT TRDC_DFLOWTYPE Definition of Update Types MANDT
TRLIC_AD FLOWTYPE_EXPENSE TRLIC_AD FLOWTYPE_EXPENSE TRDC_DFLOWTYPE Definition of Update Types DIS_FLOWTYPE
TRLIC_AD FLOWTYPE_INCOME SYST MANDT TRDC_DFLOWTYPE Definition of Update Types MANDT
TRLIC_AD FLOWTYPE_INCOME TRLIC_AD FLOWTYPE_INCOME TRDC_DFLOWTYPE Definition of Update Types DIS_FLOWTYPE
TRLIC_AD FT_ACCRUAL TRLIC_AD FT_ACCRUAL TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_ACCRUAL TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_ACCRUAL '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_ACCRUAL_CORR TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_ACCRUAL_CORR '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_ACCRUAL_CORR TRLIC_AD FT_ACCRUAL_CORR TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_ACCRUAL_RES TRLIC_AD FT_ACCRUAL_RES TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_ACCRUAL_RES TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_ACCRUAL_RES '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_AD_CC_CLEAR TRLIC_AD MANDT TRDC_DFLOWTYPE Definition of Update Types MANDT
TRLIC_AD FT_AD_CC_CLEAR TRLIC_AD FT_AD_CC_CLEAR TRDC_DFLOWTYPE Definition of Update Types DIS_FLOWTYPE
TRLIC_AD FT_AD_CC_CLEAR_N TRLIC_AD MANDT TRDC_DFLOWTYPE Definition of Update Types MANDT
TRLIC_AD FT_AD_CC_CLEAR_N TRLIC_AD FT_AD_CC_CLEAR_N TRDC_DFLOWTYPE Definition of Update Types DIS_FLOWTYPE
TRLIC_AD FT_AD_CC_POST TRLIC_AD FT_AD_CC_POST TRDC_DFLOWTYPE Definition of Update Types DIS_FLOWTYPE
TRLIC_AD FT_AD_CC_POST TRLIC_AD MANDT TRDC_DFLOWTYPE Definition of Update Types MANDT
TRLIC_AD FT_AD_CC_POST_N TRLIC_AD MANDT TRDC_DFLOWTYPE Definition of Update Types MANDT
TRLIC_AD FT_AD_CC_POST_N TRLIC_AD FT_AD_CC_POST_N TRDC_DFLOWTYPE Definition of Update Types DIS_FLOWTYPE
TRLIC_AD FT_AD_CORR TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_AD_CORR '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_AD_CORR TRLIC_AD FT_AD_CORR TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_AD_DIFF_METH '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_AD_DIFF_METH TRLIC_AD FT_AD_DIFF_METH TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_AD_DIFF_METH TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_AD_FX_DEC TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_AD_FX_DEC '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_AD_FX_DEC TRLIC_AD FT_AD_FX_DEC TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_AD_FX_INC TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_AD_FX_INC '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_AD_FX_INC TRLIC_AD FT_AD_FX_INC TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_DEFERRAL TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_DEFERRAL '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_DEFERRAL TRLIC_AD FT_DEFERRAL TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_DEFERRAL_CORR TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_DEFERRAL_CORR '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD FT_DEFERRAL_CORR TRLIC_AD FT_DEFERRAL_CORR TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_DEFERRAL_RES TRLIC_AD FT_DEFERRAL_RES TRGC_DFTSOURCASS Assign Update Types to Usages DIS_FLOWTYPE
TRLIC_AD FT_DEFERRAL_RES TRLIC_AD MANDT TRGC_DFTSOURCASS Assign Update Types to Usages MANDT
TRLIC_AD FT_DEFERRAL_RES '0006' TRGC_DFTSOURCASS Assign Update Types to Usages SOURCE
TRLIC_AD POS_MAN_PROC TRLIC_AD MANDT TRGC_PM_PROC Treasury: Position Management Procedure MANDT
TRLIC_AD POS_MAN_PROC TRLIC_AD POS_MAN_PROC TRGC_PM_PROC Treasury: Position Management Procedure POS_MAN_PROC
TRLIC_AD PRODUCT_CATEGORY TRLIC_AD PRODUCT_CATEGORY TZAF Product categories SANLF
TRLIC_AD PRODUCT_TYPE TRLIC_AD MANDT TZPA Financial Assets Management Product Types MANDT
TRLIC_AD PRODUCT_TYPE TRLIC_AD PRODUCT_TYPE TZPA Financial Assets Management Product Types GSART
TRLIC_AD VALUATION_AREA TRLIC_AD MANDT TRGC_VAL_AREA Valuation Areas MANDT
TRLIC_AD VALUATION_AREA TRLIC_AD VALUATION_AREA TRGC_VAL_AREA Valuation Areas VALUATION_AREA