SAP ABAP Table DPAYP (Payment program - data on paid item)
Hierarchy
☛
FI-CA (Software Component) FI-CA
⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷ FKKB (Package) Contract A/R & A/P: Central Objects
⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
⤷ FKKB (Package) Contract A/R & A/P: Central Objects
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | DPAYP | Table Relationship Diagram |
Short Description | Payment program - data on paid item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LAUFD | LAUFD_KK | DATUM | DATS | 8 | 0 | Date ID | ||
3 | LAUFI | LAUFI_PAY | LAUFI_PAY | CHAR | 5 | 0 | Identification for the payment run | ||
4 | ORIGN | ORIGN_PAY | LAUFK_F110 | CHAR | 1 | 0 | Source of the payment data | ||
5 | XVORL | XVORL | XFELD | CHAR | 1 | 0 | Indicator: Only Proposal Run? | ||
6 | PAYNO | PAYNO_PAY | INT4_NOS | INT4 | 10 | 0 | Sequential payment number | ||
7 | SUBNO | SUBNO_PAY | CHAR6 | CHAR | 6 | 0 | Additional distinguishing criterion from payments | ||
8 | DOC2T | DOC2T_PAY | DOCTP_PAY | CHAR | 2 | 0 | Category for paid document | ||
9 | DOC2R | DOC2R_PAY | CHAR24 | CHAR | 24 | 0 | Reference to Paid Document | ||
10 | GPA2T | GPA2T_PAY | GPATP_PAY | CHAR | 2 | 0 | Category of business partner making a payment | ||
11 | GPA2R | GPA2R_PAY | CHAR12 | CHAR | 12 | 0 | Reference to Business Partner Giving Payment Instruction | ||
12 | ACC1T | ACC1T_PAY | ACCTP_PAY | CHAR | 2 | 0 | Contract Account Category | ||
13 | ACC1R | ACC1R_PAY | CHAR18 | CHAR | 18 | 0 | Reference to Contract Account | ||
14 | VOR1T | VOR1T_PAY | VORTP_PAY | CHAR | 2 | 0 | Activity type | ||
15 | VOR1R | VOR1R_PAY | CHAR4 | CHAR | 4 | 0 | Reference to Main Transaction | ||
16 | VOR2T | VOR1T_PAY | VORTP_PAY | CHAR | 2 | 0 | Activity type | ||
17 | VOR2R | VOR2R_PAY | CHAR4 | CHAR | 4 | 0 | Reference to Subtransaction | ||
18 | TXT1T | TXT1T_PAY | CHAR02 | CHAR | 2 | 0 | Long text type | ||
19 | TXT1R | TXT1R_PAY | CHAR30 | CHAR | 30 | 0 | Long text reference | ||
20 | ADRNR | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
21 | NAME1 | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
22 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
23 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
24 | ORT01 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
25 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
26 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
27 | FAEDT | FAEDT_F110 | DATUM | DATS | 8 | 0 | Due Date of Payment | ||
28 | SKTPA | SKTPA_KK | PRZ23 | DEC | 5 | 3 | Accepted cash discount rate | ||
29 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
30 | BETRW | BETRW_KK | WRTV7 | CURR | 13 | 2 | Amount in Transaction Currency with +/- Sign | ||
31 | AUGBH | AUGBH_KK | WRTV7 | CURR | 13 | 2 | Clearing amount in local currency with +/- sign | ||
32 | AUGBW | AUGBW_KK | WRTV7 | CURR | 13 | 2 | Clearing Amount in Transaction Currency (With +/- Sign) | ||
33 | ASKTH | ASKTH_KK | WRTV7 | CURR | 13 | 2 | Proportional cash discount in local currency | ||
34 | ASKTW | ASKTW_KK | WRTV7 | CURR | 13 | 2 | Proportional cash discount in transaction currency | ||
35 | POKEN | POKEN_PAY | POKEN_PAY | NUMC | 3 | 0 | Item indicator in payment program | TFKPK | |
36 | ZLSPR | SPZAH_KK | SPZAH_KK | CHAR | 1 | 0 | Lock Reason for Automatic Payment | TFK008 | |
37 | CLRLO | CLRLO_KK | SPPOS_KK | CHAR | 1 | 0 | Clearing Lock Reason | TFK004B | |
38 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
39 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
40 | C4EYE | C4EYE_KK | C4EYE_KK | CHAR | 2 | 0 | Check Reason for Workflows Acc. to Dual Control Principle | * | |
41 | OPTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
42 | REF1T | REFIT_PAY | REFIT_PAY | CHAR | 2 | 0 | Reference information type | ||
43 | REF1R | REFIN_PAY | CHAR40 | CHAR | 40 | 0 | Reference information | ||
44 | REF2T | REFIT_PAY | REFIT_PAY | CHAR | 2 | 0 | Reference information type | ||
45 | REF2R | REFIN_PAY | CHAR40 | CHAR | 40 | 0 | Reference information | ||
46 | REF3T | REFIT_PAY | REFIT_PAY | CHAR | 2 | 0 | Reference information type | ||
47 | REF3R | REFIN_PAY | CHAR40 | CHAR | 40 | 0 | Reference information | ||
48 | VTREF | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
49 | VTRE2 | VTREF_KK | VTREF_KK | CHAR | 20 | 0 | Reference Specifications from Contract | ||
50 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
51 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
52 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
53 | AQSBW | AQSBW_KK | WRTV7 | CURR | 13 | 2 | Proportional Withholding Tax Amount In Transaction Currency | ||
54 | AQSBH | AQSBH_KK | WRTV7 | CURR | 13 | 2 | Proportional Withholding Tax Amount In Local Currency | ||
55 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
56 | STAKZ | STAKZ_KK | STAKZ_KK | CHAR | 1 | 0 | Type of statistical item | ||
57 | SUBAP | SUBAP_KK | SUBAP_KK | CHAR | 1 | 0 | Subapplication in Contract Accounts Receivable and Payable | ||
58 | .INCLUDE | 0 | 0 | IS-U-Specific Fields: Number Program, Where-Used List | |||||
59 | .INCLUDE | 0 | 0 | ||||||
60 | .INCLUDE | 0 | 0 | ||||||
61 | .INCLUDE | 0 | 0 | ||||||
62 | .INCLUDE | 0 | 0 | ||||||
63 | .INCLUDE | 0 | 0 | ||||||
64 | .INCLUDE | 0 | 0 | ||||||
65 | .INCLUDE | 0 | 0 | IS-SI-Specific Fields for Payment Program Where-Used List |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DPAYP | ADRNR | ADRC | ADDRNUMBER | |||
2 | DPAYP | CLRLO | TFK004B | CLRLO | |||
3 | DPAYP | LAND1 | T005 | LAND1 | |||
4 | DPAYP | LANDL | T005 | LAND1 | |||
5 | DPAYP | LZBKZ | T015L | LZBKZ | |||
6 | DPAYP | MANDT | T000 | MANDT | |||
7 | DPAYP | POKEN | TFKPK | POKEN | |||
8 | DPAYP | REGIO | T005S | BLAND | |||
9 | DPAYP | WAERS | TCURC | WAERS | |||
10 | DPAYP | ZLSPR | TFK008 | ZAHLS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |