COMT_BSP_RELATION_EMP_PARTNER SAP (Employee data with partner info) Structure details

Dictionary Type: Structure
Description: Employee data with partner info




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




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

COMT_BSP_RELATION_EMP_PARTNER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Employee data with partner info" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_COMT_BSP_RELATION_EMP_PARTNER TYPE COMT_BSP_RELATION_EMP_PARTNER.

The COMT_BSP_RELATION_EMP_PARTNER table consists of various fields, each holding specific information or linking keys about Employee data with partner info data available in SAP. These include PARTNER_1 (Business Partner Number), OBJECT_KEY (Object Key), TITLE_KEY (Form-of-Address Key), TEL1_NUMBR (First telephone no.: dialling code+number).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP COMT_BSP_RELATION_EMP_PARTNER structure 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
PARTNER_2Business Partner Number COMT_BSP_BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNER_1Business Partner Number COMT_BSP_BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
OBJECT_KEYObject Key CRMT_BSP_OBJECTKEYCHAR100
TITLE_KEYForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
TEL2_NUMBRSecond Telephone Number: Code + Extension COMT_BSP_BP_TEL2_NUMBRCHAR30CHAR30
TEL2_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
FIRSTNAMEFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
LASTNAMELast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
BIRTHNAMEName at birth of business partner BU_BIRTHNMCHAR40BU_NAME
MIDDLENAMEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
SECONDNAMEOther Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4TSAD2AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4TSAD2AD_TITLE1
TITLE_SPPLName supplement, e.g. noble title (key) AD_TITLESCHAR4TSAD5AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4TSAD4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4TSAD4AD_PREFIX
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
NAMCOUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
SEXSex of business partner (person) BU_SEXIDCHAR1BU_SEXID
BIRTHPLACEBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
BIRTHDATEDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDATEDate of death of business partner BU_DEATHDTDATS8DATUM
MARITALSTATUSMarital Status of Business Partner BU_MARSTCHAR1TB027BU_MARST
CORRESPONDLANGUAGEBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1T002ISOLASPRAS
CORRESPONDLANGUAGEISO2-Character SAP Language Code LAISOCHAR2LAISO
FULLNAMEFull Name BU_NAME1TXCHAR80TEXT80
EMPLOYERName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
OCCUPATIONOccupation/group BU_JOBGRCHAR4Assigned to domainBU_JOBGR
NATIONALITYNationality BU_NATIOCHAR3Assigned to domainLAND1
NATIONALITYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
COUNTRYORIGINCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3Assigned to domainLAND1
STANDARDADDRESSIndicator: Address is standard address BU_XDFADRCHAR1XFELD
BUILDING_PBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
INITS_SIGShort name for correspondence AD_ID_CODECHAR10TEXT10
INHOUSE_MLInt. mail postal code AD_IH_MAILCHAR10TEXT10
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
ADDRESS_DESCRAddress (GUID/Description) COMT_BSP_ADDR_GUIDCHAR60TEXT60

Key field Non-key field



How do I retrieve data from SAP structure COMT_BSP_RELATION_EMP_PARTNER using ABAP code?

As COMT_BSP_RELATION_EMP_PARTNER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on COMT_BSP_RELATION_EMP_PARTNER as there is no data to select.

How to access SAP table COMT_BSP_RELATION_EMP_PARTNER

Within an ECC or HANA version of SAP you can also view further information about COMT_BSP_RELATION_EMP_PARTNER 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!