Skip to Content
0
Jul 23, 2018 at 01:01 AM

Join conditions for EHS tables for Incident reporting ?

201 Views

Hi All,

I am new to join SAP Community and this is my second question. For first question I received response from Jocelyn Dart. Thanks for that. I tried to respond for that question seems i have authorization issue hence here in this question I am saying thanks to her.

1) I am building CDS view for EHS Incident reporting, for this i need join conditions for all the tables mentioned below, 2) Also can I know how to create custom Hierarchy for HSE module.

Thanks in advance.

TableTechnical nameDescription of the fieldJoin Conditions ?EHHSSD_INC_ROOTIDIncident IDEHHSSD_INC_ROOTZEVENT_TYPEEvent TypeEHHSSD_INC_ROOTDATETIME_CRDate/Time of Item CreationEHHSSD_INC_BINFA

ZEVENT_TYPEEvent Type EHHSSD_INC_BINFA LOC_TYPELocation Classification EHHSSD_INC_BINFA ZINRINR Flag EHHSSD_INC_BINFA ZOWNEROwnership EHHSSD_INC_INCGRINC_GROUPIncident Group EHHSSD_INC_INRESSTART_DATEInvestigation Start Date EHHSSD_INC_INRESZZINV_TYPEInvestigation : Investigation Type EHHSSD_INC_INRESINV_LEAD_IDInvestigation Lead EHHSSD_INC_RCAUSROOT_CAUSERoot Cause EHHSSD_INC_INSTPSTEP_CODEInvestigation Step EHHSSD_INC_INSTPEXECUTOR_IDID of Person Responsible for Investigation Step EHHSSD_INC_INSTPDEADLINE_DATEDue Date for Investigation Step