EMKINSTLN SAP (Installation data for logical databases (marketing)) Structure details

Dictionary Type: Structure
Description: Installation data for logical databases (marketing)




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




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

EMKINSTLN 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 "Installation data for logical databases (marketing)" 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_EMKINSTLN TYPE EMKINSTLN.

The EMKINSTLN table consists of various fields, each holding specific information or linking keys about Installation data for logical databases (marketing) data available in SAP. These include MANDT (Client), ANLAGE (Installation), BIS (Date at Which a Time Slice Expires), AB (Date from which time slice is valid).. 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 EMKINSTLN 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
MANDTClient MANDTCLNT3T000MANDT
ANLAGEInstallation ANLAGECHAR10EANLALPHAANLAGEANLEANL
BISDate at Which a Time Slice Expires BISZEITSCHDATS8DATUM
ABDate from which time slice is valid ABZEITSCHDATS8DATUM
TARIFTYPRate category TARIFTYP_ANLCHAR10ETTATARIFTYPTTYEANL_TTYP
ANLSTATInstallation Status ANLSTATCHAR2ANLSTAT
KONZBEFRExempt from franchise fee KONZBEFRCHAR1KONZBEFR
PAUSCHALDevice allocation is not possible E_PAUSCHALCHAR1KENNZX
BRANCHEIndustry BU_IND_SECTORCHAR10TB038ABU_INDSECTOR
AKLASSEBilling class AKLASSECHAR4EAKLASSEAKLASSEAKL
ABLEINHMeter Reading Unit ABLEINHEITCHAR8TE422ABLEINHEITTAETE422A
TEMP_AREATemperature area TEMP_AREACHAR8TE307TEMP_AREA
KONZVERFranchise contract KONZVERCHAR10Assigned to domainALPHAKONZVERKZVEKONA
BILLING_PARTYService Provider that Bills the Installation BILLING_PARTYCHAR10Assigned to domainSERVICE_PROVSERVICEPROVIDER
INVOICING_PARTYService Provider That Invoices the Contract INVOICING_PARTYCHAR10Assigned to domainSERVICE_PROVSERVICEPROVIDER
PROV_LAST_RESObligation to Supply PROV_LAST_RESSORTCHAR10Assigned to domainSERVICE_PROVSERVICEPROVIDER
MAININSTKey of Primary Installation MAININSTCHAR10EANLALPHAANLAGE
INSTROLERole of an Installation Within the Installation Group INSTROLECHAR4TE673INSTROLE
INSTGRTYPEGrouping Type for Installation Group INSTGRTYPECHAR4TE672INSTGRTYPE
ISTYPEIndustry System BU_ISTYPECHAR4TB038BU_ISTYPE
HIGHLEVINSTHigher-Level Installation HIGHLEVINSTCHAR10EANLALPHAANLAGE
SCHEMANRNumber of the billing schema SCHEMANRCHAR10ESCHSCHEMANRISU_F4_SCHEMA
HOCHARTType of extrapolation in unbilled revenue reporting HOCHARTCHAR1HOCHART
VPERGRUPPrevious period control group VPERGRUPCHAR4VPERGRUP
PRUEFGRValidation group for dependent validations PRUEFGRCHAR4TE413PRUEFGR
ABSSTEUBudget billing control ABSSTEUCHAR1ABSSTEU
SPARTEDivision SPARTECHAR2TESPTSPARTSPA
VSTELLEPremise VSTELLECHAR10EVBSALPHAVSTELLEVBSEVBS
ABLSPERRReason for blocking meter reading ABLSPERRCHAR2TE119ABLSPERR
BAPERTYPBase period category BAPERTYPCHAR1BAPERTYP
ANSCHREINotification control for MR announcement/request ANSCHREICHAR10ANSCHREI
SPEBENEVoltage Level SPEBENECHAR2TE369SPEBENE
DRCKSTUFGas Pressure Level at Installation Level (Grid) DRCKSTUF_GRIDCHAR2TE696DRCKSTUF_GRID
ANLARTInstallation type ANLARTCHAR4TE439ANLART
BEZUGReference BEZUGCHAR1KENNZX
ABLESARTSTControl of perm. number of cust. MRs and autom. estimations ABLESARTSTCHAR8TE438ABLESARTSTABLARTST
NODISCONCTReason for guarantee of supply NODISCONCTCHAR4TE759ALPHANODISCONCT
SERVICEService Type SERCODECHAR4TECDESERVCATTECDE
DEREGSTATDeregulation status DEREGSTATCHAR2TEDEREGSTATALPHADEREGSTAT
INFORELRelease Status for Installation Data INFORELCHAR2TEINFORELALPHAINFOREL
ETIMEZONETime Zone for EDM Objects EDM_TIMEZONECHAR6TTZZTZNZONEVTTZZ
OUCONTOutline Contract OUCONTCHAR1KENNZX
HOLICALIDPublic Holiday Calendar HOLICALIDCHAR2Assigned to domainHIDENTVTHOCI
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion Indicator LOEVMCHAR1XFELD

Key field Non-key field



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

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

How to access SAP table EMKINSTLN

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