P_SDDocItemPartnerComplete

DDL: P_SDDOCITEMPARTNERCOMPLETE SQL: PSDOCITPARTCMPLT Type: view CONSUMPTION

P_SDDocItemPartnerComplete is a Consumption CDS View in SAP S/4HANA. It reads from 5 data sources (I_SDDocumentCompletePartners, I_SDDocumentItemPartner, I_SDDocumentItemPartner, I_SalesDocumentItem, I_SalesDocumentItem) and exposes 25 fields. It has 1 association to related views.

5 data source(s) 25 fields

Data Sources (5)

SourceAliasJoin Type
I_SDDocumentCompletePartners CompletePartner from
I_SDDocumentItemPartner ItemPartner left_outer
I_SDDocumentItemPartner ItemPartner union
I_SalesDocumentItem SDI left_outer
I_SalesDocumentItem SDI left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSDOCITPARTCMPLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (25)

KeyFieldSource TableSource FieldDescription
SDDocument I_SDDocumentCompletePartners SDDocument
SDDocumentItem I_SDDocumentCompletePartners SDDocumentItem
PartnerFunction I_SDDocumentCompletePartners PartnerFunction
CustomerendasCustomer
Personnel I_SDDocumentCompletePartners Personnel
AddressID I_SDDocumentCompletePartners AddressID
AddressPersonID I_SDDocumentCompletePartners AddressPersonID
ContactPerson I_SDDocumentCompletePartners ContactPerson
_PartnerFunction I_SDDocumentCompletePartners _PartnerFunction
_Customer _Customer
_Address I_SDDocumentCompletePartners _Address
_DfltAddrRprstn I_SDDocumentCompletePartners _DfltAddrRprstn
SDDocument
SDDocumentItem I_SDDocumentItemPartner SDDocumentItem
PartnerFunction I_SDDocumentItemPartner PartnerFunction
CustomerendasCustomer
Personnel I_SDDocumentItemPartner Personnel
AddressID I_SDDocumentItemPartner AddressID
AddressPersonID I_SDDocumentItemPartner AddressPersonID
ContactPerson I_SDDocumentItemPartner ContactPerson
_PartnerFunction I_SDDocumentItemPartner _PartnerFunction
_Customer _Customer
_Address I_SDDocumentItemPartner _Address
_DfltAddrRprstn I_SDDocumentItemPartner _DfltAddrRprstn
SalesDocumentItem I_SalesDocumentItem SalesDocumentItem 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PSDOCITPARTCMPLT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_SDDocItemPartnerComplete
  as select from    I_SDDocumentCompletePartners as CompletePartner
    left outer join I_SDDocumentItemPartner      as ItemPartner on  CompletePartner.SDDocument      = ItemPartner.SDDocument
                                                                and CompletePartner.PartnerFunction = ItemPartner.PartnerFunction
    left outer join I_SalesDocumentItem          as SDI         on CompletePartner.SDDocument = SDI.SalesDocument

  association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
{
  CompletePartner.SDDocument,
  CompletePartner.SDDocumentItem,
  CompletePartner.PartnerFunction,
  case when CompletePartner.Supplier <> ''
    then CompletePartner.Supplier
    else CompletePartner.Customer
  end as Customer,
  CompletePartner.Personnel,
  CompletePartner.AddressID,
  CompletePartner.AddressPersonID,
  CompletePartner.ContactPerson,
  CompletePartner._PartnerFunction,
  _Customer,
  CompletePartner._Address,
  CompletePartner._DfltAddrRprstn,
  SDI.SalesDocumentItem
}
where
  (ItemPartner.SDDocument is null
   or (
           CompletePartner.SDDocumentItem != ItemPartner.SDDocumentItem
       and SDI.SalesDocumentItem != ItemPartner.SDDocumentItem
      )
  )
  and  ( CompletePartner._PartnerFunction.SDDocumentPartnerType = 'KU' 
            or CompletePartner._PartnerFunction.SDDocumentPartnerType = 'LI' )
  
union 

select from I_SDDocumentItemPartner      as ItemPartner
  left outer join I_SalesDocumentItem     as SDI on ItemPartner.SDDocument = SDI.SalesDocument
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
{
  ItemPartner.SDDocument,
  ItemPartner.SDDocumentItem,
  ItemPartner.PartnerFunction,
  case when ItemPartner.Supplier <> ''
    then ItemPartner.Supplier
    else ItemPartner.Customer
  end as Customer,
  ItemPartner.Personnel,
  ItemPartner.AddressID,
  ItemPartner.AddressPersonID,
  ItemPartner.ContactPerson,
  ItemPartner._PartnerFunction,
  _Customer,
  ItemPartner._Address,
  ItemPartner._DfltAddrRprstn,
  SDI.SalesDocumentItem
}
where
  (SDI.SalesDocumentItem = ItemPartner.SDDocumentItem
   and (
          ItemPartner._PartnerFunction.SDDocumentPartnerType = 'KU'
       or ItemPartner._PartnerFunction.SDDocumentPartnerType = 'LI'
       )
   )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PARTNERFUNCTION",
"I_SALESDOCUMENTITEM",
"I_SDDOCUMENTCOMPLETEPARTNERS",
"I_SDDOCUMENTITEMPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_CUSTOMER",
"I_PARTNERFUNCTION"
],
"BASE":
[
"I_SDDOCUMENTCOMPLETEPARTNERS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More