I_KW_PurchaseOrderTotalAmount

DDL: I_KW_PURCHASEORDERTOTALAMOUNT Type: view_entity COMPOSITE
9 Fields 2 Data Sources 3 Associations

Purchase Order Total Net Amount

I_KW_PurchaseOrderTotalAmount is a Composite CDS View that provides data about "Purchase Order Total Net Amount" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocument, I_PurchaseOrderItem) and exposes 9 fields with key field PurchasingDocument. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocument _PurHeader from
I_PurchaseOrderItem _PurItems inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocument _PurchaseHeader $projection.PurchasingDocument = _PurchaseHeader.PurchasingDocument
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchase Order Total Net Amount view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocument PurchasingDocument Purchasing Document
CompanyCode I_PurchasingDocument CompanyCode Receiver Company Code
Supplier I_PurchasingDocument Supplier Supplier
PurchasingDocumentOrderDate I_PurchasingDocument PurchasingDocumentOrderDate PO Date
DocumentCurrency I_PurchaseOrderItem DocumentCurrency Document Currency
PurchaseOrderNetAmount
_PurchaseHeader _PurchaseHeader
_Supplier _Supplier
_CompanyCode _CompanyCode

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_KW_PurchaseOrderTotalAmount.
-- 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 I_KW_PurchaseOrderTotalAmount AS
SELECT
  _PurHeader.PurchasingDocument AS PurchasingDocument,
  _PurHeader.CompanyCode AS CompanyCode,
  _PurHeader.Supplier AS Supplier,
  _PurHeader.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  _PurItems.DocumentCurrency AS DocumentCurrency,
  sum( _PurItems.NetAmount ) AS PurchaseOrderNetAmount
FROM I_PurchasingDocument AS _PurHeader
INNER JOIN I_PurchaseOrderItem AS _PurItems ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingDocument AS _PurchaseHeader ON PurchasingDocument = _PurchaseHeader.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More