ESH_N_CREDITMEMOREQUEST

Anchor view -CREDITMEMOREQUEST | view: ESH_L_CRDTMEMREQ | TRAN | Extraction: Not supported | Component: Sales

Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, ADCP, ADRC, KNA1, TVTW, TVTWT, TSPA, TSPAT, MARA, MAKT, TVAK, TVAKT, TVKO, TVKOT, TVAU, TVAUT, USR21, TVBST, TVBST, TVBST, TVBST

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical (4)
Other (17)
🔗 Relations (8)

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	TEXT40
BUSINESSPARTNERNAME2	Name 2	TEXT40
CREATEDBYUSER	Name of Person Responsible for Creating the Object	USNAM
CREDITMEMOREQUESTITEMTEXT	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
TOTALCREDITCHECKSTATUSDESC	Status Description	TEXT20
USERDESCRIPTION	User Description	SUIDTECHDESC

Master Data Relations	Join Conditions
Order type in order header Sales Document Type Client	`ESH_N_CREDITMEMOREQUEST.CREDITMEMOREQUESTTYPE == TVAK.AUART` `ESH_N_CREDITMEMOREQUEST.MANDT == TVAK.MANDT`
Distribution channel in order header Client Sales Organization Distribution Channel	`ESH_N_CREDITMEMOREQUEST.MANDT == TVKOV.MANDT` `ESH_N_CREDITMEMOREQUEST.SALESORGANIZATION == TVKOV.VKORG` `ESH_N_CREDITMEMOREQUEST.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Material: order item Material Number Client	`ESH_N_CREDITMEMOREQUEST.MATERIAL == MARA.MATNR` `ESH_N_CREDITMEMOREQUEST.MANDT == MARA.MANDT`
Division in order header Division Client Sales Organization Distribution Channel	`ESH_N_CREDITMEMOREQUEST.ORGANIZATIONDIVISION == TVTA.SPART` `ESH_N_CREDITMEMOREQUEST.MANDT == TVTA.MANDT` `ESH_N_CREDITMEMOREQUEST.SALESORGANIZATION == TVTA.VKORG` `ESH_N_CREDITMEMOREQUEST.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Sales organization in order header Client Sales Organization	`ESH_N_CREDITMEMOREQUEST.MANDT == TVKO.MANDT` `ESH_N_CREDITMEMOREQUEST.SALESORGANIZATION == TVKO.VKORG`
Order Reason (Reason for the Business Transaction) Order Reason (Reason for the Business Transaction) Client	`ESH_N_CREDITMEMOREQUEST.SDDOCUMENTREASON == TVAU.AUGRU` `ESH_N_CREDITMEMOREQUEST.MANDT == TVAU.MANDT`
Sold-to Party Sold-to Party Client	`ESH_N_CREDITMEMOREQUEST.SOLDTOPARTY == KNA1.KUNNR` `ESH_N_CREDITMEMOREQUEST.MANDT == KNA1.MANDT`
Currency in order header SD Document Currency Client	`ESH_N_CREDITMEMOREQUEST.TRANSACTIONCURRENCY == TCURC.WAERS` `ESH_N_CREDITMEMOREQUEST.MANDT == TCURC.MANDT`