SAP ABAP Table SMOSORDER (Order master data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOSORDER	Table Relationship Diagram
Short Description	Order master data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFASORDER	☑	SMO_SFASOR	SMO_GUID	CHAR	32	0	SFA key of service order
3	SFANOTIFN	☐	SMO_SFANOT	SMO_GUID	CHAR	32	0	SFA key for Service Notification
4	SFAILOA	☐	SMO_SFAILO	SMO_GUID	CHAR	32	0	SFA key for Location
5	SFAEQUI	☐	SMO_SFAEQI	SMO_GUID	CHAR	32	0	SFA Key of Equipment (EQUI)
6	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
7	SFAADRC	☐	SMO_SFAADC	SMO_GUID	CHAR	32	0	SFA Key of Address
8	SFAMITABT	☐	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
9	SFAVBAK	☐	SMO_SFAVKC	SMO_GUID	CHAR	32	0	SFA Key for Service Contract Object
10	SFAVBAP	☐	SMO_SFAVPC	SMO_GUID	CHAR	32	0	SFA Key for Service Contract Item
11	SFAWRKCNT	☐	SMO_SFAWCT	SMO_GUID	CHAR	32	0	Identifier Workcenter
12	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
13	AUFNR	☐	SMO3AUFNR	SMO3AUFNR	CHAR	12	0	Order number
14	ORD_STATUS	☐	SMO_STSORD	SMO_ST2	CHAR	2	0	Status of Service order
15	AUART	☐	SMO3AUFAR	SMO3AUFAR	CHAR	4	0	Order type
16	ERNAM	☐	SMO3AUFER1	USNAM	CHAR	12	0	Entered by
17	ERDAT	☐	SMO3AUFER	DATUM	DATS	8	0	Date created
18	AENAM	☐	SMO3AUFAE1	USNAM	CHAR	12	0	User ID of person who made the last change
19	AEDAT	☐	SMO3AUFAE	DATUM	DATS	8	0	Change date for Order Master
20	KTEXT	☐	SMO3AUFTE	TEXT40	CHAR	40	0	Short text
21	LTEXT	☐	SMO3AUFLT	XFELD	CHAR	1	0	Indicator: "Long text exists"
22	BUKRS	☐	SMO3BUKRS	SMO3BUKRS	CHAR	4	0	Company code
23	WERKS	☐	SMO3WERKS	SMO3WERKS	CHAR	4	0	Plant
24	GSBER	☐	SMO3GSBER	SMO3GSBER	CHAR	4	0	Business area
25	KOKRS	☐	SMO3KOKRS	SMO3CACCD	CHAR	4	0	Controlling area
26	KOSTV	☐	SMO3AUFKO	SMO3KOSTL	CHAR	10	0	Responsible cost center
27	WAERS	☐	SMO3AUFWA	WAERS	CUKY	5	0	Order Currency	*
28	USER4	☐	SMO_USER4	SMO_CURRCY	CURR	28	9	Estimated total costs of order
29	OBJNR	☐	SMO3J_OBJ	SMO3J_OBJ	CHAR	22	0	Object number
30	PRCTR	☐	SMO3PRCTR	SMO3PRCTR	CHAR	10	0	Profit center
31	KDAUF	☐	SMO3KDAUF	SMO3VBELN	CHAR	10	0	Sales order number
32	KDPOS	☐	SMO3KDPOS	NUM06	NUMC	6	0	Item number in sales order
33	BEMOT	☐	SMO3BEMOT	SMO3BEMOT	CHAR	2	0	Accounting indicator
34	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
35	ERFZEIT	☐	SMO3CO_IN	UZEIT	TIMS	6	0	Time created
36	AEZEIT	☐	SMO3CO_CH	UZEIT	TIMS	6	0	Changed at
37	ARTPR	☐	SMO3ARTPR	SMO3ARTPR	CHAR	2	0	Priority type
38	PRIOK	☐	SMO3PRIOK	SMO3PRIOK	CHAR	1	0	Priority
39	EQUNR	☐	SMO3EQUNR	SMO3EQUNR	CHAR	18	0	Equipment number
40	BAUTL	☐	SMO3BAUTL	SMO3MATNR	CHAR	40	0	Assembly
41	ILOAN	☐	SMO3ILOAN	SMO3ILOAN	CHAR	12	0	Location and account assignment for technical object
42	IWERK	☐	SMO3IWERK	SMO3WERKS	CHAR	4	0	Maintenance Planning Plant
43	INGPR	☐	SMO3INGRP	SMO3INGRP	CHAR	3	0
44	GEWRK	☐	SMO3LGWID	SMO3CR_OB	NUMC	8	0	Object ID of the Work Center
45	KUNUM	☐	SMO3KUNUM	SMO3KUNNR	CHAR	10	0	Customer number
46	SOURCE_C	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
47	OBKNR	☐	SMO3OBJKN	SMO3OBJKN	INT4	10	0	Object list number
48	ADDAT	☐	SMO3ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
49	ADUHR	☐	SMO3ADUHR	UZEIT	TIMS	6	0	Time of reference date
50	ILART	☐	SMO3ILA	SMO3ILART	CHAR	3	0	Maintenance activity type
51	QMNUM	☐	SMO3QMNUM	SMO3QMNUM	CHAR	12	0	Notification number
52	SERIALNR	☐	SMO3GERNR	SMO3GERNR	CHAR	18	0	Serial number
53	SERMAT	☐	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
54	DEVICEID	☐	SMO3DEVIC	SMO3DEVIC	CHAR	40	0	Additional device data
55	GLTRP	☐	SMO3CO_GL	DATUM	DATS	8	0	Finish date
56	GSTRP	☐	SMO3CO_GS1	DATUM	DATS	8	0	Order start date
57	GLTRS	☐	SMO3CO_GL1	DATUM	DATS	8	0	Scheduled finish
58	GSTRS	☐	SMO3CO_GS2	DATUM	DATS	8	0	Scheduled start
59	GSTRI	☐	SMO3CO_GS	DATUM	DATS	8	0	Actual start date
60	GETRI	☐	SMO3CO_GE	DATUM	DATS	8	0	Confirmed order finish date
61	RSNUM	☐	SMO3RSNUM	SMO3RSNUM	NUMC	10	0	Number of reservation/dependent requirements
62	AUFPL	☐	SMO3CO_AU	SMO3AUFPL	NUMC	10	0	Routing number for operations in the order
63	GLUZP	☐	SMO3CO_GL2	UHRZT	TIMS	6	0	Basic finish (time)
64	GSUZP	☐	SMO3CO_GS4	UHRZT	TIMS	6	0	Basic start time
65	GSUZI	☐	SMO3CO_GS3	UHRZT	TIMS	6	0	Actual start time
66	GEUZI	☐	SMO3CO_GE1	UHRZT	TIMS	6	0	Confirmed order finish (time)
67	GLUZS	☐	SMO3CO_GL3	UHRZT	TIMS	6	0	Scheduled finish time
68	GSUZS	☐	SMO3CO_GS5	SMO3ATIME	TIMS	6	0	Scheduled start time
69	BSTKD	☐	SMO3BSTKD	SMO3BSTKD	CHAR	35	0	Customer purchase order number
70	BSTDK	☐	SMO3BSTDK	DATUM	DATS	8	0	Customer purchase order date
71	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
72	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
73	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
74	VKGRP	☐	SMO3VKGRP	SMO3VKGRP	CHAR	14	0	Sales group
75	VKBUR	☐	SMO3VKBUR	SMO3VKBUR	CHAR	14	0	Sales office
76	FFPRF	☐	SMO3AD01P	SMO3AD01P	CHAR	8	0	Dynamic item processor profile
77	FAKTF	☐	SMO3FAKTF	SMO3FAKTF	CHAR	2	0	Billing form
78	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
79	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
80	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
81	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
82	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
83	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
84	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
85	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
86	MSECREATED	☐	SMO_MSECRE	BOOLE	CHAR	1	0	Value for records created by MSE client

History

Last changed by/on	SAP	20110908
SAP Release Created in