I_CUSTOMERRETURNPARTNER

CDS View

Returns Order Partner

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

Used by 3 CDS view(s) 27 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SDDocumentCustomer view from CONSUMPTION Business Partners
R_CustomerReturnPartnerTP view_entity from TRANSACTIONAL Returns Order Partner - TP
R_CustomerReturnShipToPartyTP view_entity from TRANSACTIONAL Returns Order Ship-to Party - TP

Fields (27)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn,SDDocument 2
KEY PartnerFunction PartnerFunction 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 3
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' ]
}
@AbapCatalog: {
  preserveKey: true,
  sqlViewName: 'ISDCUSTRETPART',
  compiler.compareFilter: true
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@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';         
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESSPERSONNAME",
"I_ADDRESS_2",
"I_ADDRORGNAMEPOSTALADDRESS",
"I_BUSPARTADDRESS",
"I_CONTACTPERSON",
"I_CUSTOMERRETURN",
"I_ORGANIZATIONADDRESS",
"I_PARTNERFUNCTION",
"I_PERSONADDRESS"
],
"BASE":
[
"I_SALESDOCUMENTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More