SAP ABAP Table DFKKCOL_LOG (Collections Agency File: Settlement Log (Payments))

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DFKKCOL_LOG	Table Relationship Diagram
Short Description	Collections Agency File: Settlement Log (Payments)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OPBEL	☑	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	DFKKKO
3	INKPS	☑	INKPS_KK	NUM03	NUMC	3	0	Collection Item
4	LFDNR	☑	LFDNR_KK	NUMC3	NUMC	3	0	Sequence Number (Internal Use Only)
5	NRZAS	☑	NRZAS_KK	NRZAS_KK	CHAR	12	0	Payment Form Number
6	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
8	TRATYP	☐	TRATYP_KK	TRATYP_KK	CHAR	1	0	Transaction Category for External Collections Agency File
9	VALUT	☐	VALUT_B_KK	CHAR8	CHAR	8	0	Value date (batch input)
10	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	BETRZ	☐	BETRZ_B_KK	CHAR16	CHAR	16	0	Payment amount in transaction currency (batch input)
12	NINKB	☐	NINKB_B_KK	CHAR16	CHAR	16	0	Uncollectable Amount
13	BETRI	☐	BETRI_B_KK	CHAR16	CHAR	16	0	Interest Amount in Transaction Currency (Batch Input)
14	BETRC	☐	BETRC_B_KK	CHAR16	CHAR	16	0	Charge Amount in Transaction Currency (Batch Input)
15	IOPBEL	☐	IOPBEL_KK	OPBEL_KK	CHAR	12	0	Number of an interest document	*
16	GOPBEL	☐	GOPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Charge Document	*
17	AOPBEL	☐	AOPBEL_KK	OPBEL_KK	CHAR	12	0	Document Number of Write-Off Documents	*
18	TXTVW	☐	TXTVW_KK	CHAR80	CHAR	80	0	Note to Payee in Payment
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
21	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DFKKCOL_LOG	MANDT	T000	MANDT
2	DFKKCOL_LOG	OPBEL	DFKKKO	OPBEL
3	DFKKCOL_LOG	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in