GRISDET

Summary Table for Insurance (DE) - Rollup | #transactional | Component: Collections/Disbursements
Column Name Description
RCLNT FK Client
RLDNR FK Ledger
RRCTY Record Type Show values
RVERS FK Version
RYEAR Fiscal Year
ROBJNR Object number for objects (account assignment elements)
COBJNR Object number for transaction attributes
SOBJNR Object number for partner objects (accnt assignmnt elements)
RTCUR FK Currency Key
RUNIT FK Base Unit of Measure
DRCRK Debit/Credit Indicator Show values
RPMAX Period
Column Name Description
💲 Currency Key (RTCUR):
TSLVT Balance carried forward in transaction currency
TSL01 Total of transactions of the period in transaction currency
TSL02 Total of transactions of the period in transaction currency
TSL03 Total of transactions of the period in transaction currency
TSL04 Total of transactions of the period in transaction currency
TSL05 Total of transactions of the period in transaction currency
TSL06 Total of transactions of the period in transaction currency
TSL07 Total of transactions of the period in transaction currency
TSL08 Total of transactions of the period in transaction currency
TSL09 Total of transactions of the period in transaction currency
TSL10 Total of transactions of the period in transaction currency
TSL11 Total of transactions of the period in transaction currency
TSL12 Total of transactions of the period in transaction currency
TSL13 Total of transactions of the period in transaction currency
TSL14 Total of transactions of the period in transaction currency
TSL15 Total of transactions of the period in transaction currency
TSL16 Total of transactions of the period in transaction currency
💲 Currency key of currency 2 (T882.CURR1):
HSLVT Balance carried forward in local currency
HSL01 Total of transactions of the period in local currency
HSL02 Total of transactions of the period in local currency
HSL03 Total of transactions of the period in local currency
HSL04 Total of transactions of the period in local currency
HSL05 Total of transactions of the period in local currency
HSL06 Total of transactions of the period in local currency
HSL07 Total of transactions of the period in local currency
HSL08 Total of transactions of the period in local currency
HSL09 Total of transactions of the period in local currency
HSL10 Total of transactions of the period in local currency
HSL11 Total of transactions of the period in local currency
HSL12 Total of transactions of the period in local currency
HSL13 Total of transactions of the period in local currency
HSL14 Total of transactions of the period in local currency
HSL15 Total of transactions of the period in local currency
HSL16 Total of transactions of the period in local currency
💲 Currency key of currency 3 (T882.CURR2):
KSLVT Balance carried forward in group currency
KSL01 Total of transactions of the period in group currency
KSL02 Total of transactions of the period in group currency
KSL03 Total of transactions of the period in group currency
KSL04 Total of transactions of the period in group currency
KSL05 Total of transactions of the period in group currency
KSL06 Total of transactions of the period in group currency
KSL07 Total of transactions of the period in group currency
KSL08 Total of transactions of the period in group currency
KSL09 Total of transactions of the period in group currency
KSL10 Total of transactions of the period in group currency
KSL11 Total of transactions of the period in group currency
KSL12 Total of transactions of the period in group currency
KSL13 Total of transactions of the period in group currency
KSL14 Total of transactions of the period in group currency
KSL15 Total of transactions of the period in group currency
KSL16 Total of transactions of the period in group currency
Column Name Description
📏 Base Unit of Measure (RUNIT):
MSLVT Balance carried forward of quantity
MSL01 Total of the transactions of period in units of measure
MSL02 Total of the transactions of period in units of measure
MSL03 Total of the transactions of period in units of measure
MSL04 Total of the transactions of period in units of measure
MSL05 Total of the transactions of period in units of measure
MSL06 Total of the transactions of period in units of measure
MSL07 Total of the transactions of period in units of measure
MSL08 Total of the transactions of period in units of measure
MSL09 Total of the transactions of period in units of measure
MSL10 Total of the transactions of period in units of measure
MSL11 Total of the transactions of period in units of measure
MSL12 Total of the transactions of period in units of measure
MSL13 Total of the transactions of period in units of measure
MSL14 Total of the transactions of period in units of measure
MSL15 Total of the transactions of period in units of measure
MSL16 Total of the transactions of period in units of measure
Column Name Description
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
Column Name Description Domain name
RACCT Account Number SAKNR
RCNTR Cost Center KOSTL
RASSC Company ID of Trading Partner RCOMP
ANLN1 Main Asset Number ANLN1
STAGR Statistical key figure STAGR
SJAHR_VX Year of loss SJAHR_VX
MJAHR_VX Reporting Year MJAHR_VX
BSART_VX In-Force Business Type BSART_VX
SDART_VX Type of Loss SDART_VX
GSART_VX Business Transaction Type GSART_VX
LNDSL_VX Country/Region Where Risk Is Situated LAND1
BSGRP_VX In-Force Business Group for Pension Funds and Life Insurance BSGRP_VX
SCNTR Partner cost center KOSTL
DISTKEY Distribution Key DISTKEY_VY
Master Data Relations Join Conditions
Distribution key for currency amounts
  • Distribution key for currency amounts
  • Client
  • GRISDET.CSPRED == T821S.SPRED
  • GRISDET.RCLNT == T821S.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • GRISDET.LAND1 == T005.LAND1
  • GRISDET.RCLNT == T005.MANDT
Logical system GRISDET.LOGSYS == TBDLS.LOGSYS
Distribution key for quantities
  • Distribution key for quantities
  • Client
  • GRISDET.QSPRED == T821S.SPRED
  • GRISDET.RCLNT == T821S.MANDT
Organizational area - insurance
  • Company Code
  • Organizational area - insurance
Company Code
  • GRISDET.RCLNT == T001.MANDT
  • GRISDET.RBUKRS == T001.BUKRS
Business Area
  • GRISDET.RCLNT == TGSB.MANDT
  • GRISDET.RBUSA == TGSB.GSBER
Client GRISDET.RCLNT == T000.MANDT
Insurance Functional Area
  • Company Code
  • Insurance Functional Area
  • Client
Underwriting Type
  • Underwriting Type
  • Client
  • Company Code
Ledger
  • Ledger
  • Client
  • GRISDET.RLDNR == T881.RLDNR
  • GRISDET.RCLNT == T881.MANDT
Transaction type
  • GRISDET.RCLNT == T856.MANDT
  • GRISDET.RMVCT == T856.TRTYP
Risk type
  • Company Code
  • Risk type
Currency Key
  • GRISDET.RCLNT == TCURC.MANDT
  • GRISDET.RTCUR == TCURC.WAERS
Base Unit of Measure
  • GRISDET.RCLNT == T006.MANDT
  • GRISDET.RUNIT == T006.MSEHI
Version
  • Ledger
  • Client
  • Version
  • GRISDET.RLDNR == T894.RLDNR
  • GRISDET.RCLNT == T894.MANDT
  • GRISDET.RVERS == T894.RVERS
Insurance Type
  • Company Code
  • Insurance Type
Trading Partner Business Area of the Business Partner
  • GRISDET.RCLNT == TGSB.MANDT
  • GRISDET.SBUSA == TGSB.GSBER