I_FrcElmntToPosExtRelshpDrft

DDL: I_FRCELMNTTOPOSEXTRELSHPDRFT SQL: IFETOPOSEXTRESHP Type: view BASIC
13 Fields 1 Data Sources

Interface View of FE To Pos Ext Relshp With Draft

I_FrcElmntToPosExtRelshpDrft is a Basic CDS View that provides data about "Interface View of FE To Pos Ext Relshp With Draft" in SAP S/4HANA. It reads from 1 data source (dfs_fetoposext_d) and exposes 13 fields with key fields DfsObjectID, DfsObjectDraftUUID, DfsObjectPlngStatus, DfsPositionValdtyStartDate, DfsPositionValdtyEndDate.

Data Sources (1)

SourceAliasJoin Type
dfs_fetoposext_d FrcElmntToPosExtRelshpDrft from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFETOPOSEXTRESHP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface View of FE To Pos Ext Relshp With Draft view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectID dfs_fetoposext_d dfsobjectid Object ID
KEY DfsObjectDraftUUID dfs_fetoposext_d draftuuid UUID
KEY DfsObjectPlngStatus dfs_fetoposext_d dfsobjectplngstatus Planning status
KEY DfsPositionValdtyStartDate dfs_fetoposext_d dfspositionvaldtystartdate Start date
KEY DfsPositionValdtyEndDate dfs_fetoposext_d dfspositionvaldtyenddate End Date
DfsObjectPlanVersion dfs_fetoposext_d dfsobjectplanversion Plan version
DfsObjectType dfs_fetoposext_d dfsobjecttype Object type
DfsObjectSubType dfs_fetoposext_d dfsobjectsubtype Subtype
DfsObjectInfoType dfs_fetoposext_d dfsobjectinfotype Infotype
DfsObjectRelatedObjectType dfs_fetoposext_d dfsobjectrelatedobjecttype Rel.obj.type
DfsObjectRelatedObjectID dfs_fetoposext_d dfsobjectrelatedobjectid ID rel.object
DfsObjectRelshpPriority dfs_fetoposext_d dfsobjectrelshppriority Priority
HasActiveEntity dfs_fetoposext_d hasactiveentity TRUE

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_FrcElmntToPosExtRelshpDrft.
-- 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: IFETOPOSEXTRESHP

CREATE VIEW I_FrcElmntToPosExtRelshpDrft AS
SELECT
  FrcElmntToPosExtRelshpDrft.dfsobjectid AS DfsObjectID,
  FrcElmntToPosExtRelshpDrft.draftuuid AS DfsObjectDraftUUID,
  FrcElmntToPosExtRelshpDrft.dfsobjectplngstatus AS DfsObjectPlngStatus,
  FrcElmntToPosExtRelshpDrft.dfspositionvaldtystartdate AS DfsPositionValdtyStartDate,
  FrcElmntToPosExtRelshpDrft.dfspositionvaldtyenddate AS DfsPositionValdtyEndDate,
  FrcElmntToPosExtRelshpDrft.dfsobjectplanversion AS DfsObjectPlanVersion,
  FrcElmntToPosExtRelshpDrft.dfsobjecttype AS DfsObjectType,
  FrcElmntToPosExtRelshpDrft.dfsobjectsubtype AS DfsObjectSubType,
  FrcElmntToPosExtRelshpDrft.dfsobjectinfotype AS DfsObjectInfoType,
  FrcElmntToPosExtRelshpDrft.dfsobjectrelatedobjecttype AS DfsObjectRelatedObjectType,
  FrcElmntToPosExtRelshpDrft.dfsobjectrelatedobjectid AS DfsObjectRelatedObjectID,
  FrcElmntToPosExtRelshpDrft.dfsobjectrelshppriority AS DfsObjectRelshpPriority,
  FrcElmntToPosExtRelshpDrft.hasactiveentity AS HasActiveEntity
FROM dfs_fetoposext_d AS FrcElmntToPosExtRelshpDrft
;

Learn More