I_ConditionContract

DDL: I_CONDITIONCONTRACT Type: view BASIC
120 Fields 1 Data Sources 8 Associations

Condition Contract

I_ConditionContract is a Basic CDS View (Dimension) that provides data about "Condition Contract" in SAP S/4HANA. It reads from 1 data source (R_ConditionContract) and exposes 120 fields with key field ConditionContract. It has 8 associations to related views.

SAP Help Documentation

CategoryCondition Contract
Data CategoryDimension
Purpose
This CDS view provides the data to answer questions about condition contracts. The condition contract is used to enter conditions that refer to one or more suppliers, customers, or workforce. The condition contract combines all information relevant to the agreement, such as the condition granter or owner of the condition contract and special conditions such as discounts or prizes. It can be used to grant discounts for meeting quantity or value targets for sales or purchase volumes. This CDS view provides the data to answer the following business questions: What is the organizational data associated with the condition contract? What are the settlement calendars? What is the condition contract type? Is the condition contract relevant for the supplier or customer? What is the validity period of the condition contract? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BEGRU_KNA1 (Authorization Group for Customers) BEGRU_LFA1 (Authorization Group for Suppliers) ORG_AREA (Organizational Area) CONTR_TYP (Condition Contract Type) BEGRU_BUPA_GRP (Authorization Group for Business Partners) BUKRS_KOSTL (Company Code/Cost Center) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description ConditionContract Condition Contract CndnContrType Condition Contract Type Customer Customer Supplier Supplier PersonWorkAgreement Personnel Number CompanyCode Company Code PurchasingOrganization Purchasing Organization SalesOrganization Sales Organization CndnContrWorkerCostCenter Worker Cost Center CndnContrValidFrom Valid From CndnContrValidTo Valid To Note At least one element of this CDS view was deprecated. SAP may make the deprecated elements unusable, usually no earlier than one year after the deprecation. For more information, see Deprecated and Decommissioned CDS Views . We recommend that you switch to the following successor element(s) as soon as possible: PrecedingConditionContract → PrecedingConditionDocument _PrecedingConditionContract → _PrecedingConditionDocument You can't create new content based on deprecated CDS view elements. You can still change existing content that is based on deprecated CDS view elements (for example, adding deprecated fields of a released SAP view to an existing custom CDS view and adding further fields of a deprecated SAP view to an existing custom CDS view). As a key user, you will see the tasks in key user extensibility apps for prominent occurrences of deprecated CDS view elements, prompting you to rework your content where necessary.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_ConditionContract R_ConditionContract from

Associations (8)

CardinalityTargetAliasCondition
[0..*] I_CndnContrBusVolSelCriteria _CndnContrBusVolSelCriteria $projection.ConditionContract = _CndnContrBusVolSelCriteria.ConditionContract
[0..*] I_CndnContrSettlmtCal _CndnContrSettlmtCal $projection.ConditionContract = _CndnContrSettlmtCal.ConditionContract
[0..*] I_CndnContrConditionUsage _CndnContrConditionUsage $projection.ConditionContract = _CndnContrConditionUsage.ConditionContract
[0..1] I_CndnContrType _CndnContrType $projection.CndnContrType = _CndnContrType.CndnContrType
[0..1] I_CndnContrIsInactive _CndnContrIsInactive $projection.CndnContrIsInactive = _CndnContrIsInactive.CndnContrIsInactive
[0..1] I_ConditionContract _PrecedingConditionContract $projection.PrecedingConditionContract = _PrecedingConditionContract.ConditionContract
[0..1] I_ConditionDocument _PrecedingConditionDocument $projection.PrecedingConditionDocument = _PrecedingConditionDocument.ConditionDocument
[1..1] E_ConditionContract _Extension $projection.ConditionContract = _Extension.ConditionContract

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ICNDNCNTR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Condition Contract view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ConditionContract view
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (120)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
CndnContrType CndnContrType Contract Type
CndnContrClassfctnType CndnContrClassfctnType Contract Category
CndnContrProcVar CndnContrProcVar Process Variant
DocumentReferenceID DocumentReferenceID Reference
CndnContrAssgmtRef CndnContrAssgmtRef
ExternalDocumentReferenceID ExternalDocumentReferenceID Ext. Identifier
CndnContrExternalPartner CndnContrExternalPartner
CndnContrIsInactive CndnContrActvtnStatus
CndnContrValidFrom CndnContrValidFrom Valid From
CndnContrValidTo CndnContrValidTo Valid To
Supplier Supplier Supplier
Customer Customer Sold-to Party
PriorSupplier PriorSupplier Prior Supplier
PersonWorkAgreement PersonWorkAgreement Personnel No.
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationTimeZone CreationTimeZone Time Zone
CreationUTCDateTime CreationUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangedDate LastChangedDate Created On
LastChangeTime LastChangeTime Time changed
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
CndnContrCurrency CndnContrCurrency
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRate ExchangeRate Exchange rate
ExchangeRateDate ExchangeRateDate Translatn Date
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
NetPaymentDays NetPaymentDays Net Pmt Terms Period
PaymentMethod PaymentMethod Pymt Meth.
CndnContrSuplrSettlmtCat CndnContrSuplrSettlmtCat
CndnContrCustSettlmtCat CndnContrCustSettlmtCat
SettlmtProduct SettlmtProduct
FinalSettlmtCalendar FinalSettlmtCalendar
PartialSettlmtCalendar PartialSettlmtCalendar
DeltaSettlmtCalendar DeltaSettlmtCalendar
DeltaAccrualSettlmtCalendar DeltaAccrualSettlmtCalendar
AccrualClearingSettlmtCalendar AccrualClearingSettlmtCalendar
CndnContrExtensionCalendar CndnContrExtensionCalendar
PrecedingConditionContract PrecedingConditionDocument
PrecedingConditionDocument PrecedingConditionDocument
CndnContrPurposeCat CndnContrPurposeCat
CndnContrSourceDocCat CndnContrSourceDocCat
CndnContrSourceDoc CndnContrSourceDoc
CndnContrSourceDocItem CndnContrSourceDocItem
BusVolTableGroup BusVolTableGroup
AmountFieldGroup AmountFieldGroup
CndnContrUnit CndnContrUnit
CndnContrWeightUnit CndnContrWeightUnit
CndnContrVolumeUnit CndnContrVolumeUnit
CndnContrPointsQtyUnit CndnContrPointsQtyUnit
AccrualUpdateIsRequired AccrualUpdateIsRequired
CndnContrUUID CndnContrUUID
CndnContrSourceUUID CndnContrSourceUUID
SettlmtPartTxRegnNmbr SettlmtPartTxRegnNmbr
TaxCountry TaxCountry Tax Ctry/Reg.
SettlmtPartTxRegnCntry SettlmtPartTxRegnCntry
CndnContrPrcgDetnRlvnceCat CndnContrPrcgDetnRlvnceCat
CndnContrWorkerCostCenter CndnContrWorkerCostCenter
CndnContrWorkerSettlmtCat CndnContrWorkerSettlmtCat
DataController DataController Data Controller
_CndnContrBusVolSelCriteria _CndnContrBusVolSelCriteria
_CndnContrSettlmtCal _CndnContrSettlmtCal
_CndnContrConditionUsage _CndnContrConditionUsage
_CndnContrType _CndnContrType
_CndnContrClassfctnType _CndnContrClassfctnType
_CndnContrProcVar _CndnContrProcVar
_CndnContrIsInactive _CndnContrIsInactive
_Supplier _Supplier
_Customer _Customer
_PriorSupplier _PriorSupplier
_PersonWorkAgreement _PersonWorkAgreement
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CndnContrCurrency _CndnContrCurrency
_ExchangeRateType _ExchangeRateType
_CndnContrSuplrSettlmtCat _CndnContrSuplrSettlmtCat
_CndnContrCustSettlmtCat _CndnContrCustSettlmtCat
_SettlmtProduct _SettlmtProduct
_FinalSettlmtCalendar _FinalSettlmtCalendar
_PartialSettlmtCalendar _PartialSettlmtCalendar
_DeltaSettlmtCalendar _DeltaSettlmtCalendar
_DeltaAccrualSettlmtCalendar _DeltaAccrualSettlmtCalendar
_AccrualClearingSettlmtCal _AccrualClearingSettlmtCal
_CndnContrExtensionCalendar _CndnContrExtensionCalendar
_PrecedingConditionContract _PrecedingConditionContract
_PrecedingConditionDocument _PrecedingConditionDocument
_CndnContrPurposeCat _CndnContrPurposeCat
_CndnContrSourceDocCat _CndnContrSourceDocCat
_BusVolTableGroup _BusVolTableGroup
_AmountFieldGroup _AmountFieldGroup
_CndnContrUnit _CndnContrUnit
_CndnContrWeightUnit _CndnContrWeightUnit
_CndnContrVolumeUnit _CndnContrVolumeUnit
_CndnContrPointsQtyUnit _CndnContrPointsQtyUnit
_TaxCountry _TaxCountry
_SettlmtPartTxRegnCntry _SettlmtPartTxRegnCntry
_CndnContrPrcgDetnRlvnceCat _CndnContrPrcgDetnRlvnceCat
_CndnContrWorkerSettlmtCat _CndnContrWorkerSettlmtCat

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_ConditionContract.
-- 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 I_ConditionContract AS
SELECT
  ConditionContract,
  CndnContrType,
  CndnContrClassfctnType,
  CndnContrProcVar,
  DocumentReferenceID,
  CndnContrAssgmtRef,
  ExternalDocumentReferenceID,
  CndnContrExternalPartner,
  CndnContrActvtnStatus AS CndnContrIsInactive,
  CndnContrValidFrom,
  CndnContrValidTo,
  Supplier,
  Customer,
  PriorSupplier,
  PersonWorkAgreement,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationTimeZone,
  CreationUTCDateTime,
  LastChangedByUser,
  LastChangedDate,
  LastChangeTime,
  LastChangeUTCDateTime,
  CndnContrCurrency,
  ExchangeRateType,
  ExchangeRate,
  ExchangeRateDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  CndnContrSuplrSettlmtCat,
  CndnContrCustSettlmtCat,
  SettlmtProduct,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  CndnContrExtensionCalendar,
  PrecedingConditionDocument AS PrecedingConditionContract,
  PrecedingConditionDocument,
  CndnContrPurposeCat,
  CndnContrSourceDocCat,
  CndnContrSourceDoc,
  CndnContrSourceDocItem,
  BusVolTableGroup,
  AmountFieldGroup,
  CndnContrUnit,
  CndnContrWeightUnit,
  CndnContrVolumeUnit,
  CndnContrPointsQtyUnit,
  AccrualUpdateIsRequired,
  CndnContrUUID,
  CndnContrSourceUUID,
  SettlmtPartTxRegnNmbr,
  TaxCountry,
  SettlmtPartTxRegnCntry,
  CndnContrPrcgDetnRlvnceCat,
  CndnContrWorkerCostCenter,
  CndnContrWorkerSettlmtCat,
  DataController
FROM R_ConditionContract
LEFT OUTER JOIN I_CndnContrBusVolSelCriteria AS _CndnContrBusVolSelCriteria ON ConditionContract = _CndnContrBusVolSelCriteria.ConditionContract  -- association [0..*]
LEFT OUTER JOIN I_CndnContrSettlmtCal AS _CndnContrSettlmtCal ON ConditionContract = _CndnContrSettlmtCal.ConditionContract  -- association [0..*]
LEFT OUTER JOIN I_CndnContrConditionUsage AS _CndnContrConditionUsage ON ConditionContract = _CndnContrConditionUsage.ConditionContract  -- association [0..*]
LEFT OUTER JOIN I_CndnContrType AS _CndnContrType ON CndnContrType = _CndnContrType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrIsInactive AS _CndnContrIsInactive ON CndnContrIsInactive = _CndnContrIsInactive.CndnContrIsInactive  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _PrecedingConditionContract ON PrecedingConditionContract = _PrecedingConditionContract.ConditionContract  -- association [0..1]
LEFT OUTER JOIN I_ConditionDocument AS _PrecedingConditionDocument ON PrecedingConditionDocument = _PrecedingConditionDocument.ConditionDocument  -- association [0..1]
LEFT OUTER JOIN E_ConditionContract AS _Extension ON ConditionContract = _Extension.ConditionContract  -- association [1..1]
;

Learn More