I_SuplrActLifecycleStatusText

DDL: I_SUPLRACTLIFECYCLESTATUSTEXT SQL: ISUPACTLFSTST Type: view BASIC Package: VDM_SLC_ACT
5 Fields 1 Data Sources 2 Associations 2 OData Services

Lifecycle Status of Suplr Acty - Text

I_SuplrActLifecycleStatusText (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_SuplrActLifecycleStatusText is a Basic CDS View that provides data about "Lifecycle Status of Suplr Acty - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields SuplrActyLifecycleStatus, Language. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F0354, ASQL_F1990). Part of development package VDM_SLC_ACT.

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,Language-Dependent Text
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 SUPLRACTLIFECYCLESTATUS.</p> <p>The values and their meanings are:</p> Lifecycle Status Code for Activities Fixed Value Description 01 In Preparation 02 New 03 In Process 04 Submitted 05 Pending Clarification 06 Completed

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_SuplrActLifecycleStatus _SuplrActLifecycleStatus $projection.SuplrActyLifecycleStatus = _SuplrActLifecycleStatus.SuplrActyLifecycleStatus

Annotations (13)

NameValueLevelField
EndUserText.label Lifecycle Status of Suplr Acty - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey SuplrActyLifecycleStatus view
AbapCatalog.sqlViewName ISUPACTLFSTST view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F0354 ASQL_F0354 C2 NOT_RELEASED
ASQL_F1990 ASQL_F1990 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SuplrActyLifecycleStatus Lifecycle Status Code for Activities
KEY Language ddlanguage Language Key
SuplrActyLifecycleStatusName Short text
_SuplrActLifecycleStatus _SuplrActLifecycleStatus
_Language _Language

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_SuplrActLifecycleStatusText.
-- 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: ISUPACTLFSTST

CREATE VIEW I_SuplrActLifecycleStatusText AS
SELECT
  cast ( substring( domvalue_l, 1, 2 ) as /srmsmc/act_lifecycle_stat_cd preserving type) AS SuplrActyLifecycleStatus,
  ddlanguage AS Language,
  cast(ddtext as /srmsmc/status_descr) AS SuplrActyLifecycleStatusName
FROM dd07t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_SuplrActLifecycleStatus AS _SuplrActLifecycleStatus ON SuplrActyLifecycleStatus = _SuplrActLifecycleStatus.SuplrActyLifecycleStatus  -- association [1..1]
;

Learn More