REEX_ORDER SAP (Order) Structure details

Dictionary Type: Structure
Description: Order




ABAP Code to SELECT data from REEX_ORDER
Related tables to REEX_ORDER
Access table REEX_ORDER




Structure field list including key, data, relationships and ABAP select examples

REEX_ORDER 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 "Order" 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_REEX_ORDER TYPE REEX_ORDER.

The REEX_ORDER table consists of various fields, each holding specific information or linking keys about Order data available in SAP. These include MANDT (Client), AUFNR (Order Number), AUART (Order Type), AUTYP (Order category).. 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 REEX_ORDER 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
MANDTClient MANDTCLNT3T000MANDT
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
AUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
AUTYPOrder category AUFTYPNUMC2AUFTYP
REFNRReference order number AUFREFNRCHAR12AUFKALPHAAUFNRANV
ERNAMEntered by AUFERFNAMCHAR12USNAM
ERDATCreated on AUFERFDATDATS8DATUM
AENAMLast changed by AUFAENAMCHAR12USNAM
AEDATChange date for Order Master AUFAEDATDATS8DATUM
KTEXTDescription AUFTEXTCHAR40TEXT40
LTEXTLong Text Exists AUFLTEXTCHAR1XFELD
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
CCKEYCost collector key CCKEYCHAR23CCKEY
KOSTVResponsible cost center AUFKOSTVCHAR10CSKSALPHAKOSTL
STORTLocation AUFSTORTCHAR10T499SAP_STAND
SOWRKLocation plant AUFSOWRKCHAR4T001WWERKS
ASTKZIdentifier for statistical order AUFSTKZCHAR1XFELD
WAERSOrder Currency AUFWAERSCUKY5TCURCWAERS
ASTNROrder status AUFASTNRNUMC2Assigned to domainAUFSTNR
STDATDate of last status change AUFSTDATDATS8DATUM
ESTNRStatus reached so far AUFESTNRNUMC2TKO03AUFSTNR
PHAS0Phase 'Order created' AUFPHAS0CHAR1XFELD
PHAS1Phase 'Order released' AUFPHAS1CHAR1XFELD
PHAS2Phase 'order completed' AUFPHAS2CHAR1XFELD
PHAS3Phase 'order closed' AUFPHAS3CHAR1XFELD
PDAT1Planned release date AUFPDAT1DATS8DATUM
PDAT2Planned completion date AUFPDAT2DATS8DATUM
PDAT3Planned closing date AUFPDAT3DATS8DATUM
IDAT1Release date AUFIDAT1DATS8DATUM
IDAT2Technical completion date AUFIDAT2DATS8DATUM
IDAT3Close date AUFIDAT3DATS8DATUM
OBJIDObject ID CCOBJIDCHAR1CHAR1
VOGRPGroup of disallowed transactions AUFSPSETCHAR4TKAVGVOGRP
LOEKZDeletion flag AUFLOEKZCHAR1XFELD
PLGKZIdentifier for planning with line items PLGKZCHAR1XFELD
KVEWEUsage of the condition table KVEWECHAR1T681VKVEWEKVW
KAPPLApplication KAPPLCHAR2T681AKAPPLKAP
KALSMCosting Sheet AUFKALSMCHAR6T683KALSM
ZSCHLOverhead key AUFZSCHLCHAR6CHAR6
ABKRSProcessing group AUFABKRSNUMC2TKO08AKREISAKR
KSTARSettlement cost element AUFKSTARCHAR10CSKBALPHAKSTAR
KOSTLCost center for basic settlement AUFKOSTLCHAR10CSKSALPHAKOSTLKOS
SAKNRG/L account for basic settlement AUFSAKNRCHAR10SKB1ALPHASAKNRSAK
SETNMAllocation set AUFSETNMCHAR12SETNRGSE
CYCLECost center to which costs are actually posted ST_KOSTLCHAR10CSKSALPHAKOSTL
SDATEStart Date SDATEDATS8Assigned to domainSDATEGAS
SEQNRSequence number AUFSEQNRNUMC4Assigned to domainSQNR
USER0Applicant AUFUSER0CHAR20AUFUSER0
USER1Applicant's telephone number AUFUSER1CHAR20AUFUSER1
USER2Person responsible AUFUSER2CHAR20AUFUSER2
USER3Telephone number of person in charge AUFUSER3CHAR20AUFUSER3
USER4Estimated total costs of order AUFUSER4CURR11(2) AUFUSER4
USER5Application Date AUFUSER5DATS8AUFUSER5
USER6Department AUFUSER6CHAR15AUFUSER6
USER7Work Start AUFUSER7DATS8AUFUSER7
USER8End of Work AUFUSER8DATS8AUFUSER8
USER9Identifier for work permit issued AUFUSER9CHAR1AUFUSER9
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PSPELWork breakdown structure element (WBS element) PS_PSP_ELENUMC8PRPSKONPRPS_POSNR
AWSLSVariance Key AWSLSCHAR6TKV01AWSLS
ABGSLResults Analysis Key ABGR_SCHLCHAR6TKKAAABGR_SCHLACS
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
FUNC_AREAFunctional Area FKBERCHAR16TFKBFKBERFBE
SCOPEObject Class SCOPE_CVCHAR2SCOPESCOPE_CVPCO
PLINTIndicator for Integrated Planning PLINTCHAR1XFELD
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
AUFEXExternal order number AUFEXCHAR20ALPHAAUFEX
IVPROInvestment measure profile IM_PROFILCHAR6TAPRFIM_PROFIL
LOGSYSTEMLogical System LOGSYSTEMCHAR10TBDLSALPHALOGSYS
FLG_MLTPSOrder with multiple items CO_MLTPSCHAR1KREUZ
ABUKRRequesting company code IM_ABUKRSCHAR4T001BUKRSBUK
AKSTLRequesting cost center PS_AKSTLCHAR10CSKSALPHAKOSTLKOS
SIZECLScale of investment objects IM_SIZECLCHAR2TAIF5ALPHASIZECL
IZWEKReason for investment IZWEKCHAR2T087IIZWEK
UMWKZReason for environmental investment AM_UMWKZCHAR5T087KAM_UMWKZ
KSTEMPFIndicator: Direct cost collector CO_KSTEMPFCHAR1CO_KSTEMPF
ZSCHMInterest Profile for Project/Order Interest Calculation PS_ZSCHMCHAR7TPI01PS_ZSCHM
PKOSACost collector for production process PROCNR PKOSA_DCHAR12Assigned to domainALPHAAUFNR
ANFAUFNRRequesting order AUFANFNRCHAR12AUFKALPHAAUFNR
PROCNRProduction Process CKML_F_PROCNRNUMC12Assigned to domainCK_KALNRCKML_PROCNR
PROTYProcess Category (Procurement/Consumption) CKML_PROZESS_TYPCHAR4Assigned to domainCKML_PROZESS_TYP
RSORDRefurbishment order indicator (PM) RSORDCHAR1XFELD
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
ADRNRAAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
ERFZEITTime created CO_INS_TIMETIMS6UZEIT
AEZEITChanged at CO_CHG_TIMETIMS6UZEIT
CSTG_VRNTCosting Variant CK_KLVARCHAR4Assigned to domainKLVARKRT
COSTESTNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
VERAA_USERPerson Responsible for CO Internal Order VERAA_USERCHAR12USR02XUBNAMEXUS
DUMMY_CI_AUFKSingle-Character Indicator CHAR1CHAR1CHAR1
VNAMEJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
ETYPEEquity type JV_ETYPECHAR3T8JGALPHAJV_ETYPE
OTYPEJoint Venture Object Type JV_OTYPECHAR4ALPHAJV_OTYPE
JV_JIBCLJIB/JIBE Class JV_JIBCLCHAR3T8J6AJV_JIBCLJIB
JV_JIBSAJIB/JIBE Subclass A JV_JIBSACHAR5T8J6CJV_JIBSAJBS
JV_OCOJV original cost object JV_OR_COCHAR1JV_OR_COB
CPD_UPDATTime Stamp /CPD/PFP_TSTMPDEC15TSTLC/CPD/PFP_TSTMP
/CUM/INDCUCU: Order is Used for Compatible Units /CUM/INDCUCHAR1FLAG
/CUM/CMNUMCU: Construction Measure Number /CUM/CMNUMCHAR12ALPHA/CUM/CMNUM/CUM/CMNUM/CUM/V_CMNUM_ALL
/CUM/AUESTCU: Automatic Copy of Estimated Costs /CUM/AUESTCHAR1FLAG
/CUM/DESNUMCU: Design Number /CUM/DESNUMCHAR12Assigned to domainALPHA/CUM/DESNUM/CUM/DESNUM
/MRSS/PL_STRU_IDResource planning nodes /MRSS/T_PLAN_STRUCT_IDNUMC8Assigned to domainCR_OBJID
/MRSS/PL_MAN_TYPAssignment to resource planner or contact person /MRSS/T_MANAGER_TYPECHAR1/MRSS/_MANAGER_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
/MRSS/NW_BOOKEDNetwork Set to 'Booked' /MRSS/T_NW_BOOKEDCHAR1FLAG
AD01PROFNRDynamic Item Processor Profile AD01PROFNRCHAR8AD01C_PROFAD01PROFNRAD0DIP_PROFILE
VAPLZMain work center for maintenance tasks GEWRKCHAR8ARBPLVAP
WAWRKPlant associated with main work center WERGWCHAR4Assigned to domainWERKS
FERC_INDRegulatory indicator FE_INDCHAR4FERC_C7ALPHAFE_IND
AUFK_STATUSStatus Combination ACTCMB_DELEINT13ACTCMB_TABACTCMB_DOM
CLAIM_CONTROLClaim creation control indicator WTYSC_CLAIM_CONTROLCHAR1WTYSCC_CLM_CONTWTYSC_CLAIM_CONTROL
UPDATE_NEEDEDClaim inconsistency with order indicator WTYSC_UPDATE_NEEDEDCHAR1WTYSC_UPDATE_NEEDED
UPDATE_CONTROLClaim update trigger point from service order WTYSC_UPDATE_CONTROLCHAR1WTYSCC_UPDT_CONTWTYSC_UPDATE_CONTROL

Key field Non-key field



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

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

How to access SAP table REEX_ORDER

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!