C_EHSCtrlImplmtnRespCntctCard

DDL: C_EHSCTRLIMPLMTNRESPCNTCTCARD SQL: CEHSCTRLIMPLRECC Type: view CONSUMPTION
21 Fields 1 Data Sources

Contact Card for Responsible

C_EHSCtrlImplmtnRespCntctCard is a Consumption CDS View that provides data about "Contact Card for Responsible" in SAP S/4HANA. It reads from 1 data source (P_EHSControlImplResponsible) and exposes 21 fields with key field EHSControlInstanceUUID.

Data Sources (1)

SourceAliasJoin Type
P_EHSControlImplResponsible responsible from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CEHSCTRLIMPLRECC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Contact Card for Responsible view
VDM.viewType #CONSUMPTION view
ObjectModel.updateEnabled false view
ObjectModel.createEnabled false view
UI.headerInfo.typeName Responsible Contact Card view
UI.headerInfo.typeNamePlural Responsible Contact Cards view
UI.headerInfo.title.value FullName view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY EHSControlInstanceUUID P_EHSControlImplResponsible EHSControlInstanceUUID
ResponsiblePerson P_EHSControlImplResponsible ResponsiblePerson Processor
EHSRiskUUID P_EHSControlImplResponsible EHSRiskUUID
ContactCardID ContactCardID
Person Person Person/ Farm/ Field
BusinessPartnerUUID BusinessPartnerUUID UUID
FirstName FirstName First Name
LastName LastName Last Name
FullName FullName Name
AddressID AddressID Ship-to address
PhoneNumber PhoneNumber Telephone no.
MobilePhoneNumber MobilePhoneNumber Telephone
FaxNumber FaxNumber Fax Number
EmailAddress EmailAddress E-Mail Address
Department Department Department
FunctionalTitleName FunctionalTitleName
ContactCardRole ContactCardRole
ContactCardType ContactCardType
ContactCardNavLinkSemanticObj ContactCardNavLinkSemanticObj
ContactCardNavLinkQueryPart ContactCardNavLinkQueryPart
_EHSRiskRoot _EHSRiskRoot

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_EHSCtrlImplmtnRespCntctCard.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CEHSCTRLIMPLRECC

CREATE VIEW C_EHSCtrlImplmtnRespCntctCard AS
SELECT
  responsible.EHSControlInstanceUUID AS EHSControlInstanceUUID,
  responsible.ResponsiblePerson AS ResponsiblePerson,
  responsible.EHSRiskUUID AS EHSRiskUUID,
  ContactCardID,
  Person,
  BusinessPartnerUUID,
  FirstName,
  LastName,
  FullName,
  AddressID,
  PhoneNumber,
  MobilePhoneNumber,
  FaxNumber,
  EmailAddress,
  Department,
  FunctionalTitleName,
  ContactCardRole,
  ContactCardType,
  ContactCardNavLinkSemanticObj,
  ContactCardNavLinkQueryPart
FROM P_EHSControlImplResponsible AS responsible
;

Learn More