SAP CEPREMISEANLYSQ table - Generated Table for View details in SAP


SAP CEPREMISEANLYSQ table summary

Object Name: CEPREMISEANLYSQ
Dictionary Type: Table view
Description: Generated Table for View


Field list for CEPREMISEANLYSQ table on an S/4 SAP system

Details
CEPREMISEANLYSQ-MANDT table field - Client

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

CEPREMISEANLYSQ-UTILITIESPREMISE table field - Premise

Description: Premise
Field Name: UTILITIESPREMISE
Data Element: VSTELLE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: VSTELLE
MemoryID: VBS
AppClass:
SHLP: EVBS
SHLP Field: VSTELLE
ConvExit: ALPHA

See all SAP tables containing field UTILITIESPREMISE

CEPREMISEANLYSQ-AUTHORIZATIONGROUP table field - Authorization Group

Description: Authorization Group
Field Name: AUTHORIZATIONGROUP
Data Element: BEGRU
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BEGRU
MemoryID:
AppClass: INST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTHORIZATIONGROUP

CEPREMISEANLYSQ-FUNCTIONALLOCATION table field - Number of functional location

Description: Number of functional location
Field Name: FUNCTIONALLOCATION
Data Element: TPLNUMMER
Data Type: CHAR
length (Dec): 30(0)
Check table: IFLOT
Conversion Routine: TPLNR
Domain Name: TPLNR
MemoryID:
AppClass: INST
SHLP:
SHLP Field:
ConvExit: TPLNR

See all SAP tables containing field FUNCTIONALLOCATION

CEPREMISEANLYSQ-NUMBEROFPERSONS table field - Number of persons

Description: Number of persons
Field Name: NUMBEROFPERSONS
Data Element: ANZ_PERS
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ANZ_PERS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMBEROFPERSONS

CEPREMISEANLYSQ-UTILITIESCONNECTIONOBJECT table field - Connection Object

Description: Connection Object
Field Name: UTILITIESCONNECTIONOBJECT
Data Element: HAUS
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine: TPLNR
Domain Name: TPLNR
MemoryID: HAU
AppClass: INST
SHLP: EHAU
SHLP Field: TPLNR
ConvExit: TPLNR

See all SAP tables containing field UTILITIESCONNECTIONOBJECT

CEPREMISEANLYSQ-UTILITIESOWNER table field - Owner

Description: Owner
Field Name: UTILITIESOWNER
Data Element: E_GPARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field UTILITIESOWNER

CEPREMISEANLYSQ-UTILITIESPREMISETYPE table field - Type of premise

Description: Type of premise
Field Name: UTILITIESPREMISETYPE
Data Element: VBSART
Data Type: CHAR
length (Dec): 8(0)
Check table: TE102
Conversion Routine:
Domain Name: VBSART
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UTILITIESPREMISETYPE

CEPREMISEANLYSQ-UTILITIESPREMISETYPENAME table field - Text for premise type

Description: Text for premise type
Field Name: UTILITIESPREMISETYPENAME
Data Element: VBSARTTEXT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UTILITIESPREMISETYPENAME

CEPREMISEANLYSQ-UTILSPREMISEISMAINRESIDENCE table field - Main residence

Description: Main residence
Field Name: UTILSPREMISEISMAINRESIDENCE
Data Element: MAINRESI
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: KENNZX
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UTILSPREMISEISMAINRESIDENCE

CEPREMISEANLYSQ-DELETIONINDICATOR table field - Deletion Indicator

Description: Deletion Indicator
Field Name: DELETIONINDICATOR
Data Element: LOEVM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELETIONINDICATOR

CEPREMISEANLYSQ-LOCATIONSUPPLEMENT table field - Additional Information on Location

Description: Additional Information on Location
Field Name: LOCATIONSUPPLEMENT
Data Element: LGZUSATZ
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: LGZUSATZ
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATIONSUPPLEMENT

CEPREMISEANLYSQ-ADDRESSID table field - Address Number

Description: Address Number
Field Name: ADDRESSID
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRESSID

CEPREMISEANLYSQ-COUNTRY table field - Country/Region Key

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

CEPREMISEANLYSQ-REGION table field - Region (State, Province, County)

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

CEPREMISEANLYSQ-CITYNAME table field - City

Description: City
Field Name: CITYNAME
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITYNAME

CEPREMISEANLYSQ-STREETNAME table field - Street

Description: Street
Field Name: STREETNAME
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREETNAME

CEPREMISEANLYSQ-HOUSENUMBER table field - House Number

Description: House Number
Field Name: HOUSENUMBER
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSENUMBER

CEPREMISEANLYSQ-HOUSENUMBERSUPPLEMENTTEXT table field - House number supplement

Description: House number supplement
Field Name: HOUSENUMBERSUPPLEMENTTEXT
Data Element: AD_HSNM2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSENUMBERSUPPLEMENTTEXT

CEPREMISEANLYSQ-POSTALCODE table field - City postal code

Description: City postal code
Field Name: POSTALCODE
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTALCODE

CEPREMISEANLYSQ-FLOOR table field - Floor in building

Description: Floor in building
Field Name: FLOOR
Data Element: AD_FLOOR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLOOR

CEPREMISEANLYSQ-ROOMNUMBER table field - Room or Apartment Number

Description: Room or Apartment Number
Field Name: ROOMNUMBER
Data Element: AD_ROOMNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOMNUMBER

CEPREMISEANLYSQ-STREETSUPPLEMENT1 table field - Street 3

Description: Street 3
Field Name: STREETSUPPLEMENT1
Data Element: AD_STRSPP2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREETSUPPLEMENT1

CEPREMISEANLYSQ-STREETSUPPLEMENT2 table field - Street 5

Description: Street 5
Field Name: STREETSUPPLEMENT2
Data Element: AD_LCTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREETSUPPLEMENT2

CEPREMISEANLYSQ-NUMBEROFUTILITIESPREMISES table field - Number of Premises

Description: Number of Premises
Field Name: NUMBEROFUTILITIESPREMISES
Data Element: E_NROUTILSPREMISES_VDM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMBEROFUTILITIESPREMISES

CEPREMISEANLYSQ-UTILITIESANALYSISKEYDATE table field - Premise Analysis Key Date

Description: Premise Analysis Key Date
Field Name: UTILITIESANALYSISKEYDATE
Data Element: E_UTILSPREMISEKEYDATE_VDM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UTILITIESANALYSISKEYDATE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table