P_Cfd_Field_Status

DDL: P_CFD_FIELD_STATUS SQL: P_CFD_FLD_STATUS Type: view

Status Values of Custom Fields

P_Cfd_Field_Status is a CDS View that provides data about "Status Values of Custom Fields" in SAP S/4HANA. It reads from 1 data source (P_Cfd_Domain_Value) and exposes 2 fields with key field Code. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_Cfd_Domain_Value FieldStatus from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_Cfd_Domain_Value_Text _Text _Text.Code = $projection.Code and _Text.Name = 'CFD_FIELD_STATUS_UI'

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_FLD_STATUS view
EndUserText.label Status Values of Custom Fields view
VDM.private true view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Code P_Cfd_Domain_Value Code
_Text _Text
@AbapCatalog.sqlViewName: 'P_CFD_FLD_STATUS'
@EndUserText.label: 'Status Values of Custom Fields'
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
define view P_Cfd_Field_Status as 
  select from P_Cfd_Domain_Value as FieldStatus
    association [1..*] to P_Cfd_Domain_Value_Text as _Text
      on  _Text.Code = $projection.Code
      and _Text.Name = 'CFD_FIELD_STATUS_UI'
{
  key FieldStatus.Code,
  _Text
} where FieldStatus.Name = 'CFD_FIELD_STATUS_UI'