I_PPS_PurchaseReqnHeader

DDL: I_PPS_PURCHASEREQNHEADER Type: view_entity COMPOSITE
9 Fields 2 Data Sources

Purchase Requisition Header

I_PPS_PurchaseReqnHeader is a Composite CDS View that provides data about "Purchase Requisition Header" in SAP S/4HANA. It reads from 2 data sources (I_PPS_PurchaseReqnDocumentType, I_PurchaseRequisitionItemBasic) and exposes 9 fields with key field PurchaseRequisition.

Data Sources (2)

SourceAliasJoin Type
I_PPS_PurchaseReqnDocumentType _PurchaseRequisitionDocType inner
I_PurchaseRequisitionItemBasic PurchaseRequisition from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Purchase Requisition Header view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_PurchaseRequisitionItemBasic PurchaseRequisition Requisition
PurReqnDescription I_PurchaseRequisitionItemBasic PurReqnDescription PurReqn Description
PurchasingDocumentCategory I_PurchaseRequisitionItemBasic PurchasingDocumentCategory Doc. Category
PurchaseRequisitionType I_PurchaseRequisitionItemBasic PurchaseRequisitionType Order Type
PurchasingDocumentSubtype I_PurchaseRequisitionItemBasic PurchasingDocumentSubtype Control
PurchasingDocumentTypeName I_PPS_PurchaseReqnDocumentType PurchasingDocumentTypeName Description
LastChangeDateTime
IsPurReqnOvrlRel I_PurchaseRequisitionItemBasic IsPurReqnOvrlRel Overall req. rel.
_PurchaseRequisition I_PurchaseRequisitionItemBasic _PurchaseRequisition

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 I_PPS_PurchaseReqnHeader.
-- 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.

CREATE VIEW I_PPS_PurchaseReqnHeader AS
SELECT
  PurchaseRequisition.PurchaseRequisition AS PurchaseRequisition,
  PurchaseRequisition.PurReqnDescription AS PurReqnDescription,
  PurchaseRequisition.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseRequisition.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchaseRequisition.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchaseRequisitionDocType.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  max( PurchaseRequisition.LastChangeDateTime ) AS LastChangeDateTime,
  PurchaseRequisition.IsPurReqnOvrlRel AS IsPurReqnOvrlRel,
  PurchaseRequisition._PurchaseRequisition AS _PurchaseRequisition
FROM I_PurchaseRequisitionItemBasic AS PurchaseRequisition
INNER JOIN I_PPS_PurchaseReqnDocumentType AS _PurchaseRequisitionDocType ON /* join condition not captured in parsed metadata */
;

Learn More