CVIS_EI_3VL SAP (Ext. Interface: Address of Person in Company) Structure details

Dictionary Type: Structure
Description: Ext. Interface: Address of Person in Company




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




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

CVIS_EI_3VL 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 "Ext. Interface: Address of Person in Company" 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_CVIS_EI_3VL TYPE CVIS_EI_3VL.

The CVIS_EI_3VL table consists of various fields, each holding specific information or linking keys about Ext. Interface: Address of Person in Company data available in SAP. These include ADDR_VERS (Version ID for International Addresses), FROM_DATE (Valid-from date - in current Release only 00010101 possible), TO_DATE (Valid-to date in current Release only 99991231 possible), TITLE_P (Form-of-Address Key).. 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 CVIS_EI_3VL 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
DATA 0
ADDR_VERSVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
FROM_DATEValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
TO_DATEValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
TITLE_PForm-of-Address Key AD_TITLECHAR4AD_TITLE
FIRSTNAMEFirst name AD_NAMEFIRCHAR40TEXT40
LASTNAMELast name AD_NAMELASCHAR40TEXT40
BIRTH_NAMEName of person at birth AD_NAME2_PCHAR40TEXT40
MIDDLENAMEMiddle name or second forename of a person AD_NAMEMIDCHAR40TEXT40
SECONDNAMESecond surname of a person AD_NAMLAS2CHAR40TEXT40
FULLNAMEFull Name of Person AD_NAMTEXTCHAR80TEXT80
FULLNAME_XStatus of Field 'Full Name' NAME_TEXT AD_NAMCONVCHAR1AD_NAMCONV
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4AD_TITLE1
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4AD_PREFIX
TITLE_SPPLName supplement, e.g. noble title (key) AD_TITLESCHAR4AD_TITLES
NICKNAMENickname or name used AD_NICKNAMCHAR40TEXT40
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
NAMCTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
PROFESSIONProfession AD_PROFESSCHAR40TEXT40
SEXGender key AD_SEXCHAR1AD_SEX
LANGU_PLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
LANGUP_ISO2-Character SAP Language Code LAISOCHAR2LAISO
SORT1_PSearch Term 1 AD_SORT1CHAR20CHAR20
SORT2_PSearch Term 2 AD_SORT2CHAR20CHAR20
LANGU_CR_PAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
LANGUCPISO2-Character SAP Language Code LAISOCHAR2LAISO
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
BUILDING_PBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOOR_PFloor in building AD_FLOORCHAR10TEXT10
ROOM_NO_PRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
INITS_SIGShort name for correspondence AD_ID_CODECHAR10TEXT10
INHOUSE_MLInt. mail postal code AD_IH_MAILCHAR10TEXT10
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3AD_COMM
PERS_GROUPPerson Group (Key) (Business Address Services) AD_GROUP_PCHAR4AD_GROUP_P
DATAX 0
ADDR_VERSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FROM_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TO_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FIRSTNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LASTNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BIRTH_NAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MIDDLENAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SECONDNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FULLNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FULLNAME_XUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_ACA1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_ACA2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PREFIX1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PREFIX2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TITLE_SPPLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NICKNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INITIALSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAMEFORMATUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAMCOUNTRYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NAMCTRYISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROFESSIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SEXUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGU_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGUP_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT1_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORT2_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGU_CR_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LANGUCPISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DEPARTMENTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FUNCTIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BUILDING_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FLOOR_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ROOM_NO_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INITS_SIGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INHOUSE_MLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COMM_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERS_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UPDATEFLAGAddress transfer structure change flag AD_UPDFLAGCHAR1AD_UPDFLAG

Key field Non-key field



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

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

How to access SAP table CVIS_EI_3VL

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