P_SerialNmbrSalesOrder

DDL: P_SERIALNMBRSALESORDER SQL: PSERSLSORD Type: view CONSUMPTION
7 Fields 1 Data Sources

Serial Number Sales Order Consmptn View

P_SerialNmbrSalesOrder is a Consumption CDS View that provides data about "Serial Number Sales Order Consmptn View" in SAP S/4HANA. It reads from 1 data source (I_SerialNmbrSalesOrder) and exposes 7 fields with key fields Equipment, SalesOrder, SalesOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_SerialNmbrSalesOrder _SerialSalesOrder from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSERSLSORD view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Serial Number Sales Order Consmptn View view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
Material Material Vehicle Model
SerialNumber SerialNumber Serial Number
DocumentType
SalesOrderDate SalesOrderDate Document Date

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 P_SerialNmbrSalesOrder.
-- 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: PSERSLSORD

CREATE VIEW P_SerialNmbrSalesOrder AS
SELECT
  Equipment,
  SalesOrder,
  SalesOrderItem,
  Material,
  SerialNumber,
  cast( 'S' as sn_history_doc_type preserving type ) AS DocumentType,
  SalesOrderDate
FROM I_SerialNmbrSalesOrder AS _SerialSalesOrder
;

Learn More