I_SupplierActivityTaskPrio

DDL: I_SUPPLIERACTIVITYTASKPRIO SQL: ISUPLACTTSKPRIO Type: view BASIC Package: VDM_SLC_TSK

Priority of Supplier Activity Task

I_SupplierActivityTaskPrio (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_SupplierActivityTaskPrio is a Basic CDS View that provides data about "Priority of Supplier Activity Task" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field SuplrActyTaskPriority. It has 1 association to related views. Part of development package VDM_SLC_TSK.

SAP Help Documentation

CategoryProcurement-Related Task
StatusReleased
Purpose
This view provides supported values for SUPPLIERACTIVITYTASKPRIO. The values and their meanings are: Priority of a Task Fixed Value Description 1 Low 2 Medium 3 High 4 Very High

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSourcing & Procurement
Application ComponentSLC-ACT
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSourcing and Procurement for SAP S/4HANA Cloud Public Edition
Description <p>This view provides supported values for SUPPLIERACTIVITYTASKPRIO.</p> <p>The values and their meanings are:</p> Priority of a Task Fixed Value Description 1 Low 2 Medium 3 High 4 Very High

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SupplierActivityTaskPrioText _SupplierActivityTaskPrioText $projection.SuplrActyTaskPriority = _SupplierActivityTaskPrioText.SuplrActyTaskPriority

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISUPLACTTSKPRIO view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey SuplrActyTaskPriority view
EndUserText.label Priority of Supplier Activity Task view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SuplrActyTaskPriority Priority of a Task
_SupplierActivityTaskPrioText _SupplierActivityTaskPrioText

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_SupplierActivityTaskPrio.
-- 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: ISUPLACTTSKPRIO

CREATE VIEW I_SupplierActivityTaskPrio AS
SELECT
  cast(substring( domvalue_l, 1, 1) as /srmsmc/tsk_priority) AS SuplrActyTaskPriority
FROM dd07l
LEFT OUTER JOIN I_SupplierActivityTaskPrioText AS _SupplierActivityTaskPrioText ON SuplrActyTaskPriority = _SupplierActivityTaskPrioText.SuplrActyTaskPriority  -- association [0..*]
;