N3BGHAVB SAP () Table details

Dictionary Type: Table
Description:




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




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

N3BGHAVB is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.

The N3BGHAVB table consists of various fields, each holding specific information or linking keys about data available in SAP. These include DOKAR (Document Type), DOKNR (Document number), DOKVR (Document Version), DOKTL (Document Part).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP N3BGHAVB table 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
DOKARDocument Type DOKARCHAR3Assigned to domainDOKARCV2
DOKNRDocument number DOKNRCHAR25Assigned to domainALPHADOKNRCV1
DOKVRDocument Version DOKVRCHAR2DOKVRCV3
DOKTLDocument Part DOKTL_DCHAR3DOKTLCV4
N3BG_VIN_LPMD: Reference by GUUID N2_REFUUIDCHAR32SYSUUID_C
N3BG_UVTGPIS-H: Business Partner GPARTNERCHAR10Assigned to domainALPHARI_KUNNRNGP
N3BG_UVNAM N3BG_NAMECHAR80N3BG_NAME
N3BG_UVIKNIS-H: Institute Indicator INSTNRCHAR10ALPHAINSTNR
N3BG_UVDAT N3BG_DATSDATS8DATS
N3BG_UFDATAccident Date UNFDTDATS8RI_DATUM
N3BG_UVAKZIS-H: Number of Case on File with Insurance Provider RI_AKTKZCHAR20CHAR20
N3BG_UVT_CReserve field XFELD N2_XFELDCHAR1XFELD
N3BG_TE414PMD: Reference by GUUID N2_REFUUIDCHAR32SYSUUID_C
N3BG_AFV1 N3BG_DATSDATS8DATS
N3BG_AFV2Reserve field XFELD N2_XFELDCHAR1XFELD
N3BG_AFV3 N3BG_BETXTCHAR100TEXT100
N3BG_AFV4 N3BG_DAUAUNUMC3NUMC03
N3BG_AFV5 N3BG_DAUEHCHAR1N3BG_DAUEH
N3BG_AFV6 N3BG_DATSDATS8DATS
N3BG_ABSGPIS-H: Business Partner GPARTNERCHAR10Assigned to domainALPHARI_KUNNRNGP
N3BG_ABLANVehicle country key LANDKCHAR3LANDK
N3BG_ABNAM N3BG_NAMECHAR80N3BG_NAME
N3BG_ABPLZIS-H: Postal Code of Business Partner PSTLZ_GPCHAR10PSTLZ
N3BG_ABORTIS-H: City of Business Partner ORT_GPCHAR25TEXT25
N3BG_ABSTRIS-H: Street Name and Street Number of Business Partner STRASSE_GPCHAR30STRAS
N3BG_ABTELIS-H: Telephone Number of Business Partner TELEFON_GPCHAR16TEXT16
N3BG_AB2GPIS-H: Business Partner GPARTNERCHAR10Assigned to domainALPHARI_KUNNRNGP
N3BG_ABS7 N3BG_NAMECHAR80N3BG_NAME
N3BG_ABS8Checkbox XFELDCHAR1XFELD
N3BG_ABS_CCheckbox XFELDCHAR1XFELD
N3BG_NNAMEPatient Last Name NNAME_PATCHAR30TEXT30
N3BG_VNAMEIS-H: Patient First Name VNAME_PATCHAR30TEXT30
N3BG_TITLEIS-H: Title RI_TITELCHAR15Assigned to domainTITEL
N3BG_NAMZUIS-H: Name Affix RI_NAMZUCHAR15Assigned to domainTITEL
N3BG_VORSWIS-H: Name Prefix RI_VORSWCHAR15Assigned to domainTITEL
N3BG_GBDATIS-H: Birthdate RI_GBDATDATS8RI_DATUM
N3BG_GESIS-H: Sex Indicator - Internal GSCHLCHAR1GSCHL
N3BG_NATIS-H: Nationality RI_NATIOCHAR3Assigned to domainLAND1
N3BG_TELIS-H: Telephone Number ISH_TELNRCHAR30CHAR30
N3BG_STRIS-H: Street ISH_STRASSCHAR40TEXT40
N3BG_LANDIS-H: Country ISH_LANDCHAR3Assigned to domainLAND1
N3BG_PSTLZIS-H: Postal Code of City ISH_PSTLZOCHAR10PSTLZ
N3BG_ORTIS-H: City ISH_CITY1CHAR40TEXT40

Key field Non-key field



How do I retrieve data from SAP table N3BGHAVB using ABAP code

The following ABAP code Example will allow you to do a basic selection on N3BGHAVB to SELECT all data from the table
DATA: WA_N3BGHAVB TYPE N3BGHAVB.

SELECT SINGLE *
FROM N3BGHAVB
INTO CORRESPONDING FIELDS OF WA_N3BGHAVB
WHERE...

How to access SAP table N3BGHAVB

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