R_PPS_PurOrdHdrNvtnPrtnDraft

DDL: R_PPS_PURORDHDRNVTNPRTNDRAFT Type: view_entity BASIC
27 Fields 1 Data Sources 1 Associations

Purchase Order Novation Partner - Draft

R_PPS_PurOrdHdrNvtnPrtnDraft is a Basic CDS View that provides data about "Purchase Order Novation Partner - Draft" in SAP S/4HANA. It reads from 1 data source (pps_po_prtnext_d) and exposes 27 fields with key fields PurchasingDocument, PurchasingDocumentItem, PartnerFunction, PartnerCounter, ContactPerson. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
pps_po_prtnext_d pps_po_prtnext_d from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_PPS_PurchaseOrderDraft _PurchaseOrd $projection.PurchasingDocument = _PurchaseOrd.PurchaseOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Order Novation Partner - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument purchasingdocument Purchasing Document
KEY PurchasingDocumentItem purchasingdocumentitem Purchasing Doc. Item
KEY PartnerFunction partnerfunction Partner Functn
KEY PartnerCounter partnercounter Partner counter
KEY ContactPerson contactperson Contact Person Key
KEY Supplier supplier Supplier
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
ReferenceSupplier Ref. to suplr
DefaultPartner defaultpartner Default Partner
SupplierHierarchyCategory supplierhierarchycategory Hierarchy Cat.
PPSPurgDocPartnerValidFromDate ppspurgdocpartnervalidfromdate
PPSPurgDocPartnerValidToDate ppspurgdocpartnervalidtodate
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
LastChangedDate lastchangeddate Created On
LastChangedByUser lastchangedbyuser User Name
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
SupplierName suppliername Supplier Name
PartnerFunctionName partnerfunctionname Name
PartnerFunctionLanguageDepdnt partnerfunctionlanguagedepdnt Lang-spec.partr
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_PurchaseOrd _PurchaseOrd

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_PurOrdHdrNvtnPrtnDraft.
-- 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_PurOrdHdrNvtnPrtnDraft AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  PartnerFunction,
  PartnerCounter,
  ContactPerson,
  Supplier,
  DraftUUID,
  ParentDraftUUID,
  cast(referencesupplier as pps_e_new_lifnr preserving type ) AS ReferenceSupplier,
  DefaultPartner,
  SupplierHierarchyCategory,
  PPSPurgDocPartnerValidFromDate,
  PPSPurgDocPartnerValidToDate,
  CreatedByUser,
  CreationDate,
  LastChangedDate,
  LastChangedByUser,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  SupplierName,
  PartnerFunctionName,
  PartnerFunctionLanguageDepdnt,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM pps_po_prtnext_d
LEFT OUTER JOIN R_PPS_PurchaseOrderDraft AS _PurchaseOrd ON PurchasingDocument = _PurchaseOrd.PurchaseOrder  -- association [0..*]
;

Learn More