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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_O2C_SLS (Package) ERP Sales Order 2 Cash - Sales

Basic Data

Table Category	INTTAB	Structure
Structure	TDS_CUSTOMER	Table Relationship Diagram
Short Description	Customer Master Data: Sales Area and Address Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
2	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
3	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
4	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
5	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
6	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
7	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
8	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
9	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
10	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
11	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
12	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
13	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
14	STREET_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
15	PCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
17	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
18	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
19	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
20	AUFSDZ	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
21	AUFSDV	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)	*
22	LIFSDZ	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
23	LIFSDV	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	*
24	FAKSDZ	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
25	FAKSDV	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	*
26	LOEVMZ	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
27	LOEVMV	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
28	NODEL	☐	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record
29	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
30	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
31	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
32	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
33	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
34	HOMEPAGE	☐	HOMEPAGE	AD_URI	LCHR	2048	0	Homepage URL
35	HOMEPAGE_REF	☐	HOMEPAGE	AD_URI	LCHR	2048	0	Homepage URL
36	SDEMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
37	SDEMAIL_REF	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
38	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
39	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
40	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
41	VKORG_T	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
42	VTWEG_T	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
43	SPART_T	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
44	VKBUR_T	☐	VKBUR_BEZ	TEXT20	CHAR	20	0	Description of sales office
45	VKGRP_T	☐	VKGRP_BEZ	TEXT20	CHAR	20	0	Description of Sales Group
46	BUKRS_T	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
47	KUKLA_T	☐	KUKLA_BEZ	TEXT20	CHAR	20	0	Customer Classification Description
48	KDGRP_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TDS_CUSTOMER	AUFSDZ	TVAST	AUFSP
2	TDS_CUSTOMER	FAKSDZ	TVFS	FAKSP
3	TDS_CUSTOMER	KUKLA	TKUKL	KUKLA
4	TDS_CUSTOMER	LIFSDZ	TVLS	LIFSP

History

Last changed by/on	SAP	20110901
SAP Release Created in	602