I_OverallDeliveryStatus

DDL: I_OVERALLDELIVERYSTATUS SQL: ISDOVRLDELIVSTS Type: view BASIC Package: VDM_SD_SLS_GF
3 Fields 1 Data Sources 1 Associations 6 OData Services

Overall Delivery Status

I_OverallDeliveryStatus (Basic)

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

Sales Document Overall Delivery Status · Sales

I_OverallDeliveryStatus is a Basic CDS View (Dimension) that provides data about "Overall Delivery Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field OverallDeliveryStatus. It has 1 association to related views. It is exposed through 6 OData services (ASQL_F0333A, ASQL_F8712, C_SALESORDERMANAGE_SD, ...). Part of development package VDM_SD_SLS_GF.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentSD-SLS-GF-2CL
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select,Data Provider for Value Help,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OverallDeliveryStatusText _Text $projection.OverallDeliveryStatus = _Text.OverallDeliveryStatus

Annotations (17)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey OverallDeliveryStatus view
ObjectModel.sapObjectNodeType.name SalesDocOverallDeliveryStatus view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
EndUserText.label Overall Delivery Status view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDOVRLDELIVSTS view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view

OData Services (6)

ServiceBindingVersionContractRelease
ASQL_F0333A ASQL_F0333A C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY OverallDeliveryStatus Delivery Status (All Items)
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_OverallDeliveryStatus.
-- 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: ISDOVRLDELIVSTS

CREATE VIEW I_OverallDeliveryStatus AS
SELECT
  cast ( substring(dd07l.domvalue_l, 1, 1) as lfstk preserving type ) AS OverallDeliveryStatus,
  domvalue_l AS DomainValue
FROM dd07l
LEFT OUTER JOIN I_OverallDeliveryStatusText AS _Text ON OverallDeliveryStatus = _Text.OverallDeliveryStatus  -- association [0..*]
;

Learn More