P_SalesDocItemInheritedPartner

DDL: P_SALESDOCITEMINHERITEDPARTNER Type: view COMPOSITE

P_SalesDocItemInheritedPartner is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_SalesDocumentItem, I_SalesDocumentItemPartner, I_SalesDocumentPartner) and exposes 23 fields with key fields SalesDocument, SalesDocumentItem, PartnerFunction.

3 data source(s) 23 fields

Data Sources (3)

SourceAliasJoin Type
I_SalesDocumentItem _Item from
I_SalesDocumentItemPartner _ItemPartner left_outer
I_SalesDocumentPartner _Partner inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSLSDOCITMINHPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentPartner SalesDocument
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem
KEY PartnerFunction I_SalesDocumentPartner PartnerFunction
Customer I_SalesDocumentPartner Customer
Supplier I_SalesDocumentPartner Supplier
ContactPerson I_SalesDocumentPartner ContactPerson
ReferenceBusinessPartner I_SalesDocumentPartner ReferenceBusinessPartner
Personnel I_SalesDocumentPartner Personnel
AddressID I_SalesDocumentPartner AddressID
AddressPersonID I_SalesDocumentPartner AddressPersonID
AddressObjectType I_SalesDocumentPartner AddressObjectType
SDDocPartnerAddressRefType I_SalesDocumentPartner SDDocPartnerAddressRefType
BPAddrDeterminationTransaction I_SalesDocumentPartner BPAddrDeterminationTransaction
BPRefAddressIDForDocSpcfcAddr I_SalesDocumentPartner BPRefAddressIDForDocSpcfcAddr
VATRegistration I_SalesDocumentPartner VATRegistration
UnloadingPointName I_SalesDocumentPartner UnloadingPointName
_Address I_SalesDocumentPartner _Address
_DfltAddrRprstn I_SalesDocumentPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocumentPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocumentPartner _BPRefAddressForDocSpcfcAddr
_SalesDocument I_SalesDocumentPartner _SalesDocument
_PartnerFunction I_SalesDocumentPartner _PartnerFunction
_ContactPerson I_SalesDocumentPartner _ContactPerson 
@AbapCatalog: {
  sqlViewName: 'PSLSDOCITMINHPT',
  compiler.compareFilter: true,
  preserveKey: true
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}

@VDM: {
  private: true,
  viewType: #COMPOSITE
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_SalesDocItemInheritedPartner 
  as select from I_SalesDocumentItem         as _Item
  
  inner join I_SalesDocumentPartner          as _Partner on _Item.SalesDocument = _Partner.SalesDocument
  
  left outer join I_SalesDocumentItemPartner as _ItemPartner on _Partner.SalesDocument   = _ItemPartner.SalesDocument
                                                            and _Item.SalesDocumentItem  = _ItemPartner.SalesDocumentItem
                                                            and _Partner.PartnerFunction = _ItemPartner.PartnerFunction
                                                            
{
  key _Partner.SalesDocument,
  
  key _Item.SalesDocumentItem,
  
  key _Partner.PartnerFunction,
  
      _Partner.Customer,
      
      _Partner.Supplier,
      
      _Partner.ContactPerson,
      
      _Partner.ReferenceBusinessPartner,
      
      _Partner.Personnel,
      
      _Partner.AddressID,
      
      _Partner.AddressPersonID,
      
      _Partner.AddressObjectType,
      
      _Partner.SDDocPartnerAddressRefType,
      
      _Partner.BPAddrDeterminationTransaction,
      
      _Partner.BPRefAddressIDForDocSpcfcAddr,
      
      _Partner.VATRegistration,
      
      _Partner.UnloadingPointName,
      
      _Partner._Address,
      
      _Partner._DfltAddrRprstn,
      
      _Partner._BusinessPartnerAddress,
      
      _Partner._BPRefAddressForDocSpcfcAddr,
      
      _Partner._SalesDocument,
      
      _Partner._PartnerFunction,
      
      _Partner._ContactPerson
} 

  where _ItemPartner.PartnerFunction is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMPARTNER",
"I_SALESDOCUMENTPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_BUSPARTADDRESS",
"I_CONTACTPERSON",
"I_PARTNERFUNCTION",
"I_SALESDOCUMENT"
],
"BASE":
[
"I_SALESDOCUMENTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More