P_SOFAProcFlow00

DDL: P_SOFAPROCFLOW00 SQL: PSOFAPROCF0 Type: view COMPOSITE
16 Fields 1 Data Sources

P_SOFAProcFlow00 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocument) and exposes 16 fields with key fields SalesDocument, SDDocumentCategory.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocument 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 PSOFAPROCF0 view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesOrganization I_SalesDocument SalesOrganization Sales Organization
DistributionChannel I_SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesDocument OrganizationDivision Org. Division
OverallSDProcessStatus OverallSDProcessStatus
OverallTotalDeliveryStatus OverallTotalDeliveryStatus
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus
SalesDocumentDate SalesDocumentDate Document Date
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SoldToParty SoldToParty Sold-to Party
PurchaseOrderByCustomer 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_SOFAProcFlow00.
-- 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: PSOFAPROCF0

CREATE VIEW P_SOFAProcFlow00 AS
SELECT
  SalesDocument,
  SDDocumentCategory,
  SalesDocumentType,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  OverallSDProcessStatus,
  OverallTotalDeliveryStatus,
  OverallOrdReltdBillgStatus,
  RequestedDeliveryDate,
  SalesDocumentDate,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  PurchaseOrderByCustomer
FROM I_SalesDocument AS SalesDocument
;

Learn More