P_PurOrdMaintainHeaderActCalFs

DDL: P_PURORDMAINTAINHEADERACTCALFS SQL: PPOMAINTHDRACTCF Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN

PO Maintenance: Calculated fields of Purchase Order Header

P_PurOrdMaintainHeaderActCalFs is a Consumption CDS View that provides data about "PO Maintenance: Calculated fields of Purchase Order Header" in SAP S/4HANA. It reads from 1 data source (P_PurOrdMaintainHdrActCalFsHlp) and exposes 4 fields with key field PurchaseOrder. It has 1 association to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
P_PurOrdMaintainHdrActCalFsHlp calc_fields from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderStatus hdr_status calc_fields.PurchaseOrder = hdr_status.PurchaseOrder

Annotations (4)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.sqlViewName PPOMAINTHDRACTCF view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder P_PurOrdMaintainHdrActCalFsHlp PurchaseOrder
NetValue P_PurOrdMaintainHdrActCalFsHlp NetValue
NumberOfItems P_PurOrdMaintainHdrActCalFsHlp NumberOfItems
PurchasingDocumentStatus hdr_status PurchasingDocumentStatus
// =========================================================================

//   PO Maintenance: Calculated fields of Purchase Order Header

// =========================================================================


@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.sqlViewName: 'PPOMAINTHDRACTCF'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

define view P_PurOrdMaintainHeaderActCalFs
  as select from P_PurOrdMaintainHdrActCalFsHlp as calc_fields
  association [1..1] to I_PurchaseOrderStatus   as hdr_status on calc_fields.PurchaseOrder = hdr_status.PurchaseOrder
{
  key calc_fields.PurchaseOrder           as PurchaseOrder,
      calc_fields.NetValue                as NetValue,
      calc_fields.NumberOfItems           as NumberOfItems, //TO CLARIFY: Do we have to exclude deleted/statistical/return items???

      hdr_status.PurchasingDocumentStatus as PurchasingDocumentStatus
}