P_PurchOrdReleased

DDL: P_PURCHORDRELEASED SQL: PPURCHORDREL Type: view CONSUMPTION

Purchase Order Items released

P_PurchOrdReleased is a Consumption CDS View that provides data about "Purchase Order Items released" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 13 fields with key fields PurchaseOrder, PurchaseOrderItem.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPURCHORDREL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchase Order Items released view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
PurchasingInfoRecord PurchasingInfoRecord
PurchaseContract PurchaseContract
DocumentCurrency DocumentCurrency
NetAmount NetAmount
Plant Plant
PurchasingGroup _PurchaseOrder PurchasingGroup
PurchasingOrganization _PurchaseOrder PurchasingOrganization
CompanyCode _PurchaseOrder CompanyCode
PurchaseOrderDate _PurchaseOrder PurchaseOrderDate
PurchaseOrderType _PurchaseOrder PurchaseOrderType
_PurchaseOrder _PurchaseOrder 
@AbapCatalog.sqlViewName: 'PPURCHORDREL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Purchase Order Items released'
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_PurchOrdReleased as select from I_PurchaseOrderItem {

  @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchaseOrder,
  key PurchaseOrderItem,
  PurchasingInfoRecord,
  PurchaseContract,
  DocumentCurrency,
  NetAmount,
  Plant,
  _PurchaseOrder.PurchasingGroup,
  _PurchaseOrder.PurchasingOrganization,
  _PurchaseOrder.CompanyCode,
  _PurchaseOrder.PurchaseOrderDate,
  _PurchaseOrder.PurchaseOrderType,
  _PurchaseOrder
  
}
where _PurchaseOrder.PurchasingDocumentDeletionCode = ''
  and _PurchaseOrder.ReleaseIsNotCompleted          = ''
  and _PurchaseOrder.PurchasingCompletenessStatus   = ''
  and PurchasingDocumentDeletionCode                = ''

Learn More