C_APProcessFlowPurOrdItemVH

DDL: C_APPROCESSFLOWPURORDITEMVH SQL: CAPPFPOITEMVH Type: view CONSUMPTION Package: ODATA_PROCESS_FLOW_AP

AP Process Flow Purchase Order Item VH

C_APProcessFlowPurOrdItemVH is a Consumption CDS View that provides data about "AP Process Flow Purchase Order Item VH" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 10 fields with key fields PurchaseOrder, PurchaseOrderItem. It is exposed through 1 OData service (ASQL_F2691). Part of development package ODATA_PROCESS_FLOW_AP.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder I_PurchaseOrder from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CAPPFPOITEMVH view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label AP Process Flow Purchase Order Item VH view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2691 ASQL_F2691 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem _PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Supplier Supplier Supplier
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseOrderDate PurchaseOrderDate PO Date
PurchaseOrderType PurchaseOrderType PO Type
AuthorizationGroup _Supplier AuthorizationGroup AuthorizGroup

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_APProcessFlowPurOrdItemVH.
-- 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: CAPPFPOITEMVH

CREATE VIEW C_APProcessFlowPurOrdItemVH AS
SELECT
  PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderDate,
  PurchaseOrderType,
  _Supplier.AuthorizationGroup AS AuthorizationGroup
FROM I_PurchaseOrder
;