ESH_S_CREDITMEMOREQUEST

Search view -CREDITMEMOREQUEST | view: ESH_U_CRDTMEMREQ | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAADCPADRCKNA1TVTWTVTWTTSPATSPATMARAMAKTTVAKTVAKTTVKOTVKOTTVAUTVAUTUSR21TVBSTTVBSTTVBSTTVBST
Column Name Description
CREDITMEMOREQUEST Credit 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
CREDITMEMOREQUESTDATE 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
TOTALCREDITCHECKSTATUS Overall Status of Credit Checks Show values
Column Name Description Domain name
BUSINESSPARTNERNAME1 Name 1
BUSINESSPARTNERNAME2 Name 2
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
CREDITMEMOREQUESTITEMTEXT Short text for sales order item TEXT40
DISTRIBUTIONCHANNELNAME Distribution Channel Description
DIVISIONNAME Division Description
MATERIALBYCUSTOMER Material Number Used by Customer IDNEX
MATERIALNAME Material Description
OVERALLORDRELTDBILLGSTSDESC Status Description
OVERALLSDPROCESSSTATUSDESC Status Description
OVRLSDDOCUMENTREJECTIONSTSDESC Status Description
PURCHASEORDERBYCUSTOMER Customer Reference BSTKD
SALESDOCUMENTTYPENAME Sales Document Type Description
SALESORGANIZATIONNAME Sales Organization Description
SDDOCUMENTREASONTEXT Description
TOTALCREDITCHECKSTATUSDESC Status Description
USERDESCRIPTION User Description
Master Data Relations Join Conditions
Order type in order header
  • Sales Document Type
  • Client
  • ESH_S_CREDITMEMOREQUEST.CREDITMEMOREQUESTTYPE == TVAK.AUART
  • ESH_S_CREDITMEMOREQUEST.MANDT == TVAK.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • ESH_S_CREDITMEMOREQUEST.SALESORGANIZATION == TVKOV.VKORG
  • ESH_S_CREDITMEMOREQUEST.MANDT == TVKOV.MANDT
  • ESH_S_CREDITMEMOREQUEST.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Material Number
  • Client
  • ESH_S_CREDITMEMOREQUEST.MATERIAL == MARA.MATNR
  • ESH_S_CREDITMEMOREQUEST.MANDT == MARA.MANDT
Division in order header
  • Sales Organization
  • Client
  • Division
  • Distribution Channel
  • ESH_S_CREDITMEMOREQUEST.SALESORGANIZATION == TVTA.VKORG
  • ESH_S_CREDITMEMOREQUEST.MANDT == TVTA.MANDT
  • ESH_S_CREDITMEMOREQUEST.ORGANIZATIONDIVISION == TVTA.SPART
  • ESH_S_CREDITMEMOREQUEST.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales organization in order header
  • Sales Organization
  • Client
  • ESH_S_CREDITMEMOREQUEST.SALESORGANIZATION == TVKO.VKORG
  • ESH_S_CREDITMEMOREQUEST.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • ESH_S_CREDITMEMOREQUEST.MANDT == TVAU.MANDT
  • ESH_S_CREDITMEMOREQUEST.SDDOCUMENTREASON == TVAU.AUGRU
Sold-to Party
  • Client
  • Sold-to Party
  • ESH_S_CREDITMEMOREQUEST.MANDT == KNA1.MANDT
  • ESH_S_CREDITMEMOREQUEST.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • ESH_S_CREDITMEMOREQUEST.MANDT == TCURC.MANDT
  • ESH_S_CREDITMEMOREQUEST.TRANSACTIONCURRENCY == TCURC.WAERS