I_ConditionContract

DDL: I_CONDITIONCONTRACT Type: view BASIC

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 117 fields with key field ConditionContract. It has 8 associations to related views.

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 (20)

NameValueLevelField
AbapCatalog.sqlViewName ICNDNCNTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 (117)

KeyFieldSource TableSource FieldDescription
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
CndnContrWorkerCostCenter CndnContrWorkerCostCenter
CndnContrWorkerSettlmtCat CndnContrWorkerSettlmtCat
_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
_CndnContrWorkerSettlmtCat _CndnContrWorkerSettlmtCat
@AbapCatalog: {
    sqlViewName: 'ICNDNCNTR',
    compiler.compareFilter: true,
    preserveKey: 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: #B,
      sizeCategory:   #XXL
      }
    }
@ClientHandling: {
    type: #INHERITED,
    algorithm: #SESSION_VARIABLE
    }
@VDM: {
    viewType: #BASIC,
    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,

      /* Worker related fields */
      CndnContrWorkerCostCenter,
      CndnContrWorkerSettlmtCat,

      /* 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,
      _CndnContrWorkerSettlmtCat
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CONDITIONCONTRACT"
],
"ASSOCIATED":
[
"E_CONDITIONCONTRACT",
"I_AMOUNTFIELDGROUP",
"I_BUSVOLTABLEGROUP",
"I_CNDNCONTRBUSVOLSELCRITERIA",
"I_CNDNCONTRCLASSFCTNTYPE",
"I_CNDNCONTRCONDITIONUSAGE",
"I_CNDNCONTRCUSTSETTLMTCAT",
"I_CNDNCONTRISINACTIVE",
"I_CNDNCONTRPROCVAR",
"I_CNDNCONTRPURPOSECAT",
"I_CNDNCONTRSETTLMTCAL",
"I_CNDNCONTRSOURCEDOCCAT",
"I_CNDNCONTRSUPLRSETTLMTCAT",
"I_CNDNCONTRTYPE",
"I_CNDNDOCWORKERSETTLMTCAT",
"I_COMPANYCODE",
"I_CONDITIONDOCUMENT",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EXCHANGERATETYPE",
"I_FACTORYCALENDAR",
"I_PERSONWORKAGREEMENT_1",
"I_PRODUCT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SUPPLIER",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"R_CONDITIONCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/