I_CUSTOMERRETURNPARTNER

CDS View

Returns Order Partner

I_CUSTOMERRETURNPARTNER is a CDS View in S/4HANA. Returns Order Partner. It contains 26 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 26 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_CustomerReturnPartnerTP view_entity from TRANSACTIONAL Returns Order Partner - TP
R_CustomerReturnShipToPartyTP view_entity from TRANSACTIONAL Returns Order Ship-to Party - TP

Fields (26)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 1
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 1
_BusinessPartnerAddress _BusinessPartnerAddress 1
_DfltAddrRprstn _DfltAddrRprstn 1
AddressID AddressID 2
AddressObjectType AddressObjectType 2
AddressPersonID AddressPersonID 2
BPAddrDeterminationTransaction BPAddrDeterminationTransaction 1
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr 1
ContactPerson ContactPerson 1
CorrespondenceLanguage CorrespondenceLanguage 2
Customer Customer,Partner 2
EmailAddress EmailAddress 2
FormOfAddress FormOfAddress 2
FullName FullName 2
InternationalFaxNumber InternationalFaxNumber 2
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 1
InternationalPhoneNumber InternationalMobilePhoneNumber,InternationalPhoneNumber 2
Partner Partner 1
Personnel Personnel 1
ReferenceBusinessPartner ReferenceBusinessPartner 1
SDDocPartnerAddressRefType SDDocPartnerAddressRefType 1
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 2
Supplier Supplier 1
UnloadingPointName UnloadingPointName 2
VATRegistration VATRegistration 2 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Returns 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: {
  preserveKey: true,
  sqlViewName: 'ISDCUSTRETPART',
  compiler.compareFilter: true
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Consumption.dbHints: [ 'USE_HEX_PLAN', 'NO_SUBPLAN_SHARING' ]
@Metadata.ignorePropagatedAnnotations: true

define view I_CustomerReturnPartner 
as select from I_SalesDocumentPartner  as Partner
      
association[1..1] to I_CustomerReturn  as _CustomerReturn  on $projection.CustomerReturn = _CustomerReturn.CustomerReturn     
    
{
        @ObjectModel.foreignKey.association: '_CustomerReturn'                                                                                                   
    key cast(SalesDocument as vdm_customer_return preserving type) as CustomerReturn,             
        @ObjectModel.foreignKey.association: '_PartnerFunction'
    key PartnerFunction,       
        Customer,          
        Supplier,           
        Personnel,  
        ContactPerson,
        @ObjectModel.text.element: ['FullName']        
        Partner,
        @Semantics: {
          text: true,
          name.fullName: true
        }
        FullName,
        ReferenceBusinessPartner,
                           
        @ObjectModel.foreignKey.association: '_Address'
        AddressID,   
        AddressPersonID,
        AddressObjectType,
        SDDocPartnerAddressRefType,
        BPAddrDeterminationTransaction,
        BPRefAddressIDForDocSpcfcAddr,                
        
        SDDocPartnerAddrIsDocSpecific,
        VATRegistration,  
        @Semantics.text: true
        UnloadingPointName, 

        CorrespondenceLanguage,
        FormOfAddress,
        
        InternationalPhoneNumber,
        InternationalMobilePhoneNumber,
        InternationalFaxNumber,
        EmailAddress,
        
        //Association

        @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]    
        _CustomerReturn,
        _PartnerFunction,
        _ContactPerson,
        _Address,
        _DfltAddrRprstn,
        _BusinessPartnerAddress,
        _BPRefAddressForDocSpcfcAddr,
        _PersonAddress,
        _PersonName,
        _OrganizationAddress,
        _OrgNamePostalAddress  
}
where SDDocumentCategory = 'H';

Learn More