I_DFS_ObjectName

DDL: I_DFS_OBJECTNAME SQL: IDFSOBJECTNAME Type: view BASIC
12 Fields 1 Data Sources 1 Associations

Interface View for Defense Object Names

I_DFS_ObjectName is a Basic CDS View that provides data about "Interface View for Defense Object Names" in SAP S/4HANA. It reads from 1 data source (P_DFS_ObjectName) and exposes 12 fields with key fields DfsObjectPlanVersion, DfsObjectType, DfsObjectID, DfsObjectPlngStatus, DfsObjectValdtyStartDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_DFS_ObjectName ObjectName from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_DFS_SenstvyClfnFrcElmnt _SenstvyClfn $projection.DfsObjectID = _SenstvyClfn.ForceElementOrgID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDFSOBJECTNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface View for Defense Object Names view
VDM.viewType #BASIC view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DfsObjectPlanVersion P_DFS_ObjectName DfsObjectPlanVersion Plan version
KEY DfsObjectType P_DFS_ObjectName DfsObjectType Object type
KEY DfsObjectID P_DFS_ObjectName DfsObjectID Object ID
KEY DfsObjectPlngStatus P_DFS_ObjectName DfsObjectPlngStatus Planning status
KEY DfsObjectValdtyStartDate P_DFS_ObjectName DfsObjectValdtyStartDate Start date
KEY DfsObjectValdtyEndDate P_DFS_ObjectName DfsObjectValdtyEndDate End Date
KEY LanguageCode P_DFS_ObjectName LanguageCode Language Key
DfsObjectInfoType P_DFS_ObjectName DfsObjectInfoType Infotype
DfsObjectShortName P_DFS_ObjectName DfsObjectShortName Shortened form
DfsObjectName P_DFS_ObjectName DfsObjectName Text
DfsObjectDelimitDate P_DFS_ObjectName DfsObjectDelimitDate Delimit date
_SenstvyClfn _SenstvyClfn

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_ObjectName.
-- 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: IDFSOBJECTNAME

CREATE VIEW I_DFS_ObjectName AS
SELECT
  ObjectName.DfsObjectPlanVersion AS DfsObjectPlanVersion,
  ObjectName.DfsObjectType AS DfsObjectType,
  ObjectName.DfsObjectID AS DfsObjectID,
  ObjectName.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  ObjectName.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  ObjectName.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  ObjectName.LanguageCode AS LanguageCode,
  ObjectName.DfsObjectInfoType AS DfsObjectInfoType,
  ObjectName.DfsObjectShortName AS DfsObjectShortName,
  ObjectName.DfsObjectName AS DfsObjectName,
  ObjectName.DfsObjectDelimitDate AS DfsObjectDelimitDate
FROM P_DFS_ObjectName AS ObjectName
LEFT OUTER JOIN I_DFS_SenstvyClfnFrcElmnt AS _SenstvyClfn ON DfsObjectID = _SenstvyClfn.ForceElementOrgID  -- association [1..*]
;

Learn More