SAP ABAP Table FCOMS_COSTCENTER_DQUERY (BOL : Cost Center Master Data Dynamic Query)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO (Application Component) Controlling
     ⤷ FCOM_MASTERDATA_CORE (Package) Master data

Basic Data

Table Category	INTTAB	Structure
Structure	FCOMS_COSTCENTER_DQUERY	Table Relationship Diagram
Short Description	BOL : Cost Center Master Data Dynamic Query

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	.INCLUDE	☐				0	0	BOL: Cost Center Root Object Key
2	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
3	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
4	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
5	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
6	VERAK_USER	☐	VERAK_USER	XUBNAME	CHAR	12	0	User Responsible	USR02
7	KSTGR	☐	KOSZSCHL	CHAR6	CHAR	6	0	CO-CCA Overhead Key
8	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
9	ERSDA	☐	ERFDT	DATUM	DATS	8	0	Created on
10	USNAM	☐	ERFNM	USNAM	CHAR	12	0	Entered by
11	BKZKP	☐	BKZKP	YNFLG	CHAR	1	0	Lock Indicator for Actual Primary Postings
12	BKZKS	☐	BKZKS	YNFLG	CHAR	1	0	Lock Indicator for Actual Secondary Costs
13	BKZER	☐	BKZER	YNFLG	CHAR	1	0	Lock Indicator for Actual Revenue Postings
14	BKZOB	☐	BKZOB	YNFLG	CHAR	1	0	Lock Indicator for Commitment Update
15	PKZKP	☐	PKZKP	YNFLG	CHAR	1	0	Lock Indicator for Plan Primary Costs
16	PKZKS	☐	PKZKS	YNFLG	CHAR	1	0	Lock Indicator for Plan Secondary Costs
17	PKZER	☐	PKZER	YNFLG	CHAR	1	0	Lock Indicator for Planning Revenues
18	MGEFL	☐	MGEFL	YNFLG	CHAR	1	0	Indicator for Recording Consumption Quantities
19	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
20	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	ABTEI	☐	ABTEI	ABTEI	CHAR	12	0	Department
22	KOSAR	☐	KOSAR	KOSAR	CHAR	1	0	Cost Center Category	TKA05
23	VERAK	☐	VERAK	VERAK	CHAR	20	0	Person Responsible
24	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
25	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
26	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
27	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
28	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
29	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
30	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
31	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
32	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
33	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
34	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
35	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
36	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
37	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
38	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
39	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
40	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
41	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
42	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
43	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
44	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
45	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
46	DRNAM	☐	KDNAM	DRNAM	CHAR	4	0	Printer destination for CCtr report
47	KHINR	☐	KHINR	SETNR	CHAR	12	0	Standard Hierarchy Area
48	KOMPL	☐	KSKOM	YNFLG	CHAR	1	0	Completion flag for the cost center master record
49	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
50	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
51	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
52	CPI_TEMPL	☐	CCA_TEMPL_CPI	ABC_TEMPL	CHAR	10	0	Template for Activity-Independent Formula Planning	COTPL
53	CPD_TEMPL	☐	CCA_TEMPL_CPD	ABC_TEMPL	CHAR	10	0	Template for Activity-Dependent Formula Planning	COTPL
54	SCI_TEMPL	☐	CCA_TEMPL_SCI	ABC_TEMPL	CHAR	10	0	Template: Activity-Independent Allocation to Cost Center	COTPL
55	SCD_TEMPL	☐	CCA_TEMPL_SCD	ABC_TEMPL	CHAR	10	0	Template: Activity-Dependent Allocation to Cost Center	COTPL
56	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
57	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
58	CSKS_CI	☐	CSKS_CI		STRU	0	0
59	DUMMY_FIELD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
60	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FCOMS_COSTCENTER_DQUERY	BUKRS	T001	BUKRS
2	FCOMS_COSTCENTER_DQUERY	CPD_TEMPL	COTPL	TEMPLATE
3	FCOMS_COSTCENTER_DQUERY	CPI_TEMPL	COTPL	TEMPLATE
4	FCOMS_COSTCENTER_DQUERY	FUNC_AREA	TFKB	FKBER
5	FCOMS_COSTCENTER_DQUERY	GSBER	TGSB	GSBER
6	FCOMS_COSTCENTER_DQUERY	KALSM	T683	KALSM
7	FCOMS_COSTCENTER_DQUERY	KOSAR	TKA05	KOSAR
8	FCOMS_COSTCENTER_DQUERY	LAND1	T005	LAND1
9	FCOMS_COSTCENTER_DQUERY	REGIO	T005S	BLAND
10	FCOMS_COSTCENTER_DQUERY	SCD_TEMPL	COTPL	TEMPLATE
11	FCOMS_COSTCENTER_DQUERY	SCI_TEMPL	COTPL	TEMPLATE
12	FCOMS_COSTCENTER_DQUERY	SPRAS	T002	SPRAS
13	FCOMS_COSTCENTER_DQUERY	TXJCD	TTXJ	TXJCD
14	FCOMS_COSTCENTER_DQUERY	VERAK_USER	USR02	BNAME
15	FCOMS_COSTCENTER_DQUERY	WAERS	TCURC	WAERS

History

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