SAP table DFKKPP (Promises to Pay Header Table)
SAP table DFKKPP has 2 primary key fields being MANDT,PPKEY.
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 | ||||||||||||||||
PPKEY | Identification of Promise to Pay | CHAR | 12 | 0 | PPKEY_KK | ||||||||||||||||
PRAMT_CHR | Charges for Promise to Pay | CURR | 13 | 2 | PRAMT_CHR_KK | ||||||||||||||||
PRAMT_INT | Interest for Promise to Pay | CURR | 13 | 2 | PRAMT_INT_KK | ||||||||||||||||
OPBEL_CHR | Number of Charges Document for Promise to Pay | CHAR | 12 | 0 | OPBEL_CHR_KK | ||||||||||||||||
OPBEL_INT | Number of Interest Document for Promise to Pay | CHAR | 12 | 0 | OPBEL_INT_KK | ||||||||||||||||
OPBEL_INT_ADJ | Number of Interest Adjustment Document in Promise to Pay | CHAR | 12 | 0 | OPBEL_INT_ADJ_KK | ||||||||||||||||
PRGPA | Business Partner that Promised Payment | CHAR | 10 | 0 | * | PRGPA_KK | |||||||||||||||
GPART | Business Partner Number | CHAR | 10 | 0 | * | GPART_KK | |||||||||||||||
VKONT | Contract Account Number (If Unique) | CHAR | 12 | 0 | VKONT_UNIQUE_KK | ||||||||||||||||
BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||||||||||||||||
PPRSC | Reason for Promise to Pay | CHAR | 2 | 0 | PPRSC_KK | ||||||||||||||||
PPRSW | Reason for Withdrawal of Promise to Pay | CHAR | 2 | 0 | PPRSW_KK | ||||||||||||||||
PPCAT | Category of Promise to Pay | CHAR | 2 | 0 | PPCAT_KK | ||||||||||||||||
C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | CHAR | 2 | 0 | C4EYE_KK | ||||||||||||||||
C4LEV | Multiple Control Principle: Number of Checks | NUMC | 1 | 0 | C4LEV_KK | ||||||||||||||||
PRCUR | Currency for Payment | CUKY | 5 | 0 | PRCUR_KK | ||||||||||||||||
PRAMT | Payment Amount Promised | CURR | 13 | 2 | PRAMT_KK | ||||||||||||||||
XP2PS | Simple Promise to Pay | CHAR | 1 | 0 | XP2PS_KK | ||||||||||||||||
FDGRP | Planning Group | CHAR | 10 | 0 | * | FDGRP_KK | |||||||||||||||
FDLEV | Planning level | CHAR | 2 | 0 | * | FDLEV_KK | |||||||||||||||
BETRZ_PC | Payment Amount in Currency of Promise to Pay | CURR | 13 | 2 | BETRZ_PC_KK | ||||||||||||||||
RDAMT | Amount Cleared by Other Means | CURR | 13 | 2 | RDAMT_KK | ||||||||||||||||
ERNAM | Created by | CHAR | 12 | 0 | ERNAM_KK | ||||||||||||||||
ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||||||||||
ERTIM | Time at which the object was created | TIMS | 6 | 0 | ERTIM_KK | ||||||||||||||||
CHDAT | Check Date for Status Determination | DATS | 8 | 0 | CHDAT_KK | ||||||||||||||||
PPSTA | Status of Promise to Pay | CHAR | 1 | 0 | PPSTA_KK |
|
|||||||||||||||
DEGFF | Level of Fulfillment of Promise to Pay | DEC | 5 | 2 | DEGFF_KK | ||||||||||||||||
XSTCH | Status Was Subsequently Changed | CHAR | 1 | 0 | XSTCH_KK | ||||||||||||||||
PPKEY_NEW | Promise to Pay Created as Replacement | CHAR | 12 | 0 | PPKEY_NEW_KK | ||||||||||||||||
XINDR | Individual Installments Agreed | CHAR | 1 | 0 | XINDR_KK | ||||||||||||||||
PRAMT_MIG | Promised Payment Amount Before Migration | CURR | 13 | 2 | PRAMT_MIG_KK | ||||||||||||||||
PPKEY_OLD | Identification of a Promise to Pay in the Legacy System | CHAR | 20 | 0 | PPKEY_OLD_KK |