R_CentralContractItemSelTP

DDL: R_CENTRALCONTRACTITEMSELTP Type: view_entity TRANSACTIONAL
44 Fields 1 Data Sources 1 Associations

Central Purchase Contract Item Selection

R_CentralContractItemSelTP is a Transactional CDS View that provides data about "Central Purchase Contract Item Selection" in SAP S/4HANA. It reads from 1 data source (I_CentralContractItemSel) and exposes 44 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CentralContractItemSel I_CentralContractItemSel from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PurchasingDocumentItem _CentralContractItemExtension $projection.CentralPurchaseContract = _CentralContractItemExtension.PurchasingDocument and $projection.CentralPurchaseContractItem = _CentralContractItemExtension.PurchasingDocumentItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name CentralPurchaseContract view
EndUserText.label Central Purchase Contract Item Selection view

Fields (44)

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 _MaterialText MaterialName Material Description
PurchaseContractItemText PurchaseContractItemText Short Text
MaterialGroup MaterialGroup Product Group
MaterialGroupName _MaterialGrouptext MaterialGroupName prod Grp Desc.
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingProcessingStatus PurchasingProcessingStatus Proc. State
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
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
PurchasingDocumentItemUniqueID PurchasingDocumentItemUniqueID Document Item
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
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
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
PurgDocChangeRequestStatus PurgDocChangeRequestStatus Change Request Stat.
PurchasingContractDeletionCode PurchasingContractDeletionCode Del. Indicator
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PurgDocItemRenegotiationStatus PurgDocItemRenegotiationStatus Renegotiation Status
ActivePurchasingDocument ActivePurchasingDocument Active Purchase Doc
_MaterialGrouptext _MaterialGrouptext
_MaterialText _MaterialText
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_PurContrDocSts _PurContrDocSts
_Supplier _Supplier
_PurgDocItemRenegttnStsText _PurgDocItemRenegttnStsText

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_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 R_CentralContractItemSelTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  FormattedPurchasingDocItem,
  PurchasingDocumentName,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  PurchaseContractItemText,
  MaterialGroup,
  _MaterialGrouptext.MaterialGroupName AS MaterialGroupName,
  PurchasingGroup,
  PurchasingOrganization,
  PurchasingProcessingStatus,
  CompanyCode,
  Supplier,
  TargetQuantity,
  OrderQuantityUnit,
  TargetAmount,
  DocumentCurrency,
  OrderPriceUnit,
  ValidityStartDate,
  ValidityEndDate,
  Plant,
  PurchasingDocumentItemUniqueID,
  PurchasingDocumentItemCategory,
  ProductTypeCode,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  ContractNetPriceAmount,
  PurchaseContractType,
  PurchasingDocumentCategory,
  PurchasingDocumentOrigin,
  PurgDocChangeRequestStatus,
  PurchasingContractDeletionCode,
  PurchasingDocumentSubtype,
  IsEndOfPurposeBlocked,
  PurgDocItemRenegotiationStatus,
  ActivePurchasingDocument
FROM I_CentralContractItemSel
LEFT OUTER JOIN E_PurchasingDocumentItem AS _CentralContractItemExtension ON CentralPurchaseContract = _CentralContractItemExtension.PurchasingDocument AND CentralPurchaseContractItem = _CentralContractItemExtension.PurchasingDocumentItem  -- association [1..1]
;

Learn More