R_WorkPermitIssueHistoryDraft

DDL: R_WORKPERMITISSUEHISTORYDRAFT Type: view_entity BASIC Package: VDM_EAM_WCM_PERMIT_TO_WORK
22 Fields 1 Data Sources 1 Associations

Work Permit Issue History Draft

R_WorkPermitIssueHistoryDraft is a Basic CDS View that provides data about "Work Permit Issue History Draft" in SAP S/4HANA. It reads from 1 data source (wrkpmtisshist_d) and exposes 22 fields with key fields WorkPermitInternalID, NumberOfWorkPermitIssued, DraftUUID. It has 1 association to related views. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

Data Sources (1)

SourceAliasJoin Type
wrkpmtisshist_d wrkpmtisshist_d from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_WorkPermitIssueHistoryDraft _WorkPermitIssueHistDExtension $projection.WorkPermitInternalID = _WorkPermitIssueHistDExtension.WorkPermitInternalID and $projection.NumberOfWorkPermitIssued = _WorkPermitIssueHistDExtension.NumberOfWorkPermitIssued and $projection.DraftUUID = _WorkPermitIssueHistDExtension.DraftUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Permit Issue History Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY WorkPermitInternalID workpermitinternalid Object number
KEY NumberOfWorkPermitIssued numberofworkpermitissued Counter
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
WorkPermit workpermit Application
MaintenancePlanningPlant maintenanceplanningplant Planning Plant
WorkPermitType workpermittype Work Permit Type
WorkPermitIssuedBy workpermitissuedby Permit Issued By
WorkPermitIssuedTo workpermitissuedto Permit Issued To
UserCommentsText usercommentstext Character 100
WorkPermitIssueDateTime workpermitissuedatetime Time Stamp
WorkPermitReturnedTo workpermitreturnedto Permit Returned To
WorkPermitReturnedDateTime workpermitreturneddatetime Time Stamp
WorkPermitIssuedByName workpermitissuedbyname Description
WorkPermitReturnedByName workpermitreturnedbyname Description
PersonFullName personfullname Full Name
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_WorkPermitIssueHistoryDraft.
-- 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 R_WorkPermitIssueHistoryDraft AS
SELECT
  WorkPermitInternalID,
  NumberOfWorkPermitIssued,
  DraftUUID,
  ParentDraftUUID,
  WorkPermit,
  MaintenancePlanningPlant,
  WorkPermitType,
  WorkPermitIssuedBy,
  WorkPermitIssuedTo,
  UserCommentsText,
  WorkPermitIssueDateTime,
  WorkPermitReturnedTo,
  WorkPermitReturnedDateTime,
  WorkPermitIssuedByName,
  WorkPermitReturnedByName,
  PersonFullName,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM wrkpmtisshist_d
LEFT OUTER JOIN E_WorkPermitIssueHistoryDraft AS _WorkPermitIssueHistDExtension ON WorkPermitInternalID = _WorkPermitIssueHistDExtension.WorkPermitInternalID AND NumberOfWorkPermitIssued = _WorkPermitIssueHistDExtension.NumberOfWorkPermitIssued AND DraftUUID = _WorkPermitIssueHistDExtension.DraftUUID  -- association [0..1]
;

Learn More