SAP ABAP Table BAPI_ALM_ORDER_LISTHEAD_RESULT (ALM Orders: Order List from Selection)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ IWO_BAPI_EX (Package) BAPI Interfaces ALM Order

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI_ALM_ORDER_LISTHEAD_RESULT	Table Relationship Diagram
Short Description	ALM Orders: Order List from Selection

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
2	ORDER_TYPE	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
3	CURRENCY	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
4	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
5	ENTERED_BY	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
6	ENTER_DATE	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
7	CHANGED_BY	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
8	CHANGE_DATE	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
9	SHORT_TEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
10	LONG_TEXT_FLAG	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
11	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
12	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
13	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
14	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
15	RESPCCTR	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	*
16	DELETION_FLAG	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
17	CSTG_SHEET	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	*
18	OVERHEAD_KEY	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
19	ABCINDIC	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	*
20	SORTFIELD	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
21	PRIORITY	☐	PRIOK	PRIOK	CHAR	1	0	Priority	*
22	EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
23	ASSEMBLY	☐	BAUTL	MATNR	CHAR	18	0	Assembly	*
24	SYSTCOND	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	*
25	PLANPLANT	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
26	PLANGROUP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	*
27	RESP_PLANNER_GROUP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
28	MN_WK_CTR	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
29	MN_WK_PLANT	☐	AWERK	WERKS	CHAR	4	0	Plant associated with main work center	*
30	CUSTOMER	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
31	SYSTEM_RESP	☐	ANING	USNAM	CHAR	12	0	Name of Person Reponsible for System
32	PLANNED_DOWN_TIME	☐	EGAUZT	DEC9_2	DEC	11	2	Planned Breakdown Duration
33	SYSTEM_AVAILABLE_TO_DATE	☐	ANLBD	DATUM	DATS	8	0	Date until which the system is available
34	SYSTEM_AVAILABLE_FROM_DATE	☐	ANLVD	DATUM	DATS	8	0	Date from which the system is available
35	SYSTEM_AVAILABLE_TO_TIME	☐	ANLBZ	UHRZT	TIMS	6	0	Time until which the system is available
36	SYSTEM_AVAILABLE_FROM_TIME	☐	ANLVZ	UHRZT	TIMS	6	0	Time from Which System is Available
37	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
38	MAINTPLANT	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	*
39	MAINTLOC	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
40	MAINTROOM	☐	RAUMNR	CHAR8	CHAR	8	0	Room
41	PLSECTN	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	*
42	FUNCLOC	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
43	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
44	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
45	REVISION	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
46	MAINTPLAN	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
47	MAINTITEM	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
48	S_STATUS	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
49	U_STATUS	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
50	WORK_CNTR	☐	ARBPL	ARBPL	CHAR	8	0	Work center
51	FINISH_DATE	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
52	START_DATE	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
53	PRODUCTION_FINISH_DATE	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
54	PRODUCTION_START_DATE	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
55	ACTUAL_START_DATE	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
56	CONFIRMED_FINISH_DATE	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
57	PLANNER_GROUP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
58	ACTUAL_RELEASE_DATE	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
59	PMACTTYPE	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	*
60	NOTIF_NO	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
61	HISTORY_DATE	☐	HISDA	DATUM	DATS	8	0	PM request: History date
62	EQUIDESCR	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
63	FUNCLDESCR	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
64	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
65	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
66	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
67	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
68	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
69	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
70	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
71	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
72	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
73	PROFIT_SEGM_NO	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
74	TOTAL_COSTS_ACT	☐	DGESKOSIST	WERTV8	CURR	15	2	Total(actual) maintenance costs
75	TOTAL_COSTS_PLAN	☐	DGESKOPLAN	WERTV8	CURR	15	2	Total plant maintenance costs (planned)
76	TOTAL_SETTLEMENT_COSTS	☐	DGESKOABRE	WERTV8	CURR	15	2	Total Settlement Costs (PMCO)
77	TOTAL_REVENUES_ACT	☐	DGESERTRAG	WERTV8	CURR	15	2	Total plant maintenance revenues (actual)
78	TOTAL_REVENUES_PLAN	☐	DGPLERTRAG	WERTV8	CURR	15	2	Total (planned) maintenance revenues
79	TOTAL_SUM_ACT	☐	DPMISTVAL	WERTV8	CURR	15	2	Actual sum of maintenance order (costs - revenues)
80	TOTAL_SUM_PLAN	☐	DPMPLANVAL	WERTV8	CURR	15	2	Plan sum of maintenance order (costs - revenues)
81	OBJECT_NO	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
82	SALES_DOC_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
83	SALES_ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
84	LEADING_ORDERID	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	*
85	SUPERIOR_ORDERID	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order	*
86	ACTUAL_FINISH_TIME	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
87	ACTUAL_START_TIME	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
88	PRODUCTION_FINISH_TIME	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
89	PRODUCTION_START_TIME	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
90	TASK_LIST_GROUP	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
91	GROUP_COUNTER	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
92	ORDPLANID	☐	AUF_PLKNZ	AUF_PLKNZ	CHAR	1	0	Maintenance order planning indicator
93	REFDATE	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
94	WBS_ELEMENT	☐	I_PM_POSID	CHAR24	CHAR	24	0	Work Breakdown Structure Element (WBS Element) for List
95	SUPERIOR_NETWORK	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network	*
96	SUPERIOR_ACTIVITY	☐	VORG_UEBER	VORNR	CHAR	4	0	Superior activity
97	ESTIMATED_COSTS	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
98	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
99	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
100	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
101	BASIC_FIN	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
102	BASICSTART	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
103	REFTIME	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
104	CALC_MOTIVE	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
105	ADDR_NO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
106	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
107	SERIALNO	☐	GERNR	GERNR	CHAR	18	0	Serial Number
108	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
109	SALES_OFF	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
110	SALES_GRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
111	MATL_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
112	ASSMBL_DESC	☐	BAUTXL	TEXT40	CHAR	40	0	Assembly Description
113	PAGESTATUS	☐	PAGESTAT	PAGESTAT	CHAR	4	0	Paging Status
114	WBS_ELEMENT_HEAD	☐	I_PM_POSID_HEADER	CHAR24	CHAR	24	0	Work breakdown structure element (WBS element) order header
115	MRP_RELEVANT	☐	AUDISP_PLUS	AUDISP	CHAR	1	0	Reservation Relevance/Generation of Purchase Requisition
116	PHASE	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
117	PRIOTYPE	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	*
118	PRIO_DESC	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
119	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
120	PURCH_DATE	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
121	SERVICE_MATERIAL	☐	MATSV	MATNR	CHAR	18	0	Service product	*
122	SERVICE_MATL_DESC	☐	MATSVTX	TEXT40	CHAR	40	0	Description of Service Product
123	SERVICE_MATL_QUANTITY	☐	MNGSP	MENG13	QUAN	13	3	Service product quantity
124	SERVCIE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
125	SERVCIE_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
126	BILLING_FORM	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
127	PLAN_PLANNER_GROUP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
128	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
129	OBJECTLIST_NO	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	*
130	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
131	ASSEMBLY_EXTERNAL	☐	MGV_ASSEMBLY_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for Field ASSEMBLY
132	ASSEMBLY_GUID	☐	MGV_ASSEMBLY_GUID	MATNR_EGUID	CHAR	32	0	External GUID for ASSEMBLY Field
133	ASSEMBLY_VERSION	☐	MGV_ASSEMBLY_VERSION	MATNR_VERS	CHAR	10	0	Version Number for ASSEMBLY Field
134	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
135	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
136	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
137	SERVICE_MATERIAL_EXTERNAL	☐	MGV_SERVICE_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for SERVICE_MATERIAL Field
138	SERVICE_MATERIAL_GUID	☐	MGV_SERVICE_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for SERVICE_MATERIAL Field
139	SERVICE_MATERIAL_VERSION	☐	MGV_SERVICE_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for SERVICE_MATERIAL Field
140	START_POINT	☐	EAML_START_POINT	EAML_POINT	CHAR	18	0	Start Point
141	END_POINT	☐	EAML_END_POINT	EAML_POINT	CHAR	18	0	End Point
142	LINEAR_LENGTH	☐	EAML_LINEAR_LENGTH	EAML_POINT	CHAR	18	0	Length
143	LINEAR_UNIT	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	T006
144	LINEAR_UNIT_ISO	☐	EAML_LINEAR_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Linear Data in ISO Code	*
145	FIRST_OFFSET_TYPE_CODE	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	EAML_D_OFFSET_TC
146	FIRST_OFFSET_VALUE	☐	EAML_OFFSET1_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 1
147	FIRST_OFFSET_UNIT	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	T006
148	FIRST_OFFSET_UNIT_ISO	☐	EAML_OFFSET1_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 1 in ISO Code	*
149	SECOND_OFFSET_TYPE_CODE	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	EAML_D_OFFSET_TC
150	SECOND_OFFSET_VALUE	☐	EAML_OFFSET2_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 2
151	SECOND_OFFSET_UNIT	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	T006
152	SECOND_OFFSET_UNIT_ISO	☐	EAML_OFFSET2_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 2 in ISO Code	*
153	FIRST_OFFSET_TYPE_CODE_NAME	☐	EAML_OFFSET1_TYPE_CODE_NAME	TXT60	CHAR	60	0	First Offset Type Description
154	SECOND_OFFSET_TYPE_CODE_NAME	☐	EAML_OFFSET2_TYPE_CODE_NAME	TXT60	CHAR	60	0	Second Offset Type Description
155	MARKER_START_POINT	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
156	MARKER_DISTANCE_START_POINT	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
157	MARKER_END_POINT	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
158	MARKER_DISTANCE_END_POINT	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
159	MARKER_DISTANCE_UNIT	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	T006
160	MARKER_DISTANCE_UNIT_ISO	☐	EAML_MARKER_DISTANCE_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit for the Distance from Marker in ISO Code	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI_ALM_ORDER_LISTHEAD_RESULT	BUS_AREA	TGSB	GSBER
2	BAPI_ALM_ORDER_LISTHEAD_RESULT	COSTCENTER	CSKS	KOSTL
3	BAPI_ALM_ORDER_LISTHEAD_RESULT	CURRENCY	TCURC	WAERS
4	BAPI_ALM_ORDER_LISTHEAD_RESULT	CUSTOMER	KNA1	KUNNR
5	BAPI_ALM_ORDER_LISTHEAD_RESULT	EQUIPMENT	EQUI	EQUNR
6	BAPI_ALM_ORDER_LISTHEAD_RESULT	FIRST_OFFSET_TYPE_CODE	EAML_D_OFFSET_TC	OFFSET_TC
7	BAPI_ALM_ORDER_LISTHEAD_RESULT	FIRST_OFFSET_UNIT	T006	MSEHI
8	BAPI_ALM_ORDER_LISTHEAD_RESULT	LINEAR_UNIT	T006	MSEHI
9	BAPI_ALM_ORDER_LISTHEAD_RESULT	MAINTLOC	T499S	STAND
10	BAPI_ALM_ORDER_LISTHEAD_RESULT	MAINTPLAN	MPLA	WARPL
11	BAPI_ALM_ORDER_LISTHEAD_RESULT	MARKER_DISTANCE_UNIT	T006	MSEHI
12	BAPI_ALM_ORDER_LISTHEAD_RESULT	OBJECT_NO	ONR00	OBJNR
13	BAPI_ALM_ORDER_LISTHEAD_RESULT	ORDERID	AUFK	AUFNR
14	BAPI_ALM_ORDER_LISTHEAD_RESULT	REVISION	T352R	REVNR
15	BAPI_ALM_ORDER_LISTHEAD_RESULT	SALES_DOC_NUMBER	VBUK	VBELN
16	BAPI_ALM_ORDER_LISTHEAD_RESULT	SALES_ITM_NUMBER	VBUP	POSNR
17	BAPI_ALM_ORDER_LISTHEAD_RESULT	SECOND_OFFSET_TYPE_CODE	EAML_D_OFFSET_TC	OFFSET_TC
18	BAPI_ALM_ORDER_LISTHEAD_RESULT	SECOND_OFFSET_UNIT	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in	110