CRMT_BSP_ADDRESS_2 SAP (Address Structure for Second Address Controller) Structure details

Dictionary Type: Structure
Description: Address Structure for Second Address Controller




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




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

CRMT_BSP_ADDRESS_2 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 "Address Structure for Second Address Controller" 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_CRMT_BSP_ADDRESS_2 TYPE CRMT_BSP_ADDRESS_2.

The CRMT_BSP_ADDRESS_2 table consists of various fields, each holding specific information or linking keys about Address Structure for Second Address Controller data available in SAP. These include OBJECT_KEY (Object Key), ADDRESS_TYPE (Address type (1=Organization, 2=Person, 3=Contact person)), DROPDOWN_EXPAND (Default Display/Detail Display of Addresses), DROPDOWN_NATION (Display of Address Version of an Address).. 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 (Deep)


SAP CRMT_BSP_ADDRESS_2 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
OBJECT_KEYObject Key CRMT_BSP_OBJECTKEYCHAR100
ADDRESS_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
DROPDOWN_EXPANDDefault Display/Detail Display of Addresses CRMT_BSP_AD_DROPDOWN_EXPANDCHAR1XFELD
DROPDOWN_NATIONDisplay of Address Version of an Address CRMT_BSP_AD_DROPDOWN_NATIONCHAR1Assigned to domainAD_NATION
DROPDOWN_COMMDisplay of Communication Types for an Address CRMT_BSP_AD_DROPDOWN_COMMCHAR3Assigned to domainAD_COMM
NATIONVersion ID for International Addresses AD_NATIONCHAR1Assigned to domainAD_NATIONADDRESS_NATION
TITLEForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_TXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
TITLE_PForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
NAME_FIRSTFirst name AD_NAMEFIRCHAR40TEXT40
NAME_LASTLast name AD_NAMELASCHAR40TEXT40
NAME2_PName of person at birth AD_NAME2_PCHAR40TEXT40
NAMEMIDDLEMiddle name or second forename of a person AD_NAMEMIDCHAR40TEXT40
NAME_LAST2Second surname of a person AD_NAMLAS2CHAR40TEXT40
NAME_TEXTFull Name of Person AD_NAMTEXTCHAR80TEXT80
CONVERTEDStatus of Field 'Full Name' NAME_TEXT AD_NAMCONVCHAR1AD_NAMCONV
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4Assigned to domainAD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4Assigned to domainAD_TITLE1
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4Assigned to domainAD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4Assigned to domainAD_PREFIX
TITLE_SPPLName supplement, e.g. noble title (key) AD_TITLESCHAR4Assigned to domainAD_TITLES
NICKNAMENickname or name used AD_NICKNAMCHAR40TEXT40
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
PROFESSIONProfession AD_PROFESSCHAR40TEXT40
SEXGender key AD_SEXCHAR1AD_SEX
LANGU_PLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
SORT1_PSearch Term 1 AD_SORT1ULCHAR20TEXT20
SORT2_PSearch Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN_P(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
PERSORIGINPersonal data source (key) AD_ORIGINPCHAR4TSAD6AD_ORIGIN
LANGU_CR_PAddress record creation original language AD_LANGUCRLANG1T002ISOLASPRAS
NAMCOUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
SO_KEYSAP-Office key AD_SO_KEYCHAR10ALPHAAD_SO_KEYADDRESS
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
BUILDING_CBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOOR_CFloor in building AD_FLOORCHAR10TEXT10
ROOMNUM_CRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
ID_CODEShort name for correspondence AD_ID_CODECHAR10TEXT10
IH_MAILInt. mail postal code AD_IH_MAILCHAR10TEXT10
SORT1_C(Not Supported) Search Term AD_SORTOLDCHAR20CHAR20
SORT2_C(Not Supported) Search Term AD_SORTOLDCHAR20CHAR20
SORT_PHN_C(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ADRCITYALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ADRCITYPRTALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ADRCITYALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
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
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4TSAD12AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ADRCITYALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3T005SREGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3T005LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4TSAD12AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ADRSTREETALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
LANGULanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4TSAD6AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1T002ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4ADDRC_DELI_SERVAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ADRCOUNTYALPHACNTY_CODE
COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
REGION_DESCRIPTIONDescription BEZEI20CHAR20TEXT20
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ADRTOWNSHIPALPHATWSHP_CODE
TRANSPZONE_DESCRIPTIONDescription BEZEI20CHAR20TEXT20
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
REGIOGROUP_DESCRIPTIONText Field TEXT50CHAR50TEXT50
COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
PO_BOX_CTY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
REGION_DESCRIPTIONDescription BEZEI20CHAR20TEXT20
PO_BOX_REG_DESCRIPTIONDescription BEZEI20CHAR20TEXT20
TRANSPZONE_DESCRIPTIONDescription BEZEI20CHAR20TEXT20
TEL_COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
REGIOGROUP_DESCRIPTIONText Field TEXT50CHAR50TEXT50
PO_BOX_CTY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
TEL_COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
PO_BOX_REG_DESCRIPTIONDescription BEZEI20CHAR20TEXT20
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
MOB_COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
TEL_COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
TEL_COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
MOB_NUMBERFirst Mobile Telephone No.: Dialing Code + Number AD_MBNMBR1CHAR30CHAR30
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
MOB_EXTENSFirst Mobile Telephone No.: Extension AD_MBXTNS1CHAR10CHAR10
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
MOB_COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
FAX_COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
MOB_COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
MOB_NUMBERFirst Mobile Telephone No.: Dialing Code + Number AD_MBNMBR1CHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
MOB_EXTENSFirst Mobile Telephone No.: Extension AD_MBXTNS1CHAR10CHAR10
SMTP_ADDRE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
FAX_COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
URI_TYPEURI type flag AD_URITYPECHAR3AD_URITYPE
FAX_COUNTRY_DESCRIPTIONCountry Name LANDXCHAR15TEXT15
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
URI_SCREENURI, e.g. Homepage or ftp Address AD_URISCRCHAR132AD_URISCR
DEFLT_COMMStandard Communication Method (Key) CRMT_BSP_AD_DCOMMCHAR3Assigned to domainAD_COMM
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
SMTP_ADDRE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
URI_TYPEURI type flag AD_URITYPECHAR3AD_URITYPE
URI_SCREENURI, e.g. Homepage or ftp Address AD_URISCRCHAR132AD_URISCR
DEFLT_COMMStandard Communication Method (Key) CRMT_BSP_AD_DCOMMCHAR3Assigned to domainAD_COMM

Key field Non-key field



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

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

How to access SAP table CRMT_BSP_ADDRESS_2

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