1. Home
  2. Resources
  3. SAP Tables
  4. BAPI_ALM_ORDER_LISTHEAD_RESULT - ALM Orders: Order List from Selection

SAP Table BAPI_ALM_ORDER_LISTHEAD_RESULT

ALM Orders: Order List from Selection

BAPI_ALM_ORDER_LISTHEAD_RESULT (ALM Orders: Order List from Selection) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPI_ALM_ORDER_LISTHEAD_RESULT to other SAP tables.

BAPI_ALM_ORDER_LISTHEAD_RESULT table fields

Field Data element Checktable Datatype Length Decimals
ORDERID Order Number AUFNR AUFK CHAR 12 0
ORDER_TYPE Order Type AUFART CHAR 4 0
CURRENCY Order Currency AUFWAERS TCURC CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
ENTERED_BY Entered by AUFERFNAM CHAR 12 0
ENTER_DATE Created on AUFERFDAT DATS 8 0
CHANGED_BY Last changed by AUFAENAM CHAR 12 0
CHANGE_DATE Change date for Order Master AUFAEDAT DATS 8 0
SHORT_TEXT Description AUFTEXT CHAR 40 0
LONG_TEXT_FLAG Long Text Exists AUFLTEXT CHAR 1 0
X Yes
NULL No
COMP_CODE Company Code BUKRS CHAR 4 0
PLANT Plant WERKS_D CHAR 4 0
BUS_AREA Business Area GSBER TGSB CHAR 4 0
CO_AREA Controlling Area KOKRS CHAR 4 0
RESPCCTR Responsible cost center AUFKOSTV CHAR 10 0
DELETION_FLAG Deletion flag AUFLOEKZ CHAR 1 0
X Yes
NULL No
CSTG_SHEET Costing Sheet AUFKALSM CHAR 6 0
OVERHEAD_KEY Overhead key AUFZSCHL CHAR 6 0
ABCINDIC ABC indicator for technical object ABCKZ CHAR 1 0
SORTFIELD Sort field EQFNR CHAR 30 0
PRIORITY Priority PRIOK CHAR 1 0
EQUIPMENT Equipment Number EQUNR EQUI CHAR 18 0
ASSEMBLY Assembly BAUTL CHAR 18 0
SYSTCOND Syst.Condition ANLZU CHAR 1 0
PLANPLANT Maintenance Planning Plant IWERK CHAR 4 0
PLANGROUP Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
RESP_PLANNER_GROUP Responsible planner group/department VAGRP CHAR 3 0
MN_WK_CTR Main work center for maintenance tasks GEWRK CHAR 8 0
MN_WK_PLANT Plant associated with main work center AWERK CHAR 4 0
CUSTOMER Customer Number KUNUM KNA1 CHAR 10 0
SYSTEM_RESP Name of Person Reponsible for System ANING CHAR 12 0
PLANNED_DOWN_TIME Planned Breakdown Duration EGAUZT DEC 11 2
SYSTEM_AVAILABLE_TO_DATE Date until which the system is available ANLBD DATS 8 0
SYSTEM_AVAILABLE_FROM_DATE Date from which the system is available ANLVD DATS 8 0
SYSTEM_AVAILABLE_TO_TIME Time until which the system is available ANLBZ TIMS 6 0
SYSTEM_AVAILABLE_FROM_TIME Time from Which System is Available ANLVZ TIMS 6 0
COSTCENTER Cost Center KOSTL CSKS CHAR 10 0
MAINTPLANT Maintenance plant SWERK CHAR 4 0
MAINTLOC Location of maintenance object PMLOC T499S CHAR 10 0
MAINTROOM Room RAUMNR CHAR 8 0
PLSECTN Plant section BEBER CHAR 3 0
FUNCLOC Functional Location Label ILOM_STRNO CHAR 40 0
ASSET_NO Main Asset Number ANLN1 CHAR 12 0
SUB_NUMBER Asset Subnumber ANLN2 CHAR 4 0
REVISION Revision for Plant Maintenance and Customer Service REVNI T352R CHAR 8 0
MAINTPLAN Maintenance Plan WARPL MPLA CHAR 12 0
MAINTITEM Maintenance item WAPOS CHAR 16 0
S_STATUS System status line J_STEXT CHAR 40 0
U_STATUS User Status Line J_ATEXT CHAR 40 0
WORK_CNTR Work center ARBPL CHAR 8 0
FINISH_DATE Basic finish date CO_GLTRP DATS 8 0
START_DATE Basic start date CO_GSTRP DATS 8 0
PRODUCTION_FINISH_DATE Scheduled finish CO_GLTRS DATS 8 0
PRODUCTION_START_DATE Scheduled start CO_GSTRS DATS 8 0
ACTUAL_START_DATE Actual start date CO_GSTRI DATS 8 0
CONFIRMED_FINISH_DATE Confirmed Order Finish Date CO_GETRI DATS 8 0
PLANNER_GROUP Responsible planner group/department VAGRP CHAR 3 0
ACTUAL_RELEASE_DATE Actual release date CO_FTRMI DATS 8 0
PMACTTYPE Maintenance activity type ILA CHAR 3 0
NOTIF_NO Notification No QMNUM CHAR 12 0
HISTORY_DATE PM request: History date HISDA DATS 8 0
EQUIDESCR Description of technical object KTX01 CHAR 40 0
FUNCLDESCR Description of functional location PLTXT CHAR 40 0
NAME_LIST Name for list displays I_NAME_LST CHAR 35 0
TEL1_NUMBR First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
POSTL_COD1 City postal code AD_PSTCD1 CHAR 10 0
CITY City AD_CITY1 CHAR 40 0
DISTRICT District AD_CITY2 CHAR 40 0
COUNTRY Country Key LAND1 CHAR 3 0
COUNTRYISO Country ISO code INTCA CHAR 2 0
REGION Region (State, Province, County) REGIO CHAR 3 0
STREET Street AD_STREET CHAR 60 0
PROFIT_SEGM_NO Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
TOTAL_COSTS_ACT Total(actual) maintenance costs DGESKOSIST CURR 15 2
TOTAL_COSTS_PLAN Total plant maintenance costs (planned) DGESKOPLAN CURR 15 2
TOTAL_SETTLEMENT_COSTS Total Settlement Costs (PMCO) DGESKOABRE CURR 15 2
TOTAL_REVENUES_ACT Total plant maintenance revenues (actual) DGESERTRAG CURR 15 2
TOTAL_REVENUES_PLAN Total (planned) maintenance revenues DGPLERTRAG CURR 15 2
TOTAL_SUM_ACT Actual sum of maintenance order (costs - revenues) DPMISTVAL CURR 15 2
TOTAL_SUM_PLAN Plan sum of maintenance order (costs - revenues) DPMPLANVAL CURR 15 2
OBJECT_NO Object number J_OBJNR ONR00 CHAR 22 0
SALES_DOC_NUMBER Sales Document VBELN_VA VBUK CHAR 10 0
SALES_ITM_NUMBER Sales Document Item POSNR_VA VBUP NUMC 6 0
LEADING_ORDERID Leading order in current processing CO_LAUFNR CHAR 12 0
SUPERIOR_ORDERID Number of superior order MAUFNR CHAR 12 0
ACTUAL_FINISH_TIME Confirmed order finish (time) CO_GEUZI TIMS 6 0
ACTUAL_START_TIME Actual start time CO_GSUZI TIMS 6 0
PRODUCTION_FINISH_TIME Scheduled finish time CO_GLUZS TIMS 6 0
PRODUCTION_START_TIME Scheduled Start (Time) CO_GSUZS TIMS 6 0
TASK_LIST_GROUP Key for Task List Group PLNNR CHAR 8 0
GROUP_COUNTER Group Counter PLNAL CHAR 2 0
ORDPLANID Maintenance order planning indicator AUF_PLKNZ CHAR 1 0
NULL Unplanned order
1 Planned order
2 Immediate order
REFDATE PM Order: Reference Date ADDAT DATS 8 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) for List I_PM_POSID CHAR 24 0
SUPERIOR_NETWORK Number of superior network CO_TEILNET CHAR 12 0
SUPERIOR_ACTIVITY Superior activity VORG_UEBER CHAR 4 0
ESTIMATED_COSTS Estimated total costs of order AUFUSER4 CURR 11 2
SALESORG Sales Organization VKORG CHAR 4 0
DISTR_CHAN Distribution Channel VTWEG CHAR 2 0
DIVISION Division SPART CHAR 2 0
BASIC_FIN Basic finish (time) CO_GLUZP TIMS 6 0
BASICSTART Basic start time CO_GSUZP TIMS 6 0
REFTIME Time of Reference Date ADUHR TIMS 6 0
CALC_MOTIVE Accounting Indicator BEMOT CHAR 2 0
ADDR_NO Address number AD_ADDRNUM CHAR 10 0
MATERIAL Material Number MATNR CHAR 18 0
SERIALNO Serial Number GERNR CHAR 18 0
DEVICEID Additional Device Data DEVICEID CHAR 40 0
SALES_OFF Sales Office VKBUR CHAR 4 0
SALES_GRP Sales Group VKGRP CHAR 3 0
MATL_DESC Material Description (Short Text) MAKTX CHAR 40 0
ASSMBL_DESC Assembly Description BAUTXL CHAR 40 0
PAGESTATUS Paging Status PAGESTAT CHAR 4 0
OK Successful
PEND Triggered
WARN Warning
ERR Error
WBS_ELEMENT_HEAD Work breakdown structure element (WBS element) order header I_PM_POSID_HEADER CHAR 24 0
MRP_RELEVANT Reservation Relevance/Generation of Purchase Requisition AUDISP_PLUS CHAR 1 0
1 Never
2 From release
3 Immediately
PHASE Maintenance Processing Phase PM_PHASE CHAR 1 0
0 Outstanding
1 Postponed (currently not used)
2 Released
3 Technically completed
4 Manual deletion indicator set
5 Historical order
6 Completed for business (from 4.6)
PRIOTYPE Priority Type ARTPR CHAR 2 0
PRIO_DESC Priority Text PRIOKX CHAR 20 0
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
PURCH_DATE Customer purchase order date BSTDK DATS 8 0
SERVICE_MATERIAL Service product MATSV CHAR 18 0
SERVICE_MATL_DESC Description of Service Product MATSVTX CHAR 40 0
SERVICE_MATL_QUANTITY Service product quantity MNGSP QUAN 13 3
SERVCIE_UOM Base Unit of Measure MEINS UNIT 3 0
SERVCIE_UOM_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
BILLING_FORM Billing form FAKTF CHAR 2 0
01 Fixed rate
02 Costs
PLAN_PLANNER_GROUP Responsible planner group/department VAGRP CHAR 3 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
OBJECTLIST_NO Object list number OBJKNR INT4 10 0
CLIENT Client MANDT CLNT 3 0
ASSEMBLY_EXTERNAL Long Material Number for Field ASSEMBLY MGV_ASSEMBLY_EXTERNAL CHAR 40 0
ASSEMBLY_GUID External GUID for ASSEMBLY Field MGV_ASSEMBLY_GUID CHAR 32 0
ASSEMBLY_VERSION Version Number for ASSEMBLY Field MGV_ASSEMBLY_VERSION CHAR 10 0
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
MATERIAL_GUID External GUID for MATERIAL Field MGV_MATERIAL_GUID CHAR 32 0
MATERIAL_VERSION Version Number for MATERIAL Field MGV_MATERIAL_VERSION CHAR 10 0
SERVICE_MATERIAL_EXTERNAL Long Material Number for SERVICE_MATERIAL Field MGV_SERVICE_MATERIAL_EXTERNAL CHAR 40 0
SERVICE_MATERIAL_GUID External GUID for SERVICE_MATERIAL Field MGV_SERVICE_MATERIAL_GUID CHAR 32 0
SERVICE_MATERIAL_VERSION Version Number for SERVICE_MATERIAL Field MGV_SERVICE_MATERIAL_VERSION CHAR 10 0
START_POINT Start Point EAML_START_POINT CHAR 18 0
END_POINT End Point EAML_END_POINT CHAR 18 0
LINEAR_LENGTH Length EAML_LINEAR_LENGTH CHAR 18 0
LINEAR_UNIT Unit of Measurement for Linear Data EAML_LINEAR_UNIT T006 UNIT 3 0
LINEAR_UNIT_ISO Unit of Measurement for Linear Data in ISO Code EAML_LINEAR_UNIT_ISO CHAR 3 0
FIRST_OFFSET_TYPE_CODE Type of First Offset EAML_OFFSET1_TYPE_CODE EAML_D_OFFSET_TC CHAR 2 0
FIRST_OFFSET_VALUE Value of Offset 1 EAML_OFFSET1_VALUE CHAR 18 0
FIRST_OFFSET_UNIT Unit of Measurement for Offset 1 EAML_OFFSET1_UNIT T006 UNIT 3 0
FIRST_OFFSET_UNIT_ISO Unit of Measurement for Offset 1 in ISO Code EAML_OFFSET1_UNIT_ISO CHAR 3 0
SECOND_OFFSET_TYPE_CODE Type of Second Offset EAML_OFFSET2_TYPE_CODE EAML_D_OFFSET_TC CHAR 2 0
SECOND_OFFSET_VALUE Value of Offset 2 EAML_OFFSET2_VALUE CHAR 18 0
SECOND_OFFSET_UNIT Unit of Measurement for Offset 2 EAML_OFFSET2_UNIT T006 UNIT 3 0
SECOND_OFFSET_UNIT_ISO Unit of Measurement for Offset 2 in ISO Code EAML_OFFSET2_UNIT_ISO CHAR 3 0
FIRST_OFFSET_TYPE_CODE_NAME First Offset Type Description EAML_OFFSET1_TYPE_CODE_NAME CHAR 60 0
SECOND_OFFSET_TYPE_CODE_NAME Second Offset Type Description EAML_OFFSET2_TYPE_CODE_NAME CHAR 60 0
MARKER_START_POINT Marker for Start Point EAML_MARKER_START_POINT CHAR 18 0
MARKER_DISTANCE_START_POINT Distance between Marker and Start Point EAML_MARKER_DISTANCE_START CHAR 18 0
MARKER_END_POINT Marker for End Point EAML_MARKER_END_POINT CHAR 18 0
MARKER_DISTANCE_END_POINT Length Spec for Distance between Marker and End Point EAML_MARKER_DISTANCE_END CHAR 18 0
MARKER_DISTANCE_UNIT Unit for the Distance from Marker EAML_MARKER_DISTANCE_UNIT T006 UNIT 3 0
MARKER_DISTANCE_UNIT_ISO Unit for the Distance from Marker in ISO Code EAML_MARKER_DISTANCE_UNIT_ISO CHAR 3 0

BAPI_ALM_ORDER_LISTHEAD_RESULT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPI_ALM_ORDER_LISTHEAD_RESULT BUS_AREA BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT TGSB Business Areas MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT BUS_AREA BAPI_ALM_ORDER_LISTHEAD_RESULT BUS_AREA TGSB Business Areas GSBER
BAPI_ALM_ORDER_LISTHEAD_RESULT COSTCENTER BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT CSKS Cost Center Master Data MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT COSTCENTER BAPI_ALM_ORDER_LISTHEAD_RESULT CO_AREA CSKS Cost Center Master Data KOKRS
BAPI_ALM_ORDER_LISTHEAD_RESULT COSTCENTER BAPI_ALM_ORDER_LISTHEAD_RESULT COSTCENTER CSKS Cost Center Master Data KOSTL
BAPI_ALM_ORDER_LISTHEAD_RESULT COSTCENTER BAPI_ALM_ORDER_LISTHEAD_RESULT SYSTEM_AVAILABLE_FROM_DATE CSKS Cost Center Master Data DATBI
BAPI_ALM_ORDER_LISTHEAD_RESULT CURRENCY BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT TCURC Currency Codes MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT CURRENCY BAPI_ALM_ORDER_LISTHEAD_RESULT CURRENCY TCURC Currency Codes WAERS
BAPI_ALM_ORDER_LISTHEAD_RESULT CUSTOMER BAPI_ALM_ORDER_LISTHEAD_RESULT CUSTOMER KNA1 General Data in Customer Master KUNNR
BAPI_ALM_ORDER_LISTHEAD_RESULT CUSTOMER BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT KNA1 General Data in Customer Master MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT EQUIPMENT BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT EQUI Equipment master data MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT EQUIPMENT BAPI_ALM_ORDER_LISTHEAD_RESULT EQUIPMENT EQUI Equipment master data EQUNR
BAPI_ALM_ORDER_LISTHEAD_RESULT FIRST_OFFSET_TYPE_CODE SYST MANDT EAML_D_OFFSET_TC Offset Type Codes MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT FIRST_OFFSET_TYPE_CODE BAPI_ALM_ORDER_LISTHEAD_RESULT FIRST_OFFSET_TYPE_CODE EAML_D_OFFSET_TC Offset Type Codes OFFSET_TC
BAPI_ALM_ORDER_LISTHEAD_RESULT FIRST_OFFSET_UNIT SYST MANDT T006 Units of Measurement MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT FIRST_OFFSET_UNIT BAPI_ALM_ORDER_LISTHEAD_RESULT FIRST_OFFSET_UNIT T006 Units of Measurement MSEHI
BAPI_ALM_ORDER_LISTHEAD_RESULT LINEAR_UNIT SYST MANDT T006 Units of Measurement MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT LINEAR_UNIT BAPI_ALM_ORDER_LISTHEAD_RESULT LINEAR_UNIT T006 Units of Measurement MSEHI
BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTLOC BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT T499S Location MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTLOC BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTPLANT T499S Location WERKS
BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTLOC BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTLOC T499S Location STAND
BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTPLAN BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT MPLA Maintenance plan MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTPLAN BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTPLAN MPLA Maintenance plan WARPL
BAPI_ALM_ORDER_LISTHEAD_RESULT MARKER_DISTANCE_UNIT SYST MANDT T006 Units of Measurement MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT MARKER_DISTANCE_UNIT BAPI_ALM_ORDER_LISTHEAD_RESULT MARKER_DISTANCE_UNIT T006 Units of Measurement MSEHI
BAPI_ALM_ORDER_LISTHEAD_RESULT OBJECT_NO BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT ONR00 General Object Number MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT OBJECT_NO BAPI_ALM_ORDER_LISTHEAD_RESULT OBJECT_NO ONR00 General Object Number OBJNR
BAPI_ALM_ORDER_LISTHEAD_RESULT ORDERID BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT AUFK Order master data MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT ORDERID BAPI_ALM_ORDER_LISTHEAD_RESULT ORDERID AUFK Order master data AUFNR
BAPI_ALM_ORDER_LISTHEAD_RESULT REVISION BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT T352R Maintenance revisions MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT REVISION BAPI_ALM_ORDER_LISTHEAD_RESULT MAINTPLANT T352R Maintenance revisions IWERK
BAPI_ALM_ORDER_LISTHEAD_RESULT REVISION BAPI_ALM_ORDER_LISTHEAD_RESULT REVISION T352R Maintenance revisions REVNR
BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_DOC_NUMBER BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT VBUK Sales Document: Header Status and Administrative Data MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_DOC_NUMBER BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_DOC_NUMBER VBUK Sales Document: Header Status and Administrative Data VBELN
BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_ITM_NUMBER BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_ITM_NUMBER VBUP Sales Document: Item Status POSNR
BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_ITM_NUMBER BAPI_ALM_ORDER_LISTHEAD_RESULT CLIENT VBUP Sales Document: Item Status MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_ITM_NUMBER BAPI_ALM_ORDER_LISTHEAD_RESULT SALES_DOC_NUMBER VBUP Sales Document: Item Status VBELN
BAPI_ALM_ORDER_LISTHEAD_RESULT SECOND_OFFSET_TYPE_CODE SYST MANDT EAML_D_OFFSET_TC Offset Type Codes MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT SECOND_OFFSET_TYPE_CODE BAPI_ALM_ORDER_LISTHEAD_RESULT SECOND_OFFSET_TYPE_CODE EAML_D_OFFSET_TC Offset Type Codes OFFSET_TC
BAPI_ALM_ORDER_LISTHEAD_RESULT SECOND_OFFSET_UNIT SYST MANDT T006 Units of Measurement MANDT
BAPI_ALM_ORDER_LISTHEAD_RESULT SECOND_OFFSET_UNIT BAPI_ALM_ORDER_LISTHEAD_RESULT SECOND_OFFSET_UNIT T006 Units of Measurement MSEHI