SAP ABAP Table SMOKNVV (Customer Master Sales 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	SMOKNVV	Table Relationship Diagram
Short Description	Customer Master Sales 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	SFAKNVV	☑	SMO_SFAKNV	SMO_GUID	CHAR	32	0	SFA Key of Customer Sales Area
3	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
4	KUNNR	☐	SMO3KUNNR	SMO3KUNNR	CHAR	10	0	Customer number
5	SOURCE_C	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
6	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
7	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
8	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
9	PHLINE	☐	SMO_PHLINE	SMO_TXT20	CHAR	20	0	Pharmaceutical: BU Line
10	AUFSD	☐	SMO3AUFSD	SMO3KAUFS	CHAR	2	0	Customer order block (sales area)
11	KALKS	☐	SMO3KALKS	SMO3KALKS	CHAR	1	0	Pricing procedure assigned to this customer
12	VERSG	☐	SMO3STGKU	SMO3STGKU	CHAR	1	0	Customer statistics group
13	LOEVM	☐	SMO3LOEVM1	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
14	BZIRK	☐	SMO3BZIRK	SMO3BZIRK	CHAR	6	0	Sales district
15	VKBUR	☐	SMO3VKBUR	SMO3VKBUR	CHAR	14	0	Sales office
16	VKGRP	☐	SMO3VKGRP	SMO3VKGRP	CHAR	14	0	Sales group
17	KDGRP	☐	SMO3KDGRP	SMO3KDGRP	CHAR	2	0	Customer group
18	WAERS	☐	SMO3WAERS4	WAERS	CUKY	5	0	Currency	*
19	AWAHR	☐	SMO3AWAHR	SMO3AWAHR	NUMC	3	0	Order probability of the item
20	VSORT	☐	SMO3VSORT	SMO3VBELN	CHAR	10	0	Item proposal
21	EIKTO	☐	SMO3EIKTO	CHAR12	CHAR	12	0	Our account number at the customer or vendor
22	KURST	☐	SMO3KURST	KURST	CHAR	4	0	Exchange rate type	*
23	KONDA	☐	SMO3KONDA	SMO3KONDA	CHAR	2	0	Price group (customer)
24	PLTYP	☐	SMO3PLTYP	SMO3PLTYP	CHAR	2	0	Price list type
25	LPRIO	☐	SMO3LPRIO	SMO3LPRIO	NUMC	2	0	Delivery priority
26	VSBED	☐	SMO3VSBED	SMO3VSBED	CHAR	2	0	Shipping conditions
27	VWERK	☐	SMO3DWERK	SMO3WERKS	CHAR	4	0	Delivering plant
28	KZAZU	☐	SMO3KZAZU	XFELD	CHAR	1	0	Order combination indicator
29	CHSPL	☐	SMO3CHSPL	XFELD	CHAR	1	0	Batch split allowed
30	AUTLF	☐	SMO3AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
31	KZTLF	☐	SMO3KZTLF	SMO3KZTLF	CHAR	1	0	Partial delivery at item level
32	ANTLF	☐	SMO3ANTLF	SMO3ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
33	MRNKZ	☐	SMO3MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
34	BOKRE	☐	SMO3BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
35	PRFRE	☐	SMO3PRFRE	XFELD	CHAR	1	0	Relevant for price determination ID
36	PERFK	☐	SMO3PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	*
37	PERRL	☐	SMO3PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	*
38	INCO1	☐	SMO3INCO1	SMO3INCO1	CHAR	3	0	Incoterms (part 1)
39	INCO2	☐	SMO3INCO2	SMO3INCO2	CHAR	28	0	Incoterms (part 2)
40	ZTERM	☐	SMO3DZTER	SMO3ZTERM	CHAR	4	0	Terms of payment key
41	LIFSD	☐	SMO3LIFSD	SMO3LIFSP	CHAR	2	0	Customer delivery block (sales area)
42	FAKSD	☐	SMO3FAKSD	SMO3FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)
43	KLABC	☐	SMO3KLABC	SMO3KLABC	CHAR	2	0	Customer classification (ABC analysis)
44	KVGR1	☐	SMO3KVGR1	SMO3KVGR1	CHAR	3	0	Customer group 1
45	KVGR2	☐	SMO3KVGR2	SMO3KVGR2	CHAR	3	0	Customer group 2
46	KVGR3	☐	SMO3KVGR3	SMO3KVGR3	CHAR	3	0	Customer group 3
47	KVGR4	☐	SMO3KVGR4	SMO3KVGR4	CHAR	3	0	Customer group 4
48	KVGR5	☐	SMO3KVGR5	SMO3KVGR5	CHAR	3	0	Customer group 5
49	KABSS	☐	SMO3KABSS	SMO3KABSS	CHAR	4	0	Customer payment guarantee procedure
50	UEBTO	☐	SMO3UEBTO	SMO3PRZ21	DEC	3	1	Overdelivery tolerance limit
51	UNTTO	☐	SMO3UNTTO	SMO3PRZ21	DEC	3	1	Underdelivery tolerance limit
52	UEBTK	☐	SMO3UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited overdelivery allowed
53	ERDAT	☐	SMO3ERDAT	DATUM	DATS	8	0	Date on which the record was created
54	ERNAM	☐	SMO3ERNAM	USNAM	CHAR	12	0	Name of person who created the object
55	PARTNER	☐	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
56	RLTYP	☐	SMO_RLTYP	SMO_RLTYP	CHAR	8	0	ZGP Relation Type
57	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
58	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
59	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
60	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
61	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
62	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
63	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
64	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
65	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
66	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
67	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
68	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
69	BRYTH	☐	SMO3BRYTH	SMO3BRYTH	CHAR	4	0	Call frequency
70	SFAKNVVSHT	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
71	KTGRD	☐	CRM_ACCTGRPBP	CRM_ACCTGRPBP	CHAR	2	0	Business Partner Account Assignment Group	*

History

Last changed by/on	SAP	20100420
SAP Release Created in