SAP ABAP Table N2AZ_WS_PINS8 (Datentyp Praepateinformationen (Packungsbeilage ab AVWG 3.1))
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-HMED (Application Component) Clinical System
⤷ NMED_GER (Package) IS-H*MED: Landesversion Deutschland
⤷ IS-HMED (Application Component) Clinical System
⤷ NMED_GER (Package) IS-H*MED: Landesversion Deutschland
Basic Data
Table Category | INTTAB | Structure |
Structure | N2AZ_WS_PINS8 | Table Relationship Diagram |
Short Description | Datentyp Praepateinformationen (Packungsbeilage ab AVWG 3.1) |
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 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
2 | DATE_OF_ACTUALITY | N2AZ_WS_DATUM | CHAR | 8 | 0 | Datumsvereinbarung zwischen IS-H und AMASYS in der Form JJJJ | |||
3 | DATE_OF_CONTENT_PROOF | N2AZ_WS_DATUM | CHAR | 8 | 0 | Datumsvereinbarung zwischen IS-H und AMASYS in der Form JJJJ | |||
4 | DRUG | N2AZ_WS_DRUG | STRU | 0 | 0 | ||||
5 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
6 | ID | N2AZ_WS_DRUG_ID | CHAR | 10 | 0 | 10-stelliger Verbindungsschluessel (Praeparate) | |||
7 | TRADENAME | N2AZ_WS_DRUG_TRADENAME | CHAR | 100 | 0 | 100-stellige Handelsname | |||
8 | PF_ID | N2AZ_WS_PF_ID | CHAR | 3 | 0 | 3-stellige Darreichungsform | |||
9 | PF_NAME | N2AZ_WS_PF_NAME | CHAR | 50 | 0 | 50-stellige Darreichungsform Bezeichnung | |||
10 | PROD_ID | N2AZ_WS_PROD_ID | CHAR | 7 | 0 | 7-stellige Adressschluessel als CHAR | |||
11 | PROD_NAME_S | N2AZ_WS_PROD_NAME_S | CHAR | 80 | 0 | 80-stellige Herstellername kurz | |||
12 | GROUP_ID | N2AZ_WS_DRUG_GROUP_ID | INT4 | 10 | 0 | 1-stellige Integer-Kennzeichnung fuer die Produktgruppe | |||
13 | VENDOR_ID | N2AZ_WS_VENDOR_ID | INT4 | 10 | 0 | Adress-Schluesselnummer in ABDA_ADF_MED als INT | |||
14 | VENDOR_NAME_S | N2AZ_WS_PROD_NAME_S | CHAR | 80 | 0 | 80-stellige Herstellername kurz | |||
15 | F_MONO | N2AZ_WS_DRUG_F_MONO | CHAR | 1 | 0 | 1-stellige Kennzeichnung Mono-Kombipraeparat | |||
16 | F_NEG | N2AZ_WS_DRUG_F_NEG | CHAR | 1 | 0 | 1-stellige Kennzeichnung der Negativliste | |||
17 | F_CLAUSE | N2AZ_WS_DRUG_F_CLAUSE | CHAR | 1 | 0 | 1-stellige Kennzeichnung der Abgabebestimmung | |||
18 | F_STATUS | N2AZ_WS_DRUG_F_STATUS | CHAR | 1 | 0 | 1-stellige Kennzeichnung des Verkehrsstatus | |||
19 | ATC_ID | N2AZ_WS_ATC_ID | CHAR | 7 | 0 | 7-stelliger ATCCode | |||
20 | F_DC | N2AZ_WS_PACK_F_DC | CHAR | 1 | 0 | 1-stelliges Flag fuer das Vorliegen eines Rabattvertrages (D | |||
21 | WARN | N2AZ_WS_PINS_WARN | STRU | 0 | 0 | ||||
22 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
23 | COMMON | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
24 | SUPPLIES | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
25 | DOSAGE | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
26 | CHILDBEARING | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
27 | LACTATION | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
28 | PROD | N2AZ_WS_PINS_PROD | STRU | 0 | 0 | ||||
29 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
30 | ID | N2AZ_WS_PROD_ID | CHAR | 7 | 0 | 7-stellige Adressschluessel als CHAR | |||
31 | NAME_L | N2AZ_WS_PROD_NAME_L | CHAR | 120 | 0 | 120-stellige Herstellername lang | |||
32 | STREET | N2AZ_WS_PROD_STREET | CHAR | 60 | 0 | 60-stellige Strasse | |||
33 | COUNTRY | N2AZ_WS_PROD_COUNTRY | CHAR | 3 | 0 | 3-stelliger Laendercode | |||
34 | ZIP | N2AZ_WS_PROD_ZIP | CHAR | 10 | 0 | 10-stellige PLZ | |||
35 | CITY | N2AZ_WS_PROD_CITY | CHAR | 60 | 0 | 60-stellige Ort | |||
36 | PHONE | N2AZ_WS_PROD_PHONE | CHAR | 60 | 0 | 60-stellige Telefonnummer | |||
37 | FAX | N2AZ_WS_PROD_FAX | CHAR | 60 | 0 | 60-stellige Faxnummer | |||
38 | PRODEC | N2AZ_WS_PINS_PRODEC_TAB | TTYP | 0 | 0 | ||||
39 | TEXT | N2AZ_WS_PINS_TEXT | STRU | 0 | 0 | ||||
40 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
41 | DOSAGE | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
42 | DECREE | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
43 | CONTRA | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
44 | INDI | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
45 | SIDE | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
46 | PINS_PACK8 | N2AZ_WS_PINS_PACK8_TAB | TTYP | 0 | 0 | ||||
47 | ATC | N2AZ_WS_ATC_TAB | TTYP | 0 | 0 | ||||
48 | INDI_MAIN | N2AZ_WS_INDI_TAB | TTYP | 0 | 0 | ||||
49 | INDI_MINOR | N2AZ_WS_INDI_TAB | TTYP | 0 | 0 | ||||
50 | DRUGCOMP | N2AZ_WS_PINS_DRUGCOMP_TAB | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |