VIGW_R_VZGPM1F SAP () Structure details

Dictionary Type: Structure
Description:




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




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

VIGW_R_VZGPM1F 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 "" 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_VIGW_R_VZGPM1F TYPE VIGW_R_VZGPM1F.

The VIGW_R_VZGPM1F table consists of various fields, each holding specific information or linking keys about data available in SAP. These include MANDT (Client), BUKRS (Company Code), SWENR (Site Number), SMENR (Number of Rental Unit).. 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 VIGW_R_VZGPM1F 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 MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8Assigned to domainSMENRSMENRMEHMCME
PARTNRBusiness Partner Number BP_PARTNRCHAR10BP000ALPHABP_PARTNRBPN
ROLETYPBusiness Partner Role Category BP_ROLETYPCHAR4TPZ3BP_ROLETYPBPR
ROLEBusiness Partner Role Type BP_ROLECHAR4TPZ6BP_ROLE
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PERSNUMBERPerson number AD_PERSNUMCHAR10ADRPALPHAAD_PERSNUMCDTADDRESS
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4Assigned to domainBU_GROUPBPP
EXTPARTNRExternal Business Partner ID BP_EXT_PNRCHAR15CHAR15
CUSTOMERCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
TYPEPartner category BP_TYPE_OLDCHAR1BP_TYPE
BP_GROUPBP: Collective Business Partner Indicator BP_GROUPCHAR1XFELD
GROUP_IDBusiness Partner Grouping BP_GRP_ID_OLDCHAR4TPZ2BP_GRP_ID
NAME1Name 1 (surname for persons, otherwise company name) BP_NAME1CHAR40TEXT40
NAME2Name 2 (Continuation of NAME 1) BP_NAME2CHAR40TEXT40
LANGULanguage Key LANGULANG1T002ISOLASPRAS
TITLEForm of Address (Key) BP_TITLE_OLDNUMC2TP01BP_TITLE
TITLE_LETSalutation BP_TITL_LTNUMC2TP02BP_TITL_LT
ADR_REFAddress ID BP_ADR_REF_OLDCHAR10TP14BP_ADR_REFADK
SORT1Sort Field 1 BP_SORT1CHAR20CHAR20
SORT2Sort Field 2 BP_SORT2CHAR20CHAR20
SORT_PHONSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
MC_NAME1Field NAME1 in Upper Case BP_MC_NAM1CHAR25CHAR25
MC_NAME2Field NAME2 in Upper Case BP_MC_NAM2CHAR25CHAR25
SOURCESource Key of Business Partner Data BP_SOURCECHAR4BP_SOURCE
CRUSEREntered by BP_CRUSERCHAR12SYCHAR12
CRDATCreation Date BP_CRDATDATS8DATUM
VIPBusiness Partner: VIP Partner BP_VIPCHAR1TVIPPAVIP
GROUP_DTarget Group BP_GROUP_DCHAR4TP13BP_GROUP_D
DEL_INDDeletion Flag BP_DEL_INDCHAR1XFELD
BEGRUAuthorization Group BEGRUCHAR4BEGRU
XTITLEText of Form of Address BP_XTITLECHAR50TEXT50
XTIT_LESalutation BP_XTIT_LECHAR50TEXT50
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
NAME_LASTLast Name BP_NAMLASTCHAR40TEXT40
NAME_FIRSTFirst Name BP_NAMFRSTCHAR40TEXT40
TITLE_ACAcademic Title BP_TITL_AC_OLDCHAR20TEXT20
N_PREFIXName Prefix BP_PREFIX_OLDCHAR20TEXT20
N_ADDITIONName Affix BP_ADDITN_OLDCHAR20TEXT20
NICKNAMEKnown As BP_NICKNAMCHAR20TEXT20
SEXGender of Business Partner BP_SEX_OLDCHAR1BP_SEX
PROFESSIONDescription of Occupation for Business Partner BP_PROFESS_OLDCHAR40TEXT40
NATIONNationality BP_CNTR_NCHAR3T005LAND1
STATECitizenship BP_CNTR_STCHAR3T005LAND1
BIRTH_DATEDate of Birth of Business Partner BP_BIRTHDDATS8DATUM
BIRTH_PLACBirthplace BP_BIRTHPLCHAR40TEXT40
BIRTH_NAMEName at Birth BP_BIRTHNACHAR40TEXT40
BIRTH_N_ADName at Birth Affix BP_BIRTH_ACHAR40TEXT40
DEATH_DATEDate of Death BP_DEATH_DDATS8DATUM
MARITAL_STMarital Status BP_MARITAL_OLDNUMC2TP03BP_MARITAL
PROPRTY_STMarital property regime BP_PROPRTY_OLDNUMC2TP04BP_PROPRTY
CHILDRENNumber of Children Belonging to the Business Partner BP_CHILDRNDEC2DEC2
MEM_HOUSENumber of People Living in the Household BP_MEM_HOUDEC2DEC2
INCOME_CURCurrency of Net Income BP_INC_CURCUKY5TCURCWAERS
NET_INCOMENet Annual Income BP_NET_INCCURR15(2) WERTV8
MO_NET_INCMonthly Net Income of Business Partner BP_MO_INCCURR15(2) WERTV8
NET_INC_YYear of Net Annual Income BP_N_INC_YNUMC4GJAHRGJAHR
MO_INC_MCalendar Month of Monthly Net Income BP_M_INC_MNUMC2BP_M_INC_M
MO_INC_YYear of Monthly Net Income BP_M_INC_YNUMC4GJAHRGJAHR
PERS_NRPersonnel Number BP_PERS_NRCHAR15CHAR15
STAFF_GRPEmployee Group BP_STAFF_GCHAR4TP05BP_STAFF_G
HR_ORG_REFHR Org. Link HR_ORG_REFCHAR1XFELD
XUBNAMEUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
STAFF_REFEmployee BP_STAFF_RCHAR1XFELD
ORG_NAMEName 1 (surname for persons, otherwise company name) BP_NAME1CHAR40TEXT40
ORG_NAME2Name 2 (Continuation of NAME 1) BP_NAME2CHAR40TEXT40
CALENDARIDFactory calendar BP_CAL_IDCHAR2TFACDWFCID
LEGAL_ENTYLegal Form of Organization BP_LEG_ETY_OLDNUMC2TP08BP_LEG_ETY
LEGAL_ORGLegal Entity of Organization BP_LEG_ORG_OLDNUMC2TP09BP_LEG_ORG
BALANCE_FLBalance Sheet Display BP_BAL_FLGCHAR1BP_BAL_FLG
FOUND_YEARFoundation Year of Organization BP_FOUND_YNUMC4GJAHRGJAHR
COMM_REGISEntry in Commercial Register BP_COM_REGCHAR50TEXT50
COMM_REG_DDate of Entry in Commercial Register BP_COM_R_DDATS8DATUM
CNTRY_COMPCountry of Organization's Registered Office BP_CNTR_HDCHAR3T005LAND1
REGIORegion of Registered Office BP_REGIO_HDCHAR3T005SREGIO
COMP_HEADRegistered Office BP_COMP_HDCHAR35TEXT35
LIQUID_DATDate of Liquidation BP_LIQUI_DDATS8DATUM
COMP_NRInternational location number (part 1) BBBNRNUMC7NUM07
COMP_NR_ADInternational location number (Part 2) BBSNRNUMC5NUM05
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
IND_SECTORIndustry Keys BP_BRSCH_OLDCHAR4T016BRSCH
MIN_RESERVBank Subject to Minimum Reserve Requirement BP_MIN_RSVCHAR1XFELD
BAL_SH_CURBalance Sheet Currency BP_BAL_CURCUKY5TCURCWAERS
CAP_INCR_AAmount of last capital increase BP_CA_IN_ACURR15(2) WERTV8
CAP_INCR_YYear of Last Capital Increase BP_CA_IN_YNUMC4GJAHRGJAHR
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
ADRNRAddress Number BP_ADRNR_OLDCHAR10SANS1SADRNR
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ADRCALPHAAD_ADDRNUMADR
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
ADR_D_EBusiness Partner Address Relationship Valid Until BP_ADR_D_EDATS8DATUM
ADR_LOCBuilding BP_ADR_LOCCHAR20CHAR20
FLOORFloor BP_FLOORCHAR10CHAR10
ROOM_NRRoom Number BP_ROOM_NRCHAR10CHAR10
NAME3Name 3 BP_NAME3CHAR40TEXT40
NAME4Name 4 BP_NAME4CHAR40TEXT40
NAME_COc/o Name BP_NAME_COCHAR40TEXT40
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
TELF1First telephone number TELF1CHAR16TEXT16
TELF2Second telephone number TELF2CHAR16TEXT16
TELFX1Fax Number TELFXCHAR31TEXT31
TELFX2Fax Number TELFXCHAR31TEXT31
TELBXTelebox number TELBXCHAR15TEXT15
TELX1Telex number TELX1CHAR30TEXT30
DATLTData communication line no. DATLTCHAR14TEXT14
TELTXTeletex number TELTXCHAR30TEXT30
ADSMTPE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
TELNR_CALL1Telephone number for determining caller AD_TELNRCLCHAR30CHAR30
TELNR_CALL2Telephone number for determining caller AD_TELNRCLCHAR30CHAR30
STRASHouse number and street STRAS_GPCHAR35TEXT35
STRA1House number and street STRAS_GPCHAR35TEXT35
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_GPCHAR35TEXT35
PSTLZPostal Code PSTLZCHAR10PSTLZ
PSTBZPost delivery district PSTBZCHAR15PSTBZ
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1

Key field Non-key field



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

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

How to access SAP table VIGW_R_VZGPM1F

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