SAP ABAP Table EKUND (Fields for Business Partner on Subscreens)
Hierarchy
☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data
Basic Data
Table Category INTTAB    Structure 
Structure EKUND   Table Relationship Diagram
Short Description Fields for Business Partner on Subscreens    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
3 RAHMEN1 E_RAHMEN50 CHAR50 CHAR 50   0   Outline text  
4 RAHMEN2 E_RAHMEN60 CHAR60 CHAR 60   0   Outline text  
5 RAHMEN3 E_RAHMEN50 CHAR50 CHAR 50   0   Outline text  
6 RAHMEN4 E_RAHMEN50 CHAR50 CHAR 50   0   Outline text  
7 RAHMEN5 E_RAHMEN50 CHAR50 CHAR 50   0   Outline text  
8 RAHMEN6 E_RAHMEN50 CHAR50 CHAR 50   0   Outline text  
9 MITGLIEDT TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
10 PB_FULL1 E_VOLLBILD CHAR1 CHAR 1   0   Pushbutton: full screen  
11 PB_FULL2 E_VOLLBILD CHAR1 CHAR 1   0   Pushbutton: full screen  
12 PB_FULL3 E_VOLLBILD CHAR1 CHAR 1   0   Pushbutton: full screen  
13 PB_FULL4 E_VOLLBILD CHAR1 CHAR 1   0   Pushbutton: full screen  
14 PB_FULL5 E_VOLLBILD CHAR1 CHAR 1   0   Pushbutton: full screen  
15 PB_FULL6 E_VOLLBILD CHAR1 CHAR 1   0   Pushbutton: full screen  
16 MUSTER_KUN MUSTER_KUN KUNNR CHAR 10   0   Reference for creating a standard customer for bus. partner *
17 BU_GROUP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping TB001
18 RLTYP BU_RLTYP BU_RLTYP CHAR 6   0   BDT: Object part TBZ0
19 BPKIND BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
20 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key *
21 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) *
22 BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
23 BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
24 TITLE_ROYL AD_TITLEST TEXT20 CHAR 20   0   Name supplement, e.g. noble title (written form)  
25 BU_LANGU BU_LANGU SPRAS LANG 1   0   Business partner: Language *
26 LANGU_CORR BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language *
27 NAME_LAST2 BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
28 .INCLUDE       0   0   Screen Fields: Cust.Name and Search Terms for Subscreens  
29 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
30 TITLE_MEDI AD_TITLETX TEXT30 CHAR 30   0   Title text  
31 NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
32 NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
33 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
34 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
35 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
36 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
37 NAME_GRP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
38 NAME_GRP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
39 LEGAL_ENTY BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
40 ISTYPE BU_ISTYPE BU_ISTYPE CHAR 4   0   Industry System TB038
41 IND_SECTOR BU_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry TB038A
42 PARTGRPTYP BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type *
43 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
44 BU_SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
45 XSEXU BU_XSEXU XFELD CHAR 1   0   Selection: Sex of business partner is not known  
46 XSEXF BU_XSEXF XFELD CHAR 1   0   Selection: Business partner is female  
47 XSEXM BU_XSEXM XFELD CHAR 1   0   Selection: Business partner is male  
48 SEXID BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
49 .INCLUDE       0   0   Texts for Customer Name Fields on Subscreens  
50 TITLET TITLET TEXT20 CHAR 20   0   Text for form of address  
51 LEGENTYT LEGENTYT BU_TEXT40 CHAR 40   0   Text for legal form  
52 INDSECTT INDSECTT BU_TEXT40 CHAR 40   0   Text for industry  
53 GRPTYPT GRPTYPT BU_TEXT40 CHAR 40   0   Text for partner group type  
54 .INCLUDE       0   0   Screen Fields: Cust. Addr. and Communication for Subscreens  
55 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
56 STREET AD_STREET TEXT60 CHAR 60   0   Street  
57 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
58 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
59 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
60 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
61 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
62 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
63 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
64 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
65 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
66 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file *
67 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
68 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
69 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
70 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
71 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
72 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
73 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
74 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
75 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) *
76 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country *
77 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
78 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
79 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
80 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
81 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
82 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
83 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
84 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
85 TEL_NUMBER E_TLNMBR CHAR30 CHAR 30   0   Telephone No.: Dialling Code + Number  
86 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
87 MOB_NUMBER E_MBNMBR1 CHAR30 CHAR 30   0   First Mobile Phone No.: Dial.Code + Number (Address-Indep.)  
88 TEL_NUMBER_AI E_TLNMBR1_AI CHAR30 CHAR 30   0   First Telephone No.: Dial.Code + Number - Address-Independ.  
89 TEL_EXTENS_AI AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
90 SMTP_ADDR_AI E_SMTPADR_AI AD_SMTPADR CHAR 241   0   E-Mail Address (Address-Independent)  
91 FAX_NUMBER E_FXNMBR CHAR30 CHAR 30   0   Fax Number: Dialling Code + Number  
92 FAX_EXTENS AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
93 SMTP_ADDR AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
94 OTHER_ADDR OTHER_ADDR KENNZX CHAR 1   0   Additional addresses for customer exist  
95 .INCLUDE       0   0   Texts for Customer Address Fields in Subscreens  
96 LANDT LANDX TEXT15 CHAR 15   0   Country Name  
97 REGIONT REGIONT TEXT20 CHAR 20   0   Text for region  
98 SPRAST SPTXT SPTXT16 CHAR 16   0   Name of Language  
99 .INCLUDE       0   0   Screen Fields: Customer Bank Details for Subscreens  
100 BKVID BU_BKVID CHAR4 CHAR 4   0   Bank details ID  
101 BANKS BANKS LAND1 CHAR 3   0   Bank country key T005
102 BANKL BANKK BANKK CHAR 15   0   Bank Keys  
103 BANKN BANKN BANKN CHAR 18   0   Bank account number  
104 BKONT BKONT BKONT CHAR 2   0   Bank Control Key  
105 BKREF BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
106 KOINH BU_KOINH BU_KOINH CHAR 60   0   Account Holder Name  
107 BKEXT BU_BKEXT CHAR20 CHAR 20   0   Bank details ID in external system  
108 BKDSC BU_BKDSC CHAR100 CHAR 100   0   Name of bank  
109 BKVID2 BU_BKVID CHAR4 CHAR 4   0   Bank details ID  
110 BANKS2 BANKS LAND1 CHAR 3   0   Bank country key *
111 BANKL2 BANKK BANKK CHAR 15   0   Bank Keys  
112 BANKN2 BANKN BANKN CHAR 18   0   Bank account number  
113 BKONT2 BKONT BKONT CHAR 2   0   Bank Control Key  
114 BKREF2 BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
115 KOINH2 BU_KOINH BU_KOINH CHAR 60   0   Account Holder Name  
116 BKEXT2 BU_BKEXT CHAR20 CHAR 20   0   Bank details ID in external system  
117 BKDSC2 BU_BKDSC CHAR100 CHAR 100   0   Name of bank  
118 COUNT_BANK COUNT_BANK COUNT_BANK NUMC 2   0   Number of bank details for business partner  
119 BANKA BANKA TEXT60 CHAR 60   0   Name of bank  
120 BRNCH BRNCH TEXT40 CHAR 40   0   Bank Branch  
121 OTHER_BANK OTHER_BANK KENNZX CHAR 1   0   Further bank details for customer exist  
122 IBAN BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
123 IBAN2 BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
124 .INCLUDE       0   0   Customer Data Screen Fields for Subscreens: Credit Cards  
125 CCARD_ID BU_CCID CHAR6 CHAR 6   0   Payment Card ID  
126 CCINS CC_INSTITUTE CC_INSTITUTE CHAR 4   0   Payment card type TB033
127 CCNUM CCNUM CCNUM CHAR 25   0   Payment cards: Card number *
128 CCDEF BU_CCDEF XFELD CHAR 1   0   BP: Standard Payment Card  
129 COUNT_CCARD COUNT_CCARD COUNT_CCARD NUMC 2   0   Number of credit cards owned by business partner  
130 DATAB CC_DATAB_DI CHAR8 CHAR 8   0   Payment cards: Valid from (direct input)  
131 DATBI CC_DATBI_DI CHAR8 CHAR 8   0   Payment Cards: Valid To (Direct Input)  
132 .INCLUDE       0   0   Screen Fields: ISU-Specific Customer Data for Subscreens  
133 PB_UNMASK_CCNUM PB_UNMASK_CCNUM CHAR1 CHAR 1   0   Pushbutton: Credit Card Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EKUND BANKS T005 LAND1    
2 EKUND BPKIND TB004 BPKIND    
3 EKUND BU_GROUP TB001 BU_GROUP    
4 EKUND CCINS TB033 CCINS    
5 EKUND COUNTRY T005 LAND1    
6 EKUND IND_SECTOR TB038A IND_SECTOR    
7 EKUND ISTYPE TB038 ISTYPE    
8 EKUND LANGU T002 SPRAS    
9 EKUND LEGAL_ENTY TB019 LEGAL_ENTY    
10 EKUND MANDT T000 MANDT    
11 EKUND PARTNER BUT000 PARTNER    
12 EKUND REGION T005S BLAND    
13 EKUND RLTYP TBZ0 RLTYP    
14 EKUND TIME_ZONE TTZZ TZONE    
15 EKUND TITLE TSAD3 TITLE    
History
Last changed by/on SAP  20130529 
SAP Release Created in