P_GoodsIssueQuantity

DDL: P_GOODSISSUEQUANTITY SQL: PGOODSISSUE Type: view CONSUMPTION
7 Fields 1 Associations

Goods Issue Quantity

P_GoodsIssueQuantity is a Consumption CDS View that provides data about "Goods Issue Quantity" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SubcontractingComponent _SubcontractingComponent $projection.PurchasingDocument = _SubcontractingComponent.PurchasingDocument and $projection.PurchasingDocumentItem = _SubcontractingComponent.PurchasingDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PGOODSISSUE view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Goods Issue Quantity view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchaseOrder Purchasing Document
KEY PurchasingDocumentItem PurchaseOrderItem Purchasing Document Item
KEY Material Material Vehicle Model
KEY Supplier Supplier Supplier
KEY Plant Plant Valuation Area
KEY ScheduleLine _SubcontractingComponent ScheduleLine Schedule Line
TotalGIPerPO

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_GoodsIssueQuantity.
-- 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: PGOODSISSUE

CREATE VIEW P_GoodsIssueQuantity AS
SELECT
  PurchaseOrder AS PurchasingDocument,
  PurchaseOrderItem AS PurchasingDocumentItem,
  Material,
  Supplier,
  Plant,
  _SubcontractingComponent.ScheduleLine AS ScheduleLine,
  sum(QuantityInBaseUnit) AS TotalGIPerPO
LEFT OUTER JOIN I_SubcontractingComponent AS _SubcontractingComponent ON PurchasingDocument = _SubcontractingComponent.PurchasingDocument AND PurchasingDocumentItem = _SubcontractingComponent.PurchasingDocumentItem  -- association [1..1]
;

Learn More