VB_DRAFT_PUBLISH_STATUS_VIEWS

DDL: VB_DRAFT_PUBLISH_STATUS_VIEWS SQL: VBSTATUSALL Type: view Package: S_DICT_VB
7 Fields 2 Data Sources

View to get all staus for custom query

VB_DRAFT_PUBLISH_STATUS_VIEWS is a CDS View that provides data about "View to get all staus for custom query" in SAP S/4HANA. It reads from 2 data sources (VB_DRAFT_AND_PUBLISH_VIEWS, VB_DRAFT_OR_PUBLISH_VIEWS) and exposes 7 fields with key field ItemId. Part of development package S_DICT_VB.

Data Sources (2)

SourceAliasJoin Type
VB_DRAFT_AND_PUBLISH_VIEWS _draft_and_published from
VB_DRAFT_OR_PUBLISH_VIEWS _draft_or_published union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VBSTATUSALL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View to get all staus for custom query view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ItemId VB_DRAFT_AND_PUBLISH_VIEWS ItemId Russia Statutory Reporting Report Land Tax, Run Item ID
Ddlname VB_DRAFT_AND_PUBLISH_VIEWS Ddlname DDL Source Name
CDSViewStatus
ItemId Russia Statutory Reporting Report Land Tax, Run Item ID
Ddlname VB_DRAFT_OR_PUBLISH_VIEWS Ddlname DDL Source Name
CDSViewStatus VB_DRAFT_OR_PUBLISH_VIEWS CDSViewStatus
is_draft VB_DRAFT_OR_PUBLISH_VIEWS is_draft Is Draft

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 VB_DRAFT_PUBLISH_STATUS_VIEWS.
-- 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: VBSTATUSALL

CREATE VIEW VB_DRAFT_PUBLISH_STATUS_VIEWS AS
SELECT
  _draft_and_published.ItemId AS ItemId,
  _draft_and_published.Ddlname AS Ddlname,
  'PUBLISHED' AS CDSViewStatus,
  _draft_or_published.is_draft AS is_draft
FROM VB_DRAFT_AND_PUBLISH_VIEWS AS _draft_and_published
-- UNION ALL with additional select branch(es): VB_DRAFT_OR_PUBLISH_VIEWS
;

Learn More