I_CAProviderContractHeader

DDL: I_CAPROVIDERCONTRACTHEADER SQL: ICAPRVDRCONTRH Type: view BASIC

Provider Contract Header

I_CAProviderContractHeader (Basic)

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

Contract Accounting Provider Contract · Contract Accounting

I_CAProviderContractHeader is a Basic CDS View (Dimension) that provides data about "Provider Contract Header" in SAP S/4HANA. It reads from 1 data source (I_ProviderContract) and exposes 37 fields with key field CAProviderContract. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Data CategoryDimension
Purpose
This CDS view represents the header data of provider contracts 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 header structure of the provider contract comprise the ID of the provider contract, the business partner, the name of the contract, and the start date and time, and end date and time. This CDS view provides the prerequisites for answering the following business questions: How many provider contracts exist for a business partner? When does the validity of the provider contract end?

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

StateC1
Line of BusinessContract Accounting
Application ComponentFI-CA
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction, Analytical Dimension
PackageContract Accounting for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view represents the header data of provider contracts 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 header structure of the provider contract comprise the ID of the provider contract, the business partner, the name of the contract, and the start date and time, and end date and time. </p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>How many provider contracts exist for a business partner?</p></li> <li><p>When does the validity of the provider contract end?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ProviderContract I_ProviderContract from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CAProviderContractHeader _Extension $projection.CAProviderContract = _Extension.CAProviderContract

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ICAPRVDRCONTRH view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Provider Contract Header view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CAProviderContract view
ObjectModel.sapObjectNodeType.name ContrAcctgProviderContract view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CAProviderContract ProviderContract Identification of a Provider Contract
BusinessPartner BusinessPartner Business Partner Number
CreationDate CreationDate Record Created On
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser Name of Person Responsible for Creating the Object
IsMarkedForDeletion IsMarkedForDeletion Deletion Indicator
LastChangeDate LastChangeDate Last Changed On
LastChangeTime LastChangeTime Last Changed At
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
CAProviderContractName CAProviderContractName Name of Contract
CAProviderContractExtReference CAProviderContractExtReference Technical Key of Provider Contract in External System
CAPrvdrContrStartDateTime CAPrvdrContrStartDateTime Contract Start
CAPrvdrContrEndDateTime CAPrvdrContrEndDateTime Contract End Date
CAAuthorizationGroup CAAuthorizationGroup Authorization Group
CompanyCode CompanyCode Company Code for Authorization Check
TimeZoneID TimeZoneID Time Zone
CAProviderContractCategory CAProviderContractCategory Contract Category
CAProviderContractMigrtnStatus CAProviderContractMigrtnStatus Migration Status
CAProviderContractType CAProviderContractType Contract Specification
CAProviderContractStatus CAProviderContractStatus Status of Provider Contract
CAProviderContractSender CAProviderContractSender Provider Contract Sender
PrvdrContrEarliestEndDateTime PrvdrContrEarliestEndDateTime End of Minimum Term
MinNrOfMonthsForContractPeriod MinNrOfMonthsForContractPeriod Min Length of Contract (Months)
NrOfMonthsForContractRenewal NrOfMonthsForContractRenewal Contract Extension in Months
NrOfDaysForContrNoticePeriod NrOfDaysForContrNoticePeriod Notice Period in Days
BudgetBillingPlanType BudgetBillingPlanType Utilities Budget Billing Plan Type
_BusinessPartner _BusinessPartner
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CAAuthorizationGroup _CAAuthorizationGroup
_CompCode _CompCode
_TimeZone _TimeZone
_ProviderContractCategory _ProviderContractCategory
_ProviderContractMigrtnSts _ProviderContractMigrtnSts
_ProviderContractType _ProviderContractType
_ProviderContractStatus _ProviderContractStatus
_ProviderContractSender _ProviderContractSender

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_CAProviderContractHeader.
-- 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: ICAPRVDRCONTRH

CREATE VIEW I_CAProviderContractHeader AS
SELECT
  ProviderContract AS CAProviderContract,
  BusinessPartner,
  CreationDate,
  CreationTime,
  CreatedByUser,
  IsMarkedForDeletion,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  CAProviderContractName,
  CAProviderContractExtReference,
  CAPrvdrContrStartDateTime,
  CAPrvdrContrEndDateTime,
  CAAuthorizationGroup,
  CompanyCode,
  TimeZoneID,
  CAProviderContractCategory,
  CAProviderContractMigrtnStatus,
  CAProviderContractType,
  CAProviderContractStatus,
  CAProviderContractSender,
  PrvdrContrEarliestEndDateTime,
  MinNrOfMonthsForContractPeriod,
  NrOfMonthsForContractRenewal,
  NrOfDaysForContrNoticePeriod,
  BudgetBillingPlanType
FROM I_ProviderContract
LEFT OUTER JOIN E_CAProviderContractHeader AS _Extension ON CAProviderContract = _Extension.CAProviderContract  -- association [1..1]
;