C_CASecurityDepositMgmtTP

Security Deposit Management | view: CCASCRTYDEPTP | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: FKK_SEC_REQ, DFKKCOH, DFKKOP, DFKKIA, CDHDR, ADCP, ADRC, BUT020, BUT021_FS, BUT000, TFK001G, TFK056A, TFK056T, FKKVKP, FKK_SEC, FKK_SEC_C, TFK_SEC_REASON_T, TFK_SEC_REV_T, T001, TKA02, FKKVK, FKKVKP, T005, T005T, USR21, BUT021_FS, TB008S, TB008U
Column Name Description
CASecurityDeposit Security Deposit
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CASecurityDepositRequestAmount Requested Amount for Security Deposit
CAReversedAmtInTransCurrency Reversed Amount
💲 Payment Currency Key (PaymentCurrency):
CAReleasedAmtInPaymentCurrency Released Amount of Cash Security Deposit
CAPaymentAmountInPaytCurrency Cash security deposit payment
CAInterestAmtInPaymentCurrency Cash Security Deposit Interest
💲 Return Currency (RefundCurrency):
AmountInRefundCurrency Returned Amount
Column Name Description
Column Name Description
CASecurityDepositStartDate Start date for security deposit
CASecurityDepositReturnDate Return Date for Security Deposit
CreationDate Date on which the record was created
LastChangedDate Last Changed On
Column Name Description
CACashSecurityDepositStatus Cash security deposit status Show values
CASecurityDepositIsReversed Security Deposit Reversed Show values
CASecurityDepositIsReleased Security Deposits Were Released Show values
CASecurityDepositEditIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepCorrespncIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CACorrespncCreationIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepositReqIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepPrtlRelIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepFullRelIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepAddReqDocIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepClearIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepResetRelIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CASecurityDepReverseIsHidden Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
CASecurityDepositReqReasonText Text, Length 40 TEXT40
CACashSecurityDepositStatusTxt Status Text of Security Deposit C_STATUS_TEXT_KK
CASecurityDepStatusCriticality null
BusinessPartnerFullName Character String - 128 User-Defined Characters CHAR0128
HouseNumber Street/House Number TEXT70
HomeTown Postal Code/City TEXT50
CountryName Country/Region Name TEXT50
ContractAccountName Description of Contract Account TEXT35
CAContract Reference Specifications from Contract VTREF_KK
CAContractSemanticObject Semantic Object for Contract TEXT30
CASecurityDepositRvslRsnText Text, Length 40 TEXT40
CASecurityDepositExtReference External Reference Number of Security Deposit CHAR35
CASecurityDepReqAmtCriticality null
CAPaymentFormNumber Payment Form Number NRZAS_KK
CAInterestCodeName Interest Key Description TEXT30
CAScrtyDepCreationDteTme Creation Time in User Timezone TZNTSTMPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserDescription User Description SUIDTECHDESC
CAScrtyDepLastChangeDteTme Last Change Time in User Timezone TZNTSTMPL
LastChangedByUser Changed By XUBNAME
LastChangedByUserDescription User Description SUIDTECHDESC
CACorrespondence Correspondence key COKEY_KK
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • C_CASECURITYDEPOSITMGMTTP.MANDT == BUT000.CLIENT
  • C_CASECURITYDEPOSITMGMTTP.BUSINESSPARTNER == BUT000.PARTNER
Authorization Group
  • Client
  • ?
  • Authorization Group
  • C_CASECURITYDEPOSITMGMTTP.MANDT == TFK_BEGRU.CLIENT
  • C_CASECURITYDEPOSITMGMTTP.[column in domain "BGOBJ_KK"] == TFK_BEGRU.BGOBJ
  • C_CASECURITYDEPOSITMGMTTP.CAAUTHORIZATIONGROUP == TFK_BEGRU.BEGRU
Interest Key
  • Client
  • Interest Key
  • C_CASECURITYDEPOSITMGMTTP.MANDT == TFK056A.MANDT
  • C_CASECURITYDEPOSITMGMTTP.CAINTERESTCODE == TFK056A.IKEY
Reason for Requesting a Security Deposit
  • Client
  • Reason for Requesting a Security Deposit
Reversal reason for security deposit
  • Client
  • Reversal reason for security deposit
  • C_CASECURITYDEPOSITMGMTTP.MANDT == TFK_SEC_REV.MANDT
  • C_CASECURITYDEPOSITMGMTTP.CASECURITYDEPOSITREVERSALRSN == TFK_SEC_REV.REV_REASON
Contract Account Number
  • Client
  • Contract Account Number
  • C_CASECURITYDEPOSITMGMTTP.MANDT == FKKVK.MANDT
  • C_CASECURITYDEPOSITMGMTTP.CONTRACTACCOUNT == FKKVK.VKONT
Country key
  • Country/Region Description
  • Client
  • C_CASECURITYDEPOSITMGMTTP.COUNTRY == T005.LAND1
  • C_CASECURITYDEPOSITMGMTTP.MANDT == T005.MANDT
Transaction Currency
  • Client
  • Payment Currency Key
  • Transaction Currency
  • C_CASECURITYDEPOSITMGMTTP.MANDT == TCURC.MANDT
  • C_CASECURITYDEPOSITMGMTTP.PAYMENTCURRENCY == TCURC.WAERS
  • C_CASECURITYDEPOSITMGMTTP.TRANSACTIONCURRENCY == TCURC.WAERS