I_SLSCONTRADDLCOMPLETEPARTNERS

CDS View

SD Document Additional Complete Partners

I_SLSCONTRADDLCOMPLETEPARTNERS is a CDS View in S/4HANA. SD Document Additional Complete Partners. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SalesContractPartner view union_all COMPOSITE Sales Contract Partner 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SD Document Additional Complete Partners'
@VDM.viewType: #BASIC
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #REQUIRED,
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDCNTRACOMPPART',
  compiler.compareFilter: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}

define view I_SlsContrAddlCompletePartners
  as

  select from vbpa2

  association [0..1] to I_SalesDocumentBasic     as _SalesDocument          on  $projection.SDDocument = _SalesDocument.SalesDocument
  association [0..1] to I_PartnerFunction        as _PartnerFunction        on  $projection.PartnerFunction = _PartnerFunction.PartnerFunction
  association [0..1] to I_Address                as _Address                on  $projection.AddressID = _Address.AddressID
  association [0..1] to I_Address_2              as _DfltAddrRprstn         on  $projection.AddressID                     = _DfltAddrRprstn.AddressID
                                                                            and $projection.AddressPersonID               = _DfltAddrRprstn.AddressPersonID
                                                                            and _DfltAddrRprstn.AddressRepresentationCode is initial
  association [0..1] to I_BusPartAddress as _BusinessPartnerAddress
    on $projection.ReferenceBusinessPartner = _BusinessPartnerAddress.BusinessPartner
    and $projection.AddressID = _BusinessPartnerAddress.AddressID
    and $projection.SDDocPartnerAddressRefType = 'H'
  association [0..1] to I_BusPartAddress as _BPRefAddressForDocSpcfcAddr
    on $projection.ReferenceBusinessPartner = _BPRefAddressForDocSpcfcAddr.BusinessPartner
    and $projection.BPRefAddressIDForDocSpcfcAddr = _BPRefAddressForDocSpcfcAddr.AddressID
{
  key vbeln as SDDocument,
  key posnr as SDDocumentItem,
  @ObjectModel.foreignKey.association: '_PartnerFunction'
  key parvw as PartnerFunction,
  key cntpa as SDDocPartnerSequenceNumber,

      case
        when _PartnerFunction.SDDocumentPartnerType = 'PE' // Personnel Number

          then ''
        else
          left(partner, 10)
      end             as Customer,

      cast( case
        when _PartnerFunction.SDDocumentPartnerType = 'PE' // Personnel Number

          then left(partner, 8)
        else
          '00000000'
      end as pernr_d) as Personnel,

      // assigned_bp as BusinessPartner,

      assigned_bp     as ReferenceBusinessPartner,

      @ObjectModel.foreignKey.association: '_Address'
      adrnr           as AddressID,

      adrnp           as PersonNumber, // To be deprecated.

      adrnp           as AddressPersonID,
      adrda           as SDDocPartnerAddressRefType,
      addr_type       as AddressObjectType,
      addr_operation  as BPAddrDeterminationTransaction,
      bp_ref_adrnr    as BPRefAddressIDForDocSpcfcAddr,

      _SalesDocument,
      _PartnerFunction,

      _Address,
      _DfltAddrRprstn,
      _BusinessPartnerAddress,
      _BPRefAddressForDocSpcfcAddr
}
where
  _SalesDocument.SDDocumentCategory = 'G' // Contract

Learn More