SAP Table
() is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link to other SAP tables.
table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| EINRI | Institution | EINRI | TN01 | CHAR | 4 | 0 | ||||||
| FALNR | IS-H: Case Number | FALNR | NFAL | CHAR | 10 | 0 | ||||||
| LFDNR | IS-H: Sequence Number of Movement | LFDBEW | NBEW | NUMC | 5 | 0 | ||||||
| INTNR | NWAT_INTENSIV_LFDNR | NUMC | 3 | 0 | ||||||||
| AUFART | N1AUFART | CHAR | 1 | 0 | ||||||||
| AUFTYP | N1AUFTYP | CHAR | 1 | 0 | ||||||||
| AIDS | N1AIDS | CHAR | 1 | 0 |
Possible values
|
|||||||
| METAST | N1METAM | CHAR | 1 | 0 |
Possible values
|
|||||||
| HAEMAT | N1HAEMAT | CHAR | 1 | 0 |
Possible values
|
|||||||
| ENTDT | N1ENTDATIN | DATS | 8 | 0 | ||||||||
| ENTZT | N1ENTSTDIN | TIMS | 6 | 0 | ||||||||
| ENTZUST | N1ENTZUST | CHAR | 1 | 0 | ||||||||
| ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | 0 | |||||||
| ERTIM | IS-H: Time Record Created | RI_ERTIM | TIMS | 6 | 0 | |||||||
| ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | 0 | |||||||
| UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | 0 | |||||||
| UPTIM | IS-H: Time of Last Change | RI_UPTIM | TIMS | 6 | 0 | |||||||
| UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | 0 | |||||||
| STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | 0 |
Possible values
|
||||||
| STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | 0 | |||||||
| STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | 0 | |||||||
| MODELL | NWAT_SCO_MODELL | CHAR | 1 | 0 | ||||||||
| TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | ISH_TIMESTAMP | DEC | 15 | 0 | |||||||
foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| NWATINTENS | EINRI | NWATINTENS | MANDT | TN01 | IS-H: Institutions | MANDT |
| NWATINTENS | EINRI | NWATINTENS | EINRI | TN01 | IS-H: Institutions | EINRI |
| NWATINTENS | FALNR | NWATINTENS | MANDT | NFAL | IS-H: Cases | MANDT |
| NWATINTENS | FALNR | NWATINTENS | EINRI | NFAL | IS-H: Cases | EINRI |
| NWATINTENS | FALNR | NWATINTENS | FALNR | NFAL | IS-H: Cases | FALNR |
| NWATINTENS | LFDNR | NWATINTENS | LFDNR | NBEW | IS-H: Movements for Case | LFDNR |
| NWATINTENS | LFDNR | NWATINTENS | MANDT | NBEW | IS-H: Movements for Case | MANDT |
| NWATINTENS | LFDNR | NWATINTENS | EINRI | NBEW | IS-H: Movements for Case | EINRI |
| NWATINTENS | LFDNR | NWATINTENS | FALNR | NBEW | IS-H: Movements for Case | FALNR |
| NWATINTENS | MANDT | NWATINTENS | MANDT | T000 | Clients | MANDT |
