I_CentralPurchaseContractBasic

DDL: I_CENTRALPURCHASECONTRACTBASIC Type: view_entity BASIC
33 Fields 1 Data Sources 1 Associations

Central Purchase Contract

I_CentralPurchaseContractBasic (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_CentralPurchaseContractBasic is a Basic CDS View that provides data about "Central Purchase Contract" in SAP S/4HANA. It reads from 1 data source (R_CentralPurchaseContract) and exposes 33 fields with key field CentralPurchaseContract. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Central Purchase Contracts
Purpose
This CDS view provides general information about the header of a central purchase contract. This CDS view provides the data to answer the following business questions: Who is the supplier for a particular central purchase contract? What is the central purchasing organization, central purchasing group, and central company code associated with a central purchase contract? What are the payment terms and incoterms for a central purchase contract? What is the central purchase contract number? What is the central purchase contract type? When was the central purchase contract created? What is the period for which the central purchase contract is valid? What is the release status of the central purchase contract? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: SAP_BR_CENTRAL_PURCHASER (Central Purchaser)

Structure
Important Fields Important fields in this view include the following: Field Name Description CENTRALPURCHASECONTRACT Central Purchase Contract PURCHASECONTRACTTYPE Purchasing Document Type PURCHASINGDOCUMENTCATEGORY Purchasing Document Category SUPPLIER Supplier COMPANYCODE Company Code PURCHASINGORGANIZATION Purchasing Organization PURCHASINGGROUP Purchasing Group

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-HUB-CTR
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides general information about the header of a central purchase contract.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Who is the supplier for a particular central purchase contract?</p></li> <li><p>What is the central purchasing organization, central purchasing group, and central company code associated with a central purchase contract?</p></li> <li><p>What are the payment terms and incoterms for a central purchase contract?</p></li> <li><p>What is the central purchase contract number? </p></li> <li><p>What is the central purchase contract type?</p></li> <li><p>When was the central purchase contract created?</p></li> <li><p>What is the period for which the central purchase contract is valid?</p></li> <li><p>What is the release status of the central purchase contract?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_CentralPurchaseContract CentralPurchaseContract from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_CntrlPurContractItemBasic _CentralPurchaseContractItem $projection.CentralPurchaseContract = _CentralPurchaseContractItem.CentralPurchaseContract

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Central Purchase Contract view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract Central Purchase Contract
PurchaseContractType PurchaseContractType Purchasing Document Type
PurchasingDocumentCategory PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentSubtype PurchasingDocumentSubtype Control indicator for purchasing document type
Supplier Supplier Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingDocumentName PurchasingDocumentName Name of Purchasing Document
ValidityStartDate ValidityStartDate Start of Validity Period
ValidityEndDate ValidityEndDate End of Validity Period
DocumentCurrency DocumentCurrency Document Currency
PurchaseContractTargetAmount PurchaseContractTargetAmount Target Value for Header Area per Distribution
LastChangeDateTime LastChangeDateTime Change Time Stamp
CreationDate CreationDate Creation Date of Purchasing Document
CreatedByUser CreatedByUser User of person who created a purchasing document
ReleaseCode ReleaseCode Release Indicator: Purchasing Document
PaymentTerms PaymentTerms Terms of Payment Key
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
CashDiscount1Percent CashDiscount1Percent Cash Discount Percentage 1
CashDiscount2Percent CashDiscount2Percent Cash Discount Percentage 2
NetPaymentDays NetPaymentDays Net Payment Terms Period
IncotermsClassification IncotermsClassification Incoterms (Part 1)
IncotermsTransferLocation IncotermsTransferLocation Incoterms (Part 2)
IncotermsVersion IncotermsVersion Incoterms Version
IncotermsLocation1 IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 IncotermsLocation2 Incoterms Location 2
ExchangeRateIsFixed ExchangeRateIsFixed Indicator for Fixed Exchange Rate
PurgDocChangeRequestStatus PurgDocChangeRequestStatus Change Request Status
PurgDocIsChgVers PurgDocIsChgVers Checkbox
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document
_CentralPurchaseContractItem _CentralPurchaseContractItem

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 I_CentralPurchaseContractBasic.
-- 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 I_CentralPurchaseContractBasic AS
SELECT
  cast (ActivePurchasingDocument as vdm_centralpurchasecontract preserving type) AS CentralPurchaseContract,
  PurchaseContractType,
  PurchasingDocumentCategory,
  PurchasingDocumentSubtype,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingDocumentName,
  ValidityStartDate,
  ValidityEndDate,
  DocumentCurrency,
  PurchaseContractTargetAmount,
  LastChangeDateTime,
  CreationDate,
  CreatedByUser,
  ReleaseCode,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  ExchangeRateIsFixed,
  PurgDocChangeRequestStatus,
  PurgDocIsChgVers,
  PurchasingDocumentDeletionCode
FROM R_CentralPurchaseContract AS CentralPurchaseContract
LEFT OUTER JOIN I_CntrlPurContractItemBasic AS _CentralPurchaseContractItem ON CentralPurchaseContract = _CentralPurchaseContractItem.CentralPurchaseContract  -- association [1..*]
;

Learn More