SAP table DFKKZP (Payment lot: Data for payment)

SAP table DFKKZP has 3 primary key fields being MANDT,KEYZ1,POSZA.

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
SELT1 1. Selection Category CHAR 1 0 TFK004 SELT1_KK
SELT2 2. Selection Category CHAR 1 0 TFK004 SELT2_KK
SELT3 3. Selection Category CHAR 1 0 TFK004 SELT3_KK
SELW1 First Field Value to be Selected CHAR 35 0 SELW1_KK
SELW2 Second Field Value to be Selected CHAR 35 0 SELW2_KK
SELW3 Third Field Value to be Selected CHAR 35 0 SELW3_KK
BETRZ Payment Amount in Transaction Currency CURR 13 2 BETRZ_KK
BETRH Amount In Local Currency With +/- Signs CURR 13 2 BETRH_KK
BETRK Assigned Amount in Transaction Currency CURR 13 2 BETRK_KK
BETRL Clarified Amount In Local Currency CURR 13 2 BETRL_KK
XTKLA Partial Clarifications Exist For Payment CHAR 1 0 XTKLA_KK
TBETR Partial Amount that Refers to the Specified Selection CURR 13 2 TBETR_KK
FIKEY Reconciliation Key for General Ledger CHAR 12 0 DFKKSUMC FIKEY_KK
BVRKO Bank clearing account CHAR 10 0 SKB1 BVRKO_KK
BUKRS Company Code CHAR 4 0 T001 BUKRS
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
GSBER Business Area CHAR 4 0 TGSB GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
BLART Document Type CHAR 2 0 TFK003 BLART_KK
WAERS Currency Key CUKY 5 0 TCURC WAERS
KURSF Exchange rate DEC 9 5 KURSF
BUDAT Posting Date in the Document DATS 8 0 BUDAT_KK
BLDAT Document Date in Document DATS 8 0 BLDAT
VALUT Value date DATS 8 0 VALUT
XEIPH Create Line Item in General Ledger CHAR 1 0 XEIPH_KK
AUGRD Clearing Reason CHAR 2 0 TFK001A AUGRD_KK
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Time at Which the Object Was Last Changed TIMS 6 0 AETIM_KK
XRUES Check was or will be sent back CHAR 1 0 XRUES_KK
XAKON Post Payment on Account CHAR 1 0 XAKON_KK
XKLAE Clarify Payment Transaction CHAR 1 0 XKLAE_KK
KLAEB Number of Clarification Document CHAR 12 0 KLAEB_KK
KLAEH Clarification Account CHAR 10 0 SKB1 KLAEH_KK
KLAED Posting date of clarif. doc DATS 8 0 KLAED_KK
KLAEC Clarification Company Code CHAR 4 0 KLAEC_KK
OPBEL Number of a FI-CA Document CHAR 12 0 OPBEL_KK
UPOSZ Allocation key for payment item NUMC 6 0 UPOSZ_KK
UPOSV Allocation key for payment item NUMC 6 0 UPOSZ_KK
TXTVW Note to Payee in Payment CHAR 80 0 TXTVW_KK
CHCKN Check number CHAR 13 0 CHCKN_KK
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
BANKL Bank Number of Other Bank Key CHAR 15 0 BANKL_KK
BANKN Bank account number CHAR 18 0 BANKN
BKONT Bank Control Key CHAR 2 0 BKONT
KOINH Name of Holder of Bank Account/Check Issuer/Cardholder CHAR 60 0 KOINH_KK
XPGRO Post Office Bank Current Account CHAR 1 0 XPGRO
XDAUB Payment by Standing Order CHAR 1 0 XDAUB_KK
NRZAA Repayment Request CHAR 10 0 NRZAA_KK
REPYM Payment Method for Repayment CHAR 1 0 TFK042Z REPYM_KK
XCLAR Line item included in clarification worklist CHAR 1 0 XCLAR_KK
INFOF Additional information CHAR 50 0 INFOF_KK
KUKON Short Account Assignment for Transfer Postings CHAR 4 0 TFK020K KUKON_KK
CCINS Payment card type CHAR 4 0 TB033 CCINS_KK
CCNUM Payment cards: Card number CHAR 25 0 CCNUM
MERCH Payment cards: Merchant ID at the clearing house CHAR 15 0 TCCM MERCH
RUEBL Number of the resetting document CHAR 12 0 RUEBL_KK
RUEAR Type of resetting document CHAR 1 0 RUEAR_KK
1 Reversal document
2 Returns Document
3 Reset Clearing
4 Prior Period Posting to Clarif. Acct
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
TXTRZ Text For Payment on Account, Repayment, or Transfer Posting CHAR 50 0 TXTRZ_KK
HZUON Assignment Number in G/L Document CHAR 18 0 HZUON_KK
DATAB Payment cards: Valid from DATS 8 0 CC_DATAB
DATBI Payment Cards: Valid To DATS 8 0 CC_DATBI
AUNUM Payment cards: Authorization number CHAR 25 0 AUNUM_KK
AUDAT Payment cards: Authorization date DATS 8 0 AUDAT_CC
AUTIM Payment cards: Authorization time TIMS 6 0 AUTIM
XATTS Move Attachments of UPOSZ from PSOZA CHAR 1 0 XATTS_KK
CGUID GUID of a Payment Card RAW 16 0 CARD_GUID
ENCTP Type of Encryption CHAR 1 0 CCSECA_ENCTYPE
1 Data in PCA_SECURITY_RAW
2 Data in CCSEC_ENC or CCSEC_ENCV
3 Data in CCARDEC
BEGRU Authorization Group CHAR 4 0 BEGRU_PL_KK
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN_KK
SWIFT SWIFT Code/Bank Identifier Code (BIC) CHAR 11 0 BICSW_KK
PGUID GUID of a Postdated Check RAW 16 0 PGUID_KK
ISDAT Date of Postdated Check DATS 8 0 ISDAT_KK
ESNUM Memo Record Number (Line Item Number in Bank Statement) NUMC 5 0 ESNUM_EB
LNKID Link ID CHAR 32 0 FQM_LINKID
ML_STATUS Machine Learning: Status of Payment Lot Item CHAR 2 0 ML_STATUS_PLOT_KK
01 A proposal was requested.
10 No proposal was created.
20 No valid proposal was created.
30 A valid proposal was created.
40 A secure proposal has been created.
50 A secure proposal has been created with clearing.
XML_CLEARED Machine Learning: Clearing Based on Proposal CHAR 1 0 X_ML_CLEARED_KK
KEYPP Subarea for Parallelization in Mass Processing NUMC 3 0 KEYPP_KK

DFKKZP foreign key relationships

Table Field Check Table Check Field
0 DFKKZP AUGRD TFK001A Clearing Reasons AUGRD
1 DFKKZP BANKS T005 Countries MANDT
1 DFKKZP BANKS T005 Countries LAND1
0 DFKKZP BUKRS T001 Company Codes BUKRS
1 DFKKZP BVRKO SKB1 G/L account master (company code) MANDT
1 DFKKZP BVRKO SKB1 G/L account master (company code) BUKRS
0 DFKKZP CCINS TB033 Payment Cards: Type MANDT
0 DFKKZP CCINS TB033 Payment Cards: Type CCINS
1 DFKKZP FIKEY DFKKSUMC Control details for posting totals MANDT
1 DFKKZP FIKEY DFKKSUMC Control details for posting totals FIKEY
0 DFKKZP GSBER TGSB Business Areas MANDT
0 DFKKZP GSBER TGSB Business Areas GSBER
1 DFKKZP HBKID T012 House Banks BUKRS
0 DFKKZP HKTID T012K House Bank Accounts MANDT
0 DFKKZP HKTID T012K House Bank Accounts BUKRS
0 DFKKZP HKTID T012K House Bank Accounts HBKID
0 DFKKZP HKTID T012K House Bank Accounts HKTID
1 DFKKZP KLAEH SKB1 G/L account master (company code) MANDT
1 DFKKZP KLAEH SKB1 G/L account master (company code) BUKRS
0 DFKKZP MERCH TCCM Payment cards: Merchant ID MANDT
1 DFKKZP REPYM TFK042Z Payment Program: Additional Specifications for Payt Methods LAND1
1 DFKKZP REPYM TFK042Z Payment Program: Additional Specifications for Payt Methods ZLSCH
0 DFKKZP SELT1 TFK004 Selection categories for manual payment processing MANDT
1 DFKKZP SELT2 TFK004 Selection categories for manual payment processing MANDT
0 DFKKZP SELT3 TFK004 Selection categories for manual payment processing MANDT
1 DFKKZP WAERS TCURC Currency Codes MANDT
1 DFKKZP WAERS TCURC Currency Codes WAERS