P_SlsQtanProcFlow0

DDL: P_SLSQTANPROCFLOW0 SQL: PSLSQTANPROCF0 Type: view CONSUMPTION
9 Fields 1 Data Sources

P_SlsQtanProcFlow0 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 9 fields with key fields Level1Document, Level1DocumentItem, SalesQuotation.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic SalesDocument from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PSLSQTANPROCF0 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Level1Document
KEY Level1DocumentItem
KEY SalesQuotation SD Document
SalesQuotationType SalesDocumentType Sales Doc. Type
SalesQuotationCategory SDDocumentCategory Document Cat.
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesOrderIsProjectBased

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_SlsQtanProcFlow0.
-- 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: PSLSQTANPROCF0

CREATE VIEW P_SlsQtanProcFlow0 AS
SELECT
  cast('' as vbeln_von) AS Level1Document,
  cast('' as posnr_von) AS Level1DocumentItem,
  cast(SalesDocument as sales_quotation) AS SalesQuotation,
  SalesDocumentType AS SalesQuotationType,
  SDDocumentCategory AS SalesQuotationCategory,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  '' AS SalesOrderIsProjectBased
FROM I_SalesDocumentBasic AS SalesDocument
;

Learn More