CRMXIF_ACTIVITY_X SAP (IF Business Transaction: Activity) Structure details

Dictionary Type: Structure
Description: IF Business Transaction: Activity




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




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

CRMXIF_ACTIVITY_X 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 "IF Business Transaction: Activity" 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_CRMXIF_ACTIVITY_X TYPE CRMXIF_ACTIVITY_X.

The CRMXIF_ACTIVITY_X table consists of various fields, each holding specific information or linking keys about IF Business Transaction: Activity data available in SAP. These include CATEGORY (Activity Category (Communication Type)), PRIORITY (Activity Priority), OBJECTIVE (Goal of an Activity), DIRECTION (Direction of an Activity).. 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 CRMXIF_ACTIVITY_X 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
DATA 0
CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3CRM_ACTIVITY_CATEGORY
PRIORITYActivity Priority CRMT_PRIORITYNUMC1SC_PRIO
OBJECTIVEGoal of an Activity CRMT_OBJECTIVECHAR3CRM_OBJECTIVE
DIRECTIONDirection of an Activity CRMT_DIRECTIONCHAR1CRM_DIRECTION
EXTERN_ACT_IDExternal Business Transaction Number CRMT_EXTERNAL_ACTIVITY_IDCHAR20CRM_EXTERNAL_ACTIVITY_ID
PRIVATE_FLAGIndicator: Task is Private CRMT_PRIVATCHAR1CRM_BOOLEAN
COMPLETIONCompletion Rate in Percent CRMT_COMPLETIONNUMC3CRM_COMPLETIONCRM_ACT_COMPLETION
CALENDARInclude Activity in Calendar CRMT_CALENDARCHAR1CRM_BOOLEAN
ACTIVITY_TASKIndicator: Activity is a Task CRMT_TASKCHAR1CRM_BOOLEAN
CLASSActivity Class CRMT_ACTIVITY_CLASSCHAR1CRM_ACTIVITY_CLASS
ADDRESS_IDLocation where Activity takes place CRMT_ADDRESSCHAR10ALPHAAD_ADDRNUM
ACT_LOCATIONLocation CRMT_ACTIVITY_LCTNCHAR100CRM_ACTIVITY_LOCATION
ADDRESS 0
ADDR_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
TITLE_PTitle text AD_TITLETXCHAR30TEXT30
FIRSTNAMEFirst name AD_NAMEFIRCHAR40TEXT40
LASTNAMELast name AD_NAMELASCHAR40TEXT40
BIRTH_NAMEName of person at birth AD_NAME2_PCHAR40TEXT40
MIDDLENAMEMiddle name or second forename of a person AD_NAMEMIDCHAR40TEXT40
SECONDNAMESecond surname of a person AD_NAMLAS2CHAR40TEXT40
FULLNAMEFull Name of Person AD_NAMTEXTCHAR80TEXT80
FULLNAME_XStatus of Field 'Full Name' NAME_TEXT AD_NAMCONVCHAR1AD_NAMCONV
TITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ACA2Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
PREFIX1Name prefix AD_PREFIXTCHAR20TEXT20
PREFIX2Name prefix AD_PREFIXTCHAR20TEXT20
TITLE_SPPLName supplement, e.g. noble title (written form) AD_TITLESTCHAR20TEXT20
NICKNAMENickname or name used AD_NICKNAMCHAR40TEXT40
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
LANGU_PLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
LANGUP_ISO2-Character SAP Language Code LAISOCHAR2LAISO
SORT1_PSearch Term 1 AD_SORT1CHAR20CHAR20
SORT2_PSearch Term 2 AD_SORT2CHAR20CHAR20
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
BUILDING_PBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOOR_PFloor in building AD_FLOORCHAR10TEXT10
ROOM_NO_PRoom 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_COMMCHAR3AD_COMM
TITLETitle text AD_TITLETXCHAR30TEXT30
NAMEName 1 AD_NAME1CHAR40TEXT40
NAME_2Name 2 AD_NAME2CHAR40TEXT40
NAME_3Name 3 AD_NAME3CHAR40TEXT40
NAME_4Name 4 AD_NAME4CHAR40TEXT40
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
CITY_NOCity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
DISTRCT_NODistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PBOXCIT_NOCity PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
DELIV_DIS(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGold: building (no. or abbreviation) AD_BLD_OLDCHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
LANGU_ISO2-Character SAP Language Code LAISOCHAR2LAISO
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADR_NOTESAddress notes AD_REMARK1CHAR50TEXT50
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_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
BUILD_LONGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
ADDR_NOAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
HOMECITYNODifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
LANGU_CR_PAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
LANGUCPISO2-Character SAP Language Code LAISOCHAR2LAISO
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PERS_NOPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
POBOX_CTRYPO box country AD_POBXCTYCHAR3LAND1
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
INPUT_FIELDS 0
ADDR_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FIRSTNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LASTNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BIRTH_NAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MIDDLENAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SECONDNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FULLNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FULLNAME_XUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_ACA1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_ACA2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PREFIX1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PREFIX2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_SPPLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NICKNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INITIALSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAMEFORMATUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAMCOUNTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGU_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGUP_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT1_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT2_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DEPARTMENTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FUNCTIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BUILDING_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FLOOR_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ROOM_NO_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INITS_SIGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INHOUSE_MLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COMM_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAME_2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAME_3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAME_4Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
C_O_NAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CITYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DISTRICTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CITY_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DISTRCT_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CHCKSTATUSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
POSTL_COD1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
POSTL_COD2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
POSTL_COD3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PO_BOXUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PO_BOX_CITUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PBOXCIT_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DELIV_DISUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TRANSPZONEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STREETUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STREET_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STR_ABBRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
HOUSE_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
HOUSE_NO2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STR_SUPPL1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STR_SUPPL2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STR_SUPPL3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LOCATIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BUILDINGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FLOORUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ROOM_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COUNTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COUNTRYISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGUUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGU_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REGIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TIME_ZONEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAXJURCODEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ADR_NOTESUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TEL1_NUMBRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TEL1_EXTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FAX_NUMBERUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FAX_EXTENSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
E_MAILUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BUILD_LONGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ADDR_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DONT_USE_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DONT_USE_SUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
HOME_CITYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
HOMECITYNOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
HOUSE_NO3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGU_CR_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGUCPISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PCODE1_EXTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PCODE2_EXTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PCODE3_EXTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERS_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PO_BOX_REGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PO_CTRYISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PO_W_O_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
POBOX_CTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REGIOGROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REASON 0
CODEGROUPCode Group QCODEGRPCHAR8QCODEGRPCGP
CODECode QCODECHAR4QCODEQCODE
INPUT_FIELDS 0
CODEGROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CODEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
OUTCOME 0
CODEGROUPCode Group QCODEGRPCHAR8QCODEGRPCGP
CODECode QCODECHAR4QCODEQCODE
INPUT_FIELDS 0
CODEGROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CODEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INPUT_FIELDS 0
CATEGORYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRIORITYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
OBJECTIVEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DIRECTIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
EXTERN_ACT_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRIVATE_FLAGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COMPLETIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CALENDARUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ACTIVITY_TASKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CLASSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ADDRESS_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ACT_LOCATIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE

Key field Non-key field



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

As CRMXIF_ACTIVITY_X 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 CRMXIF_ACTIVITY_X as there is no data to select.

How to access SAP table CRMXIF_ACTIVITY_X

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