SAP ABAP Table EHS00S_VACCH_IOT (EHS: IOTAB for Vaccination (7EHS00_VACCH))
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-HEA (Application Component) Occupational Health
⤷ P99Q1 (Package) EH&S: Occupational Health
⤷ EHS-HEA (Application Component) Occupational Health
⤷ P99Q1 (Package) EH&S: Occupational Health
Basic Data
Table Category | INTTAB | Structure |
Structure | EHS00S_VACCH_IOT | Table Relationship Diagram |
Short Description | EHS: IOTAB for Vaccination (7EHS00_VACCH) |
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 | .INCLUDE | 0 | 0 | EHS: Standard fields for IOTABs (step loop library) | |||||
2 | MARKFLG | ESEMARKFLG | ESDFLAG | CHAR | 1 | 0 | Row Is Selected | ||
3 | SELEFLG | ESESELEFLG | ESDFLAG | CHAR | 1 | 0 | Step Loop Line Selected | ||
4 | LINENO | ESECOUNTER | NUMC10 | NUMC | 10 | 0 | General Auxiliary Counter | ||
5 | LINEMOD | ESELINEMOD | CHAR1 | CHAR | 1 | 0 | Processing status or mode of a record/step loop line | ||
6 | CHCOFLG | ESECHCOFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Change number collision | ||
7 | LOCKMOD | ESELOCKMOD | CHAR1 | CHAR | 1 | 0 | Lock Mode (Shared, Exclusive) | ||
8 | INTRFLG | ESEINTRFLG | ESDFLAG | CHAR | 1 | 0 | Flag for Internal Use | ||
9 | .INCLUDE | 0 | 0 | EHS: Vaccination Data Header Information | |||||
10 | .INCLUDE | 0 | 0 | EHS: Structure for key info of master data | |||||
11 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
12 | RECN | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
13 | ACTN | ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
14 | .INCLUDE | 0 | 0 | EHS: Structure for General Administration Information | |||||
15 | VALFR | ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
16 | VALTO | ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
17 | AENNR | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
18 | DELFLG | ESEDELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
19 | PARKFLG | ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
20 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
21 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
22 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
23 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
24 | SRSID | ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
25 | OWNID | ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
26 | RECNROOT | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
27 | CRDTIMESTAMP | EHS00_CRTS | DEC | 15 | 0 | Creation Time | |||
28 | UPDTIMESTAMP | EHS00_UPDTS | DEC | 15 | 0 | Time of Last Change | |||
29 | PERNR | EHS00_PERNR | EHS00_PERNR | NUMC | 8 | 0 | Personnel number | T7EHS00_MAPPERNR | |
30 | SERVICENO | EHS00_SRVNUMBER | NUMC12 | NUMC | 12 | 0 | Number of Medical Service | ||
31 | PGROUP | EHS00_PGROUP | EHS00_PGROUP | CHAR | 3 | 0 | Health Surveillance Protocol Category | VT7EHS00_PGROUPV | |
32 | PNUMBER | EHS00_PNUMBER | CHAR3 | CHAR | 3 | 0 | Protocol Number | T7EHS00_PROT | |
33 | SRV_PROTTYPE | EHS00_FRTYP | EHS00_FRTYP | CHAR | 3 | 0 | Examination Type | T7EHS00_PROTFREQ | |
34 | VACC_ID | EHS00_VACCID | EHS00_VACCID | CHAR | 20 | 0 | Vaccination | ||
35 | VACC_DATE | EHS00_VACCDATE | DATS | 8 | 0 | Vaccination Date | |||
36 | VACC_STATUS | EHS00_VACCSTATUS | EHS00_VACCSTATUS | CHAR | 1 | 0 | Vaccination Status | ||
37 | BRAND_NAME | EHS00_BRANDNAME | EHS00D_BRANDNAME | CHAR | 50 | 0 | Brand Name | ||
38 | BATCHNO | EHS00_BATCHNO | CHAR | 20 | 0 | Batch Number | |||
39 | VACC_COMMENT | EHS00_VACCCMNT | TEXT75 | CHAR | 75 | 0 | Comment on Vaccination | ||
40 | VACC_PHYSICIAN | EHS00_SRVPHYSICIAN | BU_PARTNER | CHAR | 10 | 0 | Physician Responsible | * | |
41 | VACC_PHYSFLG | EHS00_INEXFLAG | EHS00_INEXFLAG | CHAR | 1 | 0 | Internal/External Person | ||
42 | PRIVATFLG | EHS00_PRIVATEFLG | ESDFLAG | CHAR | 1 | 0 | Vaccination to Be Settled Privately | ||
43 | DONE | EHS00_VACCSTATUS | EHS00_VACCSTATUS | CHAR | 1 | 0 | Vaccination Status | ||
44 | DONE_EXT | EHS00_VACCSTATUS | EHS00_VACCSTATUS | CHAR | 1 | 0 | Vaccination Status | ||
45 | REJECT | EHS00_VACCSTATUS | EHS00_VACCSTATUS | CHAR | 1 | 0 | Vaccination Status | ||
46 | PNAME | EHS00_PNAME | TEXT40 | CHAR | 40 | 0 | Description of Health Surveillance Protocol | ||
47 | PROT_FRTYPNAM | EHS00_FRTYPNAM | TEXT40 | CHAR | 40 | 0 | Name of Examination Type | ||
48 | SRV_STATUS | EHS00_SRVSTATUS | CHAR01 | CHAR | 1 | 0 | Status of Medical Service | ||
49 | VACC_PHYSNAM | EHS00_PHYSICIANT | TEXT80 | CHAR | 80 | 0 | Physician/Health Center |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EHS00S_VACCH_IOT | AENNR | AENR | AENNR | REF | 1 | CN |
2 | EHS00S_VACCH_IOT | MANDT | T000 | MANDT | |||
3 | EHS00S_VACCH_IOT | PERNR | T7EHS00_MAPPERNR | INTPERNR | |||
4 | EHS00S_VACCH_IOT | PGROUP | VT7EHS00_PGROUPV | PGROUP | |||
5 | EHS00S_VACCH_IOT | PNUMBER | T7EHS00_PROT | PNUMBER | |||
6 | EHS00S_VACCH_IOT | SRSID | TCG56 | SRSID | REF | 1 | CN |
7 | EHS00S_VACCH_IOT | SRV_PROTTYPE | T7EHS00_PROTFREQ | PROT_FRTYP |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |