SAP ABAP Table N2AZ_WS_GET_ALL_PINS8_RES (Datentyp Beipackzettel fuer AVWG 3.1 und achtstelliger PZN)
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_GET_ALL_PINS8_RES | Table Relationship Diagram |
Short Description | Datentyp Beipackzettel fuer AVWG 3.1 und achtstelliger PZN |
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 | ALL_ERRORCODE | N2AZ_WS_ALL_ERRORCODE | STRU | 0 | 0 | ||||
3 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
4 | ALL_SUCCESS | CHAR | 1 | 0 | |||||
5 | ALL_ERRORTEXT | CHAR | 200 | 0 | |||||
6 | ALL_MESSAGECODE | N2AZ_WS_ALL_MESSAGECODE | STRU | 0 | 0 | ||||
7 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
8 | BELNR | CHAR | 10 | 0 | |||||
9 | FALNR | CHAR | 10 | 0 | |||||
10 | MSGTY | CHAR | 1 | 0 | |||||
11 | MSGID | CHAR | 20 | 0 | |||||
12 | MSGNO | CHAR | 3 | 0 | |||||
13 | MSGV1 | CHAR | 50 | 0 | |||||
14 | MSGV2 | CHAR | 50 | 0 | |||||
15 | MSGV3 | CHAR | 50 | 0 | |||||
16 | MSGV4 | CHAR | 50 | 0 | |||||
17 | CATEGORY | STRG | 0 | 0 | |||||
18 | PINS8 | N2AZ_WS_PINS8 | STRU | 0 | 0 | ||||
19 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
20 | DATE_OF_ACTUALITY | N2AZ_WS_DATUM | CHAR | 8 | 0 | Datumsvereinbarung zwischen IS-H und AMASYS in der Form JJJJ | |||
21 | DATE_OF_CONTENT_PROOF | N2AZ_WS_DATUM | CHAR | 8 | 0 | Datumsvereinbarung zwischen IS-H und AMASYS in der Form JJJJ | |||
22 | DRUG | N2AZ_WS_DRUG | STRU | 0 | 0 | ||||
23 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
24 | ID | N2AZ_WS_DRUG_ID | CHAR | 10 | 0 | 10-stelliger Verbindungsschluessel (Praeparate) | |||
25 | TRADENAME | N2AZ_WS_DRUG_TRADENAME | CHAR | 100 | 0 | 100-stellige Handelsname | |||
26 | PF_ID | N2AZ_WS_PF_ID | CHAR | 3 | 0 | 3-stellige Darreichungsform | |||
27 | PF_NAME | N2AZ_WS_PF_NAME | CHAR | 50 | 0 | 50-stellige Darreichungsform Bezeichnung | |||
28 | PROD_ID | N2AZ_WS_PROD_ID | CHAR | 7 | 0 | 7-stellige Adressschluessel als CHAR | |||
29 | PROD_NAME_S | N2AZ_WS_PROD_NAME_S | CHAR | 80 | 0 | 80-stellige Herstellername kurz | |||
30 | GROUP_ID | N2AZ_WS_DRUG_GROUP_ID | INT4 | 10 | 0 | 1-stellige Integer-Kennzeichnung fuer die Produktgruppe | |||
31 | VENDOR_ID | N2AZ_WS_VENDOR_ID | INT4 | 10 | 0 | Adress-Schluesselnummer in ABDA_ADF_MED als INT | |||
32 | VENDOR_NAME_S | N2AZ_WS_PROD_NAME_S | CHAR | 80 | 0 | 80-stellige Herstellername kurz | |||
33 | F_MONO | N2AZ_WS_DRUG_F_MONO | CHAR | 1 | 0 | 1-stellige Kennzeichnung Mono-Kombipraeparat | |||
34 | F_NEG | N2AZ_WS_DRUG_F_NEG | CHAR | 1 | 0 | 1-stellige Kennzeichnung der Negativliste | |||
35 | F_CLAUSE | N2AZ_WS_DRUG_F_CLAUSE | CHAR | 1 | 0 | 1-stellige Kennzeichnung der Abgabebestimmung | |||
36 | F_STATUS | N2AZ_WS_DRUG_F_STATUS | CHAR | 1 | 0 | 1-stellige Kennzeichnung des Verkehrsstatus | |||
37 | ATC_ID | N2AZ_WS_ATC_ID | CHAR | 7 | 0 | 7-stelliger ATCCode | |||
38 | F_DC | N2AZ_WS_PACK_F_DC | CHAR | 1 | 0 | 1-stelliges Flag fuer das Vorliegen eines Rabattvertrages (D | |||
39 | WARN | N2AZ_WS_PINS_WARN | STRU | 0 | 0 | ||||
40 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
41 | COMMON | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
42 | SUPPLIES | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
43 | DOSAGE | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
44 | CHILDBEARING | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
45 | LACTATION | N2AZ_WS_PINS_WARN_NAME | CHAR | 1000 | 0 | 1000-stelliger Standardisierter Warnhinweis | |||
46 | PROD | N2AZ_WS_PINS_PROD | STRU | 0 | 0 | ||||
47 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
48 | ID | N2AZ_WS_PROD_ID | CHAR | 7 | 0 | 7-stellige Adressschluessel als CHAR | |||
49 | NAME_L | N2AZ_WS_PROD_NAME_L | CHAR | 120 | 0 | 120-stellige Herstellername lang | |||
50 | STREET | N2AZ_WS_PROD_STREET | CHAR | 60 | 0 | 60-stellige Strasse | |||
51 | COUNTRY | N2AZ_WS_PROD_COUNTRY | CHAR | 3 | 0 | 3-stelliger Laendercode | |||
52 | ZIP | N2AZ_WS_PROD_ZIP | CHAR | 10 | 0 | 10-stellige PLZ | |||
53 | CITY | N2AZ_WS_PROD_CITY | CHAR | 60 | 0 | 60-stellige Ort | |||
54 | PHONE | N2AZ_WS_PROD_PHONE | CHAR | 60 | 0 | 60-stellige Telefonnummer | |||
55 | FAX | N2AZ_WS_PROD_FAX | CHAR | 60 | 0 | 60-stellige Faxnummer | |||
56 | PRODEC | N2AZ_WS_PINS_PRODEC_TAB | TTYP | 0 | 0 | ||||
57 | TEXT | N2AZ_WS_PINS_TEXT | STRU | 0 | 0 | ||||
58 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
59 | DOSAGE | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
60 | DECREE | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
61 | CONTRA | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
62 | INDI | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
63 | SIDE | N2AZ_WS_PINS_DRUG_TEXT | STRG | 0 | 0 | Praeparattexte (keine Laengenlimitierung) | |||
64 | PINS_PACK8 | N2AZ_WS_PINS_PACK8_TAB | TTYP | 0 | 0 | ||||
65 | ATC | N2AZ_WS_ATC_TAB | TTYP | 0 | 0 | ||||
66 | INDI_MAIN | N2AZ_WS_INDI_TAB | TTYP | 0 | 0 | ||||
67 | INDI_MINOR | N2AZ_WS_INDI_TAB | TTYP | 0 | 0 | ||||
68 | DRUGCOMP | N2AZ_WS_PINS_DRUGCOMP_TAB | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |