SAP table DFKKPOH (Payment Order: Header Data)

SAP table DFKKPOH has 2 primary key fields being MANDT,PYORD.

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
PYORD Payment Order CHAR 10 0 PYORD_KK
ORG1T Type of Organization CHAR 2 0 ORG1T_PAY
ORG1R Reference for Organization CHAR 8 0 ORG1R_PAY
HBKID Short Key for a House Bank CHAR 5 0 HBKID
HKTID ID for Account Details CHAR 5 0 HKTID
RZAWE Payment Method CHAR 1 0 PYMET_KK
AUSFD Due date of the paid items DATS 8 0 AUSFD
VERFD Expiration Date of Payment Order DATS 8 0 VERFD_KK
STAZA Status of Payment Order CHAR 1 0 STAZA_KK
Open
1 Executed
2 Canceled
3 Expired
4 Reversed after Expiration Date
5 Reset due to incorrect execution
6 Included in Returns Lot
GPA1T Business Partner Category CHAR 2 0 GPA1T_PAY
GPA1R Business Partner Reference CHAR 12 0 GPA1R_PAY
RFORD External Reference Number of Payment Order CHAR 30 0 RFORD_KK
LAUFD Date ID DATS 8 0 LAUFD_KK
LAUFI Identification for the payment run CHAR 5 0 LAUFI_PAY
WAERS Currency Key CUKY 5 0 * WAERS
NWBTR Net Payment Amount with +/- Sign CURR 13 2 NWBTRV_KK
RWBTR Payment Amount in Payment Currency CURR 13 2 RWBTR_KK
RBETR Payment Amount in Local Currency CURR 13 2 RHBTR_KK
DIFFB Difference Amount in Clearing Processing CURR 13 2 DIFFB_KK
VALUT Value date DATS 8 0 VALUT
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
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Time changed TIMS 6 0 CDUZEIT
FDLEV Planning Level CHAR 2 0 * FDLEV
BNKKO Bank Account/Bank Clearing Account (G/L Account) CHAR 10 0 * BNKKO
GSBER Business Area CHAR 4 0 * GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
ZLAND Country/Region Key CHAR 3 0 * LAND1
APPLK Application Area CHAR 1 0 APPLK_KK
* Valid for all application areas
C Convergent FI-CA
M Media Companies
P Public Administration
R Utility company
S Extended FI-CA
T Telecommunications
V Insurance company
X In-house development
PYBEL Number of Payment Document CHAR 12 0 * PYBEL_KK
PPKEY Identification of Promise to Pay CHAR 12 0 DFKKPP PPKEY_KK
BETRZ Payment Amount in Transaction Currency CURR 13 2 BETRZ_KK
RLGRD Return Reason CHAR 3 0 TFK045A RLGRD_KK
RLHBK House bank's return reason CHAR 6 0 TFK045D RLHBK_KK
XPRENOT Direct Debit Pre-Notification Exists CHAR 1 0 XPRN_EXIST_KK
OFFIC Branch in Cash Journal CHAR 3 0 DFKKCJ_OFFIC OFFIC_KK
CHDSK Cash Desk CHAR 2 0 DFKKCJ_CHDSK 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
OADOC Real-Time Payment: Document Number of Down Payment Request CHAR 12 0 OADOC_KK
CCINS Payment Card Type CHAR 4 0 TB033 CC_INSTITUTE
CCNUM Payment cards: Card number CHAR 25 0 * CCNUM
AUNUM Payment cards: Authorization number CHAR 25 0 AUNUM_KK
AUTRA Payment Cards: Authorization Reference Number CHAR 25 0 AUTRA_KK

DFKKPOH foreign key relationships

Table Field Check Table Check Field
0 DFKKPOH CCINS TB033 Payment Cards: Type MANDT
0 DFKKPOH CCINS TB033 Payment Cards: Type CCINS
1 DFKKPOH CHDSK DFKKCJ_CHDSK Internal ID of Cash Desks MANDT
1 DFKKPOH CHDSK DFKKCJ_CHDSK Internal ID of Cash Desks OFFIC
1 DFKKPOH CHDSK DFKKCJ_CHDSK Internal ID of Cash Desks CHDSK
0 DFKKPOH OFFIC DFKKCJ_OFFIC Internal ID of Offline or Agent Branches MANDT
0 DFKKPOH OFFIC DFKKCJ_OFFIC Internal ID of Offline or Agent Branches OFFIC
1 DFKKPOH PPKEY DFKKPP Promises to Pay Header Table MANDT
1 DFKKPOH PPKEY DFKKPP Promises to Pay Header Table PPKEY
0 DFKKPOH RLGRD TFK045A Returns table MANDT
0 DFKKPOH RLGRD TFK045A Returns table RLGRD
0 DFKKPOH RLGRD TFK045A Returns table HBKID
1 DFKKPOH RLHBK TFK045D Assign return reasons BUKRS
1 DFKKPOH RLHBK TFK045D Assign return reasons HBKID
1 DFKKPOH RLHBK TFK045D Assign return reasons RLHBK