I_FMEATaskResponsible

DDL: I_FMEATASKRESPONSIBLE Type: view_entity TRANSACTIONAL Package: PLM_FMEA
10 Fields 1 Data Sources

FMEA Task Responsible

I_FMEATaskResponsible is a Transactional CDS View that provides data about "FMEA Task Responsible" in SAP S/4HANA. It reads from 1 data source (P_FMEATaskResponsible2) and exposes 10 fields with key fields FMEATaskUUID, FMEAPartnerUUID. Part of development package PLM_FMEA.

Data Sources (1)

SourceAliasJoin Type
P_FMEATaskResponsible2 _FMEATaskResponsible2 inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label FMEA Task Responsible view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FMEATaskUUID I_FMEATaskPartner FMEATaskUUID
KEY FMEAPartnerUUID I_FMEATaskPartner FMEAPartnerUUID
FMEAPartnerRole I_FMEATaskPartner FMEAPartnerRole
BusinessPartnerUUID I_FMEATaskPartner BusinessPartnerUUID UUID
BusinessPartnerendasBusinessPartner
BusinessPartnerUUIDHex I_FMEATaskPartner BusinessPartnerUUIDHex
FMEAPartnerSortNumber I_FMEATaskPartner FMEAPartnerSortNumber
_BusinessPartner I_FMEATaskPartner _BusinessPartner
_Employee I_FMEATaskPartner _Employee
_FMEATask I_FMEATaskPartner _FMEATask

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 I_FMEATaskResponsible.
-- 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.

CREATE VIEW I_FMEATaskResponsible AS
SELECT
  I_FMEATaskPartner.FMEATaskUUID AS FMEATaskUUID,
  I_FMEATaskPartner.FMEAPartnerUUID AS FMEAPartnerUUID,
  I_FMEATaskPartner.FMEAPartnerRole AS FMEAPartnerRole,
  I_FMEATaskPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  case when I_FMEATaskPartner.BusinessPartnerUUIDHex = '00000000000000000000000000000000' then '' else I_FMEATaskPartner._BusinessPartner.BusinessPartner end as BusinessPartner AS BusinessPartnerendasBusinessPartner,
  I_FMEATaskPartner.BusinessPartnerUUIDHex AS BusinessPartnerUUIDHex,
  I_FMEATaskPartner.FMEAPartnerSortNumber AS FMEAPartnerSortNumber,
  I_FMEATaskPartner._BusinessPartner AS _BusinessPartner,
  I_FMEATaskPartner._Employee AS _Employee,
  I_FMEATaskPartner._FMEATask AS _FMEATask
INNER JOIN P_FMEATaskResponsible2 AS _FMEATaskResponsible2 ON /* join condition not captured in parsed metadata */
;

Learn More