C_APProcessFlowPurchaseOrder

DDL: C_APPROCESSFLOWPURCHASEORDER SQL: CAPPFPURCHORDER Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Associations

AP Process Flow Purchase Order

C_APProcessFlowPurchaseOrder is a Consumption CDS View that provides data about "AP Process Flow Purchase Order" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 9 fields with key field PurchaseOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder I_PurchaseOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard $projection.CreatedByUser = _UserContactCard.ContactCardID

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CAPPFPURCHORDER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label AP Process Flow Purchase Order view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderType PurchaseOrderType PO Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CreatedByUser CreatedByUser User Name
FullName _UserContactCard FullName Name
Supplier _Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
_UserContactCard _UserContactCard

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 C_APProcessFlowPurchaseOrder.
-- 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: CAPPFPURCHORDER

CREATE VIEW C_APProcessFlowPurchaseOrder AS
SELECT
  PurchaseOrder,
  PurchaseOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  CreatedByUser,
  _UserContactCard.FullName AS FullName,
  _Supplier.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName
FROM I_PurchaseOrder
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [1..1]
;

Learn More