ESH_N_DEBITMEMOREQUEST

Anchor view -DEBITMEMOREQUEST | view: ESH_L_DBTMEMREQ | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAADCPADRCKNA1TVTWTVTWTTSPATSPATMARAMAKTTVAKTVAKTTVKOTVKOTTVAUTVAUTUSR21TVBSTTVBSTTVBST
Column Name Description
DEBITMEMOREQUEST Debit Memo Request
Column Name Description
💲 SD Document Currency (TRANSACTIONCURRENCY):
TOTALNETAMOUNT Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
DEBITMEMOREQUESTDATE Document Date (Date Received/Sent)
Column Name Description
OVERALLORDRELTDBILLGSTATUS Order-Related Billing Status (All Items) Show values
OVERALLSDDOCUMENTREJECTIONSTS Rejection Status (All Items) Show values
OVERALLSDPROCESSSTATUS Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
BUSINESSPARTNERNAME1 Name 1 TEXT40
BUSINESSPARTNERNAME2 Name 2 TEXT40
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DEBITMEMOREQUESTITEMTEXT Short text for sales order item TEXT40
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
DIVISIONNAME Division Description TEXT20
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALNAME Material Description TEXT40
OVERALLORDRELTDBILLGSTSDESC Status Description TEXT20
OVERALLSDPROCESSSTATUSDESC Status Description TEXT20
OVRLSDDOCUMENTREJECTIONSTSDESC Status Description TEXT20
PURCHASEORDERBYCUSTOMER Customer Reference BSTKD
SALESDOCUMENTTYPENAME Sales Document Type Description TEXT20
SALESORGANIZATIONNAME Sales Organization Description TEXT20
SDDOCUMENTREASONTEXT Description TEXT40
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Order type in order header
  • Client
  • Sales Document Type
  • ESH_N_DEBITMEMOREQUEST.MANDT == TVAK.MANDT
  • ESH_N_DEBITMEMOREQUEST.DEBITMEMOREQUESTTYPE == TVAK.AUART
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • ESH_N_DEBITMEMOREQUEST.SALESORGANIZATION == TVKOV.VKORG
  • ESH_N_DEBITMEMOREQUEST.MANDT == TVKOV.MANDT
  • ESH_N_DEBITMEMOREQUEST.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Client
  • Material Number
  • ESH_N_DEBITMEMOREQUEST.MANDT == MARA.MANDT
  • ESH_N_DEBITMEMOREQUEST.MATERIAL == MARA.MATNR
Division in order header
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • ESH_N_DEBITMEMOREQUEST.SALESORGANIZATION == TVTA.VKORG
  • ESH_N_DEBITMEMOREQUEST.ORGANIZATIONDIVISION == TVTA.SPART
  • ESH_N_DEBITMEMOREQUEST.MANDT == TVTA.MANDT
  • ESH_N_DEBITMEMOREQUEST.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales organization in order header
  • Sales Organization
  • Client
  • ESH_N_DEBITMEMOREQUEST.SALESORGANIZATION == TVKO.VKORG
  • ESH_N_DEBITMEMOREQUEST.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • ESH_N_DEBITMEMOREQUEST.SDDOCUMENTREASON == TVAU.AUGRU
  • ESH_N_DEBITMEMOREQUEST.MANDT == TVAU.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • ESH_N_DEBITMEMOREQUEST.SOLDTOPARTY == KNA1.KUNNR
  • ESH_N_DEBITMEMOREQUEST.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • ESH_N_DEBITMEMOREQUEST.MANDT == TCURC.MANDT
  • ESH_N_DEBITMEMOREQUEST.TRANSACTIONCURRENCY == TCURC.WAERS