C_DFS_PositionSuplmntyAttrib

DDL: C_DFS_POSITIONSUPLMNTYATTRIB SQL: CPOSOBJSUPATT Type: view CONSUMPTION
10 Fields 1 Data Sources 1 Associations

Consumption View for Supplementary Attributes

C_DFS_PositionSuplmntyAttrib is a Consumption CDS View that provides data about "Consumption View for Supplementary Attributes" in SAP S/4HANA. It reads from 1 data source (I_DFS_ObjectSuplmntyAttrib) and exposes 10 fields with key field DfsPositionID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_ObjectSuplmntyAttrib I_DFS_ObjectSuplmntyAttrib from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DFS_PositionPlngStatusVH _PositionPlngStatusVH _PositionPlngStatusVH.DfsObjectPlngStatus = $projection.DfsPositionPlngStatus

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPOSOBJSUPATT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for Supplementary Attributes view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DfsPositionID I_DFS_ObjectSuplmntyAttrib DfsObjectID Object ID
DfsPositionValdtyStartDate I_DFS_ObjectSuplmntyAttrib DfsObjectValdtyStartDate Start date
DfsPositionValdtyEndDate I_DFS_ObjectSuplmntyAttrib DfsObjectValdtyEndDate End Date
DfsPositionPlngStatus I_DFS_ObjectSuplmntyAttrib DfsObjectPlngStatus Planning status
DfsPositionName I_DFS_ObjectSuplmntyAttrib DfsObjectName
DfsPositionShortName I_DFS_ObjectSuplmntyAttrib DfsObjectShortName
LanguageCode I_DFS_ObjectSuplmntyAttrib LanguageCode Language Key
DfsPositionPlngStsCritlty I_DFS_ObjectSuplmntyAttrib DfsPositionPlngStsCritlty
DfsPositionIsChiefPositionFoEd I_DFS_ObjectSuplmntyAttrib DfsPositionIsChiefPositionFoEd
_PositionPlngStatusVH _PositionPlngStatusVH

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 C_DFS_PositionSuplmntyAttrib.
-- 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: CPOSOBJSUPATT

CREATE VIEW C_DFS_PositionSuplmntyAttrib AS
SELECT
  I_DFS_ObjectSuplmntyAttrib.DfsObjectID AS DfsPositionID,
  I_DFS_ObjectSuplmntyAttrib.DfsObjectValdtyStartDate AS DfsPositionValdtyStartDate,
  I_DFS_ObjectSuplmntyAttrib.DfsObjectValdtyEndDate AS DfsPositionValdtyEndDate,
  I_DFS_ObjectSuplmntyAttrib.DfsObjectPlngStatus AS DfsPositionPlngStatus,
  I_DFS_ObjectSuplmntyAttrib.DfsObjectName AS DfsPositionName,
  I_DFS_ObjectSuplmntyAttrib.DfsObjectShortName AS DfsPositionShortName,
  I_DFS_ObjectSuplmntyAttrib.LanguageCode AS LanguageCode,
  I_DFS_ObjectSuplmntyAttrib.DfsPositionPlngStsCritlty AS DfsPositionPlngStsCritlty,
  I_DFS_ObjectSuplmntyAttrib.DfsPositionIsChiefPositionFoEd AS DfsPositionIsChiefPositionFoEd
FROM I_DFS_ObjectSuplmntyAttrib
LEFT OUTER JOIN C_DFS_PositionPlngStatusVH AS _PositionPlngStatusVH ON _PositionPlngStatusVH.DfsObjectPlngStatus = DfsPositionPlngStatus  -- association [1..1]
;

Learn More