I_SalesOrderPartner

DDL: I_SALESORDERPARTNER Type: view COMPOSITE

Sales Order Partner

I_SalesOrderPartner is a Composite CDS View that provides data about "Sales Order Partner" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentPartner) and exposes 35 fields with key fields SalesOrder, PartnerFunction.

1 data source(s) 35 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPartner Partner from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order Partner view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSLSORDPT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
KEY PartnerFunction I_SalesDocumentPartner PartnerFunction
Customer I_SalesDocumentPartner Customer
Supplier I_SalesDocumentPartner Supplier
Personnel I_SalesDocumentPartner Personnel
ContactPerson I_SalesDocumentPartner ContactPerson
Partner I_SalesDocumentPartner Partner
FullName I_SalesDocumentPartner FullName
ReferenceBusinessPartner I_SalesDocumentPartner ReferenceBusinessPartner
AddressID I_SalesDocumentPartner AddressID
AddressPersonID I_SalesDocumentPartner AddressPersonID
AddressObjectType I_SalesDocumentPartner AddressObjectType
SDDocPartnerAddressRefType I_SalesDocumentPartner SDDocPartnerAddressRefType
BPAddrDeterminationTransaction I_SalesDocumentPartner BPAddrDeterminationTransaction
BPRefAddressIDForDocSpcfcAddr I_SalesDocumentPartner BPRefAddressIDForDocSpcfcAddr
SDDocPartnerAddrIsDocSpecific I_SalesDocumentPartner SDDocPartnerAddrIsDocSpecific
VATRegistration I_SalesDocumentPartner VATRegistration
UnloadingPointName I_SalesDocumentPartner UnloadingPointName
CorrespondenceLanguage I_SalesDocumentPartner CorrespondenceLanguage
FormOfAddress I_SalesDocumentPartner FormOfAddress
InternationalPhoneNumber I_SalesDocumentPartner InternationalPhoneNumber
InternationalMobilePhoneNumber I_SalesDocumentPartner InternationalMobilePhoneNumber
InternationalFaxNumber I_SalesDocumentPartner InternationalFaxNumber
EmailAddress I_SalesDocumentPartner EmailAddress
_SalesOrder _SalesOrder
_PartnerFunction I_SalesDocumentPartner _PartnerFunction
_ContactPerson I_SalesDocumentPartner _ContactPerson
_Address I_SalesDocumentPartner _Address
_DfltAddrRprstn I_SalesDocumentPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocumentPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocumentPartner _BPRefAddressForDocSpcfcAddr
_PersonAddress I_SalesDocumentPartner _PersonAddress
_PersonName I_SalesDocumentPartner _PersonName
_OrganizationAddress I_SalesDocumentPartner _OrganizationAddress
_OrgNamePostalAddress I_SalesDocumentPartner _OrgNamePostalAddress 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Sales Order Partner'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn', '_PersonAddress', '_PersonName', '_OrganizationAddress', '_OrgNamePostalAddress' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDSLSORDPT',
  compiler.compareFilter: true
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Metadata.ignorePropagatedAnnotations: true

define view I_SalesOrderPartner   
 as select from I_SalesDocumentPartner as Partner
      
    association[1..1] to I_SalesOrder  as _SalesOrder on $projection.SalesOrder   = _SalesOrder.SalesOrder     
    
{
        @ObjectModel.foreignKey.association: '_SalesOrder'                                                                                                   
    key cast(Partner.SalesDocument as vdm_sales_order preserving type) as SalesOrder,             
        @ObjectModel.foreignKey.association: '_PartnerFunction'
    key Partner.PartnerFunction,  
         
        Partner.Customer,          
        Partner.Supplier,           
        Partner.Personnel,           
        Partner.ContactPerson,       
        
        @ObjectModel.text.element: ['FullName']
        Partner.Partner,
        
        @Semantics: {
          text: true,
          name.fullName: true
        }
        Partner.FullName,
       
        Partner.ReferenceBusinessPartner,  
            
        @ObjectModel.foreignKey.association: '_Address'
        Partner.AddressID,
        Partner.AddressPersonID,
        Partner.AddressObjectType,
        Partner.SDDocPartnerAddressRefType,
        Partner.BPAddrDeterminationTransaction,
        Partner.BPRefAddressIDForDocSpcfcAddr, 
        Partner.SDDocPartnerAddrIsDocSpecific,
           
        Partner.VATRegistration,  
        @Semantics.text: true
        Partner.UnloadingPointName,
        
        Partner.CorrespondenceLanguage,
        Partner.FormOfAddress,
        
        Partner.InternationalPhoneNumber,
        Partner.InternationalMobilePhoneNumber,
        Partner.InternationalFaxNumber,
        Partner.EmailAddress,
        
        //Association

        @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]    
        _SalesOrder,
        Partner._PartnerFunction,
        Partner._ContactPerson,
        Partner._Address,
        Partner._DfltAddrRprstn,
        Partner._BusinessPartnerAddress,
        Partner._BPRefAddressForDocSpcfcAddr,
        Partner._PersonAddress,
        Partner._PersonName,
        Partner._OrganizationAddress,
        Partner._OrgNamePostalAddress 

}
where Partner.SDDocumentCategory = 'C';         
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESSPERSONNAME",
"I_ADDRESS_2",
"I_ADDRORGNAMEPOSTALADDRESS",
"I_BUSPARTADDRESS",
"I_CONTACTPERSON",
"I_ORGANIZATIONADDRESS",
"I_PARTNERFUNCTION",
"I_PERSONADDRESS",
"I_SALESORDER"
],
"BASE":
[
"I_SALESDOCUMENTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More