P_SustSlsDocCompletePartner

DDL: P_SUSTSLSDOCCOMPLETEPARTNER Type: view_entity CONSUMPTION

P_SustSlsDocCompletePartner is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (vbpa) and exposes 7 fields with key fields SDDocument, SDDocumentItem, PartnerFunction. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
vbpa vbpa from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Address_2 _DfltAddrRprstn $projection.AddressID = _DfltAddrRprstn.AddressID and $projection.AddressPersonID = _DfltAddrRprstn.AddressPersonID and _DfltAddrRprstn.AddressRepresentationCode is initial

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SDDocument vbpa vbeln
KEY SDDocumentItem vbpa posnr
KEY PartnerFunction
AddressID vbpa adrnr
AddressPersonID vbpa adrnp
SDDocPartnerAddressRefType vbpa adrda
_DfltAddrRprstn _DfltAddrRprstn 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view entity P_SustSlsDocCompletePartner as select from vbpa

 association [0..1] to I_Address_2              as _DfltAddrRprstn                on  $projection.AddressID                     = _DfltAddrRprstn.AddressID
                                                                                  and $projection.AddressPersonID               = _DfltAddrRprstn.AddressPersonID
                                                                                  and _DfltAddrRprstn.AddressRepresentationCode is initial

{
  key vbpa.vbeln          as SDDocument,
  key vbpa.posnr          as SDDocumentItem,
  key cast(vbpa.parvw as parvw_unv) as PartnerFunction,

      // Address related fields

      @ObjectModel.foreignKey.association: '_DfltAddrRprstn'
      vbpa.adrnr          as AddressID,
      vbpa.adrnp          as AddressPersonID,
      vbpa.adrda          as SDDocPartnerAddressRefType,

      // Address related associations

      _DfltAddrRprstn
}

Learn More