I_SrvcOrdItmMisgExectgEmplSitn

DDL: I_SRVCORDITMMISGEXECTGEMPLSITN SQL: ISRVMISEEMP Type: view COMPOSITE
19 Fields 1 Data Sources

Situation Trigger Missing Exec Employee

I_SrvcOrdItmMisgExectgEmplSitn is a Composite CDS View that provides data about "Situation Trigger Missing Exec Employee" in SAP S/4HANA. It reads from 1 data source (I_SrvcOrdItmExectgEmplSitn) and exposes 19 fields with key fields ServiceObjectType, ServiceOrder, ServiceDocumentItem, ServiceDocumentItemUUID.

Data Sources (1)

SourceAliasJoin Type
I_SrvcOrdItmExectgEmplSitn I_SrvcOrdItmExectgEmplSitn from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISRVMISEEMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Situation Trigger Missing Exec Employee view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceOrder ServiceOrder Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY ServiceDocumentItemUUID ServiceDocumentItemUUID
ServiceDocItemCategory ServiceDocItemCategory
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser
SalesGroup SalesGroup Sales Group
SalesGroupOrgUnitID SalesGroupOrgUnitID
SalesOffice SalesOffice Sales Office
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
ServiceOrganization ServiceOrganization
ServiceDocumentType ServiceDocumentType Transaction Type
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ServiceEmployee ServiceEmployee
NrOfDaysAftSrvcOrdItmReqDate NrOfDaysAftSrvcOrdItmReqDate
ResponsibleEmployeeUserID ResponsibleEmployeeUserID User Name

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_SrvcOrdItmMisgExectgEmplSitn.
-- 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: ISRVMISEEMP

CREATE VIEW I_SrvcOrdItmMisgExectgEmplSitn AS
SELECT
  ServiceObjectType,
  ServiceOrder,
  ServiceDocumentItem,
  ServiceDocumentItemUUID,
  ServiceDocItemCategory,
  ServiceDocItemCreatedByUser,
  SalesGroup,
  SalesGroupOrgUnitID,
  SalesOffice,
  SalesOfficeOrgUnitID,
  SalesOrganization,
  SalesOrganizationOrgUnitID,
  ServiceOrganization,
  ServiceDocumentType,
  DistributionChannel,
  Division,
  ServiceEmployee,
  NrOfDaysAftSrvcOrdItmReqDate,
  ResponsibleEmployeeUserID
FROM I_SrvcOrdItmExectgEmplSitn
;

Learn More