OREXT SAP (CO order fields for external data transfer) Structure details
Description: CO order fields for external data transfer
Structure field list including key, data, relationships and ABAP select examples
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. .
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
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 |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects