SAP ABAP Table V_NLEM (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_NLEM   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
3 FALNR FALNR FALNR CHAR 10   0   IS-H: Case Number NFAL
4 ORGID ORGID_LS ORGID CHAR 8   0   IS-H: Org. Unit (for OU-Related Service Entry Only) NORG
5 LEIST TARLS TARLS CHAR 10   0   IS-H: Service in Service Catalog  
6 LNRLS LNRLS LNRLS CHAR 10   0   IS-H: Service Sequence Number  
7 LFDBEW LFDBEW LFDBEW NUMC 5   0   IS-H: Sequence Number of Movement NBEW
8 REFBEW REFBEW LFDBEW NUMC 5   0   IS-H: Movement which Caused Service Split NBEW
9 ERBTY TYP_ERBR TYP_ERBR CHAR 1   0   IS-H: Type of Service Performance  
10 ANFOE ANFOE ORGID CHAR 8   0   IS-H: Departmental Org. Unit Requesting Service NORG
11 ANMAN MANUELL XFELD CHAR 1   0   IS-H: Default Value Changed Manually  
12 ERBOE ERBOE ORGID CHAR 8   0   IS-H: Organizational Unit that Performs the Service NORG
13 ERMAN MANUELL XFELD CHAR 1   0   IS-H: Default Value Changed Manually  
14 HAUST TARID TARID CHAR 2   0   IS-H: Service Catalog Identification Key TNK01
15 PREIS RI_PREIS WERT6 CURR 11   2   IS-H: Indiv. Price of Service Different from Service Master  
16 MATNR MATNR_LS MATNR CHAR 18   0   IS-H: Material Number of Service MARA
17 ABRKZ ABRKZ ABRKZ_LS CHAR 1   0   IS-H: Service Can Be Billed for  
18 STALS STATUS_LS STATUS_LS CHAR 1   0   IS-H: Service Status (Planned/Performed)  
19 IMENG I_MENG_LS LEISMENGE NUMC 4   0   Service Quantity  
20 IBGDT I_BDT_LS RI_DATUM DATS 8   0   IS-H: Date when Service Performance Starts (Actual)  
21 IENDT I_EDT_LS RI_DATUM DATS 8   0   IS-H: Date when Service Performance Ends (Actual)  
22 IBZT I_BZT_LS UHRZT TIMS 6   0   IS-H: Time when Service Performance Starts (Actual)  
23 IEZT I_EZT_LS UHRZT TIMS 6   0   IS-H: Time Service Performance Ends (Actual)  
24 PMENG P_MENG_LS LEISMENGE NUMC 4   0   IS-H: Service Quantity (Planned)  
25 PBGDT P_BDT_LS RI_DATUM DATS 8   0   IS-H: Start Date of Service Performance (PLANNED)  
26 PENDT P_EDT_LS RI_DATUM DATS 8   0   IS-H: Date Service Performance Ends (PLANNED)  
27 PBZT P_BZT_LS UHRZT TIMS 6   0   IS-H: Time Service Performance Starts (PLANNED)  
28 PEZT P_EZT_LS UHRZT TIMS 6   0   IS-H: Time Service Performance Ends (PLANNED)  
29 TARIF TARID TARID CHAR 2   0   IS-H: Service Catalog Identification Key TNK01
30 TARLS TARLS TARLS CHAR 10   0   IS-H: Service in Service Catalog  
31 TARSP TARSP TARSP CHAR 2   0   IS-H: Column in Service Catalog  
32 TARAS TARAS6 ISH_TARAS6 DEC 6   3   IS-H: Multiplication Factor  
33 TLMEN TL_MEN_LS LEISMENGE NUMC 4   0   IS-H: Partial Delivery Quantity of Service  
34 LEINH TA_EINH MEINS UNIT 3   0   IS-H: Unit of Measure for Service  
35 LEITX TEXT_LEI LEIKTXT CHAR 40   0   IS-H: Service Short Text (may Differ from Service Master)  
36 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
37 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
38 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
39 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
40 STORN RI_STORN XFELD CHAR 1   0   IS-H: Cancellation Indicator  
41 STUSR STORN_USER USNAM CHAR 12   0   IS-H: Name of User who Canceled Data Record  
42 REFLNR LFDLEI LNRLS CHAR 10   0   IS-H: Sequence Number per Service (Time-Dependent)  
43 ZEITR NZEITRLS NZEITRLS CHAR 1   0   IS-H: Indicator for Extended Service  
44 BEGTX BEGRUENDTX ISH_CHAR40 CHAR 40   0   IS-H: Reason for Multiplication Factor  
45 WNDNR ISH_WNDNR ISH_WNDNR CHAR 10   0   IS-H: Wound Number  
46 REMRK ISH_REMRK ISH_REMRK CHAR 40   0   IS-H: User's Comment on Service  
47 REFNR ISH_REFNR ISH_REFNR CHAR 10   0   _  
48 KZBCP ISH_KZBCP ISH_KZBCP CHAR 1   0   _  
49 BILLP ISH_BILLP ISH_BILLP CHAR 1   0   IS-H NL: Invoicing Party (Hospital or Physician)  
50 ANPOE ANPOE ORGID CHAR 8   0   IS-H: Nursing Org. Unit Requesting Service NORG
51 APMAN MANUELL XFELD CHAR 1   0   IS-H: Default Value Changed Manually  
52 REMKZ SPRAS SPRAS LANG 1   0   Language Key  
53 ICPMK ICPM_ID TARID CHAR 2   0   IS-H: Identification of Surgical Procedure Coding Catalog TNK01
54 ICPML ICPM_LS TARLS CHAR 10   0   IS-H: Surgical Procedure Code (Service) NTPK
55 ICPHC ICPM_HCODE XFELD CHAR 1   0   IS-H: Main Surgical Procedure Code  
56 BEGKZ SPRAS SPRAS LANG 1   0   Language Key  
57 HCOKZ ISH_HCOKZ XFELD CHAR 1   0   IS-H: Service Relevant for CO  
58 ANART ANALYSEART ANALYSEART CHAR 1   0   IS-H: Analysis Type for Service (DKG-NT Germany)  
59 OTYPL ISH_OTYPL ISH_OTYPL CHAR 1   0   IS-H: Object Type of Service  
60 UBVON ISH_UBVON RI_DATUM DATS 8   0   IS-HCO: Start of Transfer  
61 UBBIS ISH_UBBIS RI_DATUM DATS 8   0   IS-HCO: End of Transfer  
62 UBLKZ ISH_UBLKZ ISH_UBLKZ CHAR 1   0   IS-HCO: Transfer Indicator for Service/Material  
63 UMENG ISH_UMENG LEISMENGE NUMC 4   0   IS-HCO: Transferred Service Quantity  
64 UAEKZ ISH_UAEKZ XFELD CHAR 1   0   IS-HCO: Service/Material Was Changed after Transfer into CO  
65 NUBKZ ISH_NUBKZ XFELD CHAR 1   0   IS-HCO: Ind. that service is permanently not transferable  
66 ENTKY ENTKEY ENTKEY CHAR 2   0   Charge Key for Paragraph 301 / DALE-UV  
67 ENZKY NZUSKEY NZUSKEY CHAR 1   0   IS-H: Add. Key for Charge Type for FR/Case, Proc.Surcharges  
68 ENTG2 ENTGART2 ENTGART2 CHAR 5   0   IS-H: Charge Type According to §301  
69 EVENT LEI_EVENT ISH_EVENT NUMC 2   0   IS-H: Event that generates services  
70 OBJCT LEI_OBJECT ISH_OBJECT CHAR 10   0   IS-H: Object that generated services  
71 KALKZ ISH_KALKZ XFELD CHAR 1   0   IS-H: For Internal Purposes Only, DB Contents Irrelevant  
72 EVTUP LEI_EVT_UP ISH_EVT_UP NUMC 2   0   IS-H: Event that Changed Services  
73 OBJUP LEI_OBJ_UP ISH_OBJ_UP CHAR 10   0   IS-H: Object that changed services  
74 ABTYP LEI_ABTYP ISH_ABTYP CHAR 4   0   IS-H: Billing Category for Individual Billing Control TN21Y
75 TCODE ISH_TCODE TCODE CHAR 20   0   IS-H: Report Control: Transaction Code for Application  
76 ABRMA MANUELL XFELD CHAR 1   0   IS-H: Default Value Changed Manually  
77 EAUFN ISH_KAUFN AUFNR CHAR 12   0   IS-HCO: Cost Object (Order)  
78 BZLST ISH_BZLST LNRLS CHAR 10   0   IS-HCO: Sequence Number of Reference Service  
79 KTRKZ ISH_KTRKZ XFELD CHAR 1   0   IS-H: Service is Cost Object  
80 BFORM BFORMEL BFORMEL CHAR 2   0   IS-H: Valuation Formula for Extended Services  
81 ENTGA ENTGART ENTGART CHAR 2   0   IS-H: Charge Type for Service  
82 NBGDT ISH_FDATUM RI_DATUM DATS 8   0   IS-H: Date of Next Extended Service  
83 NBGZT ISH_FZEIT UHRZT TIMS 6   0   IS-H: Start Time of Subsequent Extended Service  
84 ZOTYP ISH_ZUOTYP ISH_ZUOTYP CHAR 3   0   IS-H: Type of Service Assignment TNT0
85 PZAHL ISH_PZAHL ISH_PZAHL DEC 11   2   IS-H: Charge Factor  
86 REFKY REFKY ISH_REFKY CHAR 20   0   IS-H: Reference Code for Service from External System  
87 EXCAT ISH_EXTCAT ISH_EXTCAT CHAR 20   0   IS-H: Classification for External Communication  
88 USER0 ISH_USER00 ISH_C20 CHAR 20   0   IS-H: Customer-Specific Field 1  
89 USER1 ISH_USER01 ISH_C20 CHAR 20   0   IS-H: Customer-Specific Field 2  
90 USERDATE1 ISH_USERBEGIN RI_DATUM DATS 8   0   IS-H: Customer-Specific Field for Start Date  
91 USERDATE2 ISH_USEREND RI_DATUM DATS 8   0   IS-H: Customer-Specific Field for End Date  
92 USERTIME1 ISH_USERTIME_BEGIN UHRZT TIMS 6   0   IS-H: Customer-Specific Field for Start Time  
93 USERTIME2 ISH_USERTIME_END UHRZT TIMS 6   0   Customer-Specific Field for End Time  
94 USERPRICE1 ISH_USERPRICE WERT6 CURR 11   2   IS-H: Customer-Specific Field for Amount  
95 USERAMOUNT1 ISH_USERAMOUNT MENGE QUAN 13   3   IS-H: Customer-Specific Field for Quantity  
96 USERUNIT1 ISH_USERUNIT MEINS UNIT 3   0   IS-H: Customer-Specific Field for Unit  
97 USERSIGN1 ISH_USERSIGN_1 XFELD CHAR 1   0   IS-H: Customer-Specific Checkbox 1  
98 USERSIGN2 ISH_USERSIGN_2 XFELD CHAR 1   0   IS-H: Customer-Specific Field for Checkbox 2  
99 SEQUE ISH_INPUT_SEQUENCE NUMC10 NUMC 10   0   IS-H: Entry Sequence for Object  
100 USER2 ISH_USER02 ISH_C20 CHAR 20   0   IS-H: Customer-Specific Field 3  
101 USERTEXT1 ISH_USERTEXT1 TEXT_80 CHAR 80   0   IS-H: Customer-Specific Field for Free Text  
102 VIEWTYPE NVIEWTYPE NVIEWTYPE CHAR 3   0   View Type  
103 FORMNAME ISH_FORM_NAME   CHAR 15   0   IS-H: Form Name for Service Entry  
104 FORMBELNR ISH_FORM_BELNR   NUMC 2   0   IS-H: Document Number of Service Form  
105 NLSLOK N1LSLOK N2_DIALO CHAR 2   0   Localization of Service TN26E
106 MDIND NWCH_MDIND XFELD CHAR 1   0   IS-H: Service for Medical Indication  
107 HIC_FREE NWAT_HIC_FREE ISH_ON_OFF CHAR 1   0   Kennzeichen Kassenfreie Leistung  
108 PATNR PATNR PATNR CHAR 10   0   IS-H: Patient Number NPAT
109 STOID N1STOID N1STOID CHAR 3   0   Reason for Canceling Medical Object  
110 LSSTAE N1LSSTAE N1LSSTAE CHAR 3   0   Service Status - User-Specific  
111 ANFID ANFID ANFID NUMC 8   0   Identification of a Request (Number)  
112 NTRKZ NTRKZ XFELD CHAR 1   0   Indicator for Subsequently Added Service  
113 WBGDT W_BDT_LS RI_DATUM DATS 8   0   Desired Start Date of a Service  
114 WBGZT W_BZT_LS UHRZT TIMS 6   0   Desired Start Time of a Service  
115 ERGTX N1ERGTX TEXT50 CHAR 50   0   Supplementary Text  
116 ERLTX RI_LGTXT XFELD CHAR 1   0   Indicator that Long Text Exists  
117 BEFR N1BEFR N1I1 INT1 3   0   Service Time Limit  
118 BFEINH N1BEFEH N1BEFEH CHAR 1   0   Unit for Time Limit  
119 BFENDDT N1BFENDDT DATS DATS 8   0   End Date of Service with Time Limit  
120 SORTLEIST N1_BEWNR N1N002 NUMC 2   0   Sort Number  
121 WBZPI N1ZPI_INT N1ZPI_INT CHAR 2   0   Time Interpretation - Internal Format  
122 DAUER ISH_APTIME ISH_DZEIT NUMC 4   0   IS-H: Duration in Minutes for Treatment Appointment  
123 ZIMMR ISH_ZIMMID BAUID CHAR 8   0   IS-H: Building ID of Room NBAU
124 IFG N1IFG_INT NUMC2 NUMC 2   0   Degree of Infection - Internal Format  
125 ANERF N1ANERF XFELD CHAR 1   0   Anesthetist Required  
126 LSLOK N1LSLOK N2_DIALO CHAR 2   0   Localization of Service  
127 PATEIN N1PATEIN N1PATEIN1 CHAR 1   0   Patient Consent  
128 PMEDFG N1PMEDFG XFELD CHAR 1   0   Surgeon's Release  
129 PMEDVS N1PMEDVS XFELD CHAR 1   0   Premedication Complete  
130 PZMAN N1PZMAN XFELD CHAR 1   0   Plan Time Manually Fixed  
131 ANKLS N1ANKLS N1ANKLS CHAR 1   0   Anchor Service Indicator  
132 OPNR N1OPNR CHAR10 CHAR 10   0   Surgery Number  
133 N1MEDLEI N1MEDLEI XFELD CHAR 1   0   Medical Service Indicator  
134 N1PFLLEI N1PFLLEI XFELD CHAR 1   0   Nursing Service Indicator  
135 DOCXS RI_MARK XFELD CHAR 1   0   IS-H: Checkbox to Select a Row  
136 TEAMXS RI_MARK XFELD CHAR 1   0   IS-H: Checkbox to Select a Row  
137 MATXS RI_MARK XFELD CHAR 1   0   IS-H: Checkbox to Select a Row  
138 PATNUE N1PATNUE XFELD CHAR 1   0   Patient Fasting Indicator  
139 TERMINF N1TERMINF CHAR1 CHAR 1   0   Appointment Released Indicator  
140 LIDI N1LID_INT NUM3 NUMC 3   0   Position ID Internal  
141 VKGID N1VKGID N1VKGID NUMC 8   0   IS-H: CORD/PREG: ID of an Order Item (Preregistration) N1VKG
142 LNRAPP ISH_LNRAPP ISH_LNRAPP CHAR 10   0   IS-H: Sequence Number of Provisional Appointment  
143 TMNID ISH_TMNID ISH_LNRAPP CHAR 10   0   IS-H: Identification of Appointment NTMN
144 VBUND N1LEMVBD XFELD CHAR 1   0   Leistung an Verbund melden  
145 PAPID ISH_PAPID ISH_PAPID CHAR 10   0   IS-H: Provisional Patient Number NPAP
146 HIC_FREE_MED NWAT_HIC_FREE ISH_ON_OFF CHAR 1   0   Kennzeichen Kassenfreie Leistung  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_NLEM ABTYP TN21Y ABTYP REF 1 CN
2 V_NLEM ANFOE NORG ORGID REF 1 CN
3 V_NLEM ANPOE NORG ORGID REF 1 CN
4 V_NLEM EINRI TN01 EINRI KEY 1 CN
5 V_NLEM ERBOE NORG ORGID REF 1 CN
6 V_NLEM FALNR NFAL FALNR KEY 1 CN
7 V_NLEM HAUST TNK01 KATID REF 1 CN
8 V_NLEM ICPMK TNK01 KATID REF C CN
9 V_NLEM ICPML NTPK TALST REF C CN
10 V_NLEM LFDBEW NBEW LFDNR REF 1 CN
11 V_NLEM MANDT T000 MANDT KEY 1 CN
12 V_NLEM MATNR MARA MATNR KEY 1 CN
13 V_NLEM NLSLOK TN26E DIALO REF C CN
14 V_NLEM ORGID NORG ORGID KEY 1 CN
15 V_NLEM PAPID NPAP PAPID REF C CN
16 V_NLEM PATNR NPAT PATNR REF C CN
17 V_NLEM REFBEW NBEW LFDNR REF C CN
18 V_NLEM TARIF TNK01 KATID REF C CN
19 V_NLEM TMNID NTMN TMNID REF C CN
20 V_NLEM VKGID N1VKG VKGID REF C CN
21 V_NLEM ZIMMR NBAU BAUID REF C CN
22 V_NLEM ZOTYP TNT0 ZOTYP KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in