SAP ABAP Table SMOKNVV (Customer Master Sales Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-MSA (Application Component) Mobile Sales
⤷
SMO3 (Package) Consolidated Database
![](/abap/icon/s_instal.gif)
⤷
![](/abap/icon/s_b_tree.gif)
⤷
![](/abap/icon/s_pckstd.gif)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SMOKNVV |
![]() |
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 | CLNT | 3 | 0 | Client | * | |
2 | ![]() |
SMO_SFAKNV | SMO_GUID | CHAR | 32 | 0 | SFA Key of Customer Sales Area | ||
3 | ![]() |
SMO_SFAKN1 | SMO_GUID | CHAR | 32 | 0 | SFA Key of Business Partner | ||
4 | ![]() |
SMO3KUNNR | SMO3KUNNR | CHAR | 10 | 0 | Customer number | ||
5 | ![]() |
SMO_SOURCE | SMO_SOURCE | CHAR | 3 | 0 | Source of an object | ||
6 | ![]() |
SMO3VKORG | SMO3VKORG | CHAR | 14 | 0 | Sales organization | ||
7 | ![]() |
SMO3VTWEG | SMO3VTWEG | CHAR | 2 | 0 | Distribution channel | ||
8 | ![]() |
SMO3SPART | SMO3SPART | CHAR | 2 | 0 | Division | ||
9 | ![]() |
SMO_PHLINE | SMO_TXT20 | CHAR | 20 | 0 | Pharmaceutical: BU Line | ||
10 | ![]() |
SMO3AUFSD | SMO3KAUFS | CHAR | 2 | 0 | Customer order block (sales area) | ||
11 | ![]() |
SMO3KALKS | SMO3KALKS | CHAR | 1 | 0 | Pricing procedure assigned to this customer | ||
12 | ![]() |
SMO3STGKU | SMO3STGKU | CHAR | 1 | 0 | Customer statistics group | ||
13 | ![]() |
SMO3LOEVM1 | XFELD | CHAR | 1 | 0 | Deletion flag for customer (sales level) | ||
14 | ![]() |
SMO3BZIRK | SMO3BZIRK | CHAR | 6 | 0 | Sales district | ||
15 | ![]() |
SMO3VKBUR | SMO3VKBUR | CHAR | 14 | 0 | Sales office | ||
16 | ![]() |
SMO3VKGRP | SMO3VKGRP | CHAR | 14 | 0 | Sales group | ||
17 | ![]() |
SMO3KDGRP | SMO3KDGRP | CHAR | 2 | 0 | Customer group | ||
18 | ![]() |
SMO3WAERS4 | WAERS | CUKY | 5 | 0 | Currency | * | |
19 | ![]() |
SMO3AWAHR | SMO3AWAHR | NUMC | 3 | 0 | Order probability of the item | ||
20 | ![]() |
SMO3VSORT | SMO3VBELN | CHAR | 10 | 0 | Item proposal | ||
21 | ![]() |
SMO3EIKTO | CHAR12 | CHAR | 12 | 0 | Our account number at the customer or vendor | ||
22 | ![]() |
SMO3KURST | KURST | CHAR | 4 | 0 | Exchange rate type | * | |
23 | ![]() |
SMO3KONDA | SMO3KONDA | CHAR | 2 | 0 | Price group (customer) | ||
24 | ![]() |
SMO3PLTYP | SMO3PLTYP | CHAR | 2 | 0 | Price list type | ||
25 | ![]() |
SMO3LPRIO | SMO3LPRIO | NUMC | 2 | 0 | Delivery priority | ||
26 | ![]() |
SMO3VSBED | SMO3VSBED | CHAR | 2 | 0 | Shipping conditions | ||
27 | ![]() |
SMO3DWERK | SMO3WERKS | CHAR | 4 | 0 | Delivering plant | ||
28 | ![]() |
SMO3KZAZU | XFELD | CHAR | 1 | 0 | Order combination indicator | ||
29 | ![]() |
SMO3CHSPL | XFELD | CHAR | 1 | 0 | Batch split allowed | ||
30 | ![]() |
SMO3AUTLF | XFELD | CHAR | 1 | 0 | Complete delivery defined for each sales order? | ||
31 | ![]() |
SMO3KZTLF | SMO3KZTLF | CHAR | 1 | 0 | Partial delivery at item level | ||
32 | ![]() |
SMO3ANTLF | SMO3ANTLF | DEC | 1 | 0 | Maximum number of partial deliveries allowed per item | ||
33 | ![]() |
SMO3MRNKZ | XFELD | CHAR | 1 | 0 | Manual invoice maintenance | ||
34 | ![]() |
SMO3BOKRE | XFELD | CHAR | 1 | 0 | ID: Customer is to receive rebates | ||
35 | ![]() |
SMO3PRFRE | XFELD | CHAR | 1 | 0 | Relevant for price determination ID | ||
36 | ![]() |
SMO3PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | * | |
37 | ![]() |
SMO3PERRL | WFCID | CHAR | 2 | 0 | Invoice list schedule (calendar identification) | * | |
38 | ![]() |
SMO3INCO1 | SMO3INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | ||
39 | ![]() |
SMO3INCO2 | SMO3INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
40 | ![]() |
SMO3DZTER | SMO3ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
41 | ![]() |
SMO3LIFSD | SMO3LIFSP | CHAR | 2 | 0 | Customer delivery block (sales area) | ||
42 | ![]() |
SMO3FAKSD | SMO3FAKSP | CHAR | 2 | 0 | Billing block for customer (sales and distribution) | ||
43 | ![]() |
SMO3KLABC | SMO3KLABC | CHAR | 2 | 0 | Customer classification (ABC analysis) | ||
44 | ![]() |
SMO3KVGR1 | SMO3KVGR1 | CHAR | 3 | 0 | Customer group 1 | ||
45 | ![]() |
SMO3KVGR2 | SMO3KVGR2 | CHAR | 3 | 0 | Customer group 2 | ||
46 | ![]() |
SMO3KVGR3 | SMO3KVGR3 | CHAR | 3 | 0 | Customer group 3 | ||
47 | ![]() |
SMO3KVGR4 | SMO3KVGR4 | CHAR | 3 | 0 | Customer group 4 | ||
48 | ![]() |
SMO3KVGR5 | SMO3KVGR5 | CHAR | 3 | 0 | Customer group 5 | ||
49 | ![]() |
SMO3KABSS | SMO3KABSS | CHAR | 4 | 0 | Customer payment guarantee procedure | ||
50 | ![]() |
SMO3UEBTO | SMO3PRZ21 | DEC | 3 | 1 | Overdelivery tolerance limit | ||
51 | ![]() |
SMO3UNTTO | SMO3PRZ21 | DEC | 3 | 1 | Underdelivery tolerance limit | ||
52 | ![]() |
SMO3UEBTK | XFELD | CHAR | 1 | 0 | Indicator: Unlimited overdelivery allowed | ||
53 | ![]() |
SMO3ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
54 | ![]() |
SMO3ERNAM | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
55 | ![]() |
SMO_PARTNR | SMO_PARTNR | CHAR | 10 | 0 | ZGP-Partner Number | ||
56 | ![]() |
SMO_RLTYP | SMO_RLTYP | CHAR | 8 | 0 | ZGP Relation Type | ||
57 | ![]() |
SMO_NGUID | SMO_NGUID | DEC | 1 | 0 | Not Guided Record | ||
58 | ![]() |
0 | 0 | Record Modification Fields for Mobile Sales/Service | |||||
59 | ![]() |
SMO_CREATE | SMO_DATE | DATS | 8 | 0 | Date of Creation. | ||
60 | ![]() |
SMO_MODIFY | SMO_DATE | DATS | 8 | 0 | Date last Modified | ||
61 | ![]() |
SMO_BEARB | SMO_BEARB | CHAR | 15 | 0 | Record Edited by User Name | ||
62 | ![]() |
0 | 0 | Communication Fields for Mobile Sales/Service | |||||
63 | ![]() |
SMO_TR_USR | SMO_TR_USR | CHAR | 32 | 0 | Transaction User | ||
64 | ![]() |
SMO_TR_ID | SMO_TR_ID | CHAR | 32 | 0 | Transaction Identifier | ||
65 | ![]() |
SMO_TR_STS | SMO_TR_STS | CHAR | 4 | 0 | Status of Transaction | ||
66 | ![]() |
TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
67 | ![]() |
SMO_DELETD | SMO_DELETD | CHAR | 1 | 0 | Mobile Sales Deleted | ||
68 | ![]() |
SMO_RTGUID | SMO_GUID | CHAR | 32 | 0 | Identifier of BDoc Root object | ||
69 | ![]() |
SMO3BRYTH | SMO3BRYTH | CHAR | 4 | 0 | Call frequency | ||
70 | ![]() |
SMO_GUID | SMO_GUID | CHAR | 32 | 0 | Global Unique Identifier | ||
71 | ![]() |
CRM_ACCTGRPBP | CRM_ACCTGRPBP | CHAR | 2 | 0 | Business Partner Account Assignment Group | * |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in |