This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table TRDTT_VADATA_SEC (Valuation-Area-Dependent Data for Securities) is a standard table in SAP ERP. It belongs to the package FTR_DATA_TRANSFER.
Table | TRDTT_VADATA_SEC |
Short Text | Valuation-Area-Dependent Data for Securities |
Package | FTR_DATA_TRANSFER |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
KEY_DATE | ✔ | Position Value Date | TPM_POSITION_DATE | DATS | 8 | |
COMPANY_CODE | ✔ | Company Code | BUKRS | CHAR | 4 | * |
COM_VAL_CLASS | ✔ | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL |
VALUATION_AREA | ✔ | Valuation Area | TPM_VAL_AREA | CHAR | 3 | * |
SECURITY_ID | ✔ | Security ID Number | VVRANLW | CHAR | 13 | * |
SECURITY_ACCOUNT | ✔ | Securities Account | RLDEPO | CHAR | 10 | * |
PORTFOLIO | ✔ | Portfolio | RPORTB | CHAR | 10 | * |
FUND | ✔ | Fund | FM_FUND | CHAR | 10 | * |
GRANT_NBR | ✔ | Grant | GM_GRANT_NBR | CHAR | 20 | |
POSNR | ✔ | Item Number Legacy Data Transfer | TPM_TRDT_POSNR | NUMC | 8 | |
POSITION_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | TCURC | |
VALUATION_CURR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | TCURC | |
ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | TPM_ACTIVE_PASSIVE | CHAR | 1 | ||
VAL_TI_PC | Security Valuation in Position Currency | TPM_VAL_TI_PC | CURR | 21 | ||
VAL_TI_VC | Security Valuation in Valuation Currency | TPM_VAL_TI_VC | CURR | 21 | ||
VAL_TI_IDX_CLEAN | Security Valuation, Index-Clean, in Position Currency | TPM_VAL_TI_IDX_CLEAN | CURR | 21 | ||
VAL_FX_VC | Foreign Currency Valuation in Valuation Currency | TPM_VAL_FX_VC | CURR | 21 | ||
VAL_IDX_PC | Index Valuation in Position Currency | TPM_VAL_IDX_PC | CURR | 21 | ||
VAL_IDX_VC | Index Valuation in Valuation Currency | TPM_VAL_IDX_VC | CURR | 21 | ||
VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | TPM_VAL_CH_TI_PC | CURR | 21 | ||
VAL_CH_TI_VC | Valuation of Cap. Costs, Security, in Valuation Currency | TPM_VAL_CH_TI_VC | CURR | 21 | ||
VAL_CH_TI_IDXCL | Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy | TPM_VAL_CH_TI_IDX_CLEAN | CURR | 21 | ||
VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Valuation Currency | TPM_VAL_CH_FX_VC | CURR | 21 | ||
VAL_AAV_FX_VC | FX Valuation of Amort.Acquisition Value in Valuation Crcy | TPM_VAL_AAV_FX_VC | CURR | 21 | ||
IMPAIRMENT_PC | Impairment in Position Currency | TPM_IMPAIRMENT_PC | CURR | 21 | ||
IMPAIRMENT_VC | Impairment in Valuation Currency | TPM_IMPAIRMENT_VC | CURR | 21 | ||
IMPMT_IDX_CLEAN | Impairment in Position Currency Index-Clean | TPM_IMPAIRMENT_IDX_CLEAN | CURR | 21 | ||
IMPAIRMENT_FX_VC | FX Impairment in Valuation Currency | TPM_IMPAIRMENT_FX_VC | CURR | 21 | ||
AMORT_PC | Amortization in Position Currency | TPM_AMORT_PC | CURR | 21 | ||
AMORT_VC | Amortization in Valuation Currency | TPM_AMORT_VC | CURR | 21 | ||
AMORT_IDX_CLEAN | Amortization, Index-Clean, in Position Currency | TPM_AMORT_IDX_CLEAN | CURR | 21 | ||
AMORT_NEG_SPR_PC | Amortization of Negotiation Spread in Position Currency | TPM_AMORT_NEG_SPREAD_PC | CURR | 21 | ||
AMORT_NEG_SPR_VC | Amortization of Negotiation Spread in Valuation Currency | TPM_AMORT_NEG_SPREAD_VC | CURR | 21 | ||
AM_NEG_SPR_IDXCL | Amortiz. of Negotiation Spread in Position Crcy Index-Clean | TPM_AMORT_NEG_SPREAD_IDX_CLEAN | CURR | 21 | ||
DISAGIO_PC | Discount/Premium in Position Currency | TPM_DISAGIO_PC | CURR | 21 | ||
DISAGIO_VC | Discount/Premium in Valuation Currency | TPM_DISAGIO_VC | CURR | 21 | ||
DISAGIO_IDXCL | Index-Clean Discount/Premium in Position Currency | TPM_DISAGIO_IDX_CLEAN | CURR | 21 | ||
VAL_TI_PC_NPL | Securities Valuation Not Affecting P/L in Position Currency | TPM_VAL_TI_PC_NPL | CURR | 21 | ||
VAL_TI_VC_NPL | Securities Valuation Not Affecting P/L in Valuation Currency | TPM_VAL_TI_VC_NPL | CURR | 21 | ||
VAL_IT_IDXCL_NPL | Securities Val. Not Affecting P/L in Pos. Crcy Index Clean | TPM_VAL_TI_IDXCL_NPL | CURR | 21 | ||
VAL_FX_VC_NPL | Forex Valuation Not Affecting P/L in Valuation Currency | TPM_VAL_FX_VC_NPL | CURR | 21 | ||
VAL_IDX_PC_NPL | Index Valuation Not Affecting P/L in Position Currency | TPM_VAL_IDX_PC_NPL | CURR | 21 | ||
VAL_IDX_VC_NPL | Index Valuation Not Affecting P/L in Valuation Currency | TPM_VAL_IDX_VC_NPL | CURR | 21 | ||
VAL_CH_TI_PC_NPL | Security Costs Valuation Not Affecting P/L in Position Crcy | TPM_VAL_CH_TI_PC_NPL | CURR | 21 | ||
VAL_CH_TI_VC_NPL | Security Costs Valuation Not Affecting P/L in Valuation Crcy | TPM_VAL_CH_TI_VC_NPL | CURR | 21 | ||
VAL_CHTIIDXCLNPL | Security Costs Val. Not Affecting P/L in PosCrcy Index Clean | TPM_VAL_CH_TI_IDXCL_NPL | CURR | 21 | ||
VAL_CH_FX_VC_NPL | Forex Costs Valuation Not Affecting P/L in Valuation Crcy | TPM_VAL_CH_FX_VC_NPL | CURR | 21 | ||
ACC_INT_PC | Accrued Interest in Position Currency | TPM_ACC_INTEREST_PC | CURR | 21 | ||
ACC_INT_VC | Accrued Interest in Valuation Currency | TPM_ACC_INTEREST_VC | CURR | 21 | ||
ACC_INT_IDXCL | Accrued Interest in Position Currency Index-Clean | TPM_ACC_INTEREST_IDX_CLEAN | CURR | 21 | ||
NGSPR_PC | Negotiation Spread in Position Currency | TPM_NGSPR_PC | CURR | 21 | ||
NGSPR_VC | Negotiation Spread in Valuation Currency | TPM_NGSPR_VC | CURR | 21 | ||
NGSPR_IDXCL | Negotiation Spread Index Clean | TPM_NGSPR_IDXCL | CURR | 21 | ||
ACCR_PC | Accrual/Deferral in Position Currency | TPM_ACCR_PC | CURR | 21 | ||
ACCR_VC | Accrual/Deferral in Valuation Currency | TPM_ACCR_VC | CURR | 21 | ||
ACCR_IDX_CLEAN | Accrual/Deferral (1) Index Clean in Position Currency | TPM_ACCR_IDX_CLEAN | CURR | 21 | ||
ACCR2_PC | Accrual/Deferral (2) in Position Currency | TPM_ACCR2_PC | CURR | 21 | ||
ACCR2_VC | Accrual/Deferral (2) in Valuation Currency | TPM_ACCR2_VC | CURR | 21 | ||
ACCR2_IDX_CLEAN | Accrual/Deferral (2) Index Clean in Position Currency | TPM_ACCR2_IDX_CLEAN | CURR | 21 | ||
RESET_VAL | Valuation with Reset | TPM_TRDT_RESET_VAL | CHAR | 1 | ||
RESET_AMORT | Amortization with Reset | TPM_TRDT_RESET_AMORT | CHAR | 1 | ||
RESET_ACCR | Accrual/Deferral with Reset | TPM_TRDT_RESET_ACCR | CHAR | 1 | ||
RESET_KEY_DATE | Key Date for Reset within Legacy Data Transfer | TPM_TRDT_RESET_KEYDATE | DATS | 8 | ||
RESET_IMP | Impairment with Reset | TPM_TRDT_RESET_IMP | CHAR | 1 | ||
DEAL_NUMBER | Financial Transaction | TB_RFHA | CHAR | 13 | * | |
BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | ||
TRANS_FLG | Flag: Legacy Data Transferred | TPM_TRDT_TRANS_FLG | CHAR | 1 | ||
HAMORT_PC | Hedge Amortization in Position Currency | FTI_HAMORT_PC | CURR | 21 | ||
HAMORT_IDXCL_PC | Hedge Amortization in Position Crcy, Index-Clean | FTI_HAMORT_INDX_PC | CURR | 21 | ||
HAMORT_VC | Hedge Amortization in Valuation Currency | FTI_HAMORT_VC | CURR | 21 | ||
HADJ_PC | Hedge Adjustment in Position Currency | FTI_HADJ_PC | CURR | 21 | ||
HADJ_IDXCL_PC | Hedge Adjustment in Position Currency, Index-Clean | FTI_HADJ_INDX_PC | CURR | 21 | ||
HADJ_VC | Hedge Adjustment in Valuation Currency | FTI_HADJ_VC | CURR | 21 | ||
EFF_PC | Effective Amount in Position Currency | FTI_EFFECTIVE_PC | CURR | 21 | ||
EFF_VC | Effective Amount in Valuation Currency | FTI_EFFECTIVE_VC | CURR | 21 | ||
EFF_IDXCL_PC | Effective Amount in Position Currency, Index Clean | FTI_EFFECTIVE_IDXCL_PC | CURR | 21 | ||
INEFF_PC | Ineffective Amount in Position Currency | FTI_INEFFECTIVE_PC | CURR | 21 | ||
INEFF_VC | Ineffective Amount in Valuation Currency | FTI_INEFFECTIVE_VC | CURR | 21 | ||
INEFF_IDXCL_PC | Ineffective Amount in Position Currency, Index Clean | FTI_INEFFECTIVE_IDXCL_PC | CURR | 21 | ||
EFFD_PC | Effective Amount (Dormant) in Position Currency | FTI_EFFECTIVE_DORMANT_PC | CURR | 21 | ||
EFFD_VC | Effective Amount (Dormant) in Valuation Currency | FTI_EFFECTIVE_DORMANT_VC | CURR | 21 | ||
EFFD_IDXCL_PC | Effective Amount (Dormant) in Position Currency, Index-Clean | FTI_EFFECTIVE_DORMANT_IDXCL_PC | CURR | 21 | ||
INEFFD_PC | Ineffective Amount (Dormant) in Position Currency | FTI_INEFFECTIVE_DORMANT_PC | CURR | 21 | ||
INEFFD_VC | Ineffective Amount (Dormant) in Valuation Currency | FTI_INEFFECTIVE_DORMANT_VC | CURR | 21 | ||
INEFFD_IDXCL_PC | Ineffective Amount (Dormant) in Position Currency, Index-Cln | FTI_INEFF_DORMANT_IDXCL_PC | CURR | 21 | ||
ORIG_VAD_PC | Original Value Adjustment in Position Currency | FTI_ORIG_VAD_PC | CURR | 21 | ||
ORIG_VAD_VC | Original Value Adjustment in Valuation Currency | FTI_ORIG_VAD_VC | CURR | 21 | ||
VAD_GAIN_PC | Value Adjustment of Gains in Position Currency | FTI_VAD_GAIN_PC | CURR | 21 | ||
VAD_GAIN_VC | Value Adjustment of Gains in Valuation Currency | FTI_VAD_GAIN_VC | CURR | 21 | ||
VAD_LOSS_PC | Value Adjustment of Losses in Position Currency | FTI_VAD_LOSS_PC | CURR | 21 | ||
VAD_LOSS_VC | Value Adjustment of Losses in Valuation Currency | FTI_VAD_LOSS_VC | CURR | 21 |