What is I_CAProviderContractItem in SAP S/4HANA?

I_CAProviderContractItem is a basic CDS view in SAP S/4HANA. Provider Contract Item It contains 132 fields.

Which tables does I_CAProviderContractItem read from?

I_CAProviderContractItem reads data from: I_ProviderContractItem.

What VDM layer is I_CAProviderContractItem?

I_CAProviderContractItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CAProviderContractItem

DDL: I_CAPROVIDERCONTRACTITEM SQL: ICAPRVDRCONTRI Type: view BASIC

132 Fields 1 Data Sources 2 Associations

Provider Contract Item

I_CAProviderContractItem (Basic)

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

ContrAcctgProviderContractItem · Contract Accounting

I_CAProviderContractItem is a Basic CDS View (Dimension) that provides data about "Provider Contract Item" in SAP S/4HANA. It reads from 1 data source (I_ProviderContractItem) and exposes 132 fields with key fields CAProviderContract, CAProviderContractItemNumber. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Master Data
Data Category	Dimension

Purpose
This CDS view represents the provider contract item data where the contract category ( VTCAT ) is space . In Contract Accounting and Convergent Invoicing , a provider contract comprises all legally binding agreements regarding the provision and billing of services entered into by a customer and a company for a specified period of time. The most important data in the item structure of the provider contract comprises the provider contract ID, provider contract item number, contract account, product, organizational data, such as the sales organization, and data for revenue recognition. This CDS view provides the prerequisites for answering the following business questions: Which contract account is the provider contract item assigned to? When does the validity of the provider contract item start or end? Is the provider contract item relevant for revenue accounting ? Which product is the provider contract item assigned to? How often is the customer billed for a provider contract item?

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: F_KKVT_BEG ( Provider Contract Authorization Group ) F_KKVT_BUK ( Provider Contract Company Code Authorization )

SAP Business Warehouse (SAP BW) Extraction
Data Extraction Type Full Delta (change data capture) Corresponding DataSources (Extractors) This CDS view does not correspond to any DataSource (extractor). Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Contract Accounting
Application Component	FI-CA
Capabilities	Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction, Analytical Dimension
Package	Contract Accounting for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view represents the provider contract item data where the contract category (VTCAT) is space. In Contract Accounting and Convergent Invoicing, a provider contract comprises all legally binding agreements regarding the provision and billing of services entered into by a customer and a company for a specified period of time.</p> <p>The most important data in the item structure of the provider contract comprises the provider contract ID, provider contract item number, contract account, product, organizational data, such as the sales organization, and data for revenue recognition.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which contract account is the provider contract item assigned to?</p></li> <li><p>When does the validity of the provider contract item start or end?</p></li> <li><p>Is the provider contract item relevant for revenue accounting ?</p></li> <li><p>Which product is the provider contract item assigned to? </p></li> <li><p>How often is the customer billed for a provider contract item?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_ProviderContractItem	I_ProviderContractItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CAProviderContractHeader	_PrvdrContr	`$projection.CAProviderContract = _PrvdrContr.CAProviderContract`
[1..1]	E_CAProviderContractItem	_PCoExtension	`$projection.CAProviderContract = _PCoExtension.CAProviderContract and $projection.CAProviderContractItemNumber = _PCoExtension.CAProviderContractItemNumber`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	ICAPRVDRCONTRI	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Provider Contract Item	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	true	view
Analytics.internalName	#LOCAL	view
ObjectModel.representativeKey	CAProviderContractItemNumber	view
ObjectModel.sapObjectNodeType.name	ContrAcctgProviderContractItem	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#BASIC	view

Fields (132)

Key	Field	Source Field	Description
KEY	CAProviderContract	ProviderContract	Identification of a Provider Contract
KEY	CAProviderContractItemNumber	ProviderContractItem	Contract: Item Number
	CreationDate	CreationDate	Record Created On
	CreationTime	CreationTime	Time of Change
	CreatedByUser	CreatedByUser	Name of Person Responsible for Creating the Object
	LastChangeDate	LastChangeDate	Last Changed On
	LastChangeTime	LastChangeTime	Last Changed At
	LastChangedByUser	LastChangedByUser	Name of Person Who Changed Object
	CAProviderContractItemUUID	CAProviderContractItemUUID	External GUID of Provider Contract Items
	CAPrvdrContrParentItemUUID	CAPrvdrContrParentItemUUID	External GUID of Higher-Level Provider Contract Items
	CAPrvdrContrItmValidFromDteTme	CAPrvdrContrItmValidFromDteTme	Valid From (Time Stamp)
	CAPrvdrContrItmValidToDateTime	CAPrvdrContrItmValidToDateTime	Valid To (Time Stamp)
	CAPrvdrContrItemCanclnDateTime	CAPrvdrContrItemCanclnDateTime	Time of Reversal (Time Stamp)
	PrvdrContrItmWthdrwlDateTime	PrvdrContrItmWthdrwlDateTime	Withdrawn On (Timestamp)
	CAProviderContractStatus	CAProviderContractStatus	Status of Provider Contract
	CAProviderContractItemText	CAProviderContractItemText	Text for Provider Contract Item
	ContractAccount	ContractAccount	Contract Account Number
	CAPrepaidAccount	CAPrepaidAccount	Prepaid Account
	CATechnicalResourceGroup	CATechnicalResourceGroup	Group of IDs
	CAServiceRecipient	CAServiceRecipient	Recipient of Service
	CAAddressIDOfServiceRecipient	CAAddressIDOfServiceRecipient	Address Number for Recipient of the Service
	CAProduct	CAProduct	Product Number
	ProductConfiguration	ProductConfiguration	Configuration Instance
	CASalesPackageProduct	CASalesPackageProduct	Product ID of the Sales Package
	CAMasterAgreement	CAMasterAgreement	Identification of Master Agreement
	CAMasterAgreementProduct	CAMasterAgreementProduct	Custom Product or Product Range
	CAPartnerSettlementRule	CAPartnerSettlementRule	Partner Settlement Rule
	CASharingContract	CASharingContract	Reference to Sharing Contract
	TaxJurisdiction	TaxJurisdiction	Jurisdiction for Tax Calculation - Tax Jurisdiction Code
	CAReceivingCountry	CAReceivingCountry	Destination Country/Region (for Tax Reports)
	TaxCountry	TaxCountry	Tax Reporting Country/Region
	CASubscriptionChargeType	CASubscriptionChargeType	Charge Type
	CAProviderContractQuantity	CAProviderContractQuantity	Quantity
	CAProviderContractQuantityUnit	CAProviderContractQuantityUnit	Unit of Measure
	DistrSystOperatorBP	DistrSystOperatorBP	Distributor
	DistrSystOperatorMarketCommID	DistrSystOperatorMarketCommID	Distribution System Operator ID
	MeterOperatorBusinessPartner	MeterOperatorBusinessPartner	Meter Operator
	MeterOperatorMarketCommID	MeterOperatorMarketCommID	Meter Operator ID
	MarketLocationIdentifier	MarketLocationIdentifier	Market Location
	SoldProduct	SoldProduct	Product Sold
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	Distribution Channel
	CompanyCode	CompanyCode	Receiver Company Code
	CAIntcoCompanyCodeSupplying	CAIntcoCompanyCodeSupplying	Supplying Company Code
	BusinessArea	BusinessArea	Business Area
	Segment	Segment	Segment for Segmental Reporting
	ProfitCenter	ProfitCenter	Profit Center
	Division	Division	Internal Division ID
	CAPrvdrContrSalesAreaAttrib1	CAPrvdrContrSalesAreaAttrib1	Contract: Sales Area Attribute 1
	CAPrvdrContrSalesAreaAttrib2	CAPrvdrContrSalesAreaAttrib2	Contract: Sales Area Attribute 2
	WBSElementInternalID	WBSElementInternalID	WBS Element Internal ID
	InternalOrder	InternalOrder	Order Number
	PrvdrContrItmIsRlvtForPrfSgDrv	PrvdrContrItmIsRlvtForPrfSgDrv	Acct Assgmnt of Individual Contracts f. Provider Contracts
	CABillgCycle	CABillgCycle	Billing Cycle
	CALastDayOfBillingPeriod	CALastDayOfBillingPeriod	Day of Period End
	CABillgCyclePeriodStartDate	CABillgCyclePeriodStartDate	Contract: Date of Original Start of Period
	CAInvcgSchedule	CAInvcgSchedule	Selection Characteristic for Scheduling
	CARatingArea	CARatingArea	Rating Area ID
	CABillgPlnNumber	CABillgPlnNumber	Billing Plan Number
	CAConsumptionBillgSoldToParty	CAConsumptionBillgSoldToParty	Sold-To Party
	CAConsumptionBillgInvoiceRcpnt	CAConsumptionBillgInvoiceRcpnt	Invoice Recipient
	ConsumptionBillingPaymentTerms	ConsumptionBillingPaymentTerms	Terms of Payment Key
	CnsmpnBillgBillableControl	CnsmpnBillgBillableControl	Accounting Indicator
	ConsumptionBillingSEPAMandate	ConsumptionBillingSEPAMandate	Unique Reference to Mandate for each Payee
	CAConsumptionBillgPaymentCard	CAConsumptionBillgPaymentCard	Payment Card ID for Payments
	CAIsRevenueAccountingRelevant	CAIsRevenueAccountingRelevant	Relevant for Revenue Accounting
	CARevenueAcctgMigrationPackage	CARevenueAcctgMigrationPackage	Migration Package ID
	RevenueAccountingRefType	RevenueAccountingRefType	Reference Type for Revenue Accounting
	CARevenueAccountingRefType	CARevenueAccountingRefType	Reference Type for Revenue Accounting
	RevenueAccountingReference	RevenueAccountingReference	Reference ID for Revenue Accounting
	CARevenueAcctgDocumentItem	CARevenueAcctgDocumentItem	Revenue Accounting Item ID
	TransactionPriceCurrency	TransactionPriceCurrency	Currency Key
	TransactionPrice	TransactionPrice	Transaction Price for Each Recurrence Period
	TotalTransactionPrice	TotalTransactionPrice	Total Transaction Price
	TransacPriceRcrrcPerdTimeUnit	TransacPriceRcrrcPerdTimeUnit	Time Unit for Recurrence Period
	TransacPriceRcrrcPerdDuration	TransacPriceRcrrcPerdDuration	Length of Recurrence Period
	StandAloneSellingPriceCurrency	StandAloneSellingPriceCurrency	Currency Key
	StandAloneSellingPrice	StandAloneSellingPrice	Standalone Selling Price for Each Recurrence Period
	TotalStandAloneSellingPrice	TotalStandAloneSellingPrice	Total Standalone Selling Price
	SSPriceRecurrencePerdTimeUnit	SSPriceRecurrencePerdTimeUnit	Time Unit for Recurrence Period
	SSPriceRecurrencePerdDuration	SSPriceRecurrencePerdDuration	Length of Recurrence Period
	CAPrvdrContrItmChgReason	CAPrvdrContrItmChgReason	Change Reason
	CAEndOfDurationDateTime	CAEndOfDurationDateTime	End of Contract Duration (Time Stamp)
	CARevnAcctgRecrrgServiceType	CARevnAcctgRecrrgServiceType	Service Type
	CARevnAcctgTransfRecordOrigin	CARevnAcctgTransfRecordOrigin	Type of Origin for Transfer Record
	CAOriginOfPaymentMasterData	CAOriginOfPaymentMasterData	Determination of Payment Data
	PaymentCondition	PaymentCondition	Payment Condition
	CAPaymentMethodForIncgPayment	CAPaymentMethodForIncgPayment	Incoming Payment Method
	CAAlternativePayer	CAAlternativePayer	Alternative Payer
	CAAddressIDOfAlternativePayer	CAAddressIDOfAlternativePayer	Address Number for Alternative Payer
	CABankIDForIncomingPayments	CABankIDForIncomingPayments	Bank Details ID for Incoming Payments
	SEPAMandate	SEPAMandate	Unique Reference to Mandate for each Payee
	CAPaymentCardIDForIncomingPayt	CAPaymentCardIDForIncomingPayt	Payment Card ID for Incoming Payments
	CAPaymentMethodForOutgPayment	CAPaymentMethodForOutgPayment	Outgoing Payment Methods
	CAAlternativePayee	CAAlternativePayee	Alternative Payee
	CAAddressIDOfAlternativePayee	CAAddressIDOfAlternativePayee	Address Number for Alternative Payee
	CABankIDForOutgoingPayments	CABankIDForOutgoingPayments	Bank Details ID for Outgoing Payments
	CAPaymentCardIDForOutgoingPayt	CAPaymentCardIDForOutgoingPayt	Payment Card ID for Outgoing Payments
	CAKeyForPaymentCardSupplement	CAKeyForPaymentCardSupplement	Key for Payment Card Supplement
	CAOriginOfDunningMasterData	CAOriginOfDunningMasterData	Dunning Control
	CADunningProcedure	CADunningProcedure	Dunning Procedure
	CAServiceDisconncnIsProhibited	CAServiceDisconncnIsProhibited	Disconnection of Service Not Permitted
	CACollectionStrategy	CACollectionStrategy	Collection Strategy
	CACollectionsMasterDataGroup	CACollectionsMasterDataGroup	Collection Management: Master Data Group
	CACollectionsContactPerson	CACollectionsContactPerson	Collections Contact Person
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	Purchase Order Number
	CustomerPurchaseOrderDate	CustomerPurchaseOrderDate	Customer Reference Date
	_PrvdrContr	_PrvdrContr
	_ProviderContractStatus	_ProviderContractStatus
	_ContrAcc	_ContrAcc
	_Country	_Country
	_CASubscriptionChargeType	_CASubscriptionChargeType
	_CompCode	_CompCode
	_CompCodeSup	_CompCodeSup
	_BusinessArea	_BusinessArea
	_Segment	_Segment
	_Division	_Division
	_BillgCycle	_BillgCycle
	_InvcgSchedule	_InvcgSchedule
	_CARatingArea	_CARatingArea
	_BillgPln	_BillgPln
	_PrvdrContrItemChgReason	_PrvdrContrItemChgReason
	_CARevnAcctgServiceType	_CARevnAcctgServiceType
	_CARevnAcctgTransfRecdOrigin	_CARevnAcctgTransfRecdOrigin
	_CAPaymentMasterDataOrigin	_CAPaymentMasterDataOrigin
	_PaymentCondition	_PaymentCondition
	_CAPaymentMethod	_CAPaymentMethod
	_CADunningMasterDataOrigin	_CADunningMasterDataOrigin
	_CADunningProcedure	_CADunningProcedure
	_CACollectionStrategy	_CACollectionStrategy
	_CACollMasterDataGroup	_CACollMasterDataGroup
	_CACollectionsContactPerson	_CACollectionsContactPerson

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_CAProviderContractItem.
-- 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: ICAPRVDRCONTRI

CREATE VIEW I_CAProviderContractItem AS
SELECT
  ProviderContract AS CAProviderContract,
  ProviderContractItem AS CAProviderContractItemNumber,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  CAProviderContractItemUUID,
  CAPrvdrContrParentItemUUID,
  CAPrvdrContrItmValidFromDteTme,
  CAPrvdrContrItmValidToDateTime,
  CAPrvdrContrItemCanclnDateTime,
  PrvdrContrItmWthdrwlDateTime,
  CAProviderContractStatus,
  CAProviderContractItemText,
  ContractAccount,
  CAPrepaidAccount,
  CATechnicalResourceGroup,
  CAServiceRecipient,
  CAAddressIDOfServiceRecipient,
  CAProduct,
  ProductConfiguration,
  CASalesPackageProduct,
  CAMasterAgreement,
  CAMasterAgreementProduct,
  CAPartnerSettlementRule,
  CASharingContract,
  TaxJurisdiction,
  CAReceivingCountry,
  TaxCountry,
  CASubscriptionChargeType,
  CAProviderContractQuantity,
  CAProviderContractQuantityUnit,
  DistrSystOperatorBP,
  DistrSystOperatorMarketCommID,
  MeterOperatorBusinessPartner,
  MeterOperatorMarketCommID,
  MarketLocationIdentifier,
  SoldProduct,
  SalesOrganization,
  DistributionChannel,
  CompanyCode,
  CAIntcoCompanyCodeSupplying,
  BusinessArea,
  Segment,
  ProfitCenter,
  Division,
  CAPrvdrContrSalesAreaAttrib1,
  CAPrvdrContrSalesAreaAttrib2,
  WBSElementInternalID,
  InternalOrder,
  PrvdrContrItmIsRlvtForPrfSgDrv,
  CABillgCycle,
  CALastDayOfBillingPeriod,
  CABillgCyclePeriodStartDate,
  CAInvcgSchedule,
  CARatingArea,
  CABillgPlnNumber,
  CAConsumptionBillgSoldToParty,
  CAConsumptionBillgInvoiceRcpnt,
  ConsumptionBillingPaymentTerms,
  CnsmpnBillgBillableControl,
  ConsumptionBillingSEPAMandate,
  CAConsumptionBillgPaymentCard,
  CAIsRevenueAccountingRelevant,
  CARevenueAcctgMigrationPackage,
  RevenueAccountingRefType,
  CARevenueAccountingRefType,
  RevenueAccountingReference,
  CARevenueAcctgDocumentItem,
  TransactionPriceCurrency,
  TransactionPrice,
  TotalTransactionPrice,
  TransacPriceRcrrcPerdTimeUnit,
  TransacPriceRcrrcPerdDuration,
  StandAloneSellingPriceCurrency,
  StandAloneSellingPrice,
  TotalStandAloneSellingPrice,
  SSPriceRecurrencePerdTimeUnit,
  SSPriceRecurrencePerdDuration,
  CAPrvdrContrItmChgReason,
  CAEndOfDurationDateTime,
  CARevnAcctgRecrrgServiceType,
  CARevnAcctgTransfRecordOrigin,
  CAOriginOfPaymentMasterData,
  PaymentCondition,
  CAPaymentMethodForIncgPayment,
  CAAlternativePayer,
  CAAddressIDOfAlternativePayer,
  CABankIDForIncomingPayments,
  SEPAMandate,
  CAPaymentCardIDForIncomingPayt,
  CAPaymentMethodForOutgPayment,
  CAAlternativePayee,
  CAAddressIDOfAlternativePayee,
  CABankIDForOutgoingPayments,
  CAPaymentCardIDForOutgoingPayt,
  CAKeyForPaymentCardSupplement,
  CAOriginOfDunningMasterData,
  CADunningProcedure,
  CAServiceDisconncnIsProhibited,
  CACollectionStrategy,
  CACollectionsMasterDataGroup,
  CACollectionsContactPerson,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate
FROM I_ProviderContractItem
LEFT OUTER JOIN I_CAProviderContractHeader AS _PrvdrContr ON CAProviderContract = _PrvdrContr.CAProviderContract  -- association [1..1]
LEFT OUTER JOIN E_CAProviderContractItem AS _PCoExtension ON CAProviderContract = _PCoExtension.CAProviderContract AND CAProviderContractItemNumber = _PCoExtension.CAProviderContractItemNumber  -- association [1..1]
;

Depth:

I_CAProviderContractItem view

I_ProviderContractItem view