SAP ABAP Table SITAGCYDATA (Agency Collections: Global Data)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CD (Application Component) Collections/Disbursements
     ⤷ FSCDITAGCY_DDIC (Package) FS-CD: Italian Agency Management - DDIC Objects

Basic Data

Table Category	INTTAB	Structure
Structure	SITAGCYDATA	Table Relationship Diagram
Short Description	Agency Collections: Global Data

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	USERDATA	☐	SITAGCYUSERDATA		STRU	0	0
2	DESIGN	☐			STRG	0	0
3	X_PDF	☐	XFELD	XFELD	CHAR	1	0	Checkbox
4	LINES_COLLECT	☐			INT4	10	0
5	LINES_OPOVRVW	☐			INT4	10	0
6	LINES_REVERSE	☐			INT4	10	0
7	LINES_TEMPCLAR	☐			INT4	10	0
8	LINES_COSTS	☐			INT4	10	0
9	LINES_DIFFTP	☐			INT4	10	0
10	LINES_DIFFTPOVW	☐			INT4	10	0
11	LINES_BANKTR	☐			INT4	10	0
12	LINES_DUNNING	☐			INT4	10	0
13	LINES_TCPROP	☐			INT4	10	0
14	SELVAR	☐	SEL_ITAGCY	SEL_ITAGCY	CHAR	2	0	Selection Variant
15	SMARTFORM_PM_DC	☐	TDSFNAME	TDSFNAME	CHAR	30	0	Smart Forms: Form Name
16	SMARTFORM_PM_TP	☐	TDSFNAME	TDSFNAME	CHAR	30	0	Smart Forms: Form Name
17	X_RECEIPT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
18	ACTIVITY	☐	SITAGCYACT		STRU	0	0
19	.INCLUDE	☐				0	0	Activities that Can Be Executed in Agency Collections
20	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
21	ACTIVITY	☐	ACT_ITAGCY		CHAR	4	0	Activity in Agency Collections
22	PARENT	☐	PARENTACT_ITAGCY		CHAR	4	0	Superordinate Activity in Agency Collections
23	NODEORDER	☐	NODEORDER_ITAGCY	NUMC2	NUMC	2	0	Sequence of Activities in Tree Structure
24	APPLNAME	☐	APPLNAME_ITAGCY	O2APPLNAME	CHAR	30	0	Name of BSP Application
25	TXTACT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
26	CONTCLASS	☐	O2CTRCLS	SEOCLSNAME	CHAR	30	0	Controller Class
27	STARTPAGE	☐	O2PAGEEXT	O2PAGEEXT	CHAR	70	0	Name of BSP Page (Upper and Lower Case)
28	XSELECTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
29	ORGUNIT	☐	SITAGCYORG		STRU	0	0
30	DATA	☐	SITAGCYORGDESCR		STRU	0	0
31	ORGUNIT	☐	OBJEC		STRU	0	0
32	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
33	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
34	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
35	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
36	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
37	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
38	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
39	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
40	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
41	REALO	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
42	DIMABROKER	☐	DIMABROKER		STRU	0	0
43	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
44	INSOBJECT	☐	INSOBJECT_MD	INSOBJECT_MD	CHAR	20	0	Identification for an Insurance Object
45	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
46	.INCLUDE	☐				0	0	IO: Broker-Specific Data
47	PAYPER	☐	BROK_NOTE_PER_MD	COPER_KK	CHAR	1	0	FS-CD: Reporting Interval for Broker Data
48	PERPOS	☐	BROK_PER_POS_MD	PERPOS_SC	CHAR	1	0	FS-CD: Item Within a Reporting Interval
49	PEROFF	☐	BROK_PER_OFF_MD	PEROFF_SC	DEC	3	0	FS-CD: Shift for Period Item in Days
50	XCOINS_ACT	☐	XCOINS_ACT_BROK_MD	XFELD	CHAR	1	0	FS-CD: Flag: Broker Transfers Coinsurance Shares
51	.INCLUDE	☐				0	0	IO: Item Categories for Broker Report
52	POSCAT_01	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
53	POSCAT_02	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
54	POSCAT_03	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
55	POSCAT_04	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
56	POSCAT_05	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
57	.INCLUDE	☐				0	0	IO: Other Broker-Specific Data
58	BROSTMTYP	☐	BROSTMTYP_MD	BROSTMTYP_MD	CHAR	2	0	FS-CD: Broker Report Category
59	INSOBJ_COMM	☐	INSOBJECT_COMM_MD	INSOBJECT_MD	CHAR	20	0	IO: Identification for a Broker Commission Contract
60	CLARIFACC	☐	CLARIFACC_BRO	VKONT_KK	CHAR	12	0	Subledger Clarification Account for Broker
61	XPOST_AFTER_PYM	☐	XPOST_AFTER_PYM_MD	XFELD	CHAR	1	0	FS-CD: Only Post Broker Report After Payment Receipt
62	GRACE_PERIOD	☐	GRACE_PERIOD_MD	GRACE_PERIOD_MD	CHAR	1	0	FS-CD: Period for Posting with Shifted Due Date
63	GRACE_VALUE	☐	GRACE_VALUE_MD	GRACE_VALUE_MD	NUMC	3	0	FS-CD: No. of Periods for Posting with Shifted Due Date
64	AGENCYDETAIL	☐	AGDETAIL_ITAGCY		STRU	0	0
65	AGENCYTYPE	☐	AGTYPE_ITAGCY	AGTYPE_ITAGCY	CHAR	2	0	Key for Agency Category in Agency Collections
66	XNETPRINC	☐	XNETPRINC_ITAGCY	XFELD	CHAR	1	0	Flag: Report Using Net Principle
67	SUBDATA	☐	TITAGCYORGDESCR		TTYP	0	0
68	TOPDATA	☐	SITAGCYORGDESCR		STRU	0	0
69	ORGUNIT	☐	OBJEC		STRU	0	0
70	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
71	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
72	OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
73	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
74	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
75	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
76	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
77	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
78	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
79	REALO	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
80	DIMABROKER	☐	DIMABROKER		STRU	0	0
81	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
82	INSOBJECT	☐	INSOBJECT_MD	INSOBJECT_MD	CHAR	20	0	Identification for an Insurance Object
83	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
84	.INCLUDE	☐				0	0	IO: Broker-Specific Data
85	PAYPER	☐	BROK_NOTE_PER_MD	COPER_KK	CHAR	1	0	FS-CD: Reporting Interval for Broker Data
86	PERPOS	☐	BROK_PER_POS_MD	PERPOS_SC	CHAR	1	0	FS-CD: Item Within a Reporting Interval
87	PEROFF	☐	BROK_PER_OFF_MD	PEROFF_SC	DEC	3	0	FS-CD: Shift for Period Item in Days
88	XCOINS_ACT	☐	XCOINS_ACT_BROK_MD	XFELD	CHAR	1	0	FS-CD: Flag: Broker Transfers Coinsurance Shares
89	.INCLUDE	☐				0	0	IO: Item Categories for Broker Report
90	POSCAT_01	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
91	POSCAT_02	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
92	POSCAT_03	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
93	POSCAT_04	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
94	POSCAT_05	☐	XPOSCAT_VK	XFELD	CHAR	1	0	Category for Broker Report
95	.INCLUDE	☐				0	0	IO: Other Broker-Specific Data
96	BROSTMTYP	☐	BROSTMTYP_MD	BROSTMTYP_MD	CHAR	2	0	FS-CD: Broker Report Category
97	INSOBJ_COMM	☐	INSOBJECT_COMM_MD	INSOBJECT_MD	CHAR	20	0	IO: Identification for a Broker Commission Contract
98	CLARIFACC	☐	CLARIFACC_BRO	VKONT_KK	CHAR	12	0	Subledger Clarification Account for Broker
99	XPOST_AFTER_PYM	☐	XPOST_AFTER_PYM_MD	XFELD	CHAR	1	0	FS-CD: Only Post Broker Report After Payment Receipt
100	GRACE_PERIOD	☐	GRACE_PERIOD_MD	GRACE_PERIOD_MD	CHAR	1	0	FS-CD: Period for Posting with Shifted Due Date
101	GRACE_VALUE	☐	GRACE_VALUE_MD	GRACE_VALUE_MD	NUMC	3	0	FS-CD: No. of Periods for Posting with Shifted Due Date
102	AGENCYDETAIL	☐	AGDETAIL_ITAGCY		STRU	0	0
103	AGENCYTYPE	☐	AGTYPE_ITAGCY	AGTYPE_ITAGCY	CHAR	2	0	Key for Agency Category in Agency Collections
104	XNETPRINC	☐	XNETPRINC_ITAGCY	XFELD	CHAR	1	0	Flag: Report Using Net Principle
105	TOPSUBDATA	☐	TITAGCYORGDESCR		TTYP	0	0
106	CASHDESK	☐	SITAGCYCDM		STRU	0	0
107	.INCLUDE	☐				0	0	Master Data for Cash Desks
108	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
109	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
110	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
111	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID
112	CDESK	☐	CDESK_ITAGCY	CHAR4	CHAR	4	0	Cash Desk in Agency Collections
113	UNAME	☐	CDESK_UNAME_ITAGCY	UNAME	CHAR	12	0	User Name for Person Registered for Cash Desk
114	CRDATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
115	CRNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
116	XCLOSED	☐	XCLOSED_ITAGCY	XFELD	CHAR	1	0	Flag Whether Cash Desk Is Closed
117	KEY	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
118	TXTCD	☐	TXTCD_ITAGCY	TEXT30	CHAR	30	0	Description of Cash Desk
119	SELECTABLE	☐	CDSELECTABLE_ITAGCY	CHAR1	CHAR	1	0	Selectability of Cash Desk
120	TXTORG	☐	TXTORG_ITAGCY	TEXT40	CHAR	40	0	Description of an Organizational Unit
121	TXTSELECTABLE	☐	TXTSELECTABLE_ITAGCY	TEXT60	CHAR	60	0	Description of Cash Desk Status
122	USERS	☐	TITAGCY_CDESK_UNAME		TTYP	0	0
123	MODE	☐	SITAGCYCDMODE		STRU	0	0
124	.INCLUDE	☐				0	0	Mode Within Cash Desk
125	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
126	CDMODE	☐	MODE_ITAGCY	CHAR3	CHAR	3	0	Mode
127	.INCLUDE	☐				0	0	Mode Settings Structure
128	CONTTYPE	☐	CONTTYPE_ITAGCY	CONTTYPE_ITAGCY	CHAR	1	0	Container Category
129	XPRINTREC	☐	XPRINTREC_ITAGCY	XFELD	CHAR	1	0	Flag: Receipt Print
130	CLCOMPCODE	☐	CLCOMPCODE_ITAGCY	BUKRS	CHAR	4	0	Clearing Company Code
131	COMPCODE	☐	SELCOMPCODE_ITAGCY	BUKRS	CHAR	4	0	Selection Company Code in Container
132	TRCURRENCY	☐	TRCURR_ITAGCY	WAERS	CUKY	5	0	Transaction Currency for a Container
133	CURRENCY	☐	SELCURR_ITAGCY	WAERS	CUKY	5	0	Selection Currency for a Container
134	XNO_PAYMETHOD	☐	XNO_PAYMETHOD_ITAGCY	XFELD	CHAR	1	0	Flag: Do Not Use Any Payment Methods
135	XNO_REPAMOUNT	☐	XNO_REPAMOUNT_ITAGCY	XFELD	CHAR	1	0	Flag: No Reported Amount
136	DET_PAYAMOUNT	☐	DET_PAYAMOUNT_ITAGCY	DET_PAYAMOUNT_ITAGCY	CHAR	1	0	Determination of Payment Amount if No Payt Methods Are Used
137	XHIERCOLL	☐	XHIERCOLL_ITAGCY	XFELD	CHAR	1	0	Indicator: Hierarchy-Collections Is Active
138	TXTMODE	☐	TXTMODE_ITAGCY	TEXT30	CHAR	30	0	Description of a Mode
139	CONTAINER	☐	SITAGCYCONTREP		STRU	0	0
140	CONTAINER	☐	SITAGCYCONTH		STRU	0	0
141	.INCLUDE	☐				0	0	Header Data for Cash Desk Container
142	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
143	CONT	☐	CONT_ITAGCY	CONT_ITAGCY	CHAR	12	0	Cash Desk Container ID
144	.INCLUDE	☐				0	0	Cash Desk in Agency Collections
145	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
146	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
147	OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID
148	CDESK	☐	CDESK_ITAGCY	CHAR4	CHAR	4	0	Cash Desk in Agency Collections
149	CDMODE	☐	MODE_ITAGCY	CHAR3	CHAR	3	0	Mode
150	CONTSTATUS	☐	CONTSTATUS_ITAGCY	CONTSTATUS_ITAGCY	CHAR	1	0	Status of Cash Desk Container
151	INV_FR	☐	PERDFROM_BRO	DATUM	DATS	8	0	Invoicing Period From (Broker Report)
152	INV_TO	☐	PERDTO_BRO	DATUM	DATS	8	0	Invoicing Period to (Broker Report)
153	FIKEY	☐	FIKEY_KK	FIKEY_KK	CHAR	12	0	Reconciliation Key for General Ledger
154	PAYLINK	☐	PAYID_ITAGCY		RAW	16	0	Payment ID
155	PLVAR_TP	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
156	OTYPE_TP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
157	OBJID_TP	☐	HROBJID	HROBJID	NUMC	8	0	Object ID
158	XNETPRINC	☐	XNETPRINC_ITAGCY	XFELD	CHAR	1	0	Flag: Report Using Net Principle
159	XPOSREV	☐	XPOSREV_ITAGCY	XFELD	CHAR	1	0	Flag: Individual Items Reversed
160	POSTDATE	☐	POSTDATE_ITAGCY	DATUM	DATS	8	0	Posting Date
161	SRCHTERM	☐	SRCHKEY_ITAGCY	SRCHKEY_ITAGCY	CHAR	30	0	Search Term for Container
162	GRPKEY	☐	GRPKEY_ITAGCY	CHAR35	CHAR	35	0	Grouping Characteristic
163	MAXPOS	☐	MAXPOS_ITAGCY	NUM04	NUMC	4	0	Maximum Assigned Item Number for a Container
164	AMOUNT_WTAX	☐	WTAX_AMOUNT_ITAGCY	WRTV7	CURR	13	2	Reported Withholding Tax
165	CONTROL_POS	☐	SEQNO_ITAGCY	NUM04	NUMC	4	0	Sequence Number
166	CONTROL_PREM	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
167	CONTROL_COMM	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
168	AMOUNT_DIFF	☐	DIFFB_KK	WRTV7	CURR	13	2	Difference Amount in Clearing Processing
169	DIFFRULE	☐	DIFFRULE_ITAGCY	DIFFRULE_ITAGCY	CHAR	2	0	Rules for Handling Differences
170	.INCLUDE	☐				0	0	Mode Settings Structure
171	CONTTYPE	☐	CONTTYPE_ITAGCY	CONTTYPE_ITAGCY	CHAR	1	0	Container Category
172	XPRINTREC	☐	XPRINTREC_ITAGCY	XFELD	CHAR	1	0	Flag: Receipt Print
173	CLCOMPCODE	☐	CLCOMPCODE_ITAGCY	BUKRS	CHAR	4	0	Clearing Company Code
174	COMPCODE	☐	SELCOMPCODE_ITAGCY	BUKRS	CHAR	4	0	Selection Company Code in Container
175	TRCURRENCY	☐	TRCURR_ITAGCY	WAERS	CUKY	5	0	Transaction Currency for a Container
176	CURRENCY	☐	SELCURR_ITAGCY	WAERS	CUKY	5	0	Selection Currency for a Container
177	XNO_PAYMETHOD	☐	XNO_PAYMETHOD_ITAGCY	XFELD	CHAR	1	0	Flag: Do Not Use Any Payment Methods
178	XNO_REPAMOUNT	☐	XNO_REPAMOUNT_ITAGCY	XFELD	CHAR	1	0	Flag: No Reported Amount
179	DET_PAYAMOUNT	☐	DET_PAYAMOUNT_ITAGCY	DET_PAYAMOUNT_ITAGCY	CHAR	1	0	Determination of Payment Amount if No Payt Methods Are Used
180	XHIERCOLL	☐	XHIERCOLL_ITAGCY	XFELD	CHAR	1	0	Indicator: Hierarchy-Collections Is Active
181	.INCLUDE	☐				0	0	Structure with Creation Data
182	CRDATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
183	CRTIME	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
184	CRNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
185	.INCLUDE	☐				0	0	Structure with Change Data
186	CHNGDATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
187	CHNGTIME	☐	AETIM_KK	UZEIT	TIMS	6	0	Time at Which the Object Was Last Changed
188	CHNGNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
189	TXTMODE	☐	TXTMODE_ITAGCY	TEXT30	CHAR	30	0	Description of a Mode
190	TXTSTATUS	☐	TXTSTATUS_ITAGCY	TEXT60	CHAR	60	0	Description of Status
191	TXTCDESK	☐	TXTCD_ITAGCY	TEXT30	CHAR	30	0	Description of Cash Desk
192	TXTCONT	☐			STRG	0	0
193	BROKERREPORTS	☐	TITAGCYBROKERREPORT		TTYP	0	0

History

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