R_PPS_PurContrPendingNovation

DDL: R_PPS_PURCONTRPENDINGNOVATION Type: view_entity COMPOSITE
14 Fields 1 Data Sources 1 Associations

Purchase Contract Pending for Novation

R_PPS_PurContrPendingNovation is a Composite CDS View that provides data about "Purchase Contract Pending for Novation" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurchaseContract) and exposes 14 fields with key field PPSPurgDocNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurchaseContract purchasecontract from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderNetAmount _PurchaseOrderNetAmount _PurchaseOrderNetAmount.PurchaseOrder = $projection.PPSPurgDocNumber

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Purchase Contract Pending for Novation view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PPSPurgDocNumber I_PPS_PurchaseContract PurchaseContract Purchasing Doc.
PurchasingDocumentCategory I_PPS_PurchaseContract PurchasingDocumentCategory Doc. Category
PurchasingDocumentType I_PPS_PurchaseContract PurchasingDocumentType RFQ Type
CompanyCode I_PPS_PurchaseContract CompanyCode Receiver Company Code
Supplier I_PPS_PurchaseContract Supplier Supplier
PurchasingOrganization I_PPS_PurchaseContract PurchasingOrganization Purchasing Organization
PurchasingGroup I_PPS_PurchaseContract PurchasingGroup Purchasing Group
DocumentCurrency I_PPS_PurchaseContract DocumentCurrency Document Currency
_PurchasingDocumentCategory I_PPS_PurchaseContract _PurchasingDocumentCategory
PPSPurOrderHeaderStatus
PPSSmartDocumentNumber
PurchasingDocumentDescription I_PPS_PurchaseContract PurchasingDocumentName Purch. Doc. Name
PurchaseContractTargetAmount I_PPS_PurchaseContract TargetAmount Target Value
_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_PurContrPendingNovation.
-- 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_PurContrPendingNovation AS
SELECT
  purchasecontract.PurchaseContract AS PPSPurgDocNumber,
  purchasecontract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  purchasecontract.PurchasingDocumentType AS PurchasingDocumentType,
  purchasecontract.CompanyCode AS CompanyCode,
  purchasecontract.Supplier AS Supplier,
  purchasecontract.PurchasingOrganization AS PurchasingOrganization,
  purchasecontract.PurchasingGroup AS PurchasingGroup,
  purchasecontract.DocumentCurrency AS DocumentCurrency,
  purchasecontract._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  purchasecontract._Extension.PPSPurOrderHeaderStatus AS PPSPurOrderHeaderStatus,
  purchasecontract._Extension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  purchasecontract.PurchasingDocumentName AS PurchasingDocumentDescription,
  purchasecontract.TargetAmount AS PurchaseContractTargetAmount
FROM I_PPS_PurchaseContract AS purchasecontract
LEFT OUTER JOIN I_PurchaseOrderNetAmount AS _PurchaseOrderNetAmount ON _PurchaseOrderNetAmount.PurchaseOrder = PPSPurgDocNumber  -- association [1..1]
;

Learn More