DPAYP SAP (Payment program - data on paid item) Table details
Dictionary Type: Table
Description: Payment program - data on paid item
Description: Payment program - data on paid item
Table field list including key, data, relationships and ABAP select examples
DPAYP is a standard SAP Table which is used to store Payment program - data on paid item data and is available within R/3 SAP systems depending on the version and release level.
The DPAYP table consists of various fields, each holding specific information or linking keys about Payment program - data on paid item data available in SAP. These include LAUFD (Date ID), LAUFI (Identification for the payment run), ORIGN (Source of the payment data), XVORL (Indicator: Only Proposal Run?).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DPAYP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
LAUFD | Date ID | LAUFD_KK | DATS | 8 | DATUM | ||||
LAUFI | Identification for the payment run | LAUFI_PAY | CHAR | 5 | LAUFI_PAY | ||||
ORIGN | Source of the payment data | ORIGN_PAY | CHAR | 1 | LAUFK_F110 | ||||
XVORL | Indicator: Only Proposal Run? | XVORL | CHAR | 1 | XFELD | ||||
PAYNO | Sequential payment number | PAYNO_PAY | INT4 | 10 | INT4_NOS | ||||
SUBNO | Additional distinguishing criterion from payments | SUBNO_PAY | CHAR | 6 | CHAR6 | ||||
DOC2T | Category for paid document | DOC2T_PAY | CHAR | 2 | DOCTP_PAY | ||||
DOC2R | Reference to Paid Document | DOC2R_PAY | CHAR | 24 | CHAR24 | ||||
GPA2T | Category of business partner making a payment | GPA2T_PAY | CHAR | 2 | GPATP_PAY | ||||
GPA2R | Reference to Business Partner Giving Payment Instruction | GPA2R_PAY | CHAR | 12 | CHAR12 | ||||
ACC1T | Contract Account Category | ACC1T_PAY | CHAR | 2 | ACCTP_PAY | ||||
ACC1R | Reference to Contract Account | ACC1R_PAY | CHAR | 18 | CHAR18 | ||||
VOR1T | Activity type | VOR1T_PAY | CHAR | 2 | VORTP_PAY | ||||
VOR1R | Reference to Main Transaction | VOR1R_PAY | CHAR | 4 | CHAR4 | ||||
VOR2T | Activity type | VOR1T_PAY | CHAR | 2 | VORTP_PAY | ||||
VOR2R | Reference to Subtransaction | VOR2R_PAY | CHAR | 4 | CHAR4 | ||||
TXT1T | Long text type | TXT1T_PAY | CHAR | 2 | CHAR02 | ||||
TXT1R | Long text reference | TXT1R_PAY | CHAR | 30 | CHAR30 | ||||
ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
ORT01 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
FAEDT | Due Date of Payment | FAEDT_F110 | DATS | 8 | DATUM | ||||
SKTPA | Accepted cash discount rate | SKTPA_KK | DEC | 5(3) | PRZ23 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
AUGBH | Clearing amount in local currency with +/- sign | AUGBH_KK | CURR | 13(2) | WRTV7 | ||||
AUGBW | Clearing Amount in Transaction Currency (With +/- Sign) | AUGBW_KK | CURR | 13(2) | WRTV7 | ||||
ASKTH | Proportional cash discount in local currency | ASKTH_KK | CURR | 13(2) | WRTV7 | ||||
ASKTW | Proportional cash discount in transaction currency | ASKTW_KK | CURR | 13(2) | WRTV7 | ||||
POKEN | Item indicator in payment program | POKEN_PAY | NUMC | 3 | TFKPK | POKEN_PAY | |||
ZLSPR | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
CLRLO | Clearing Lock Reason | CLRLO_KK | CHAR | 1 | TFK004B | SPPOS_KK | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | C4EYE_KK | CHAR | 2 | Assigned to domain | C4EYE_KK | |||
OPTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
REF1T | Reference information type | REFIT_PAY | CHAR | 2 | REFIT_PAY | ||||
REF1R | Reference information | REFIN_PAY | CHAR | 40 | CHAR40 | ||||
REF2T | Reference information type | REFIT_PAY | CHAR | 2 | REFIT_PAY | ||||
REF2R | Reference information | REFIN_PAY | CHAR | 40 | CHAR40 | ||||
REF3T | Reference information type | REFIT_PAY | CHAR | 2 | REFIT_PAY | ||||
REF3R | Reference information | REFIN_PAY | CHAR | 40 | CHAR40 | ||||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
VTPOS | Contract: Item Number | VTPOS_KK | NUMC | 6 | VTPOS_KK | ||||
VTRE2 | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
AQSBW | Proportional Withholding Tax Amount In Transaction Currency | AQSBW_KK | CURR | 13(2) | WRTV7 | ||||
AQSBH | Proportional Withholding Tax Amount In Local Currency | AQSBH_KK | CURR | 13(2) | WRTV7 | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA |
Key field | Non-key field |
How do I retrieve data from SAP table DPAYP using ABAP code
The following ABAP code Example will allow you to do a basic selection on DPAYP to SELECT all data from the tableDATA: WA_DPAYP TYPE DPAYP.
SELECT SINGLE *
FROM DPAYP
INTO CORRESPONDING FIELDS OF WA_DPAYP
WHERE...
How to access SAP table DPAYP
Within an ECC or HANA version of SAP you can also view further information about DPAYP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects