DFKKEXC SAP (External Payment Information) Table details
Dictionary Type: Table
Description: External Payment Information
Description: External Payment Information
Table field list including key, data, relationships and ABAP select examples
DFKKEXC is a standard SAP Table which is used to store External Payment Information data and is available within R/3 SAP systems depending on the version and release level.
The DFKKEXC table consists of various fields, each holding specific information or linking keys about External Payment Information data available in SAP. These include OFFIC (Branch in Cash Journal), CHDSK (Cash Desk), PAYID (ID of External Payment), PAYTP (Category of Payment/Payment Lot).. 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 DFKKEXC 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 | |||
OFFIC | Branch in Cash Journal | OFFIC_KK | CHAR | 3 | OFFIC_KK | ||||
CHDSK | Cash Desk | CHDSK_KK | CHAR | 2 | CHDSK_KK | ||||
PAYID | ID of External Payment | PAYID_KK | CHAR | 35 | PAYID_KK | ||||
PAYTP | Category of Payment/Payment Lot | PAYTP_KK | CHAR | 2 | PAYTP_KK | ||||
PAYKY | Grouping Key for External Payments | PAYKY_KK | CHAR | 16 | PAYKY_KK | ||||
PRZTP | Process Category for External Payment Information | PRZTP_KK | CHAR | 2 | PRZTP_KK | ||||
GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
VKONA | Contract account number in legacy system | VKONA_KK | CHAR | 20 | CHAR20 | ||||
BETRZ | Payment amount in transaction currency | BETRZ_KK | CURR | 13(2) | WRTV7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
UZEIT | Time of External Payment | PAYTM_KK | TIMS | 6 | UZEIT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
CDVKO | Cash Desk Clearing Account | CDVKO_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
XAKON | Post Payment on Account | XAKON_KK | CHAR | 1 | XFELD | ||||
STEXC | Status of an External Payment | STEXC_KK | CHAR | 1 | STEXC_KK | ||||
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
KEYZ1 | Payment Lot | KEYZ1_KK | CHAR | 12 | KEYZ1_KK | ||||
POSZA | Item number in a payment lot | POSZA_KK | NUMC | 6 | NUM06 | ||||
STAAG | Status of Agent Posting for External Payments | STAAG_KK | CHAR | 1 | STAAG_KK | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
STORB | Number of Reversal Document | STORB_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
STDAT | Reversal Document Posting Date | STODT_KK | DATS | 8 | DATUM | ||||
STLOT | Key of Reversal Payment Lot | STLOT_KK | CHAR | 12 | STLOT_KK | ||||
XIGUID | GUID for XI Message ID | GUIDXI_KK | RAW | 16 | SYSUUID | ||||
STGUID | GUID for XI Message ID | GUIDXI_KK | RAW | 16 | SYSUUID | ||||
MSGID | Message Class | SYMSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
MSGNO | Message Number | SYMSGNO | NUMC | 3 | SYMSGNO | ||||
MSGV1 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
MSGV2 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
MSGV3 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
MSGV4 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
HOST | Application Server | SYHOST | CHAR | 32 | HOST_ID | ||||
UPDSC | Hash Key for Distribution | UPDSC_KK | NUMC | 3 | INT3 | ||||
TRBEL | Transfer Document | TRBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
STRBL | Document Number of Reversal of Transfer Document | STRBL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
POSRV | Item Number in a Reversal Payment Lot | POSRV_KK | NUMC | 6 | NUM06 | ||||
PYOUT | Outgoing Payment | PYOUT_KK | CHAR | 1 | XFELD | ||||
PAYRF | G/L Account Posting ID | PAYRF_KK | CHAR | 30 | CHAR30 | ||||
KUKON | Short Account Assignment for Transfer Postings | KUKON_KK | CHAR | 4 | Assigned to domain | KUKON_KK | |||
HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 |
Key field | Non-key field |
How do I retrieve data from SAP table DFKKEXC using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKEXC to SELECT all data from the tableDATA: WA_DFKKEXC TYPE DFKKEXC.
SELECT SINGLE *
FROM DFKKEXC
INTO CORRESPONDING FIELDS OF WA_DFKKEXC
WHERE...
How to access SAP table DFKKEXC
Within an ECC or HANA version of SAP you can also view further information about DFKKEXC 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