I_LabelSetForKeyDate

DDL: I_LABELSETFORKEYDATE SQL: ILBLSETFKD Type: view COMPOSITE Package: VDM_PLMB_LBL
26 Fields 2 Data Sources 2 Associations

Label Set on a Key Date

I_LabelSetForKeyDate is a Composite CDS View that provides data about "Label Set on a Key Date" in SAP S/4HANA. It reads from 2 data sources (I_LabelSet, I_LabelSetDetail) and exposes 26 fields with key field LabelSetInternalID. It has 2 associations to related views. Part of development package VDM_PLMB_LBL.

Data Sources (2)

SourceAliasJoin Type
I_LabelSet header inner
I_LabelSetDetail headerDetail from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.LabelSetSpecificationIntID = _SpecificationForKeyDate.SpecificationInternalID
[0..*] I_LabelSetText _LabelSetText $projection.LabelSetInternalID = _LabelSetText.LabelSetInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ILBLSETFKD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey LabelSetInternalID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Label Set on a Key Date view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY LabelSetInternalID I_LabelSetDetail LabelSetInternalID Label Set
LabelSetSpecificationIntID I_LabelSet LabelSetSpecificationIntID Specification
LabelSetSpecification
LabelSetAlternativeNumber I_LabelSet LabelSetAlternativeNumber Alternative Recipe
LabelSetVersionNumber I_LabelSet LabelSetVersionNumber Recipe Version
LabelSetChangeNumber I_LabelSetDetail LabelSetChangeNumber Change Number
LabelSetCreatedByUser I_LabelSet LabelSetCreatedByUser User ID
LabelSetCreationDate I_LabelSet LabelSetCreationDate Created On
LabelSetLastChangedByUser I_LabelSet LabelSetLastChangedByUser User ID
LabelSetLastChangeDate I_LabelSet LabelSetLastChangeDate Changed on
LabelSetLastChangeDateTime I_LabelSetDetail LabelSetLastChangeDateTime Time Stamp
LabelSetDfltUsageRating I_LabelSetDetail LabelSetDfltUsageRating Use of Data
LabelSetDfltUsageValidityArea I_LabelSetDetail LabelSetDfltUsageValidityArea Validity Area
LabelSetSourceInternalKey
LabelSetValidityStartDate I_LabelSetDetail LabelSetValidityStartDate Validity Start Time
LabelSetValidityEndDate I_LabelSetDetail LabelSetValidityEndDate Validity End Time
LabelSetStatus I_LabelSetDetail LabelSetStatus Status
LabelSetAuthorizationGroup I_LabelSetDetail LabelSetAuthorizationGroup Authorization Group
_SpecificationForKeyDate _SpecificationForKeyDate
_LabelSetText _LabelSetText
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_LabelSetStatus _LabelSetStatus
_LabelSetAuthorizationGroup _LabelSetAuthorizationGroup
_LabelSetRating _LabelSetRating
_LabelSetValidityArea _LabelSetValidityArea

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_LabelSetForKeyDate.
-- 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: ILBLSETFKD
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_LabelSetForKeyDate AS
SELECT
  headerDetail.LabelSetInternalID AS LabelSetInternalID,
  header.LabelSetSpecificationIntID AS LabelSetSpecificationIntID,
  _SpecificationForKeyDate(P_KeyDate:$parameters.P_KeyDate).Specification AS LabelSetSpecification,
  header.LabelSetAlternativeNumber AS LabelSetAlternativeNumber,
  header.LabelSetVersionNumber AS LabelSetVersionNumber,
  headerDetail.LabelSetChangeNumber AS LabelSetChangeNumber,
  header.LabelSetCreatedByUser AS LabelSetCreatedByUser,
  header.LabelSetCreationDate AS LabelSetCreationDate,
  header.LabelSetLastChangedByUser AS LabelSetLastChangedByUser,
  header.LabelSetLastChangeDate AS LabelSetLastChangeDate,
  headerDetail.LabelSetLastChangeDateTime AS LabelSetLastChangeDateTime,
  headerDetail.LabelSetDfltUsageRating AS LabelSetDfltUsageRating,
  headerDetail.LabelSetDfltUsageValidityArea AS LabelSetDfltUsageValidityArea,
  headerDetail.LabelSetValidityStartDate AS LabelSetValidityStartDate,
  headerDetail.LabelSetValidityEndDate AS LabelSetValidityEndDate,
  headerDetail.LabelSetStatus AS LabelSetStatus,
  headerDetail.LabelSetAuthorizationGroup AS LabelSetAuthorizationGroup
FROM I_LabelSetDetail AS headerDetail
INNER JOIN I_LabelSet AS header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SpecificationForKeyDate AS _SpecificationForKeyDate ON LabelSetSpecificationIntID = _SpecificationForKeyDate.SpecificationInternalID  -- association [1..1]
LEFT OUTER JOIN I_LabelSetText AS _LabelSetText ON LabelSetInternalID = _LabelSetText.LabelSetInternalID  -- association [0..*]
;

Learn More