R_ACMTRDGCONTRDPQSCHARCRANGETP

CDS View

ACM DPQS Characteristic Range

R_ACMTRDGCONTRDPQSCHARCRANGETP is a CDS View in S/4HANA. ACM DPQS Characteristic Range. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ACMTrdgContrDPQSCharcRange view_entity projection CONSUMPTION ACM DPQS Characteristic Range Entity 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel:{
              usageType: {
                dataClass: #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory: #L
              }
}
@AccessControl.personalData.blocking: #REQUIRED
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@EndUserText.label: 'ACM DPQS Characteristic Range'
define view entity R_ACMTrdgContrDPQSCharcRangeTP
  as select from I_DiscPremQltyOvrCharRange
  association [0..*] to R_ACMTrdgContrDPQSHeaderTP       as _DPQS               on  $projection.DiscPremQtyScheduleUUID = _DPQS.DiscPremQtyScheduleUUID

  association        to parent R_ACMTrdgContrDPQSCharcTP as _DPQSCharacteristic on  $projection.DiscPremQtyScheduleUUID = _DPQSCharacteristic.DiscPremQtyScheduleUUID
                                                                                and $projection.DiscPremQtyCharcsUUID   = _DPQSCharacteristic.DiscPremQtyCharcsUUID
                                                                                and $projection.TradingContractNumber   = _DPQSCharacteristic.TradingContractNumber
                                                                                and $projection.TradingContractItem     = _DPQSCharacteristic.TradingContractItem
  association [1..1] to R_ACMTrdgContrItmDetTP           as _ContractItem       on  $projection.TradingContractNumber = _ContractItem.TradingContractNumber
                                                                                and $projection.TradingContractItem   = _ContractItem.TradingContractItem
  association [1..1] to R_ACMTrdgContrHdrTP              as _ContractHeader     on  $projection.TradingContractNumber = _ContractHeader.TradingContractNumber

{
  key DiscPremQtyScheduleUUID,
  key DiscPremQtyCharcsUUID,
  key DiscPremQtyCharcsRangeUUID,
  key _DPQS.TradingContractNumber as TradingContractNumber,
  key _DPQS.TradingContractItem   as TradingContractItem,
      DiscPremQtyMinRangeVal,
      DiscPremQtyMaxRangeVal,
      DiscPremQtySchedCharcsVal,
      DiscPremQtyIncrmtVal,
      DiscPremQtyValChrgTxt,
      DiscPremQtyActionCode,
      PremDiscRateInValSchedCrcy,

      //Associations

      _DPQSCharacteristic,
      _ContractItem,
      _ContractHeader
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DISCPREMQLTYOVRCHARRANGE",
"R_ACMTRDGCONTRDPQSHEADERTP"
],
"ASSOCIATED":
[
"R_ACMTRDGCONTRDPQSCHARCTP",
"R_ACMTRDGCONTRHDRTP",
"R_ACMTRDGCONTRITMDETTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More