MSAM10_PREMISE SAP (MSAM-ISU: Premise Data) Structure details

Dictionary Type: Structure
Description: MSAM-ISU: Premise Data




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




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

MSAM10_PREMISE 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 "MSAM-ISU: Premise Data" 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_MSAM10_PREMISE TYPE MSAM10_PREMISE.

The MSAM10_PREMISE table consists of various fields, each holding specific information or linking keys about MSAM-ISU: Premise Data data available in SAP. These include VSTELLE (Premise), HAUS_NUM2 (House number supplement), STR_ERG2 (Street 3), STR_ERG4 (Street 5).. 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: Cannot Be Enhanced


SAP MSAM10_PREMISE 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
TPLNRFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
VSTELLE Premise0
HAUS_NUM2House number supplement AD_HSNM2CHAR10TEXT10
STR_ERG2Street 3 AD_STRSPP2CHAR40TEXT40
STR_ERG4Street 5 AD_LCTNCHAR40TEXT40
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
LGZUSATZ Additional Information on Location0
VBSART Type of premise0
EIGENT Owner0
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
TITLE_MEDITitle text AD_TITLETXCHAR30TEXT30
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
REMARKCommunication link notes AD_REMARK2CHAR50TEXT50
POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
PO_FLOORFloor in building AD_FLOORCHAR10TEXT10
PO_ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
NAME_COc/o name AD_NAME_COCHAR40TEXT40
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20

Key field Non-key field



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

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

How to access SAP table MSAM10_PREMISE

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