1. Home
  2. Resources
  3. SAP Tables
  4. BAPIBUSISM007_CUST_SALES - IS-M: Business Partner Customer Master Sales & Dist. (KNVV)

SAP Table BAPIBUSISM007_CUST_SALES

IS-M: Business Partner Customer Master Sales & Dist. (KNVV)

BAPIBUSISM007_CUST_SALES (IS-M: Business Partner Customer Master Sales & Dist. (KNVV)) 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 BAPIBUSISM007_CUST_SALES to other SAP tables.

BAPIBUSISM007_CUST_SALES table fields

Field Data element Checktable Datatype Length Decimals
SALESORG Sales Organization VKORG TVKO CHAR 4 0
DISTR_CHAN Distribution Channel VTWEG TVTW CHAR 2 0
DIVISION Division SPART TSPA CHAR 2 0
CUSTSTATGR Customer Statistics Group STGKU TVSD CHAR 1 0
PRC_PROCED Pricing procedure assigned to this customer KALKS TVKD CHAR 1 0
CUST_GROUP Customer group KDGRP T151 CHAR 2 0
PRICE_GRP Price group (customer) KONDA T188 CHAR 2 0
PRICE_LIST Price list type PLTYP T189 CHAR 2 0
COMPL_DLV Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
MAX_PL_DLV Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
SHIP_COND Shipping Conditions VSBED TVSB CHAR 2 0
BILL_SCHED Invoice dates (calendar identification) PERFK TFACD CHAR 2 0
CURRENCY Currency WAERS_V02D TCURC CUKY 5 0
ACCNT_ASGN Account assignment group for this customer KTGRD TVKT CHAR 2 0
PMNTTRMS Terms of Payment Key DZTERM CHAR 4 0
DELYG_PLNT Delivering Plant DWERK TVKWZ CHAR 4 0
EXCHG_RATE Exchange Rate Type KURST TCURV CHAR 4 0
PART_DLV 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
C_CTR_AREA Credit control area KKBER T014 CHAR 4 0
AUTHORITYGROUP Authorization Group BEGRU CHAR 4 0
ORDER_BLK Customer order block (sales area) AUFSD_V TVAST CHAR 2 0
SALES_DIST Sales district BZIRK T171 CHAR 6 0
ORDER_PROB Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
INCOTERMS1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCOTERMS2 Incoterms (Part 2) INCO2 CHAR 28 0
DLV_BLOCK Customer delivery block (sales area) LIFSD_V TVLS CHAR 2 0
ORDCOMBIND Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
DLV_PRIO Delivery Priority LPRIO TPRIO NUMC 2 0
ACCT_AT_PARTNER Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
BILL_BLOCK Billing block for customer (sales and distribution) FAKSD_V TVFS CHAR 2 0
MN_INVOICE Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
INVO_SCHED Invoice list schedule (calendar identification) PERRL TFACD CHAR 2 0
ABC_CLASS Customer classification (ABC analysis) KLABC CHAR 2 0
SALES_GRP Sales Group VKGRP TVKGR CHAR 3 0
SALES_OFF Sales Office VKBUR TVBUR CHAR 4 0
PROD_PROP Item proposal VSORT VBUK CHAR 10 0
CUST_GRP1 Customer group 1 KVGR1 TVV1 CHAR 3 0
CUST_GRP2 Customer group 2 KVGR2 TVV2 CHAR 3 0
CUST_GRP3 Customer group 3 KVGR3 TVV3 CHAR 3 0
CUST_GRP4 Customer group 4 KVGR4 TVV4 CHAR 3 0
CUST_GRP5 Customer group 5 KVGR5 TVV5 CHAR 3 0
REBATE_REL Indicator: Customer Is Rebate-Relevant BOKRE CHAR 1 0
X Yes
NULL No
PRIC_REL Relevant for price determination ID PRFRE CHAR 1 0
X Yes
NULL No
PAYGUAPROC Customer payment guarantee procedure KABSSCH_CM T691P CHAR 4 0
SLSACT_BLK Sales block for customer (sales area) CASSD_V CHAR 2 0
RDG_OFF Switch off rounding? RDOFF CHAR 1 0
X Yes
NULL No
AGCY_BUSN Indicator: Relevant for agency business AGREL CHAR 1 0
X Yes
NULL No
UNIT_GROUP Unit of Measure Group MEGRU TWMEG CHAR 4 0
OVER_DLV_TOL Overdelivery Tolerance Limit UEBTO DEC 3 1
UNDER_DLV_TOL Underdelivery Tolerance Limit UNTTO DEC 3 1
DELI_UNLIM_TOL Unlimited overdelivery allowed UEBTK_V CHAR 1 0
X Yes
NULL No
PROD_PROP_PROCED Customer procedure for product proposal PVKSM TPVD CHAR 2 0
POD_RELEVANT Relevant for POD processing PODKZ CHAR 1 0
X Yes
NULL No
POD_TIMEFRAME Timeframe for Confirmation of POD PODTG DEC 11 0
MONITORING_PROCEDURE IS-M/SD: Customer Procedure for Monitoring KSREMIND TJGKS CHAR 2 0

BAPIBUSISM007_CUST_SALES foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIBUSISM007_CUST_SALES ACCNT_ASGN SYST MANDT TVKT Customers: Account Assignment Groups MANDT
BAPIBUSISM007_CUST_SALES ACCNT_ASGN BAPIBUSISM007_CUST_SALES ACCNT_ASGN TVKT Customers: Account Assignment Groups KTGRD
BAPIBUSISM007_CUST_SALES BILL_BLOCK SYST MANDT TVFS Billing: Reasons for Blocking MANDT
BAPIBUSISM007_CUST_SALES BILL_BLOCK BAPIBUSISM007_CUST_SALES BILL_BLOCK TVFS Billing: Reasons for Blocking FAKSP
BAPIBUSISM007_CUST_SALES BILL_SCHED BAPIBUSISM007_CUST_SALES BILL_SCHED TFACD Factory calendar definition IDENT
BAPIBUSISM007_CUST_SALES CURRENCY SYST MANDT TCURC Currency Codes MANDT
BAPIBUSISM007_CUST_SALES CURRENCY BAPIBUSISM007_CUST_SALES CURRENCY TCURC Currency Codes WAERS
BAPIBUSISM007_CUST_SALES CUSTSTATGR SYST MANDT TVSD Customers: Statistics groups MANDT
BAPIBUSISM007_CUST_SALES CUSTSTATGR BAPIBUSISM007_CUST_SALES CUSTSTATGR TVSD Customers: Statistics groups STGKU
BAPIBUSISM007_CUST_SALES CUST_GROUP SYST MANDT T151 Customers: Customer Groups MANDT
BAPIBUSISM007_CUST_SALES CUST_GROUP BAPIBUSISM007_CUST_SALES CUST_GROUP T151 Customers: Customer Groups KDGRP
BAPIBUSISM007_CUST_SALES CUST_GRP1 SYST MANDT TVV1 Customer Group 1 MANDT
BAPIBUSISM007_CUST_SALES CUST_GRP1 BAPIBUSISM007_CUST_SALES CUST_GRP1 TVV1 Customer Group 1 KVGR1
BAPIBUSISM007_CUST_SALES CUST_GRP2 SYST MANDT TVV2 Customer Group 2 MANDT
BAPIBUSISM007_CUST_SALES CUST_GRP2 BAPIBUSISM007_CUST_SALES CUST_GRP2 TVV2 Customer Group 2 KVGR2
BAPIBUSISM007_CUST_SALES CUST_GRP3 SYST MANDT TVV3 Customer Group 3 MANDT
BAPIBUSISM007_CUST_SALES CUST_GRP3 BAPIBUSISM007_CUST_SALES CUST_GRP3 TVV3 Customer Group 3 KVGR3
BAPIBUSISM007_CUST_SALES CUST_GRP4 SYST MANDT TVV4 Customer Group 4 MANDT
BAPIBUSISM007_CUST_SALES CUST_GRP4 BAPIBUSISM007_CUST_SALES CUST_GRP4 TVV4 Customer Group 4 KVGR4
BAPIBUSISM007_CUST_SALES CUST_GRP5 BAPIBUSISM007_CUST_SALES CUST_GRP5 TVV5 Customer Group 5 KVGR5
BAPIBUSISM007_CUST_SALES CUST_GRP5 SYST MANDT TVV5 Customer Group 5 MANDT
BAPIBUSISM007_CUST_SALES C_CTR_AREA SYST MANDT T014 Credit control areas MANDT
BAPIBUSISM007_CUST_SALES C_CTR_AREA BAPIBUSISM007_CUST_SALES C_CTR_AREA T014 Credit control areas KKBER
BAPIBUSISM007_CUST_SALES DELYG_PLNT SYST MANDT TVKWZ Org.Unit: Allowed Plants per Sales Organization MANDT
BAPIBUSISM007_CUST_SALES DELYG_PLNT BAPIBUSISM007_CUST_SALES SALESORG TVKWZ Org.Unit: Allowed Plants per Sales Organization VKORG
BAPIBUSISM007_CUST_SALES DELYG_PLNT BAPIBUSISM007_CUST_SALES DISTR_CHAN TVKWZ Org.Unit: Allowed Plants per Sales Organization VTWEG
BAPIBUSISM007_CUST_SALES DELYG_PLNT BAPIBUSISM007_CUST_SALES DELYG_PLNT TVKWZ Org.Unit: Allowed Plants per Sales Organization WERKS
BAPIBUSISM007_CUST_SALES DISTR_CHAN BAPIBUSISM007_CUST_SALES DISTR_CHAN TVTW Organizational Unit: Distribution Channels VTWEG
BAPIBUSISM007_CUST_SALES DISTR_CHAN SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
BAPIBUSISM007_CUST_SALES DIVISION BAPIBUSISM007_CUST_SALES DIVISION TSPA Organizational Unit: Sales Divisions SPART
BAPIBUSISM007_CUST_SALES DIVISION SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
BAPIBUSISM007_CUST_SALES DLV_BLOCK BAPIBUSISM007_CUST_SALES DLV_BLOCK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
BAPIBUSISM007_CUST_SALES DLV_BLOCK SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
BAPIBUSISM007_CUST_SALES DLV_PRIO SYST MANDT TPRIO Customers: Delivery Priorities MANDT
BAPIBUSISM007_CUST_SALES DLV_PRIO BAPIBUSISM007_CUST_SALES DLV_PRIO TPRIO Customers: Delivery Priorities LPRIO
BAPIBUSISM007_CUST_SALES EXCHG_RATE SYST MANDT TCURV Exchange rate types for currency translation MANDT
BAPIBUSISM007_CUST_SALES EXCHG_RATE BAPIBUSISM007_CUST_SALES EXCHG_RATE TCURV Exchange rate types for currency translation KURST
BAPIBUSISM007_CUST_SALES INCOTERMS1 SYST MANDT TINC Customers: Incoterms MANDT
BAPIBUSISM007_CUST_SALES INCOTERMS1 BAPIBUSISM007_CUST_SALES INCOTERMS1 TINC Customers: Incoterms INCO1
BAPIBUSISM007_CUST_SALES INVO_SCHED BAPIBUSISM007_CUST_SALES INVO_SCHED TFACD Factory calendar definition IDENT
BAPIBUSISM007_CUST_SALES MONITORING_PROCEDURE SYST MANDT TJGKS IS-M/SD: Customer Procedure for Monitoring MANDT
BAPIBUSISM007_CUST_SALES MONITORING_PROCEDURE BAPIBUSISM007_CUST_SALES MONITORING_PROCEDURE TJGKS IS-M/SD: Customer Procedure for Monitoring KSREMIND
BAPIBUSISM007_CUST_SALES ORDER_BLK SYST MANDT TVAST Sales Document Blocking Reasons: Texts MANDT
BAPIBUSISM007_CUST_SALES ORDER_BLK SYST LANGU TVAST Sales Document Blocking Reasons: Texts SPRAS
BAPIBUSISM007_CUST_SALES ORDER_BLK BAPIBUSISM007_CUST_SALES ORDER_BLK TVAST Sales Document Blocking Reasons: Texts AUFSP
BAPIBUSISM007_CUST_SALES PAYGUAPROC BAPIBUSISM007_CUST_SALES PAYGUAPROC T691P Customer payment guarantee procedure KABSS
BAPIBUSISM007_CUST_SALES PAYGUAPROC SYST MANDT T691P Customer payment guarantee procedure MANDT
BAPIBUSISM007_CUST_SALES PRC_PROCED SYST MANDT TVKD Customer Pricing Procedures MANDT
BAPIBUSISM007_CUST_SALES PRC_PROCED BAPIBUSISM007_CUST_SALES PRC_PROCED TVKD Customer Pricing Procedures KALKS
BAPIBUSISM007_CUST_SALES PRICE_GRP SYST MANDT T188 Conditions: Groups for Customer Classifications MANDT
BAPIBUSISM007_CUST_SALES PRICE_GRP BAPIBUSISM007_CUST_SALES PRICE_GRP T188 Conditions: Groups for Customer Classifications KONDA
BAPIBUSISM007_CUST_SALES PRICE_LIST SYST MANDT T189 Conditions: Price List Categories MANDT
BAPIBUSISM007_CUST_SALES PRICE_LIST BAPIBUSISM007_CUST_SALES PRICE_LIST T189 Conditions: Price List Categories PLTYP
BAPIBUSISM007_CUST_SALES PROD_PROP SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BAPIBUSISM007_CUST_SALES PROD_PROP BAPIBUSISM007_CUST_SALES PROD_PROP VBUK Sales Document: Header Status and Administrative Data VBELN
BAPIBUSISM007_CUST_SALES PROD_PROP_PROCED SYST MANDT TPVD Product Proposal: Definition of Customer Procedure MANDT
BAPIBUSISM007_CUST_SALES PROD_PROP_PROCED BAPIBUSISM007_CUST_SALES PROD_PROP_PROCED TPVD Product Proposal: Definition of Customer Procedure PVKSM
BAPIBUSISM007_CUST_SALES SALESORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
BAPIBUSISM007_CUST_SALES SALESORG BAPIBUSISM007_CUST_SALES SALESORG TVKO Organizational Unit: Sales Organizations VKORG
BAPIBUSISM007_CUST_SALES SALES_DIST SYST MANDT T171 Customers: Sales Districts MANDT
BAPIBUSISM007_CUST_SALES SALES_DIST BAPIBUSISM007_CUST_SALES SALES_DIST T171 Customers: Sales Districts BZIRK
BAPIBUSISM007_CUST_SALES SALES_GRP BAPIBUSISM007_CUST_SALES SALES_GRP TVKGR Organizational Unit: Sales Groups VKGRP
BAPIBUSISM007_CUST_SALES SALES_GRP SYST MANDT TVKGR Organizational Unit: Sales Groups MANDT
BAPIBUSISM007_CUST_SALES SALES_OFF BAPIBUSISM007_CUST_SALES SALES_OFF TVBUR Organizational Unit: Sales Offices VKBUR
BAPIBUSISM007_CUST_SALES SALES_OFF SYST MANDT TVBUR Organizational Unit: Sales Offices MANDT
BAPIBUSISM007_CUST_SALES SHIP_COND SYST MANDT TVSB Shipping Conditions MANDT
BAPIBUSISM007_CUST_SALES SHIP_COND BAPIBUSISM007_CUST_SALES SHIP_COND TVSB Shipping Conditions VSBED
BAPIBUSISM007_CUST_SALES UNIT_GROUP SYST MANDT TWMEG Unit of measure group MANDT
BAPIBUSISM007_CUST_SALES UNIT_GROUP BAPIBUSISM007_CUST_SALES UNIT_GROUP TWMEG Unit of measure group MEGRU
BAPIBUSISM007_CUST_SALES UNIT_GROUP * TWMEG Unit of measure group MEINS