C_CreditMemoRequestWl_F1989

Credit Memo Requests | view: CCREDITMRWLF1989 | TRAN | Extraction: Not supported | Component: Sales

Tables used: VBKD, VEDA, VBAK, VBPA, ADCP, ADRC, ADR6, ADR3, ADRP, ADR2, CVI_CUST_CT_LINK, BUT0ID, BUT000, KNVK, KNA1, CVI_CUST_LINK, CVI_VEND_LINK, MOM052

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (4)
☰ Categorical (3)
Other (12)
🔗 Relations (10)

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
BillingDocumentDate	Billing Date
CreditMemoRequestDate	Document Date (Date Received/Sent)
CreationDate	Date on which the record was created
LastChangeDate	Last Changed On

Column Name	Description
OverallSDProcessStatus	Overall Processing Status (Header/All Items)	Show values
OverallSDDocumentRejectionSts	Rejection Status (All Items)	Show values
SalesDocApprovalStatus	Document Approval Status	Show values

Column Name	Description	Domain name
CustomerName	Full Name of Person	TEXT80
PurchaseOrderByCustomer	Customer Reference	BSTKD
OverallOrdReltdBillgStatus	Order-Related Billing Status (All Items)
OverallBillingBlockStatus	Billing Block Status (All Items)
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
LastChangedByUser	User Who Last Changed the Business Document	USNAM
LastChangeDateTime	Last Changed Date Time	TZNTSTMPL
ReferenceSDDocument	Document number of the reference document	VBELN
SalesDocumentRjcnReason	Reason for Rejection of Sales Documents	ABGRU_VA
CrdtMemoReqApprvlStsCritlty	null
OrganizationBPName1	Name 1	NAME
OrganizationBPName2	Name 2	NAME

Master Data Relations	Join Conditions
Order type in order header Sales Document Type Client	`C_CREDITMEMOREQUESTWL_F1989.CREDITMEMOREQUESTTYPE == TVAK.AUART` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVAK.MANDT`
Distribution channel in order header Sales Organization Distribution Channel Client	`C_CREDITMEMOREQUESTWL_F1989.SALESORGANIZATION == TVKOV.VKORG` `C_CREDITMEMOREQUESTWL_F1989.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVKOV.MANDT`
Billing Block in SD Document Billing Block in SD Document Client	`C_CREDITMEMOREQUESTWL_F1989.HEADERBILLINGBLOCKREASON == TVFS.FAKSP` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVFS.MANDT`
Division in order header Sales Organization Distribution Channel Division Client	`C_CREDITMEMOREQUESTWL_F1989.SALESORGANIZATION == TVTA.VKORG` `C_CREDITMEMOREQUESTWL_F1989.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_CREDITMEMOREQUESTWL_F1989.ORGANIZATIONDIVISION == TVTA.SPART` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVTA.MANDT`
Sales group Sales office Client Sales group	`C_CREDITMEMOREQUESTWL_F1989.SALESOFFICE == TVBVK.VKBUR` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVBVK.MANDT` `C_CREDITMEMOREQUESTWL_F1989.SALESGROUP == TVBVK.VKGRP`
Sales organization in order header Sales Organization Client	`C_CREDITMEMOREQUESTWL_F1989.SALESORGANIZATION == TVKO.VKORG` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVKO.MANDT`
Order Reason (Reason for the Business Transaction) Order Reason (Reason for the Business Transaction) Client	`C_CREDITMEMOREQUESTWL_F1989.SDDOCUMENTREASON == TVAU.AUGRU` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVAU.MANDT`
Sold-to Party Sold-to Party Client	`C_CREDITMEMOREQUESTWL_F1989.SOLDTOPARTY == KNA1.KUNNR` `C_CREDITMEMOREQUESTWL_F1989.MANDT == KNA1.MANDT`
Currency in order header SD Document Currency Client	`C_CREDITMEMOREQUESTWL_F1989.TRANSACTIONCURRENCY == TCURC.WAERS` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TCURC.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Sales Organization Distribution Channel Division Sales office Client	`C_CREDITMEMOREQUESTWL_F1989.SALESORGANIZATION == TVKBZ.VKORG` `C_CREDITMEMOREQUESTWL_F1989.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `C_CREDITMEMOREQUESTWL_F1989.ORGANIZATIONDIVISION == TVKBZ.SPART` `C_CREDITMEMOREQUESTWL_F1989.SALESOFFICE == TVKBZ.VKBUR` `C_CREDITMEMOREQUESTWL_F1989.MANDT == TVKBZ.MANDT`