SAP ABAP Table FMCACOLLAG (Derivation of Responsible Collection Agency)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-PS-CA (Application Component) Public Sector Contract Accounting
     ⤷ FMCAD (Package) PSCD: Basics & Documents

Basic Data

Table Category	INTTAB	Structure
Structure	FMCACOLLAG	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	☐	FMCA_TMP_RESULT	CHAR20	CHAR	20	0	Temporary Interim Result
3	TMPR2	☐	FMCA_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	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
23	VKTYP_PS	☐	VKTYP_KK	VKTYP_KK	CHAR	2	0	Contract Account Category	TFK002A
24	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
25	PSOBTYP	☐	PSOBTYP_PS	PSOBTYP_PS	CHAR	4	0	Contract Object Type	TPSOB001
26	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
27	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
28	KOFIZ	☐	KOFIZ_KK	KOFIZ_KK	CHAR	2	0	Account Determination ID
29	BETRH	☐	BETRH_KK	WRTV7	CURR	13	2	Amount In Local Currency With +/- Signs
30	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in