SAP table DFKKZPT (Payment Lot: Data for Partial Clearing of a Payment)
SAP table DFKKZPT has 4 primary key fields being MANDT,KEYZ1,POSZA,TKPOS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
MANDT
KEYZ1
Payment Lot
CHAR
12
0
KEYZ1_KK
POSZA
Item number in a payment lot
NUMC
6
0
POSZA_KK
TKPOS
Item Number For Partial Clarification
NUMC
3
0
TKPOS_KK
BETRK
Assigned Amount in Transaction Currency
CURR
13
2
BETRK_KK
BETRL
Clarified Amount In Local Currency
CURR
13
2
BETRL_KK
XAKON
Post Payment on Account
CHAR
1
0
XAKON_KK
KLAEB
Number of Clarification Document
CHAR
12
0
KLAEB_KK
KLAED
Posting date of clarif. doc
DATS
8
0
KLAED_KK
NRZAA
Repayment Request
CHAR
10
0
NRZAA_KK
REPYM
Payment Method for Repayment
CHAR
1
0
TFK042Z
REPYM_KK
KUKON
Short Account Assignment for Transfer Postings
CHAR
4
0
TFK020K
KUKON_KK
RUEBL
Number of the resetting document
CHAR
12
0
RUEBL_KK
RUEAR
Type of resetting document
CHAR
1
0
RUEAR_KK
Possible values
1
Reversal document
2
Returns Document
3
Reset Clearing
4
Prior Period Posting to Clarif. Acct
TXTRZ
Text For Payment on Account, Repayment, or Transfer Posting
CHAR
50
0
TXTRZ_KK
RUEZU
Number of Reset Document
CHAR
12
0
RUEZU_KK
HZUON
Assignment Number in G/L Document
CHAR
18
0
HZUON_KK
KLAEO
Old Clarification Account
CHAR
10
0
KLAEO_KK
KLACO
Old Company Code
CHAR
4
0
KLACO_KK
DFKKZPT foreign key relationships
Table
Field
Check Table
Check Field
0 DFKKZPT
REPYM
TFK042Z
Payment Program: Additional Specifications for Payt Methods
LAND1
0 DFKKZPT
REPYM
TFK042Z
Payment Program: Additional Specifications for Payt Methods
ZLSCH