SAP OREXT CO order fields for external data transfer Table data and field list

OREXT 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 "CO order fields for external data transfer" 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_OREXT TYPE OREXT.

The OREXT table consists of various fields, each holding specific information or linking keys about CO order fields for external data transfer data available in SAP. These include AUART (Order Type), KTEXT (Description), KOKRS (Controlling Area), BUKRS (Company Code)... 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. .

OREXT 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 OREXT 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 OREXT 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
AUFNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
AUART	Order Type	AUFART	CHAR	4	Assigned to domain		AUFART	AAT
KTEXT	Description	AUFTEXT	CHAR	40			TEXT40
KOKRS	Controlling Area	KOKRS	CHAR	4	Assigned to domain		CACCD	CAC
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
WERKS	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
KOSTV	Responsible cost center	AUFKOSTV	CHAR	10	Assigned to domain	ALPHA	KOSTL
POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
STORT	Location	AUFSTORT	CHAR	10	Assigned to domain		AP_STAND
SOWRK	Location plant	AUFSOWRK	CHAR	4	Assigned to domain		WERKS
ASTNR	Order status	AUFASTNR	NUMC	2	Assigned to domain		AUFSTNR
VOGRP	Group of disallowed transactions	AUFSPSET	CHAR	4	Assigned to domain		VOGRP
PDAT1	Planned release date	AUFPDAT1	DATS	8			DATUM
PDAT2	Planned completion date	AUFPDAT2	DATS	8			DATUM
PDAT3	Planned closing date	AUFPDAT3	DATS	8			DATUM
ASTKZ	Identifier for statistical order	AUFSTKZ	CHAR	1			XFELD
WAERS	Order Currency	AUFWAERS	CUKY	5	Assigned to domain		WAERS
KALSM	Costing Sheet	AUFKALSM	CHAR	6	Assigned to domain		KALSM
ZSCHL	Overhead key	AUFZSCHL	CHAR	6			CHAR6
ABGSL	Results Analysis Key	ABGR_SCHL	CHAR	6	Assigned to domain		ABGR_SCHL	ACS
AWSLS	Variance Key	AWSLS	CHAR	6	Assigned to domain		AWSLS
ABKRS	Processing group	AUFABKRS	NUMC	2	Assigned to domain		AKREIS	AKR
KSTAR	Settlement cost element	AUFKSTAR	CHAR	10	Assigned to domain	ALPHA	KSTAR
KOSTL	Cost center for basic settlement	AUFKOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
SAKNR	G/L account for basic settlement	AUFSAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK
USER0	Applicant	AUFUSER0	CHAR	20			AUFUSER0
USER1	Applicant's telephone number	AUFUSER1	CHAR	20			AUFUSER1
USER2	Person responsible	AUFUSER2	CHAR	20			AUFUSER2
USER3	Telephone number of person in charge	AUFUSER3	CHAR	20			AUFUSER3
USER4	Text field length 14	CHAR14	CHAR	14			CHAR14
USER5	Application Date	AUFUSER5	DATS	8			AUFUSER5
USER6	Department	AUFUSER6	CHAR	15			AUFUSER6
USER7	Work Start	AUFUSER7	DATS	8			AUFUSER7
USER8	End of Work	AUFUSER8	DATS	8			AUFUSER8
USER9	Identifier for work permit issued	AUFUSER9	CHAR	1			AUFUSER9
VNAME	Joint Venture	JV_NAME	CHAR	6	Assigned to domain	ALPHA	JV_NAME	JVV
RECID	Recovery Indicator	JV_RECIND	CHAR	2	Assigned to domain	ALPHA	JV_RECIND
ETYPE	Equity type	JV_ETYPE	CHAR	3	Assigned to domain	ALPHA	JV_ETYPE
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	Assigned to domain		TXJCD	TXJ
JV_JIBCL	JIB/JIBE Class	JV_JIBCL	CHAR	3	Assigned to domain		JV_JIBCL	JIB
JV_JIBSA	JIB/JIBE Subclass A	JV_JIBSA	CHAR	5	Assigned to domain		JV_JIBSA	JBS
SCOPE	Object Class	SCOPE_CV	CHAR	2		SCOPE	SCOPE_CV	PCO
KDAUF	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
KDPOS	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
AUFEX	External order number	AUFEX	CHAR	20		ALPHA	AUFEX
IVPRO	Investment measure profile	IM_PROFIL	CHAR	6	Assigned to domain		IM_PROFIL
AKSTL	Requesting cost center	PS_AKSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
.INCLU-_1				0
PERBZ_1	Settlement type	PERBZ_LD	CHAR	3		PERBZ	PERBZ_LD
URZUO_1	Source Assignment	URZUO	CHAR	3	Assigned to domain	ALPHA	CO_SCZUO
PROZS_1	Character field of length 6	CHAR6	CHAR	6			CHAR6
AQZIF_1	Character field 13 digits	CHAR13	CHAR	13			CHAR13
BETRR_1	Field Name	CHAR21	CHAR	21			CHAR21
KONTY_1	Account assignment category	KONTY	CHAR	2		OBART	J_OBART_LD
GSBER_1	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
BUKRS_1	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
HKONT_1	G/L Account Number	SAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK	C_SAKNR
PRCTR_1	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
KOSTL_1	Receiver cost center	BRGKOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
AUFNR_1	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
POSID_1	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
ANLN1_1	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2_1	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
NPLNR_1	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
VORNR_1	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
KDAUF_1	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
KDPOS_1	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
KSTRG_1	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
PRZNR_1	Business Process	CO_PRZNR	CHAR	12	Assigned to domain	ALPHA	CO_PRZNR	KWP
.INCLU-_2				0
PERBZ_2	Settlement type	PERBZ_LD	CHAR	3		PERBZ	PERBZ_LD
URZUO_2	Source Assignment	URZUO	CHAR	3	Assigned to domain	ALPHA	CO_SCZUO
PROZS_2	Character field of length 6	CHAR6	CHAR	6			CHAR6
AQZIF_2	Character field 13 digits	CHAR13	CHAR	13			CHAR13
BETRR_2	Field Name	CHAR21	CHAR	21			CHAR21
KONTY_2	Account assignment category	KONTY	CHAR	2		OBART	J_OBART_LD
GSBER_2	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
BUKRS_2	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
HKONT_2	G/L Account Number	SAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK	C_SAKNR
PRCTR_2	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
KOSTL_2	Receiver cost center	BRGKOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
AUFNR_2	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
POSID_2	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
ANLN1_2	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2_2	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
NPLNR_2	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
VORNR_2	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
KDAUF_2	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
KDPOS_2	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
KSTRG_2	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
PRZNR_2	Business Process	CO_PRZNR	CHAR	12	Assigned to domain	ALPHA	CO_PRZNR	KWP
.INCLU-_3				0
PERBZ_3	Settlement type	PERBZ_LD	CHAR	3		PERBZ	PERBZ_LD
URZUO_3	Source Assignment	URZUO	CHAR	3	Assigned to domain	ALPHA	CO_SCZUO
PROZS_3	Character field of length 6	CHAR6	CHAR	6			CHAR6
AQZIF_3	Character field 13 digits	CHAR13	CHAR	13			CHAR13
BETRR_3	Field Name	CHAR21	CHAR	21			CHAR21
KONTY_3	Account assignment category	KONTY	CHAR	2		OBART	J_OBART_LD
GSBER_3	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
BUKRS_3	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
HKONT_3	G/L Account Number	SAKNR	CHAR	10	Assigned to domain	ALPHA	SAKNR	SAK	C_SAKNR
PRCTR_3	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
KOSTL_3	Receiver cost center	BRGKOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
AUFNR_3	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
POSID_3	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
ANLN1_3	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
ANLN2_3	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
NPLNR_3	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
VORNR_3	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
KDAUF_3	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
KDPOS_3	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
KSTRG_3	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
PRZNR_3	Business Process	CO_PRZNR	CHAR	12	Assigned to domain	ALPHA	CO_PRZNR	KWP
DUMMY_CI_AUFK	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
ABUKR	Requesting company code	IM_ABUKRS	CHAR	4	Assigned to domain		BUKRS	BUK
SIZECL	Scale of investment objects	IM_SIZECL	CHAR	2	Assigned to domain	ALPHA	SIZECL
IZWEK	Reason for investment	IZWEK	CHAR	2	Assigned to domain		IZWEK
UMWKZ	Reason for environmental investment	AM_UMWKZ	CHAR	5	Assigned to domain		AM_UMWKZ
CYCLE	Cost center to which costs are actually posted	ST_KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL
PLINT	Indicator for Integrated Planning	PLINT	CHAR	1			XFELD
ZSCHM	Interest Profile for Project/Order Interest Calculation	PS_ZSCHM	CHAR	7	Assigned to domain		PS_ZSCHM
OTYPE	Joint Venture Object Type	JV_OTYPE	CHAR	4		ALPHA	JV_OTYPE
JV_OCO	JV original cost object	JV_OR_CO	CHAR	1			JV_OR_COB
ANFAUFNR	Requesting order	AUFANFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR
FUNC_AREA	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
CSTG_VRNT	Costing Variant	CK_KLVAR	CHAR	4	Assigned to domain		KLVAR	KRT
VERAA_USER	Person Responsible for CO Internal Order	VERAA_USER	CHAR	12	USR02		XUBNAME	XUS
.INCLU--AP				0
/MRSS/PL_STRU_ID	Resource planning nodes	/MRSS/T_PLAN_STRUCT_ID	NUMC	8	Assigned to domain		CR_OBJID
/MRSS/PL_MAN_TYP	Assignment to resource planner or contact person	/MRSS/T_MANAGER_TYPE	CHAR	1			/MRSS/_MANAGER_TYPE
/MRSS/ORDER_PROB	Order probability in percent	/MRSS/T_ORDER_PROB	CHAR	3		OPROB	/MRSS/_ORDER_PROB
/MRSS/ACT_TYPE	Process variant	/MRSS/T_ACTIVITY_TYPE	CHAR	1			/MRSS/_ACTIVITY_TYPE
/MRSS/INIT_DONE	Internal initialization carried out once	/MRSS/T_INIT_DONE	CHAR	1			FLAG
/MRSS/DATACHANGE	Data was changed in the controls on the user screen	/MRSS/T_USCREENCTL_DATACHANGED	CHAR	1			FLAG
/MRSS/SALES_ORG	Sales Organization	VKORG	CHAR	4	Assigned to domain		VKORG	VKO	C_VKORG
/MRSS/NW_BOOKED	Network Set to 'Booked'	/MRSS/T_NW_BOOKED	CHAR	1			FLAG

Key field

Non-key field

< OREL_S_OT - Line Structure for the Outtab of Old Model Rel. ORF260 - ORF: Data on Setting Pop Up (260) >

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

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

How to access SAP table OREXT

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

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