DPAYP

Payment program - data on paid item | #transactional | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT FK Client
LAUFD Date ID
LAUFI Identification for the payment run
ORIGN Source of the payment data Show values
XVORL Indicator: Only Proposal Run? Show values
PAYNO Sequential payment number
SUBNO Additional distinguishing criterion from payments
DOC2T Category for paid document Show values
DOC2R Reference to Paid Document
Column Name Description
💲 Currency Key (WAERS):
BETRW Amount in Transaction Currency with +/- Sign
AUGBH Clearing amount in local currency with +/- sign
AUGBW Clearing Amount in Transaction Currency (With +/- Sign)
ASKTH Proportional cash discount in local currency
ASKTW Proportional Cash Discount in Transaction Currency
STTAX Tax Amount as Statistical Information in Document Currency
AQSBW Proportional Withholding Tax Amount In Transaction Currency
AQSBH Proportional Withholding Tax Amount In Local Currency
Column Name Description
Column Name Description
LAUFD Date ID
BLDAT Document Date in Document
BUDAT Posting Date in the Document
FAEDT Due Date of Payment
Column Name Description
ORIGN Source of the payment data Show values
XVORL Indicator: Only Proposal Run? Show values
DOC2T Category for paid document Show values
GPA2T Category of business partner making a payment Show values
ACC1T Contract Account Category Show values
VOR1T Activity type Show values
VOR2T Activity type Show values
REF1T Reference information type Show values
REF2T Reference information type Show values
REF3T Reference information type Show values
STAKZ Type of statistical item Show values
SUBAP Subapplication in Contract Accounts Receivable and Payable Show values
Column Name Description Domain name
GPA2R Reference to Business Partner Giving Payment Instruction CHAR12
ACC1R Reference to Contract Account CHAR18
VOR1R Reference to Main Transaction CHAR4
VOR2R Reference to Subtransaction CHAR4
TXT1T Long text type CHAR02
TXT1R Long text reference CHAR30
NAME1 Name 1 TEXT40
ORT01 City TEXT40
SKTPA Accepted cash discount rate PRZ23
BUKRS Company Code BUKRS
GSBER Business Area GSBER
C4EYE Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK
OPTXT Item Text TEXT50
REF1R Reference information CHAR40
REF2R Reference information CHAR40
REF3R Reference information CHAR40
VTREF Reference Specifications from Contract VTREF_KK
VTPOS Contract: Item Number VTPOS_KK
VTRE2 Reference Specifications from Contract VTREF_KK
STCD1 Tax Number 1 STCD1
QSSKZ Withholding Tax Code QSSKZ
VKBEZ Contract account name TEXT35
EXVKO Reference number for business partner CHAR25
STXTACT Text for Transaction TEXT10
OPBUK Company Code for Automatic Payment Transactions BUKRS
BLART Document Type BLART_KK
SPART Division SPART
VTEXT Name TEXT20
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • ?
  • DPAYP.MANDT == ADRC.CLIENT
  • DPAYP.ADRNR == ADRC.ADDRNUMBER
  • DPAYP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • DPAYP.[column in domain "AD_NATION"] == ADRC.NATION
Clearing Lock Reason
  • Clearing Lock Reason
  • Client
Country/Region Key
  • Country/Region Key
  • Client
  • DPAYP.LAND1 == T005.LAND1
  • DPAYP.MANDT == T005.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • DPAYP.LANDL == T005.LAND1
  • DPAYP.MANDT == T005.MANDT
State Central Bank Indicator
  • DPAYP.MANDT == T015L.MANDT
  • DPAYP.LZBKZ == T015L.LZBKZ
Client DPAYP.MANDT == T000.MANDT
Item indicator in payment program DPAYP.POKEN == TFKPK.POKEN
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • DPAYP.MANDT == T005S.MANDT
  • DPAYP.LAND1 == T005S.LAND1
  • DPAYP.REGIO == T005S.BLAND
Currency Key
  • DPAYP.MANDT == TCURC.MANDT
  • DPAYP.WAERS == TCURC.WAERS
Lock Reason for Automatic Payment