C_MassUpdtPurchasingDocPart

DDL: C_MASSUPDTPURCHASINGDOCPART SQL: CPURDOCPARTNER Type: view CONSUMPTION Package: ODATA_MM_PUR_SCHAGTMASS_UPDATE
21 Fields 1 Data Sources 1 OData Services

Purchase Contract Partner

C_MassUpdtPurchasingDocPart is a Consumption CDS View that provides data about "Purchase Contract Partner" in SAP S/4HANA. It reads from 1 data source (I_Purctrpartners) and exposes 21 fields with key fields PurchaseContract, PurchaseContractItem, PurchasingOrganization, SupplierSubrange, Plant. It is exposed through 1 OData service (ASQL_F2669). Part of development package ODATA_MM_PUR_SCHAGTMASS_UPDATE.

Data Sources (1)

SourceAliasJoin Type
I_Purctrpartners I_Purctrpartners from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPURDOCPARTNER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract Partner view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2669 ASQL_F2669 C2 NOT_RELEASED

Fields (21)

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 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
ReferenceSupplier Supplier Supplier
PreferredSupplierName _Supplier SupplierName Supplier Name
SupplierContact SupplierContact Contact Person
EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
DefaultPartner DefaultPartner Default Partner
PurchasingDocumentPartner PurchasingDocumentPartner Partner
PurchasingDocumentPartnerName PurchasingDocumentPartnerName Partner Name
PartnerFunctionName
_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 C_MassUpdtPurchasingDocPart.
-- 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.
-- SQL view name: CPURDOCPARTNER

CREATE VIEW C_MassUpdtPurchasingDocPart AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchasingOrganization,
  SupplierSubrange,
  Plant,
  PartnerFunction,
  PartnerCounter,
  PurchasingDocumentCategory,
  PurchaseContractType,
  PurchasingDocumentType,
  CreatedByUser,
  CreationDate,
  Supplier AS ReferenceSupplier,
  _Supplier.SupplierName AS PreferredSupplierName,
  SupplierContact,
  EmploymentInternalID,
  DefaultPartner,
  PurchasingDocumentPartner,
  PurchasingDocumentPartnerName,
  _PartnerFunctionText[ 1:Language = $session.system_language ].PartnerFunctionName AS PartnerFunctionName
FROM I_Purctrpartners
;

Learn More