P_WrkflwPurchaseOrderItem

DDL: P_WRKFLWPURCHASEORDERITEM SQL: PWRKPURORDITM Type: view CONSUMPTION
20 Fields 4 Data Sources

P View of Purchase Order item Workflow

P_WrkflwPurchaseOrderItem is a Consumption CDS View that provides data about "P View of Purchase Order item Workflow" in SAP S/4HANA. It reads from 4 data sources (I_PurchaseOrderItem, I_PurchasingDocumentType, I_PurchaseOrder, P_PurOrdWorkflowApprovalTime1) and exposes 20 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (4)

SourceAliasJoin Type
I_PurchaseOrderItem POItem from
I_PurchasingDocumentType PurchasingDocumentType inner
I_PurchaseOrder PurOrd inner
P_PurOrdWorkflowApprovalTime1 WorkflowStatusOverview inner

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate badat
P_EndDate badat

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PWRKPURORDITM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label P View of Purchase Order item Workflow view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
CompanyCode I_PurchaseOrderItem CompanyCode Receiver Company Code
Supplier Supplier Supplier
Plant I_PurchaseOrderItem Plant Valuation Area
Material I_PurchaseOrderItem Material Vehicle Model
MaterialGroup I_PurchaseOrderItem MaterialGroup Product Group
AccountAssignmentCategory I_PurchaseOrderItem AccountAssignmentCategory Acct Assgmt Cat
PurchaseOrderDate PurchaseOrderDate PO Date
CreatedByUser I_PurchaseOrder CreatedByUser User Name
DocumentCurrency I_PurchaseOrder DocumentCurrency Document Currency
NetPriceQuantity I_PurchaseOrderItem NetPriceQuantity Price Unit
PurchaseOrderType PurchaseOrderType PO Type
OrderQuantity I_PurchaseOrderItem OrderQuantity Quantity
WrkflwTskCreationUTCDateTime WrkflwTskCreationUTCDateTime
WrkflwTskCompletionUTCDateTime WrkflwTskCompletionUTCDateTime
ApprovalTime
TargetApprovalTime TargetApprovalTime

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_WrkflwPurchaseOrderItem.
-- 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: PWRKPURORDITM
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : badat, P_EndDate : badat

CREATE VIEW P_WrkflwPurchaseOrderItem AS
SELECT
  POItem.PurchaseOrder AS PurchaseOrder,
  POItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurOrd.PurchasingGroup AS PurchasingGroup,
  PurOrd.PurchasingOrganization AS PurchasingOrganization,
  POItem.CompanyCode AS CompanyCode,
  Supplier,
  POItem.Plant AS Plant,
  POItem.Material AS Material,
  POItem.MaterialGroup AS MaterialGroup,
  POItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseOrderDate,
  PurOrd.CreatedByUser AS CreatedByUser,
  PurOrd.DocumentCurrency AS DocumentCurrency,
  POItem.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderType,
  POItem.OrderQuantity AS OrderQuantity,
  WrkflwTskCreationUTCDateTime,
  WrkflwTskCompletionUTCDateTime,
  tstmp_seconds_between( WrkflwTskCreationUTCDateTime , WrkflwTskCompletionUTCDateTime , 'INITIAL' ) AS ApprovalTime,
  TargetApprovalTime
FROM I_PurchaseOrderItem AS POItem
INNER JOIN I_PurchaseOrder AS PurOrd ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentType AS PurchasingDocumentType ON /* join condition not captured in parsed metadata */
INNER JOIN P_PurOrdWorkflowApprovalTime1 AS WorkflowStatusOverview ON /* join condition not captured in parsed metadata */
;

Learn More