1. Home
  2. Resources
  3. SAP Tables
  4. BKNVV - Customer master sales data (batch input structure)

SAP Table BKNVV

Customer master sales data (batch input structure)

BKNVV (Customer master sales data (batch input structure)) 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 BKNVV to other SAP tables.

Source: BKNVV (Customer master sales data (batch input structure))

BKNVV table fields

Field Data element Checktable Datatype Length Decimals
STYPE Batch Input Interface Record Type STYPE_BI CHAR 1 0
TBNAM Table Name TABNAME CHAR 30 0
BZIRK Sales district BZIRK CHAR 6 0
AWAHR Order probability of the item (batch input) AWAHR_BI CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
WAERS Currency WAERS_V02D CUKY 5 0
VKGRP Sales Group VKGRP CHAR 3 0
VSORT Item proposal VSORT CHAR 10 0
KDGRP Customer group KDGRP CHAR 2 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
KONDA Price group (customer) KONDA CHAR 2 0
KALKS Pricing procedure assigned to this customer KALKS CHAR 1 0
LPRIO Delivery priority (batch input) LPRIO_BI CHAR 2 0
PLTYP Price list type PLTYP CHAR 2 0
VERSG Customer Statistics Group STGKU CHAR 1 0
KZAZU Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
VSBED Shipping Conditions VSBED CHAR 2 0
CHSPL Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
VWERK Delivering Plant DWERK CHAR 4 0
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
ANTLF Maximum no.of permitted part.deliveries/item (batch input) ANTLF_BI CHAR 1 0
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
PERFK Invoice dates (calendar identification) PERFK CHAR 2 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
LOEVM Deletion flag for customer (sales level) LOEVM_V CHAR 1 0
X Yes
NULL No
AUFSD Customer order block (sales area) AUFSD_V TVAST CHAR 2 0
LIFSD Customer delivery block (sales area) LIFSD_V TVLS CHAR 2 0
FAKSD Billing block for customer (sales and distribution) FAKSD_V TVFS CHAR 2 0
BEGRU Authorization Group BEGRU CHAR 4 0
PERRL Invoice list schedule (calendar identification) PERRL CHAR 2 0
BOKRE Indicator: Customer Is Rebate-Relevant BOKRE CHAR 1 0
X Yes
NULL No
KURST Exchange Rate Type KURST CHAR 4 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
PRFRE Relevant for price determination ID PRFRE CHAR 1 0
X Yes
NULL No
KABSS Customer payment guarantee procedure KABSSCH_CM CHAR 4 0
KKBER Credit control area KKBER CHAR 4 0
CASSD Sales block for customer (sales area) CASSD_V CHAR 2 0
RDOFF Switch off rounding? RDOFF CHAR 1 0
X Yes
NULL No
KLABC Customer classification (ABC analysis) KLABC CHAR 2 0
AGREL Indicator: Relevant for agency business AGREL CHAR 1 0
X Yes
NULL No
MEGRU Unit of Measure Group MEGRU CHAR 4 0
UEBTO Overdelivery tolerance limit (BTCI) UEBTO_BI CHAR 4 0
UNTTO Underdelivery tolerance (BTCI) UNTTO_BI CHAR 4 0
UEBTK Unlimited overdelivery allowed UEBTK_V CHAR 1 0
X Yes
NULL No
PVKSM Customer procedure for product proposal PVKSM CHAR 2 0
PODKZ Relevant for POD processing PODKZ CHAR 1 0
X Yes
NULL No
PODTG Timeframe for Confirmation of POD (BI) PODTG_BI CHAR 11 0
BLIND Index Structure Active for Subsequent Settlement (in AB) BLIND_SD CHAR 1 0
X Yes
NULL No
CARRIER_NOTIF Carrier is to be notified /SPE/CARRIER_NOTIF CHAR 1 0
X Yes
NULL No
OIABTNR Contact person: Department BTCI OIDABT_BI CHAR 4 0
OIPAFKT Contact person function BTCI OIDPFKT_BI CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OIC_HOBIND Head office / branch Indicator BTCI OICHOBI_BI CHAR 1 0
X Yes
NULL No
OIC_MOT IS-OIL MAP external details mode of transport BTCI^ OIC_MOT_BI CHAR 2 0
OIINEX Code for internal or external excise duty rate determination OIH_INEX CHAR 2 0
OIGROUPNAM TD:customer compatibility group OIG_CCG_BI CHAR 8 0
OIPFLIC IS-OIL partner function for tax exemption license OIH_PFLIC CHAR 2 0
OIHCGROUP Customer tax group OIH_J1B_CTXGR CHAR 4 0
OILASTOR Last order number OID_LASTOR CHAR 10 0
SENDE Record End Indicator for Batch Input Interface SENDE_BI CHAR 1 0

BKNVV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BKNVV AUFSD SYST MANDT TVAST Sales Document Blocking Reasons: Texts MANDT
BKNVV AUFSD SYST LANGU TVAST Sales Document Blocking Reasons: Texts SPRAS
BKNVV AUFSD BKNVV AUFSD TVAST Sales Document Blocking Reasons: Texts AUFSP
BKNVV FAKSD SYST MANDT TVFS Billing: Reasons for Blocking MANDT
BKNVV FAKSD BKNVV FAKSD TVFS Billing: Reasons for Blocking FAKSP
BKNVV LIFSD SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
BKNVV LIFSD BKNVV LIFSD TVLS Deliveries: Blocking Reasons/Criteria LIFSP