TXI_KNA1 SAP (General Data in Customer Master) Structure details

Dictionary Type: Structure
Description: General Data in Customer Master




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




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

TXI_KNA1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "General Data in Customer Master" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXI_KNA1 TYPE TXI_KNA1.

The TXI_KNA1 table consists of various fields, each holding specific information or linking keys about General Data in Customer Master data available in SAP. These include MANDT (Client), KUNNR (Customer Numbers), LAND1 (Country Key), NAME1 (Name 1).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TXI_KNA1 structure 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
.INCLU--AP 0
/VSO/R_PALHGTMaximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGTQUAN13(3) MENG13
/VSO/R_PAL_ULUnit of Length for Packaging Material (VSO) /VSO/R_PAL_UNIT_LUNIT3T006CUNITMEINS
/VSO/R_PK_MATCustomer-Related Packing for Each Packaging Material (VSO) /VSO/M_PACK_BY_MATCHAR1/VSO/M_XFIELD
/VSO/R_MATPALPackaging Material of the Customer in VSO /VSO/M_MATNR_PALCHAR18MARAMATN1MATNR
/VSO/R_I_NO_LYRNumber Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYRNUMC2/VSO/M_IPAL_NO_LYR
/VSO/R_ONE_MATPacking Material-Specific for Each Packaging Material /VSO/M_ONE_MATCHAR1/VSO/M_XFIELD
/VSO/R_ONE_SORTPack Only One Package Type for Each PKM (VSO) /VSO/M_ONE_SORTCHAR1/VSO/M_XFIELD
/VSO/R_ULD_SIDESide Preference of Loading/Unloading (VSO) /VSO/M_UNLOAD_SIDE_PREFNUMC1/VSO/M_SIDE_PREF
/VSO/R_LOAD_PREFFront/Back Preference of Loading/Unloading (VSO) /VSO/M_LOAD_PREFNUMC1/VSO/M_LOAD_PREF
/VSO/R_DPOINTCollective Unloading Point for VSO /VSO/R_DELIVERYPOINTCHAR10/VSO/R_DPOINT/VSO/R_DELIVERYPOINT/VSO/R_SH_DPOINT
.INCLU--AP 0
/XLSO/CUSTOMERData element to differentiate customer /XLSO/E_CUSTOMERCHAR1/XLSO/D_CUSTOMER
/XLSO/SYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
/XLSO/CLIENTClient MANDTCLNT3Assigned to domainMANDT
/XLSO/PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
/XLSO/PREF_PAYVersion Number Component CHAR2CHAR2CHAR2
.INCLU--AP 0
ALCAgency Location Code FMFG_ALCCHAR8FMFGT_ALCFMFG_ALCFMFG_ALC
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5FMFGT_POFMFG_PMT_OFFFMFG_PMT_OFFICE
FEE_SCHEDULEFee schedule FM_FEE_SCHEDCHAR4FM_FEE_SCHEDFM_FEE_SCHEDULE
DUNSDUNS Number FMCCRDUNSCHAR9
DUNS4DUNS+4 FMCCRDUNS4CHAR4
.INCLU--AP 0
PSOFGProcessor group PSOFGCHAR10PSO19PSOFG
PSOISSubledger acct preprocessing procedure PSOISCHAR20CHAR20
PSON1Name 1 NAME1_GPCHAR35NAME
PSON2Name 2 NAME2_GPCHAR35NAME
PSON3Name 3 NAME3_GPCHAR35NAME
PSOVNFirst Name PSOVNCHAR35NAME
PSOTLTitle PSOTLCHAR20FMPSOTL
PSOHSHouse number: is no longer used from Release 4.6B PSOHSCHAR6CHAR06
PSOSTStreet: No longer used from Release 4.6B PSOSTCHAR28PSOST
PSOO1Description PSOO1CHAR50TEXT50
PSOO2Description PSOO1CHAR50TEXT50
PSOO3Description PSOO1CHAR50TEXT50
PSOO4Description PSOO1CHAR50TEXT50
PSOO5Description PSOO1CHAR50TEXT50
.INCLU--AP 0
J_3GETYPRecipient Type J_3GETYPCHAR2J_3GZUETYPJ_3GETYP
J_3GREFTYPReference Type for Recipient J_3GREFTYPCHAR2J_3GREFTYP
PSPNRWBS Element PS_POSNRNUMC8PRPSABPSPPS_POSNR
COAUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
J_3GAGEXTExternal Sold-to Party J_3GAGEXTCHAR10KNA1ALPHAKUNNR
J_3GAGINTCustomer Internal Settlement J_3GAGINTCHAR10KNA1ALPHAKUNNR
J_3GAGDUMIDummy Recipient J_3GDEMPSTCHAR10KNA1ALPHAKUNNR
J_3GAGSTDIStandard Recipient J_3GAGSTDICHAR10KNA1ALPHAKUNNR
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
J_3GABGLGRetirement Date Counts for Performance-Based Equipment J_3GABGLGCHAR1X
J_3GABGVGRetirement Date Counts for Time-Based Equipment J_3GABGVGCHAR1X
J_3GABRARTSettlement Type J_3GABRARTCHAR1J_3GABRART
J_3GSTDMONHours per Month J_3GSTDMONDEC5(2) DEC03_2
J_3GSTDTAGHours per Day J_3GSTDTAGDEC5(2) DEC03_2
J_3GTAGMONNumber of Days/Month J_3GTAGMONDEC5(2) DEC3_2
J_3GZUGTAGFunction for Settlement on Acquisition Date/PBE J_3GZUGTAGCHAR1X
J_3GMASCHB'Fill PBE Documents' Indicator J_3GMASCHBCHAR1J_3GMASCHB
J_3GMEINSAIndicator: Take Multiple Usage Periods into Account J_3GMEINSACHAR1X
J_3GKEINSAIndicator - Relevant to Short Operation Periods J_3GKEINSACHAR1X
J_3GBLSPERBlocking Indicator for Document Entry J_3GBLSPERCHAR1X
J_3GKLEIVOIndicator: Calculate PBE as TBE J_3GKLEIVOCHAR1X
J_3GCALIDCalendar ID J_3GCALIDCHAR2TFACDWFCID
J_3GVMONATIndicator for Complete Month J_3GVMONATNUMC1J_3GVMONAT
J_3GABRKENSettlement Indicator J_3GABRKENCHAR1J_3GABRKEN
J_3GLABRECHDate of Last Settlement J_3GLABRECHDATS8DATUM
J_3GAABRECHDate of Current Settlement J_3GAABRECHDATS8DATUM
J_3GZUTVHLGInd.: Acquisition Date Counts (as Daily Settlement for PBE) J_3GZUTVHLGCHAR1X
J_3GNEGMENNegative Quantities Allowed Even for Chronolog. Inv. Mgmt J_3GNEGMENCHAR1X
J_3GFRISTLOIndicator: Deadline Logic J_3GFRISTLOCHAR1X
J_3GEMINBEMinimum Usage Period for Restricted Usage (Days) J_3GEMINBENUMC5NUMC
J_3GFMGUERelease Notification Allowance for Unrestricted Usage (Days) J_3GFMGUENUMC5NUMC
J_3GZUSCHUESurcharge for Unrestricted Usage (Days) J_3GZUSCHUENUMC5NUMC
J_3GSCHPRSIndicator: Shift Price J_3GSCHPRSCHAR1X
J_3GINVSTAStatus of Construction Site Inventory J_3GINVSTACHAR1J_3GINVSTA
/SAPCEM/DBERPlanning Area /SAPCEM/DBERCHAR8/SAPCEM/DISPOBER/SAPCEM/DBER
/SAPCEM/KVMEQIndicator: Settlement Qty Relevant to Equipment /SAPCEM/KVMEQCHAR1/SAPCEM/KVMEQ
.INCLU--AP 0
OIDRCDifferential Reference Code (DRC) OIC_DRCCHAR5OICDCNUMCVOIC_DRC
.INCLU--AP 0
OID_POREQDPurchase order required: X = Yes, Blank = No OID_POREQDCHAR1OI0_XFELD
.INCLU--AP 0
OIPBLBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10OIFSPBLALPHAOIF_PBLNROI0OIFB
.INCLU--AP 0
UMSAT_CYCUKY for SYST SYCUKYCUKY5SYCUKY
UMSA1_CYCUKY for SYST SYCUKYCUKY5SYCUKY

Key field Non-key field



How do I retrieve data from SAP structure TXI_KNA1 using ABAP code?

As TXI_KNA1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXI_KNA1 as there is no data to select.

How to access SAP table TXI_KNA1

Within an ECC or HANA version of SAP you can also view further information about TXI_KNA1 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!