SAP table BIW_KNVK_S (Extraction Structure 0CONSUMER_ATTR)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
KUNNR Customer Number CHAR 10 0 KUNNR
ADRNR Address CHAR 10 0 ADRNR
AUFSD Central order block for customer CHAR 2 0 AUFSD_X
BAHNE Express train station CHAR 25 0 BAHNE
BAHNS Train station CHAR 25 0 BAHNS
BBBNR International location number (part 1) NUMC 7 0 BBBNR
BBSNR International location number (Part 2) NUMC 5 0 BBSNR
BEGRU Authorization Group CHAR 4 0 BRGRU
BRSCH Industry key CHAR 4 0 BRSCH
BUBKZ Check digit for the international location number NUMC 1 0 BUBKZ
DATLT Data communication line no. CHAR 14 0 DATLT
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
EXABL Indicator: Unloading points exist CHAR 1 0 EXABL
FAKSD Central billing block for customer CHAR 2 0 FAKSD_X
FISKN Account number of the master record with the fiscal address CHAR 10 0 FISKN_D
KNAZK Working Time Calendar CHAR 2 0 KNAZK
KNRZA Account Number of an Alternative Payer CHAR 10 0 KNRZA
KONZS Group key CHAR 10 0 KONZS
KTOKD Customer Account Group CHAR 4 0 KTOKD
KUKLA Customer Classification CHAR 2 0 KUKLA
LAND1 Country/Region Key CHAR 3 0 LAND1_GP
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
LIFSD Central delivery block for the customer CHAR 2 0 LIFSD_X
LOCCO City Coordinates CHAR 10 0 LOCCO
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
NIELS Nielsen ID CHAR 2 0 NIELS
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSTLZ Postal Code CHAR 10 0 PSTLZ
REGIO Region (State, Province, County) CHAR 3 0 REGIO
COUNC County Code CHAR 3 0 COUNC
CITYC City Code CHAR 4 0 CITYC
RPMKR Regional market CHAR 5 0 RPMKR
SPERR Central posting block CHAR 1 0 SPERB_X
SPRAS Language Key LANG 1 0 SPRAS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT CHAR 1 0 STKZU
STRAS Street and House Number CHAR 35 0 STRAS_GP
TELBX Telebox number CHAR 15 0 TELBX
TELF1 First telephone number CHAR 16 0 TELF1
TELF2 Second telephone number CHAR 16 0 TELF2
TELFX Fax Number CHAR 31 0 TELFX
TELTX Teletex number CHAR 30 0 TELTX
TELX1 Telex number CHAR 30 0 TELX1
LZONE Transportation zone to or from which the goods are delivered CHAR 10 0 LZONE
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
XZEMP Indicator: Alternative Payee in Document Allowed? CHAR 1 0 XZEMP
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
STCEG VAT Registration Number CHAR 20 0 STCEG
DEAR1 Indicator: Competitor CHAR 1 0 DEAR1
DEAR2 Indicator: Sales partner CHAR 1 0 DEAR2
DEAR3 Indicator: Sales prospect CHAR 1 0 DEAR3
No
X yes
DEAR4 Indicator for customer type 4 CHAR 1 0 DEAR4
DEAR5 ID for default sold-to party CHAR 1 0 DEAR5
DEAR6 Indicator: Consumer CHAR 1 0 DEAR6
GFORM Legal status CHAR 2 0 GFORM
BRAN1 Industry code 1 CHAR 10 0 BRAN1_D
BRAN2 Industry code 2 CHAR 10 0 BRAN2
BRAN3 Industry code 3 CHAR 10 0 BRAN3
BRAN4 Industry code 4 CHAR 10 0 BRAN4
BRAN5 Industry code 5 CHAR 10 0 BRAN5
EKONT Initial contact CHAR 10 0 EKONT
UMSAT Annual sales CURR 8 2 UMSAT
UMJAH Year For Which Sales are Given NUMC 4 0 UMJAH
UWAER Currency of sales figure CUKY 5 0 UWAER
JMZAH Yearly number of employees NUMC 6 0 JMZAH
JMJAH Year for which the number of employees is given NUMC 4 0 JMJAH
KATR1 Attribute 1 CHAR 2 0 KATR1
KATR2 Attribute 2 CHAR 2 0 KATR2
KATR3 Attribute 3 CHAR 2 0 KATR3
KATR4 Attribute 4 CHAR 2 0 KATR4
KATR5 Attribute 5 CHAR 2 0 KATR5
KATR6 Attribute 6 CHAR 3 0 KATR6
KATR7 Attribute 7 CHAR 3 0 KATR7
KATR8 Attribute 8 CHAR 3 0 KATR8
KATR9 Attribute 9 CHAR 3 0 KATR9
KATR10 Attribute 10 CHAR 3 0 KATR10
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
UMSA1 Annual sales CURR 15 2 UMSA1
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
MCOD1 Search term for matchcode search CHAR 25 0 MCDD1
MCOD2 Search Term for Matchcode Search CHAR 25 0 MCDD2
MCOD3 Search term for matchcode search CHAR 25 0 MCDD3
PERIV Fiscal Year Variant CHAR 2 0 PERIV
ABRVW Usage Indicator CHAR 3 0 ABRVW
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) CHAR 1 0 QINSPBYDEB
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery CHAR 1 0 QINSPATDEB
KTOCD Reference Account Group for One-Time Account (Customer) CHAR 4 0 KTOCD
PFORT PO Box city CHAR 35 0 PFORT_GP
WERKS Plant CHAR 4 0 WERKS_D
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 DTAWS
DUEFL Status of Data Transfer into Subsequent Release CHAR 1 0 DUEFL_BKPF
Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
HZUOR Assignment to Hierarchy NUMC 2 0 HZUOR
SPERZ Payment Block CHAR 1 0 SPERZ
ETIKG IS-R Labeling: customer/plant group CHAR 10 0 ETIKG
CIVVE ID for mainly non-military use CHAR 1 0 CIVVE
MILVE ID for mainly military use CHAR 1 0 MILVE
KDKG1 Customer condition group 1 CHAR 2 0 KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 KDKG5
XKNZA Indicator: Alternative payer using account number CHAR 1 0 XKNZA
FITYP Tax type CHAR 2 0 J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 J_1ATOID
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
XICMS Customer is ICMS-exempt CHAR 1 0 J_1BTCICMS
XXIPI Customer is IPI-exempt CHAR 1 0 J_1BTCIPI
XSUBT Customer group for Substituiçao Tributária calculation CHAR 3 0 J_1BTCST
CFOPC Customer's CFOP category CHAR 2 0 J_1BINDUS1
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1 Tax law: ICMS CHAR 3 0 J_1BTAXLW1
TXLW2 Tax law: IPI CHAR 3 0 J_1BTAXLW2
CCC01 Indicator for biochemical warfare for legal control CHAR 1 0 CCC01
CCC02 Indicator for nuclear nonproliferation for legal control CHAR 1 0 CCC02
CCC03 Indicator for national security for legal control CHAR 1 0 CCC03
CCC04 Indicator for missile technology for legal control CHAR 1 0 CCC04
CASSD Central sales block for customer CHAR 2 0 CASSD_X
KNURL Uniform resource locator CHAR 132 0 URL
PARNR Number of Contact Person NUMC 10 0 PARNR
NAMEV First name CHAR 35 0 NAMEV_VP
NAME1 Name 1 CHAR 35 0 NAME1_GP
ADRND Business address CHAR 10 0 ADRND
ADRNP Home address CHAR 10 0 ADRNP
ABTPA Contact person's department at customer CHAR 12 0 ABTEI_PA
ABTNR Contact person department CHAR 4 0 ABTNR_PA
UEPAR Higher-Level Partner NUMC 10 0 UEPAR
ANRED Form of address for contact person (Mr, Mrs...etc) CHAR 30 0 ANRED_AP
PAFKT Contact person function CHAR 2 0 PAFKT
PARVO Partner's Authority CHAR 1 0 PARVO
PAVIP VIP Partner CHAR 1 0 PAVIP
PARGE Partner's gender CHAR 1 0 PARGE
PARLA Partner language LANG 1 0 PARLA
GBDAT Date of Birth DATS 8 0 GBDAT
VRTNR Representative number NUMC 10 0 VTRNR
BRYTH Call frequency CHAR 4 0 BRYTH
AKVER Buying habits CHAR 2 0 AKVER
NMAIL Advertising material indicator CHAR 1 0 NMAIL
PARAU Notes about contact person CHAR 40 0 PARAU
PARH1 Contact person: Attribute 1 CHAR 2 0 PAAT1
PARH2 Contact person: Attribute 2 CHAR 2 0 PAAT2
PARH3 Contact person: Attribute 3 CHAR 2 0 PAAT3
PARH4 Contact person: Attribute 4 CHAR 2 0 PAAT4
PARH5 Contact person: Attribute 5 CHAR 2 0 PAAT5
MOAB1 Contact person's visiting hours: Monday morning from ... TIMS 6 0 BEMOAB1
MOBI1 Contact person's visiting hours: Monday morning until ... TIMS 6 0 BEMOBI1
MOAB2 Contact person's visiting hours: Monday afternoon from ... TIMS 6 0 BEMOAB2
MOBI2 Contact person's visiting hours: Monday afternoon until ... TIMS 6 0 BEMOBI2
DIAB1 Contact person's visiting hours: Tuesday morning from... TIMS 6 0 BEDIAB1
DIBI1 Contact person's visiting hours: Tuesday morning until ... TIMS 6 0 BEDIBI1
DIAB2 Contact person's visiting hours: Tuesday afternoon from.. TIMS 6 0 BEDIAB2
DIBI2 Contact person's visiting hours: Tuesday afternoon until ... TIMS 6 0 BEDIBI2
MIAB1 Contact person's visiting hours: Wednesday morning from... TIMS 6 0 BEMIAB1
MIBI1 Contact person's visiting hours: Wednesday morning until ... TIMS 6 0 BEMIBI1
MIAB2 Contact person's visiting hours: Wednesday afternoon from .. TIMS 6 0 BEMIAB2
MIBI2 Contact person's visiting hours: Wednesday afternoon until.. TIMS 6 0 BEMIBI2
DOAB1 Contact person's visiting hours: Thursday morning from .... TIMS 6 0 BEDOAB1
DOBI1 Contact person's visiting hours: Thursday morning until .... TIMS 6 0 BEDOBI1
DOAB2 Contact person's visiting hours: Thursday afternoon from... TIMS 6 0 BEDOAB2
DOBI2 Contact person's visiting hours: Thursday afternoon until .. TIMS 6 0 BEDOBI2
FRAB1 Contact person's visiting hours: Friday morning from ... TIMS 6 0 BEFRAB1
FRBI1 Contact person's visiting hours: Friday morning until ... TIMS 6 0 BEFRBI1
FRAB2 Contact person's visiting hours: Friday afternoon from ... TIMS 6 0 BEFRAB2
FRBI2 Contact person's visiting hours: Friday afternoon until ... TIMS 6 0 BEFRBI2
SAAB1 Contact person's visiting hours: Saturday morning from ... TIMS 6 0 BESAAB1
SABI1 Contact person's visiting hours: Saturday morning until ... TIMS 6 0 BESABI1
SAAB2 Contact person's visiting hours: Saturday afternoon from ... TIMS 6 0 BESAAB2
SABI2 Contact person's visiting hours: Saturday afternoon until .. TIMS 6 0 BESABI2
SOAB1 Contact person's visiting hours: Sunday morning from ... TIMS 6 0 BESOAB1
SOBI1 Contact person's visiting hours: Sunday morning until ... TIMS 6 0 BESOBI1
SOAB2 Contact person's visiting hours: Sunday afternoon from ... TIMS 6 0 BESOAB2
SOBI2 Contact person's visiting hours: Sunday afternoon until ... TIMS 6 0 BESOBI2
PAKN1 Contact person: Attribute 6 CHAR 3 0 PAAT6
PAKN2 Contact person: Attribute 7 CHAR 3 0 PAAT7
PAKN3 Contact person: Attribute 8 CHAR 3 0 PAAT8
PAKN4 Contact person: Attribute 9 CHAR 3 0 PAAT9
PAKN5 Contact person: Attribute 10 CHAR 3 0 PAAT0
SORTL Sort field CHAR 10 0 SORTL
FAMST Marital Status Key CHAR 1 0 FAMST
SPNAM Nickname CHAR 10 0 SPNAM
TITEL_AP Title of contact person (description of function) CHAR 35 0 TITEL_AP
KZHERK Internal indicator for origin of the CP: Customer or Vendor CHAR 1 0 KZHERK
ADRNP_2 Address Number CHAR 10 0 AD_ADDRNUM
PRSNR Person Number CHAR 10 0 AD_PERSNUM