P_VARCONFIGNPURCHASEREQNITEM

CDS View

P_VARCONFIGNPURCHASEREQNITEM is a CDS View in S/4HANA. It contains 10 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 10 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SimulationObjectSearch view left_outer CONSUMPTION
P_SimulationObjectUnion view union_all CONSUMPTION

Fields (10)

KeyField CDS FieldsUsed in Views
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Plant Plant 1
Product Product 1
ProductConfiguration ProductConfiguration 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchaseRequisitionType PurchaseRequisitionType 1 
@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