VDAUSZ

Drawings on Disbursement | #transactional | #language | Component: Loans Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RANL Contract Number
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
NTRANS Transaction data key: Consecutive number
NVERF Disposal number within an outpayment
Column Name Description
💲 Settlement Currency (SCWHR):
VCBTR Drawing Amount from Disbursement
💲 Currency Key (T001.WAERS):
BHWHR Amount in local currency
Column Name Description
Column Name Description
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DDISPO Payment Date (Drawing)
Column Name Description
STKZU Liable for VAT Show values
STKZN Natural Person Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
DTAMS Report key for data medium exchange Show values
XCPDK Indicator: Is the account a one-time account? Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SBEWART Flow Type SBEWART
SANLF Product Category VVSANLF
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
PSTLZ Postal Code PSTLZ
ORT01 City TEXT35
STRAS Street and House Number TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
PSKTO PO Bank Current Acct No. or Building Society Ref. No. PSKTO
BANKN Bank account number BANKN
BANKL Bank Number BANKL
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
BKONT Bank Control Key BKONT
BKREF Reference Details for Bank Details CHAR20
EMPFG Payment Recipient Code EMPFG
PARTNR Business Partner Number BU_PARTNER
SGTXT Item Text TEXT50
BVTYP Partner bank type BVTYP
SPRAS Language Key SPRAS
ANRED Title TEXT15
BUKRS_REPLACE Company Code BUKRS
RANL_REPLACE Contract Number RANL
RBO Business Operation Number (Loans) RBO
REMIT_INFO Payment Notes Info T_REMIT_INFO_LC
IBAN IBAN (International Bank Account Number) CHAR34
TRANSID SEPA Transaction ID
POREF SEPA Reference Field (Payment Engine)
PIREF SEPA Reference Field (Payment Engine)
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • VDAUSZ.BANKS == T005.LAND1
  • VDAUSZ.MANDT == T005.MANDT
Company Code
  • VDAUSZ.MANDT == T001.MANDT
  • VDAUSZ.BUKRS == T001.BUKRS
Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • Instruction Key for Data Medium Exchange
  • Client
  • Payment Method
  • VDAUSZ.BANKS == T015W.BANKS
  • VDAUSZ.DTAWS == T015W.DTAWS
  • VDAUSZ.MANDT == T015W.MANDT
  • VDAUSZ.ZLSCH == T015W.ZLSCH
Country/Region Key
  • Country/Region Key
  • Client
  • VDAUSZ.LAND1 == T005.LAND1
  • VDAUSZ.MANDT == T005.MANDT
Client VDAUSZ.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • VDAUSZ.MANDT == T005S.MANDT
  • VDAUSZ.LAND1 == T005S.LAND1
  • VDAUSZ.REGIO == T005S.BLAND
CML SEPA return codes
  • CML SEPA return codes
  • Client
CML: SEPA Return Reason
Currency table
  • VDAUSZ.MANDT == TCURC.MANDT
  • VDAUSZ.SCWHR == TCURC.WAERS
Payment Method
  • Payment Method
  • ?
  • VDAUSZ.MANDT == T042Z.MANDT
  • VDAUSZ.ZLSCH == T042Z.ZLSCH
  • VDAUSZ.[column in domain "LAND1"] == T042Z.LAND1