I_SalesProviderContractItem

DDL: I_SALESPROVIDERCONTRACTITEM SQL: ISLSPRVDRCONTRI Type: view BASIC
45 Fields 1 Data Sources 2 Associations

Provider-Vertragspositionen für SB

I_SalesProviderContractItem is a Basic CDS View that provides data about "Provider-Vertragspositionen für SB" in SAP S/4HANA. It reads from 1 data source (I_ProviderContractItem) and exposes 45 fields with key fields SalesProviderContract, SalesProviderContractItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProviderContractItem _SalesProvContrItem from

Associations (2)

CardinalityTargetAliasCondition
[1] I_SalesProviderContract _PrvdrContr $projection.SalesProviderContract = _PrvdrContr.SalesProviderContract
[0..1] I_Product _Product $projection.CAProduct = _Product.Product

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISLSPRVDRCONTRI 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
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Provider-Vertragspositionen für SB view
ObjectModel.representativeKey SalesProviderContractItem view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY SalesProviderContract ProviderContract Contract
KEY SalesProviderContractItem ProviderContractItem Contract Item
CAProviderContractItemUUID CAProviderContractItemUUID Contr.Item ID
CAPrvdrContrParentItemUUID CAPrvdrContrParentItemUUID HiLevlPCtrItmID
CAProviderContractStatus CAProviderContractStatus Workflow Status
CAProviderContractItemText CAProviderContractItemText Ctr.Item Text
CASubscriptionChargeType CASubscriptionChargeType Charge Type
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangedByUser LastChangedByUser User Name
CAPrvdrContrItmValidFromDteTme CAPrvdrContrItmValidFromDteTme Valid From
CAPrvdrContrItmValidToDateTime CAPrvdrContrItmValidToDateTime Valid To
CAPrvdrContrItemCanclnDateTime CAPrvdrContrItemCanclnDateTime Reversal ind.
PrvdrContrItmWthdrwlDateTime PrvdrContrItmWthdrwlDateTime Withdrawn At
CAEndOfDurationDateTime CAEndOfDurationDateTime End of Duration
CAProduct CAProduct Product ID
ProductConfiguration ProductConfiguration Object Number
SoldProduct SoldProduct Product Sold
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
BusinessSolutionOrder BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem BusinessSolutionOrderItem Solution Order Item
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CAPrvdrContrSalesAreaAttrib1 CAPrvdrContrSalesAreaAttrib1 Sales Area 1
CAPrvdrContrSalesAreaAttrib2 CAPrvdrContrSalesAreaAttrib2 Sales Area 2
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
InternalOrder InternalOrder Order
RevenueRecognitionKey RevenueRecognitionKey Recognition key
EBRRResultAnalysisInternalID EBRRResultAnalysisInternalID Recognition key
EBRRIsBundleActive EBRRIsBundleActive Bundling
_BusinessArea _BusinessArea
_CompCode _CompCode
_Division _Division
_PrvdrContr _PrvdrContr
_Segment _Segment
_Product _Product

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_SalesProviderContractItem.
-- 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: ISLSPRVDRCONTRI

CREATE VIEW I_SalesProviderContractItem AS
SELECT
  ProviderContract AS SalesProviderContract,
  ProviderContractItem AS SalesProviderContractItem,
  CAProviderContractItemUUID,
  CAPrvdrContrParentItemUUID,
  CAProviderContractStatus,
  CAProviderContractItemText,
  CASubscriptionChargeType,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  CAPrvdrContrItmValidFromDteTme,
  CAPrvdrContrItmValidToDateTime,
  CAPrvdrContrItemCanclnDateTime,
  PrvdrContrItmWthdrwlDateTime,
  CAEndOfDurationDateTime,
  CAProduct,
  ProductConfiguration,
  SoldProduct,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  CAPrvdrContrSalesAreaAttrib1,
  CAPrvdrContrSalesAreaAttrib2,
  CompanyCode,
  BusinessArea,
  Segment,
  ProfitCenter,
  WBSElementInternalID,
  InternalOrder,
  RevenueRecognitionKey,
  EBRRResultAnalysisInternalID,
  EBRRIsBundleActive
FROM I_ProviderContractItem AS _SalesProvContrItem
LEFT OUTER JOIN I_SalesProviderContract AS _PrvdrContr ON SalesProviderContract = _PrvdrContr.SalesProviderContract  -- association [1]
LEFT OUTER JOIN I_Product AS _Product ON CAProduct = _Product.Product  -- association [0..1]
;

Learn More