SAP CMS_STR_ADRC_STRUC_620 CMS Structure for BP:Address(Adrc)(BANK/CFM/462_10) Table data and field list

CMS_STR_ADRC_STRUC_620 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 "CMS Structure for BP:Address(Adrc)(BANK/CFM/462_10)" 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_CMS_STR_ADRC_STRUC_620 TYPE CMS_STR_ADRC_STRUC_620.

The CMS_STR_ADRC_STRUC_620 table consists of various fields, each holding specific information or linking keys about CMS Structure for BP:Address(Adrc)(BANK/CFM/462_10) data available in SAP. These include CITY1 (City), CITY2 (District), CITY_CODE (City code for city/street file), CITYP_CODE (District code for City and Street file)... 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. .

CMS_STR_ADRC_STRUC_620 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CMS_STR_ADRC_STRUC_620 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_STR_ADRC_STRUC_620 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8Assigned to domainALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12Assigned to domainALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
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_USEPCHAR4Assigned to domainAD_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_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4Assigned to domainAD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12Assigned to domainALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2Assigned to domainSTRTYPEAB
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 SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4Assigned to domainAD_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_TZONECHAR6Assigned to domainTZNZONE
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_LANGUCRLANG1Assigned to domainISOLASPRAS

Key field Non-key field



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

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

How to access SAP table CMS_STR_ADRC_STRUC_620

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

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