TXI_KNVV SAP (Customer Master Sales Data) Structure details

Dictionary Type: Structure
Description: Customer Master Sales Data




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




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

TXI_KNVV 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 "Customer Master Sales Data" 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_KNVV TYPE TXI_KNVV.

The TXI_KNVV table consists of various fields, each holding specific information or linking keys about Customer Master Sales Data data available in SAP. These include MANDT (Client), KUNNR (Customer Numbers), VKORG (Sales Organization), VTWEG (Distribution Channel).. 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_KNVV 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 KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion flag for customer (sales level) LOEVM_VCHAR1XFELD
VERSGCustomer Statistics Group STGKUCHAR1TVSDSTGKU
AUFSDCustomer order block (sales area) AUFSD_VCHAR2TVASTKAUFS
KALKSPricing procedure assigned to this customer KALKSCHAR1TVKDKALKS
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
BZIRKSales district BZIRKCHAR6T171BZIRKBZI
KONDAPrice group (customer) KONDACHAR2T188KONDAVKA
PLTYPPrice list type PLTYPCHAR2T189PLTYPVPL
AWAHROrder probability of the item AWAHRNUMC3AWAHR
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
LIFSDCustomer delivery block (sales area) LIFSD_VCHAR2TVLSLIFSP
AUTLFComplete delivery defined for each sales order? AUTLFCHAR1XFELD
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
KZAZUOrder Combination Indicator KZAZU_DCHAR1XFELD
CHSPLBatch split allowed CHSPLCHAR1XFELD
LPRIODelivery Priority LPRIONUMC2TPRIOLPRIO
EIKTOShipper's (Our) Account Number at the Customer or Vendor EIKTOCHAR12CHAR12
VSBEDShipping Conditions VSBEDCHAR2TVSBVSBED
FAKSDBilling block for customer (sales and distribution) FAKSD_VCHAR2TVFSFAKSP
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
PERFKInvoice dates (calendar identification) PERFKCHAR2TFACDWFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2TFACDWFCID
KVAKZCost estimate indicator (inactive) KVAKZCHAR1XFELD
KVAWTValue limit for cost estimate (inactive) KVAWTCURR13(2) WERT7
WAERSCurrency WAERS_V02DCUKY5TCURCWAERS
KLABCCustomer classification (ABC analysis) KLABCCHAR2KLABC
KTGRDAccount assignment group for this customer KTGRDCHAR2TVKTKTGRD
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
VWERKDelivering Plant (Own or External) DWERK_EXTCHAR4TVKWZWERKSSH_DWERK_EXTS
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
VSORTItem proposal VSORTCHAR10VBUKALPHAVBELN
KVGR1Customer group 1 KVGR1CHAR3TVV1KVGR1
KVGR2Customer group 2 KVGR2CHAR3TVV2KVGR2
KVGR3Customer group 3 KVGR3CHAR3TVV3KVGR3
KVGR4Customer group 4 KVGR4CHAR3TVV4KVGR4
KVGR5Customer group 5 KVGR5CHAR3TVV5KVGR5
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
BOIDTStart of validity per.for the rebate index for the customer BOIDTDATS8DATUM
KURSTExchange Rate Type KURSTCHAR4TCURVKURSTKUT
PRFRERelevant for price determination ID PRFRECHAR1XFELD
PRAT1ID for product attribute 1 KUAT1CHAR1PRATK
PRAT2ID for product attribute 2 KUAT2CHAR1PRATK
PRAT3ID for product attribute 3 KUAT3CHAR1PRATK
PRAT4ID for product attribute 4 KUAT4CHAR1PRATK
PRAT5ID for product attribute 5 KUAT5CHAR1PRATK
PRAT6ID for product attribute 6 KUAT6CHAR1PRATK
PRAT7ID for product attribute 7 KUAT7CHAR1PRATK
PRAT8ID for product attribute 8 KUAT8CHAR1PRATK
PRAT9ID for product attribute 9 KUAT9CHAR1PRATK
PRATAID for product attribute 10 KUATACHAR1PRATK
KABSSCustomer payment guarantee procedure KABSSCH_CMCHAR4T691PKABSSCH_CM
KKBERCredit control area KKBERCHAR4T014KKBERKKB
CASSDSales block for customer (sales area) CASSD_VCHAR2CASSP
RDOFFSwitch off rounding? RDOFFCHAR1XFELD
AGRELIndicator: Relevant for agency business AGRELCHAR1XFELD
MEGRUUnit of Measure Group MEGRUCHAR4TWMEGMEGRU
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
UEBTKUnlimited overdelivery allowed UEBTK_VCHAR1XFELD
PVKSMCustomer procedure for product proposal PVKSMCHAR2TPVDPVKSM
PODKZRelevant for POD processing PODKZCHAR1XFELD
PODTGTimeframe for Confirmation of POD PODTGDEC11TSTRGTSTRDURAG
BLINDIndex Structure Active for Subsequent Settlement (in AB) BLIND_SDCHAR1XFELD
CARRIER_NOTIFCarrier is to be notified /SPE/CARRIER_NOTIFCHAR1XFELD
.INCLU--AP 0
/BEV1/EMLGPFANDDeposit on Empties /BEV1/EMGPFANDCHAR1/BEV1/EMGPFAND
/BEV1/EMLGFORTSIndicator for Empties Update /BEV1/EMGFORTSCHAR1/BEV1/EMGFORTS
.INCLU--AP 0
J_1NBOESLExchange Key for NF Processing /NFM/BOESLCHAR3/NFM/TBOESL/NFM/BOESL
.INCLU--AP 0
PROFILEDRM profile /SAPHT/DRM_PROFILECHAR4/SAPHT/DRM_PRF/SAPHT/DRM_PROFILE
.INCLU--AP 0
FPARTBilling/Invoicing Plan Type FPARTCHAR2TFPLAFPART
.INCLU--AP 0
/XLSO/CUST_DISRate (condition amount or percentage) where no scale exists KBETR_KONDCURR11(2) WERTV6
/XLSO/COMP_NAMEName 1 NAME1_GPCHAR35NAME
/XLSO/INDUSTRYIndustry key BRSCHCHAR4Assigned to domainBRSCH
/XLSO/H_NUMBERHouse Number AD_HSNM1CHAR10TEXT10
/XLSO/STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
/XLSO/POST_CODEPostal Code PSTLZCHAR10PSTLZ
/XLSO/CITYCity ORT01_GPCHAR35TEXT35
/XLSO/REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
/XLSO/COUNTRYCountry Key LAND1_GPCHAR3Assigned to domainLAND1C_LAND1
/XLSO/INACTIVESingle-Character Indicator CHAR1CHAR1CHAR1
KVAWT_CYCUKY for SYST SYCUKYCUKY5SYCUKY

Key field Non-key field



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

As TXI_KNVV 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_KNVV as there is no data to select.

How to access SAP table TXI_KNVV

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