C_MstrProjDebtMemoRequest

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