SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

SAP KNA1 (General Data in Customer Master) Table & Fields

KNA1 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of KNA1.

SAP KNA1 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
KUNNRCustomer NumberKUNNRKUNNR
LAND1Country KeyLAND1_GPLAND1
NAME1Name 1NAME1_GPNAME
NAME2Name 2NAME2_GPNAME
ORT01CityORT01_GPTEXT35
PSTLZPostal CodePSTLZPSTLZ
REGIORegion (State, Province, County)REGIOREGIO
SORTLSort fieldSORTLCHAR10
STRASHouse number and streetSTRAS_GPTEXT35
TELF1First telephone numberTELF1TEXT16
TELFXFax NumberTELFXTEXT31
XCPDKIndicator: Is the account a one-time account?XCPDKXFELD
ADRNRAddressADRNRADRNR
MCOD1Search term for matchcode searchMCDD1CHAR25
MCOD2Search Term for Matchcode SearchMCDD2CHAR25
MCOD3Search term for matchcode searchMCDD3CHAR25
.INCLUDEGeneral Data in Customer Master    
ANREDTitleANREDTEXT15
AUFSDCentral order block for customerAUFSD_XKAUFS
BAHNEExpress train stationBAHNEBAHNH
BAHNSTrain stationBAHNSBAHNH
BBBNRInternational location number (part 1)BBBNRNUM07
BBSNRInternational location number (Part 2)BBSNRNUM05
BEGRUAuthorization GroupBRGRUBRGRU
BRSCHIndustry keyBRSCHBRSCH
BUBKZCheck digit for the international location numberBUBKZNUM01
DATLTData communication line no.DATLTTEXT14
ERDATDate on which the Record Was CreatedERDAT_RFDATUM
ERNAMName of Person who Created the ObjectERNAM_RFUSNAM
EXABLIndicator: Unloading points existEXABLXFELD
FAKSDCentral billing block for customerFAKSD_XFAKSP
FISKNAccount number of the master record with the fiscal addressFISKN_DKUNNR
KNAZKWorking Time CalendarKNAZKWFCID
KNRZAAccount number of an alternative payerKNRZAKUNNR
KONZSGroup keyKONZSKONZS
KTOKDCustomer Account GroupKTOKDKTOKD
KUKLACustomer classificationKUKLAKUKLA
LIFNRAccount Number of Vendor or CreditorLIFNRLIFNR
LIFSDCentral delivery block for the customerLIFSD_XLIFSP
LOCCOCity CoordinatesLOCCOLOCCO
LOEVMCentral Deletion Flag for Master RecordLOEVM_XXFELD
NAME3Name 3NAME3_GPNAME
NAME4Name 4NAME4_GPNAME
NIELSNielsen IDNIELSNIELS
ORT02DistrictORT02_GPTEXT35
PFACHPO BoxPFACHPFACH
PSTL2P.O. Box Postal CodePSTL2PSTLZ
COUNCCounty CodeCOUNCCOUNC
CITYCCity CodeCITYCCITYC
RPMKRRegional marketRPMKRRPMKR
SPERRCentral posting blockSPERB_XXFELD
SPRASLanguage KeySPRASSPRAS
STCD1Tax Number 1STCD1STCD1
STCD2Tax Number 2STCD2STCD2
STKZAIndicator: Business Partner Subject to Equalization Tax?STKZASTKZA
STKZULiable for VATSTKZUXFELD
TELBXTelebox numberTELBXTEXT15
TELF2Second telephone numberTELF2TEXT16
TELTXTeletex numberTELTXTEXT30
TELX1Telex numberTELX1TEXT30
LZONETransportation zone to or from which the goods are deliveredLZONEZONE
XZEMPIndicator: Is an alternative payer allowed in document?XREGUXFELD
VBUNDCompany ID of trading partnerRASSCRCOMP
STCEGVAT Registration NumberSTCEGSTCEG
DEAR1Indicator: CompetitorDEAR1XFELD
DEAR2Indicator: Sales partnerDEAR2XFELD
DEAR3Indicator: Sales prospectDEAR3DEAR3
DEAR4Indicator for customer type 4DEAR4XFELD
DEAR5ID for default sold-to partyDEAR5XFELD
GFORMLegal statusGFORMGFORM
BRAN1Industry code 1BRAN1_DBRACO
BRAN2Industry code 2BRAN2BRACO
BRAN3Industry code 3BRAN3BRACO
BRAN4Industry code 4BRAN4BRACO
BRAN5Industry code 5BRAN5BRACO
EKONTInitial contactEKONTVBELN
UMSATAnnual salesUMSATUMSAT
UMJAHYear For Which Sales are GivenUMJAHJAHR
UWAERCurrency of Sales VolumeUWAERWAERS
JMZAHYearly number of employeesJMZAHJMZAH
JMJAHYear for which the number of employees is givenJMJAHJAHR
KATR1Attribute 1KATR1ATTR1
KATR2Attribute 2KATR2ATTR2
KATR3Attribute 3KATR3ATTR3
KATR4Attribute 4KATR4ATTR4
KATR5Attribute 5KATR5ATTR5
KATR6Attribute 6KATR6ATTR6
KATR7Attribute 7KATR7ATTR7
KATR8Attribute 8KATR8ATTR8
KATR9Attribute 9KATR9ATTR9
KATR10Attribute 10KATR10ATTR10
STKZNNatural PersonSTKZNSTKZN
UMSA1Annual salesUMSA1UMSA1
TXJCDTax JurisdictionTXJCDTXJCD
PERIVFiscal Year VariantPERIVPERIV
ABRVWUsage IndicatorABRVWABRVW
INSPBYDEBIInspection Carried Out By Customer (No Inspection Lot)QINSPBYDEBQKZ
INSPATDEBIInspection for a Delivery Note After Outbound DeliveryQINSPATDEBQKZ
KTOCDReference Account Group for One-Time Account (Customer)KTOCDKTOKD
PFORTPO Box cityPFORT_GPTEXT35
WERKSPlantWERKS_DWERKS
DTAMSReport key for data medium exchangeDTAMSDTAMS
DTAWSInstruction key for data medium exchangeDTAWSDTAWS
DUEFLStatus of Data Transfer into Subsequent ReleaseDUEFL_BKPFDUEFL_BKPF
HZUORAssignment to HierarchyHZUORHZUOR
SPERZPayment BlockSPERZXFELD
ETIKGIS-R Labeling: customer/plant groupETIKGETIKG
CIVVEID for mainly non-military useCIVVEXFELD
MILVEID for mainly military useMILVEXFELD
KDKG1Customer condition group 1KDKG1KDKGR
KDKG2Customer condition group 2KDKG2KDKGR
KDKG3Customer condition group 3KDKG3KDKGR
KDKG4Customer condition group 4KDKG4KDKGR
KDKG5Customer condition group 5KDKG5KDKGR
XKNZAIndicator: Alternative payer using account numberXKNZAXFELD
FITYPTax typeJ_1AFITP_DJ_1AFITP
STCDTTax Number TypeJ_1ATOIDJ_1ATOID
STCD3Tax Number 3STCD3CHAR18
STCD4Tax Number 4STCD4CHAR18
STCD5Tax Number 5STCD5CHAR60
XICMSCustomer is ICMS-exemptJ_1BTCICMSXFELD
XXIPICustomer is IPI-exemptJ_1BTCIPIXFELD
XSUBTCustomer group for Substituiçao Tributária calculationJ_1BTCSTJ_1BTCST1
CFOPCCustomer's CFOP categoryJ_1BINDUS1J_1BINDUS1
TXLW1Tax law: ICMSJ_1BTAXLW1J_1BTAXLW1
TXLW2Tax law: IPIJ_1BTAXLW2J_1BTAXLW2
CCC01Indicator for biochemical warfare for legal controlCCC01XFELD
CCC02Indicator for nuclear nonproliferation for legal controlCCC02XFELD
CCC03Indicator for national security for legal controlCCC03XFELD
CCC04Indicator for missile technology for legal controlCCC04XFELD
CASSDCentral sales block for customerCASSD_XCASSP
KNURLUniform resource locatorURLTEXT132
J_1KFREPREName of RepresentativeREPRESREPRES
J_1KFTBUSType of BusinessGESTYPGESTYP
J_1KFTINDType of IndustryINDTYPINDTYP
CONFSStatus of Change Authorization (Central)CONFS_XCHAR1
UPDATDate on Which the Changes Were ConfirmedUPDAT_RFDATUM
UPTIMTime of Last Change ConfirmationUPTIM_RFAS4TIME
NODELCentral deletion block for master recordNODEL_XXFELD
DEAR6Indicator: ConsumerDEAR6XFELD
.INCLUDECustomer Master Data - Brazil    
SUFRAMASuframa CodeJ_1BSUFRAMAJ_1BSUFRAMA
RGRG NumberJ_1BRGJ_1BRG
EXPIssued byJ_1BEXPJ_1BEXP
UFStateJ_1BUFJ_1BUF
RGDATERG Issue DateJ_1BRGDATEDATUM
RICRIC NumberJ_1BRICJ_1BRIC
RNEForeign National RegistrationJ_1BRNEJ_1BRNE
RNEDATERNE Issue DateJ_1BRNEDATEDATUM
CNAECNAEJ_1BCNAEJ_1BCNAE
LEGALNATLegal NatureJ_1BLEGALNATJ_1BLEGALNAT
CRTNCRT NumberJ_1BCRTNJ_1BCRTN
ICMSTAXPAYICMS TaxpayerJ_1BICMSTAXPAYJ_1BICMSTAXPAY
INDTYPIndustry Main TypeJ_1BINDTYPJ_1BINDTYP
TDTTax Declaration TypeJ_1BTDTJ_1BTDT
COMSIZECompany SizeJ_1BCOMSIZEJ_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINSJ_1BDECREGPCJ_1BDECREGPC
.INCLU--APAppend to KNA1 for Vehicle Space Optimization    
.INCLUDEAdditional Data for Vehicle Space Optimization for KNA1    
/VSO/R_PALHGTMaximum Stacking Height of the Packaging Material (VSO)/VSO/R_PAL_BIN_HGTMENG13
/VSO/R_PAL_ULUnit of Length for Packaging Material (VSO)/VSO/R_PAL_UNIT_LMEINS
/VSO/R_PK_MATCustomer-Related Packing for Each Packaging Material (VSO)/VSO/M_PACK_BY_MAT/VSO/M_XFIELD
/VSO/R_MATPALPackaging Material of the Customer in VSO/VSO/M_MATNR_PALMATNR
/VSO/R_I_NO_LYRNumber Layers Under an Inter-Pallet (VSO)/VSO/M_IPAL_NO_LYR/VSO/M_IPAL_NO_LYR
/VSO/R_ONE_MATPacking Material-Specific for Each Packaging Material/VSO/M_ONE_MAT/VSO/M_XFIELD
/VSO/R_ONE_SORTPack Only One Package Type for Each PKM (VSO)/VSO/M_ONE_SORT/VSO/M_XFIELD
/VSO/R_ULD_SIDESide Preference of Loading/Unloading (VSO)/VSO/M_UNLOAD_SIDE_PREF/VSO/M_SIDE_PREF
/VSO/R_LOAD_PREFFront/Back Preference of Loading/Unloading (VSO)/VSO/M_LOAD_PREF/VSO/M_LOAD_PREF
/VSO/R_DPOINTCollective Unloading Point for VSO/VSO/R_DELIVERYPOINT/VSO/R_DELIVERYPOINT
.INCLU--APUS Federal Government Customer Master Data Additional Fields    
ALCAgency Location CodeFMFG_ALCFMFG_ALC
PMT_OFFICEPayment OfficeFMFG_PMT_OFFFMFG_PMT_OFF
.INCLUDE   
.INCLU--APLocal Authority Additional Fields    
PSOFGProcessor groupPSOFGPSOFG
PSOISSubledger acct preprocessing procedurePSOISCHAR20
.INCLUDELocal Authority Additional Fields (Address)    
PSON1Name 1NAME1_GPNAME
PSON2Name 2NAME2_GPNAME
PSON3Name 3NAME3_GPNAME
PSOVNFirst NamePSOVNNAME
PSOTLTitlePSOTLFMPSOTL
PSOHSHouse number: is no longer used from Release 4.6BPSOHSCHAR06
PSOSTStreet: No longer used from Release 4.6BPSOSTPSOST
.INCLUDEDescription (Customer/Vendor Supplement)    
PSOO1DescriptionPSOO1TEXT50
PSOO2DescriptionPSOO1TEXT50
PSOO3DescriptionPSOO1TEXT50
PSOO4DescriptionPSOO1TEXT50
PSOO5DescriptionPSOO1TEXT50

KNA1 related tables

TableNote
KNA1General Data in Customer Master
KNASCustomer master (VAT registration numbers general section)
KNB1Customer Master (Company Code)
KNB4Customer Payment History
KNB5Customer master (dunning data)
KNBKCustomer Master (Bank Details)
KNVKCustomer Master Contact Partner
KNVPCustomer Master Partner Functions
KNZAPermitted Alternative Payer
T077DCustomer account groups
T077XAccount Group Names (Table T077D)
T078DTrans.-dependent screen selection for cust.master
T079DCompany code-dependent screen sel.for cust.master
T079VCustomers: Screen Selection according to Sales Org.
TCONV_ADRConversion of Old Address Fields to CAM Address Fields
TIBAN_APARUnconfirmed IBANs and Their Correct Validity Start
TIBAN_WO_ACCNOActivation of "IBAN without Bank Account Number"
Do you know this 11 Advantages of SAP Software?
Read Now
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2021 sapstack.com