1. Home
  2. Resources
  3. SAP Tables
  4. BIW_KNVK_S - Extraction Structure 0CONSUMER_ATTR

SAP Table BIW_KNVK_S

Extraction Structure 0CONSUMER_ATTR

BIW_KNVK_S (Extraction Structure 0CONSUMER_ATTR) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BIW_KNVK_S to other SAP tables.

Source: BIW_KNVK_S (Extraction Structure 0CONSUMER_ATTR)

BIW_KNVK_S table fields

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