I_CUSTOMERRETURNPARTNER

CDS View
27 Fields 3 CDS Views

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.

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Returns Order Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMERRETURNPARTNER (
    CUSTOMERRETURN,
    PARTNERFUNCTION,
    _BPREFADDRESSFORDOCSPCFCADDR,
    _BUSINESSPARTNERADDRESS,
    _DFLTADDRRPRSTN,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    BPADDRDETERMINATIONTRANSACTION,
    BPREFADDRESSIDFORDOCSPCFCADDR,
    CONTACTPERSON,
    CORRESPONDENCELANGUAGE,
    CUSTOMER,
    EMAILADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    PARTNER,
    PERSONNEL,
    REFERENCEBUSINESSPARTNER,
    SDDOCPARTNERADDRESSREFTYPE,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    PRIMARY KEY (CUSTOMERRETURN, PARTNERFUNCTION)
);

Learn More