SAP ABAP Table FKKCOLLAG (Derivation of Responsible Collection Agency)

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	INTTAB	Structure
Structure	FKKCOLLAG	Table Relationship Diagram
Short Description	Derivation of Responsible Collection Agency

Delivery and Maintenance

Pool/cluster
Delivery Class
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	INKGP	☐	INKGP_KK	BU_PARTNER	CHAR	10	0	Collection Agency	TFK050B
2	TMPR1	☐	FICA_TMP_RESULT	CHAR20	CHAR	20	0	Temporary Interim Result
3	TMPR2	☐	FICA_TMP_RESULT	CHAR20	CHAR	20	0	Temporary Interim Result
4	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
5	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	TB004
6	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	T005
7	CNDSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	T005
8	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	TB019
9	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
10	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
13	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
14	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
15	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
16	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
17	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
18	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
19	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
20	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
21	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
22	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
24	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
25	SPART	☐	SPART_KK	SPART	CHAR	2	0	Division	*
26	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
27	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
28	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
29	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
30	KOFIZ	☐	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
31	BETRH	☐	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
32	.INCLUDE	☐				0	0
33	.INCLUDE	☐				0	0
34	.INCLUDE	☐				0	0
35	.INCLUDE	☐				0	0	Industry Include PS for Derivation of Collection Agency
36	.INCLUDE	☐				0	0
37	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKKCOLLAG	BPKIND	TB004	BPKIND		1	CN
2	FKKCOLLAG	CNDSC	T005	LAND1		1	CN
3	FKKCOLLAG	COUNTRY	T005	LAND1		1	CN
4	FKKCOLLAG	GPART	BUT000	PARTNER		1	CN
5	FKKCOLLAG	HVORG	TFKHVO	HVORG		1	CN
6	FKKCOLLAG	IND_SECTOR	TB023	IND_SECTOR		1	CN
7	FKKCOLLAG	INKGP	TFK050B	INKGP		1	CN
8	FKKCOLLAG	LEGAL_ENTY	TB019	LEGAL_ENTY		1	CN
9	FKKCOLLAG	LEGAL_ORG	TB032	LEGAL_ORG		1	CN
10	FKKCOLLAG	NATIO	T005	LAND1		1	CN
11	FKKCOLLAG	REGIOGROUP	ADRREGGRP	REGIOGROUP		1	CN
12	FKKCOLLAG	REGION	T005S	BLAND		1	CN
13	FKKCOLLAG	TRANSPZONE	TZONE	ZONE1		1	CN
14	FKKCOLLAG	TVORG	TFKTVO	TVORG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	472