I_DFS_PositionToOpExerRelshp

DDL: I_DFS_POSITIONTOOPEXERRELSHP SQL: IDFSPOSTOOPEXER Type: view BASIC
18 Fields 1 Data Sources

Interface View for the Position to Op/Exer relationship

I_DFS_PositionToOpExerRelshp is a Basic CDS View that provides data about "Interface View for the Position to Op/Exer relationship" in SAP S/4HANA. It reads from 1 data source (P_DFS_PositionToOpExerRelshp) and exposes 18 fields with key fields DfsPositionID, DfsPositionPlanVersion, DfsPositionObjectType, DfsPositionSubType, DfsPositionPlngStatus.

Data Sources (1)

SourceAliasJoin Type
P_DFS_PositionToOpExerRelshp PositionToOpExer from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFSPOSTOOPEXER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Interface View for the Position to Op/Exer relationship view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DfsPositionID P_DFS_PositionToOpExerRelshp DfsPositionID Work Center
KEY DfsPositionPlanVersion P_DFS_PositionToOpExerRelshp DfsPositionPlanVersion Plan version
KEY DfsPositionObjectType P_DFS_PositionToOpExerRelshp DfsPositionObjectType Type of Val.
KEY DfsPositionSubType P_DFS_PositionToOpExerRelshp DfsPositionSubType Subtype
KEY DfsPositionPlngStatus P_DFS_PositionToOpExerRelshp DfsPositionPlngStatus System status
KEY DfsPositionValdtyStartDate P_DFS_PositionToOpExerRelshp DfsPositionValdtyStartDate Start date
KEY DfsPositionValdtyEndDate P_DFS_PositionToOpExerRelshp DfsPositionValdtyEndDate End Date
DfsPositionVariationID P_DFS_PositionToOpExerRelshp DfsPositionVariationID Variation field
DfsPositionSequenceNumber P_DFS_PositionToOpExerRelshp DfsPositionSequenceNumber Tank ID
DfsPositionInfoType P_DFS_PositionToOpExerRelshp DfsPositionInfoType Infotype
DfsPositionRelatedObjectType P_DFS_PositionToOpExerRelshp DfsPositionRelatedObjectType Rel.obj.type
DfsPositionRelatedObjectID P_DFS_PositionToOpExerRelshp DfsPositionRelatedObjectID ID rel.object
DfsPositionRelshpPriority P_DFS_PositionToOpExerRelshp DfsPositionRelshpPriority Priority
DfsPositionOpExerciseID P_DFS_PositionToOpExerRelshp DfsPositionOpExerciseID Washout ID
DfsPositionForceProviderID
DfsPositionInitialMatlSuplrID P_DFS_PositionToOpExerRelshp DfsPositionInitialMatlSuplrID Supplier (Materials)
DfsPositionInitialPersSuplrID P_DFS_PositionToOpExerRelshp DfsPositionInitialPersSuplrID Supplier (Personnel)
DfsPositionRotationKey P_DFS_PositionToOpExerRelshp DfsPositionRotationKey Contingent Key

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_DFS_PositionToOpExerRelshp.
-- 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: IDFSPOSTOOPEXER

CREATE VIEW I_DFS_PositionToOpExerRelshp AS
SELECT
  PositionToOpExer.DfsPositionID AS DfsPositionID,
  PositionToOpExer.DfsPositionPlanVersion AS DfsPositionPlanVersion,
  PositionToOpExer.DfsPositionObjectType AS DfsPositionObjectType,
  PositionToOpExer.DfsPositionSubType AS DfsPositionSubType,
  PositionToOpExer.DfsPositionPlngStatus AS DfsPositionPlngStatus,
  PositionToOpExer.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  PositionToOpExer.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  PositionToOpExer.DfsPositionVariationID AS DfsPositionVariationID,
  PositionToOpExer.DfsPositionSequenceNumber AS DfsPositionSequenceNumber,
  PositionToOpExer.DfsPositionInfoType AS DfsPositionInfoType,
  PositionToOpExer.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PositionToOpExer.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PositionToOpExer.DfsPositionRelshpPriority AS DfsPositionRelshpPriority,
  PositionToOpExer.DfsPositionOpExerciseID AS DfsPositionOpExerciseID,
  cast(PositionToOpExer.DfsPositionForceProviderID as hrobjid) AS DfsPositionForceProviderID,
  PositionToOpExer.DfsPositionInitialMatlSuplrID AS DfsPositionInitialMatlSuplrID,
  PositionToOpExer.DfsPositionInitialPersSuplrID AS DfsPositionInitialPersSuplrID,
  PositionToOpExer.DfsPositionRotationKey AS DfsPositionRotationKey
FROM P_DFS_PositionToOpExerRelshp AS PositionToOpExer
;

Learn More