P_GetGRPostingDate

DDL: P_GETGRPOSTINGDATE Type: view_entity TRANSACTIONAL Package: ODATA_MM_IM_OVERDUE_GRBLOCKED

Get GR Posting date

P_GetGRPostingDate is a Transactional CDS View that provides data about "Get GR Posting date" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderHistory) and exposes 3 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_IM_OVERDUE_GRBLOCKED.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderHistory I_PurchaseOrderHistory from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #TRANSACTIONAL view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
PostingDate 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S

@VDM.private: true
@VDM.viewType: #TRANSACTIONAL
define view entity P_GetGRPostingDate as select from I_PurchaseOrderHistory  

{
        key PurchaseOrder,
        key PurchaseOrderItem,        
        min(PostingDate) as PostingDate                 
                                         
}
      where GoodsMovementType = '103'
    
   group by PurchaseOrder, PurchaseOrderItem

Learn More