I_ConditionContract
Condition Contract
I_ConditionContract is a Composite 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. Part of development package WCB_API_A2A_CC_VDM.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_ConditionContract | R_ConditionContract | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 | #A | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ConditionContract | ConditionContract | ||
| CndnContrType | CndnContrType | |||
| CndnContrClassfctnType | CndnContrClassfctnType | |||
| CndnContrProcVar | CndnContrProcVar | |||
| DocumentReferenceID | DocumentReferenceID | |||
| CndnContrAssgmtRef | CndnContrAssgmtRef | |||
| ExternalDocumentReferenceID | ExternalDocumentReferenceID | |||
| CndnContrExternalPartner | CndnContrExternalPartner | |||
| CndnContrIsInactive | CndnContrActvtnStatus | |||
| CndnContrValidFrom | CndnContrValidFrom | |||
| CndnContrValidTo | CndnContrValidTo | |||
| 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 | |||
| CreationDate | CreationDate | |||
| CreationTime | CreationTime | |||
| CreationTimeZone | CreationTimeZone | |||
| CreationUTCDateTime | CreationUTCDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| LastChangedDate | LastChangedDate | |||
| LastChangeTime | LastChangeTime | |||
| LastChangeUTCDateTime | LastChangeUTCDateTime | |||
| CndnContrCurrency | CndnContrCurrency | |||
| ExchangeRateType | ExchangeRateType | |||
| ExchangeRate | ExchangeRate | |||
| ExchangeRateDate | ExchangeRateDate | |||
| PaymentTerms | PaymentTerms | |||
| CashDiscount1Days | CashDiscount1Days | |||
| CashDiscount1Percent | CashDiscount1Percent | |||
| CashDiscount2Days | CashDiscount2Days | |||
| CashDiscount2Percent | CashDiscount2Percent | |||
| NetPaymentDays | NetPaymentDays | |||
| PaymentMethod | PaymentMethod | |||
| 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 | |||
| SettlmtPartTxRegnCntry | SettlmtPartTxRegnCntry | |||
| CndnContrPrcgDetnRlvnceCat | CndnContrPrcgDetnRlvnceCat | |||
| CndnContrWorkerCostCenter | CndnContrWorkerCostCenter | |||
| CndnContrWorkerSettlmtCat | CndnContrWorkerSettlmtCat | |||
| DataController | DataController | |||
| _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 |
@AbapCatalog: {
sqlViewName: 'ICNDNCNTR',
compiler.compareFilter: true
}
@EndUserText.label: 'Condition Contract'
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA'),
privilegedAssociations: [ '_LastChangedByUser', '_CreatedByUser' ]
}
@ObjectModel: {
representativeKey: 'ConditionContract',
compositionRoot: true,
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [ #ANALYTICAL_DIMENSION,
#CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XXL
}
}
@ClientHandling: {
type: #INHERITED,
algorithm: #SESSION_VARIABLE
}
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction.enabled: false,
internalName: #LOCAL
}
@Metadata: {
ignorePropagatedAnnotations: true,
allowExtensions: true
}
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view I_ConditionContract
as select from R_ConditionContract
association [0..*] to I_CndnContrBusVolSelCriteria as _CndnContrBusVolSelCriteria on $projection.ConditionContract = _CndnContrBusVolSelCriteria.ConditionContract
association [0..*] to I_CndnContrSettlmtCal as _CndnContrSettlmtCal on $projection.ConditionContract = _CndnContrSettlmtCal.ConditionContract
association [0..*] to I_CndnContrConditionUsage as _CndnContrConditionUsage on $projection.ConditionContract = _CndnContrConditionUsage.ConditionContract
association [0..1] to I_CndnContrType as _CndnContrType on $projection.CndnContrType = _CndnContrType.CndnContrType
association [0..1] to I_CndnContrIsInactive as _CndnContrIsInactive on $projection.CndnContrIsInactive = _CndnContrIsInactive.CndnContrIsInactive
association [0..1] to I_ConditionContract as _PrecedingConditionContract on $projection.PrecedingConditionContract = _PrecedingConditionContract.ConditionContract
association [0..1] to I_ConditionDocument as _PrecedingConditionDocument on $projection.PrecedingConditionDocument = _PrecedingConditionDocument.ConditionDocument
//Extension Association
association [1..1] to E_ConditionContract as _Extension on $projection.ConditionContract = _Extension.ConditionContract
{
key ConditionContract,
@ObjectModel.foreignKey.association: '_CndnContrType'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_CndnContrTypeStdVH', element: 'CndnContrType' } }]
}
CndnContrType,
@ObjectModel.foreignKey.association: '_CndnContrClassfctnType'
CndnContrClassfctnType,
@ObjectModel.foreignKey.association: '_CndnContrProcVar'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_CndnContrProcVarStdVH', element: 'CndnContrProcVar' } }]
}
CndnContrProcVar,
DocumentReferenceID,
@VDM.lifecycle: { status: #DEPRECATED, successor: 'CndnContrAssgmtRef' }
CndnContrAssgmtRef as AssignmentReference,
CndnContrAssgmtRef,
ExternalDocumentReferenceID,
CndnContrExternalPartner,
@ObjectModel.foreignKey.association: '_CndnContrIsInactive'
@Semantics.booleanIndicator: false
CndnContrActvtnStatus as CndnContrIsInactive,
@Semantics.businessDate: { from: true }
CndnContrValidFrom,
@Semantics.businessDate: { to: true }
CndnContrValidTo,
@ObjectModel.foreignKey.association: '_Supplier'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_Supplier_VH', element: 'Supplier' } }]
}
Supplier,
@ObjectModel.foreignKey.association: '_Customer'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_Customer_VH', element: 'Customer' } }]
}
Customer,
@ObjectModel.foreignKey.association: '_PriorSupplier'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_Supplier_VH', element: 'Supplier' } }]
}
PriorSupplier,
@Consumption:{
valueHelpDefinition: [{ entity: { name:'I_PersWrkAgrmtSrchHelp_1' , element: 'PersonWorkAgreement' } }]
}
PersonWorkAgreement,
@ObjectModel.foreignKey.association: '_CompanyCode'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } }]
}
CompanyCode,
@ObjectModel.foreignKey.association: '_PurchasingOrganization'
PurchasingOrganization,
@ObjectModel.foreignKey.association: '_PurchasingGroup'
PurchasingGroup,
@ObjectModel.foreignKey.association: '_SalesOrganization'
SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
@ObjectModel.foreignKey.association: '_Division'
Division,
@ObjectModel.foreignKey.association: '_SalesGroup'
SalesGroup,
@ObjectModel.foreignKey.association: '_SalesOffice'
SalesOffice,
@Semantics.user.createdBy: true
CreatedByUser,
@Semantics.systemDate.createdAt: true
CreationDate,
CreationTime,
CreationTimeZone,
@Semantics.systemDateTime.createdAt: true
CreationUTCDateTime,
@Semantics.user.lastChangedBy: true
LastChangedByUser,
@Semantics.systemDate.lastChangedAt: true
LastChangedDate,
LastChangeTime,
@Semantics.systemDateTime.lastChangedAt: true
LastChangeUTCDateTime,
@Semantics.currencyCode: true
@ObjectModel.foreignKey.association: '_CndnContrCurrency'
CndnContrCurrency,
@ObjectModel.foreignKey.association: '_ExchangeRateType'
ExchangeRateType,
ExchangeRate,
ExchangeRateDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount1Percent,
CashDiscount2Days,
CashDiscount2Percent,
NetPaymentDays,
//@ObjectModel.foreignKey.association: '_PaymentMethod'
PaymentMethod,
@ObjectModel.foreignKey.association: '_CndnContrSuplrSettlmtCat'
CndnContrSuplrSettlmtCat,
@ObjectModel.foreignKey.association: '_CndnContrCustSettlmtCat'
CndnContrCustSettlmtCat,
@ObjectModel.foreignKey.association: '_SettlmtProduct'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_ProductStdVH', element: 'Product' } }]
}
SettlmtProduct,
@ObjectModel.foreignKey.association: '_FinalSettlmtCalendar'
FinalSettlmtCalendar,
@ObjectModel.foreignKey.association: '_PartialSettlmtCalendar'
PartialSettlmtCalendar,
@ObjectModel.foreignKey.association: '_DeltaSettlmtCalendar'
DeltaSettlmtCalendar,
@ObjectModel.foreignKey.association: '_DeltaAccrualSettlmtCalendar'
DeltaAccrualSettlmtCalendar,
@ObjectModel.foreignKey.association: '_AccrualClearingSettlmtCal'
AccrualClearingSettlmtCalendar,
@ObjectModel.foreignKey.association: '_CndnContrExtensionCalendar'
CndnContrExtensionCalendar,
@API.element:{releaseState: #DEPRECATED, successor: 'PrecedingConditionDocument'}
@ObjectModel.foreignKey.association: '_PrecedingConditionContract'
@Consumption: {
valueHelpDefinition: [{ entity: { name: 'I_ConditionContractStdVH', element: 'ConditionContract' } }]
}
PrecedingConditionDocument as PrecedingConditionContract,
PrecedingConditionDocument,
@ObjectModel.foreignKey.association: '_CndnContrPurposeCat'
CndnContrPurposeCat,
@ObjectModel.foreignKey.association: '_CndnContrSourceDocCat'
CndnContrSourceDocCat,
CndnContrSourceDoc,
CndnContrSourceDocItem,
@ObjectModel.foreignKey.association: '_BusVolTableGroup'
BusVolTableGroup,
@ObjectModel.foreignKey.association: '_AmountFieldGroup'
AmountFieldGroup,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_CndnContrUnit'
CndnContrUnit,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_CndnContrWeightUnit'
CndnContrWeightUnit,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_CndnContrVolumeUnit'
CndnContrVolumeUnit,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_CndnContrPointsQtyUnit'
CndnContrPointsQtyUnit,
AccrualUpdateIsRequired,
CndnContrUUID,
CndnContrSourceUUID,
SettlmtPartTxRegnNmbr,
TaxCountry,
SettlmtPartTxRegnCntry,
CndnContrPrcgDetnRlvnceCat,
/* Worker related fields */
CndnContrWorkerCostCenter,
CndnContrWorkerSettlmtCat,
DataController,
/* Associations */
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_CndnContrBusVolSelCriteria,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_CndnContrSettlmtCal,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_CndnContrConditionUsage,
_CndnContrType,
_CndnContrClassfctnType,
_CndnContrProcVar,
_CndnContrIsInactive,
_Supplier,
_Customer,
_PriorSupplier,
_PersonWorkAgreement,
_CompanyCode,
_PurchasingOrganization,
_PurchasingGroup,
_SalesOrganization,
_DistributionChannel,
_Division,
_SalesGroup,
_SalesOffice,
_CreatedByUser,
_LastChangedByUser,
_CndnContrCurrency,
_ExchangeRateType,
// _PaymentMethod,
_CndnContrSuplrSettlmtCat,
_CndnContrCustSettlmtCat,
_SettlmtProduct,
_FinalSettlmtCalendar,
_PartialSettlmtCalendar,
_DeltaSettlmtCalendar,
_DeltaAccrualSettlmtCalendar,
_AccrualClearingSettlmtCal,
_CndnContrExtensionCalendar,
@API.element:{releaseState: #DEPRECATED, successor: '_PrecedingConditionDocument'}
_PrecedingConditionContract,
_PrecedingConditionDocument,
_CndnContrPurposeCat,
_CndnContrSourceDocCat,
_BusVolTableGroup,
_AmountFieldGroup,
_CndnContrUnit,
_CndnContrWeightUnit,
_CndnContrVolumeUnit,
_CndnContrPointsQtyUnit,
_TaxCountry,
_SettlmtPartTxRegnCntry,
_CndnContrPrcgDetnRlvnceCat,
_CndnContrWorkerSettlmtCat
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA