SAP table DFKKIP_GRP (Payment Specification: Header Data)

SAP table DFKKIP_GRP has 2 primary key fields being MANDT,PDKEY.

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
PDKEY Number of Payment Specification NUMC 12 0 PDKEY_KK
PDTYP Category of Payment Specification CHAR 1 0 PDTYP_KK
1 Preselected for Payment Run
2 Defined for Payment Run
3 Defined for Payment Lot
4 Biller Direct
5 Financial Customer Care
GPARV BP Acting as Payer/Payee in Payment Transactions CHAR 10 0 * GPARV_KK
VKONV Contract account used for payment transactions CHAR 12 0 * VKONV_IP
PDREF Reference Number of Payment Specification CHAR 16 0 PDREF_KK
EIGBV Own Bank Details CHAR 25 0 EIGBV_KK
PYMET Payment Method CHAR 1 0 TFK042Z PYMET_KK
BKVID Bank Details ID CHAR 4 0 BU_BKVID
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
CCARD_ID Payment Card ID CHAR 6 0 BU_CCID
PYBUK Company Code for Automatic Payment Transactions CHAR 4 0 PYBUK_KK
BETRW Payment Amount of Payment Specification CURR 13 2 BETRW_INDPAY
WAERS Currency Key CUKY 5 0 WAERS
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERTIM 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 of Entry TIMS 6 0 CPUTM
DOC1T Payment Document Category CHAR 2 0 DOC1T_KK
DOC1R Reference to Payment Document CHAR 24 0 DOC1R_KK
LAUFD Date ID DATS 8 0 LAUFD_KK
LAUFI Identification for the payment run CHAR 5 0 LAUFI_PAY
C4EYE Check Reason for Workflows Acc. to Dual Control Principle CHAR 2 0 C4EYE_KK
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 * DTAWS
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
TXTSL Text key for the code line on the form CHAR 2 0 TXTSL_042Z
TXERG Text key supplement CHAR 3 0 TXERG
STAIP Payment Specification: Status CHAR 1 0 STAIP_KK
Open
1 To Be Approved
2 Approved
3 Rejected
4 Reopened After Reversal of Payment
5 Clearing Reset
6 Returns
8 Reversed
9 Posted
AUSFD Payment Specification: Execution Date DATS 8 0 AUSFD_INDPAY
PYTXT Text for Payment CHAR 50 0 PYTXT_KK
XFINI Processing Status for Payment Specification CHAR 1 0 XFINI_INDPAY
VALTO Expiry Date of Payment Specification DATS 8 0 VALTO_IP
PYTYP Payment Type Notified CHAR 1 0 PYTYP_KK
C Check
U Transfer
FDGRP Planning Group CHAR 10 0 T035 FDGRP_KK
FDLEV Planning level CHAR 2 0 T036 FDLEV_KK
FDZTG Additional Days for Cash Management NUMC 2 0 FDZTG_KK
FDWBT Planned Amount in Document or G/L Account Currency CURR 13 2 FDWBT_CS
SPZAH Lock Reason for Automatic Payment CHAR 1 0 TFK008 SPZAH_KK
BETRH Amount In Local Currency With +/- Signs CURR 13 2 BETRH_KK
HERKF Origin of Payment Specification CHAR 2 0 HERKF_IP_KK
02 Created Externally (Example: From Biller Direct)
03 Created Internally (Example: From FCC)
04 From Credit Processing
CCINS Payment Card Type CHAR 4 0 TB033 CC_INSTITUTE
CCNUM Payment cards: Card number CHAR 25 0 * CCNUM
CCFOL Payment cards: Payment card suffix CHAR 10 0 CCFOL
DATAB Payment cards: Valid from DATS 8 0 CC_DATAB
DATBI Payment Cards: Valid To DATS 8 0 CC_DATBI
CCNAME Payment cards: Name of cardholder CHAR 40 0 CCNAME
AUNUM Payment cards: Authorization number CHAR 25 0 AUNUM_KK
AUDAT Payment cards: Authorization date DATS 8 0 AUDAT_CC
AUTIM Payment cards: Authorization time TIMS 6 0 AUTIM
AUTRA Payment Cards: Authorization Reference Number CHAR 25 0 AUTRA_KK
CGUID GUID of a Payment Card RAW 16 0 CARD_GUID
ENCTP Type of Encryption CHAR 1 0 CCSECA_ENCTYPE
1 Data in PCA_SECURITY_RAW
2 Data in CCSEC_ENC or CCSEC_ENCV
3 Data in CCARDEC
SKTOW Cash Discount Amount in Currency of Payment Specification CURR 13 2 SKTOW_INDPAY

DFKKIP_GRP foreign key relationships

Table Field Check Table Check Field
0 DFKKIP_GRP CCINS TB033 Payment Cards: Type MANDT
0 DFKKIP_GRP CCINS TB033 Payment Cards: Type CCINS
1 DFKKIP_GRP FDGRP T035 Planning groups GRUPP
0 DFKKIP_GRP FDLEV T036 Planning levels EBENE
1 DFKKIP_GRP PYMET TFK042Z Payment Program: Additional Specifications for Payt Methods LAND1
1 DFKKIP_GRP PYMET TFK042Z Payment Program: Additional Specifications for Payt Methods ZLSCH
0 DFKKIP_GRP SPZAH TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS