SAP COERT Special Data Transfer: Sales Order -> Accounting Table data and field list

COERT 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 "Special Data Transfer: Sales Order -> Accounting" 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_COERT TYPE COERT.

The COERT table consists of various fields, each holding specific information or linking keys about Special Data Transfer: Sales Order -> Accounting data available in SAP. These include AWREF (Reference Document Number), AWORG (Reference Organizational Units), AWPOS (Reference line item), KZVBR (Consumption Posting)... 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. .

COERT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP COERT 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 COERT 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
AWTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
AWREF	Reference Document Number	AWREF	CHAR	10		ALPHA	AWREF
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
AWPOS	Reference line item	AWPOS	CHAR	10			AWPOS
KZVBR	Consumption Posting	KZVBR	CHAR	1			KZVBR
OBJNR	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
ORDERED	Indicator: One Order Exists for the Item	ORDERED	CHAR	1			QKZ

Key field

Non-key field

< COERR_TABLES - Controlling Cockpit: Data in Table for Check COER_KEY - Reference Structure for SD Document Number Table >

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

As COERT 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 COERT as there is no data to select.

How to access SAP table COERT

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

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