P_SOFAProcFlow30

DDL: P_SOFAPROCFLOW30 SQL: PSOFAPROCF30 Type: view COMPOSITE
23 Fields 2 Data Sources

P_SOFAProcFlow30 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_SOFAProcFlow20, I_SDDocumentProcessFlow) and exposes 23 fields with key fields SalesDocument, SDDocumentCategory, Level2Document, Level2DocumentItem, Level2DocumentCategory.

Data Sources (2)

SourceAliasJoin Type
P_SOFAProcFlow20 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 #COMPOSITE view
AbapCatalog.sqlViewName PSOFAPROCF30 view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SDDocumentCategory P_SOFAProcFlow20 SDDocumentCategory Document Cat.
KEY Level2Document Level2Document
KEY Level2DocumentItem Level2DocumentItem
KEY Level2DocumentCategory Level2DocumentCategory
KEY Level1DocumentCategory Level1DocumentCategory
KEY Level3Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level3DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY Level3DocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SalesDocumentType P_SOFAProcFlow20 SalesDocumentType Sales Doc. Type
SalesOrganization P_SOFAProcFlow20 SalesOrganization Sales Organization
DistributionChannel P_SOFAProcFlow20 DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SOFAProcFlow20 OrganizationDivision Org. Division
OverallSDProcessStatus P_SOFAProcFlow20 OverallSDProcessStatus
OverallTotalDeliveryStatus P_SOFAProcFlow20 OverallTotalDeliveryStatus
OverallOrdReltdBillgStatus P_SOFAProcFlow20 OverallOrdReltdBillgStatus
RequestedDeliveryDate P_SOFAProcFlow20 RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus
SalesDocumentDate P_SOFAProcFlow20 SalesDocumentDate Document Date
SalesGroup P_SOFAProcFlow20 SalesGroup Sales Group
SalesOffice P_SOFAProcFlow20 SalesOffice Sales Office
SoldToParty P_SOFAProcFlow20 SoldToParty Sold-to Party
PurchaseOrderByCustomer P_SOFAProcFlow20 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_SOFAProcFlow30.
-- 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: PSOFAPROCF30

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

Learn More