SKNA1 SAP (Customer Master table for BC417 Course) Table details

Dictionary Type: Table
Description: Customer Master table for BC417 Course




ABAP Code to SELECT data from SKNA1
Related tables to SKNA1
Access table SKNA1




Table field list including key, data, relationships and ABAP select examples

SKNA1 is a standard SAP Table which is used to store Customer Master table for BC417 Course data and is available within R/3 SAP systems depending on the version and release level.

The SKNA1 table consists of various fields, each holding specific information or linking keys about Customer Master table for BC417 Course data available in SAP. These include KUNNR (Customer Numbers), LAND1 (Country Key), NAME1 (Name 1), NAME2 (Name 2).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP SKNA1 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
PSTLZPostal Code PSTLZCHAR10PSTLZ
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
SORTLSort field SORTLCHAR10CHAR10
STRASHouse number and street STRAS_GPCHAR35TEXT35
TELF1First telephone number TELF1CHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
MCOD1Search term for matchcode search MCDD1CHAR25CHAR25
MCOD2Search Term for Matchcode Search MCDD2CHAR25CHAR25
MCOD3Search term for matchcode search MCDD3CHAR25CHAR25
ANREDTitle ANREDCHAR15TEXT15
AUFSDCentral order block for customer AUFSD_XCHAR2TVASTKAUFS
BAHNEExpress train station BAHNECHAR25BAHNH
BAHNSTrain station BAHNSCHAR25BAHNH
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
BRSCHIndustry key BRSCHCHAR4T016BRSCH
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
DATLTData communication line no. DATLTCHAR14TEXT14
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
EXABLIndicator: Unloading points exist EXABLCHAR1XFELD
FAKSDCentral billing block for customer FAKSD_XCHAR2TVFSFAKSP
FISKNAccount number of the master record with the fiscal address FISKN_DCHAR10KNA1ALPHAKUNNR
KNAZKWorking Time Calendar KNAZKCHAR2TFACDWFCID
KNRZAAccount number of an alternative payer KNRZACHAR10KNA1ALPHAKUNNR
KONZSGroup key KONZSCHAR10KONZS
KTOKDCustomer Account Group KTOKDCHAR4T077DKTOKDKGD
KUKLACustomer classification KUKLACHAR2TKUKLKUKLA
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
LIFSDCentral delivery block for the customer LIFSD_XCHAR2TVLSLIFSP
LOCCOCity Coordinates LOCCOCHAR10LOCCO
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
NIELSNielsen ID NIELSCHAR2TNLSNIELS
ORT02District ORT02_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
COUNCCounty Code COUNCCHAR3T005ECOUNC
CITYCCity Code CITYCCHAR4T005GCITYC
RPMKRRegional Market RPMKRCHAR5RPMKR
SPERRCentral posting block SPERB_XCHAR1XFELD
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
TELBXTelebox number TELBXCHAR15TEXT15
TELF2Second telephone number TELF2CHAR16TEXT16
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
LZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
XZEMPIndicator: Is an alternative payer allowed in document? XREGUCHAR1XFELD
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
STCEGVAT Registration Number STCEGCHAR20STCEG
DEAR1Indicator: Competitor DEAR1CHAR1XFELD
DEAR2Indicator: Sales partner DEAR2CHAR1XFELD
DEAR3Indicator: Sales prospect DEAR3CHAR1DEAR3
DEAR4Indicator for customer type 4 DEAR4CHAR1XFELD
DEAR5ID for default sold-to party DEAR5CHAR1XFELD
GFORMLegal status GFORMCHAR2TVGFGFORM
BRAN1Industry Code 1 BRAN1_DCHAR10TBRCBRACO
BRAN2Industry code 2 BRAN2CHAR10TBRCBRACO
BRAN3Industry code 3 BRAN3CHAR10TBRCBRACO
BRAN4Industry code 4 BRAN4CHAR10TBRCBRACO
BRAN5Industry code 5 BRAN5CHAR10TBRCBRACO
EKONTInitial contact EKONTCHAR10VBUKALPHAVBELN
UMSATAnnual sales UMSATCURR8(2) UMSAT
UMJAHYear For Which Sales are Given UMJAHNUMC4JAHR
UWAERCurrency of sales figure UWAERCUKY5TCURCWAERS
JMZAHYearly number of employees JMZAHNUMC6JMZAH
JMJAHYear for which the number of employees is given JMJAHNUMC4JAHR
KATR1Attribute 1 KATR1CHAR2TVK1ATTR1
KATR2Attribute - 2 KATR2CHAR2TVK2ATTR2
KATR3Attribute 3 KATR3CHAR2TVK3ATTR3
KATR4Attribute 4 KATR4CHAR2TVK4ATTR4
KATR5Attribute 5 KATR5CHAR2TVK5ATTR5
KATR6Attribute 6 KATR6CHAR3TVK6ATTR6
KATR7Attribute 7 KATR7CHAR3TVK7ATTR7
KATR8Attribute 8 KATR8CHAR3TVK8ATTR8
KATR9Attribute 9 KATR9CHAR3TVK9ATTR9
KATR10Attribute 10 KATR10CHAR3TVK0ATTR10
STKZNNatural Person STKZNCHAR1STKZN
UMSA1Annual sales UMSA1CURR15(2) UMSA1
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
ABRVWUsage Indicator ABRVWCHAR3TVLVABRVW
INSPBYDEBIInspection Carried Out By Customer (No Inspection Lot) QINSPBYDEBCHAR1QKZ
INSPATDEBIInspection for a Delivery Note After Outbound Delivery QINSPATDEBCHAR1QKZ
KTOCDReference Account Group for One-Time Account (Customer) KTOCDCHAR4T077DKTOKD
PFORTPO Box city PFORT_GPCHAR35TEXT35
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
HZUORAssignment to Hierarchy HZUORNUMC2HZUOR
SPERZPayment Block SPERZCHAR1XFELD
ETIKGIS-R Labeling: customer/plant group ETIKGCHAR10TWEKETIKG
CIVVEID for mainly non-military use CIVVECHAR1XFELD
MILVEID for mainly military use MILVECHAR1XFELD
KDKG1Customer condition group 1 KDKG1CHAR2TVKGGKDKGR
KDKG2Customer condition group 2 KDKG2CHAR2TVKGGKDKGR
KDKG3Customer condition group 3 KDKG3CHAR2TVKGGKDKGR
KDKG4Customer condition group 4 KDKG4CHAR2TVKGGKDKGR
KDKG5Customer condition group 5 KDKG5CHAR2TVKGGKDKGR
XKNZAIndicator: Alternative payer using account number XKNZACHAR1XFELD
FITYPTax type J_1AFITP_DCHAR2J_1AFITPJ_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2J_1ATODCJ_1ATOID
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
STCD5Tax Number 5 STCD5CHAR60CHAR60
XICMSCustomer is ICMS-exempt J_1BTCICMSCHAR1XFELD
XXIPICustomer is IPI-exempt J_1BTCIPICHAR1XFELD
XSUBTCustomer group for Substituiçao Tributária calculation J_1BTCSTCHAR3J_1BTXSTGJ_1BTCST1
CFOPCCustomer's CFOP category J_1BINDUS1CHAR2ALPHAJ_1BINDUS1
TXLW1Tax law: ICMS J_1BTAXLW1CHAR3J_1BATL1ALPHAJ_1BTAXLW1
TXLW2Tax law: IPI J_1BTAXLW2CHAR3J_1BATL2ALPHAJ_1BTAXLW2
CCC01Indicator for biochemical warfare for legal control CCC01CHAR1XFELD
CCC02Indicator for nuclear nonproliferation for legal control CCC02CHAR1XFELD
CCC03Indicator for national security for legal control CCC03CHAR1XFELD
CCC04Indicator for missile technology for legal control CCC04CHAR1XFELD
CASSDCentral sales block for customer CASSD_XCHAR2CASSP
KNURLUniform Resource Locator URLCHAR132TEXT132
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30BUSTYPEGESTYP
J_1KFTINDType of Industry INDTYPCHAR30INDUSTYPEINDTYP
CONFSStatus of Change Authorization (Central) CONFS_XCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELCentral deletion block for master record NODEL_XCHAR1XFELD
DEAR6Indicator: Consumer DEAR6CHAR1XFELD
SUFRAMASuframa Code J_1BSUFRAMACHAR9J_1BSUFRAMA
RGRG Number J_1BRGCHAR11J_1BRG
EXPIssued by J_1BEXPCHAR3J_1BEXP
UFState J_1BUFCHAR2J_1BUF
RGDATERG Issue Date J_1BRGDATEDATS8DATUM
RICRIC Number J_1BRICNUMC11J_1BRIC
RNEForeign National Registration J_1BRNECHAR10J_1BRNE
RNEDATERNE Issue Date J_1BRNEDATEDATS8DATUM
CNAECNAE J_1BCNAECHAR7J_1BTCNAEJ_1BCNAE
LEGALNATLegal Nature J_1BLEGALNATNUMC4J_1BTLEGALNATJ_1BLEGALNAT
CRTNCRT Number J_1BCRTNCHAR1J_1BCRTN
ICMSTAXPAYICMS Taxpayer J_1BICMSTAXPAYCHAR2J_1BTICMSTAXPAYJ_1BICMSTAXPAY
INDTYPIndustry Main Type J_1BINDTYPCHAR2J_1BTINDTYPJ_1BINDTYP
TDTTax Declaration Type J_1BTDTCHAR2J_1BTTDTJ_1BTDT
COMSIZECompany Size J_1BCOMSIZECHAR2J_1BTCOMSIZEJ_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINS J_1BDECREGPCCHAR2J_1BTDECREGPCJ_1BDECREGPC

Key field Non-key field



How do I retrieve data from SAP table SKNA1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on SKNA1 to SELECT all data from the table
DATA: WA_SKNA1 TYPE SKNA1.

SELECT SINGLE *
FROM SKNA1
INTO CORRESPONDING FIELDS OF WA_SKNA1
WHERE...

How to access SAP table SKNA1

Within an ECC or HANA version of SAP you can also view further information about SKNA1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!