I_PurchaseOrderItemPurgIssue

DDL: I_PURCHASEORDERITEMPURGISSUE SQL: IPURORDITMSU01 Type: view COMPOSITE
27 Fields 3 Data Sources

SOFM Purchase Order Item Purchasing Issue

I_PurchaseOrderItemPurgIssue is a Composite CDS View that provides data about "SOFM Purchase Order Item Purchasing Issue" in SAP S/4HANA. It reads from 3 data sources (I_SalesOrderInSupplyPurgIssue, I_PurchasingDocumentItem, I_SalesDocumentItem) and exposes 27 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_SalesOrderInSupplyPurgIssue ISSUE_SU01 from
I_PurchasingDocumentItem POI inner
I_SalesDocumentItem SOI inner

Parameters (1)

NameTypeDefault
P_ReferenceDate sydate

Annotations (9)

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 view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IPURORDITMSU01 view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
DueDays I_SalesOrderInSupplyPurgIssue DueDays Processing Time
DueDate I_SalesOrderInSupplyPurgIssue DueDate Promised For
SalesOrder I_SalesOrderInSupplyPurgIssue SalesOrder SD Document
SalesOrderItem I_SalesOrderInSupplyPurgIssue SalesOrderItem Sales Order Item
SalesOrderType
SalesOrderItemCategory I_SalesDocumentItem SalesDocumentItemCategory Item Category
_ItemCategory _ItemCategory
SalesOrganization
DistributionChannel
OrganizationDivision
OrderQuantity I_SalesDocumentItem OrderQuantity Quantity
OrderQuantityUnit I_SalesDocumentItem OrderQuantityUnit Sales Unit
NetAmount I_SalesDocumentItem NetAmount Stated Amount
TransactionCurrency I_SalesDocumentItem TransactionCurrency Transaction Currency
PurchasingDocumentItemText I_PurchasingDocumentItem PurchasingDocumentItemText Short Text
Material I_PurchasingDocumentItem Material Vehicle Model
Plant I_PurchasingDocumentItem Plant Valuation Area
PlantName
PurchasingDocumentOrderQty I_PurchasingDocumentItem OrderQuantity Quantity
PurgDocOrderQuantityUnit I_PurchasingDocumentItem OrderQuantityUnit Sales Unit
IsCompletelyDelivered I_PurchasingDocumentItem IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced I_PurchasingDocumentItem IsFinallyInvoiced Final Invoice
DeliveryDate I_SalesOrderInSupplyPurgIssue DeliveryDate Delivery Date
_TransactionCurrency I_SalesDocumentItem _TransactionCurrency
_OrderQuantityUnit I_SalesDocumentItem _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 I_PurchaseOrderItemPurgIssue.
-- 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: IPURORDITMSU01
-- Parameters: P_ReferenceDate : sydate

CREATE VIEW I_PurchaseOrderItemPurgIssue AS
SELECT
  POI.PurchasingDocument AS PurchasingDocument,
  POI.PurchasingDocumentItem AS PurchasingDocumentItem,
  ISSUE_SU01.DueDays AS DueDays,
  ISSUE_SU01.DueDate AS DueDate,
  ISSUE_SU01.SalesOrder AS SalesOrder,
  ISSUE_SU01.SalesOrderItem AS SalesOrderItem,
  SOI._SalesDocument.SalesDocumentType AS SalesOrderType,
  SOI.SalesDocumentItemCategory AS SalesOrderItemCategory,
  SOI._SalesDocument.SalesOrganization AS SalesOrganization,
  SOI._SalesDocument.DistributionChannel AS DistributionChannel,
  SOI._SalesDocument.OrganizationDivision AS OrganizationDivision,
  SOI.OrderQuantity AS OrderQuantity,
  SOI.OrderQuantityUnit AS OrderQuantityUnit,
  SOI.NetAmount AS NetAmount,
  SOI.TransactionCurrency AS TransactionCurrency,
  POI.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  POI.Material AS Material,
  POI.Plant AS Plant,
  POI._Plant.PlantName AS PlantName,
  POI.OrderQuantity AS PurchasingDocumentOrderQty,
  POI.OrderQuantityUnit AS PurgDocOrderQuantityUnit,
  POI.IsCompletelyDelivered AS IsCompletelyDelivered,
  POI.IsFinallyInvoiced AS IsFinallyInvoiced,
  ISSUE_SU01.DeliveryDate AS DeliveryDate,
  SOI._TransactionCurrency AS _TransactionCurrency,
  SOI._OrderQuantityUnit AS _OrderQuantityUnit
FROM I_SalesOrderInSupplyPurgIssue AS ISSUE_SU01
INNER JOIN I_PurchasingDocumentItem AS POI ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentItem AS SOI ON /* join condition not captured in parsed metadata */
;

Learn More