SMOKNA1 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of SMOKNA1 in SAP.
- Table description : General Data in Customer Master
- Module : CRM-MSA
- Parent Module : CRM
- Package : SMO3
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SMOKNA1 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SFAKNA1 | SFA Key of Business Partner | SMO_SFAKN1 | SMO_GUID |
| SFAADRC1 | GUID of Address (standard address/business address) | SMO_SFADC1 | SMO_GUID |
| SFAADRC2 | GUID of Address (private) | SMO_SFARC2 | SMO_GUID |
| SFAROLE | SFA Key of Role | SMO_SFAROLE | SMO_GUID |
| KUNNR | Customer number | SMO3KUNNR | SMO3KUNNR |
| KTOKD | Customer account group | SMO3KTOKD | SMO3KTOKD |
| SOURCE | Source of an object | SMO_SOURCE | SMO_SOURCE |
| KNURL | Uniform resource locator | SMO3URL | TEXT132 |
| KVORIGIN | Origin of Data (choice list) | SMO_ORIGCH | SMO_TXT4 |
| ADDRNUMBER | Address number | AD_ADDRNUM | AD_ADDRNUM |
| SORTL | Sort field | SMO3SORTL | CHAR10 |
| ANRED | Title | ANRED | TEXT15 |
| TITLE | Form-of-Address Key | AD_TITLE | AD_TITLE |
| TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | AD_TITLES |
| NAME1 | Name 1 | AD_NAME1 | TEXT40 |
| NAME2 | Name 2 | AD_NAME2 | TEXT40 |
| NAME3 | Name 3 | AD_NAME3 | TEXT40 |
| NAME4 | Name 4 | AD_NAME4 | TEXT40 |
| BBBNR | International location number (part 1) | SMO3BBBNR | NUM07 |
| BBSNR | International location number (part 2) | SMO3BBSNR | NUM05 |
| BUBKZ | Check digit for the international location number | SMO3BUBKZ | NUM01 |
| BRSCH | Industry key | SMO3BRSCH | SMO3BRSCH |
| NIELS | Nielsen indicator | SMO3NIELS | SMO3NIELS |
| KUKLA | Customer classification | SMO3KUKLA | SMO3KUKLA |
| UMSA1 | Amount in local currency | SMO_DMBTR | |
| UMJAH | Year for which sales are given | SMO3UMJAH | SMO3JAHR |
| UWAER | Currency of sales figure | SMO3UWAER | WAERS |
| JMZAH | Number of employees for the year | SMO3JMZAH | SMO3JMZAH |
| JMJAH | Year for which the number of employees is given | SMO3JMJAH | SMO3JAHR |
| AUFSD | Central order block for customer | SMO3AUFSD1 | SMO3KAUFS |
| FAKSD | Central billing block for customer | SMO3FAKSD1 | SMO3FAKSP |
| LIFSD | Central delivery block for the customer | SMO3LIFSD1 | SMO3LIFSP |
| LOEVM | Central deletion flag for master record | SMO3LOEVM2 | XFELD |
| SPERZ | Payment block | SMO3SPERZ | XFELD |
| SPERR | Central posting block | SMO3SPERB | XFELD |
| GFORM | Legal status | SMO3GFORM | SMO3GFORM |
| KEYACC | Business Partner is Key Account (T/F) | SMO_KEYACC | SMO_LOGICL |
| BRAN1 | Industry code 1 | SMO3BRAN1 | SMO3BRACO |
| BRAN2 | Industry code 2 | SMO3BRAN2 | SMO3BRACO |
| BRAN3 | Industry code 3 | SMO3BRAN3 | SMO3BRACO |
| BRAN4 | Industry code 4 | SMO3BRAN4 | SMO3BRACO |
| BRAN5 | Industry code 5 | SMO3BRAN5 | SMO3BRACO |
| KATR1 | Attribute 1 | SMO3KATR1 | SMO3ATTR1 |
| KATR2 | Attribute 2 | SMO3KATR2 | SMO3ATTR2 |
| KATR3 | Attribute 3 | SMO3KATR3 | SMO3ATTR3 |
| KATR4 | Attribute 4 | SMO3KATR4 | SMO3ATTR4 |
| KATR5 | Attribute 5 | SMO3KATR5 | SMO3ATTR5 |
| KATR6 | Attribute 6 | SMO3KATR6 | SMO3ATTR6 |
| KATR7 | Attribute 7 | SMO3KATR7 | SMO3ATTR7 |
| KATR8 | Attribute 8 | SMO3KATR8 | SMO3ATTR8 |
| KATR9 | Attribute 9 | SMO3KATR9 | SMO3ATTR9 |
| KATR10 | Attribute 10 | SMO3KATR11 | SMO3ATTR11 |
| WERKS | Plant | SMO3WERKS | SMO3WERKS |
| KVTGRP | Target Group | SMO_TGTGRP | SMO_TXT2 |
| KVREF | Reference Customer (T/F) | SMO_KVREF | SMO_LOGICL |
| KVASSO | Member of Association | SMO_KVASSO | SMO_TXT3 |
| KVFOUNDED | Company founded on | SMO_FOUNDD | SMO_DATE |
| KVCGROUP | Organization Group | SMO_CGRP | SMO_TXT4 |
| KVCSGROUP | Organization Sub-Group | SMO_CSGRP | SMO_TXT4 |
| KVOUTYP | Outlet Type | SMO_OUTYP | SMO_TXT4 |
| KVWHOLE | Wholesaler (T/F) | SMO_WHOLE | SMO_LOGICL |
| KVMARKT | Market of Partner | SMO_MARKET | SMO_TXT4 |
| PARTNER | ZGP-Partner Number | SMO_PARTNR | SMO_PARTNR |
| RLTYP | ZGP Relation Type | SMO_RLTYP | SMO_RLTYP |
| PERSNUMBER | Person number | AD_PERSNUM | AD_PERSNUM |
| KUNN2 | Customer number | SMO3KUNNR | SMO3KUNNR |
| SOURCE_C | Source of an object | SMO_SOURCE | SMO_SOURCE |
| SFAKNA2 | GUID of Organization (a Contact Person is assigned to) | SMO_CGUID | SMO_GUID |
| ABTPA | Contact person's department at customer | SMO3ABTEI1 | ABTEI |
| KVDEPART | Department of Person (free text) | SMO_DEPART | SMO_DEPART |
| ABTNR | Contact person department | SMO3ABTNR1 | SMO3ABTNR |
| SORT1 | Search Term 1 | AD_SORT1 | CHAR20 |
| SORT2 | Search Term 2 | AD_SORT2 | CHAR20 |
| PAFKT | Contact person function | SMO3PAFKT | SMO3PAFKT |
| KVPAFKT | Person's Function (free text) | SMO_KVPAFK | SMO_DEPART |
| PARVO | Partner's power of attorney | SMO3PARVO | SMO3PARVO |
| PAVIP | VIP Partner | SMO3PAVIP | SMO3PAVIP |
| SEX | Gender key | AD_SEX | AD_SEX |
| LANGU | Language | SMO_LANGU | SMO_LANGU |
| TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | AD_TITLE1 |
| KVTITLE | Titel of Person (free text) | SMO_KVTITL | SMO_TXT50 |
| GBDAT | Date of birth | SMO3GBDAT | SMO3GBDAT |
| GBDAY | Day of birth, if complete date+year is not known | SMO_GBDAY | SMO_TXT2 |
| GBMON | Month of birth, if complete date is not known | SMO_GBMON | SMO_TXT2 |
| GBYEAR | Year of birth if day/month are not known | SMO_GBYEA | SMO_TXT4 |
| VRTNR | Representative number | SMO3VTRNR | SMO3VTRNR |
| BRYTH | Call frequency | SMO3BRYTH | SMO3BRYTH |
| KVLETSAL | Letter Salutation | SMO_LETSAL | SMO_TXT40 |
| AKVER | Buying habits | SMO3AKVER | SMO3AKVER |
| FAMST | Marital status key | SMO3FAMST | SMO3FAMST |
| PERSORIGIN | Personal data source (key) | AD_ORIGINP | AD_ORIGIN |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATUM |
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATUM |
| NATION | Version ID for International Addresses | AD_NATION | AD_NATION |
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | AD_PREFIX |
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | AD_PREFIX |
| ADRNP | Home address | SMO3ADRNP | ADRNR |
| ADRND | Business address | SMO3ADRND | ADRNR |
| NICKNAME | Nickname or name used | AD_NICKNAM | TEXT40 |
| INITIALS | "Middle Initial" or personal initials | AD_INITS | CHAR10 |
| PROFESSION | Profession | AD_PROFESS | TEXT40 |
| PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | AD_GROUP_P |
| KVPGROUP | Person Group | SMO_PGRP | SMO_TXT4 |
| KVPSGROUP | Person Sub-Group | SMO_PSGRP | SMO_TXT4 |
| KVMAINC | Main (Flag, T/F) | SMO_MAINFL | SMO_LOGICL |
| KVCPPOS | Position (established post) | SMO_POSITN | SMO_TXT40 |
| KVMOBILE | Mobile Telephone | SMO_MOBILT | SMO_MOBILT |
| BPACT | Status of Business Partner | SMO3BPACT | SMO3BPACT |
| KTOKD_CHG | Account Group Change Indicator | SMO_KTCHNG | SMO_LOGICL |
| LOGSYS | Logical system | LOGSYS | LOGSYS |
| NON_GUID | Not Guided Record | SMO_NGUID | SMO_NGUID |
| .INCLUDE | Communication Fields for Mobile Sales/Service | ||
| TR_USER | Transaction User | SMO_TR_USR | SMO_TR_USR |
| TR_ID | Transaction Identifier | SMO_TR_ID | SMO_TR_ID |
| TR_STATUS | Status of Transaction | SMO_TR_STS | SMO_TR_STS |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS |
| DELETED | Mobile Sales Deleted | SMO_DELETD | SMO_DELETD |
| TR_ROOTID | Identifier of BDoc Root object | SMO_RTGUID | SMO_GUID |
| STCD3 | Tax Number 3 | STCD3 | CHAR18 |
| STCD4 | Tax Number 4 | STCD4 | CHAR18 |
| ARCFL | Flag for Archiving of BP/Con | SMO3ARCIV | XFELD |
| BPISCOMP | Indicator: Business partner is competitor | SMO3BPCOMP | XFELD |
| BPISCUST | Indicator: Business partner is customer | SMO3BPCUST | XFELD |
| BPISPROS | Indicator: Business partner is a prospect | SMO3BPPROS | XFELD |
| BPISCONS | Indicator: Business partner is consumer | SMO3BPCONS | XFELD |
| BPISCODC | Indicator: Business partner is cash on delivery customer | SMO3BPCODC | XFELD |
| SFAKNA1SHT | Global Unique Identifier | SMO_GUID | SMO_GUID |
| XBLCK | Central Block for Business Partner | BU_XBLCK | XFELD |
| CONTACT | Business Partner: Contact Permission | BU_CONTACT | BU_CONTACT |
| N_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | XFELD |
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | AD_TITLE1 |
| NBRCK | Brick Codes | SMOBRCKCOD | SMO_BRCKCD |
| BUS_TYPE_KR | Business Transaction Type (Korea) | CDBT_GESTYP_KR | CHAR30 |
| IND_TYPE_KR | Industry Type (Korea) | CDBT_INDTYP_KR | CHAR30 |
| REP_NAME_KR | Substitute Name (Korea) | CDBT_REPRES_KR | CHAR10 |
| BU_GROUP | Business Partner Grouping | SMOBUGROUP | BU_GROUP |
| PAFKT1 | Function of partner | BU_PAFKT | BU_PAFKT |
| CONISOEMP | Indicator: Person is only employee | CONISOEMP | XFELD |
| BPISVEND | Indicator: BP is vendor | BPISVEND | XFELD |
SMOKNA1 related tables
| Table | Note |
|---|---|
| KNA1 | General Data in Customer Master |
| SMOKNA1 | General Data in Customer Master |
| /SLOAP/KNA1 | General Data in Customer Master |
| KNAS | Customer master (VAT registration numbers general section) |
| /SLOAS/KNA1 | Customer Master Record (General Part) |
| JGTBP00 | IS-M: Business Partner Master Data (General Data) |
| J_7LV01 | REA Packaging Master Data: General Data |
| PSO48 | Customer Assignment of BUSAB to Customer Master Record |
| TVKGG | Customer Condition Groups (Customer Master) |
| TVKGGT | Texts for Customer Condition Groups (Customer Master) |
| DFKKORDERASSIGN | Assignment of ORDNR for General Requests (General Object) |
| AFWBM_ATT_BM | TRM: Key Table for Benchmark Master Data(General Attributes) |
| BKK40 | Current Account Master Data: General |
| BP000 | Business Partner Master (General Data) |
| CPED_COVERAGE | Coverage - General Master Data |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP