C_PPS_PurOrderHdrNvtnPartnerTP

DDL: C_PPS_PURORDERHDRNVTNPARTNERTP Type: view_entity CONSUMPTION
18 Fields 1 Data Sources

Purchase Order Novation Partner

C_PPS_PurOrderHdrNvtnPartnerTP is a Consumption CDS View that provides data about "Purchase Order Novation Partner" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurOrderHdrNvtnPartnerTP) and exposes 18 fields with key fields PurchasingDocument, PurchasingDocumentItem, PartnerFunction, PartnerCounter, ContactPerson.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurOrderHdrNvtnPartnerTP R_PPS_PurOrderHdrNvtnPartnerTP projection

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Order Novation Partner view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey PurchasingDocument view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
Feature SW:PPS_NG_NOVATION view

Fields (18)

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
ReferenceSupplier 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
SupplierName _Supplier SupplierName Supplier Name
PartnerFunctionName
PartnerFunctionLanguageDepdnt PartnerFunctionLanguageDepdnt Lang-spec.partr

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 C_PPS_PurOrderHdrNvtnPartnerTP.
-- 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 C_PPS_PurOrderHdrNvtnPartnerTP AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  PartnerFunction,
  PartnerCounter,
  ContactPerson,
  Supplier,
  ReferenceSupplier,
  DefaultPartner,
  SupplierHierarchyCategory,
  PPSPurgDocPartnerValidFromDate,
  PPSPurgDocPartnerValidToDate,
  CreatedByUser,
  CreationDate,
  LastChangedDate,
  LastChangedByUser,
  _Supplier.SupplierName AS SupplierName,
  _PartnerFunctionText[Language = $session.system_language].PartnerFunctionName AS PartnerFunctionName,
  PartnerFunctionLanguageDepdnt
FROM R_PPS_PurOrderHdrNvtnPartnerTP
;

Learn More