REEX_FL_ORDER_L SAP (Orders for Functional Locations - List Fields) Structure details
Description: Orders for Functional Locations - List Fields
Related tables to REEX_FL_ORDER_L
Access table REEX_FL_ORDER_L
Structure field list including key, data, relationships and ABAP select examples
REEX_FL_ORDER_L 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 "Orders for Functional Locations - List Fields" 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_FL_ORDER_L TYPE REEX_FL_ORDER_L.
The REEX_FL_ORDER_L table consists of various fields, each holding specific information or linking keys about Orders for Functional Locations - List Fields data available in SAP. These include ILOAN (Location and account assignment for technical object), MANDT (Client), AUFNR (Order Number), AUART (Order Type).. 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_FL_ORDER_L 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 |
TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | Assigned to domain | ILOAN | |||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUART | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
REFNR | Reference order number | AUFREFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANV | |
ERNAM | Entered by | AUFERFNAM | CHAR | 12 | USNAM | ||||
ERDAT | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
AENAM | Last changed by | AUFAENAM | CHAR | 12 | USNAM | ||||
AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | DATUM | ||||
KTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
LTEXT | Long Text Exists | AUFLTEXT | CHAR | 1 | XFELD | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
CCKEY | Cost collector key | CCKEY | CHAR | 23 | CCKEY | ||||
KOSTV | Responsible cost center | AUFKOSTV | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
STORT | Location | AUFSTORT | CHAR | 10 | T499S | AP_STAND | |||
SOWRK | Location plant | AUFSOWRK | CHAR | 4 | T001W | WERKS | |||
ASTKZ | Identifier for statistical order | AUFSTKZ | CHAR | 1 | XFELD | ||||
WAERS | Order Currency | AUFWAERS | CUKY | 5 | TCURC | WAERS | |||
ASTNR | Order status | AUFASTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
STDAT | Date of last status change | AUFSTDAT | DATS | 8 | DATUM | ||||
ESTNR | Status reached so far | AUFESTNR | NUMC | 2 | TKO03 | AUFSTNR | |||
PHAS0 | Phase 'Order created' | AUFPHAS0 | CHAR | 1 | XFELD | ||||
PHAS1 | Phase 'Order released' | AUFPHAS1 | CHAR | 1 | XFELD | ||||
PHAS2 | Phase 'order completed' | AUFPHAS2 | CHAR | 1 | XFELD | ||||
PHAS3 | Phase 'order closed' | AUFPHAS3 | CHAR | 1 | XFELD | ||||
PDAT1 | Planned release date | AUFPDAT1 | DATS | 8 | DATUM | ||||
PDAT2 | Planned completion date | AUFPDAT2 | DATS | 8 | DATUM | ||||
PDAT3 | Planned closing date | AUFPDAT3 | DATS | 8 | DATUM | ||||
IDAT1 | Release date | AUFIDAT1 | DATS | 8 | DATUM | ||||
IDAT2 | Technical completion date | AUFIDAT2 | DATS | 8 | DATUM | ||||
IDAT3 | Close date | AUFIDAT3 | DATS | 8 | DATUM | ||||
OBJID | Object ID | CCOBJID | CHAR | 1 | CHAR1 | ||||
VOGRP | Group of disallowed transactions | AUFSPSET | CHAR | 4 | TKAVG | VOGRP | |||
LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
PLGKZ | Identifier for planning with line items | PLGKZ | CHAR | 1 | XFELD | ||||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | KALSM | |||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
ABKRS | Processing group | AUFABKRS | NUMC | 2 | TKO08 | AKREIS | AKR | ||
KSTAR | Settlement cost element | AUFKSTAR | CHAR | 10 | CSKB | ALPHA | KSTAR | ||
KOSTL | Cost center for basic settlement | AUFKOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
SAKNR | G/L account for basic settlement | AUFSAKNR | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | |
SETNM | Allocation set | AUFSETNM | CHAR | 12 | SETNR | GSE | |||
CYCLE | Cost center to which costs are actually posted | ST_KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
SDATE | Start Date | SDATE | DATS | 8 | Assigned to domain | SDATE | GAS | ||
SEQNR | Sequence number | AUFSEQNR | NUMC | 4 | Assigned to domain | SQNR | |||
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 | Estimated total costs of order | AUFUSER4 | CURR | 11(2) | AUFUSER4 | ||||
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 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
AWSLS | Variance Key | AWSLS | CHAR | 6 | TKV01 | AWSLS | |||
ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | XFELD | ||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | 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 | TAPRF | IM_PROFIL | |||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
FLG_MLTPS | Order with multiple items | CO_MLTPS | CHAR | 1 | KREUZ | ||||
ABUKR | Requesting company code | IM_ABUKRS | CHAR | 4 | T001 | BUKRS | BUK | ||
AKSTL | Requesting cost center | PS_AKSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
SIZECL | Scale of investment objects | IM_SIZECL | CHAR | 2 | TAIF5 | ALPHA | SIZECL | ||
IZWEK | Reason for investment | IZWEK | CHAR | 2 | T087I | IZWEK | |||
UMWKZ | Reason for environmental investment | AM_UMWKZ | CHAR | 5 | T087K | AM_UMWKZ | |||
KSTEMPF | Indicator: Direct cost collector | CO_KSTEMPF | CHAR | 1 | CO_KSTEMPF | ||||
ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | TPI01 | PS_ZSCHM | |||
PKOSA | Cost collector for production process PROCNR | PKOSA_D | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
ANFAUFNR | Requesting order | AUFANFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
PROCNR | Production Process | CKML_F_PROCNR | NUMC | 12 | Assigned to domain | CK_KALNR | CKML_PROCNR | ||
PROTY | Process Category (Procurement/Consumption) | CKML_PROZESS_TYP | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
RSORD | Refurbishment order indicator (PM) | RSORD | CHAR | 1 | XFELD | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
ADRNRA | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ERFZEIT | Time created | CO_INS_TIME | TIMS | 6 | UZEIT | ||||
AEZEIT | Changed at | CO_CHG_TIME | TIMS | 6 | UZEIT | ||||
CSTG_VRNT | Costing Variant | CK_KLVAR | CHAR | 4 | Assigned to domain | KLVAR | KRT | ||
COSTESTNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
VERAA_USER | Person Responsible for CO Internal Order | VERAA_USER | CHAR | 12 | USR02 | XUBNAME | XUS | ||
DUMMY_CI_AUFK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JG | ALPHA | JV_ETYPE | ||
OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | ALPHA | JV_OTYPE | |||
JV_JIBCL | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | T8J6A | JV_JIBCL | JIB | ||
JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | T8J6C | JV_JIBSA | JBS | ||
JV_OCO | JV original cost object | JV_OR_CO | CHAR | 1 | JV_OR_COB | ||||
CPD_UPDAT | Time Stamp | /CPD/PFP_TSTMP | DEC | 15 | TSTLC | /CPD/PFP_TSTMP | |||
/CUM/INDCU | CU: Order is Used for Compatible Units | /CUM/INDCU | CHAR | 1 | FLAG | ||||
/CUM/CMNUM | CU: Construction Measure Number | /CUM/CMNUM | CHAR | 12 | ALPHA | /CUM/CMNUM | /CUM/CMNUM | /CUM/V_CMNUM_ALL | |
/CUM/AUEST | CU: Automatic Copy of Estimated Costs | /CUM/AUEST | CHAR | 1 | FLAG | ||||
/CUM/DESNUM | CU: Design Number | /CUM/DESNUM | CHAR | 12 | Assigned to domain | ALPHA | /CUM/DESNUM | /CUM/DESNUM | |
/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 | ||||
AD01PROFNR | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | AD01C_PROF | AD01PROFNR | AD0 | DIP_PROFILE | |
VAPLZ | Main work center for maintenance tasks | GEWRK | CHAR | 8 | ARBPL | VAP | |||
WAWRK | Plant associated with main work center | WERGW | CHAR | 4 | Assigned to domain | WERKS | |||
FERC_IND | Regulatory indicator | FE_IND | CHAR | 4 | FERC_C7 | ALPHA | FE_IND | ||
AUFK_STATUS | Status Combination | ACTCMB_DELE | INT1 | 3 | ACTCMB_TAB | ACTCMB_DOM | |||
CLAIM_CONTROL | Claim creation control indicator | WTYSC_CLAIM_CONTROL | CHAR | 1 | WTYSCC_CLM_CONT | WTYSC_CLAIM_CONTROL | |||
UPDATE_NEEDED | Claim inconsistency with order indicator | WTYSC_UPDATE_NEEDED | CHAR | 1 | WTYSC_UPDATE_NEEDED | ||||
UPDATE_CONTROL | Claim update trigger point from service order | WTYSC_UPDATE_CONTROL | CHAR | 1 | WTYSCC_UPDT_CONT | WTYSC_UPDATE_CONTROL |
Key field | Non-key field |
How do I retrieve data from SAP structure REEX_FL_ORDER_L using ABAP code?
As REEX_FL_ORDER_L 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_FL_ORDER_L as there is no data to select.How to access SAP table REEX_FL_ORDER_L
Within an ECC or HANA version of SAP you can also view further information about REEX_FL_ORDER_L 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