P_POItemAcctInvoiceTotalCalc

DDL: P_POITEMACCTINVOICETOTALCALC Type: view_entity CONSUMPTION
8 Fields 1 Data Sources 3 Associations

P_POItemAcctInvoiceTotalCalc is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_PurOrdAccountAssignment) and exposes 8 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdAccountAssignment I_PurOrdAccountAssignment from

Associations (3)

CardinalityTargetAliasCondition
[1..1] P_TotalGrInvQty _TotalGrInvQty $projection.PurchaseOrder = _TotalGrInvQty.PurchaseOrder and $projection.PurchaseOrderItem = _TotalGrInvQty.PurchaseOrderItem
[0..1] P_POItemAcctInvoiceCalc _POItemAcctInvoiceCalc $projection.PurchaseOrder = _POItemAcctInvoiceCalc.PurchaseOrder and $projection.PurchaseOrderItem = _POItemAcctInvoiceCalc.PurchaseOrderItem and $projection.AccountAssignmentNumber = _POItemAcctInvoiceCalc.AccountAssignmentNumber
[0..1] P_POItemAcctMatDocCalc _POItemAcctMatDocCalc $projection.PurchaseOrder = _POItemAcctMatDocCalc.PurchaseOrder and $projection.PurchaseOrderItem = _POItemAcctMatDocCalc.PurchaseOrderItem and ( $projection.AccountAssignmentNumber = _POItemAcctMatDocCalc.AccountAssignmentNumber or _POItemAcctMatDocCalc.AccountAssignmentNumber = '00' )

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
OrderQuantityUnit OrderQuantityUnit Sales Unit
Quantity Quantity Value
_TotalGrInvQty _TotalGrInvQty
_POItemAcctMatDocCalc _POItemAcctMatDocCalc
_POItemAcctInvoiceCalc _POItemAcctInvoiceCalc

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_POItemAcctInvoiceTotalCalc.
-- 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.

CREATE VIEW P_POItemAcctInvoiceTotalCalc AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  OrderQuantityUnit,
  Quantity
FROM I_PurOrdAccountAssignment
LEFT OUTER JOIN P_TotalGrInvQty AS _TotalGrInvQty ON PurchaseOrder = _TotalGrInvQty.PurchaseOrder AND PurchaseOrderItem = _TotalGrInvQty.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN P_POItemAcctInvoiceCalc AS _POItemAcctInvoiceCalc ON PurchaseOrder = _POItemAcctInvoiceCalc.PurchaseOrder AND PurchaseOrderItem = _POItemAcctInvoiceCalc.PurchaseOrderItem AND AccountAssignmentNumber = _POItemAcctInvoiceCalc.AccountAssignmentNumber  -- association [0..1]
LEFT OUTER JOIN P_POItemAcctMatDocCalc AS _POItemAcctMatDocCalc ON PurchaseOrder = _POItemAcctMatDocCalc.PurchaseOrder AND PurchaseOrderItem = _POItemAcctMatDocCalc.PurchaseOrderItem AND ( AccountAssignmentNumber = _POItemAcctMatDocCalc.AccountAssignmentNumber OR _POItemAcctMatDocCalc.AccountAssignmentNumber = '00' )  -- association [0..1]
;

Learn More