VTBSTC1

Components of Payment Details for Standing Instruction | #masterdata | Component: Business Partner
Column Name Description
MANDT FK Client
PARTNR Business Partner Number
BUKRS FK Company Code
WAERS FK Currency Key
ZAHLVID Identification of Payment Details (Standing Instructions)
Column Name Description
Column Name Description
Column Name Description
DCRDAT Entered On
TCRTIM Entry Time
DUPDAT Changed On
TUPTIM Time Changed
Column Name Description
SZART Payment Transaction Show values
SPAYRQ Generate Payment Request Show values
SPRSNG Individual Payment Show values
SPRGRD Determine Grouping Definition Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
Column Name Description Domain name
BVTYP Partner Bank Details BVTYP
RPZAHL Payer/Payee BU_PARTNER
ZWELS List of Respected Payment Methods ZWELS
CRUSER Entered By SYCHAR12
UPUSER Last Changed By SYCHAR12
Master Data Relations Join Conditions
Company Code Foreign Key
  • VTBSTC1.MANDT == T001.MANDT
  • VTBSTC1.BUKRS == T001.BUKRS
Foreign key for house bank ID
  • Short Key for a House Bank
  • Company Code
  • VTBSTC1.MANDT == T012.MANDT
  • VTBSTC1.HBKID == T012.HBKID
  • VTBSTC1.BUKRS == T012.BUKRS
Foreign key for house bank account ID
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • VTBSTC1.BUKRS == T012K.BUKRS
  • VTBSTC1.HKTID == T012K.HKTID
  • VTBSTC1.MANDT == T012K.MANDT
  • VTBSTC1.HBKID == T012K.HBKID
Foreign key: client VTBSTC1.MANDT == T000.MANDT
Repetitive Code
  • Short Key for a House Bank
  • Repetitive Code
  • Company Code
Foreign key for payment method supplement
  • VTBSTC1.MANDT == T042F.MANDT
  • VTBSTC1.UZAWE == T042F.UZAWE
Foreign key: currency
  • VTBSTC1.MANDT == TCURC.MANDT
  • VTBSTC1.WAERS == TCURC.WAERS
Foreign key for payment method
  • Payment Method
  • ?
  • VTBSTC1.MANDT == T042Z.MANDT
  • VTBSTC1.ZLSCH == T042Z.ZLSCH
  • VTBSTC1.[column in domain "LAND1"] == T042Z.LAND1