I_DebitMemoReqPartner

DDL: I_DEBITMEMOREQPARTNER Type: view COMPOSITE
34 Fields 1 Data Sources

Debit Memo Request Partner

I_DebitMemoReqPartner (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_DebitMemoReqPartner is a Composite CDS View that provides data about "Debit Memo Request Partner" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentPartner) and exposes 34 fields with key fields DebitMemoRequest, PartnerFunction.

SAP Help Documentation

CategoryDebit Memo Requests
StatusReleased
Purpose
This CDS view provides the prerequisites for answering questions about partners in debit memo requests at header level. Example business questions could include the following: Which partner functions exist for a given debit memo request? What is the partner address of a given debit memo request?

Prerequisites
You have authorizations to access the relevant debit memo requests.

Structure
Object Types This view relates to the following SAP object type: Debit memo request The key fields are DebitMemoRequest and PartnerFunction . Measures and attributes Some important measures and attributes are: Partner function ( PartnerFunction ) Customer ( Customer ) Address ( AddressId )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-SLS-CMR
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about partners in debit memo requests at header level.</p> <p>Example business questions could include the following:</p> <ul> <li><p>Which partner functions exist for a given debit memo request?</p></li> <li><p>What is the partner address of a given debit memo request?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPartner Partner from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Debit Memo Request Partner view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IDMRPARTNER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 (34)

KeyFieldSource TableSource FieldDescription
KEY DebitMemoRequest Debit Memo Request
KEY PartnerFunction PartnerFunction Partner Function
Customer Customer Customer Number
Supplier Supplier Account Number of Supplier
Personnel Personnel Personnel Number
ContactPerson ContactPerson Number of Contact Person
Partner Partner Customer Number
FullName FullName Full Name of Person
ReferenceBusinessPartner ReferenceBusinessPartner Business Partner Number
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
SDDocPartnerAddressRefType SDDocPartnerAddressRefType Address indicator
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Determination in Document
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
VATRegistration VATRegistration VAT Registration Number
UnloadingPointName UnloadingPointName Unloading Point Name
CorrespondenceLanguage CorrespondenceLanguage Language
FormOfAddress FormOfAddress Form-of-Address Key
InternationalPhoneNumber InternationalPhoneNumber Complete Number: Dialing Code+Number+Extension
InternationalMobilePhoneNumber InternationalMobilePhoneNumber Complete Number: Dialing Code+Number+Extension
InternationalFaxNumber InternationalFaxNumber Complete Number: Dialing Code+Number+Extension
EmailAddress EmailAddress E-Mail Address
_DebitMemoRequest _DebitMemoRequest
_ContactPerson _ContactPerson
_PartnerFunction _PartnerFunction
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr
_PersonAddress _PersonAddress
_PersonName _PersonName
_OrganizationAddress _OrganizationAddress
_OrgNamePostalAddress _OrgNamePostalAddress

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_DebitMemoReqPartner.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_DebitMemoReqPartner AS
SELECT
  cast(SalesDocument as debit_memo_request preserving type) AS DebitMemoRequest,
  PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  ContactPerson,
  Partner,
  FullName,
  ReferenceBusinessPartner,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  UnloadingPointName,
  CorrespondenceLanguage,
  FormOfAddress,
  InternationalPhoneNumber,
  InternationalMobilePhoneNumber,
  InternationalFaxNumber,
  EmailAddress
FROM I_SalesDocumentPartner AS Partner
;

Learn More