SAP table DFKKOPW (Items in contract account document)

SAP table DFKKOPW has 4 primary key fields being MANDT,OPBEL,WHGRP,OPUPW.

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
OPBEL Number of a FI-CA Document CHAR 12 0 DFKKKO OPBEL_KK
WHGRP Repetition group NUMC 3 0 WHGRP_KK
OPUPW Repetition Item in FI-CA Document NUMC 3 0 OPUPW_KK
WHANZ Number of Items for this Repetition Group NUMC 4 0 WHANZ_KK
GPART Business Partner Number CHAR 10 0 GPART_KK
VKONT Contract Account Number CHAR 12 0 VKONT_KK
ABWBL Number of the Substitute FI-CA Document CHAR 12 0 ABWBL_KK
ABWTP Category of Substitute Document in FI-CA CHAR 1 0 ABWTP_KK
P Promise to Pay
R Installment Plan
S Collective Bill
BUDAT Posting Date in the Document DATS 8 0 BUDAT_KK
FAEDN Due date for net payment DATS 8 0 FAEDN_KK
FAEDS Due Date for Cash Discount DATS 8 0 FAEDS_KK
PERSL Key for Period Assignment CHAR 4 0 PERSL_KK
XAESP Printing - No Changes Possible CHAR 1 0 XAESP_KK
MANSP Dunning Lock Reason CHAR 1 0 MANSP_KK
AUGDT Clearing Date DATS 8 0 AUGDT_KK
AUGBL Clearing Document or Printed Document CHAR 12 0 AUGBL_KK
AUGBD Clearing Document Posting Date DATS 8 0 AUGBD_KK
AUGRD Clearing Reason CHAR 2 0 AUGRD_KK
AUGVD Value date for clearing DATS 8 0 AUGVD_KK
AUGOB Item Canceled CHAR 1 0 AUGOB_KK
XAUFL Repetition Item was Broken Down CHAR 1 0 XAUFL_KK
XRAGL Clearing posting reversed CHAR 1 0 XRAGL_KK
XPYOR Item Included in a Payment Order CHAR 1 0 XPYOR_KK
X Item Is Contained in a Payment Order
Y Item Is Contained in a Direct Debit Pre-Notification
STZAL Status of Payment Processing CHAR 1 0 STZAL_KK
B Boleto Created (Brazil)
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
PNNUM SEPA: Number of Direct Debit Pre-Notification CHAR 16 0 PNNUM_KK
PNHKF SEPA: Origin of Direct Debit Pre-Notification CHAR 2 0 PNHKF_KK
Pre-Notification Run
01 Convergent Invoicing
R1 IS-U Invoicing
PNEXD SEPA: Date of Execution of Direct Debit Pre-Notifcation DATS 8 0 PNEXD_KK

DFKKOPW foreign key relationships

Table Field Check Table Check Field
0 DFKKOPW OPBEL DFKKKO Header Data in Open Item Accounting Document MANDT