P_Cfd_Availability_Type

DDL: P_CFD_AVAILABILITY_TYPE SQL: P_CFD_AVL_TYPE Type: view

Possible values of availability of Custom Fields

P_Cfd_Availability_Type is a CDS View that provides data about "Possible values of availability 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.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
P_Cfd_Domain_Value AvailabilityType from

Associations (1)

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

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_AVL_TYPE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Possible values of availability of Custom Fields view
ClientDependent false view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Code P_Cfd_Domain_Value Code
_Text _Text 
@AbapCatalog.sqlViewName: 'P_CFD_AVL_TYPE'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Possible values of availability of Custom Fields'
@ClientDependent: false
@VDM.private: true
define view P_Cfd_Availability_Type as 
  select from P_Cfd_Domain_Value as AvailabilityType
    association [1..*] to P_Cfd_Domain_Value_Text as _Text
      on  _Text.Code = $projection.Code
      and _Text.Name = 'CFD_AVAILABILITY_TYPE'
{
  key AvailabilityType.Code,
  _Text
} where AvailabilityType.Name = 'CFD_AVAILABILITY_TYPE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CFD_DOMAIN_VALUE"
],
"ASSOCIATED":
[
"P_CFD_DOMAIN_VALUE_TEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More