I_DebitMemoRequestItemCube

Debit Memo Request Item - Cube | view: ISDDEBMEMREQITMC | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, TVKO
Column Name Description
DebitMemoRequest FK Debit Memo Request
DebitMemoRequestItem Debit Memo Request Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TaxAmount Tax Amount in Document Currency
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
NetAmount Net Value of Sales Order Item in Transaction Currency
DebitMemoRequestNetAmount Net Amount of Debit Memo Request Items
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Value in Display Currency
DebitMemoRequestNetAmtInDC Net Amount of Debit Memo Request Items in Display Currency
Column Name Description
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
📏 Base Unit of Measure (BaseUnit):
DebitMemoRequestQuantity Quantity of Debit Memo Request Items
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
CustomerPurchaseOrderDate Customer Reference Date
Column Name Description
DebitMemoRequestItemType Item Type Show values
ItemIsBillingRelevant Relevant for Billing Show values
SDProcessStatus Overall Processing Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
Column Name Description Domain name
DebitMemoRequestType Sales Document Type AUART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesGroup Sales group VKGRP
SalesOffice Sales office VKBUR
SoldToParty Sold-to Party KUNNR
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
DebitMemoRequestItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
Plant Plant (Own or External) WERKS
CustomerPaymentTerms Terms of payment key ZTERM
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
NumberOfDebitMemoRequestItems Number of Items in Debit Memo Requests
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T006.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T001.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Client
  • Business Area
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == TGSB.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.BUSINESSAREA == TGSB.GSBER
Customer Group
  • Client
  • Customer Group
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T151.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Sales document item category
  • Client
  • Sales document item category
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == TVPT.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.DEBITMEMOREQUESTITEMCATEGORY == TVPT.PSTYV
Division
  • Client
  • Division
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == TSPA.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.DIVISION == TSPA.SPART
Billing Block Reason for Item
  • Client
  • Billing Block Reason for Item
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == TVFS.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Volume unit
  • Client
  • Volume unit
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T006.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T006.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == MARA.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.MATERIAL == MARA.MATNR
  • I_DEBITMEMOREQUESTITEMCUBE.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Product Group
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T023.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_DEBITMEMOREQUESTITEMCUBE.PRODUCTGROUP == T023.MATKL
Payment Method
  • Client
  • ?
  • Payment Method
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T042Z.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.[column in domain "LAND1"] == T042Z.LAND1
  • I_DEBITMEMOREQUESTITEMCUBE.PAYMENTMETHOD == T042Z.ZLSCH
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == MARA.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.MATERIAL == MARA.MATNR
  • I_DEBITMEMOREQUESTITEMCUBE.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Material Group
  • Product Group
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == T023.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_DEBITMEMOREQUESTITEMCUBE.PRODUCTGROUP == T023.MATKL
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_DEBITMEMOREQUESTITEMCUBE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == TVAG.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_DEBITMEMOREQUESTITEMCUBE.MANDT == TCURC.MANDT
  • I_DEBITMEMOREQUESTITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS