N_VTCSEL SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

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

The N_VTCSEL table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include BELNR (IS-H: Document Number of IV Document/Treatment Certificate), EINRI (Institution), FALNR (IS-H: Case Number), LFDNR (IS-H: Sequence Number of Movement).. 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: Not classified


SAP N_VTCSEL table view 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 MANDTCLNT3MANDT
BELNRIS-H: Document Number of IV Document/Treatment Certificate KS_BELNRCHAR10ALPHAKS_BELNR
EINRIInstitution EINRICHAR4TN01ALPHAEINRIEIN
FALNRIS-H: Case Number FALNRCHAR10ALPHAFALNRFAL
LFDNRIS-H: Sequence Number of Movement LFDBEWNUMC5LFDBEW
NBKZFALNRIS-H: Case Number FALNRCHAR10NFALALPHAFALNRFAL
NBKZEINRIInstitution EINRICHAR4TN01ALPHAEINRIEIN
ABGDTIS-H: Date when IV/Certificate Fully Completed KS_ABGDTDATS8KS_ABGDT
KSTYPIS-H: External Category of IV Document/Treatment Certificate KS_TYPCHAR2TN19AALPHAKS_TYP
KSTYIIS-H: Internal Category of Insurance Verification/Certific. KS_TYPINTCHAR2ALPHAKS_TYPINT
KSARTIS-H: Type of IV Document/Treatment Certificate per Category KS_ARTCHAR2TN19BALPHAKS_ART
EBZEIIS-H: Reference of IV/Certificate at Recipient KS_EBZEICHAR20KS_EBZEI
TCSTORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
APSTATEIS-H: Application Status ISH_APSTATECHAR2ISH_APSTATE
PFDATPerformance Date ISH_TC_PERF_DATEDATS8RI_DATUM
EXPIDIdentifier for Referring Physician ISH_TC_EXPIDCHAR16CHAR16
BOKDTBooking Date ISH_TC_BOOK_DATEDATS8RI_DATUM
ASTDTDate when Sickness Certificate Issued to the Insured ASTDTDATS8RI_DATUM
PFMODPerformance Mode ISH_TC_PERF_MODECHAR1TN19LISH_TC_PERF_MODE
EXCATExemption Category ISH_TC_EXCATCHAR2TN19FALPHAISH_TC_EXCAT
TCPRIPriority ISH_TC_PRIORITYCHAR2TN19KISH_TC_PRIORITY
RETRIRecommended Treatment Indicator ISH_TC_RETRICHAR1TN19NISH_TC_RETRI
EXCODExemption Code ISH_TC_EXCODECHAR6TN19JISH_TC_EXCODE
UEXIDUnique External ID ISH_TC_UEXIDCHAR10ISH_TC_UEXID
TCLASTreatment Certificate Class ISH_TC_CLASSCHAR2TN19MISH_TC_CLASS
TCABRKZBilling Indicator ISH_TRTCRT_ABRKZCHAR1ABRKZ_TC
PATNRIS-H: Patient Number PATNRCHAR10NPATALPHAPATNRPAT
FALARIS-H: Case Type FALLARTCHAR1FALLART
ISTAT_RESISTAT Code ISH_ISTATCHAR6ISH_ISTAT
ASL_RESASL as Insurance Provider ISH_ASL_KOSTRCHAR10ALPHARI_KUNNR
BWIDTIS-H: Date of Movement BWIDTDATS8RI_DATUM
ORGPFOrganizational Unit Assigned to Case NZUWPFCHAR8NORGALPHAORGID
RFSRCIS-H: Referral, Postdischarge Treatment Type ISH_REFSRCCHAR2ALPHAISH_REFSRC
PLANBIS-H: Planned Indicator for Date of Movement PLANBCHAR1ISH_PLAN
ITREGRegion ISH_ITREGCHAR3TN50RISH_ITREG
GSCHLIS-H: Sex Indicator - Internal GSCHLCHAR1GSCHL
GBDATIS-H: Birthdate RI_GBDATDATS8RI_DATUM
NATIOIS-H: Nationality RI_NATIOCHAR3T005LAND1
HEALTHIDPatient ID for Data Exchange ISH_IT_HEALTHIDCHAR16ISH_IT_HEALTHID
STRASIS-H: Street ISH_STRASSCHAR40TEXT40

Key field Non-key field



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

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

SELECT SINGLE *
FROM N_VTCSEL
INTO CORRESPONDING FIELDS OF WA_N_VTCSEL
WHERE...

How to access SAP table N_VTCSEL

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