I_CONDITIONCONTRACT

CDS View

Condition Contract

I_CONDITIONCONTRACT is a CDS View in S/4HANA. Condition Contract. It contains 75 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
C_CndnContrOPg view from CONSUMPTION Condition Contract Object Page
C_CndnContrWrkflwRel view from CONSUMPTION cds-view to release workflow scenarios for CndnContr
C_CndnContrWrkflwRelReWrk view from CONSUMPTION cds-view to rework workflow scenarios for CndnContr
C_CndnContrWrkflwSettlmtRel view from CONSUMPTION cds-view to release settlmt workflow scenarios for CndnContr
C_CndnContrWrkflwSettlmtReWrk view from CONSUMPTION cds-view to rework settlmt workflow scenarios for CndnContr
C_MngCustCndnContr view from CONSUMPTION Monitor Customer Condition Contracts
C_MngSuplrCndnContr view from CONSUMPTION Monitor Supplier Condition Contracts
C_MntrRoytyCndnContr view from CONSUMPTION Monitor Royalty Condition Contracts
ESH_B_CNDNCONTR view from Enterprise Search for Condition Contracts "Basicview"
I_CndnContrCustomerListStdVH view from COMPOSITE Condition Contract Customer List
I_CndnContrCustomerStdVH view from COMPOSITE Customer Condition Contracts
I_CndnContrExtSlsCommsnStdVH view_entity from COMPOSITE External Sales Commissions
I_CndnContrPlantListStdVH view from COMPOSITE Condition Contract Plant List
I_CndnContrPurgRbteStdVH view_entity from COMPOSITE Purchasing Rebate Condition Contracts
I_CndnContrRoyaltyStdVH view from COMPOSITE Royalty Condition Contracts
I_CndnContrSupplierListStdVH view from COMPOSITE Condition Contract Supplier List
I_CndnContrSupplierStdVH view from COMPOSITE Supplier Condition Contracts
I_ConditionContractStdVH view from COMPOSITE Condition Contract
I_TrdCndnContrChkBook view from COMPOSITE TMA Condition Contract Checkbook
P_CndnContrOPg view from CONSUMPTION Enhanced View for C_CndnContrOPg
R_CndnContrActiveStatus view inner BASIC Active Status of Condition Contract
R_CndnContrPlainLongText view inner BASIC Plain Long Texts of a Condition Contract

Fields (75)

KeyField CDS FieldsUsed in Views
KEY ConditionContract ConditionContract 18
_CndnContrClassfctnType _CndnContrClassfctnType 4
_CndnContrCurrency _CndnContrCurrency 3
_CndnContrIsInactive _CndnContrIsInactive 3
_CndnContrPointsQtyUnit _CndnContrPointsQtyUnit 3
_CndnContrProcVar _CndnContrProcVar 3
_CndnContrPurposeCat _CndnContrPurposeCat 3
_CndnContrSourceDocCat _CndnContrSourceDocCat 3
_CndnContrType _CndnContrType 3
_CndnContrUnit _CndnContrUnit 3
_CndnContrVolumeUnit _CndnContrVolumeUnit 3
_CndnContrWeightUnit _CndnContrWeightUnit 3
_CompanyCode _CompanyCode 3
_Customer _Customer 8
_DistributionChannel _DistributionChannel 3
_Division _Division 3
_PersonWorkAgreement _PersonWorkAgreement 8
_PriorSupplier _PriorSupplier 8
_PurchasingGroup _PurchasingGroup 3
_PurchasingOrganization _PurchasingOrganization 3
_SalesGroup _SalesGroup 3
_SalesOffice _SalesOffice 3
_SalesOrganization _SalesOrganization 3
_SettlmtProduct _SettlmtProduct 3
_Supplier _Supplier 8
AccrualUpdateIsRequired AccrualUpdateIsRequired 3
AmountFieldGroup AmountFieldGroup 1
AssignmentReference AssignmentReference 1
CashDiscount1Days CashDiscount1Days 3
CashDiscount1Percent CashDiscount1Percent 3
CashDiscount2Days CashDiscount2Days 3
CashDiscount2Percent CashDiscount2Percent 3
CndnContrAssgmtRef CndnContrAssgmtRef 3
CndnContrClassfctnType CndnContrClassfctnType 5
CndnContrCurrency CndnContrCurrency 4
CndnContrCustSettlmtCat CndnContrCustSettlmtCat 1
CndnContrExtensionCalendar CndnContrExtensionCalendar 1
CndnContrExternalPartner CndnContrExternalPartner 4
CndnContrIsInactive CndnContrIsInactive 9
CndnContrPointsQtyUnit CndnContrPointsQtyUnit 3
CndnContrProcVar CndnContrProcVar 3
CndnContrPurposeCat CndnContrPurposeCat 4
CndnContrSourceDoc CndnContrSourceDoc 4
CndnContrSourceDocCat CndnContrSourceDocCat 4
CndnContrSourceUUID CndnContrSourceUUID 3
CndnContrType CndnContrType 13
CndnContrUnit CndnContrUnit 3
CndnContrUUID CndnContrUUID 4
CndnContrValidFrom CndnContrValidFrom 17
CndnContrValidTo CndnContrValidTo 17
CndnContrVolumeUnit CndnContrVolumeUnit 3
CndnContrWeightUnit CndnContrWeightUnit 3
CndnContrWorkerCostCenter CndnContrWorkerCostCenter 13
CompanyCode CompanyCode 10
CreatedByUser CreatedByUser 5
CreationDate CreationDate 2
Customer Customer 14
DistributionChannel DistributionChannel 13
Division Division 13
DocumentReferenceID DocumentReferenceID 4
ExternalDocumentReferenceID ExternalDocumentReferenceID 10
LastChangedByUser LastChangedByUser 4
LastChangedDate LastChangedDate 1
NetPaymentDays NetPaymentDays 3
PaymentMethod PaymentMethod 4
PaymentTerms PaymentTerms 3
PersonWorkAgreement PersonWorkAgreement 13
PriorSupplier PriorSupplier 12
PurchasingGroup PurchasingGroup 12
PurchasingOrganization PurchasingOrganization 12
SalesGroup SalesGroup 4
SalesOffice SalesOffice 4
SalesOrganization SalesOrganization 13
SettlmtProduct SettlmtProduct 4
Supplier Supplier 13
@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":""
}
}*/