P_VarConfignPurchaseReqnItem

DDL: P_VARCONFIGNPURCHASEREQNITEM SQL: PAVCPURGREQNITM Type: view BASIC
13 Fields 1 Data Sources

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.

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 Requisition
KEY PurchaseRequisitionItem bnfpo Requisn. item
Product matnr Vehicle Model
Plant werks Receiving Plant
ProductConfiguration cuobj Object Number
CreatedByUser ernam User Name
CreationDate badat Requisn Date
LastChangedByUser ernam User Name
OrderQuantity bsmng Order quantity
OrderQuantityUnit meins Valuation Unit
PurchaseRequisitionType bsart Stnd purch.ord.
PurchasingOrganization ekorg Purchasing Org.
PurchasingGroup ekgrp Sub. purchasing grp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_VarConfignPurchaseReqnItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PAVCPURGREQNITM

CREATE VIEW P_VarConfignPurchaseReqnItem AS
SELECT
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  matnr AS Product,
  werks AS Plant,
  cuobj AS ProductConfiguration,
  ernam AS CreatedByUser,
  badat AS CreationDate,
  ernam AS LastChangedByUser,
  bsmng AS OrderQuantity,
  meins AS OrderQuantityUnit,
  bsart AS PurchaseRequisitionType,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup
FROM eban
;

Learn More