I_GdsRecGdsIssdTotQtyForPO

DDL: I_GDSRECGDSISSDTOTQTYFORPO SQL: IGRGITOTQTY Type: view COMPOSITE
5 Fields 2 Data Sources

Total Quantities of GI and GR

I_GdsRecGdsIssdTotQtyForPO is a Composite CDS View that provides data about "Total Quantities of GI and GR" in SAP S/4HANA. It reads from 2 data sources (P_GdsIssdTotQtyForPO, P_GdsRecTotQtyForPO) and exposes 5 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (2)

SourceAliasJoin Type
P_GdsIssdTotQtyForPO _GoodsIssueData left_outer
P_GdsRecTotQtyForPO _GoodsReceiptData left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IGRGITOTQTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Total Quantities of GI and GR view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private false view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder purchaseOrders PurchaseOrder Purchasing Document
KEY PurchaseOrderItem purchaseOrders PurchaseOrderItem Purchasing Document Item
PurchaseOrderItemQuantity PurchaseOrderItemQuantity
TotalGoodsIssuedForPOQty
TotalGoodsReceiptForPOQty

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_GdsRecGdsIssdTotQtyForPO.
-- 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: IGRGITOTQTY

CREATE VIEW I_GdsRecGdsIssdTotQtyForPO AS
SELECT
  purchaseOrders.PurchaseOrder AS PurchaseOrder,
  purchaseOrders.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItemQuantity,
  cast( _GoodsIssueData.TotalGoodsIssuedForPOQty as mmim_total_goodsissued_qty_po) AS TotalGoodsIssuedForPOQty,
  cast( _GoodsReceiptData.TotalGoodsReceiptForPOQty as mmim_total_goodsreceipt_qty_po) AS TotalGoodsReceiptForPOQty
LEFT OUTER JOIN P_GdsRecTotQtyForPO AS _GoodsReceiptData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GdsIssdTotQtyForPO AS _GoodsIssueData ON /* join condition not captured in parsed metadata */
;

Learn More