/SLOAP/KNA1 is a SAP table coming under CA module and DMIS component.View details, Fields & related tables of /SLOAP/KNA1 in SAP.
- Table description : General Data in Customer Master
- Module : CA-EUR
- Parent Module : CA
- Package : /SLOAP/APPLICATION
- Software Component : DMIS
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 /SLOAP/KNA1 Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
KUNNR | Customer Number | KUNNR | KUNNR |
LAND1 | Country Key | LAND1_GP | LAND1 |
NAME1 | Name 1 | NAME1_GP | NAME |
NAME2 | Name 2 | NAME2_GP | NAME |
ORT01 | City | ORT01_GP | TEXT35 |
PSTLZ | Postal Code | PSTLZ | PSTLZ |
REGIO | Region (State, Province, County) | REGIO | REGIO |
SORTL | Sort field | SORTL | CHAR10 |
STRAS | House number and street | STRAS_GP | TEXT35 |
TELF1 | First telephone number | TELF1 | TEXT16 |
TELFX | Fax Number | TELFX | TEXT31 |
XCPDK | Indicator: Is the account a one-time account? | XCPDK | XFELD |
ADRNR | Address | ADRNR | ADRNR |
MCOD1 | Search term for matchcode search | MCDD1 | CHAR25 |
MCOD2 | Search Term for Matchcode Search | MCDD2 | CHAR25 |
MCOD3 | Search term for matchcode search | MCDD3 | CHAR25 |
.INCLUDE | General Data in Customer Master | ||
ANRED | Title | ANRED | TEXT15 |
AUFSD | Central order block for customer | AUFSD_X | KAUFS |
BAHNE | Express train station | BAHNE | BAHNH |
BAHNS | Train station | BAHNS | BAHNH |
BBBNR | International location number (part 1) | BBBNR | NUM07 |
BBSNR | International location number (Part 2) | BBSNR | NUM05 |
BEGRU | Authorization Group | BRGRU | BRGRU |
BRSCH | Industry key | BRSCH | BRSCH |
BUBKZ | Check digit for the international location number | BUBKZ | NUM01 |
DATLT | Data communication line no. | DATLT | TEXT14 |
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATUM |
ERNAM | Name of Person who Created the Object | ERNAM_RF | USNAM |
EXABL | Indicator: Unloading points exist | EXABL | XFELD |
FAKSD | Central billing block for customer | FAKSD_X | FAKSP |
FISKN | Account number of the master record with the fiscal address | FISKN_D | KUNNR |
KNAZK | Working Time Calendar | KNAZK | WFCID |
KNRZA | Account number of an alternative payer | KNRZA | KUNNR |
KONZS | Group key | KONZS | KONZS |
KTOKD | Customer Account Group | KTOKD | KTOKD |
KUKLA | Customer classification | KUKLA | KUKLA |
LIFNR | Account Number of Vendor or Creditor | LIFNR | LIFNR |
LIFSD | Central delivery block for the customer | LIFSD_X | LIFSP |
LOCCO | City Coordinates | LOCCO | LOCCO |
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | XFELD |
NAME3 | Name 3 | NAME3_GP | NAME |
NAME4 | Name 4 | NAME4_GP | NAME |
NIELS | Nielsen ID | NIELS | NIELS |
ORT02 | District | ORT02_GP | TEXT35 |
PFACH | PO Box | PFACH | PFACH |
PSTL2 | P.O. Box Postal Code | PSTL2 | PSTLZ |
COUNC | County Code | COUNC | COUNC |
CITYC | City Code | CITYC | CITYC |
RPMKR | Regional market | RPMKR | RPMKR |
SPERR | Central posting block | SPERB_X | XFELD |
SPRAS | Language Key | SPRAS | SPRAS |
STCD1 | Tax Number 1 | STCD1 | STCD1 |
STCD2 | Tax Number 2 | STCD2 | STCD2 |
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | STKZA |
STKZU | Liable for VAT | STKZU | XFELD |
TELBX | Telebox number | TELBX | TEXT15 |
TELF2 | Second telephone number | TELF2 | TEXT16 |
TELTX | Teletex number | TELTX | TEXT30 |
TELX1 | Telex number | TELX1 | TEXT30 |
LZONE | Transportation zone to or from which the goods are delivered | LZONE | ZONE |
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | XFELD |
VBUND | Company ID of trading partner | RASSC | RCOMP |
STCEG | VAT Registration Number | STCEG | STCEG |
DEAR1 | Indicator: Competitor | DEAR1 | XFELD |
DEAR2 | Indicator: Sales partner | DEAR2 | XFELD |
DEAR3 | Indicator: Sales prospect | DEAR3 | DEAR3 |
DEAR4 | Indicator for customer type 4 | DEAR4 | XFELD |
DEAR5 | ID for default sold-to party | DEAR5 | XFELD |
GFORM | Legal status | GFORM | GFORM |
BRAN1 | Industry code 1 | BRAN1_D | BRACO |
BRAN2 | Industry code 2 | BRAN2 | BRACO |
BRAN3 | Industry code 3 | BRAN3 | BRACO |
BRAN4 | Industry code 4 | BRAN4 | BRACO |
BRAN5 | Industry code 5 | BRAN5 | BRACO |
EKONT | Initial contact | EKONT | VBELN |
UMSAT | Annual sales | UMSAT | UMSAT |
UMJAH | Year For Which Sales are Given | UMJAH | JAHR |
UWAER | Currency of Sales Volume | UWAER | WAERS |
JMZAH | Yearly number of employees | JMZAH | JMZAH |
JMJAH | Year for which the number of employees is given | JMJAH | JAHR |
KATR1 | Attribute 1 | KATR1 | ATTR1 |
KATR2 | Attribute 2 | KATR2 | ATTR2 |
KATR3 | Attribute 3 | KATR3 | ATTR3 |
KATR4 | Attribute 4 | KATR4 | ATTR4 |
KATR5 | Attribute 5 | KATR5 | ATTR5 |
KATR6 | Attribute 6 | KATR6 | ATTR6 |
KATR7 | Attribute 7 | KATR7 | ATTR7 |
KATR8 | Attribute 8 | KATR8 | ATTR8 |
KATR9 | Attribute 9 | KATR9 | ATTR9 |
KATR10 | Attribute 10 | KATR10 | ATTR10 |
STKZN | Natural Person | STKZN | STKZN |
UMSA1 | Annual sales | UMSA1 | UMSA1 |
TXJCD | Tax Jurisdiction | TXJCD | TXJCD |
PERIV | Fiscal Year Variant | PERIV | PERIV |
ABRVW | Usage Indicator | ABRVW | ABRVW |
INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | QINSPBYDEB | QKZ |
INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | QINSPATDEB | QKZ |
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | KTOKD |
PFORT | PO Box city | PFORT_GP | TEXT35 |
WERKS | Plant | WERKS_D | WERKS |
DTAMS | Report key for data medium exchange | DTAMS | DTAMS |
DTAWS | Instruction key for data medium exchange | DTAWS | DTAWS |
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | DUEFL_BKPF |
HZUOR | Assignment to Hierarchy | HZUOR | HZUOR |
SPERZ | Payment Block | SPERZ | XFELD |
ETIKG | IS-R Labeling: customer/plant group | ETIKG | ETIKG |
CIVVE | ID for mainly non-military use | CIVVE | XFELD |
MILVE | ID for mainly military use | MILVE | XFELD |
KDKG1 | Customer condition group 1 | KDKG1 | KDKGR |
KDKG2 | Customer condition group 2 | KDKG2 | KDKGR |
KDKG3 | Customer condition group 3 | KDKG3 | KDKGR |
KDKG4 | Customer condition group 4 | KDKG4 | KDKGR |
KDKG5 | Customer condition group 5 | KDKG5 | KDKGR |
XKNZA | Indicator: Alternative payer using account number | XKNZA | XFELD |
FITYP | Tax type | J_1AFITP_D | J_1AFITP |
STCDT | Tax Number Type | J_1ATOID | J_1ATOID |
STCD3 | Tax Number 3 | STCD3 | CHAR18 |
STCD4 | Tax Number 4 | STCD4 | CHAR18 |
STCD5 | Tax Number 5 | STCD5 | CHAR60 |
XICMS | Customer is ICMS-exempt | J_1BTCICMS | XFELD |
XXIPI | Customer is IPI-exempt | J_1BTCIPI | XFELD |
XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | J_1BTCST1 |
CFOPC | Customer's CFOP category | J_1BINDUS1 | J_1BINDUS1 |
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | J_1BTAXLW1 |
TXLW2 | Tax law: IPI | J_1BTAXLW2 | J_1BTAXLW2 |
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | XFELD |
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | XFELD |
CCC03 | Indicator for national security for legal control | CCC03 | XFELD |
CCC04 | Indicator for missile technology for legal control | CCC04 | XFELD |
CASSD | Central sales block for customer | CASSD_X | CASSP |
KNURL | Uniform resource locator | URL | TEXT132 |
J_1KFREPRE | Name of Representative | REPRES | REPRES |
J_1KFTBUS | Type of Business | GESTYP | GESTYP |
J_1KFTIND | Type of Industry | INDTYP | INDTYP |
CONFS | Status of Change Authorization (Central) | CONFS_X | CHAR1 |
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATUM |
UPTIM | Time of Last Change Confirmation | UPTIM_RF | AS4TIME |
NODEL | Central deletion block for master record | NODEL_X | XFELD |
DEAR6 | Indicator: Consumer | DEAR6 | XFELD |
.INCLUDE | Customer Master Data - Brazil | ||
SUFRAMA | Suframa Code | J_1BSUFRAMA | J_1BSUFRAMA |
RG | RG Number | J_1BRG | J_1BRG |
EXP | Issued by | J_1BEXP | J_1BEXP |
UF | State | J_1BUF | J_1BUF |
RGDATE | RG Issue Date | J_1BRGDATE | DATUM |
RIC | RIC Number | J_1BRIC | J_1BRIC |
RNE | Foreign National Registration | J_1BRNE | J_1BRNE |
RNEDATE | RNE Issue Date | J_1BRNEDATE | DATUM |
CNAE | CNAE | J_1BCNAE | J_1BCNAE |
LEGALNAT | Legal Nature | J_1BLEGALNAT | J_1BLEGALNAT |
CRTN | CRT Number | J_1BCRTN | J_1BCRTN |
ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | J_1BICMSTAXPAY |
INDTYP | Industry Main Type | J_1BINDTYP | J_1BINDTYP |
TDT | Tax Declaration Type | J_1BTDT | J_1BTDT |
COMSIZE | Company Size | J_1BCOMSIZE | J_1BCOMSIZE |
DECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC | J_1BDECREGPC |
.INCLU--AP | Append to KNA1 for Vehicle Space Optimization | ||
.INCLUDE | Additional Data for Vehicle Space Optimization for KNA1 | ||
/VSO/R_PALHGT | Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | MENG13 |
/VSO/R_PAL_UL | Unit of Length for Packaging Material (VSO) | /VSO/R_PAL_UNIT_L | MEINS |
/VSO/R_PK_MAT | Customer-Related Packing for Each Packaging Material (VSO) | /VSO/M_PACK_BY_MAT | /VSO/M_XFIELD |
/VSO/R_MATPAL | Packaging Material of the Customer in VSO | /VSO/M_MATNR_PAL | MATNR |
/VSO/R_I_NO_LYR | Number Layers Under an Inter-Pallet (VSO) | /VSO/M_IPAL_NO_LYR | /VSO/M_IPAL_NO_LYR |
/VSO/R_ONE_MAT | Packing Material-Specific for Each Packaging Material | /VSO/M_ONE_MAT | /VSO/M_XFIELD |
/VSO/R_ONE_SORT | Pack Only One Package Type for Each PKM (VSO) | /VSO/M_ONE_SORT | /VSO/M_XFIELD |
/VSO/R_ULD_SIDE | Side Preference of Loading/Unloading (VSO) | /VSO/M_UNLOAD_SIDE_PREF | /VSO/M_SIDE_PREF |
/VSO/R_LOAD_PREF | Front/Back Preference of Loading/Unloading (VSO) | /VSO/M_LOAD_PREF | /VSO/M_LOAD_PREF |
/VSO/R_DPOINT | Collective Unloading Point for VSO | /VSO/R_DELIVERYPOINT | /VSO/R_DELIVERYPOINT |
.INCLU--AP | US Federal Government Customer Master Data Additional Fields | ||
ALC | Agency Location Code | FMFG_ALC | FMFG_ALC |
PMT_OFFICE | Payment Office | FMFG_PMT_OFF | FMFG_PMT_OFF |
.INCLUDE | |||
.INCLU--AP | Local Authority Additional Fields | ||
PSOFG | Processor group | PSOFG | PSOFG |
PSOIS | Subledger acct preprocessing procedure | PSOIS | CHAR20 |
.INCLUDE | Local Authority Additional Fields (Address) | ||
PSON1 | Name 1 | NAME1_GP | NAME |
PSON2 | Name 2 | NAME2_GP | NAME |
PSON3 | Name 3 | NAME3_GP | NAME |
PSOVN | First Name | PSOVN | NAME |
PSOTL | Title | PSOTL | FMPSOTL |
PSOHS | House number: is no longer used from Release 4.6B | PSOHS | CHAR06 |
PSOST | Street: No longer used from Release 4.6B | PSOST | PSOST |
.INCLUDE | Description (Customer/Vendor Supplement) | ||
PSOO1 | Description | PSOO1 | TEXT50 |
PSOO2 | Description | PSOO1 | TEXT50 |
PSOO3 | Description | PSOO1 | TEXT50 |
PSOO4 | Description | PSOO1 | TEXT50 |
PSOO5 | Description | PSOO1 | TEXT50 |
/SLOAP/KNA1 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