P_SlsQtanProcFlow10

DDL: P_SLSQTANPROCFLOW10 SQL: PSLSQTANPROCF10 Type: view CONSUMPTION
10 Fields 2 Data Sources

P_SlsQtanProcFlow10 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_SlsQtanProcFlow0, I_SDDocumentProcessFlow) and exposes 10 fields with key fields Level1Document, Level1DocumentItem, Level1DocumentCategory.

Data Sources (2)

SourceAliasJoin Type
P_SlsQtanProcFlow0 Level0 from
I_SDDocumentProcessFlow Level1 inner

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 PSLSQTANPROCF10 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Level1Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level1DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesQuotation P_SlsQtanProcFlow0 SalesQuotation
SalesQuotationType P_SlsQtanProcFlow0 SalesQuotationType Sales Doc. Type
SalesQuotationCategory P_SlsQtanProcFlow0 SalesQuotationCategory Document Cat.
SalesOrganization P_SlsQtanProcFlow0 SalesOrganization Sales Organization
DistributionChannel P_SlsQtanProcFlow0 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SlsQtanProcFlow0 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_SlsQtanProcFlow10.
-- 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: PSLSQTANPROCF10

CREATE VIEW P_SlsQtanProcFlow10 AS
SELECT
  Level1.SubsequentDocument AS Level1Document,
  Level1.SubsequentDocumentItem AS Level1DocumentItem,
  Level1.SubsequentDocumentCategory AS Level1DocumentCategory,
  Level0.SalesQuotation AS SalesQuotation,
  Level0.SalesQuotationType AS SalesQuotationType,
  Level0.SalesQuotationCategory AS SalesQuotationCategory,
  Level0.SalesOrganization AS SalesOrganization,
  Level0.DistributionChannel AS DistributionChannel,
  Level0.OrganizationDivision AS OrganizationDivision,
  '' AS SalesOrderIsProjectBased
FROM P_SlsQtanProcFlow0 AS Level0
INNER JOIN I_SDDocumentProcessFlow AS Level1 ON /* join condition not captured in parsed metadata */
;

Learn More