Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_DebitMemoRequestItem instead. View all deprecated CDS views →

I_MPDebitMemoRequest

DDL: I_MPDEBITMEMOREQUEST SQL: IMPDEBITMEMOREQ Type: view COMPOSITE
17 Fields 1 Data Sources

Master Project Debit Memo Request

I_MPDebitMemoRequest is a Composite CDS View that provides data about "Master Project Debit Memo Request" in SAP S/4HANA. It reads from 1 data source (I_DebitMemoRequestItem) and exposes 17 fields with key field DebitMemoRequest.

Data Sources (1)

SourceAliasJoin Type
I_DebitMemoRequestItem DebitMemoRequestItem from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMPDEBITMEMOREQ view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Project Debit Memo Request view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_DebitMemoRequestItem view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY DebitMemoRequest I_DebitMemoRequestItem DebitMemoRequest
ReferenceSDDocument I_DebitMemoRequestItem ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem I_DebitMemoRequestItem ReferenceSDDocumentItem Reference Item
Material I_DebitMemoRequestItem Material Vehicle Model
BaseUnit I_DebitMemoRequestItem BaseUnit Unit of Measure
SDProcessStatus I_DebitMemoRequestItem SDProcessStatus
DebitMemoRequestType _DebitMemoRequest DebitMemoRequestType Sales Doc. Type
OrganizationDivision _DebitMemoRequest OrganizationDivision Org. Division
DistributionChannel _DebitMemoRequest DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization _DebitMemoRequest SalesOrganization Sales Organization
SoldToParty _DebitMemoRequest SoldToParty Sold-to Party
CreationDate I_DebitMemoRequestItem CreationDate Time Stamp
NetAmount I_DebitMemoRequestItem NetAmount Stated Amount
TransactionCurrency I_DebitMemoRequestItem TransactionCurrency Transaction Currency
_DebitMemoRequest _DebitMemoRequest
_SDProcessStatus _SDProcessStatus
_SalesDocumentItem _SalesDocumentItem

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_MPDebitMemoRequest.
-- 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.
-- SQL view name: IMPDEBITMEMOREQ

CREATE VIEW I_MPDebitMemoRequest AS
SELECT
  DebitMemoRequestItem.DebitMemoRequest AS DebitMemoRequest,
  DebitMemoRequestItem.ReferenceSDDocument AS ReferenceSDDocument,
  DebitMemoRequestItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  DebitMemoRequestItem.Material AS Material,
  DebitMemoRequestItem.BaseUnit AS BaseUnit,
  DebitMemoRequestItem.SDProcessStatus AS SDProcessStatus,
  _DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  _DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  _DebitMemoRequest.DistributionChannel AS DistributionChannel,
  _DebitMemoRequest.SalesOrganization AS SalesOrganization,
  _DebitMemoRequest.SoldToParty AS SoldToParty,
  DebitMemoRequestItem.CreationDate AS CreationDate,
  DebitMemoRequestItem.NetAmount AS NetAmount,
  DebitMemoRequestItem.TransactionCurrency AS TransactionCurrency
FROM I_DebitMemoRequestItem AS DebitMemoRequestItem
;

Learn More