I_SalesProviderContract

DDL: I_SALESPROVIDERCONTRACT SQL: ISLSPRVDRCONTR Type: view BASIC

Provider-Vertrag für Sales Billing

I_SalesProviderContract is a Basic CDS View that provides data about "Provider-Vertrag für Sales Billing" in SAP S/4HANA. It reads from 1 data source (I_ProviderContract) and exposes 23 fields with key field SalesProviderContract.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_ProviderContract I_ProviderContract from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISLSPRVDRCONTR view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey SalesProviderContract view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Provider-Vertrag für Sales Billing view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SalesProviderContract ProviderContract
BusinessPartner BusinessPartner
IsMarkedForDeletion IsMarkedForDeletion
CAProviderContractName CAProviderContractName
CAPrvdrContrStartDateTime CAPrvdrContrStartDateTime
CAPrvdrContrEndDateTime CAPrvdrContrEndDateTime
CompanyCode CompanyCode
TimeZoneID TimeZoneID
CAProviderContractStatus CAProviderContractStatus
CAProviderContractSender CAProviderContractSender
CreationDate CreationDate
CreationTime CreationTime
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
LastChangedByUser LastChangedByUser
_BusinessPartner _BusinessPartner
_CompCode _CompCode
_ProviderContractStatus _ProviderContractStatus
_ProviderContractSender _ProviderContractSender
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_TimeZone _TimeZone 
@AbapCatalog.sqlViewName: 'ISLSPRVDRCONTR'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'SalesProviderContract'
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking : #REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Provider-Vertrag für Sales Billing'
define view I_SalesProviderContract
  as select from I_ProviderContract
{

  key ProviderContract as SalesProviderContract,

      BusinessPartner,
      IsMarkedForDeletion,
      CAProviderContractName,
      CAPrvdrContrStartDateTime,
      CAPrvdrContrEndDateTime,
      CompanyCode,
      TimeZoneID,
      CAProviderContractStatus,
      CAProviderContractSender,

      /* Administrative Data */
      CreationDate,
      CreationTime,
      CreatedByUser,
      LastChangeDate,
      LastChangeTime,
      LastChangedByUser,

      /* Associations */
      _BusinessPartner,
      _CompCode,
      _ProviderContractStatus,
      _ProviderContractSender,
      _CreatedByUser,
      _LastChangedByUser,
      _TimeZone      
}
where
  CAProviderContractCategory = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROVIDERCONTRACT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_PROVIDERCONTRACTSENDER",
"I_PROVIDERCONTRACTSTATUS",
"I_TIMEZONE",
"I_USER"
],
"BASE":
[
"I_PROVIDERCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More