P_PurReqnItmsForConf

DDL: P_PURREQNITMSFORCONF SQL: PREQNITMSFORCNF Type: view COMPOSITE
25 Fields 1 Data Sources

P_PurReqnItmsForConf is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseRequisitionItemBasic) and exposes 25 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseRequisitionItemBasic I_PurchaseRequisitionItemBasic from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREQNITMSFORCNF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurReqnItemCurrency PurReqnItemCurrency Currency
CreatedByUser CreatedByUser User Name
PurchasingGroup PurchasingGroup Purchasing Group
CreationDate CreationDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
PurchaseRequisitionType PurchaseRequisitionType Order Type
RequestedQuantity RequestedQuantity Requested Quantity
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurReqnSSPRequestor PurReqnSSPRequestor Requestor
PurReqnSSPAuthor PurReqnSSPAuthor Author
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
ExtCompanyCodeForPurg ExtCompanyCodeForPurg Company Code
ExtPlantForPurg ExtPlantForPurg Plant
PurReqnIsValdInCntrlReqnProcg PurReqnIsValdInCntrlReqnProcg Is Central PR Procg.
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurchaseReqnItemUniqueID PurchaseReqnItemUniqueID Purch. Doc. ID
PurReqnDescription PurReqnDescription PurReqn Description
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
MaterialGroup MaterialGroup Product Group
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat

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_PurReqnItmsForConf.
-- 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: PREQNITMSFORCNF

CREATE VIEW P_PurReqnItmsForConf AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurReqnItemCurrency,
  CreatedByUser,
  PurchasingGroup,
  CreationDate,
  LastChangeDateTime,
  PurchaseRequisitionType,
  RequestedQuantity,
  PurchaseRequisitionPrice,
  Plant,
  PurchasingOrganization,
  PurReqnSSPRequestor,
  PurReqnSSPAuthor,
  ProcurementHubSourceSystem,
  ExtCompanyCodeForPurg,
  ExtPlantForPurg,
  PurReqnIsValdInCntrlReqnProcg,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurchaseReqnItemUniqueID,
  PurReqnDescription,
  PurchaseRequisitionItemText,
  MaterialGroup,
  AccountAssignmentCategory
FROM I_PurchaseRequisitionItemBasic
;

Learn More