I_WorkforceAvailabilitySuplmnt

DDL: I_WORKFORCEAVAILABILITYSUPLMNT Type: view_entity BASIC
13 Fields 1 Data Sources 1 Associations

Workforce Availability Supplement

I_WorkforceAvailabilitySuplmnt is a Basic CDS View that provides data about "Workforce Availability Supplement" in SAP S/4HANA. It reads from 1 data source (wfd_d_avail_supl) and exposes 13 fields with key fields WorkAssignment, WorkforceAvailabilityDate, WrkfrcAvailySuplmntSqncNumber, ExternalWorkAssignmentID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
wfd_d_avail_supl AvailySuplmnt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkforceAvailability _AvailabilityHeader $projection.WorkAssignment = _AvailabilityHeader.WorkAssignment and $projection.WorkforceAvailabilityDate = _AvailabilityHeader.WorkforceAvailabilityDate and $projection.ExternalWorkAssignmentID = _AvailabilityHeader.ExternalWorkAssignmentID

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Workforce Availability Supplement view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment wfd_d_avail_supl work_assignment_id WorkForce Assgmt ID
KEY WorkforceAvailabilityDate wfd_d_avail_supl availability_date Availability Date
KEY WrkfrcAvailySuplmntSqncNumber wfd_d_avail_supl sequence_number Sort Sequence
KEY ExternalWorkAssignmentID wfd_d_avail_supl work_assignment_ext_id WFA Ext. ID
WrkfrcAvailySuplmntCategory wfd_d_avail_supl category Violation Category
WorkerIsApproachable wfd_d_avail_supl is_worker_approachable Worker Approachable
WrkfrcAvailySupplementType wfd_d_avail_supl type Worklist Type
WrkfrcAvailySuplmntStartTime wfd_d_avail_supl interval_start Interval start
WrkfrcAvailySuplmntEndTime wfd_d_avail_supl interval_end Interval end
WrkfrcAvailySuplmntContrbnVal wfd_d_avail_supl contribution Time Contribution
WrkfrcAvailySuplmntContrbnHrs wfd_d_avail_supl contribution_numeric Numeric Contribution
BlockingIndicator wfd_d_avail_supl block_ind BlockingInd.
_AvailabilityHeader _AvailabilityHeader

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_WorkforceAvailabilitySuplmnt.
-- 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_WorkforceAvailabilitySuplmnt AS
SELECT
  AvailySuplmnt.work_assignment_id AS WorkAssignment,
  AvailySuplmnt.availability_date AS WorkforceAvailabilityDate,
  AvailySuplmnt.sequence_number AS WrkfrcAvailySuplmntSqncNumber,
  AvailySuplmnt.work_assignment_ext_id AS ExternalWorkAssignmentID,
  AvailySuplmnt.category AS WrkfrcAvailySuplmntCategory,
  AvailySuplmnt.is_worker_approachable AS WorkerIsApproachable,
  AvailySuplmnt.type AS WrkfrcAvailySupplementType,
  AvailySuplmnt.interval_start AS WrkfrcAvailySuplmntStartTime,
  AvailySuplmnt.interval_end AS WrkfrcAvailySuplmntEndTime,
  AvailySuplmnt.contribution AS WrkfrcAvailySuplmntContrbnVal,
  AvailySuplmnt.contribution_numeric AS WrkfrcAvailySuplmntContrbnHrs,
  AvailySuplmnt.block_ind AS BlockingIndicator
FROM wfd_d_avail_supl AS AvailySuplmnt
LEFT OUTER JOIN I_WorkforceAvailability AS _AvailabilityHeader ON WorkAssignment = _AvailabilityHeader.WorkAssignment AND WorkforceAvailabilityDate = _AvailabilityHeader.WorkforceAvailabilityDate AND ExternalWorkAssignmentID = _AvailabilityHeader.ExternalWorkAssignmentID  -- association [1..1]
;

Learn More