DFKKZP SAP (Payment lot: Data for payment) Table details
Dictionary Type: Table
Description: Payment lot: Data for payment
Description: Payment lot: Data for payment
Table field list including key, data, relationships and ABAP select examples
DFKKZP is a standard SAP Table which is used to store Payment lot: Data for payment data and is available within R/3 SAP systems depending on the version and release level.
The DFKKZP table consists of various fields, each holding specific information or linking keys about Payment lot: Data for payment data available in SAP. These include KEYZ1 (Payment Lot), POSZA (Item number in a payment lot), SELT1 (1. Selection Category), SELT2 (2. Selection Category).. 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 DFKKZP 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 | Assigned to domain | MANDT | |||
KEYZ1 | Payment Lot | KEYZ1_KK | CHAR | 12 | KEYZ1_KK | ||||
POSZA | Item number in a payment lot | POSZA_KK | NUMC | 6 | NUM06 | ||||
SELT1 | 1. Selection Category | SELT1_KK | CHAR | 1 | TFK004 | SELTX_KK | |||
SELT2 | 2. Selection Category | SELT2_KK | CHAR | 1 | TFK004 | SELTX_KK | |||
SELT3 | 3. Selection Category | SELT3_KK | CHAR | 1 | TFK004 | SELTX_KK | |||
SELW1 | First Field Value to be Selected | SELW1_KK | CHAR | 35 | CHAR35 | ||||
SELW2 | Second Field Value to be Selected | SELW2_KK | CHAR | 35 | CHAR35 | ||||
SELW3 | Third Field Value to be Selected | SELW3_KK | CHAR | 35 | CHAR35 | ||||
BETRZ | Payment amount in transaction currency | BETRZ_KK | CURR | 13(2) | WRTV7 | ||||
BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13(2) | WRTV7 | ||||
BETRK | Assigned Amount in Transaction Currency | BETRK_KK | CURR | 13(2) | WRTV7 | ||||
BETRL | Clarified Amount In Local Currency | BETRL_KK | CURR | 13(2) | WRTV7 | ||||
XTKLA | Partial Clarifications Exist For Payment | XTKLA_KK | CHAR | 1 | XFELD | ||||
TBETR | Partial Amount that Refers to the Specified Selection | TBETR_KK | CURR | 13(2) | WRTV7 | ||||
FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | DFKKSUMC | FIKEY_KK | FKFI1 | ||
BVRKO | Bank clearing account | BVRKO_KK | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
BLART | Document Type | BLART_KK | CHAR | 2 | TFK003 | BLART_KK | |||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
BUDAT | Posting Date in the Document | BUDAT_KK | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
XEIPH | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1 | XFELD | ||||
AUGRD | Clearing Reason | AUGRD_KK | CHAR | 2 | TFK001A | AUGRD_KK | |||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AETIM | Time at Which the Object Was Last Changed | AETIM_KK | TIMS | 6 | UZEIT | ||||
XRUES | Check was or will be sent back | XRUES_KK | CHAR | 1 | XFELD | ||||
XAKON | Post Payment on Account | XAKON_KK | CHAR | 1 | XFELD | ||||
XKLAE | Clarify Payment Transaction | XKLAE_KK | CHAR | 1 | XFELD | ||||
KLAEB | Number of Clarification Document | KLAEB_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
KLAEH | Clarification Account | KLAEH_KK | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
KLAED | Posting date of clarif. doc | KLAED_KK | DATS | 8 | DATUM | ||||
KLAEC | Clarification Company Code | KLAEC_KK | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
UPOSZ | Allocation key for payment item | UPOSZ_KK | NUMC | 6 | NUM06 | ||||
UPOSV | Allocation key for payment item | UPOSZ_KK | NUMC | 6 | NUM06 | ||||
TXTVW | Note to Payee in Payment | TXTVW_KK | CHAR | 80 | CHAR80 | ||||
CHCKN | Check number | CHCKN_KK | CHAR | 13 | CHCKN | ||||
BANKS | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
BANKL | Bank Number of Other Bank Key | BANKL_KK | CHAR | 15 | BANKK | BLZ | |||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
KOINH | Name of Holder of Bank Account/Check Issuer/Cardholder | KOINH_KK | CHAR | 60 | KOINH | ||||
XPGRO | Post Office Bank Current Account | XPGRO | CHAR | 1 | XFELD | ||||
XDAUB | Payment by Standing Order | XDAUB_KK | CHAR | 1 | XFELD | ||||
NRZAA | Repayment request | NRZAA_KK | CHAR | 10 | ALPHA | NRZAA_KK | |||
REPYM | Payment Method for Repayment | REPYM_KK | CHAR | 1 | TFK042Z | PYMET_KK | |||
XCLAR | Line item included in clarification worklist | XCLAR_KK | CHAR | 1 | XFELD | ||||
INFOF | Additional information | INFOF_KK | CHAR | 50 | CHAR50 | ||||
KUKON | Short Account Assignment for Transfer Postings | KUKON_KK | CHAR | 4 | TFK020K | KUKON_KK | |||
CCINS | Payment card type | CCINS_KK | CHAR | 4 | TB033 | CC_INSTITUTE | |||
CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | Assigned to domain | CCNUM | |||
MERCH | Payment cards: Merchant ID at the clearing house | MERCH | CHAR | 15 | TCCM | MERCH | |||
RUEBL | Number of the resetting document | RUEBL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
RUEAR | Type of resetting document | RUEAR_KK | CHAR | 1 | RUEAR_KK | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
TXTRZ | Text For Payment on Account, Repayment, or Transfer Posting | TXTRZ_KK | CHAR | 50 | TEXT50 | ||||
HZUON | Assignment Number in G/L Document | HZUON_KK | CHAR | 18 | ZUONR | ||||
DATAB | Payment cards: Valid from | CC_DATAB | DATS | 8 | DATUM | ||||
DATBI | Payment Cards: Valid To | CC_DATBI | DATS | 8 | DATUM | ||||
AUNUM | Payment cards: Authorization number | AUNUM_KK | CHAR | 25 | CHAR25 | ||||
AUDAT | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | DATUM | ||||
AUTIM | Payment cards: Authorization time | AUTIM | TIMS | 6 | UZEIT | ||||
XATTS | Move Attachments of UPOSZ from PSOZA | XATTS_KK | CHAR | 1 | XFELD | ||||
CGUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | SYSUUID | ||||
ENCTP | Type of Encryption | CCSECA_ENCTYPE | CHAR | 1 | CCSECA_ENCTYPE | ||||
BEGRU | Authorization Group | BEGRU_PL_KK | CHAR | 4 | BEGRU | ||||
IBAN | IBAN (International Bank Account Number) | IBAN_KK | CHAR | 34 | IBAN | ||||
SWIFT | SWIFT Code/Bank Identifier Code (BIC) | BICSW_KK | CHAR | 11 | SWIFT |
Key field | Non-key field |
How do I retrieve data from SAP table DFKKZP using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKZP to SELECT all data from the tableDATA: WA_DFKKZP TYPE DFKKZP.
SELECT SINGLE *
FROM DFKKZP
INTO CORRESPONDING FIELDS OF WA_DFKKZP
WHERE...
How to access SAP table DFKKZP
Within an ECC or HANA version of SAP you can also view further information about DFKKZP 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