R_ACMTRDGCONTRDPQSCHARCTP

CDS View

ACM DPQS Charecteristics

R_ACMTRDGCONTRDPQSCHARCTP is a CDS View in S/4HANA. ACM DPQS Charecteristics. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ACMTrdgContrDPQSCharc view_entity projection CONSUMPTION ACM DPQS Characteristic 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 Charecteristics'
define view entity R_ACMTrdgContrDPQSCharcTP
  as select from I_ACM_DPQSCharacteristics  as DPQSCharacteristics
  //association [0..1] to I_ACMTrdgContrDPQSHeaderInfo      as _DPQSHeaderInfo1 on  $projection.DiscPremQtyScheduleUUID = _DPQSHeaderInfo1.DiscPremQtyScheduleUUID

    inner join   R_ACMTrdgContrDPQSHeaderTP as DPQSHeaderInfo on DPQSCharacteristics.DiscPremQtyScheduleUUID = DPQSHeaderInfo.DiscPremQtyScheduleUUID
  composition [*] of R_ACMTrdgContrDPQSCharcRangeTP as _DPQSCharacteristicRange
  association        to parent R_ACMTrdgContrDPQSHeaderTP  as _DPQS    on  $projection.TradingContractNumber = _DPQS.TradingContractNumber
                                                                       and $projection.TradingContractItem   = _DPQS.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 DPQSCharacteristics.DiscPremQtyScheduleUUID                     as DiscPremQtyScheduleUUID,
  key DPQSCharacteristics.DiscPremQtyCharcsUUID                       as DiscPremQtyCharcsUUID,
  key DPQSHeaderInfo.TradingContractNumber                            as TradingContractNumber,
  key DPQSHeaderInfo.TradingContractItem                              as TradingContractItem,
      cast(DPQSCharacteristics.DiscPremQtyIntChar as abap.numc( 10 )) as DiscPremQtyIntChar,
      DPQSCharacteristics.ACMSettlmtUnitFullShptQtyUnit               as ACMSettlmtUnitFullShptQtyUnit,
      DPQSCharacteristics.ACMSettlementSequenceNmbr                   as ACMSettlementSequenceNmbr,
      DPQSCharacteristics.DiscPremQtyCalcMethodCode                   as DiscPremQtyCalcMethodCode,
      DPQSCharacteristics.DiscPremQtyRateType                         as DiscPremQtyRateType,
      DPQSCharacteristics.DiscPremQtyAppliesToCode                    as DiscPremQtyAppliesToCode,
      DPQSCharacteristics.DiscPremQtyType                             as DiscPremQtyType,
      DPQSCharacteristics.DiscPremQtyRoundingDirection                as DiscPremQtyRoundingDirection,
      DPQSCharacteristics.DiscPremAnalysisReq                         as DiscPremAnalysisReq,
      
      //Association

      _DPQS,
      _DPQSCharacteristicRange,
      _ContractItem,
      _ContractHeader
}

Learn More