SAP ABAP Table N2AZ_WS_PACK (Datentyp Artikelstamm mit 7 stelligen 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_PACK | Table Relationship Diagram |
Short Description | Datentyp Artikelstamm mit 7 stelligen 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 | ID | N2AZ_WS_PACK_ID | CHAR | 7 | 0 | 7-stellige Pharmazentralnummer | |||
3 | DRUG_ID | N2AZ_WS_DRUG_ID | CHAR | 10 | 0 | 10-stelliger Verbindungsschluessel (Praeparate) | |||
4 | TRADENAME_S | N2AZ_WS_PACK_TRADENAME_S | CHAR | 26 | 0 | 26-stellige Handelsname kurz | |||
5 | TRADENAME_L | N2AZ_WS_PACK_TRADENAME_L | CHAR | 50 | 0 | 50-stellige Handelsname lang (erster) | |||
6 | PF_ID | N2AZ_WS_PF_ID | CHAR | 3 | 0 | 3-stellige Darreichungsform | |||
7 | PF_NAME | N2AZ_WS_PF_NAME | CHAR | 50 | 0 | 50-stellige Darreichungsform Bezeichnung | |||
8 | PROD_ID | N2AZ_WS_PROD_ID | CHAR | 7 | 0 | 7-stellige Adressschluessel als CHAR | |||
9 | PROD_NAME_S | N2AZ_WS_PROD_NAME_S | CHAR | 80 | 0 | 80-stellige Herstellername kurz | |||
10 | PROD_NAME_L | N2AZ_WS_PROD_NAME_L | CHAR | 120 | 0 | 120-stellige Herstellername lang | |||
11 | QU | N2AZ_WS_PACK_QU | CHAR | 2 | 0 | 2-stellige Einheit Packungsroesse | |||
12 | QUA | N2AZ_WS_PACK_QUA | CHAR | 7 | 0 | 7-stellige Packungsroesse | |||
13 | SALE_STATE | N2AZ_WS_PACK_SALE_STATE | CHAR | 1 | 0 | 1-stellige Vertriebsstatus | |||
14 | PRICE | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
15 | PRICE_FIX | N2AZ_WS_PACK_PRICE_FIX | INT4 | 10 | 0 | Festbetrag in Cent | |||
16 | PRICE_FIX_S | N2AZ_WS_PACK_PRICE_FIX_S | CHAR | 1 | 0 | 1-stellige Festbetragsstufe | |||
17 | PRICE_FIX_TAB | N2AZ_WS_PACK_PRICE_FIX_TAB | CHAR | 5 | 0 | 5-stellige Festbetragstabelle | |||
18 | CHEMIST_DUTY | N2AZ_WS_PACK_CHEMIST_DUTY | CHAR | 1 | 0 | 1-stellige Apothekenpflicht | |||
19 | F_AGENT | N2AZ_WS_PACK_F_AGENT | CHAR | 1 | 0 | 1-stelliges Flag Arzneimittel | |||
20 | F_AGENT_PRICE | N2AZ_WS_PACK_F_AGENT_PRICE | CHAR | 1 | 0 | 1-stelliges Flag Arzneimittelpreisverordnung | |||
21 | F_NARCOTIC | N2AZ_WS_PACK_F_NARCOTIC | CHAR | 1 | 0 | 1-stelliges Flag Betaeubungsmittel | |||
22 | F_IMPORT | N2AZ_WS_PACK_F_IMPORT | CHAR | 1 | 0 | 1-stelliges Flag Import | |||
23 | F_MEDPRODUCT | N2AZ_WS_PACK_F_MEDPRODUCT | CHAR | 1 | 0 | 1-stelliges Flag Medizinprodukt | |||
24 | F_CE | N2AZ_WS_PACK_F_CE | CHAR | 1 | 0 | 1-stelliges Flag CE-Kennzeichnung | |||
25 | F_NEG | N2AZ_WS_PACK_F_NEG | CHAR | 1 | 0 | 1-stelliges Flag Negativliste | |||
26 | F_TRANS | N2AZ_WS_PACK_F_TRANS | CHAR | 1 | 0 | 1-stelliges Flag Transfusionsgesetz | |||
27 | AUTIDEM_ID | N2AZ_WS_PACK_AUTIDEM_ID | CHAR | 9 | 0 | 9-stelliger Auswahltabellenschluessel | |||
28 | F_PRESCRIP | N2AZ_WS_PACK_F_PRESCRIP | CHAR | 1 | 0 | 1-stelliges Flag Verschreibungspflicht | |||
29 | PACK_ID_SUCC | N2AZ_WS_PACK_ID | CHAR | 7 | 0 | 7-stellige Pharmazentralnummer | |||
30 | PACK8_ID_SUCC | N2AZ_WS_PACK8_ID | CHAR | 8 | 0 | 8-stellige Pharmazentralnummer | |||
31 | PACK_ID_SMALL | N2AZ_WS_PACK_ID | CHAR | 7 | 0 | 7-stellige Pharmazentralnummer | |||
32 | PACK8_ID_SMALL | N2AZ_WS_PACK8_ID | CHAR | 8 | 0 | 8-stellige Pharmazentralnummer | |||
33 | PACK_ID_ORG | N2AZ_WS_PACK_ID | CHAR | 7 | 0 | 7-stellige Pharmazentralnummer | |||
34 | PACK8_ID_ORG | N2AZ_WS_PACK8_ID | CHAR | 8 | 0 | 8-stellige Pharmazentralnummer | |||
35 | F_DECREE_SGB | N2AZ_WS_PACK_F_DECREE_SGB | CHAR | 1 | 0 | 1-stelliges Flag Arzneimittelpreisverordnung SGB | |||
36 | F_PAY_FREE | N2AZ_WS_PACK_F_PAY_FREE | CHAR | 1 | 0 | 1-stelliges Flag Zuzahlungsbefreiung | |||
37 | F_LIFESTYLE | N2AZ_WS_PACK_F_LIFESTYLE | CHAR | 1 | 0 | 1-stelliges Flag Lifestyle Medikament | |||
38 | F_LOWCOST | N2AZ_WS_PACK_F_LOWCOST | CHAR | 1 | 0 | 1-stelliges Flag preisguenstige Festbetragsartikel | |||
39 | NO_EXTRA_COST_IK | N2AZ_WS_IKKASSE_TAB | TTYP | 0 | 0 | ||||
40 | F_PACKGROUP | N2AZ_WS_PACK_F_PACKGROUP | CHAR | 1 | 0 | 1-stelliges Flag Einstufung Packungsgroessen | |||
41 | F_OAP | N2AZ_WS_PACK_F_OAP | CHAR | 1 | 0 | 1-stelliges Flag (0/1) das angibt, ob im Beipackzettel Ausna | |||
42 | F_VOV | N2AZ_WS_PACK_F_VOV | CHAR | 1 | 0 | 1-stelliges Flag (0/1) das angibt, ob im Beipackzettel Angab | |||
43 | PRICE_ADD_PAY | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
44 | PRICE_MORE_PAY | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
45 | PRICE_EXTRA_PAY | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
46 | F_PRICE_FIX_INDICATOR | N2AZ_WS_PACK_F_PRICE_FIX_INDIC | CHAR | 1 | 0 | 1-stelliges Flag fuer den Festbetragsindikator | |||
47 | F_PRICE_CLASS | N2AZ_WS_PACK_F_PRICE_CLASS | CHAR | 1 | 0 | 1-stelliges Flag fuer die durch SIEMENS bestimmte Preisklass | |||
48 | F_DC | N2AZ_WS_PACK_F_DC | CHAR | 1 | 0 | 1-stelliges Flag fuer das Vorliegen eines Rabattvertrages (D | |||
49 | AGENT_NAME | N2AZ_WS_AGENT_NAME | CHAR | 200 | 0 | 200-stellige Stoffbezeichnung | |||
50 | PACK_ARV | N2AZ_WS_PACK_ARV | STRU | 0 | 0 | ||||
51 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
52 | KEY_VEB | INT4 | 10 | 0 | |||||
53 | RULES | N2AZ_WS_PACK_ARV_RULE_TAB | TTYP | 0 | 0 | ||||
54 | TARGETPRICE | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
55 | TARGETPRICE_TOLERANCE | INT4 | 10 | 0 | |||||
56 | TARGETCOSTS | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
57 | TARGETCOSTS_TOLERANCE | INT4 | 10 | 0 | |||||
58 | PRICE_OLD | N2AZ_WS_PACK_PRICE | INT4 | 10 | 0 | Apothkenverkaufspreis in Cent | |||
59 | PRICE_CHANGE_DATE | N2AZ_WS_DATUM | CHAR | 8 | 0 | Datumsvereinbarung zwischen IS-H und AMASYS in der Form JJJJ | |||
60 | PACK_VOV | N2AZ_WS_PACK_VOV | STRU | 0 | 0 | ||||
61 | CONTROLLER | PRXCTRLTAB | TTYP | 0 | 0 | ||||
62 | VOV_TYPE | N2AZ_WS_INT_TAB | TTYP | 0 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |