SAP table TDS_CUSTOMER (Customer Master Data: Sales Area and Address Data)

Field Description Data Type Length Decimals Checktable Data Element
KUNNR Customer Number CHAR 10 0 * KUNNR
VKORG Sales Organization CHAR 4 0 * VKORG
VTWEG Distribution Channel CHAR 2 0 * VTWEG
SPART Division CHAR 2 0 * SPART
VKBUR Sales office CHAR 4 0 * VKBUR
VKGRP Sales group CHAR 3 0 * VKGRP
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
SORTL Sort field CHAR 10 0 SORTL
NAME Name 1 CHAR 35 0 NAME1_GP
STREET Street CHAR 60 0 AD_STREET
MC_STREET Street Name in Uppercase for Search Help CHAR 25 0 AD_MC_STRT
STREET_NO House Number CHAR 10 0 AD_HSNM1
PCODE Postal Code CHAR 10 0 PSTLZ
CITY City CHAR 35 0 ORT01_GP
COUNTRY Country/Region Key CHAR 3 0 * LAND1_GP
REGION Region (State, Province, County) CHAR 3 0 * REGIO
TELF1 First telephone number CHAR 16 0 TELF1
AUFSDZ Central order block for customer CHAR 2 0 TVAST AUFSD_X
AUFSDV Customer order block (sales area) CHAR 2 0 * AUFSD_V
LIFSDZ Central delivery block for the customer CHAR 2 0 TVLS LIFSD_X
LIFSDV Customer delivery block (sales area) CHAR 2 0 * LIFSD_V
FAKSDZ Central billing block for customer CHAR 2 0 TVFS FAKSD_X
FAKSDV Billing block for customer (sales and distribution) CHAR 2 0 * FAKSD_V
LOEVMZ Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
LOEVMV Deletion flag for customer (sales level) CHAR 1 0 LOEVM_V
NODEL Central deletion block for master record CHAR 1 0 NODEL_X
BUKRS Company Code CHAR 4 0 * BUKRS
NAME2 Name 2 CHAR 35 0 NAME2_GP
KLABC Customer classification (ABC analysis) CHAR 2 0 KLABC
KDGRP Customer Group CHAR 2 0 * KDGRP
KUKLA Customer Classification CHAR 2 0 TKUKL KUKLA
HOMEPAGE Homepage URL LCHR 2048 0 HOMEPAGE
HOMEPAGE_REF Homepage URL LCHR 2048 0 HOMEPAGE
SDEMAIL E-Mail Address CHAR 241 0 AD_SMTPADR
SDEMAIL_REF E-Mail Address CHAR 241 0 AD_SMTPADR
TELFX Fax Number CHAR 31 0 TELFX
BEGRU Authorization Group CHAR 4 0 BEGRU
KTOKD Customer Account Group CHAR 4 0 * KTOKD
VKORG_T Description of sales organization CHAR 20 0 VKORG_BEZ
VTWEG_T Description of distribution channel CHAR 20 0 VTWEG_BEZ
SPART_T Description of division CHAR 20 0 SPART_BEZ
VKBUR_T Description of sales office CHAR 20 0 VKBUR_BEZ
VKGRP_T Description of Sales Group CHAR 20 0 VKGRP_BEZ
BUKRS_T Name of Company Code or Company CHAR 25 0 BUTXT
KUKLA_T Customer Classification Description CHAR 20 0 KUKLA_BEZ
KDGRP_T Description CHAR 20 0 BEZEI20

TDS_CUSTOMER foreign key relationships

Table Field Check Table Check Field
0 TDS_CUSTOMER AUFSDZ TVAST Sales Document Blocking Reasons: Texts MANDT
0 TDS_CUSTOMER AUFSDZ TVAST Sales Document Blocking Reasons: Texts SPRAS
1 TDS_CUSTOMER FAKSDZ TVFS Billing: Reasons for Blocking FAKSP
0 TDS_CUSTOMER KUKLA TKUKL Customers: Customer Classifications KUKLA
1 TDS_CUSTOMER LIFSDZ TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 TDS_CUSTOMER LIFSDZ TVLS Deliveries: Blocking Reasons/Criteria LIFSP