1. Home
  2. Resources
  3. SAP Tables
  4. TDS_CUSTOMER - Customer Master Data: Sales Area and Address Data

SAP Table TDS_CUSTOMER

Customer Master Data: Sales Area and Address Data

TDS_CUSTOMER (Customer Master Data: Sales Area and Address Data) 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 TDS_CUSTOMER to other SAP tables.

Source: TDS_CUSTOMER (Customer Master Data: Sales Area and Address Data)

TDS_CUSTOMER table fields

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

TDS_CUSTOMER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TDS_CUSTOMER AUFSDZ SYST MANDT TVAST Sales Document Blocking Reasons: Texts MANDT
TDS_CUSTOMER AUFSDZ * TVAST Sales Document Blocking Reasons: Texts SPRAS
TDS_CUSTOMER AUFSDZ TDS_CUSTOMER AUFSDZ TVAST Sales Document Blocking Reasons: Texts AUFSP
TDS_CUSTOMER FAKSDZ SYST MANDT TVFS Billing: Reasons for Blocking MANDT
TDS_CUSTOMER FAKSDZ TDS_CUSTOMER FAKSDZ TVFS Billing: Reasons for Blocking FAKSP
TDS_CUSTOMER KUKLA SYST MANDT TKUKL Customers: Customer Classifications MANDT
TDS_CUSTOMER KUKLA TDS_CUSTOMER KUKLA TKUKL Customers: Customer Classifications KUKLA
TDS_CUSTOMER LIFSDZ SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
TDS_CUSTOMER LIFSDZ TDS_CUSTOMER LIFSDZ TVLS Deliveries: Blocking Reasons/Criteria LIFSP