C_InApprovalPurchaseOrderItem

DDL: C_INAPPROVALPURCHASEORDERITEM SQL: CINAPPO Type: view CONSUMPTION
18 Fields 1 Data Sources

In Approval Purchase Order Items

C_InApprovalPurchaseOrderItem is a Consumption CDS View that provides data about "In Approval Purchase Order Items" in SAP S/4HANA. It reads from 1 data source (P_InApprovalPurchaseOrderItem) and exposes 18 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
P_InApprovalPurchaseOrderItem P_InApprovalPurchaseOrderItem from

Parameters (1)

NameTypeDefault
P_DisplayCurrency displaycurrency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CINAPPO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
EndUserText.label In Approval Purchase Order Items view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
MaterialGroup MaterialGroup Product Group
PurchasingCategory PurchasingCategory Purchasing Category
PurchasingOrganization _PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
Material Material Vehicle Model
MaterialName MaterialName Material Description
PurchaseOrderDate _PurchaseOrder PurchaseOrderDate PO Date
OrderQuantity OrderQuantity Quantity
Supplier _PurchaseOrder Supplier Supplier
SupplierName
curr215asNetAmount
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
DisplayCurrency
_PurchaseOrder _PurchaseOrder

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_InApprovalPurchaseOrderItem.
-- 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: CINAPPO
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW C_InApprovalPurchaseOrderItem AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  MaterialGroup,
  PurchasingCategory,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  CompanyCode,
  Plant,
  Material,
  MaterialName,
  _PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  OrderQuantity,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  cast( currency_conversion( amount => NetAmount, source_currency => _PurchaseOrder.DocumentCurrency, round => 'X', target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => _PurchaseOrder.PurchaseOrderDate, error_handling => 'SET_TO_NULL') as abap.curr(21,5)) as NetAmount AS curr215asNetAmount,
  PurchaseOrderQuantityUnit,
  cast(:P_DisplayCurrency as displaycurrency) AS DisplayCurrency
FROM P_InApprovalPurchaseOrderItem
;

Learn More