I_MstrProjDebtMemoRequest

DDL: I_MSTRPROJDEBTMEMOREQUEST SQL: IMPDMREQ Type: view COMPOSITE
27 Fields 2 Data Sources 6 Associations

Master Project Debit Memo Request

I_MstrProjDebtMemoRequest is a Composite CDS View (Dimension) that provides data about "Master Project Debit Memo Request" in SAP S/4HANA. It reads from 2 data sources (I_MpDebitMemoRequestItem, I_MPStructureElement) and exposes 27 fields with key fields MasterProject, DebitMemoRequest, Material, SalesDocument, SalesDocumentItem. It has 6 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MpDebitMemoRequestItem DebitMemoRequest inner
I_MPStructureElement Hierarchy from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_SDProcessStatus _SDProcessStatus $projection.SDProcessStatus = _SDProcessStatus.SDProcessStatus
[0..1] I_Customer _Customer $projection.SoldToParty = _Customer.Customer
[0..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
[0..1] I_DebitMemoRequest _DebitMemoRequest $projection.DebitMemoRequest = _DebitMemoRequest.DebitMemoRequest

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMPDMREQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Master Project Debit Memo Request view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey MasterProject view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MPStructureElement MasterProject Project ID
KEY DebitMemoRequest I_MpDebitMemoRequestItem DebitMemoRequest
KEY Material I_MpDebitMemoRequestItem Material Vehicle Model
KEY SalesDocument I_MPStructureElement SalesDocument SD Document
KEY SalesDocumentItem I_MPStructureElement SalesDocumentItem Sales Document Item
MasterProjectName I_MPStructureElement MasterProjectName
MasterProjectType I_MPStructureElement MasterProjectType
MasterProjectIsConfidential I_MPStructureElement MasterProjectIsConfidential
MasterProjectOrganization I_MPStructureElement MasterProjectOrganization
TargetQuantity I_MpDebitMemoRequestItem TargetQuantity Target Quantity
TargetQuantityUnit I_MpDebitMemoRequestItem TargetQuantityUnit Target Qty UoM
DistributionChannel I_MpDebitMemoRequestItem DistributionChannel RefDistCh-Cust/Mat.
DebitMemoRequestType I_MpDebitMemoRequestItem DebitMemoRequestType
OrganizationDivision I_MpDebitMemoRequestItem OrganizationDivision Org. Division
SalesOrganization I_MpDebitMemoRequestItem SalesOrganization Sales Organization
ControllingObjectExternalID
SDProcessStatus I_MpDebitMemoRequestItem SDProcessStatus
SoldToParty I_MpDebitMemoRequestItem SoldToParty Sold-to Party
CreationDate
NetAmount
TransactionCurrency I_MpDebitMemoRequestItem TransactionCurrency Transaction Currency
_Material _Material
_SDProcessStatus _SDProcessStatus
_Customer _Customer
_DebitMemoRequest _DebitMemoRequest
_SalesDocument _SalesDocument
_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_MstrProjDebtMemoRequest.
-- 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: IMPDMREQ

CREATE VIEW I_MstrProjDebtMemoRequest AS
SELECT
  Hierarchy.MasterProject AS MasterProject,
  DebitMemoRequest.DebitMemoRequest AS DebitMemoRequest,
  DebitMemoRequest.Material AS Material,
  Hierarchy.SalesDocument AS SalesDocument,
  Hierarchy.SalesDocumentItem AS SalesDocumentItem,
  Hierarchy.MasterProjectName AS MasterProjectName,
  Hierarchy.MasterProjectType AS MasterProjectType,
  Hierarchy.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  Hierarchy.MasterProjectOrganization AS MasterProjectOrganization,
  DebitMemoRequest.TargetQuantity AS TargetQuantity,
  DebitMemoRequest.TargetQuantityUnit AS TargetQuantityUnit,
  DebitMemoRequest.DistributionChannel AS DistributionChannel,
  DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  DebitMemoRequest.SalesOrganization AS SalesOrganization,
  cast(Hierarchy.ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  DebitMemoRequest.SDProcessStatus AS SDProcessStatus,
  DebitMemoRequest.SoldToParty AS SoldToParty,
  cast( DebitMemoRequest.CreationDate as /cpd/cpm_creationdate ) AS CreationDate,
  cast( DebitMemoRequest.NetAmount as /cpd/cpm_netamount ) AS NetAmount,
  DebitMemoRequest.TransactionCurrency AS TransactionCurrency
FROM I_MPStructureElement AS Hierarchy
INNER JOIN I_MpDebitMemoRequestItem AS DebitMemoRequest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_SDProcessStatus AS _SDProcessStatus ON SDProcessStatus = _SDProcessStatus.SDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_DebitMemoRequest AS _DebitMemoRequest ON DebitMemoRequest = _DebitMemoRequest.DebitMemoRequest  -- association [0..1]
;

Learn More