SAP ABAP Table NEO_NFAL (IS-H: External Orders - Order Data)
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
⤷ NEO1 (Package) IS-H: External Order
⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
⤷ NEO1 (Package) IS-H: External Order
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | NEO_NFAL | Table Relationship Diagram |
Short Description | IS-H: External Orders - Order Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | AFART | NEO_ORDTYP | NEO_ORDTYP | CHAR | 1 | 0 | External Order - Order Type | TNEO_ORDER_TYPE | |
5 | AUTYP | NEO_ORDCAT | NEO_ORDCAT | CHAR | 2 | 0 | External Order - Order Category | TNEO_ORDER_CAT | |
6 | KTTAR | NCH_TARCDE | NCH_TARCDE | CHAR | 3 | 0 | IS-H CH: Canton Tariff | TNCH12 | |
7 | EINDAT | EIN_DAT | RI_DATUM | DATS | 8 | 0 | IS-H: EA Eingangsdatum des Auftrags | ||
8 | EINZT | EIN_ZT | UHRZT | TIMS | 6 | 0 | IS-H: EA Eingangsuhrzeit des Auftrags | ||
9 | EAUFNR | EIN_AUFNR | EAUFNR | CHAR | 35 | 0 | IS-H: EA Einsender-Auftragsnummer | ||
10 | EKRZ | EKRZ | TEXT12 | CHAR | 12 | 0 | IS-H: EA Einsender-Kürzel | ||
11 | REFG | REFG | CHAR20 | CHAR | 20 | 0 | IS-H: EA Referenznummer des Garanten | ||
12 | ABT_ARZT | ABT_ARZT | TEXT50 | CHAR | 50 | 0 | IS-H: EA Abteilungsbezeichnung oder Arztname | ||
13 | LAUFNR | LAB_AUFNR | LAUFNR | CHAR | 16 | 0 | IS-H: EA Labor-Auftragsnummer | ||
14 | BEMINT | BEMINT | TEXT50 | CHAR | 50 | 0 | IS-H: EA Interne Bemerkungen | ||
15 | BEMINTL | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
16 | BEMEXT | BEMEXT | TEXT50 | CHAR | 50 | 0 | IS-H: EA Externe Bemerkungen | ||
17 | BEMEXTL | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
18 | EXTAUFNR | EXTAUF_NR | EXTAUFNR | CHAR | 10 | 0 | IS-H: EA Nummer des Externen Auftrags | ||
19 | EXTFALNR | ISH_EXTNR_FAL | ISH_EXTNR_FAL | CHAR | 20 | 0 | IS-H: External Case Identification | ||
20 | EXTFALAR | EXTFALAR | FALLART | CHAR | 1 | 0 | IS-H: EA Externe Fallart | ||
21 | EXTCLASS | EXTCLASS | ISH_PAYCL | CHAR | 4 | 0 | IS-H: EA Externe Klasse des Patienten | ||
22 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
23 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
24 | ERTIM | ISH_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time when Data Record Created | ||
25 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
26 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
27 | UPTIM | ISH_UPTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Data Record was Last Changed | ||
28 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
29 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
30 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
31 | TIMESTAMP | ISH_TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | NEO_NFAL | AFART | TNEO_ORDER_TYPE | AFART | KEY | 1 | CN |
2 | NEO_NFAL | AUTYP | TNEO_ORDER_CAT | AUTYP | KEY | 1 | CN |
3 | NEO_NFAL | EINRI | TN01 | EINRI | KEY | 1 | CN |
4 | NEO_NFAL | FALNR | NFAL | FALNR | KEY | 1 | CN |
5 | NEO_NFAL | KTTAR | TNCH12 | TARCDE | KEY | 1 | CN |
6 | NEO_NFAL | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |