A_CustomFieldCodeListValue

DDL: A_CUSTOMFIELDCODELISTVALUE SQL: ACFDCODEVALUE Type: view Package: S_CFD_EXT_INTERFACE_TEMPLATE
4 Fields 2 Data Sources 1 Associations

Custom Field Code List Value

A_CustomFieldCodeListValue is a CDS View that provides data about "Custom Field Code List Value" in SAP S/4HANA. It reads from 2 data sources (P_CustomFieldLatestVersion, cfd_w_rep_code) and exposes 4 fields with key fields CustomFieldID, Code. It has 1 association to related views. Part of development package S_CFD_EXT_INTERFACE_TEMPLATE.

Data Sources (2)

SourceAliasJoin Type
P_CustomFieldLatestVersion _LatestVersion inner
cfd_w_rep_code CodeListValue from

Associations (1)

CardinalityTargetAliasCondition
[1..*] A_CustomFieldCodeListDesc _CodeListDescription _CodeListDescription.CustomFieldID = _LatestVersion.external_name and _CodeListDescription.Code = CodeListValue.code

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACFDCODEVALUE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Custom Field Code List Value view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CustomFieldID P_CustomFieldLatestVersion external_name External Name
KEY Code cfd_w_rep_code code Water Hazard Cl.
IsDisabled cfd_w_rep_code is_disabled Disabled
_CodeListDescription _CodeListDescription

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 A_CustomFieldCodeListValue.
-- 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: ACFDCODEVALUE

CREATE VIEW A_CustomFieldCodeListValue AS
SELECT
  _LatestVersion.external_name AS CustomFieldID,
  CodeListValue.code AS Code,
  CodeListValue.is_disabled AS IsDisabled
FROM cfd_w_rep_code AS CodeListValue
INNER JOIN P_CustomFieldLatestVersion AS _LatestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_CustomFieldCodeListDesc AS _CodeListDescription ON _CodeListDescription.CustomFieldID = _LatestVersion.external_name AND _CodeListDescription.Code = CodeListValue.code  -- association [1..*]
;

Learn More