I_COMMSNCONTRTARGETAGRMTBYTIME
Target Agreement by Time
I_COMMSNCONTRTARGETAGRMTBYTIME is a CDS View in S/4HANA. Target Agreement by Time. It contains 15 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CommsnContrTargetAgreement | view_entity | from | CONSUMPTION | Target Agreement |
Fields (15)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CommissionApplication | CommissionApplication | 1 |
| KEY | CommissionContract | CommissionContract | 1 |
| KEY | CommissionContractAgreement | CommissionContractAgreement | 1 |
| KEY | CommissionStandardAgreement | CommissionStandardAgreement | 1 |
| KEY | CommsnContrEffctvFrmDateTime | CommsnContrEffctvFrmDateTime | 1 |
| KEY | CommsnContrEffctvToDateTime | CommsnContrEffctvToDateTime | 1 |
| CommissionContractCurrency | CommissionContractCurrency | 1 | |
| CommissionContractVersion | CommissionContractVersion | 1 | |
| CommissionVersionIsInvalid | CommissionVersionIsInvalid | 1 | |
| CommsnAgrmtEffctvFrmDteTme | CommsnAgrmtEffctvFrmDteTme | 1 | |
| CommsnAgrmtEffctvToDteTme | CommsnAgrmtEffctvToDteTme | 1 | |
| CommsnContractAgreementVersion | CommsnContractAgreementVersion | 1 | |
| CommsnContrAgreementIsLocked | CommsnContrAgreementIsLocked | 1 | |
| CommsnContrAgreementRule | CommsnContrAgreementRule | 1 | |
| CommsnContrChangeReason | CommsnContrChangeReason | 1 |
@EndUserText.label: 'Target Agreement by Time'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.sapObjectNodeType.name: 'CommsnContractTargetAgreement'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
define view entity I_CommsnContrTargetAgrmtByTime
as select from I_CommsnContrCompByTimePeriod as CommsnContrCompByTimePeriod
association [1..1] to I_CommsnContrTargetAgreement as _CommsnTargetAgrmt on CommsnContrCompByTimePeriod.CommissionApplication = _CommsnTargetAgrmt.CommissionApplication
and CommsnContrCompByTimePeriod.CommissionContract = _CommsnTargetAgrmt.CommissionContract
and CommsnContrCompByTimePeriod.CommsnContractAgreementVersion = _CommsnTargetAgrmt.CommsnContractAgreementVersion
and CommsnContrCompByTimePeriod.CommissionStandardAgreement = _CommsnTargetAgrmt.CommissionStandardAgreement
and CommsnContrCompByTimePeriod.CommissionContractAgreement = _CommsnTargetAgrmt.CommissionContractAgreement
{
key CommsnContrCompByTimePeriod.CommissionApplication as CommissionApplication,
key CommsnContrCompByTimePeriod.CommissionContract as CommissionContract,
key CommsnContrCompByTimePeriod.CommsnContrEffctvFrmDateTime as CommsnContrEffctvFrmDateTime,
key CommsnContrCompByTimePeriod.CommsnContrEffctvToDateTime as CommsnContrEffctvToDateTime,
key CommsnContrCompByTimePeriod.CommissionStandardAgreement as CommissionStandardAgreement,
key CommsnContrCompByTimePeriod.CommissionContractAgreement as CommissionContractAgreement,
key _CommsnTargetAgrmt.CommsnAgrmtEffctvFrmDteTme as CommsnAgrmtEffctvFrmDteTme,
_CommsnTargetAgrmt.CommsnAgrmtEffctvToDteTme as CommsnAgrmtEffctvToDteTme,
CommsnContrCompByTimePeriod.CommissionContractVersion as CommissionContractVersion,
CommsnContrCompByTimePeriod.CommsnContrAgreementRule as CommsnContrAgreementRule,
CommsnContrCompByTimePeriod.CommsnContractAgreementVersion as CommsnContractAgreementVersion,
CommsnContrCompByTimePeriod.CommissionContractCurrency as CommissionContractCurrency,
CommsnContrCompByTimePeriod.CommsnContrChangeReason as CommsnContrChangeReason,
_CommsnTargetAgrmt.CommissionVersionIsInvalid as CommissionVersionIsInvalid,
_CommsnTargetAgrmt.CommsnContrAgreementIsLocked as CommsnContrAgreementIsLocked
}
where
CommissionContractComponent = 'TA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMSNCONTRCOMPBYTIMEPERIOD",
"I_COMMSNCONTRTARGETAGREEMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/