EKUN SAP (IS-U-Specific Fields for Business Partner) Table details

Dictionary Type: Table
Description: IS-U-Specific Fields for Business Partner




ABAP Code to SELECT data from EKUN
Related tables to EKUN
Access table EKUN




Table field list including key, data, relationships and ABAP select examples

EKUN is a standard SAP Table which is used to store IS-U-Specific Fields for Business Partner data and is available within R/3 SAP systems depending on the version and release level.

The EKUN table consists of various fields, each holding specific information or linking keys about IS-U-Specific Fields for Business Partner data available in SAP. These include PARTNER (Business Partner Number), MUSTER_KUN (Reference for creating a standard customer for bus. partner), WAKLASS (Employee classification), FIRMART (Type of installation company).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EKUN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PARTNERBusiness Partner Number BU_PARTNERCHAR10BUT000ALPHABU_PARTNERBPABUPA
MUSTER_KUNReference for creating a standard customer for bus. partner MUSTER_KUNCHAR10Assigned to domainALPHAKUNNR
WAKLASSEmployee classification WAKLASSCHAR4TE697E_WAKLASS
FIRMARTType of installation company FIRMARTCHAR2TE183FIRMART
ARBFELDCompany work field ARBFELDCHAR2TE185ARBFELD
MITGLIEDMembership of installer MITGLIEDCHAR1MITGLIED
SPZULASSDivision license of installer SPZULASSCHAR20SPZULASS
ARTZULASSInstaller license type ARTZULASSCHAR2TE189ARTZULASS
AUSWANZNumber of identifications AUSWANZNUMC2AUSWANZ
PLOMBENZSealing pliers number PLOMBENZCHAR10PLOMBENZ
FREMDEVUMain utility company FREMDEVUCHAR3TE187EVU
STATINSValid status of installer in supply area STATINSCHAR2TE061STATINS
STATDATUMDate on which status of installer comes into effect STATDATUMDATS8STATDATUM
ERSTZULDate of initial license of installer ERSTZULDATS8ERSTZUL
WERKSTATTDate of workshop inspection WERKSTATTDATS8WERKSTATT
VERLZULDate of license renewal VERLZULDATS8VERLZUL
ENDEZULDate until which license is renewed ENDEZULDATS8ENDEZUL
ANZEVUNumber of utility companies ANZEVUNUMC2ANZEVU
ANZFILNumber of branches supported by an installionr company ANZFILNUMC2ANZFIL
AUSW_INSTIdentification number for installer license AUSW_INSTCHAR10AUSW_INST
DR_LICENSE_LAND1Country in which driver's license was acquired DR_LICENSE_LAND1CHAR3T005LAND1
DR_LICENSE_REGIORegion in which driver's license was acquired DR_LICENSE_REGIOCHAR3T005SREGIO
DR_LICENSEDriver's license number DR_LICENSECHAR20DR_LICENSE
SOC_SECURESocial Insurance Number E_SOC_SECUCHAR12E_SOC_SECU
WELFAREWelfare office WELFARECHAR9WELFARE
PLACE_EMPLWork center PLACE_EMPLCHAR40CHAR40
KTOKLASSEAccount class KTOKLASSECHAR4KONTOKLASSEKTOKLASSE
BUPINFORELInformation release for business partner data BUPINFORELCHAR2TEBUPINFORELALPHABUPINFOREL
CLERK_IDBusiness partner-specific criteria for agent determination E_CLERK_IDCHAR8TECLERK_IDE_CLERK_ID
RECPTYPECategory for Alternate Payee E_RECPTYPECHAR1E_RECPTYPE
PYMETPayment method for donations/fund payments E_PYMET_DONCHAR1TFK042ZPYMET_KK
EMBVTBank details ID for donations/fund payments E_EMBVT_DONCHAR4CHAR4
HKONTG/L accounts for donations/fund payments E_HKONT_DONCHAR10SKA1ALPHASAKNR
CLASSIFICATIONClassification of Business Partner E_CLASSIFICATIONCHAR4TE181CHAR4
VIPIndicate Very Important Business Partner E_VIPCHAR1KENNZX
IDENT_INSTIdentification Number for Installer License IDENT_INSTCHAR18IDENT_INST

Key field Non-key field



How do I retrieve data from SAP table EKUN using ABAP code

The following ABAP code Example will allow you to do a basic selection on EKUN to SELECT all data from the table
DATA: WA_EKUN TYPE EKUN.

SELECT SINGLE *
FROM EKUN
INTO CORRESPONDING FIELDS OF WA_EKUN
WHERE...

How to access SAP table EKUN

Within an ECC or HANA version of SAP you can also view further information about EKUN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!