C_PurchaseOrderItemPurgIssueQ

DDL: C_PURCHASEORDERITEMPURGISSUEQ SQL: CPurOrdItmSU01Q Type: view CONSUMPTION
28 Fields 1 Data Sources

SOFM Purchase Order Item Purchasing Issue Query

C_PurchaseOrderItemPurgIssueQ is a Consumption CDS View that provides data about "SOFM Purchase Order Item Purchasing Issue Query" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItemPurgIssue) and exposes 28 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItemPurgIssue I_PurchaseOrderItemPurgIssue from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_ReferenceDate sydate

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Purchase Order Item Purchasing Issue Query view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CPurOrdItmSU01Q view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
DueDays DueDays Processing Time
DueDate DueDate Promised For
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderType SalesOrderType Sales Order Type
SalesOrderItemCategory SalesOrderItemCategory Item Category
SalesOrderItemCategoryName
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesOrderItemQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
SalesOrderItemNetAmount NetAmount Stated Amount
SalesOrderTransactionCurrency TransactionCurrency Transaction Currency
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
Material Material Vehicle Model
Plant Plant Valuation Area
PlantName PlantName Plant Name
PurchasingDocumentOrderQty PurchasingDocumentOrderQty PO Quantity
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
SuplrConfIsPending
DeliveryDate DeliveryDate Delivery Date
_TransactionCurrency _TransactionCurrency
_OrderQuantityUnit _OrderQuantityUnit

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_PurchaseOrderItemPurgIssueQ.
-- 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: CPurOrdItmSU01Q
-- Parameters: P_Language : sylangu, P_ReferenceDate : sydate

CREATE VIEW C_PurchaseOrderItemPurgIssueQ AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  DueDays,
  DueDate,
  SalesOrder,
  SalesOrderItem,
  SalesOrderType,
  SalesOrderItemCategory,
  _ItemCategory._Text[1: Language=$parameters.P_Language].SalesDocumentItemCategoryName AS SalesOrderItemCategoryName,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  OrderQuantity AS SalesOrderItemQuantity,
  OrderQuantityUnit,
  NetAmount AS SalesOrderItemNetAmount,
  TransactionCurrency AS SalesOrderTransactionCurrency,
  PurchasingDocumentItemText,
  Material,
  Plant,
  PlantName,
  PurchasingDocumentOrderQty,
  PurgDocOrderQuantityUnit,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  cast(SuplrConfIsPending as boolean) AS SuplrConfIsPending,
  DeliveryDate
FROM I_PurchaseOrderItemPurgIssue
;

Learn More