C_CAProviderContractTP

DDL: C_CAPROVIDERCONTRACTTP Type: view_entity CONSUMPTION
42 Fields 1 Data Sources

Contract Accounting Provider Contract

C_CAProviderContractTP is a Consumption CDS View that provides data about "Contract Accounting Provider Contract" in SAP S/4HANA. It reads from 1 data source (R_CAProviderContractTP) and exposes 42 fields with key field CAProviderContract.

Data Sources (1)

SourceAliasJoin Type
R_CAProviderContractTP R_CAProviderContractTP projection

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Contract Accounting Provider Contract view
Search.searchable true view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CAProviderContract CAProviderContract
CAProviderContractName CAProviderContractName
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompCode CompanyCodeName Company Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _CreatedByUser UserDescription Full Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _LastChangedByUser UserDescription Full Name
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
CAProviderContractExtReference CAProviderContractExtReference
CAPrvdrContrStartDateTime CAPrvdrContrStartDateTime
CAPrvdrContrEndDateTime CAPrvdrContrEndDateTime
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup
CAAuthorizationGroupText
TimeZoneID TimeZoneID Time Zone
TimeZoneText
CAProviderContractCategory CAProviderContractCategory
CAProviderContractMigrtnStatus CAProviderContractMigrtnStatus
CAProviderContractType CAProviderContractType
CAProviderContractTypeText
CAProviderContractStatus CAProviderContractStatus
CAProviderContractStatusText
CAProviderContractSender CAProviderContractSender
CAProviderContractSenderText
PrvdrContrEarliestEndDateTime PrvdrContrEarliestEndDateTime
MinNrOfMonthsForContractPeriod MinNrOfMonthsForContractPeriod
NrOfMonthsForContractRenewal NrOfMonthsForContractRenewal
NrOfDaysForContrNoticePeriod NrOfDaysForContrNoticePeriod
BudgetBillingPlanType BudgetBillingPlanType
_BusinessPartner _BusinessPartner
_ProviderContractType _ProviderContractType
_ProviderContractStatus _ProviderContractStatus
_ProviderContractSender _ProviderContractSender
_CAAuthorizationGroup _CAAuthorizationGroup

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_CAProviderContractTP.
-- 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_CAProviderContractTP AS
SELECT
  CAProviderContract,
  CAProviderContractName,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  CreationDate,
  CreationTime,
  CreationDateTime,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  IsMarkedForDeletion,
  CAProviderContractExtReference,
  CAPrvdrContrStartDateTime,
  CAPrvdrContrEndDateTime,
  CAAuthorizationGroup,
  _CAAuthorizationGroup._Text[1:Language = $session.system_language].CAAuthorizationGroupText AS CAAuthorizationGroupText,
  TimeZoneID,
  _TimeZone._TimeZoneText[1:Language = $session.system_language].TimeZoneText AS TimeZoneText,
  CAProviderContractCategory,
  CAProviderContractMigrtnStatus,
  CAProviderContractType,
  _ProviderContractType._Text[1:Language = $session.system_language].CAProviderContractTypeText AS CAProviderContractTypeText,
  CAProviderContractStatus,
  _ProviderContractStatus._Text[1:Language = $session.system_language].CAProviderContractStatusText AS CAProviderContractStatusText,
  CAProviderContractSender,
  _ProviderContractSender._Text[1:Language = $session.system_language].CAProviderContractSenderText AS CAProviderContractSenderText,
  PrvdrContrEarliestEndDateTime,
  MinNrOfMonthsForContractPeriod,
  NrOfMonthsForContractRenewal,
  NrOfDaysForContrNoticePeriod,
  BudgetBillingPlanType
FROM R_CAProviderContractTP
;

Learn More