P_PurReqnSuccssrDocs

DDL: P_PURREQNSUCCSSRDOCS SQL: PPURREQNSRDOC Type: view COMPOSITE
9 Fields 2 Data Sources

P_PurReqnSuccssrDocs is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentItem, I_PurgDocScheduleLine) and exposes 9 fields with key fields PurchasingDocument, PurchasingDocumentItem, PurchasingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentItem _purgAgrmt from
I_PurgDocScheduleLine _schedgLine union_all

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PPURREQNSRDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurchaseRequisition I_PurchasingDocumentItem PurchaseRequisition Requisition
PurchaseRequisitionItem I_PurchasingDocumentItem PurchaseRequisitionItem Requisn. item
PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurgDocScheduleLine PurchasingDocumentItem Purchasing Doc. Item
PurchaseRequisition I_PurgDocScheduleLine PurchaseRequisition Requisition
PurchaseRequisitionItem I_PurgDocScheduleLine PurchaseRequisitionItem Requisn. item
PurchasingDocumentCategory _purgDoc PurchasingDocumentCategory Doc. Category

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_PurReqnSuccssrDocs.
-- 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: PPURREQNSRDOC

CREATE VIEW P_PurReqnSuccssrDocs AS
SELECT
  _purgAgrmt.PurchasingDocument AS PurchasingDocument,
  _purgAgrmt.PurchasingDocumentItem AS PurchasingDocumentItem,
  _purgAgrmt.PurchaseRequisition AS PurchaseRequisition,
  _purgAgrmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _purgDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory
FROM I_PurchasingDocumentItem AS _purgAgrmt
-- UNION ALL with additional select branch(es): I_PurgDocScheduleLine
;

Learn More