I_PutawayStatus

DDL: I_PUTAWAYSTATUS SQL: ILEKOSTK Type: view BASIC Package: VDM_LE_SHP_COMMON

Putaway Status

I_PutawayStatus (Basic)

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

Overall Pick Status · Supply Chain

I_PutawayStatus is a Basic CDS View (Dimension) that provides data about "Putaway Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field PutawayStatus. It has 1 association to related views. Part of development package VDM_LE_SHP_COMMON.

SAP Help Documentation

CategoryCDS Views for Inbound Delivery Documents
StatusReleased
Purpose
This CDS view is the basic interface view for Putaway Status. You can use this CDS view to build your own consumption view on top.

Prerequisites
This CDS view does not require any authorization.

Structure
Main input parameters This view does not have any input parameters. Attributes This view contains the following attributes: Putaway status

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSupply Chain
Application ComponentLE-SHP-GF-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Provider for Value Help,Data Source for Search,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is the basic interface view for Putaway Status. You can use this CDS view to build your own consumption view on top.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PutawayStatusText _Text $projection.PutawayStatus = _Text.PutawayStatus

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ILEKOSTK view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Putaway Status view
VDM.viewType #BASIC view
ObjectModel.representativeKey PutawayStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name OverallPickStatus view
ObjectModel.dataCategory #VALUE_HELP view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PutawayStatus Putaway Status
DomainValue domvalue_l Values for Domains: Single Value/Lower Limit
_Text _Text

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_PutawayStatus.
-- 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: ILEKOSTK

CREATE VIEW I_PutawayStatus AS
SELECT
  cast(left(dd07l.domvalue_l, 1 ) as le_putaway_status preserving type) AS PutawayStatus,
  domvalue_l AS DomainValue
FROM dd07l
LEFT OUTER JOIN I_PutawayStatusText AS _Text ON PutawayStatus = _Text.PutawayStatus  -- association [0..*]
;