1. Home
  2. Resources
  3. SAP Tables
  4. BAPISOLDTO - Sold-to Party View of the Customer Master Record

SAP Table BAPISOLDTO

Sold-to Party View of the Customer Master Record

BAPISOLDTO (Sold-to Party View of the Customer Master Record) 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 BAPISOLDTO to other SAP tables.

Source: BAPISOLDTO (Sold-to Party View of the Customer Master Record)

BAPISOLDTO table fields

Field Data element Checktable Datatype Length Decimals
SOLD_TO Sold-to party KUNAG KNA1 CHAR 10 0
NAME Name 1 NAME1_GP CHAR 35 0
STREET House number and street STRAS CHAR 30 0
PO_BOX PO Box PFACH CHAR 10 0
POSTL_CODE Postal Code PSTLZ CHAR 10 0
POBX_PCD P.O. Box Postal Code PSTL2 CHAR 10 0
CITY City ORT01 CHAR 25 0
LANGU Language Key SPRAS T002 LANG 1 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
TELEPHONE First telephone number TELF1 CHAR 16 0
STAT_GROUP Statistics group VERSG TVSG CHAR 1 0
ORDER_BLCK Customer blocked for orders AUFSD TVAST CHAR 2 0
PRC_PROCED Pricing procedure assigned to this customer KALKS TVKD CHAR 1 0
CUST_GROUP Customer group KDGRP T151 CHAR 2 0
SALES_DIST Sales district BZIRK T171 CHAR 6 0
PRICE_GRP Price group (customer) KONDA T188 CHAR 2 0
PRICE_LIST Price list type PLTYP T189 CHAR 2 0
INCOTERMS1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCOTERMS2 Incoterms (Part 2) INCO2 CHAR 28 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
ORDER_COMB Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
BTCH_SPLIT Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
DLV_PRIO Delivery Priority LPRIO TPRIO NUMC 2 0
CURRENCY SD Document Currency WAERK TCURC CUKY 5 0
EXCHG_RATE Exchange Rate Type KURST TCURV CHAR 4 0
SHIP_COND Shipping Conditions VSBED TVSB CHAR 2 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
ORDER_PROB Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
DLV_BLOCK Customer delivery block (sales area) LIFSD_V TVLS CHAR 2 0
PROD_PROP Item proposal VSORT VBUK CHAR 10 0
ACC_1_TIME Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
SALES_OFF Sales Office VKBUR TVBUR CHAR 4 0
SALES_GRP Sales Group VKGRP TVKGR CHAR 3 0
VAT_REG_NO VAT Registration Number STCEG CHAR 20 0
TAX_CLASS1 Tax classification 1 for customer TAXK1 TSKD CHAR 1 0
TAX_CLASS2 Tax classification 2 for customer TAXK2 TSKD CHAR 1 0
TAX_CLASS3 Tax classification 3 for customer TAXK3 TSKD CHAR 1 0
TAX_CLASS4 Tax Classification 4 Customer TAXK4 TSKD CHAR 1 0
TAX_CLASS5 Tax classification 5 for customer TAXK5 TSKD CHAR 1 0
TAX_CLASS6 Tax classification 6 for customer TAXK6 TSKD CHAR 1 0
TAX_CLASS7 Tax classification 7 for customer TAXK7 TSKD CHAR 1 0
TAX_CLASS8 Tax classification 8 for customer TAXK8 TSKD CHAR 1 0
TAX_CLASS9 Tax classification 9 for customer TAXK9 TSKD CHAR 1 0
COMPANY_ID Company ID VBUND T880 CHAR 6 0

BAPISOLDTO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPISOLDTO COMPANY_ID SYST MANDT T880 Global Company Data (for KONS Ledger) MANDT
BAPISOLDTO COMPANY_ID BAPISOLDTO COMPANY_ID T880 Global Company Data (for KONS Ledger) RCOMP
BAPISOLDTO COUNTRY SYST MANDT T005 Countries MANDT
BAPISOLDTO COUNTRY BAPISOLDTO COUNTRY T005 Countries LAND1
BAPISOLDTO CURRENCY BAPISOLDTO CURRENCY TCURC Currency Codes WAERS
BAPISOLDTO CURRENCY SYST MANDT TCURC Currency Codes MANDT
BAPISOLDTO CUST_GROUP SYST MANDT T151 Customers: Customer Groups MANDT
BAPISOLDTO CUST_GROUP BAPISOLDTO CUST_GROUP T151 Customers: Customer Groups KDGRP
BAPISOLDTO DLV_BLOCK BAPISOLDTO DLV_BLOCK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
BAPISOLDTO DLV_BLOCK SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
BAPISOLDTO DLV_PRIO BAPISOLDTO DLV_PRIO TPRIO Customers: Delivery Priorities LPRIO
BAPISOLDTO DLV_PRIO SYST MANDT TPRIO Customers: Delivery Priorities MANDT
BAPISOLDTO EXCHG_RATE SYST MANDT TCURV Exchange rate types for currency translation MANDT
BAPISOLDTO EXCHG_RATE BAPISOLDTO EXCHG_RATE TCURV Exchange rate types for currency translation KURST
BAPISOLDTO INCOTERMS1 BAPISOLDTO INCOTERMS1 TINC Customers: Incoterms INCO1
BAPISOLDTO INCOTERMS1 SYST MANDT TINC Customers: Incoterms MANDT
BAPISOLDTO LANGU BAPISOLDTO LANGU T002 Language Keys (Component BC-I18) SPRAS
BAPISOLDTO ORDER_BLCK BAPISOLDTO ORDER_BLCK TVAST Sales Document Blocking Reasons: Texts AUFSP
BAPISOLDTO ORDER_BLCK SYST MANDT TVAST Sales Document Blocking Reasons: Texts MANDT
BAPISOLDTO ORDER_BLCK BAPISOLDTO LANGU TVAST Sales Document Blocking Reasons: Texts SPRAS
BAPISOLDTO PRC_PROCED SYST MANDT TVKD Customer Pricing Procedures MANDT
BAPISOLDTO PRC_PROCED BAPISOLDTO PRC_PROCED TVKD Customer Pricing Procedures KALKS
BAPISOLDTO PRICE_GRP SYST MANDT T188 Conditions: Groups for Customer Classifications MANDT
BAPISOLDTO PRICE_GRP BAPISOLDTO PRICE_GRP T188 Conditions: Groups for Customer Classifications KONDA
BAPISOLDTO PRICE_LIST SYST MANDT T189 Conditions: Price List Categories MANDT
BAPISOLDTO PRICE_LIST BAPISOLDTO PRICE_LIST T189 Conditions: Price List Categories PLTYP
BAPISOLDTO PROD_PROP BAPISOLDTO PROD_PROP VBUK Sales Document: Header Status and Administrative Data VBELN
BAPISOLDTO PROD_PROP SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
BAPISOLDTO SALES_DIST SYST MANDT T171 Customers: Sales Districts MANDT
BAPISOLDTO SALES_DIST BAPISOLDTO SALES_DIST T171 Customers: Sales Districts BZIRK
BAPISOLDTO SALES_GRP BAPISOLDTO SALES_GRP TVKGR Organizational Unit: Sales Groups VKGRP
BAPISOLDTO SALES_GRP SYST MANDT TVKGR Organizational Unit: Sales Groups MANDT
BAPISOLDTO SALES_OFF BAPISOLDTO SALES_OFF TVBUR Organizational Unit: Sales Offices VKBUR
BAPISOLDTO SALES_OFF SYST MANDT TVBUR Organizational Unit: Sales Offices MANDT
BAPISOLDTO SHIP_COND SYST MANDT TVSB Shipping Conditions MANDT
BAPISOLDTO SHIP_COND BAPISOLDTO SHIP_COND TVSB Shipping Conditions VSBED
BAPISOLDTO SOLD_TO SYST MANDT KNA1 General Data in Customer Master MANDT
BAPISOLDTO SOLD_TO BAPISOLDTO SOLD_TO KNA1 General Data in Customer Master KUNNR
BAPISOLDTO STAT_GROUP SYST MANDT TVSG Sales Statistics Groups MANDT
BAPISOLDTO STAT_GROUP BAPISOLDTO STAT_GROUP TVSG Sales Statistics Groups VERSG
BAPISOLDTO TAX_CLASS1 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS1 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS1 BAPISOLDTO TAX_CLASS1 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS2 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS2 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS2 BAPISOLDTO TAX_CLASS2 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS3 BAPISOLDTO TAX_CLASS3 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS3 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS3 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS4 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS4 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS4 BAPISOLDTO TAX_CLASS4 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS5 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS5 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS5 BAPISOLDTO TAX_CLASS5 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS6 BAPISOLDTO TAX_CLASS6 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS6 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS6 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS7 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS7 BAPISOLDTO TAX_CLASS7 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS7 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS8 BAPISOLDTO TAX_CLASS8 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS8 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS8 SYST MANDT TSKD Customer Taxes MANDT
BAPISOLDTO TAX_CLASS9 BAPISOLDTO TAX_CLASS9 TSKD Customer Taxes TAXKD
BAPISOLDTO TAX_CLASS9 * TSKD Customer Taxes TATYP
BAPISOLDTO TAX_CLASS9 SYST MANDT TSKD Customer Taxes MANDT