C_BankGuaranteeOverviewQry

Bank Guarantee Overview - Query | view: CBKOVERVIEWQRY | Extraction: Not supported | Component: Treasury and Risk Management
Column Name Description
FinancialInstrProductCategory FK Product Category
FinancialInstrumentProductType FK Product Type
FinancialInstrTransactionType FK Financial Transaction Type
CompanyCode FK Company Code
FinancialTransaction FK Financial Transaction
Counterparty Counterparty number
FinInstrTransactionCategory FK Transaction Category
FinInstrConditionLogicGroup Condition Group
Column Name Description
💲 Display Currency (DisplayCurrency):
NominalAmountInNominalCurrency null
FeeAmountInTransactionCrcy Financial Position Amount In Transaction Currency
NominalAmountInDisplayCurrency Nominal Amount in Display Currency
FeeAmountInDisplayCurrency Fee Amount in Display Currency
EstimatedFeeAmtInDisplayCrcy Estimated Fee Amount in Display Currency
Column Name Description
Column Name Description
Column Name Description
InterestCalculationType Interest Calculation Type Show values
VolumeIsCounted Indicator whether transaction has valid condition Show values
ConditionIsValid Indicator whether transaction has valid condition Show values
Column Name Description Domain name
ConditionPercentageRate Percentage rate for condition items DECV3_7
NmbrOfFinancialTransactions Number of Financial Transactions
ExchangeRateType null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_BANKGUARANTEEOVERVIEWQRY.MANDT == T001.MANDT
  • C_BANKGUARANTEEOVERVIEWQRY.COMPANYCODE == T001.BUKRS
Product Category C_BANKGUARANTEEOVERVIEWQRY.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Transaction Type
  • Product Type
  • Client
  • Financial Transaction Type
  • C_BANKGUARANTEEOVERVIEWQRY.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
  • C_BANKGUARANTEEOVERVIEWQRY.MANDT == AT10.MANDT
  • C_BANKGUARANTEEOVERVIEWQRY.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
Product Type
  • Product Type
  • Client
  • C_BANKGUARANTEEOVERVIEWQRY.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
  • C_BANKGUARANTEEOVERVIEWQRY.MANDT == TZPA.MANDT
Financial Transaction
  • Client
  • Company Code
  • Financial Transaction
  • C_BANKGUARANTEEOVERVIEWQRY.MANDT == VTBFHA.MANDT
  • C_BANKGUARANTEEOVERVIEWQRY.COMPANYCODE == VTBFHA.BUKRS
  • C_BANKGUARANTEEOVERVIEWQRY.FINANCIALTRANSACTION == VTBFHA.RFHA
Transaction Category
  • Transaction Category
  • ?
  • C_BANKGUARANTEEOVERVIEWQRY.FININSTRTRANSACTIONCATEGORY == AT01.SFGTYP
  • C_BANKGUARANTEEOVERVIEWQRY.[column in domain "TB_SANLF"] == AT01.SANLFOR
Transaction Currency
  • Client
  • Transaction Currency
  • C_BANKGUARANTEEOVERVIEWQRY.MANDT == TCURC.MANDT
  • C_BANKGUARANTEEOVERVIEWQRY.PAYMENTCURRENCY == TCURC.WAERS