R_PPS_PurOrdForCloseout

DDL: R_PPS_PURORDFORCLOSEOUT Type: view_entity COMPOSITE
27 Fields 1 Data Sources 3 Associations

Process Purchase Order Closeout

R_PPS_PurOrdForCloseout is a Composite CDS View that provides data about "Process Purchase Order Closeout" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurOrdForCloseout) and exposes 27 fields with key field PurchaseOrder. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurOrdForCloseout PurchaseOrder from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PPS_PurOrdWorkflowDetail _WorkflowDetail $projection.PurchaseOrder = _WorkflowDetail.PurchasingDocument
[1..1] R_PPS_PurOrderHeaderExtension _PurchaseOrderHeaderExtension $projection.PurchaseOrder = _PurchaseOrderHeaderExtension.PurchaseOrder
[1..1] I_PurchaseOrderNetAmount _PurchaseOrderNetAmount _PurchaseOrderNetAmount.PurchaseOrder = $projection.PurchaseOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Process Purchase Order Closeout view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PPS_PurOrdForCloseout PurchaseOrder Purchasing Document
ActivePurchasingDocument
PurchaseOrderType I_PPS_PurOrdForCloseout PurchaseOrderType PO Type
PurchasingDocumentCategory I_PPS_PurOrdForCloseout PurchasingDocumentCategory Doc. Category
Supplier I_PPS_PurOrdForCloseout Supplier Supplier
CompanyCode I_PPS_PurOrdForCloseout CompanyCode Receiver Company Code
PurchasingOrganization I_PPS_PurOrdForCloseout PurchasingOrganization Purchasing Organization
PurchasingGroup I_PPS_PurOrdForCloseout PurchasingGroup Purchasing Group
PurchasingProcessingStatus I_PPS_PurOrdForCloseout PurchasingProcessingStatus Proc. State
CreatedByUser I_PPS_PurOrdForCloseout CreatedByUser User Name
CreationDate I_PPS_PurOrdForCloseout CreationDate Time Stamp
IncotermsClassification I_PPS_PurOrdForCloseout IncotermsClassification Incoterms
PurchasingDocumentName I_PPS_PurOrdForCloseout PurchasingDocumentName Purch. Doc. Name
DocumentCurrency I_PPS_PurOrdForCloseout DocumentCurrency Document Currency
PPSSmartNumberHeader _PurchaseOrderHeaderExtension PPSSmartNumberHeader Smart Number
PPSSmartDocumentNumber _PurchaseOrderHeaderExtension PPSSmartDocumentNumber Smart Doc Number
PPSRevisionComment _PurchaseOrderHeaderExtension PPSRevisionComment Reason Text
PPSPerdOfPerfStartDate _PurchaseOrderHeaderExtension PPSPerdOfPerfStartDate PeROP Start Date
PPSPerdOfPerfEndDate _PurchaseOrderHeaderExtension PPSPerdOfPerfEndDate PeROP End Date
PPSPurgDocClassfctnCode _PurchaseOrderHeaderExtension PPSPurgDocClassfctnCode Doc Confidential
PPSPurOrderHeaderStatus _PurchaseOrderHeaderExtension PPSPurOrderHeaderStatus Status
PPSPurgDocHdrCloseoutStatus _PurchaseOrderHeaderExtension PPSPurgDocHdrCloseoutStatus
PPSFiscalYear _PurchaseOrderHeaderExtension PPSFiscalYear Fiscal Year
_PurchaseOrderHeaderExtension _PurchaseOrderHeaderExtension
_CreatedByUser I_PPS_PurOrdForCloseout _CreatedByUser
_WorkflowDetail _WorkflowDetail
_PurchaseOrderNetAmount _PurchaseOrderNetAmount

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 R_PPS_PurOrdForCloseout.
-- 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 R_PPS_PurOrdForCloseout AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  cast(PurchaseOrder.ActivePurchasingDocument as pps_e_active_po_doc preserving type ) AS ActivePurchasingDocument,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrder.CreationDate AS CreationDate,
  PurchaseOrder.IncotermsClassification AS IncotermsClassification,
  PurchaseOrder.PurchasingDocumentName AS PurchasingDocumentName,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrderHeaderExtension.PPSSmartNumberHeader AS PPSSmartNumberHeader,
  _PurchaseOrderHeaderExtension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  _PurchaseOrderHeaderExtension.PPSRevisionComment AS PPSRevisionComment,
  _PurchaseOrderHeaderExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurchaseOrderHeaderExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  _PurchaseOrderHeaderExtension.PPSPurgDocClassfctnCode AS PPSPurgDocClassfctnCode,
  _PurchaseOrderHeaderExtension.PPSPurOrderHeaderStatus AS PPSPurOrderHeaderStatus,
  _PurchaseOrderHeaderExtension.PPSPurgDocHdrCloseoutStatus AS PPSPurgDocHdrCloseoutStatus,
  _PurchaseOrderHeaderExtension.PPSFiscalYear AS PPSFiscalYear,
  PurchaseOrder._CreatedByUser AS _CreatedByUser
FROM I_PPS_PurOrdForCloseout AS PurchaseOrder
LEFT OUTER JOIN I_PPS_PurOrdWorkflowDetail AS _WorkflowDetail ON PurchaseOrder = _WorkflowDetail.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurOrderHeaderExtension AS _PurchaseOrderHeaderExtension ON PurchaseOrder = _PurchaseOrderHeaderExtension.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderNetAmount AS _PurchaseOrderNetAmount ON _PurchaseOrderNetAmount.PurchaseOrder = PurchaseOrder  -- association [1..1]
;

Learn More