T045G

Bank charges table for bill of exchange presentation | #other | Component: Basic Functions
Column Name Description
MANDT FK Client
BUKRS FK Company Code
HBKID FK House bank ID
HKTID FK ID for Account Details
WVERW Bill/Exchange Usage Indicator for the B/Exch. Usage Posting Show values
CASES Charge Types
ZLSCH FK Payment Method
WAERS FK Currency Key
GRBTR Minimum amount as from which a charge rate is used
GRTAG Remaining term as from which the charge is to be calculated
VALID Charge Is Valid as from This Date
Column Name Description
💲 Currency Key (WAERS):
MIBTR Minimum Amount
MIBTD Minimum amount (DME)
GEBTR Fixed Amount
GEBTD Fixed amount (DME)
Column Name Description
Column Name Description
VALID Charge Is Valid as from This Date
Column Name Description
WVERW Bill/Exchange Usage Indicator for the B/Exch. Usage Posting Show values
WEPRI Charge Is Relevant for Printing Bills of Exchange Show values
CALTY Usage Type of the Charges Rate Show values
Column Name Description Domain name
MIZIT Minimum days for calculating charges NUMC3
GSATZ Charge in the form of a percentage rate GSATZ_045G
GSATD Charge in the form of a percentage rate (DME) GSATZ_045G
Master Data Relations Join Conditions
Existence of Company Code
  • T045G.MANDT == T001.MANDT
  • T045G.BUKRS == T001.BUKRS
Existence of House Bank
  • House bank ID
  • Company Code
  • T045G.MANDT == T012.MANDT
  • T045G.HBKID == T012.HBKID
  • T045G.BUKRS == T012.BUKRS
Existence of House Bank Account
  • Company Code
  • ID for Account Details
  • Client
  • House bank ID
  • T045G.BUKRS == T012K.BUKRS
  • T045G.HKTID == T012K.HKTID
  • T045G.MANDT == T012K.MANDT
  • T045G.HBKID == T012K.HBKID
Existence of Client T045G.MANDT == T000.MANDT
Existence of Currency
  • T045G.MANDT == TCURC.MANDT
  • T045G.WAERS == TCURC.WAERS
Existence of Payment Method
  • Payment Method
  • ?
  • T045G.MANDT == T042Z.MANDT
  • T045G.ZLSCH == T042Z.ZLSCH
  • T045G.[column in domain "LAND1"] == T042Z.LAND1