SAP TDS_CUSTOMER table - Customer Master Data: Sales Area and Address Data details in SAP


SAP TDS_CUSTOMER table summary

Object Name: TDS_CUSTOMER
Dictionary Type: Structure
Description: Customer Master Data: Sales Area and Address Data


Field list for TDS_CUSTOMER table on an S/4 SAP system

Details
TDS_CUSTOMER-KUNNR table field - Customer Number

Description: Customer Number
Field Name: KUNNR
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field KUNNR

TDS_CUSTOMER-VKORG table field - Sales Organization

Description: Sales Organization
Field Name: VKORG
Data Element: VKORG
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: VKORG
MemoryID: VKO
AppClass: MG
SHLP: C_VKORG
SHLP Field: VKORG
ConvExit:

See all SAP tables containing field VKORG

TDS_CUSTOMER-VTWEG table field - Distribution Channel

Description: Distribution Channel
Field Name: VTWEG
Data Element: VTWEG
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: VTWEG
MemoryID: VTW
AppClass: MG
SHLP: C_VTWEG
SHLP Field: VTWEG
ConvExit:

See all SAP tables containing field VTWEG

TDS_CUSTOMER-SPART table field - Division

Description: Division
Field Name: SPART
Data Element: SPART
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: SPART
MemoryID: SPA
AppClass: V
SHLP: C_SPART
SHLP Field: SPART
ConvExit:

See all SAP tables containing field SPART

TDS_CUSTOMER-VKBUR table field - Sales office

Description: Sales office
Field Name: VKBUR
Data Element: VKBUR
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: VKBUR
MemoryID: VKB
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VKBUR

TDS_CUSTOMER-VKGRP table field - Sales group

Description: Sales group
Field Name: VKGRP
Data Element: VKGRP
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: VKGRP
MemoryID: VKG
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VKGRP

TDS_CUSTOMER-MCOD1 table field - Search term for matchcode search

Description: Search term for matchcode search
Field Name: MCOD1
Data Element: MCDD1
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCOD1

TDS_CUSTOMER-MCOD2 table field - Search Term for Matchcode Search

Description: Search Term for Matchcode Search
Field Name: MCOD2
Data Element: MCDD2
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCOD2

TDS_CUSTOMER-MCOD3 table field - Search term for matchcode search

Description: Search term for matchcode search
Field Name: MCOD3
Data Element: MCDD3
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MCOD3

TDS_CUSTOMER-SORTL table field - Sort field

Description: Sort field
Field Name: SORTL
Data Element: SORTL
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORTL

TDS_CUSTOMER-NAME table field - Name 1

Description: Name 1
Field Name: NAME
Data Element: NAME1_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

TDS_CUSTOMER-STREET table field - Street

Description: Street
Field Name: STREET
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET

TDS_CUSTOMER-MC_STREET table field - Street Name in Uppercase for Search Help

Description: Street Name in Uppercase for Search Help
Field Name: MC_STREET
Data Element: AD_MC_STRT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MC_STREET

TDS_CUSTOMER-STREET_NO table field - House Number

Description: House Number
Field Name: STREET_NO
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET_NO

TDS_CUSTOMER-PCODE table field - Postal Code

Description: Postal Code
Field Name: PCODE
Data Element: PSTLZ
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PSTLZ
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCODE

TDS_CUSTOMER-CITY table field - City

Description: City
Field Name: CITY
Data Element: ORT01_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY

TDS_CUSTOMER-COUNTRY table field - Country/Region Key

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1_GP
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP: C_LAND1
SHLP Field: LAND1
ConvExit:

See all SAP tables containing field COUNTRY

TDS_CUSTOMER-REGION table field - Region (State, Province, County)

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

TDS_CUSTOMER-TELF1 table field - First telephone number

Description: First telephone number
Field Name: TELF1
Data Element: TELF1
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELF1

TDS_CUSTOMER-AUFSDZ table field - Central order block for customer

Description: Central order block for customer
Field Name: AUFSDZ
Data Element: AUFSD_X
Data Type: CHAR
length (Dec): 2(0)
Check table: TVAST
Conversion Routine:
Domain Name: KAUFS
MemoryID:
AppClass: VA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUFSDZ

TDS_CUSTOMER-AUFSDV table field - Customer order block (sales area)

Description: Customer order block (sales area)
Field Name: AUFSDV
Data Element: AUFSD_V
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: KAUFS
MemoryID:
AppClass: VA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUFSDV

TDS_CUSTOMER-LIFSDZ table field - Central delivery block for the customer

Description: Central delivery block for the customer
Field Name: LIFSDZ
Data Element: LIFSD_X
Data Type: CHAR
length (Dec): 2(0)
Check table: TVLS
Conversion Routine:
Domain Name: LIFSP
MemoryID:
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIFSDZ

TDS_CUSTOMER-LIFSDV table field - Customer delivery block (sales area)

Description: Customer delivery block (sales area)
Field Name: LIFSDV
Data Element: LIFSD_V
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: LIFSP
MemoryID:
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIFSDV

TDS_CUSTOMER-FAKSDZ table field - Central billing block for customer

Description: Central billing block for customer
Field Name: FAKSDZ
Data Element: FAKSD_X
Data Type: CHAR
length (Dec): 2(0)
Check table: TVFS
Conversion Routine:
Domain Name: FAKSP
MemoryID:
AppClass: VF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAKSDZ

TDS_CUSTOMER-FAKSDV table field - Billing block for customer (sales and distribution)

Description: Billing block for customer (sales and distribution)
Field Name: FAKSDV
Data Element: FAKSD_V
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: FAKSP
MemoryID:
AppClass: VF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAKSDV

TDS_CUSTOMER-LOEVMZ table field - Central Deletion Flag for Master Record

Description: Central Deletion Flag for Master Record
Field Name: LOEVMZ
Data Element: LOEVM_X
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOEVMZ

TDS_CUSTOMER-LOEVMV table field - Deletion flag for customer (sales level)

Description: Deletion flag for customer (sales level)
Field Name: LOEVMV
Data Element: LOEVM_V
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOEVMV

TDS_CUSTOMER-NODEL table field - Central deletion block for master record

Description: Central deletion block for master record
Field Name: NODEL
Data Element: NODEL_X
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODEL

TDS_CUSTOMER-BUKRS table field - Company Code

Description: Company Code
Field Name: BUKRS
Data Element: BUKRS
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: BUKRS
MemoryID: BUK
AppClass: FB
SHLP: C_T001
SHLP Field: BUKRS
ConvExit:

See all SAP tables containing field BUKRS

TDS_CUSTOMER-NAME2 table field - Name 2

Description: Name 2
Field Name: NAME2
Data Element: NAME2_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME2

TDS_CUSTOMER-KLABC table field - Customer classification (ABC analysis)

Description: Customer classification (ABC analysis)
Field Name: KLABC
Data Element: KLABC
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: KLABC
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KLABC

TDS_CUSTOMER-KDGRP table field - Customer Group

Description: Customer Group
Field Name: KDGRP
Data Element: KDGRP
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: KDGRP
MemoryID: VKD
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KDGRP

TDS_CUSTOMER-KUKLA table field - Customer Classification

Description: Customer Classification
Field Name: KUKLA
Data Element: KUKLA
Data Type: CHAR
length (Dec): 2(0)
Check table: TKUKL
Conversion Routine:
Domain Name: KUKLA
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KUKLA

TDS_CUSTOMER-HOMEPAGE table field - Homepage URL

Description: Homepage URL
Field Name: HOMEPAGE
Data Element: HOMEPAGE
Data Type: LCHR
length (Dec): 2048(0)
Check table:
Conversion Routine:
Domain Name: AD_URI
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOMEPAGE

TDS_CUSTOMER-HOMEPAGE_REF table field - Homepage URL

Description: Homepage URL
Field Name: HOMEPAGE_REF
Data Element: HOMEPAGE
Data Type: LCHR
length (Dec): 2048(0)
Check table:
Conversion Routine:
Domain Name: AD_URI
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOMEPAGE_REF

TDS_CUSTOMER-SDEMAIL table field - E-Mail Address

Description: E-Mail Address
Field Name: SDEMAIL
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field SDEMAIL

TDS_CUSTOMER-SDEMAIL_REF table field - E-Mail Address

Description: E-Mail Address
Field Name: SDEMAIL_REF
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field SDEMAIL_REF

TDS_CUSTOMER-TELFX table field - Fax Number

Description: Fax Number
Field Name: TELFX
Data Element: TELFX
Data Type: CHAR
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: TEXT31
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELFX

TDS_CUSTOMER-BEGRU table field - Authorization Group

Description: Authorization Group
Field Name: BEGRU
Data Element: BEGRU
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BEGRU
MemoryID:
AppClass: INST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BEGRU

TDS_CUSTOMER-KTOKD table field - Customer Account Group

Description: Customer Account Group
Field Name: KTOKD
Data Element: KTOKD
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: KTOKD
MemoryID: KGD
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KTOKD

TDS_CUSTOMER-VKORG_T table field - Description of sales organization

Description: Description of sales organization
Field Name: VKORG_T
Data Element: VKORG_BEZ
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VKORG_T

TDS_CUSTOMER-VTWEG_T table field - Description of distribution channel

Description: Description of distribution channel
Field Name: VTWEG_T
Data Element: VTWEG_BEZ
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VTWEG_T

TDS_CUSTOMER-SPART_T table field - Description of division

Description: Description of division
Field Name: SPART_T
Data Element: SPART_BEZ
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPART_T

TDS_CUSTOMER-VKBUR_T table field - Description of sales office

Description: Description of sales office
Field Name: VKBUR_T
Data Element: VKBUR_BEZ
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VKBUR_T

TDS_CUSTOMER-VKGRP_T table field - Description of Sales Group

Description: Description of Sales Group
Field Name: VKGRP_T
Data Element: VKGRP_BEZ
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VKGRP_T

TDS_CUSTOMER-BUKRS_T table field - Name of Company Code or Company

Description: Name of Company Code or Company
Field Name: BUKRS_T
Data Element: BUTXT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: TEXT25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUKRS_T

TDS_CUSTOMER-KUKLA_T table field - Customer Classification Description

Description: Customer Classification Description
Field Name: KUKLA_T
Data Element: KUKLA_BEZ
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KUKLA_T

TDS_CUSTOMER-KDGRP_T table field - Description

Description: Description
Field Name: KDGRP_T
Data Element: BEZEI20
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KDGRP_T


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table