SAP Table VN1CORDTYP
IS-H: Clinical Order Type (Update Structure)
VN1CORDTYP (IS-H: Clinical Order Type (Update Structure)) 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 VN1CORDTYP to other SAP tables.
VN1CORDTYP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||
|
CORDTYPID
IS-H: CORD/PREG: Identification of the Clinical Order Type
|
N1COTID |
CHAR
|
32 | 0 | ||||||||||||||||
|
LTDTR
IS-H: CORD/PREG: CORD Type: Order Fillers Restricted
|
N1COTLTDTR |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
LTDAV
IS-H: CORD/PREG: Clincical Order Type - Initiator Restricted
|
N1COTLTDAV |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
EXTGPA
IS-H: CORD/PREG: CORD Type - External Bus. Partner Allowed
|
N1COTEXTGPA |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
AVLWEB
IS-H: CORD/PREG: Clin. Order Type is Available in Internet
|
N1COTAVLWEB |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
FALAR
CORD/PREG: Clinical Order Type: Default Case Type
|
N1COTFALAR |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
CORDTPR
IS-H: CORD/PREG: CORD Type: Profile Type Indicator
|
N1COTPR |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
PREREG
Is-H: CORD/PREG: Clinical Order Item of Type "Preregistered"
|
N1COTPREREG |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WLSTA
IS-H: CORD/PREG: CORD Type - Default Waiting List Status
|
N1COTWLSTA | TN42C |
CHAR
|
2 | 0 | |||||||||||||||
|
WLTYP
IS-H: CORD/PREG: CORD Type - Default Waiting List
|
N1COTWLTYP | TN42A |
CHAR
|
6 | 0 | |||||||||||||||
|
CASEOBL
IS-H: CORD/PREG: Clinical Order Type - Case Mandatory
|
N1COTCASEOBL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BEWTY
CORD/PREG: Clinical Order Type - Movement Category
|
N1COTBEWTY |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
BEGDT
IS-H: CORD/PREG: Clinical Order Type - Validity Start Date
|
N1COTBEGDT |
DATS
|
8 | 0 | ||||||||||||||||
|
ENDDT
IS-H: CORD/PREG: Clinical Order Type - Validity End Date
|
N1COTENDDT |
DATS
|
8 | 0 | ||||||||||||||||
|
LOEKZ
Deletion Flag/Indicator
|
RI_LOEKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
LOUSR
User Who Deleted Record
|
RI_LOUSR |
CHAR
|
12 | 0 | ||||||||||||||||
|
LODAT
Date of Deletion
|
RI_LODAT |
DATS
|
8 | 0 | ||||||||||||||||
|
ERUSR
IS-H: Name of Employee who Created Record
|
RI_ERNAM |
CHAR
|
12 | 0 | ||||||||||||||||
|
ERDAT
IS-H: Date when Record Created
|
RI_ERDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
UPDAT
IS-H: Date of Last Change
|
RI_UPDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
UPUSR
IS-H: Name of Person who Last Changed Data
|
RI_UPNAM |
CHAR
|
12 | 0 | ||||||||||||||||
|
REQCOMP
IS-H: Equivalent Request Type (Migration)
|
N1COTREQCOMP |
CHAR
|
6 | 0 | ||||||||||||||||
|
CYINAC
ISHMED: Cycle Input Active
|
N1CCYINAC |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
STDCORDTYP
IS-H: CORD/PREG: Indicator for Standard Order Type
|
N1CORDSTDCORDTYP |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZ
Change Type (U, I, S, D)
|
CDCHNGIND |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
VN1CORDTYP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| VN1CORDTYP | MANDT | VN1CORDTYP | MANDT |
T000
Clients
|
MANDT |
| VN1CORDTYP | WLSTA | VN1CORDTYP | WLSTA |
TN42C
IS-H: Preregistration Status
|
WLSTA |
| VN1CORDTYP | WLSTA | VN1CORDTYP | MANDT |
TN42C
IS-H: Preregistration Status
|
MANDT |
| VN1CORDTYP | WLSTA | * |
TN42C
IS-H: Preregistration Status
|
EINRI | |
| VN1CORDTYP | WLTYP | VN1CORDTYP | MANDT |
TN42A
IS-H: Waiting List Type
|
MANDT |
| VN1CORDTYP | WLTYP | * |
TN42A
IS-H: Waiting List Type
|
EINRI | |
| VN1CORDTYP | WLTYP | VN1CORDTYP | WLTYP |
TN42A
IS-H: Waiting List Type
|
WLTYP |