SAP TABLES | Logistics - General | Logistics Basic Data | Customer Master(LO-MD-BP-CM) SAP LO

KNA1 SAP General Data in Customer Master Table and data







KNA1 is a standard SAP Table which is used to store General Data in Customer Master data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP KNA1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP KNA1 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
KUNNRKUNNRCHAR10 Customer NumberALPHA
LAND1LAND1_GPCHAR3 T005Country Key
NAME1NAME1_GPCHAR35 Name 1
NAME2NAME2_GPCHAR35 Name 2
ORT01ORT01_GPCHAR35 City
PSTLZPSTLZCHAR10 Postal Code
SORTLSORTLCHAR10 Sort field
STRASSTRAS_GPCHAR35 House number and street
TELF1TELF1CHAR16 First telephone number
TELFXTELFXCHAR31 Fax Number
XCPDKXCPDKCHAR1 Indicator: Is the account a one-time account?
ADRNRADRNRCHAR10
*
AddressALPHA
MCOD1MCDD1CHAR25 Search term for matchcode search
MCOD2MCDD2CHAR25 Search Term for Matchcode Search
MCOD3MCDD3CHAR25 Search term for matchcode search
.INCLUDESI_KNA1 General Data in Customer Master
ANREDANREDCHAR15 Title
AUFSDAUFSD_XCHAR2 TVASTCentral order block for customer
BAHNEBAHNECHAR25 Express train station
BAHNSBAHNSCHAR25 Train station
BBBNRBBBNRNUMC7 International location number (part 1)
BBSNRBBSNRNUMC5 International location number (Part 2)
BEGRUBRGRUCHAR4
*
Authorization Group
BRSCHBRSCHCHAR4 T016Industry key
BUBKZBUBKZNUMC1 Check digit for the international location number
DATLTDATLTCHAR14 Data communication line no.
ERDATERDAT_RFDATS8 Date on which the Record Was Created
ERNAMERNAM_RFCHAR12 Name of Person who Created the Object
EXABLEXABLCHAR1 Indicator: Unloading points exist
FAKSDFAKSD_XCHAR2 TVFSCentral billing block for customer
FISKNFISKN_DCHAR10 KNA1Account number of the master record with the fiscal addressALPHA
KNAZKKNAZKCHAR2 TFACDWorking Time Calendar
KNRZAKNRZACHAR10 KNA1Account number of an alternative payerALPHA
KONZSKONZSCHAR10 Group key
KTOKDKTOKDCHAR4 T077DCustomer Account Group
KUKLAKUKLACHAR2 TKUKLCustomer classification
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
LIFSDLIFSD_XCHAR2 TVLSCentral delivery block for the customer


LOCCOLOCCOCHAR10 City Coordinates
LOEVMLOEVM_XCHAR1 Central Deletion Flag for Master Record
NAME3NAME3_GPCHAR35 Name 3
NAME4NAME4_GPCHAR35 Name 4
NIELSNIELSCHAR2 TNLSNielsen ID
ORT02ORT02_GPCHAR35 District
PFACHPFACHCHAR10 PO Box
PSTL2PSTL2CHAR10 P.O. Box Postal Code
COUNCCOUNCCHAR3 T005ECounty Code
CITYCCITYCCHAR4 T005GCity Code
RPMKRRPMKRCHAR5 Regional Market
SPERRSPERB_XCHAR1 Central posting block
SPRASSPRASLANG1 T002Language KeyISOLA
STCD1STCD1CHAR16 Tax Number 1
STCD2STCD2CHAR11 Tax Number 2
STKZASTKZACHAR1 Indicator: Business Partner Subject to Equalization Tax?
STKZUSTKZUCHAR1 Liable for VAT
TELBXTELBXCHAR15 Telebox number
TELF2TELF2CHAR16 Second telephone number
TELTXTELTXCHAR30 Teletex number
TELX1TELX1CHAR30 Telex number
LZONELZONECHAR10 TZONETransportation zone to or from which the goods are delivered
XZEMPXREGUCHAR1 Indicator: Is an alternative payer allowed in document?
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
STCEGSTCEGCHAR20 VAT Registration Number
DEAR1DEAR1CHAR1 Indicator: Competitor
DEAR2DEAR2CHAR1 Indicator: Sales partner
DEAR3DEAR3CHAR1 Indicator: Sales prospect
DEAR4DEAR4CHAR1 Indicator for customer type 4
DEAR5DEAR5CHAR1 ID for default sold-to party
GFORMGFORMCHAR2 TVGFLegal status
BRAN1BRAN1_DCHAR10 TBRCIndustry Code 1
BRAN2BRAN2CHAR10 TBRCIndustry code 2
BRAN3BRAN3CHAR10 TBRCIndustry code 3
BRAN4BRAN4CHAR10 TBRCIndustry code 4
BRAN5BRAN5CHAR10 TBRCIndustry code 5
EKONTEKONTCHAR10 VBUKInitial contactALPHA
UMSATUMSATCURR8(2) Annual sales
UMJAHUMJAHNUMC4 Year For Which Sales are Given


UWAERUWAERCUKY5 TCURCCurrency of sales figure
JMZAHJMZAHNUMC6 Yearly number of employees
JMJAHJMJAHNUMC4 Year for which the number of employees is given
KATR4KATR4CHAR2 TVK4Attribute 4
KATR5KATR5CHAR2 TVK5Attribute 5
KATR6KATR6CHAR3 TVK6Attribute 6
KATR7KATR7CHAR3 TVK7Attribute 7
KATR8KATR8CHAR3 TVK8Attribute 8
KATR9KATR9CHAR3 TVK9Attribute 9
KATR10KATR10CHAR3 TVK0Attribute 10
STKZNSTKZNCHAR1 Natural Person
UMSA1UMSA1CURR15(2) Annual sales
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
PERIVPERIVCHAR2 T009Fiscal Year Variant
ABRVWABRVWCHAR3 TVLVUsage Indicator
INSPBYDEBIQINSPBYDEBCHAR1 Inspection Carried Out By Customer (No Inspection Lot)
INSPATDEBIQINSPATDEBCHAR1 Inspection for a Delivery Note After Outbound Delivery
KTOCDKTOCDCHAR4 T077DReference Account Group for One-Time Account (Customer)
PFORTPFORT_GPCHAR35 PO Box city
WERKSWERKS_DCHAR4 T001WPlant
DTAMSDTAMSCHAR1 Indicator for Data Medium Exchange
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
DUEFLDUEFL_BKPFCHAR1 Status of Data Transfer into Subsequent Release
HZUORHZUORNUMC2 Assignment to Hierarchy
SPERZSPERZCHAR1 Payment Block
ETIKGETIKGCHAR10 TWEKIS-R Labeling: customer/plant group
CIVVECIVVECHAR1 ID for mainly non-military use
MILVEMILVECHAR1 ID for mainly military use
KDKG1KDKG1CHAR2 TVKGGCustomer condition group 1
KDKG2KDKG2CHAR2 TVKGGCustomer condition group 2
KDKG3KDKG3CHAR2 TVKGGCustomer condition group 3
KDKG4KDKG4CHAR2 TVKGGCustomer condition group 4
KDKG5KDKG5CHAR2 TVKGGCustomer condition group 5
XKNZAXKNZACHAR1 Indicator: Alternative payer using account number
FITYPJ_1AFITP_DCHAR2 J_1AFITPTax type
STCDTJ_1ATOIDCHAR2 J_1ATODCTax Number Type
STCD3STCD3CHAR18 Tax Number 3
STCD4STCD4CHAR18 Tax Number 4
STCD5STCD5CHAR60 Tax Number 5

XICMSJ_1BTCICMSCHAR1 Customer is ICMS-exempt
XXIPIJ_1BTCIPICHAR1 Customer is IPI-exempt
XSUBTJ_1BTCSTCHAR3 J_1BTXSTGCustomer group for Substituiçao Tributária calculation
CFOPCJ_1BINDUS1CHAR2 Customer's CFOP categoryALPHA
TXLW1J_1BTAXLW1CHAR3 J_1BATL1Tax law: ICMSALPHA
TXLW2J_1BTAXLW2CHAR3 J_1BATL2Tax law: IPIALPHA
CCC01CCC01CHAR1 Indicator for biochemical warfare for legal control
CCC02CCC02CHAR1 Indicator for nuclear nonproliferation for legal control
CCC03CCC03CHAR1 Indicator for national security for legal control
CCC04CCC04CHAR1 Indicator for missile technology for legal control
CASSDCASSD_XCHAR2 Central sales block for customer
KNURLURLCHAR132 Uniform Resource Locator
J_1KFREPREREPRESCHAR10 Name of Representative
J_1KFTBUSGESTYPCHAR30 BUSTYPEType of Business
J_1KFTINDINDTYPCHAR30 INDUSTYPEType of Industry
CONFSCONFS_XCHAR1 Status of Change Authorization (Central)
UPDATUPDAT_RFDATS8 Date on Which the Changes Were Confirmed
UPTIMUPTIM_RFTIMS6 Time of Last Change Confirmation
NODELNODEL_XCHAR1 Central deletion block for master record
DEAR6DEAR6CHAR1 Indicator: Consumer
.INCLUDEKNA1BRAZIL Customer Master Data - Brazil
SUFRAMAJ_1BSUFRAMACHAR9 Suframa Code
RGJ_1BRGCHAR11 RG Number
EXPJ_1BEXPCHAR3 Issued by
UFJ_1BUFCHAR2 State
RGDATEJ_1BRGDATEDATS8 RG Issue Date
RICJ_1BRICNUMC11 RIC Number
RNEJ_1BRNECHAR10 Foreign National Registration
RNEDATEJ_1BRNEDATEDATS8 RNE Issue Date
CNAEJ_1BCNAECHAR7 J_1BTCNAECNAE
LEGALNATJ_1BLEGALNATNUMC4 J_1BTLEGALNATLegal Nature
CRTNJ_1BCRTNCHAR1 CRT Number
ICMSTAXPAYJ_1BICMSTAXPAYCHAR2 J_1BTICMSTAXPAYICMS Taxpayer
INDTYPJ_1BINDTYPCHAR2 J_1BTINDTYPIndustry Main Type
TDTJ_1BTDTCHAR2 J_1BTTDTTax Declaration Type
COMSIZEJ_1BCOMSIZECHAR2 J_1BTCOMSIZECompany Size
DECREGPCJ_1BDECREGPCCHAR2 J_1BTDECREGPCDeclaration Regimen for PIS/COFINS
.APPEND/VSO/R_KNA1_A Append to KNA1 for Vehicle Space Optimization
.INCLUDE/VSO/R_KNA1_I Additional Data for Vehicle Space Optimization for KNA1
/VSO/R_PALHGT/VSO/R_PAL_BIN_HGTQUAN13(3) Maximum Stacking Height of the Packaging Material (VSO)
/VSO/R_PAL_UL/VSO/R_PAL_UNIT_LUNIT3 T006Unit of Length for Packaging Material (VSO)CUNIT
/VSO/R_PK_MAT/VSO/M_PACK_BY_MATCHAR1 Customer-Related Packing for Each Packaging Material (VSO)
/VSO/R_MATPAL/VSO/M_MATNR_PALCHAR18 MARAPackaging Material of the Customer in VSOMATN1
/VSO/R_I_NO_LYR/VSO/M_IPAL_NO_LYRNUMC2 Number Layers Under an Inter-Pallet (VSO)
/VSO/R_ONE_MAT/VSO/M_ONE_MATCHAR1 Packing Material-Specific for Each Packaging Material
/VSO/R_ONE_SORT/VSO/M_ONE_SORTCHAR1 Pack Only One Package Type for Each PKM (VSO)
/VSO/R_ULD_SIDE/VSO/M_UNLOAD_SIDE_PREFNUMC1 Side Preference of Loading/Unloading (VSO)
/VSO/R_LOAD_PREF/VSO/M_LOAD_PREFNUMC1 Front/Back Preference of Loading/Unloading (VSO)
/VSO/R_DPOINT/VSO/R_DELIVERYPOINTCHAR10 /VSO/R_DPOINTCollective Unloading Point for VSO
.APPEND/XLSO/S_PP_DIS_WF Append strct for Prefrd payment,discount,WF,Shop Id,Txn_ctx
/XLSO/CUSTOMER/XLSO/E_CUSTOMERCHAR1 Data element to differentiate customer
/XLSO/SYSIDSYSYSIDCHAR8 Name of SAP System
/XLSO/CLIENTMANDTCLNT3
*
Client
/XLSO/PARTNERBU_PARTNERCHAR10
*
Business Partner NumberALPHA
/XLSO/PREF_PAYCHAR2CHAR2 Version Number Component
.APPENDAKNA1_FMFG US Federal Government Customer Master Data Additional Fields
ALCFMFG_ALCCHAR8 FMFGT_ALCAgency Location Code
PMT_OFFICEFMFG_PMT_OFFCHAR5 FMFGT_POPayment Office
.INCLUDESI_FMFG_VP2 Fee Schedule for Value Pack 2
FEE_SCHEDULEFM_FEE_SCHEDCHAR4 Fee schedule
DUNSFMCCRDUNSCHAR9 DUNS Number
DUNS4FMCCRDUNS4CHAR4 DUNS+4
.APPENDAKNA1_PSO Local Authority Additional Fields
PSOFGPSOFGCHAR10 PSO19Processor group
PSOISPSOISCHAR20 Subledger acct preprocessing procedure
.INCLUDEIADDR_PSO Local Authority Additional Fields (Address)
PSON1NAME1_GPCHAR35 Name 1
PSON2NAME2_GPCHAR35 Name 2
PSON3NAME3_GPCHAR35 Name 3
PSOVNPSOVNCHAR35 First Name
PSOTLPSOTLCHAR20 Title
PSOHSPSOHSCHAR6 House number: is no longer used from Release 4.6B
PSOSTPSOSTCHAR28 Street: No longer used from Release 4.6B
.INCLUDEPSO21 Description (Customer/Vendor Supplement)
PSOO1PSOO1CHAR50 Description
PSOO2PSOO1CHAR50 Description
PSOO3PSOO1CHAR50 Description
PSOO4PSOO1CHAR50 Description
PSOO5PSOO1CHAR50 Description
.APPENDJ_3GKNA1A צירוף ל-KNA1
.INCLUDEJ_3GKNA1S Include Structure in KNA1 for CEM Project
J_3GETYPJ_3GETYPCHAR2 J_3GZUETYPRecipient Type
J_3GREFTYPJ_3GREFTYPCHAR2 Reference Type for Recipient
PSPNRPS_POSNRNUMC8 PRPSWBS ElementABPSP
COAUFNRAUFNRCHAR12 AUFKOrder NumberALPHA
J_3GAGEXTJ_3GAGEXTCHAR10 KNA1External Sold-to PartyALPHA
J_3GAGINTJ_3GAGINTCHAR10 KNA1Customer Internal SettlementALPHA
J_3GAGDUMIJ_3GDEMPSTCHAR10 KNA1Dummy RecipientALPHA
J_3GAGSTDIJ_3GAGSTDICHAR10 KNA1Standard RecipientALPHA
LGORTLGORT_DCHAR4 T001LStorage Location
KOKRSKOKRSCHAR4 TKA01Controlling Area
KOSTLKOSTLCHAR10 CSKSCost CenterALPHA
J_3GABGLGJ_3GABGLGCHAR1 Retirement Date Counts for Performance-Based Equipment
J_3GABGVGJ_3GABGVGCHAR1 Retirement Date Counts for Time-Based Equipment
J_3GABRARTJ_3GABRARTCHAR1 Settlement Type
J_3GSTDMONJ_3GSTDMONDEC5(2) Hours per Month
J_3GSTDTAGJ_3GSTDTAGDEC5(2) Hours per Day
J_3GTAGMONJ_3GTAGMONDEC5(2) Number of Days/Month
J_3GZUGTAGJ_3GZUGTAGCHAR1 Function for Settlement on Acquisition Date/PBE
J_3GMASCHBJ_3GMASCHBCHAR1 "Fill PBE Documents" Indicator
J_3GMEINSAJ_3GMEINSACHAR1 Indicator: Take Multiple Usage Periods into Account
J_3GKEINSAJ_3GKEINSACHAR1 Indicator - Relevant to Short Operation Periods
J_3GBLSPERJ_3GBLSPERCHAR1 Blocking Indicator for Document Entry
J_3GKLEIVOJ_3GKLEIVOCHAR1 Indicator: Calculate PBE as TBE
J_3GCALIDJ_3GCALIDCHAR2 TFACDCalendar ID
J_3GVMONATJ_3GVMONATNUMC1 Indicator for Complete Month
J_3GABRKENJ_3GABRKENCHAR1 Settlement Indicator
J_3GLABRECHJ_3GLABRECHDATS8 Date of Last Settlement
J_3GAABRECHJ_3GAABRECHDATS8 Date of Current Settlement
J_3GZUTVHLGJ_3GZUTVHLGCHAR1 Ind.: Acquisition Date Counts (as Daily Settlement for PBE)
J_3GNEGMENJ_3GNEGMENCHAR1 Negative Quantities Allowed Even for Chronolog. Inv. Mgmt
J_3GFRISTLOJ_3GFRISTLOCHAR1 Indicator: Deadline Logic
J_3GEMINBEJ_3GEMINBENUMC5 Minimum Usage Period for Restricted Usage (Days)
J_3GFMGUEJ_3GFMGUENUMC5 Release Notification Allowance for Unrestricted Usage (Days)
J_3GZUSCHUEJ_3GZUSCHUENUMC5 Surcharge for Unrestricted Usage (Days)
J_3GSCHPRSJ_3GSCHPRSCHAR1 Indicator: Shift Price
J_3GINVSTAJ_3GINVSTACHAR1 Status of Construction Site Inventory
/SAPCEM/DBER/SAPCEM/DBERCHAR8 /SAPCEM/DISPOBERPlanning Area
/SAPCEM/KVMEQ/SAPCEM/KVMEQCHAR1 Indicator: Settlement Qty Relevant to Equipment
.APPENDOIC_KNA1 IS-Oil MAP append to table KNA1
OIDRCOIC_DRCCHAR5 OICDCDifferential Reference Code (DRC)NUMCV
.APPENDOID_KNA1 IS-Oil MCOE append to table KNA1
OID_POREQDOID_POREQDCHAR1 Purchase order required: X = Yes, Blank = No
.APPENDOIF_KNA1 IS-Oil MRN append to table KNA1
OIPBLOIF_PBLNRCHAR10 OIFSPBLBusiness location identifier (IS-Oil MRN)ALPHA
ZFIELD248 VBELN_VACHAR10
*
Sales DocumentALPHA



Key field
Non-key field

KNA1 relationships with other tables


BOSG-Uppermost Hierarchy Segment for BRF
     BKPF-Accounting Document Header
          BSEG-Accounting Document Segment
          BSET-Tax Data Document Segment
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
     KNA1-General Data in Customer Master
          KNBK-Customer Master (Bank Details)
          KNB1-Customer Master (Company Code)
               KNB4-Customer Payment History
               KNB5-Customer Master (Dunning Data)
               KNKK-Credit Management Cust. Mstr: Control Area Data
               KNC1-Customer Master (Transaction Figures)
               KNC3-Customer Master (Special G/L Transaction Figures)
     LFA1-Vendor Master (General Section)
          LFBK-Vendor Master (Bank Details)
          LFB1-Vendor Master (Company Code)
               LFB5-Vendor Master (Dunning Data)
               LFC1-Vendor Master (Transaction Figures)
               LFC3-Vendor Master (Transaction Figures) Special Ledger
     SKA1-G/L Account Master Record (Chart of Accounts)
          SKB1-G/L Account Master Record (Company Code)
               SKC1A-G/L Sales Segment Derived from GLDB - Internal
               SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


KNA1-General Data in Customer Master
     ADDR1_VAL-Address Data
     KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
     KNKA-Customer Master Credit Management: Central Data
     KNKK-Credit Management Cust. Mstr: Control Area Data
     KNBK-Customer Master (Bank Details)
     KNB1-Customer Master (Company Code)
          KNB4-Customer Payment History
          KNB5-Customer Master (Dunning Data)
          KNC1-Customer Master (Transaction Figures)
          KNC3-Customer Master (Special G/L Transaction Figures)
          BSID-Accounting: Secondary Index for Customers
               ADMI_FILES-Archive Files
               BSIDEXT-Secondary Index & Additions Section (bsega)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                         GSEG-Offsetting Items for B-Segment in Reporting


KNA1-General Data in Customer Master
     KNVP-Customer Master Partner Functions
     KNVK-Customer Master Contact Partner
     KNVV-Customer Master Sales Data


VBKPA-SD index: Sales activities by partner function
     VBKA-Sales activities
          SADLSTADM-Administrative Data - Address List
               SADLSTIAD-Administration Table for Address Lists
                    SADLSTRECH-Statistical part of an address list (rec. header)
                    SADLSTRECB-Dynamic part of address record (record body)
               SADLSTDIR1-Address List Directory
          SADLSTSORT-Sort Fields for Address List
     VBPA-Sales Document: Partner
          KNA1-General Data in Customer Master
          KNVV-Customer Master Sales Data
          KNVK-Customer Master Contact Partner
          VBADR-Address work area
     VBFA-Sales Document Flow
          VBAK-Sales Document: Header Data


KNVK-Customer Master Contact Partner
     KNA1-General Data in Customer Master
          KNVV-Customer Master Sales Data
          KNVP-Customer Master Partner Functions
          VBAP-Sales Document: Item Data
          LIPS-SD document: Delivery: Item data
          VBRP-Billing Document: Item Data
          VBKA-Sales Activities