I_MstrProjDebtMemoRequestCube

DDL: I_MSTRPROJDEBTMEMOREQUESTCUBE SQL: IMPDMRCUBE Type: view COMPOSITE
26 Fields 1 Data Sources 4 Associations

Master Project Debit Memo Request Cube

I_MstrProjDebtMemoRequestCube is a Composite CDS View (Cube) that provides data about "Master Project Debit Memo Request Cube" in SAP S/4HANA. It reads from 1 data source (I_MstrProjDebtMemoRequest) and exposes 26 fields with key fields MasterProject, DebitMemoRequest, Material, SalesDocument, SalesDocumentItem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MstrProjDebtMemoRequest DebitMemoRequest from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MasterProjectVH _MasterProject $projection.MasterProject = _MasterProject.MasterProject
[0..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..1] I_Currency _Currency $projection.TransactionCurrency = _Currency.Currency
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.TargetQuantityUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPDMRCUBE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Master Project Debit Memo Request Cube 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
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MstrProjDebtMemoRequest MasterProject Project ID
KEY DebitMemoRequest I_MstrProjDebtMemoRequest DebitMemoRequest
KEY Material I_MstrProjDebtMemoRequest Material Vehicle Model
KEY SalesDocument I_MstrProjDebtMemoRequest SalesDocument SD Document
KEY SalesDocumentItem I_MstrProjDebtMemoRequest SalesDocumentItem Sales Document Item
ControllingObjectExternalID WBS Element
CreationDate
MasterProjectName I_MstrProjDebtMemoRequest MasterProjectName
MaterialName
TargetQuantity I_MstrProjDebtMemoRequest TargetQuantity Target Quantity
TargetQuantityUnit I_MstrProjDebtMemoRequest TargetQuantityUnit Target Qty UoM
SDProcessStatus I_MstrProjDebtMemoRequest SDProcessStatus
SDProcessStatusDesc
SoldToParty I_MstrProjDebtMemoRequest SoldToParty Sold-to Party
CustomerName
NetAmount I_MstrProjDebtMemoRequest NetAmount Stated Amount
TransactionCurrency I_MstrProjDebtMemoRequest TransactionCurrency Transaction Currency
DebitMemoRequestType I_MstrProjDebtMemoRequest DebitMemoRequestType
DistributionChannel I_MstrProjDebtMemoRequest DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_MstrProjDebtMemoRequest OrganizationDivision Org. Division
SalesOrganization I_MstrProjDebtMemoRequest SalesOrganization Sales Organization
_MasterProject _MasterProject
_SalesDocument _SalesDocument
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_Customer I_MstrProjDebtMemoRequest _Customer

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_MstrProjDebtMemoRequestCube.
-- 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: IMPDMRCUBE

CREATE VIEW I_MstrProjDebtMemoRequestCube AS
SELECT
  DebitMemoRequest.MasterProject AS MasterProject,
  DebitMemoRequest.DebitMemoRequest AS DebitMemoRequest,
  DebitMemoRequest.Material AS Material,
  DebitMemoRequest.SalesDocument AS SalesDocument,
  DebitMemoRequest.SalesDocumentItem AS SalesDocumentItem,
  cast(ControllingObjectExternalID as /cpd/cpm_struct_elm) AS ControllingObjectExternalID,
  cast( DebitMemoRequest.CreationDate as /cpd/cpm_creationdate ) AS CreationDate,
  DebitMemoRequest.MasterProjectName AS MasterProjectName,
  DebitMemoRequest._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  DebitMemoRequest.TargetQuantity AS TargetQuantity,
  DebitMemoRequest.TargetQuantityUnit AS TargetQuantityUnit,
  DebitMemoRequest.SDProcessStatus AS SDProcessStatus,
  cast(DebitMemoRequest._SDProcessStatus._Text[1:Language = $session.system_language].SDProcessStatusDesc as bezei) AS SDProcessStatusDesc,
  DebitMemoRequest.SoldToParty AS SoldToParty,
  DebitMemoRequest._Customer.CustomerName AS CustomerName,
  DebitMemoRequest.NetAmount AS NetAmount,
  DebitMemoRequest.TransactionCurrency AS TransactionCurrency,
  DebitMemoRequest.DebitMemoRequestType AS DebitMemoRequestType,
  DebitMemoRequest.DistributionChannel AS DistributionChannel,
  DebitMemoRequest.OrganizationDivision AS OrganizationDivision,
  DebitMemoRequest.SalesOrganization AS SalesOrganization,
  DebitMemoRequest._Customer AS _Customer
FROM I_MstrProjDebtMemoRequest AS DebitMemoRequest
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON TargetQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More