P_SlsQtanProcFlow30

DDL: P_SLSQTANPROCFLOW30 SQL: PSLSQTANPROCF30 Type: view CONSUMPTION
11 Fields 2 Data Sources

P_SlsQtanProcFlow30 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_SlsQtanProcFlow20, I_SDDocumentProcessFlow) and exposes 11 fields with key fields Level2Document, Level2DocumentItem, Level3Document, Level3DocumentItem, SalesQuotation.

Data Sources (2)

SourceAliasJoin Type
P_SlsQtanProcFlow20 Level2 from
I_SDDocumentProcessFlow Level3 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 PSLSQTANPROCF30 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Level2Document P_SlsQtanProcFlow20 Level2Document
KEY Level2DocumentItem P_SlsQtanProcFlow20 Level2DocumentItem
KEY Level3Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level3DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY SalesQuotation P_SlsQtanProcFlow20 SalesQuotation
SalesQuotationType P_SlsQtanProcFlow20 SalesQuotationType
Level2DocumentCategory P_SlsQtanProcFlow20 Level2DocumentCategory
Level3DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesOrganization P_SlsQtanProcFlow20 SalesOrganization Sales Organization
DistributionChannel P_SlsQtanProcFlow20 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SlsQtanProcFlow20 OrganizationDivision Org. Division

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_SlsQtanProcFlow30.
-- 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: PSLSQTANPROCF30

CREATE VIEW P_SlsQtanProcFlow30 AS
SELECT
  Level2.Level2Document AS Level2Document,
  Level2.Level2DocumentItem AS Level2DocumentItem,
  Level3.SubsequentDocument AS Level3Document,
  Level3.SubsequentDocumentItem AS Level3DocumentItem,
  Level2.SalesQuotation AS SalesQuotation,
  Level2.SalesQuotationType AS SalesQuotationType,
  Level2.Level2DocumentCategory AS Level2DocumentCategory,
  Level3.SubsequentDocumentCategory AS Level3DocumentCategory,
  Level2.SalesOrganization AS SalesOrganization,
  Level2.DistributionChannel AS DistributionChannel,
  Level2.OrganizationDivision AS OrganizationDivision
FROM P_SlsQtanProcFlow20 AS Level2
INNER JOIN I_SDDocumentProcessFlow AS Level3 ON /* join condition not captured in parsed metadata */
;

Learn More