SAP ABAP Table SMOVBAK (Sales Document: Header 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	SMOVBAK	Table Relationship Diagram
Short Description	Sales Document: Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAVBAK	SMO_SFAVBK	SMO_GUID	CHAR	32	0	SFA Key of Sales Document
3	SFAKNVV	SMO_SFAKNV	SMO_GUID	CHAR	32	0	SFA Key of Customer Sales Area
4	SFAKNA1	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
5	SOURCE	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
6	VBELN	SMO3VBELN2	SMO3VBELN	CHAR	10	0	Sales document
7	VKORG	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
8	VTWEG	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
9	SPART	SMO3SPART	SMO3SPART	CHAR	2	0	Division
10	VKGRP	SMO3VKGRP	SMO3VKGRP	CHAR	14	0	Sales group
11	VKBUR	SMO3VKBUR	SMO3VKBUR	CHAR	14	0	Sales office
12	PHLINE	SMO_PHLINE	SMO_TXT20	CHAR	20	0	Pharmaceutical: BU Line
13	KUNNR	SMO3KUNAG	SMO3KUNNR	CHAR	10	0	Sold-to party
14	SOURCE_C	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
15	VBTYP	SMO3VBTYP	SMO3VBTYP	CHAR	1	0	SD document category
16	AUART	SMO3AUART	SMO3AUART	CHAR	4	0	Sales document type
17	KVPRINTED	SMO_KVPRIN	SMO_LOGICL	CHAR	1	0	Sales Document was printed (T/F)
18	KVCOMMIT	SMO_KVCOMM	SMO_LOGICL	CHAR	1	0	Sales Document was committed (T/F)
19	KVUPLOAD	SMO_KVUPLO	SMO_LOGICL	CHAR	1	0	Sales Document was uploaded (T/F)
20	BSTNK	SMO3BSTNK	SMO3BSTNK	CHAR	35	0	Customer purchase order number
21	BSARK	SMO3BSARK	SMO3BSARK	CHAR	4	0	Customer purchase order type
22	BSTDK	SMO3BSTDK	DATUM	DATS	8	0	Customer purchase order date
23	ANGDT	SMO3ANGDT	DATUM	DATS	8	0	Quotation/Inquiry is valid from
24	BNDDT	SMO3BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
25	AUDAT	SMO3AUDAT	DATUM	DATS	8	0	Document date (date received/sent)
26	AUGRU	SMO3AUGRU	SMO3AUGRU	CHAR	3	0	Order reason (reason for the business transaction)
27	GUEBG	SMO3GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
28	GUEEN	SMO3GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
29	AWAHR	SMO3AWAHR1	SMO3AWAHR	NUMC	3	0	Order probability
30	GWLDT	SMO3GWLDT	DATUM	DATS	8	0	Guarantee date
31	LIFSK	SMO3LIFSK	SMO3LIFSP	CHAR	2	0	Delivery block (document header)
32	FAKSK	SMO3FAKSK	SMO3FAKSP	CHAR	2	0	Billing block in SD document
33	NETWR	SMO_DMBTR		CURR	28	9	Amount in local currency
34	WAERK	SMO3WAERK	WAERS	CUKY	5	0	SD document currency	*
35	KNUMV	SMO3KNUMV	SMO3KNUMV	CHAR	10	0	Number of the document condition
36	VDATU	SMO3EDATU1	DATUM	DATS	8	0	Requested delivery date
37	VPRGR	SMO3PRGRS1	SMO3PRGRS	CHAR	1	0	Proposed date type
38	AUTLF	SMO3AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
39	KALSM	SMO3KALSM	SMO3KALSM	CHAR	6	0	Pricing procedure for sales and distribution
40	VSBED	SMO3VSBED	SMO3VSBED	CHAR	2	0	Shipping conditions
41	IHREZ	SMO3IHREZ	TEXT12	CHAR	12	0	Customer's or vendor's internal reference
42	BNAME	SMO3BNAME	NAME	CHAR	35	0	Name of orderer
43	KVGR1	SMO3KVGR1	SMO3KVGR1	CHAR	3	0	Customer group 1
44	KVGR2	SMO3KVGR2	SMO3KVGR2	CHAR	3	0	Customer group 2
45	KVGR3	SMO3KVGR3	SMO3KVGR3	CHAR	3	0	Customer group 3
46	KVGR4	SMO3KVGR4	SMO3KVGR4	CHAR	3	0	Customer group 4
47	KVGR5	SMO3KVGR5	SMO3KVGR5	CHAR	3	0	Customer group 5
48	KNUMA	SMO3KNUMA	SMO3KNUMA	CHAR	10	0	Agreement (various conditions grouped together)
49	KURST	SMO3KURST	KURST	CHAR	4	0	Exchange rate type	*
50	ABRVW	SMO3ABRVW	SMO3ABRVW	CHAR	3	0	Usage indicator
51	VGBEL	SMO3VGBEL	SMO3VBELN	CHAR	10	0	Document number of the reference document
52	TAXK1	SMO3TAXK11	SMO3TAXKD	CHAR	1	0	Alternative tax classification
53	TAXK2	SMO3TAXK2	SMO3TAXKD	CHAR	1	0	Tax classification 2 for customer
54	TAXK3	SMO3TAXK3	SMO3TAXKD	CHAR	1	0	Tax classification 3 for customer
55	TAXK4	SMO3TAXK4	SMO3TAXKD	CHAR	1	0	Tax classification 4 for customer
56	TAXK5	SMO3TAXK5	SMO3TAXKD	CHAR	1	0	Tax classification 5 for customer
57	TAXK6	SMO3TAXK6	SMO3TAXKD	CHAR	1	0	Tax classification 6 for customer
58	TAXK7	SMO3TAXK7	SMO3TAXKD	CHAR	1	0	Tax classification 7 for customer
59	TAXK8	SMO3TAXK8	SMO3TAXKD	CHAR	1	0	Tax classification 8 for customer
60	TAXK9	SMO3TAXK9	SMO3TAXKD	CHAR	1	0	Tax classification 9 for customer
61	VGTYP	SMO3VBTYP2	SMO3VBTYP	CHAR	1	0	Document category of preceding SD document
62	KV_LANGU	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
63	KTEXT	SMO3KTEXT1	TEXT40	CHAR	40	0	Search term for product proposal
64	AUFNR	SMO3AUFNR	SMO3AUFNR	CHAR	12	0	Order number
65	QMNUM	SMO3QMNUM	SMO3QMNUM	CHAR	12	0	Notification number
66	LISTDAT	SMO_LISDAT	SMO_LISDAT	DATS	8	0	Date of listed document
67	LISTTYPE	SMO_LISTTP	SMO_CHOI4	CHAR	4	0	Listed Item Type
68	KVOUTYP	SMO_CHOI4	SMO_TXT4	CHAR	4	0	Key for Choice Text
69	KVWHOLE	SMO_LOGICL	SMO_LOGICL	CHAR	1	0	Logical field (true/false)
70	KVMARKT	SMO_CHOI4	SMO_TXT4	CHAR	4	0	Key for Choice Text
71	INCOMPL	SMO_INCPLT	SMO_LOGICL	CHAR	1	0	Incomplete (T/F)
72	SDSTATUS	SMO_STAT	SMO_TEXT1	CHAR	1	0	Status
73	SFAPOSORG	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
74	SFALAYITM	SMO_SFALAT	SMO_GUID	CHAR	32	0	SFA key of Layout for sales document print-out
75	SFAVBAK2	SMO_SFVBK2	SMO_GUID	CHAR	32	0	Sfa Key of refernce Sales document
76	SFAVBKA	SMO_SFAACT	SMO_GUID	CHAR	32	0	SFA key of Activity Master (VBKA)
77	SFAOBJEKT	SMO_SFAOBJ	SMO_GUID	CHAR	32	0	SFA Key of Opportunity
78	SFAMITABT	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
79	SFAMITAB2	SMO_SFAMI2	SMO_GUID	CHAR	32	0	Key of the assigned / central employe
80	SFAKNA2	SMO_SFAKN2	SMO_GUID	CHAR	32	0	SFA Key for Busines Partner 2 / Contact person
81	SFANOTIFN	SMO_SFANOT	SMO_GUID	CHAR	32	0	SFA key for Service Notification
82	SFASORDER	SMO_SFASOR	SMO_GUID	CHAR	32	0	SFA key of service order
83	SFAFPLA	SMOG_GUID	SMOG_GUID	CHAR	32	0	GUID
84	ERDAT	SMO3ERDAT	DATUM	DATS	8	0	Date on which the record was created
85	ERZET	SMO3ERZET	UZEIT	TIMS	6	0	Entry time
86	ERNAM	SMO3ERNAM	USNAM	CHAR	12	0	Name of person who created the object
87	BUKRS_VF	SMO3BUKRS2	SMO3BUKRS	CHAR	4	0	Company code to be billed
88	VBACH1	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
89	VBACH2	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
90	VBACH3	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
91	VBKLA	SMO_VBKLA	SMO_TEXT10	CHAR	10	0	SMO_VBKLA
92	FLAG1	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
93	FLAG2	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
94	FLAG3	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
95	NON_GUID	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
96	.INCLUDE				0	0	Communication Fields for Mobile Sales/Service
97	TR_USER	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
98	TR_ID	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
99	TR_STATUS	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
100	TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
101	DELETED	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
102	TR_ROOTID	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
103	SUBMI	SMO3SUBMSD	CHAR10	CHAR	10	0	Collective number (SD)
104	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
105	PARTNER	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
106	AEDAT	SMO3AEDAT	DATUM	DATS	8	0	Last changed on
107	AENAM	SMO3AENAM	USNAM	CHAR	12	0	Name of person who changed object
108	AEZET	SMO3AEZEI	UHRZT	TIMS	6	0	Time of change
109	COND	SMO3COND	SMO3COND	CHAR	6	0	Indicator for Conditions
110	FG_PROC	SMOFGPROC	SMO_TXT6	CHAR	6	0	Free Goods Procedure
111	ANGZET	SMO3ANGZET	UHRZT	TIMS	6	0	Time of change
112	AUZET	SMO3AUZET	UHRZT	TIMS	6	0	Time of change
113	BNDZET	SMO3BNDZET	UHRZT	TIMS	6	0	Time of change
114	BSTZET	SMO3BSTZET	UHRZT	TIMS	6	0	Time of change
115	GUEBGZET	SMO3GUEBGZET	UHRZT	TIMS	6	0	Time of change
116	GUEENZET	SMO3GUEENZET	UHRZT	TIMS	6	0	Time of change
117	OBJECT_TYPE	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
118	CRM_CHANGED_AT	CRMT_ONLINE_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change in CRM Online
119	LOGICAL_SYSTEM	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
120	VERSION_ID	SMO_VERID	CHAR10	CHAR	10	0	Version Identifier
121	VDZET	SMO3VDZET	UHRZT	TIMS	6	0	Time of change
122	CODE	SMO_CODE	SMO_TXT4	CHAR	4	0	Status reason: code
123	KATART	SMO_KATAL	SMO_TEXT2	CHAR	2	0	Status reason: catalog
124	CODEGR	SMO_CODEG	SMO_TXT8	CHAR	8	0	Status reason: code group
125	ALT_ID_TYPE	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs