I_CentralPurchaseContractAPI01

DDL: I_CENTRALPURCHASECONTRACTAPI01 SQL: ICNTRLPCTRHAPI01 Type: view COMPOSITE
48 Fields 1 Data Sources 2 Associations

Central Purchase Contract

I_CentralPurchaseContractAPI01 (Composite)

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

Sourcing & Procurement

I_CentralPurchaseContractAPI01 is a Composite CDS View that provides data about "Central Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_CentralPurchaseContract) and exposes 48 fields with key field CentralPurchaseContract. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Central Purchase Contracts
StatusReleased
Purpose
This CDS view provides general information about the central purchase contract. This CDS view provides the prerequisites for answering 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?

Prerequisites
You must have a role based on the SAP_BR_CENTRAL_PURCHASER business role template.

Structure
Object types This view relates to the following SAP object types: I_CentralPurchaseContractAPI01 Measures and attributes Some important measures and attributes are: Central Purchase Contract Central Purchasing Organization Central Purchasing Group Release Code Central Company Code

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-HUB-CTR
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides general information about the central purchase contract.</p> <p>This CDS view provides the prerequisites for answering 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>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_CentralPurchaseContract I_CentralPurchaseContract from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_CntrlPurContractItemAPI01 _CentralPurchaseContractItem $projection.CentralPurchaseContract = _CentralPurchaseContractItem.CentralPurchaseContract
[1..*] I_ExtendedPurgDocDistrMessages _CntrlPurContrDistrMessages $projection.CentralPurchaseContract = _CntrlPurContrDistrMessages.PurchasingDocument

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICNTRLPCTRHAPI01 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Central Purchase Contract view
AbapCatalog.preserveKey true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Central Purchase Contract
PurchaseContractType PurchaseContractType Purchasing Document Type
PurchasingDocumentCategory PurchasingDocumentCategory Purchasing Document Category
Supplier Supplier Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
ValidityStartDate ValidityStartDate Start of Validity Period
ValidityEndDate ValidityEndDate End of Validity Period
DocumentCurrency DocumentCurrency Document Currency
LastChangeDateTime LastChangeDateTime Change Time Stamp
CreationDate CreationDate Creation Date of 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
PurchaseContractTargetAmount PurchaseContractTargetAmount Target Value for Header Area per Distribution
ExchangeRate Exchange rate
PurContractExchangeRateValue Exchange rate
ExchangeRateIsFixed ExchangeRateIsFixed Indicator for Fixed Exchange Rate
SupplyingSupplier SupplyingSupplier Goods Supplier
QuotationSubmissionDate QuotationSubmissionDate Quotation Submission Date
SupplierQuotation SupplierQuotation Quotation Number
CorrespncExternalReference CorrespncExternalReference Your Reference
CorrespncInternalReference CorrespncInternalReference Our Reference
SupplierRespSalesPersonName SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office
SupplierPhoneNumber SupplierPhoneNumber Supplier's Phone Number
ReleaseCode ReleaseCode Release Indicator: Purchasing Document
CreatedByUser CreatedByUser User of person who created a purchasing document
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document
PurchasingProcessingStatus PurchasingProcessingStatus Purchasing Document Processing State
ActivePurchasingDocument ActivePurchasingDocument Active Purchasing Document
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Business Purpose Completed
PurgContractIsInPreparation Boolean Variable (X = True, - = False, Space = Unknown)
PurchasingDocumentName PurchasingDocumentName Name of Purchasing Document
PurchasingDocumentSubtype PurchasingDocumentSubtype Control indicator for purchasing document type
CntrlPurContrDistributionSts _CntrlPurContrAggrgnDistrSts CntrlPurContrDistributionSts
CntrlPurContrFlxblDistrIsAllwd CntrlPurContrFlxblDistrIsAllwd Boolean Variable (X = True, - = False, Space = Unknown)
PurgDocIsChgVers PurgDocIsChgVers Checkbox
_CentralPurchaseContractItem _CentralPurchaseContractItem
_CntrlPurContrDistrMessages _CntrlPurContrDistrMessages

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_CentralPurchaseContractAPI01.
-- 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: ICNTRLPCTRHAPI01

CREATE VIEW I_CentralPurchaseContractAPI01 AS
SELECT
  CentralPurchaseContract,
  PurchaseContractType,
  PurchasingDocumentCategory,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  ValidityStartDate,
  ValidityEndDate,
  DocumentCurrency,
  LastChangeDateTime,
  CreationDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  NetPaymentDays,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PurchaseContractTargetAmount,
  cast (ExchangeRate as abap.char(12)) AS ExchangeRate,
  cast (ExchangeRate as abap.char(12)) AS PurContractExchangeRateValue,
  ExchangeRateIsFixed,
  SupplyingSupplier,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  ReleaseCode,
  CreatedByUser,
  PurchasingDocumentDeletionCode,
  PurchasingProcessingStatus,
  ActivePurchasingDocument,
  IsEndOfPurposeBlocked,
  cast ('' as boolean) AS PurgContractIsInPreparation,
  PurchasingDocumentName,
  PurchasingDocumentSubtype,
  _CntrlPurContrAggrgnDistrSts.CntrlPurContrDistributionSts AS CntrlPurContrDistributionSts,
  CntrlPurContrFlxblDistrIsAllwd,
  PurgDocIsChgVers
FROM I_CentralPurchaseContract
LEFT OUTER JOIN I_CntrlPurContractItemAPI01 AS _CentralPurchaseContractItem ON CentralPurchaseContract = _CentralPurchaseContractItem.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_ExtendedPurgDocDistrMessages AS _CntrlPurContrDistrMessages ON CentralPurchaseContract = _CntrlPurContrDistrMessages.PurchasingDocument  -- association [1..*]
;

Learn More