C_CentralContractItemSelTP

DDL: C_CENTRALCONTRACTITEMSELTP Type: view_entity CONSUMPTION Package: APPL_MM_PUR_CTR_RENEGOTIATION
43 Fields 1 Data Sources 2 OData Services

Central Purchase Contract Selection

C_CentralContractItemSelTP is a Consumption CDS View that provides data about "Central Purchase Contract Selection" in SAP S/4HANA. It reads from 1 data source (R_CentralContractItemSelTP) and exposes 43 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem. It is exposed through 2 OData services (UI_CNTRLCONTRITMSELECT_MANAGE, UI_PURCONTRRENEGTTN_MANAGE). Part of development package APPL_MM_PUR_CTR_RENEGOTIATION.

Data Sources (1)

SourceAliasJoin Type
R_CentralContractItemSelTP R_CentralContractItemSelTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Central Purchase Contract Selection view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey CentralPurchaseContract view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.query.implementedBy ABAP:CL_MMPUR_CCTR_FILTER_CNDN view

OData Services (2)

ServiceBindingVersionContractRelease
UI_CNTRLCONTRITMSELECT_MANAGE UI_CNTRLCONTRITMSEL_MANAGE V2 C1 NOT_RELEASED
UI_PURCONTRRENEGTTN_MANAGE UI_PURCONTRRENEGTTN_MANAGE V2 C1 NOT_RELEASED

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
FormattedPurchasingDocItem FormattedPurchasingDocItem
PurchasingDocumentName PurchasingDocumentName Purch. Doc. Name
Material Material Vehicle Model
MaterialName MaterialName Material Description
PurchaseContractItemText PurchaseContractItemText Short Text
MaterialGroup MaterialGroup Product Group
MaterialGroupName MaterialGroupName prod Grp Desc.
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
PurchasingProcessingStatus PurchasingProcessingStatus Proc. State
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
TargetQuantity TargetQuantity Target Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
TargetAmount TargetAmount Target Value
DocumentCurrency DocumentCurrency Document Currency
OrderPriceUnit OrderPriceUnit Order Price Un.
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
Plant Plant Valuation Area
ProductTypeCode ProductTypeCode Product Type Group
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
ContractNetPriceAmount ContractNetPriceAmount Net Price
PurchaseContractType PurchaseContractType Order Type
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
PurgDocChangeRequestStatus PurgDocChangeRequestStatus Change Request Stat.
PurchasingContractDeletionCode PurchasingContractDeletionCode Del. Indicator
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PurgDocItemRenegotiationStatus PurgDocItemRenegotiationStatus Renegotiation Status
PurgDocItmRenegotiationStsDesc _PurgDocItemRenegttnStsText PurgDocItmRenegotiationStsDesc
ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc
_Supplier _Supplier
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup

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_CentralContractItemSelTP.
-- 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_CentralContractItemSelTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  FormattedPurchasingDocItem,
  PurchasingDocumentName,
  Material,
  MaterialName,
  PurchaseContractItemText,
  MaterialGroup,
  MaterialGroupName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingProcessingStatus,
  CompanyCode,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  TargetQuantity,
  OrderQuantityUnit,
  TargetAmount,
  DocumentCurrency,
  OrderPriceUnit,
  ValidityStartDate,
  ValidityEndDate,
  Plant,
  ProductTypeCode,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  ContractNetPriceAmount,
  PurchaseContractType,
  PurchasingDocumentCategory,
  PurchasingDocumentItemCategory,
  PurchasingDocumentOrigin,
  PurgDocChangeRequestStatus,
  PurchasingContractDeletionCode,
  PurchasingDocumentSubtype,
  IsEndOfPurposeBlocked,
  PurgDocItemRenegotiationStatus,
  _PurgDocItemRenegttnStsText.PurgDocItmRenegotiationStsDesc AS PurgDocItmRenegotiationStsDesc,
  ActivePurchasingDocument
FROM R_CentralContractItemSelTP
;

Learn More