DEMO_SALES_PV_SO

DDL: DEMO_SALES_PV_SO Type: view_entity Package: SABAP_DEMOS_SALES
10 Fields 1 Data Sources

Projection View SO

DEMO_SALES_PV_SO is a CDS View that provides data about "Projection View SO" in SAP S/4HANA. It reads from 1 data source (DEMO_SALES_CDS_SO) and exposes 10 fields with key field SalesOrderKey. Part of development package SABAP_DEMOS_SALES.

Data Sources (1)

SourceAliasJoin Type
DEMO_SALES_CDS_SO DEMO_SALES_CDS_SO projection

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Projection View SO view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderKey so_key SO key
SalesOrderExternalId id WorklistID
LifecycleStatus lifecycle_status Status
BuyerId buyer_id Identifier
BuyerDescription _Buyer family_name
CreatedBy created_by Version Created By
LastChangedBy last_changed_by Username
dats8
_BuyerredirectedtoDEMO_SALES_PV_BUPA
ShipToPartner DEMO_SALES_CDS_SO ship_to_id Business Partner ID

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 DEMO_SALES_PV_SO.
-- 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.

CREATE VIEW DEMO_SALES_PV_SO AS
SELECT
  so_key AS SalesOrderKey,
  id AS SalesOrderExternalId,
  lifecycle_status AS LifecycleStatus,
  buyer_id AS BuyerId,
  _Buyer.family_name AS BuyerDescription,
  created_by AS CreatedBy,
  last_changed_by AS LastChangedBy,
  virtual ValidToDate : abap.dats(8) AS dats8,
  DEMO_SALES_CDS_SO.ship_to_id AS ShipToPartner
FROM DEMO_SALES_CDS_SO
;

Learn More