ALORDER SAP (Field Selection Change Documents Order) Structure details
Description: Field Selection Change Documents Order
Structure field list including key, data, relationships and ABAP select examples
ALORDER 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 "Field Selection Change Documents 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_ALORDER TYPE ALORDER.
The ALORDER table consists of various fields, each holding specific information or linking keys about Field Selection Change Documents Order data available in SAP. These include GSBER (Business Area), LOEKZ (Deletion flag), KALSM (Costing Sheet), ZSCHL (Overhead key).. 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 ALORDER 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 |
KTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | Assigned to domain | KALSM | |||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
ABKRS | Processing group | AUFABKRS | NUMC | 2 | Assigned to domain | AKREIS | AKR | ||
USER4 | Estimated total costs of order | AUFUSER4 | CURR | 11(2) | AUFUSER4 | ||||
WAERS | Order Currency | AUFWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
ADRNRA | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
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 | ||
JV_OCO | JV original cost object | JV_OR_CO | CHAR | 1 | JV_OR_COB | ||||
GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
GSTRP | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
KLVARI | Costing variant for actual costs | KALKVARIST | CHAR | 4 | Assigned to domain | KLVAR | |||
AUFNT | Number of superior network | CO_TEILNET | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
NO_DISP | Ind: Reserv. not applicable to MRP;Purc. req. not created | NODISP | CHAR | 1 | XFELD | ||||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
KLVARP | Costing variant for planned costs | KALKVARPLN | CHAR | 4 | Assigned to domain | KLVAR | |||
PRIOK | Priority | PRIOK | CHAR | 1 | Assigned to domain | PRIOK | PRIOK | ||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
BAUTL | Assembly | BAUTL | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
INGPR | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | Assigned to domain | INGRP | IHG | ||
GEWRK | Object ID of the Work Center | LGWID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | Assigned to domain | ABCKZ | |||
EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
SWERK | Maintenance plant | SWERK | CHAR | 4 | Assigned to domain | WERKS | SWK | ||
STORT | Location of maintenance object | PMLOC | CHAR | 10 | Assigned to domain | AP_STAND | |||
MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
BEBER | Plant section | BEBER | CHAR | 3 | Assigned to domain | BEBER | BBE | ||
PPSID | Object ID of PP work center | PPSID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
DAUFN | Standing order number | DAUFN | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ORDP | |
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
STEUS | Control key | STEUS | CHAR | 4 | Assigned to domain | STEUS | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | Assigned to domain | ALPHA | INFNR | INF | MEIN_C |
LARNT | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | WEMPF | ||||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
SLWID | Key word ID for user-defined fields | SLWID | CHAR | 7 | Assigned to domain | SLWID | |||
PARNR | Number of contact person | PARNR | NUMC | 10 | PARNR | VPA | |||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
LIFZT | Delivery time in days | LIFZT | DEC | 3 | DEC3 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE05 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | Assigned to domain | ILOAN | |||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | Assigned to domain | WERKS | IWK | ||
APGRP | Responsible planner group/department | VAGRP | CHAR | 3 | Assigned to domain | VAGRP | H_T024A | ||
ARBID | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
TXTSP | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
SORTL | Sort Term for Non-Stock Info Records | SORTI | CHAR | 10 | CHAR10 | ||||
PREIS | Price | PREIS | CURR | 11(2) | WERT11 | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
EKGRP | Purchasing group for external processing | VG_EKGRP | CHAR | 3 | Assigned to domain | EKGRP | |||
PACKNO | Package number | PACKNO | NUMC | 10 | Assigned to domain | PACKNO | |||
DAUNO | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
DAUNE | Normal duration/unit | DAUNORE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ARBEI | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
ARBEH | Unit for work | ARBEITE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE06 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE07 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
USR08 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR09 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | ILOM_OWNER | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | ||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ROMEN | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | ||||
RFORM | Formula key | RFORM | CHAR | 2 | Assigned to domain | RFORM | |||
ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | ||||
POTX1 | BOM Item Text (Line 1) | POTX1 | CHAR | 40 | TEXT40 | ||||
POTX2 | BOM item text (line 2) | POTX2 | CHAR | 40 | TEXT40 | ||||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | Assigned to domain | BEIKZ | |||
PEINH_2 | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | Assigned to domain | REVNI |
Key field | Non-key field |
How do I retrieve data from SAP structure ALORDER using ABAP code?
As ALORDER 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 ALORDER as there is no data to select.How to access SAP table ALORDER
Within an ECC or HANA version of SAP you can also view further information about ALORDER 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