I_MstrProjDebtMemoRequestCube

Column Name Description
MasterProject Commercial Project ID
DebitMemoRequest FK Debit Memo Request
Material FK Material Number
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Master project Net Amount
Column Name Description
📏 Base Unit of Measure (TargetQuantityUnit):
TargetQuantity null
Column Name Description
CreationDate Master Project Invoice Creation Date
Column Name Description
SDProcessStatus Overall Processing Status (Item) Show values
Column Name Description Domain name
ControllingObjectExternalID Master Project Structure Element CHAR34
MasterProjectName Project Name /CPD/SHORT_TEXT
MaterialName Material Description TEXT40
SDProcessStatusDesc Name of the controlling area TEXT25
CustomerName Name of Customer TEXT80
Master Data Relations Join Conditions
Order type in order header
  • Sales Document Type
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.DEBITMEMOREQUESTTYPE == TVAK.AUART
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == TVAK.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.SALESORGANIZATION == TVKOV.VKORG
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == TVKOV.MANDT
Material: order item
  • Client
  • Material Number
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == MARA.MANDT
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MATERIAL == MARA.MATNR
Division in order header
  • Distribution Channel
  • Sales Organization
  • Division
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.SALESORGANIZATION == TVTA.VKORG
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.ORGANIZATIONDIVISION == TVTA.SPART
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == TVTA.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.SOLDTOPARTY == KNA1.KUNNR
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == KNA1.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.TARGETQUANTITYUNIT == T006.MSEHI
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == T006.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MSTRPROJDEBTMEMOREQUESTCUBE.MANDT == TCURC.MANDT