SAP Table TRLIT_AD_TRANS - Accrual/Deferral Business Transactions (Documentation avail)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
ACCOUNTING_CODE X TPM_ACC_CODE CHAR 3 4 0 TRGC_TR_ACC_CODE Accounting Code
VALUATION_AREA X TPM_VAL_AREA CHAR 7 3 0 TRGC_VAL_AREA Valuation Area
POSITION_ID X TPM_DB_OS_GUID CHAR 10 32 0 TRACT_DOCUMENT Object Identity in Database Format
TRANSACTION_DATE X TPM_POSTING_DATE DATS 42 8 0 Posting Date for the Subledger
BUSTRANSID X TPM_BUSTRANSID RAW 50 16 0 Identifier of the Distributor Business Transaction
BUSTRANSCAT TPM_BUSTRANSCAT NUMC 66 4 0 Business Transaction Category
POSITION_TYPE TPM_AD_POS_TYPE CHAR 70 1 0 Categorization of a Position
KEY_DATE TPM_AD_KEYDATE DATS 71 8 0 Accrual/Deferral Key Date
KEY_DATE_INCL TPM_KEY_DATE_INCL CHAR 79 1 0 Indicator for Including Key Date
FLOWTYPE TPM_TRLI_FLOWTYPE_INCOME CHAR 80 8 0 TRDC_DFLOWTYPE Accrual/Deferral: Update Type for Profit-related Flow
CALC_BEGIN DBERVON DATS 88 8 0 Start of Calculation Period
CALC_BEGIN_ULT VVSULTVON CHAR 96 1 0 Month-End Indicator for Start of a Calculation Period
NUMBER_DAYS TFMATAGE INT4 100 10 0 Number of Days
DAYS_IN_PERIOD VVAPERTAGE NUMC 104 6 0 No. of days of a (calculation) period in cash flow
POSITION_CURR TPM_POSITION_CURR CUKY 110 5 0 TCURC Position Currency
POSITION_AMT TPM_POSITION_AMT CURR 115 21 2 Amount in Position Currency
POSAMT_IDX_CLEAN TPM_POSITION_AMT_IDX_CLEAN CURR 126 21 2 Amount in Position Currency Index-Clean
VALUATION_CURR TPM_VALUATION_CURR CUKY 137 5 0 TCURC Valuation Currency
VALUATION_AMT TPM_VALUATION_AMT CURR 142 21 2 Amount in Valuation Currency
COMP_POS_AMT TPM_COMP_POSITION_AMT CURR 153 21 2 Netting Amount in Position Currency
COMP_VAL_AMT TPM_COMP_VALUATION_AMT CURR 164 21 2 Netting Amount in Valuation Currency
TOTAL_POS_AMT TPM_POSITION_AMT CURR 175 21 2 Amount in Position Currency
TOTAL_VAL_AMT TPM_VALUATION_AMT CURR 186 21 2 Amount in Valuation Currency
PART_POS_AMT TPM_POSITION_AMT CURR 197 21 2 Amount in Position Currency
PART_VAL_AMT TPM_VALUATION_AMT CURR 208 21 2 Amount in Valuation Currency
RATE_POS_TO_VAL TPM_FX_RATE_POS_TO_VAL DEC 219 9 5 Exchange Rate from Position to Local Currency
METHOD TPM_TRLI_AD_METHOD CHAR 224 1 0 Accrual/Deferral Procedure
KEY_DATE_ULT TPM_KEY_DATE_ULT CHAR 225 1 0 Month-End Indicator for Key Date
FUNCTION TPM_TRLI_AD_FUNCTION CHAR 226 3 0 Accrual/Deferral Method
BBASIS TFM_BBASIS2 CURR 229 13 2 Calculation Base Amount
PKOND PKOND DEC 236 10 7 Percentage rate for condition items
JEXPOZINS TB_JZINSRE CHAR 242 1 0 Exponential Interest Calculation
SZBMETH SZBMETH CHAR 243 1 0 Interest Calculation Method
SKALIDWT TFMSKALIDWT CHAR 244 2 0 TFACD Interest Calendar
PPAYMENT TFM_PPAYMENT DEC 246 11 7 Payment Rate