P_SOFAProcFlow20

DDL: P_SOFAPROCFLOW20 SQL: PSOFAPROCF20 Type: view COMPOSITE
22 Fields 2 Data Sources

P_SOFAProcFlow20 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_SOFAProcFlow10, I_SDDocumentProcessFlow) and exposes 22 fields with key fields SalesDocument, SDDocumentCategory, Level1Document, Level1DocumentItem, Level1DocumentCategory.

Data Sources (2)

SourceAliasJoin Type
P_SOFAProcFlow10 Level1 from
I_SDDocumentProcessFlow Level2 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 #COMPOSITE view
AbapCatalog.sqlViewName PSOFAPROCF20 view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SDDocumentCategory P_SOFAProcFlow10 SDDocumentCategory Document Cat.
KEY Level1Document Level1Document
KEY Level1DocumentItem Level1DocumentItem
KEY Level1DocumentCategory Level1DocumentCategory
KEY Level2Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level2DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level2DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesDocumentType P_SOFAProcFlow10 SalesDocumentType Sales Doc. Type
SalesOrganization P_SOFAProcFlow10 SalesOrganization Sales Organization
DistributionChannel P_SOFAProcFlow10 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SOFAProcFlow10 OrganizationDivision Org. Division
OverallSDProcessStatus P_SOFAProcFlow10 OverallSDProcessStatus
OverallTotalDeliveryStatus P_SOFAProcFlow10 OverallTotalDeliveryStatus
OverallOrdReltdBillgStatus P_SOFAProcFlow10 OverallOrdReltdBillgStatus
RequestedDeliveryDate P_SOFAProcFlow10 RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus
SalesDocumentDate P_SOFAProcFlow10 SalesDocumentDate Document Date
SalesGroup P_SOFAProcFlow10 SalesGroup Sales Group
SalesOffice P_SOFAProcFlow10 SalesOffice Sales Office
SoldToParty P_SOFAProcFlow10 SoldToParty Sold-to Party
PurchaseOrderByCustomer P_SOFAProcFlow10 PurchaseOrderByCustomer Purchase Order Number

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_SOFAProcFlow20.
-- 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: PSOFAPROCF20

CREATE VIEW P_SOFAProcFlow20 AS
SELECT
  SalesDocument,
  Level1.SDDocumentCategory AS SDDocumentCategory,
  Level1Document,
  Level1DocumentItem,
  Level1DocumentCategory,
  Level2.SubsequentDocument AS Level2Document,
  Level2.SubsequentDocumentItem AS Level2DocumentItem,
  Level2.SubsequentDocumentCategory AS Level2DocumentCategory,
  Level1.SalesDocumentType AS SalesDocumentType,
  Level1.SalesOrganization AS SalesOrganization,
  Level1.DistributionChannel AS DistributionChannel,
  Level1.OrganizationDivision AS OrganizationDivision,
  Level1.OverallSDProcessStatus AS OverallSDProcessStatus,
  Level1.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  Level1.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  Level1.RequestedDeliveryDate AS RequestedDeliveryDate,
  Level1.SalesDocumentDate AS SalesDocumentDate,
  Level1.SalesGroup AS SalesGroup,
  Level1.SalesOffice AS SalesOffice,
  Level1.SoldToParty AS SoldToParty,
  Level1.PurchaseOrderByCustomer AS PurchaseOrderByCustomer
FROM P_SOFAProcFlow10 AS Level1
INNER JOIN I_SDDocumentProcessFlow AS Level2 ON /* join condition not captured in parsed metadata */
;

Learn More