P_VarConfignPurchaseReqnItem

DDL: P_VARCONFIGNPURCHASEREQNITEM SQL: PAVCPURGREQNITM Type: view BASIC

P_VarConfignPurchaseReqnItem is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (eban) and exposes 13 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
eban eban from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PAVCPURGREQNITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition banfn
KEY PurchaseRequisitionItem bnfpo
Product matnr
Plant werks
ProductConfiguration cuobj
CreatedByUser ernam
CreationDate badat
LastChangedByUser ernam
OrderQuantity bsmng
OrderQuantityUnit meins
PurchaseRequisitionType bsart
PurchasingOrganization ekorg
PurchasingGroup ekgrp 
@AbapCatalog.sqlViewName: 'PAVCPURGREQNITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@VDM.private: true
define view P_VarConfignPurchaseReqnItem
  as select from eban
{
  key banfn                                                        as  PurchaseRequisition,
  key bnfpo                                                        as  PurchaseRequisitionItem,

      matnr                                                        as  Product,
      werks                                                        as  Plant,
      cuobj                                                        as  ProductConfiguration,

      ernam                                                        as  CreatedByUser,
      badat                                                        as  CreationDate,
      ernam                                                        as  LastChangedByUser,
      case
      when  erdat = '00000000'
      or  erdat is null
      then  badat
      else erdat
      end                                                          as  LastChangeDate,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      bsmng                                                        as  OrderQuantity,
      @Semantics.unitOfMeasure: true
      meins                                                        as  OrderQuantityUnit,
      
      //needed for authorization

      bsart                                                        as  PurchaseRequisitionType,
      ekorg                                                        as  PurchasingOrganization,
      ekgrp                                                        as  PurchasingGroup
}
//Only configured Purchasing Document Items are relevant

where
      cuobj != '000000000000000000'
  and loekz        = '' //Deletion marker

  and iseopblocked = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EBAN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More