SAP table DFKKEXC (External Payment Information)

SAP table DFKKEXC has 5 primary key fields being MANDT,OFFIC,CHDSK,PAYID,PAYTP.

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
OFFIC Branch in Cash Journal CHAR 3 0 OFFIC_KK
CHDSK Cash Desk CHAR 2 0 CHDSK_KK
PAYID ID of External Payment CHAR 35 0 PAYID_KK
PAYTP Category of Payment/Payment Lot CHAR 2 0 PAYTP_KK
* Valid for All Payment Categories
AM Account Maintenance
CH Check payment
CO Outgoing Check Payment
CP Card Payment
CS Cash payment
EX External Payment
PO Postal remittance
RD Zero Document or Collective Bill for Cash Register
PAYKY Grouping Key for External Payments CHAR 16 0 PAYKY_KK
PRZTP Process Category for External Payment Information CHAR 2 0 PRZTP_KK
01 External Payment via XI Interface
02 External Payment Posted Manually Internally
GPART Business Partner Number CHAR 10 0 GPART_KK
BPEXT Business Partner Number in External System CHAR 20 0 BU_BPEXT
VKONT Contract Account Number CHAR 12 0 VKONT_KK
VKONA Contract account number in legacy system CHAR 20 0 VKONA_KK
BETRZ Payment Amount in Transaction Currency CURR 13 2 BETRZ_KK
WAERS Currency Key CUKY 5 0 WAERS
VALUT Value date DATS 8 0 VALUT
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
UZEIT Time of External Payment TIMS 6 0 PAYTM_KK
BUKRS Company Code CHAR 4 0 BUKRS
GSBER Business Area CHAR 4 0 GSBER
SEGMENT Segment for Segmental Reporting CHAR 10 0 SEGMT_KK
PRCTR Profit Center CHAR 10 0 PRCTR
CDVKO Cash Desk Clearing Account CHAR 10 0 CDVKO_KK
XAKON Post Payment on Account CHAR 1 0 XAKON_KK
STEXC Status of an External Payment CHAR 1 0 STEXC_KK
Created, Not Yet Processed
C Reversed
D Reversal Unsuccessful, Repetition Scheduled
E Payment Reversed, Posting Not Required
F Payment Lot: Posting Incomplete
G Payment Lot: Reversal Incomplete
P Posted (Document or Payment Lot Exists)
R Posting Unsuccessful, Repetition Scheduled
X Item Could Not Be Processed
OPBEL Number of a FI-CA Document CHAR 12 0 OPBEL_KK
KEYZ1 Payment Lot CHAR 12 0 KEYZ1_KK
POSZA Item number in a payment lot NUMC 6 0 POSZA_KK
STAAG Status of Agent Posting for External Payments CHAR 1 0 STAAG_KK
Posting Not Created
P Posting Created
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
STORB Number of Reversal Document CHAR 12 0 STORB_KK
STDAT Reversal Document Posting Date DATS 8 0 STODT_KK
STLOT Key of Reversal Payment Lot CHAR 12 0 STLOT_KK
XIGUID GUID for XI Message ID RAW 16 0 GUIDXI_KK
STGUID GUID for XI Message ID RAW 16 0 GUIDXI_KK
MSGID Message Class CHAR 20 0 SYMSGID
MSGNO Message Number NUMC 3 0 SYMSGNO
MSGV1 Message Variable CHAR 50 0 SYMSGV
MSGV2 Message Variable CHAR 50 0 SYMSGV
MSGV3 Message Variable CHAR 50 0 SYMSGV
MSGV4 Message Variable CHAR 50 0 SYMSGV
HOST Application Server CHAR 32 0 SYHOST
UPDSC Hash Key for Distribution NUMC 3 0 UPDSC_KK
TRBEL Transfer Document CHAR 12 0 TRBEL_KK
STRBL Document Number of Reversal of Transfer Document CHAR 12 0 STRBL_KK
POSRV Item Number in a Reversal Payment Lot NUMC 6 0 POSRV_KK
PYOUT Outgoing Payment CHAR 1 0 PYOUT_KK
PAYRF G/L Account Posting ID CHAR 30 0 PAYRF_KK
KUKON Short Account Assignment for Transfer Postings CHAR 4 0 KUKON_KK
HZUON Assignment Number for Special G/L Accounts CHAR 18 0 HZUON
SGTXT Item Text CHAR 50 0 SGTXT
HBKID Short Key for a House Bank CHAR 5 0 HBKID
HKTID ID for Account Details CHAR 5 0 HKTID
RTPTP Real-Time Payment: Scenario CHAR 2 0 RTPTP_KK
01 Automatic Debit
02 Bank Payment
03 Payment Using Virtual Account
04 Payment Using Credit Card
PYORD Payment Order CHAR 10 0 PYORD_KK
STRTP Status of Real-Time Payment CHAR 2 0 STRTP_KK
01 Created, Not Yet Processed
05 Error occurred during processing
06 Credit Card Authorization Rejected
07 Virtual Account Not Assigned to a Business Partner
10 Payment Order Created, Bank Not Yet Informed
11 Payment Order Created, Bank Has Not Yet Responded
12 Payment Order Created, Bank Has Confirmed
13 Payment Order Created, Bank Has Rejected
15 Payment Order Created, Confirmed, and Payment Posted
16 Payment Order Created, Rejected, and Return Created
17 Payment Order Created, Rejected, and Return Posted
18 Payment Order Created, Rejected, and Reversed
20 Payment Posted, Bank Not Yet Informed
21 Payment Posted, Bank Has Not Yet Responded
22 Payment Posted, Bank Has Confirmed
23 Payment Posted, Bank Has Rejected
26 Payment Posted, Rejected, and Return Created
27 Payment Posted, Rejected, and Return Posted
41 Payment Rejected
42 Payment Was Externally Reversed
BKVID Bank Details ID CHAR 4 0 BU_BKVID
VACID Real-Time Payment: ID of a Virtual Account CHAR 18 0 VACID_RTP_KK
KEYR1 Returns Lot CHAR 12 0 KEYR1_KK
RCODE Real-Time Payment: Response of Bank CHAR 1 0 RCODE_RTP_KK
1 Payment Made Successfully
2 Payment Could Not Be Made
3 Payment Sent to Bank - No Response Yet
RLGRD Return Reason CHAR 3 0 TFK045A RLGRD_KK
RLHBK House bank's return reason CHAR 6 0 TFK045D RLHBK_KK
AENAM Last Changed By CHAR 12 0 AENAM_KK
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Time at Which the Object Was Last Changed TIMS 6 0 AETIM_KK
PYMET Payment Method CHAR 1 0 * PYMET_KK
PYVAR Additional Characteristic for Real-Time Payment CHAR 6 0 PYVAR_KK
RCAVR Payment Cards: Result of Address Check (Address Result) CHAR 4 0 TCCRC RCAVR_CC
RCAVA Payment Cards: Result of Address Check (Address Approval) CHAR 4 0 TCCRC RCAVA_CC
RCAVZ Payment Cards: Result of Address Check (ZIP Code Result) CHAR 4 0 TCCRC RCAVZ_CC
RCRSP Payment cards: Result of card check (response code) CHAR 4 0 TCCRC RCRSP_CC
RTEXT Payment cards: Result text CHAR 40 0 RTEXT_CC
RCCVV Results Check for Card Verification Value CHAR 4 0 TCCRC RCCVV_CC

DFKKEXC foreign key relationships

Table Field Check Table Check Field
0 DFKKEXC RCAVA TCCRC Payment Cards: Check Results MANDT
0 DFKKEXC RCAVA TCCRC Payment Cards: Check Results RCATG
0 DFKKEXC RCAVA TCCRC Payment Cards: Check Results RCODE
1 DFKKEXC RCAVR TCCRC Payment Cards: Check Results MANDT
1 DFKKEXC RCAVR TCCRC Payment Cards: Check Results RCATG
1 DFKKEXC RCAVR TCCRC Payment Cards: Check Results RCODE
0 DFKKEXC RCAVZ TCCRC Payment Cards: Check Results MANDT
0 DFKKEXC RCAVZ TCCRC Payment Cards: Check Results RCATG
0 DFKKEXC RCAVZ TCCRC Payment Cards: Check Results RCODE
1 DFKKEXC RCCVV TCCRC Payment Cards: Check Results MANDT
1 DFKKEXC RCCVV TCCRC Payment Cards: Check Results RCATG
1 DFKKEXC RCCVV TCCRC Payment Cards: Check Results RCODE
0 DFKKEXC RCRSP TCCRC Payment Cards: Check Results MANDT
0 DFKKEXC RCRSP TCCRC Payment Cards: Check Results RCATG
0 DFKKEXC RCRSP TCCRC Payment Cards: Check Results RCODE
1 DFKKEXC RLGRD TFK045A Returns table MANDT
1 DFKKEXC RLGRD TFK045A Returns table RLGRD
1 DFKKEXC RLGRD TFK045A Returns table HBKID
0 DFKKEXC RLHBK TFK045D Assign return reasons BUKRS
0 DFKKEXC RLHBK TFK045D Assign return reasons HBKID
0 DFKKEXC RLHBK TFK045D Assign return reasons RLHBK