R_PurContrPartnersTP

DDL: R_PURCONTRPARTNERSTP Type: view_entity TRANSACTIONAL
20 Fields 1 Data Sources

Purchase Contract Partners

R_PurContrPartnersTP is a Transactional CDS View that provides data about "Purchase Contract Partners" in SAP S/4HANA. It reads from 1 data source (I_Purctrpartners) and exposes 20 fields with key fields PurchaseContract, PurchaseContractItem, PurchasingOrganization, SupplierSubrange, Plant.

Data Sources (1)

SourceAliasJoin Type
I_Purctrpartners I_Purctrpartners from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Contract Partners view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY SupplierSubrange SupplierSubrange Suppl. Subrange
KEY Plant Plant Valuation Area
KEY PartnerFunction Partner Functn
KEY PartnerCounter PartnerCounter Partner counter
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseContractType PurchaseContractType Order Type
PurchasingDocumentType PurchasingDocumentType RFQ Type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
SupplierContact SupplierContact Contact Person
EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
DefaultPartner DefaultPartner Default Partner
PurchasingDocumentPartner PurchasingDocumentPartner Partner
PurchasingDocumentPartnerName PurchasingDocumentPartnerName Partner Name
LastChangeDateTime _PurchaseContract LastChangeDateTime Timestamp
_PurchaseContract _PurchaseContract

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_PurContrPartnersTP.
-- 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_PurContrPartnersTP AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchasingOrganization,
  SupplierSubrange,
  Plant,
  cast( PartnerFunction as parvw_unv ) AS PartnerFunction,
  PartnerCounter,
  PurchasingDocumentCategory,
  PurchaseContractType,
  PurchasingDocumentType,
  CreatedByUser,
  CreationDate,
  Supplier,
  SupplierContact,
  EmploymentInternalID,
  DefaultPartner,
  PurchasingDocumentPartner,
  PurchasingDocumentPartnerName,
  _PurchaseContract.LastChangeDateTime AS LastChangeDateTime
FROM I_Purctrpartners
;

Learn More