I_ClosingTaskListText

DDL: I_CLOSINGTASKLISTTEXT Type: view BASIC Package: FCCO_VDM_MD
8 Fields 1 Data Sources 3 Associations

Closing Task List Text

I_ClosingTaskListText is a Basic CDS View that provides data about "Closing Task List Text" in SAP S/4HANA. It reads from 1 data source (fcco_hdrt) and exposes 8 fields with key fields ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, Language. It has 3 associations to related views. Part of development package FCCO_VDM_MD.

Data Sources (1)

SourceAliasJoin Type
fcco_hdrt fcco_hdrt from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_ClosingTemplate _ClosingTemplate $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType
[1..1] I_FinTaskListContextType _FinTaskListContextType $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGTASKLISTT view
AbapCatalog.preserveKey true view
EndUserText.label Closing Task List Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ClosingTaskListInstance view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ClosingTemplate profile WBS sched. prof
KEY ClosingTaskListInstance instance TaskCount
KEY FinancialTaskListContextType flavor Task List Context
KEY Language langu Primary lang.
ClosingTaskListDescription text User Group
_Language _Language
_ClosingTemplate _ClosingTemplate
_FinTaskListContextType _FinTaskListContextType

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_ClosingTaskListText.
-- 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.

CREATE VIEW I_ClosingTaskListText AS
SELECT
  profile AS ClosingTemplate,
  instance AS ClosingTaskListInstance,
  flavor AS FinancialTaskListContextType,
  langu AS Language,
  text AS ClosingTaskListDescription
FROM fcco_hdrt
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_ClosingTemplate AS _ClosingTemplate ON ClosingTemplate = _ClosingTemplate.ClosingTemplate AND FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType  -- association [0..1]
LEFT OUTER JOIN I_FinTaskListContextType AS _FinTaskListContextType ON FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType  -- association [1..1]
;

Learn More