P_SOFAProcFlow10

DDL: P_SOFAPROCFLOW10 SQL: PSOFAPROCF10 Type: view COMPOSITE
19 Fields 2 Data Sources

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

Data Sources (2)

SourceAliasJoin Type
I_SDDocumentProcessFlow Level1 inner
P_SOFAProcFlow00 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 #COMPOSITE view
AbapCatalog.sqlViewName PSOFAPROCF10 view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SDDocumentCategory P_SOFAProcFlow00 SDDocumentCategory Document Cat.
KEY Level1Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level1DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesOrganization P_SOFAProcFlow00 SalesOrganization Sales Organization
DistributionChannel P_SOFAProcFlow00 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SOFAProcFlow00 OrganizationDivision Org. Division
OverallSDProcessStatus P_SOFAProcFlow00 OverallSDProcessStatus
OverallTotalDeliveryStatus P_SOFAProcFlow00 OverallTotalDeliveryStatus
OverallOrdReltdBillgStatus P_SOFAProcFlow00 OverallOrdReltdBillgStatus
RequestedDeliveryDate P_SOFAProcFlow00 RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus
SalesDocumentDate P_SOFAProcFlow00 SalesDocumentDate Document Date
SalesGroup P_SOFAProcFlow00 SalesGroup Sales Group
SalesOffice P_SOFAProcFlow00 SalesOffice Sales Office
SoldToParty P_SOFAProcFlow00 SoldToParty Sold-to Party
PurchaseOrderByCustomer P_SOFAProcFlow00 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_SOFAProcFlow10.
-- 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: PSOFAPROCF10

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

Learn More