SAP Table DFKKZP
Payment lot: Data for payment
DFKKZP (Payment lot: Data for payment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DFKKZP to other SAP tables.
Source: DFKKZP (Payment lot: Data for payment)
DFKKZP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| KEYZ1 | Payment Lot | KEYZ1_KK | CHAR | 12 | 0 | |||||||||
| POSZA | Item number in a payment lot | POSZA_KK | NUMC | 6 | 0 | |||||||||
| SELT1 | 1. Selection Category | SELT1_KK | TFK004 | CHAR | 1 | 0 | ||||||||
| SELT2 | 2. Selection Category | SELT2_KK | TFK004 | CHAR | 1 | 0 | ||||||||
| SELT3 | 3. Selection Category | SELT3_KK | TFK004 | CHAR | 1 | 0 | ||||||||
| SELW1 | First Field Value to be Selected | SELW1_KK | CHAR | 35 | 0 | |||||||||
| SELW2 | Second Field Value to be Selected | SELW2_KK | CHAR | 35 | 0 | |||||||||
| SELW3 | Third Field Value to be Selected | SELW3_KK | CHAR | 35 | 0 | |||||||||
| BETRZ | Payment amount in transaction currency | BETRZ_KK | CURR | 13 | 2 | |||||||||
| BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13 | 2 | |||||||||
| BETRK | Assigned Amount in Transaction Currency | BETRK_KK | CURR | 13 | 2 | |||||||||
| BETRL | Clarified Amount In Local Currency | BETRL_KK | CURR | 13 | 2 | |||||||||
| XTKLA | Partial Clarifications Exist For Payment | XTKLA_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| TBETR | Partial Amount that Refers to the Specified Selection | TBETR_KK | CURR | 13 | 2 | |||||||||
| FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | DFKKSUMC | CHAR | 12 | 0 | ||||||||
| BVRKO | Bank clearing account | BVRKO_KK | SKB1 | CHAR | 10 | 0 | ||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | 0 | |||||||||
| BLART | Document Type | BLART_KK | TFK003 | CHAR | 2 | 0 | ||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||
| KURSF | Exchange rate | KURSF | DEC | 9 | 5 | |||||||||
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS | 8 | 0 | |||||||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||||
| VALUT | Value date | VALUT | DATS | 8 | 0 | |||||||||
| XEIPH | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| AUGRD | Clearing Reason | AUGRD_KK | TFK001A | CHAR | 2 | 0 | ||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||
| AETIM | Time at Which the Object Was Last Changed | AETIM_KK | TIMS | 6 | 0 | |||||||||
| XRUES | Check was or will be sent back | XRUES_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| XAKON | Post Payment on Account | XAKON_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| XKLAE | Clarify Payment Transaction | XKLAE_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| KLAEB | Number of Clarification Document | KLAEB_KK | CHAR | 12 | 0 | |||||||||
| KLAEH | Clarification Account | KLAEH_KK | SKB1 | CHAR | 10 | 0 | ||||||||
| KLAED | Posting date of clarif. doc | KLAED_KK | DATS | 8 | 0 | |||||||||
| KLAEC | Clarification Company Code | KLAEC_KK | CHAR | 4 | 0 | |||||||||
| OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | 0 | |||||||||
| UPOSZ | Allocation key for payment item | UPOSZ_KK | NUMC | 6 | 0 | |||||||||
| UPOSV | Allocation key for payment item | UPOSZ_KK | NUMC | 6 | 0 | |||||||||
| TXTVW | Note to Payee in Payment | TXTVW_KK | CHAR | 80 | 0 | |||||||||
| CHCKN | Check number | CHCKN_KK | CHAR | 13 | 0 | |||||||||
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||||||||
| BANKL | Bank Number of Other Bank Key | BANKL_KK | CHAR | 15 | 0 | |||||||||
| BANKN | Bank account number | BANKN | CHAR | 18 | 0 | |||||||||
| BKONT | Bank Control Key | BKONT | CHAR | 2 | 0 | |||||||||
| KOINH | Name of Holder of Bank Account/Check Issuer/Cardholder | KOINH_KK | CHAR | 60 | 0 | |||||||||
| XPGRO | Post Office Bank Current Account | XPGRO | CHAR | 1 | 0 |
Possible values
|
||||||||
| XDAUB | Payment by Standing Order | XDAUB_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| NRZAA | Repayment request | NRZAA_KK | CHAR | 10 | 0 | |||||||||
| REPYM | Payment Method for Repayment | REPYM_KK | TFK042Z | CHAR | 1 | 0 | ||||||||
| XCLAR | Line item included in clarification worklist | XCLAR_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| INFOF | Additional information | INFOF_KK | CHAR | 50 | 0 | |||||||||
| KUKON | Short Account Assignment for Transfer Postings | KUKON_KK | TFK020K | CHAR | 4 | 0 | ||||||||
| CCINS | Payment card type | CCINS_KK | TB033 | CHAR | 4 | 0 | ||||||||
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | 0 | |||||||||
| MERCH | Payment cards: Merchant ID at the clearing house | MERCH | TCCM | CHAR | 15 | 0 | ||||||||
| RUEBL | Number of the resetting document | RUEBL_KK | CHAR | 12 | 0 | |||||||||
| RUEAR | Type of resetting document | RUEAR_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | 0 | |||||||||
| TXTRZ | Text For Payment on Account, Repayment, or Transfer Posting | TXTRZ_KK | CHAR | 50 | 0 | |||||||||
| HZUON | Assignment Number in G/L Document | HZUON_KK | CHAR | 18 | 0 | |||||||||
| DATAB | Payment cards: Valid from | CC_DATAB | DATS | 8 | 0 | |||||||||
| DATBI | Payment Cards: Valid To | CC_DATBI | DATS | 8 | 0 | |||||||||
| AUNUM | Payment cards: Authorization number | AUNUM_KK | CHAR | 25 | 0 | |||||||||
| AUDAT | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | 0 | |||||||||
| AUTIM | Payment cards: Authorization time | AUTIM | TIMS | 6 | 0 | |||||||||
| XATTS | Move Attachments of UPOSZ from PSOZA | XATTS_KK | CHAR | 1 | 0 |
Possible values
|
||||||||
| CGUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | 0 | |||||||||
| ENCTP | Type of Encryption | CCSECA_ENCTYPE | CHAR | 1 | 0 |
Possible values
|
||||||||
| BEGRU | Authorization Group | BEGRU_PL_KK | CHAR | 4 | 0 | |||||||||
| IBAN | IBAN (International Bank Account Number) | IBAN_KK | CHAR | 34 | 0 | |||||||||
| SWIFT | SWIFT Code/Bank Identifier Code (BIC) | BICSW_KK | CHAR | 11 | 0 | |||||||||
DFKKZP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| DFKKZP | AUGRD | DFKKZP | AUGRD | TFK001A | Clearing Reasons | AUGRD |
| DFKKZP | BANKS | DFKKZP | BANKS | T005 | Countries | LAND1 |
| DFKKZP | BANKS | DFKKZP | MANDT | T005 | Countries | MANDT |
| DFKKZP | BLART | DFKKZP | BLART | TFK003 | Document types | BLART |
| DFKKZP | BLART | DFKKZK | APPLK | TFK003 | Document types | APPLK |
| DFKKZP | BLART | DFKKZP | MANDT | TFK003 | Document types | MANDT |
| DFKKZP | BUKRS | DFKKZP | BUKRS | T001 | Company Codes | BUKRS |
| DFKKZP | BUKRS | DFKKZP | MANDT | T001 | Company Codes | MANDT |
| DFKKZP | BVRKO | DFKKZP | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
| DFKKZP | BVRKO | DFKKZP | MANDT | SKB1 | G/L account master (company code) | MANDT |
| DFKKZP | BVRKO | DFKKZP | BVRKO | SKB1 | G/L account master (company code) | SAKNR |
| DFKKZP | CCINS | DFKKZP | MANDT | TB033 | Payment Cards: Type | MANDT |
| DFKKZP | CCINS | DFKKZP | CCINS | TB033 | Payment Cards: Type | CCINS |
| DFKKZP | FIKEY | DFKKZP | FIKEY | DFKKSUMC | Control details for posting totals | FIKEY |
| DFKKZP | FIKEY | DFKKZP | MANDT | DFKKSUMC | Control details for posting totals | MANDT |
| DFKKZP | GSBER | DFKKZP | MANDT | TGSB | Business Areas | MANDT |
| DFKKZP | GSBER | DFKKZP | GSBER | TGSB | Business Areas | GSBER |
| DFKKZP | KLAEH | DFKKZP | KLAEH | SKB1 | G/L account master (company code) | SAKNR |
| DFKKZP | KLAEH | DFKKZP | BUKRS | SKB1 | G/L account master (company code) | BUKRS |
| DFKKZP | KLAEH | DFKKZP | MANDT | SKB1 | G/L account master (company code) | MANDT |
| DFKKZP | KUKON | DFKKZP | KUKON | TFK020K | Short Account Assignments for Transfer Postings | KUKON |
| DFKKZP | KUKON | DFKKZP | MANDT | TFK020K | Short Account Assignments for Transfer Postings | MANDT |
| DFKKZP | MERCH | DFKKZP | MANDT | TCCM | Payment cards: Merchant ID | MANDT |
| DFKKZP | MERCH | DFKKZP | MERCH | TCCM | Payment cards: Merchant ID | MERCH |
| DFKKZP | REPYM | DFKKZP | REPYM | TFK042Z | Payment Program: Additional Specifications for Payt Methods | ZLSCH |
| DFKKZP | REPYM | DFKKZP | MANDT | TFK042Z | Payment Program: Additional Specifications for Payt Methods | MANDT |
| DFKKZP | REPYM | T001 | LAND1 | TFK042Z | Payment Program: Additional Specifications for Payt Methods | LAND1 |
| DFKKZP | SELT1 | DFKKZP | SELT1 | TFK004 | Selection categories for manual payment processing | SELTX |
| DFKKZP | SELT1 | DFKKZK | APPLK | TFK004 | Selection categories for manual payment processing | APPLK |
| DFKKZP | SELT1 | DFKKZP | MANDT | TFK004 | Selection categories for manual payment processing | MANDT |
| DFKKZP | SELT2 | DFKKZP | MANDT | TFK004 | Selection categories for manual payment processing | MANDT |
| DFKKZP | SELT2 | DFKKZK | APPLK | TFK004 | Selection categories for manual payment processing | APPLK |
| DFKKZP | SELT2 | DFKKZP | SELT2 | TFK004 | Selection categories for manual payment processing | SELTX |
| DFKKZP | SELT3 | DFKKZP | MANDT | TFK004 | Selection categories for manual payment processing | MANDT |
| DFKKZP | SELT3 | DFKKZK | APPLK | TFK004 | Selection categories for manual payment processing | APPLK |
| DFKKZP | SELT3 | DFKKZP | SELT3 | TFK004 | Selection categories for manual payment processing | SELTX |
| DFKKZP | WAERS | DFKKZP | MANDT | TCURC | Currency Codes | MANDT |
| DFKKZP | WAERS | DFKKZP | WAERS | TCURC | Currency Codes | WAERS |
