I_MPDebitMemoRequest

DDL: I_MPDEBITMEMOREQUEST SQL: IMPDEBITMEMOREQ Type: view COMPOSITE

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.

1 data source(s) 17 fields

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
ReferenceSDDocumentItem I_DebitMemoRequestItem ReferenceSDDocumentItem
Material I_DebitMemoRequestItem Material
BaseUnit I_DebitMemoRequestItem BaseUnit
SDProcessStatus I_DebitMemoRequestItem SDProcessStatus
DebitMemoRequestType _DebitMemoRequest DebitMemoRequestType
OrganizationDivision _DebitMemoRequest OrganizationDivision
DistributionChannel _DebitMemoRequest DistributionChannel
SalesOrganization _DebitMemoRequest SalesOrganization
SoldToParty _DebitMemoRequest SoldToParty
CreationDate I_DebitMemoRequestItem CreationDate
NetAmount I_DebitMemoRequestItem NetAmount
TransactionCurrency I_DebitMemoRequestItem TransactionCurrency
_DebitMemoRequest _DebitMemoRequest
_SDProcessStatus _SDProcessStatus
_SalesDocumentItem _SalesDocumentItem 
@AbapCatalog.sqlViewName: 'IMPDEBITMEMOREQ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Debit Memo Request'

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_DebitMemoRequestItem'

define view I_MPDebitMemoRequest as select from I_DebitMemoRequestItem as DebitMemoRequestItem
  association[1..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.ReferenceSDDocument = _SalesDocumentItem.SalesDocument
                                                                and $projection.ReferenceSDDocumentItem = _SalesDocumentItem.SalesDocumentItem
 {
    key DebitMemoRequestItem.DebitMemoRequest,
        DebitMemoRequestItem.ReferenceSDDocument,
        DebitMemoRequestItem.ReferenceSDDocumentItem,
        DebitMemoRequestItem.Material,
         unit_conversion(  quantity => DebitMemoRequestItem.TargetQuantity,
                         source_unit => DebitMemoRequestItem.TargetQuantityUnit,
                         target_unit => DebitMemoRequestItem.BaseUnit,
                         error_handling => 'SET_TO_NULL' )
                         as TargetQuantity,
    //    DebitMemoRequestItem.TargetQuantity as TargetQuantity,

        DebitMemoRequestItem.BaseUnit,
        DebitMemoRequestItem.SDProcessStatus,
        _DebitMemoRequest.DebitMemoRequestType,
        _DebitMemoRequest.OrganizationDivision,
        _DebitMemoRequest.DistributionChannel,
        _DebitMemoRequest.SalesOrganization,
        _DebitMemoRequest.SoldToParty,
        DebitMemoRequestItem.CreationDate,
        DebitMemoRequestItem.NetAmount as NetAmount,
        DebitMemoRequestItem.TransactionCurrency,
        _DebitMemoRequest,
        _SDProcessStatus,
        _SalesDocumentItem
        
        }
        where DebitMemoRequestItem.ReferenceSDDocumentCategory = 'C'
           or DebitMemoRequestItem.ReferenceSDDocumentCategory = 'G'
 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEBITMEMOREQUEST",
"I_DEBITMEMOREQUESTITEM"
],
"ASSOCIATED":
[
"I_DEBITMEMOREQUEST",
"I_SALESDOCUMENTITEM",
"I_SDPROCESSSTATUS"
],
"BASE":
[
"I_DEBITMEMOREQUESTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More