SAP FCOMS_COSTCENTER_DQUERY BOL : Cost Center Master Data Dynamic Query Table data and field list

FCOMS_COSTCENTER_DQUERY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "BOL : Cost Center Master Data Dynamic Query" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FCOMS_COSTCENTER_DQUERY TYPE FCOMS_COSTCENTER_DQUERY.

The FCOMS_COSTCENTER_DQUERY table consists of various fields, each holding specific information or linking keys about BOL : Cost Center Master Data Dynamic Query data available in SAP. These include KOKRS (Controlling Area), KOSTL (Cost Center), DATAB (Valid-From Date), DATBI (Valid To Date)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FCOMS_COSTCENTER_DQUERY structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FCOMS_COSTCENTER_DQUERY structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FCOMS_COSTCENTER_DQUERY table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
KOKRS	Controlling Area	KOKRS	CHAR	4	Assigned to domain		CACCD	CAC
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
DATAB	Valid-From Date	DATAB	DATS	8			DATUM
DATBI	Valid To Date	DATBI	DATS	8			DATUM
VERAK_USER	User Responsible	VERAK_USER	CHAR	12	USR02		XUBNAME	XUS	USER_COMP
KSTGR	CO-CCA Overhead Key	KOSZSCHL	CHAR	6			CHAR6
KTEXT	General Name	KTEXT	CHAR	20			TEXT20
ERSDA	Created on	ERFDT	DATS	8			DATUM
USNAM	Entered by	ERFNM	CHAR	12			USNAM
BKZKP	Lock Indicator for Actual Primary Postings	BKZKP	CHAR	1			YNFLG
BKZKS	Lock Indicator for Actual Secondary Costs	BKZKS	CHAR	1			YNFLG
BKZER	Lock Indicator for Actual Revenue Postings	BKZER	CHAR	1			YNFLG
BKZOB	Lock Indicator for Commitment Update	BKZOB	CHAR	1			YNFLG
PKZKP	Lock Indicator for Plan Primary Costs	PKZKP	CHAR	1			YNFLG
PKZKS	Lock Indicator for Plan Secondary Costs	PKZKS	CHAR	1			YNFLG
PKZER	Lock Indicator for Planning Revenues	PKZER	CHAR	1			YNFLG
MGEFL	Indicator for Recording Consumption Quantities	MGEFL	CHAR	1			YNFLG
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
ABTEI	Department	ABTEI	CHAR	12			ABTEI
KOSAR	Cost Center Category	KOSAR	CHAR	1	TKA05		KOSAR	PCA_KOSAR
VERAK	Person Responsible	VERAK	CHAR	20			VERAK
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
LAND1	Country Key	LAND1	CHAR	3	T005		LAND1	LND
ANRED	Title	ANRED	CHAR	15			TEXT15
NAME1	Name 1	NAME1_GP	CHAR	35			NAME
NAME2	Name 2	NAME2_GP	CHAR	35			NAME
NAME3	Name 3	NAME3_GP	CHAR	35			NAME
NAME4	Name 4	NAME4_GP	CHAR	35			NAME
ORT01	City	ORT01_GP	CHAR	35			TEXT35
ORT02	District	ORT02_GP	CHAR	35			TEXT35
STRAS	House number and street	STRAS_GP	CHAR	35			TEXT35
PFACH	PO Box	PFACH	CHAR	10			PFACH
PSTLZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
PSTL2	P.O. Box Postal Code	PSTL2	CHAR	10			PSTLZ
REGIO	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
SPRAS	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
TELBX	Telebox number	TELBX	CHAR	15			TEXT15
TELF1	First telephone number	TELF1	CHAR	16			TEXT16
TELF2	Second telephone number	TELF2	CHAR	16			TEXT16
TELFX	Fax Number	TELFX	CHAR	31			TEXT31
TELTX	Teletex number	TELTX	CHAR	30			TEXT30
TELX1	Telex number	TELX1	CHAR	30			TEXT30
DATLT	Data communication line no.	DATLT	CHAR	14			TEXT14
DRNAM	Printer destination for CCtr report	KDNAM	CHAR	4			DRNAM
KHINR	Standard Hierarchy Area	KHINR	CHAR	12			SETNR
KOMPL	Completion flag for the cost center master record	KSKOM	CHAR	1			YNFLG
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	TTXJ		TXJCD	TXJ
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
KALSM	Costing Sheet	AUFKALSM	CHAR	6	T683		KALSM
CPI_TEMPL	Template for Activity-Independent Formula Planning	CCA_TEMPL_CPI	CHAR	10	COTPL		ABC_TEMPL	ABT
CPD_TEMPL	Template for Activity-Dependent Formula Planning	CCA_TEMPL_CPD	CHAR	10	COTPL		ABC_TEMPL	ABT
SCI_TEMPL	Template: Activity-Independent Allocation to Cost Center	CCA_TEMPL_SCI	CHAR	10	COTPL		ABC_TEMPL	ABT
SCD_TEMPL	Template: Activity-Dependent Allocation to Cost Center	CCA_TEMPL_SCD	CHAR	10	COTPL		ABC_TEMPL	ABT
FUNC_AREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
LOGSYSTEM	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
CSKS_CI				0
DUMMY_FIELD	Checkbox	XFELD	CHAR	1			XFELD

Key field

Non-key field

< FCOMS_COSTCENTER_DELIMIT - BOL : Cost Center Master Data Delimit FCOMS_COSTCENTER_KEY - BOL: Cost Center Root Object Key >

How do I retrieve data from SAP structure FCOMS_COSTCENTER_DQUERY using ABAP code?

As FCOMS_COSTCENTER_DQUERY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FCOMS_COSTCENTER_DQUERY as there is no data to select.

How to access SAP table FCOMS_COSTCENTER_DQUERY

Within an ECC or HANA version of SAP you can also view further information about FCOMS_COSTCENTER_DQUERY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).