I_CONDITIONCONTRACT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/