I_CustomerReturnEnhanced

Customer Return Enhanced | view: ISDCRENHANCED | ATTR | Extraction: Not supported | Component: Customer Returns
Tables used: MSR_D_HEAD, MSR_D_ITEM, VBKD, VEDA, VBAK, MSR_D_FIN_STATUS, MSR_D_FIN_DETAIL, MSR_D_LOG_STATUS, MSR_D_PLANNED
Column Name Description
CustomerReturn Customer Return
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
CustomerReturnDate Document Date (Date Received/Sent)
ServicesRenderedDate Date on which services are rendered
CustomerPurchaseOrderDate Customer Reference Date
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
ExchangeRateDate Translation date
Column Name Description
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
ReturnsDocumentType Document Type Show values
RetsMgmtLogProcgStatus Logistical Processing Status of a Return Show values
RetsMgmtCompnProcgStatus Status of Returns Refund Determination Show values
RetsMgmtProcessingStatus Processing Status Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
MaxDocValueCreditCheckStatus Status of Credit Check Against Maximum Document Value Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
ExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
SenderBusinessSystemName External Business System ID SLD_BSKEY
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
CustomerReturnCondition Number of the Document Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
CostCenter Cost Center KOSTL
ReferenceSDDocument Document number of the reference document VBELN
RetsMgmtProcess Process Identification Number MSR_PROCESS_ID
ReturnsDocument Document Number MSR_DOC_NR
CustomerTaxClassification1 Alternative Tax Classification TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_CUSTOMERRETURNENHANCED.MANDT == TVV1.MANDT
  • I_CUSTOMERRETURNENHANCED.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_CUSTOMERRETURNENHANCED.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_CUSTOMERRETURNENHANCED.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • I_CUSTOMERRETURNENHANCED.MANDT == TVV3.MANDT
  • I_CUSTOMERRETURNENHANCED.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • I_CUSTOMERRETURNENHANCED.MANDT == TVV4.MANDT
  • I_CUSTOMERRETURNENHANCED.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • I_CUSTOMERRETURNENHANCED.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_CUSTOMERRETURNENHANCED.MANDT == TVV5.MANDT
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_CUSTOMERRETURNENHANCED.MANDT == T001.MANDT
  • I_CUSTOMERRETURNENHANCED.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Client
  • Business Area
  • I_CUSTOMERRETURNENHANCED.MANDT == TGSB.MANDT
  • I_CUSTOMERRETURNENHANCED.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Client
  • I_CUSTOMERRETURNENHANCED.CONTROLLINGAREA == TKA01.KOKRS
  • I_CUSTOMERRETURNENHANCED.MANDT == TKA01.MANDT
Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • I_CUSTOMERRETURNENHANCED.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • I_CUSTOMERRETURNENHANCED.MANDT == TGSB.MANDT
Credit control area
  • Credit control area
  • Client
  • I_CUSTOMERRETURNENHANCED.CREDITCONTROLAREA == T014.KKBER
  • I_CUSTOMERRETURNENHANCED.MANDT == T014.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_CUSTOMERRETURNENHANCED.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_CUSTOMERRETURNENHANCED.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • I_CUSTOMERRETURNENHANCED.CUSTOMERGROUP == T151.KDGRP
  • I_CUSTOMERRETURNENHANCED.MANDT == T151.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_CUSTOMERRETURNENHANCED.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_CUSTOMERRETURNENHANCED.MANDT == T176.MANDT
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • I_CUSTOMERRETURNENHANCED.CUSTOMERRETURNAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • I_CUSTOMERRETURNENHANCED.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Customer Return Type
  • Client
  • I_CUSTOMERRETURNENHANCED.CUSTOMERRETURNTYPE == TVAK.AUART
  • I_CUSTOMERRETURNENHANCED.MANDT == TVAK.MANDT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_CUSTOMERRETURNENHANCED.MANDT == TVLS.MANDT
  • I_CUSTOMERRETURNENHANCED.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_CUSTOMERRETURNENHANCED.SALESORGANIZATION == TVKOV.VKORG
  • I_CUSTOMERRETURNENHANCED.MANDT == TVKOV.MANDT
  • I_CUSTOMERRETURNENHANCED.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • I_CUSTOMERRETURNENHANCED.MANDT == TCURV.MANDT
  • I_CUSTOMERRETURNENHANCED.EXCHANGERATETYPE == TCURV.KURST
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_CUSTOMERRETURNENHANCED.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_CUSTOMERRETURNENHANCED.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_CUSTOMERRETURNENHANCED.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_CUSTOMERRETURNENHANCED.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_CUSTOMERRETURNENHANCED.INCOTERMSVERSION == TINCV.INCOV
  • I_CUSTOMERRETURNENHANCED.MANDT == TINCV.MANDT
Order Number
  • Client
  • Order Number
  • I_CUSTOMERRETURNENHANCED.MANDT == AUFK.MANDT
  • I_CUSTOMERRETURNENHANCED.ORDERID == AUFK.AUFNR
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • I_CUSTOMERRETURNENHANCED.ORGANIZATIONDIVISION == TVTA.SPART
  • I_CUSTOMERRETURNENHANCED.SALESORGANIZATION == TVTA.VKORG
  • I_CUSTOMERRETURNENHANCED.MANDT == TVTA.MANDT
  • I_CUSTOMERRETURNENHANCED.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Payment Method
  • Client
  • Payment Method
  • ?
  • I_CUSTOMERRETURNENHANCED.MANDT == T042Z.MANDT
  • I_CUSTOMERRETURNENHANCED.PAYMENTMETHOD == T042Z.ZLSCH
  • I_CUSTOMERRETURNENHANCED.[column in domain "LAND1"] == T042Z.LAND1
Sales District
  • Client
  • Sales District
  • I_CUSTOMERRETURNENHANCED.MANDT == T171.MANDT
  • I_CUSTOMERRETURNENHANCED.SALESDISTRICT == T171.BZIRK
Sales group
  • Sales group
  • Client
  • Sales office
  • I_CUSTOMERRETURNENHANCED.SALESGROUP == TVBVK.VKGRP
  • I_CUSTOMERRETURNENHANCED.MANDT == TVBVK.MANDT
  • I_CUSTOMERRETURNENHANCED.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Sales Organization
  • Client
  • I_CUSTOMERRETURNENHANCED.SALESORGANIZATION == TVKO.VKORG
  • I_CUSTOMERRETURNENHANCED.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_CUSTOMERRETURNENHANCED.SDDOCUMENTREASON == TVAU.AUGRU
  • I_CUSTOMERRETURNENHANCED.MANDT == TVAU.MANDT
Shipping Type
  • Client
  • Shipping Type
  • I_CUSTOMERRETURNENHANCED.MANDT == T173.MANDT
  • I_CUSTOMERRETURNENHANCED.SHIPPINGTYPE == T173.VSART
Sold-to Party
  • Sold-to Party
  • Client
  • I_CUSTOMERRETURNENHANCED.SOLDTOPARTY == KNA1.KUNNR
  • I_CUSTOMERRETURNENHANCED.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • I_CUSTOMERRETURNENHANCED.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CUSTOMERRETURNENHANCED.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • Sales office
  • I_CUSTOMERRETURNENHANCED.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_CUSTOMERRETURNENHANCED.SALESORGANIZATION == TVKBZ.VKORG
  • I_CUSTOMERRETURNENHANCED.MANDT == TVKBZ.MANDT
  • I_CUSTOMERRETURNENHANCED.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_CUSTOMERRETURNENHANCED.SALESOFFICE == TVKBZ.VKBUR